mysql-test/include/index_merge_delete.inc

21 --let $query = FROM t1 WHERE key1=25 OR key4=10
23 --eval EXPLAIN DELETE $query
24 --eval SELECT COUNT(*) $query
25 --eval DELETE $query
26 --eval SELECT COUNT(*) $query
28 --let $query = FROM t1 WHERE key1=48 OR  key4=2 OR key6=3
30 --eval EXPLAIN DELETE $query
31 --eval SELECT COUNT(*) $query
32 --eval DELETE $query
33 --eval SELECT COUNT(*) $query
35 --let $query = FROM t1 WHERE key3=1025 OR key5 IS NULL
37 --eval EXPLAIN DELETE $query
38 --eval SELECT COUNT(*) $query
39 --eval DELETE $query
40 --eval SELECT COUNT(*) $query
42 --let $query = FROM t1 WHERE key3=45 OR key1=6 OR key6 IS NULL
44 --eval EXPLAIN DELETE $query
45 --eval SELECT COUNT(*) $query
46 --eval DELETE $query
47 --eval SELECT COUNT(*) $query
49 --let $query = FROM t1 WHERE (key4=42 AND key6 IS NOT NULL) OR (key1=4 AND key3=6)
51 --eval EXPLAIN DELETE $query
52 --eval SELECT COUNT(*) $query
53 --eval DELETE $query
54 --eval SELECT COUNT(*) $query
57 --let $query = FROM t1 WHERE (key4=42 AND key6=3) OR (key1=4 AND key3=6)
59 --eval EXPLAIN DELETE $query
60 --eval SELECT COUNT(*) $query
61 --eval DELETE $query
62 --eval SELECT COUNT(*) $query
65 --let $query = FROM t1 WHERE (key4=42 AND key6=3) OR (key1=4 AND key3=6) AND key5<>50
67 --eval EXPLAIN DELETE $query
68 --eval SELECT COUNT(*) $query
69 --eval DELETE $query
70 --eval SELECT COUNT(*) $query
72 --let $query = FROM t1 WHERE key1<2 OR key2<3
75 --eval EXPLAIN DELETE $query
76 --eval SELECT COUNT(*) $query
77 --eval DELETE $query
78 --eval SELECT COUNT(*) $query
80 --let $query = FROM t1 WHERE key1<5 OR key3<7
83 --eval EXPLAIN DELETE $query
84 --eval SELECT COUNT(*) $query
85 --eval DELETE $query
86 --eval SELECT COUNT(*) $query
89 --let $query = FROM t1 WHERE key2=10 OR key3=3 OR key4 IS NULL
91 --eval EXPLAIN DELETE $query
92 --eval SELECT COUNT(*) $query
93 --eval DELETE $query
94 --eval SELECT COUNT(*) $query
97 --let $query = FROM t1 WHERE key2=10 OR key3=3 OR key4 <=> null
99 --eval EXPLAIN DELETE $query
100 --eval SELECT COUNT(*) $query
101 --eval DELETE $query
102 --eval SELECT COUNT(*) $query
104 --let $query = FROM t1 WHERE (key1>30 AND key1<35) OR (key2>32 AND key2<40)
106 --eval EXPLAIN DELETE $query
107 --eval SELECT COUNT(*) $query
108 --eval DELETE $query
109 --eval SELECT COUNT(*) $query
111 --let $query = FROM t1 WHERE key1 BETWEEN 30 AND 35 OR key2 BETWEEN 32 AND 40
113 --eval EXPLAIN DELETE $query
114 --eval SELECT COUNT(*) $query
115 --eval DELETE $query
116 --eval SELECT COUNT(*) $query
118 --let $query = FROM t1 WHERE (key1>30 AND key1<35) OR (key2>32 AND key2<40) OR (key3>20 AND key3<45)
120 --eval EXPLAIN DELETE $query
121 --eval SELECT COUNT(*) $query
122 --eval DELETE $query
123 --eval SELECT COUNT(*) $query
125 --let $query = FROM t1 WHERE key1 BETWEEN 30 AND 35 OR key2 BETWEEN 32 AND 40 OR key3 BETWEEN 20 AN…
127 --eval EXPLAIN DELETE $query
128 --eval SELECT COUNT(*) $query
129 --eval DELETE $query
130 --eval SELECT COUNT(*) $query
133 --let $query = FROM t1 WHERE ((key3<4 OR key5<3) AND (key1<3 OR key2<3)) OR (((key3<5 AND key6<5) O…
135 --eval EXPLAIN DELETE $query
136 --eval SELECT COUNT(*) $query
137 --eval DELETE $query
138 --eval SELECT COUNT(*) $query
140 --let $query = FROM t1 WHERE (key4<42 AND key6 IS NOT NULL) OR (key1>4 AND key5 IS NULL) AND key2<>…
142 --eval EXPLAIN DELETE $query
143 --eval SELECT COUNT(*) $query
144 --eval DELETE $query
145 --eval SELECT COUNT(*) $query
147 --let $query = FROM t1 WHERE (key5 IN (15,70) OR key6 IN (15,70))
149 --eval EXPLAIN DELETE $query
150 --eval SELECT COUNT(*) $query
151 --eval DELETE $query
152 --eval SELECT COUNT(*) $query
157 --let $query = FROM t1 WHERE key1<2 OR key2<3 ORDER BY key1
159 --eval EXPLAIN DELETE $query
160 --eval SELECT COUNT(*) $query
161 --eval DELETE $query
162 --eval SELECT COUNT(*) $query
166 --let $query = FROM t1 USING t1 INNER JOIN t2 ON (t2.key1=t2.key1) WHERE t1.key1=3 OR t1.key2=4
168 --eval EXPLAIN DELETE $query
170 --eval DELETE $query
193 --let $query = FROM t2 WHERE EXISTS (SELECT * FROM t1 WHERE key1<5 OR key3<7)
195 --eval EXPLAIN DELETE $query
196 --eval SELECT COUNT(*) $query
197 --eval DELETE $query
198 --eval SELECT COUNT(*) $query
204 --let $query = FROM t1 WHERE key7 = 3 OR key8 = 4
206 --eval EXPLAIN DELETE $query
207 --eval SELECT COUNT(*) $query
208 --eval DELETE $query
209 --eval SELECT COUNT(*) $query