← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/create.result

  • Committer: Brian Aker
  • Date: 2009-02-11 17:03:03 UTC
  • mfrom: (873.1.6 temporal-new)
  • Revision ID: brian@tangent.org-20090211170303-vd2ebowng4iozwtm
Merge Jay

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/create.result
390
390
create table t1(a int,b int,c int,d date,e char,f datetime,g time,h blob);
391
391
insert into t1(a)values(1);
392
392
insert into t1(a,b,c,d,e,f,g,h)
393
 
values(2,-2,2,'1825-12-14','a','2003-1-1 3:2:1','4:3:2','binary data');
 
393
values(2,-2,2,'1825-12-14','a','2003-01-01 03:02:01','4:3:2','binary data');
394
394
select * from t1;
395
395
a       b       c       d       e       f       g       h
396
396
1       NULL    NULL    NULL    NULL    NULL    NULL    NULL
1608
1608
CREATE TABLE t3(c1 DATETIME NOT NULL);
1609
1609
INSERT INTO t3 VALUES (0);
1610
1610
 
1611
 
ALTER TABLE t3 ADD INDEX(c1);
1612
1611
 
1613
1612
# -- Cleanup.
1614
1613
DROP TABLE t1;