← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/bool_type/t/primary_key.test

merged with up to date trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/bool_type/t/primary_key.test
 
1
CREATE TABLE t1 (A BOOLEAN, PRIMARY KEY (A));
 
2
insert into t1 VALUES ("no");
 
3
insert into t1 VALUES ("true");
 
4
 
 
5
--error ER_DUP_ENTRY_WITH_KEY_NAME,ER_DUP_ENTRY
 
6
insert into t1 VALUES ("true");
 
7
 
 
8
SELECT A from t1 ORDER BY a ASC;
 
9
SELECT A from t1 ORDER BY a DESC;
 
10
 
 
11
DROP TABLE t1;