~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/metadata.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:
26
26
 
27
27
CREATE TABLE t1 (id int(3) default NULL, data varchar(255) default NULL);
28
28
INSERT INTO t1 VALUES (1,'male'),(2,'female');
29
 
CREATE TABLE t2 (id int(3) unsigned default NULL, data char(3) default '0');
 
29
CREATE TABLE t2 (id int(3) default NULL, data char(3) default '0');
30
30
INSERT INTO t2 VALUES (1,'yes'),(2,'no');
31
31
 
32
32
select t1.id, t1.data, t2.data from t1, t2 where t1.id = t2.id;