← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/mysql_compatibility/t/bool.test

  • Committer: Olaf van der Spek
  • Date: 2011-02-28 14:09:50 UTC
  • mfrom: (2207 bootstrap)
  • mto: (2209.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 2210.
  • Revision ID: olafvdspek@gmail.com-20110228140950-2nu0hyzhuww3wssx
Merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/mysql_compatibility/t/bool.test
1
 
CREATE TABLE t1 (A BOOL, B VARCHAR(5));
2
 
SHOW CREATE TABLE t1;
3
 
 
4
 
INSERT INTO t1 VALUES (0, FALSE);
5
 
INSERT INTO t1 VALUES (1, TRUE);
6
 
INSERT INTO t1 VALUES (TRUE, TRUE);
7
 
INSERT INTO t1 VALUES (FALSE, FALSE);
8
 
--sorted_result
9
 
SELECT A,B FROM t1;
10
 
 
11
 
DROP TABLE t1;