← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/randgen_queries.test

  • Committer: Patrick Crews
  • Date: 2010-07-21 19:15:45 UTC
  • mto: (1666.2.1 build)
  • mto: This revision was merged to the branch mainline in revision 1667.
  • Revision ID: gleebix@gmail.com-20100721191545-c1kb88ml9x68hccx
Updated randgen_queries test to reflect use of YES/NO vs. TRUE/FALSE in I_S and D_D

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/randgen_queries.test
52
52
            WHEN table_type = 'FUNCTION' then 'function' 
53
53
       ELSE 'misc' END, 
54
54
       column_name,
55
 
       CASE WHEN IS_USED_IN_PRIMARY = 'TRUE' THEN 'primary' 
56
 
             WHEN IS_INDEXED = 'TRUE' THEN 'indexed' 
 
55
       CASE WHEN IS_USED_IN_PRIMARY = 'YES' THEN 'primary' 
 
56
             WHEN IS_INDEXED = 'YES' THEN 'indexed' 
57
57
       ELSE 'indexed' END 
58
58
       FROM data_dictionary.tables INNER JOIN
59
59
            data_dictionary.columns USING(table_schema, table_name) ORDER BY table_schema, table_name limit 20;
75
75
            WHEN table_type = 'FUNCTION' then 'function'
76
76
       ELSE 'misc' END,
77
77
       column_name,
78
 
       CASE WHEN IS_USED_IN_PRIMARY = 'TRUE' THEN 'primary'
79
 
             WHEN IS_INDEXED = 'TRUE' THEN 'indexed'
 
78
       CASE WHEN IS_USED_IN_PRIMARY = 'YES' THEN 'primary'
 
79
             WHEN IS_INDEXED = 'YES' THEN 'indexed'
80
80
       ELSE 'indexed' END
81
81
       FROM data_dictionary.tables INNER JOIN
82
82
            data_dictionary.columns USING(table_schema, table_name) WHERE table_schema NOT IN ('DATA_DICTIONARY','INFORMATION_SCHEMA')