~drizzle-trunk/drizzle/development

 

# bookkeeping query in Executor/Drizzle.pm in randgen - variant 1

# test of non-DATA_DICTIONARY / INFORMATION_SCHEMA tables

CREATE SCHEMA randgen_query_test;

USE randgen_query_test;

CREATE TABLE t1 (a INT);

            data_dictionary.columns USING(table_schema, table_name) WHERE table_schema NOT IN ('DATA_DICTIONARY','INFORMATION_SCHEMA')

       ORDER BY table_schema, table_name limit 20;

 

DROP SCHEMA randgen_query_test;

USE test;

# end bookkeeping test

--replace_column 1 ####.##.####

--sorted_result

select COUNT(*) from data_dictionary.tables;

DROP TABLE t1;