1#Want to skip this test from daily Valgrind execution 2--source include/no_valgrind_without_big.inc 3 4--disable_warnings 5DROP TABLE IF EXISTS t1,t2; 6--enable_warnings 7CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 8CREATE TABLE t2(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 9--source suite/engines/funcs/t/data1.inc 10--source suite/engines/funcs/t/data2.inc 11SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 12SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 13SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 14SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 15SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 16SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 17SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 18DROP TABLE t1,t2; 19CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 20CREATE TABLE t2(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 21--source suite/engines/funcs/t/data1.inc 22--source suite/engines/funcs/t/data2.inc 23SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 24SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 25SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 26SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 27SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 28SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 29SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 30DROP TABLE t1,t2; 31CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 32CREATE TABLE t2(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 33--source suite/engines/funcs/t/data1.inc 34--source suite/engines/funcs/t/data2.inc 35SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 36SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 37SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 38SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 39SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 40SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 41SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 42DROP TABLE t1,t2; 43CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 44CREATE TABLE t2(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 45--source suite/engines/funcs/t/data1.inc 46--source suite/engines/funcs/t/data2.inc 47SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 48SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 49SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 50SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 51SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 52SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 53SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 54DROP TABLE t1,t2; 55CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 56CREATE TABLE t2(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 57--source suite/engines/funcs/t/data1.inc 58--source suite/engines/funcs/t/data2.inc 59SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 60SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 61SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 62SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 63SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 64SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 65SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 66DROP TABLE t1,t2; 67CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 68CREATE TABLE t2(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 69--source suite/engines/funcs/t/data1.inc 70--source suite/engines/funcs/t/data2.inc 71SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 72SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 73SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 74SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 75SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 76SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 77SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 78DROP TABLE t1,t2; 79CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 80CREATE TABLE t2(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 81--source suite/engines/funcs/t/data1.inc 82--source suite/engines/funcs/t/data2.inc 83SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 84SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 85SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 86SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 87SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 88SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 89SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 90DROP TABLE t1,t2; 91CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 92CREATE TABLE t2(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 93--source suite/engines/funcs/t/data1.inc 94--source suite/engines/funcs/t/data2.inc 95SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 96SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 97SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 98SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 99SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 100SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 101SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 102DROP TABLE t1,t2; 103CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 104CREATE TABLE t2(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 105--source suite/engines/funcs/t/data1.inc 106--source suite/engines/funcs/t/data2.inc 107SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 108SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 109SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 110SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 111SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 112SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 113SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 114DROP TABLE t1,t2; 115CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 116CREATE TABLE t2(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 117--source suite/engines/funcs/t/data1.inc 118--source suite/engines/funcs/t/data2.inc 119SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 120SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 121SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 122SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 123SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 124SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 125SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 126DROP TABLE t1,t2; 127CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 128CREATE TABLE t2(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 129--source suite/engines/funcs/t/data1.inc 130--source suite/engines/funcs/t/data2.inc 131SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 132SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 133SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 134SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 135SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 136SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 137SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 138DROP TABLE t1,t2; 139CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 140CREATE TABLE t2(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 141--source suite/engines/funcs/t/data1.inc 142--source suite/engines/funcs/t/data2.inc 143SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 144SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 145SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 146SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 147SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 148SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 149SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 150DROP TABLE t1,t2; 151CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 152CREATE TABLE t2(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 153--source suite/engines/funcs/t/data1.inc 154--source suite/engines/funcs/t/data2.inc 155SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 156SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 157SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 158SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 159SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 160SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 161SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 162DROP TABLE t1,t2; 163CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 164CREATE TABLE t2(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 165--source suite/engines/funcs/t/data1.inc 166--source suite/engines/funcs/t/data2.inc 167SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 168SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 169SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 170SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 171SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 172SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 173SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 174DROP TABLE t1,t2; 175CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 176CREATE TABLE t2(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 177--source suite/engines/funcs/t/data1.inc 178--source suite/engines/funcs/t/data2.inc 179SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 180SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 181SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 182SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 183SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 184SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 185SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 186DROP TABLE t1,t2; 187CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 188CREATE TABLE t2(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 189--source suite/engines/funcs/t/data1.inc 190--source suite/engines/funcs/t/data2.inc 191SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 192SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 193SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 194SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 195SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 196SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 197SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 198DROP TABLE t1,t2; 199CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 200CREATE TABLE t2(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 201--source suite/engines/funcs/t/data1.inc 202--source suite/engines/funcs/t/data2.inc 203SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 204SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 205SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 206SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 207SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 208SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 209SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 210DROP TABLE t1,t2; 211CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 212CREATE TABLE t2(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 213--source suite/engines/funcs/t/data1.inc 214--source suite/engines/funcs/t/data2.inc 215SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 216SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 217SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 218SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 219SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 220SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 221SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 222DROP TABLE t1,t2; 223CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 224CREATE TABLE t2(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 225--source suite/engines/funcs/t/data1.inc 226--source suite/engines/funcs/t/data2.inc 227SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 228SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 229SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 230SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 231SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 232SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 233SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 234DROP TABLE t1,t2; 235CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 236CREATE TABLE t2(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 237--source suite/engines/funcs/t/data1.inc 238--source suite/engines/funcs/t/data2.inc 239SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 240SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 241SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 242SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 243SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 244SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 245SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 246DROP TABLE t1,t2; 247CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 248CREATE TABLE t2(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 249--source suite/engines/funcs/t/data1.inc 250--source suite/engines/funcs/t/data2.inc 251SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 252SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 253SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 254SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 255SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 256SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 257SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 258DROP TABLE t1,t2; 259CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 260CREATE TABLE t2(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 261--source suite/engines/funcs/t/data1.inc 262--source suite/engines/funcs/t/data2.inc 263SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 264SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 265SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 266SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 267SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 268SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 269SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 270DROP TABLE t1,t2; 271CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 272CREATE TABLE t2(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 273--source suite/engines/funcs/t/data1.inc 274--source suite/engines/funcs/t/data2.inc 275SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 276SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 277SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 278SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 279SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 280SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 281SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 282DROP TABLE t1,t2; 283CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 284CREATE TABLE t2(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 285--source suite/engines/funcs/t/data1.inc 286--source suite/engines/funcs/t/data2.inc 287SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 288SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 289SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 290SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 291SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 292SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 293SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 294DROP TABLE t1,t2; 295CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 296CREATE TABLE t2(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 297--source suite/engines/funcs/t/data1.inc 298--source suite/engines/funcs/t/data2.inc 299SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 300SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 301SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 302SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 303SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 304SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 305SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 306DROP TABLE t1,t2; 307CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 308CREATE TABLE t2(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 309--source suite/engines/funcs/t/data1.inc 310--source suite/engines/funcs/t/data2.inc 311SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 312SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 313SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 314SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 315SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 316SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 317SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 318DROP TABLE t1,t2; 319CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 320CREATE TABLE t2(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 321--source suite/engines/funcs/t/data1.inc 322--source suite/engines/funcs/t/data2.inc 323SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 324SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 325SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 326SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 327SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 328SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 329SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 330DROP TABLE t1,t2; 331CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 332CREATE TABLE t2(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 333--source suite/engines/funcs/t/data1.inc 334--source suite/engines/funcs/t/data2.inc 335SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 336SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 337SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 338SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 339SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 340SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 341SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 342DROP TABLE t1,t2; 343CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 344CREATE TABLE t2(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 345--source suite/engines/funcs/t/data1.inc 346--source suite/engines/funcs/t/data2.inc 347SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 348SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 349SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 350SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 351SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 352SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 353SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 354DROP TABLE t1,t2; 355CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 356CREATE TABLE t2(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 357--source suite/engines/funcs/t/data1.inc 358--source suite/engines/funcs/t/data2.inc 359SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 360SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 361SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 362SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 363SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 364SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 365SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 366DROP TABLE t1,t2; 367CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 368CREATE TABLE t2(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 369--source suite/engines/funcs/t/data1.inc 370--source suite/engines/funcs/t/data2.inc 371SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 372SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 373SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 374SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 375SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 376SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 377SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 378DROP TABLE t1,t2; 379CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 380CREATE TABLE t2(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 381--source suite/engines/funcs/t/data1.inc 382--source suite/engines/funcs/t/data2.inc 383SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 384SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 385SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 386SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 387SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 388SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 389SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 390DROP TABLE t1,t2; 391CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 392CREATE TABLE t2(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 393--source suite/engines/funcs/t/data1.inc 394--source suite/engines/funcs/t/data2.inc 395SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 396SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 397SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 398SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 399SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 400SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 401SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 402DROP TABLE t1,t2; 403CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 404CREATE TABLE t2(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 405--source suite/engines/funcs/t/data1.inc 406--source suite/engines/funcs/t/data2.inc 407SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 408SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 409SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 410SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 411SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 412SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 413SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 414DROP TABLE t1,t2; 415CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 416CREATE TABLE t2(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 417--source suite/engines/funcs/t/data1.inc 418--source suite/engines/funcs/t/data2.inc 419SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 420SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 421SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 422SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 423SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 424SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 425SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 426DROP TABLE t1,t2; 427CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 428CREATE TABLE t2(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 429--source suite/engines/funcs/t/data1.inc 430--source suite/engines/funcs/t/data2.inc 431SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 432SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 433SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 434SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 435SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 436SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 437SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 438DROP TABLE t1,t2; 439CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 440CREATE TABLE t2(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 441--source suite/engines/funcs/t/data1.inc 442--source suite/engines/funcs/t/data2.inc 443SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 444SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 445SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 446SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 447SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 448SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 449SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 450DROP TABLE t1,t2; 451CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 452CREATE TABLE t2(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 453--source suite/engines/funcs/t/data1.inc 454--source suite/engines/funcs/t/data2.inc 455SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 456SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 457SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 458SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 459SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 460SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 461SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 462DROP TABLE t1,t2; 463CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 464CREATE TABLE t2(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 465--source suite/engines/funcs/t/data1.inc 466--source suite/engines/funcs/t/data2.inc 467SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 468SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 469SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 470SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 471SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 472SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 473SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 474DROP TABLE t1,t2; 475CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 476CREATE TABLE t2(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 477--source suite/engines/funcs/t/data1.inc 478--source suite/engines/funcs/t/data2.inc 479SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 480SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 481SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 482SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 483SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 484SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 485SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 486DROP TABLE t1,t2; 487CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 488CREATE TABLE t2(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 489--source suite/engines/funcs/t/data1.inc 490--source suite/engines/funcs/t/data2.inc 491SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 492SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 493SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 494SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 495SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 496SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 497SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 498DROP TABLE t1,t2; 499CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 500CREATE TABLE t2(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 501--source suite/engines/funcs/t/data1.inc 502--source suite/engines/funcs/t/data2.inc 503SELECT c1 FROM t1 UNION SELECT c1 FROM t2; 504SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 505SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 506SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 507SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1='#C2' ; 508SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c1 !='#C2' ; 509SELECT c1 FROM t1 WHERE c1='#C2' UNION SELECT c2 FROM t1 WHERE c1='#C2' UNION SELECT c1 FROM t2 WHERE c2 ='#C2' ; 510DROP TABLE t1,t2; 511 512