~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/regression/r/654219.result

edit

Show diffs side-by-side

added added

removed removed

Lines of Context:
21
21
);
22
22
SELECT CONSTRAINT_NAME,TABLE_NAME,COLUMN_NAME,ORDINAL_POSITION FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE;
23
23
CONSTRAINT_NAME TABLE_NAME      COLUMN_NAME     ORDINAL_POSITION
24
 
PRIMARY SYS_REPLICATION_LOG     ID      1
25
 
PRIMARY SYS_REPLICATION_LOG     SEGID   2
26
24
PRIMARY fore_key0       id      1
27
25
PRIMARY fore_key1       id      1
28
26
PRIMARY prim_key        id      1
50
48
SELECT CONSTRAINT_NAME,TABLE_NAME,COLUMN_NAME,ORDINAL_POSITION FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE;
51
49
CONSTRAINT_NAME TABLE_NAME      COLUMN_NAME     ORDINAL_POSITION
52
50
CO      t3      s2      1
53
 
PRIMARY SYS_REPLICATION_LOG     ID      1
54
 
PRIMARY SYS_REPLICATION_LOG     SEGID   2
55
51
PRIMARY t1      s3      1
56
52
DROP TABLE t3;
57
53
DROP TABLE t1;