← 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: Brian Aker
  • Date: 2011-02-27 02:20:23 UTC
  • mfrom: (2198.6.15 drizzle-build)
  • Revision ID: brian@tangent.org-20110227022023-ycawb23rnf22ic1l
Add ANSI || operator, fixes CREATE TABLE for boolean types such that
TRUE/FALSE are not the options for default values. Removes BOOL mysql
compatible (since Monty fixed all bool to work for MySQL clients).

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;