~drizzle-developers/drizzle/elliott-release

« back to all changes in this revision

Viewing changes to tests/r/data_dictionary_like_info.result

  • Committer: Patrick Crews
  • Date: 2011-02-01 20:33:06 UTC
  • mfrom: (1845.2.288 drizzle)
  • Revision ID: gleebix@gmail.com-20110201203306-mwq2rk0it81tlwxh
Merged Trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
308
308
f5      NULL    NO
309
309
f6      10      NO
310
310
f7      NULL    NO
311
 
f8      2006-01-01 00:00:00     NO
 
311
f8      2006-01-01 00:00:00.000000      NO
312
312
show columns from t1;
313
313
Field   Type    Null    Default Default_is_NULL On_Update
314
314
f1      VARCHAR YES             YES     
318
318
f5      BIGINT  NO              NO      
319
319
f6      BIGINT  NO      10      NO      
320
320
f7      DATETIME        NO              NO      
321
 
f8      DATETIME        YES     2006-01-01 00:00:00     NO      
 
321
f8      DATETIME        YES     2006-01-01 00:00:00.000000      NO      
322
322
drop table t1;
323
323
SET max_heap_table_size = DEFAULT;
324
324
USE test;
326
326
SELECT SCHEMA_NAME FROM DATA_DICTIONARY.SCHEMAS
327
327
WHERE SCHEMA_NAME ='data_dictionary';
328
328
SCHEMA_NAME
329
 
data_dictionary
 
329
DATA_DICTIONARY
330
330
SELECT TABLE_COLLATION FROM DATA_DICTIONARY.TABLES
331
331
WHERE TABLE_SCHEMA='mysql' and TABLE_NAME= 'db';
332
332
TABLE_COLLATION