← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/information_schema.test

  • 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/t/information_schema.test
129
129
# with SELECT SUM() ... GROUP BY queries
130
130
#
131
131
SELECT table_schema, count(*) FROM information_schema.TABLES
132
 
WHERE table_name NOT LIKE 'ndb_%' AND table_name NOT LIKE 'falcon%' GROUP BY TABLE_SCHEMA;
 
132
WHERE table_name NOT LIKE 'ndb_%' AND 
 
133
table_name NOT LIKE 'falcon%' AND
 
134
table_name NOT LIKE 'MEMCACHED%'
 
135
GROUP BY TABLE_SCHEMA;
133
136
 
134
137
#
135
138
# Bug #9434 SHOW CREATE DATABASE information_schema;
258
261
                  c2.table_name = t.table_name AND
259
262
                  c2.column_name LIKE '%SCHEMA%'
260
263
        )
261
 
  AND t.table_name NOT LIKE 'falcon%';
 
264
  AND t.table_name NOT LIKE 'falcon%'
 
265
  AND t.table_name NOT LIKE 'MEMCACHED%';
262
266
SELECT t.table_name, c1.column_name
263
267
  FROM information_schema.tables t
264
268
       INNER JOIN
273
277
                  c2.table_name = t.table_name AND
274
278
                  c2.column_name LIKE '%SCHEMA%'
275
279
        )
276
 
  AND t.table_name NOT LIKE 'falcon%';
 
280
  AND t.table_name NOT LIKE 'falcon%'
 
281
  AND t.table_name NOT LIKE 'MEMCACHED%';
277
282
 
278
283
#
279
284
# Bug#21231: query with a simple non-correlated subquery over
311
316
on t.table_schema = c1.table_schema AND t.table_name = c1.table_name
312
317
where t.table_schema = 'information_schema' AND
313
318
      t.table_name not like 'falcon%' AND
 
319
      t.table_name not like 'MEMCACHED%' AND
314
320
        c1.ordinal_position =
315
321
        (select isnull(c2.column_type) -
316
322
         isnull(group_concat(c2.table_schema, '.', c2.table_name)) +
434
440
#
435
441
SELECT table_name, column_name
436
442
FROM information_schema.columns
 
443
WHERE table_name NOT LIKE 'MEMCACHED%'
437
444
ORDER BY table_name;
438
445
 
439
446
#
496
503
#
497
504
SELECT table_schema, table_name
498
505
FROM information_schema.tables
 
506
WHERE table_name NOT LIKE 'MEMCACHED%'
499
507
ORDER BY table_name;
500
508
 
501
509
#