devregression/t/mcs7523_partitionOptimization_aCreateViews.test

45 select locate('o_orderkey', trace) > 0 as o_orderkey_accessed;
46 select locate('o_custkey', trace) > 0 as o_custkey_accessed;
47 select locate('o_orderstatus', trace) > 0 as o_orderstatus_accessed;
48 select locate('o_totalprice', trace) > 0 as o_totalprice_accessed;
49 select locate('o_orderdate', trace) > 0 as o_orderdate_accessed;
50 select locate('o_orderpriority', trace) > 0 as o_orderpriority_accessed;
51 select locate('o_clerk', trace) > 0 as o_clerk_accessed;
52 select locate('o_shippriority', trace) > 0 as o_shippriority_accessed;
53 select locate('o_comment', trace) > 0 as o_comment_accessed;
57 select locate('l_orderkey', trace) > 0 as l_orderkey_accessed;
58 select locate('l_partkey', trace) > 0 as l_partkey_accessed;
59 select locate('l_suppkey', trace) > 0 as l_suppkey_accessed;
60 select locate('l_linenumber', trace) > 0 as l_linenumber_accessed;
61 select locate('l_quantity', trace) > 0 as l_quantity_accessed;
62 select locate('l_extendedprice', trace) > 0 as l_extendedprice_accessed;
63 select locate('l_discount', trace) > 0 as l_discount_accessed;
64 select locate('l_tax', trace) > 0 as l_tax_accessed;
65 select locate('l_returnflag', trace) > 0 as l_returnflag_accessed;
66 select locate('l_linestatus', trace) > 0 as l_linestatus_accessed;
67 select locate('l_shipdate', trace) > 0 as l_shipdate_accessed;
68 select locate('l_commitdate', trace) > 0 as l_commitdate_accessed;
69 select locate('l_receiptdate', trace) > 0 as l_receiptdate_accessed;
70 select locate('l_shipinstruct', trace) > 0 as l_shipinstruct_accessed;
71 select locate('l_shipmode', trace) > 0 as l_shipmode_accessed;
72 select locate('l_comment', trace) > 0 as l_comment_accessed;
76 select locate('c_custkey', trace) > 0 as c_custkey_accessed;
77 select locate('c_name', trace) > 0 as c_name_accessed;
78 select locate('c_address', trace) > 0 as c_address_accessed;
79 select locate('c_nationkey', trace) > 0 as c_nationkey_accessed;
80 select locate('c_phone', trace) > 0 as c_phone_accessed;
81 select locate('c_acctbal', trace) > 0 as c_acctbal_accessed;
82 select locate('c_mktsegment', trace) > 0 as c_mktsegment_accessed;
83 select locate('c_comment', trace) > 0 as c_comment_accessed;
87 select locate('p_partkey', trace) > 0 as p_partkey_accessed;
88 select locate('p_name', trace) > 0 as p_name_accessed;
89 select locate('p_mfgr', trace) > 0 as p_mfgr_accessed;
90 select locate('p_brand', trace) > 0 as p_brand_accessed;
91 select locate('p_type', trace) > 0 as p_type_accessed;
92 select locate('p_size', trace) > 0 as p_size_accessed;
93 select locate('p_container', trace) > 0 as p_container_accessed;
94 select locate('p_retailprice', trace) > 0 as p_retailprice_accessed;
95 select locate('p_comment', trace) > 0 as p_comment_accessed;
99 select locate('ps_partkey', trace) > 0 as ps_partkey_accessed;
100 select locate('ps_suppkey', trace) > 0 as ps_suppkey_accessed;
101 select locate('ps_availqty', trace) > 0 as ps_availqty_accessed;
102 select locate('ps_supplycost', trace) > 0 as ps_supplycost_accessed;
103 select locate('ps_comment', trace) > 0 as ps_comment_accessed;
107 select locate('s_suppkey', trace) > 0 as s_suppkey_accessed;
108 select locate('s_name', trace) > 0 as s_name_accessed;
109 select locate('s_address', trace) > 0 as s_address_accessed;
110 select locate('s_nationkey', trace) > 0 as s_nationkey_accessed;
111 select locate('s_phone', trace) > 0 as s_phone_accessed;
112 select locate('s_acctbal', trace) > 0 as s_acctbal_accessed;
113 select locate('s_comment', trace) > 0 as s_comment_accessed;
117 select locate('n_nationkey', trace) > 0 as n_nationkey_accessed;
118 select locate('n_name', trace) > 0 as n_name_accessed;
119 select locate('n_regionkey', trace) > 0 as n_regionkey_accessed;
120 select locate('n_comment', trace) > 0 as n_comment_accessed;
124 select locate('r_regionkey', trace) > 0 as r_regionkey_accessed;
125 select locate('r_name', trace) > 0 as r_name_accessed;
126 select locate('r_comment', trace) > 0 as r_comment_accessed;
131 select substr(@stats, locate('PartitionBlocksEliminated', @stats)+26, 999) into @temp;
132 select substr(@temp, 1, locate(';', @temp)-1) into @blocksEliminated;