← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/information_schema.result

  • Committer: Stewart Smith
  • Date: 2009-10-12 05:13:54 UTC
  • mfrom: (1178 staging)
  • mto: This revision was merged to the branch mainline in revision 1179.
  • Revision ID: stewart@flamingspork.com-20091012051354-2n7zpid9f67ddsa0
merge lp:drizzle/build

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/information_schema.result
120
120
x_double_precision      NULL    NULL
121
121
drop table t1;
122
122
SELECT table_schema, count(*) FROM information_schema.TABLES
123
 
WHERE table_name NOT LIKE 'ndb_%' AND table_name NOT LIKE 'falcon%' GROUP BY TABLE_SCHEMA;
 
123
WHERE table_name NOT LIKE 'ndb_%' AND 
 
124
table_name NOT LIKE 'falcon%' AND
 
125
table_name NOT LIKE 'MEMCACHED%'
 
126
GROUP BY TABLE_SCHEMA;
124
127
table_schema    count(*)
125
128
information_schema      23
126
129
show create database information_schema;
242
245
c2.table_name = t.table_name AND
243
246
c2.column_name LIKE '%SCHEMA%'
244
247
        )
245
 
AND t.table_name NOT LIKE 'falcon%';
 
248
AND t.table_name NOT LIKE 'falcon%'
 
249
  AND t.table_name NOT LIKE 'MEMCACHED%';
246
250
table_name      column_name
247
251
INNODB_TRX      trx_id
248
252
INNODB_LOCKS    lock_id
281
285
c2.table_name = t.table_name AND
282
286
c2.column_name LIKE '%SCHEMA%'
283
287
        )
284
 
AND t.table_name NOT LIKE 'falcon%';
 
288
AND t.table_name NOT LIKE 'falcon%'
 
289
  AND t.table_name NOT LIKE 'MEMCACHED%';
285
290
table_name      column_name
286
291
INNODB_TRX      trx_id
287
292
INNODB_LOCKS    lock_id
336
341
on t.table_schema = c1.table_schema AND t.table_name = c1.table_name
337
342
where t.table_schema = 'information_schema' AND
338
343
t.table_name not like 'falcon%' AND
 
344
t.table_name not like 'MEMCACHED%' AND
339
345
c1.ordinal_position =
340
346
(select isnull(c2.column_type) -
341
347
isnull(group_concat(c2.table_schema, '.', c2.table_name)) +
526
532
utf8_unicode_ci utf8
527
533
SELECT table_name, column_name
528
534
FROM information_schema.columns
 
535
WHERE table_name NOT LIKE 'MEMCACHED%'
529
536
ORDER BY table_name;
530
537
table_name      column_name
531
538
CHARACTER_SETS  MAXLEN
1039
1046
CONSTRAINT_CATALOG      CONSTRAINT_SCHEMA       CONSTRAINT_NAME TABLE_SCHEMA    TABLE_NAME      CONSTRAINT_TYPE
1040
1047
SELECT table_schema, table_name
1041
1048
FROM information_schema.tables
 
1049
WHERE table_name NOT LIKE 'MEMCACHED%'
1042
1050
ORDER BY table_name;
1043
1051
table_schema    table_name
1044
1052
information_schema      CHARACTER_SETS