← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/mysql_compatibility/r/bool.result

  • Committer: Stewart Smith
  • Date: 2011-03-03 07:00:26 UTC
  • mfrom: (2215 staging)
  • mto: (2241.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 2242.
  • Revision ID: stewart@flamingspork.com-20110303070026-0lqlcq74n566syro
merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/mysql_compatibility/r/bool.result
1
 
CREATE TABLE t1 (A BOOL, B VARCHAR(5));
2
 
SHOW CREATE TABLE t1;
3
 
Table   Create Table
4
 
t1      CREATE TABLE `t1` (
5
 
  `A` INT DEFAULT NULL,
6
 
  `B` VARCHAR(5) COLLATE utf8_general_ci DEFAULT NULL
7
 
) ENGINE=InnoDB COLLATE = utf8_general_ci
8
 
INSERT INTO t1 VALUES (0, FALSE);
9
 
INSERT INTO t1 VALUES (1, TRUE);
10
 
INSERT INTO t1 VALUES (TRUE, TRUE);
11
 
INSERT INTO t1 VALUES (FALSE, FALSE);
12
 
SELECT A,B FROM t1;
13
 
A       B
14
 
0       0
15
 
0       0
16
 
1       1
17
 
1       1
18
 
DROP TABLE t1;