← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/data_dictionary_like_info.result

  • Committer: lbieber
  • Date: 2010-10-06 02:01:43 UTC
  • mfrom: (1814.1.1 build)
  • Revision ID: lbieber@orisndriz08-20101006020143-gho0wsmd346m02f9
Merge Brian - fix bug 654905 - DATA_DICTIONARY.TABLE.TYPE not returning BASE or VIEW (it reports the port type).

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/data_dictionary_like_info.result
66
66
select TABLE_TYPE from data_dictionary.tables where 
67
67
table_schema="data_dictionary" and table_name="COLUMNS";
68
68
TABLE_TYPE
69
 
FUNCTION
 
69
VIEW
70
70
select table_type from data_dictionary.tables
71
71
where table_schema="mysql" and table_name="user";
72
72
table_type
339
339
select * from `data_dictionary`.`INDEXES` where `TABLE_NAME` = NULL;
340
340
TABLE_SCHEMA    TABLE_NAME      INDEX_NAME      IS_USED_IN_PRIMARY      IS_UNIQUE       IS_NULLABLE     KEY_LENGTH      INDEX_TYPE      INDEX_COMMENT
341
341
select * from data_dictionary.schemas where schema_name = NULL;
342
 
SCHEMA_NAME     DEFAULT_COLLATION_NAME  SCHEMA_CREATION_TIME    SCHEMA_UPDATE_TIME
 
342
SCHEMA_NAME     DEFAULT_COLLATION_NAME  SCHEMA_CREATION_TIME    SCHEMA_UPDATE_TIME      SCHEMA_UUID     SCHEMA_VERSION
343
343
select * from data_dictionary.tables where table_schema = NULL;
344
 
TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE      ENGINE  ROW_FORMAT      TABLE_COLLATION TABLE_CREATION_TIME     TABLE_UPDATE_TIME       TABLE_COMMENT   AUTO_INCREMENT
 
344
TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE      TABLE_ARCHETYPE ENGINE  ROW_FORMAT      TABLE_COLLATION TABLE_CREATION_TIME     TABLE_UPDATE_TIME       TABLE_COMMENT   AUTO_INCREMENT  TABLE_UUID      TABLE_VERSION
345
345
select * from data_dictionary.tables where table_name = NULL;
346
 
TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE      ENGINE  ROW_FORMAT      TABLE_COLLATION TABLE_CREATION_TIME     TABLE_UPDATE_TIME       TABLE_COMMENT   AUTO_INCREMENT
 
346
TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE      TABLE_ARCHETYPE ENGINE  ROW_FORMAT      TABLE_COLLATION TABLE_CREATION_TIME     TABLE_UPDATE_TIME       TABLE_COMMENT   AUTO_INCREMENT  TABLE_UUID      TABLE_VERSION
347
347
#
348
348
# Test that the query is visible to self and others.
349
349
#