← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/subselect3.test

  • Committer: Brian Aker
  • Date: 2008-10-02 19:18:43 UTC
  • mto: (438.4.1 drizzle-clean-code)
  • mto: This revision was merged to the branch mainline in revision 435.
  • Revision ID: brian@tangent.org-20081002191843-tw3nnufik8qwf9rz
Removed UNSIGNED from parser.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/subselect3.test
579
579
CREATE TABLE t1 (a INT NOT NULL);
580
580
INSERT INTO t1 VALUES (1),(-1), (65),(66);
581
581
 
582
 
CREATE TABLE t2 (a INT UNSIGNED NOT NULL PRIMARY KEY);
 
582
CREATE TABLE t2 (a INT NOT NULL PRIMARY KEY);
583
583
INSERT INTO t2 VALUES (65),(66);
584
584
 
585
585
SELECT a FROM t1 WHERE a NOT IN (65,66);