1--disable_warnings 2DROP TABLE IF EXISTS t1; 3--enable_warnings 4CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 5--source suite/engines/funcs/t/data1.inc 6SELECT COUNT(*) FROM t1; 7SELECT COUNT(*) FROM t1 WHERE c2='a'; 8SELECT COUNT(*) FROM t1 WHERE c1='a'; 9DROP TABLE t1; 10CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 11--source suite/engines/funcs/t/data1.inc 12SELECT COUNT(*) FROM t1; 13SELECT COUNT(*) FROM t1 WHERE c2='b'; 14SELECT COUNT(*) FROM t1 WHERE c1='b'; 15DROP TABLE t1; 16CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 17--source suite/engines/funcs/t/data1.inc 18SELECT COUNT(*) FROM t1; 19SELECT COUNT(*) FROM t1 WHERE c2='c'; 20SELECT COUNT(*) FROM t1 WHERE c1='c'; 21DROP TABLE t1; 22CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 23--source suite/engines/funcs/t/data1.inc 24SELECT COUNT(*) FROM t1; 25SELECT COUNT(*) FROM t1 WHERE c2='d'; 26SELECT COUNT(*) FROM t1 WHERE c1='d'; 27DROP TABLE t1; 28CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 29--source suite/engines/funcs/t/data1.inc 30SELECT COUNT(*) FROM t1; 31SELECT COUNT(*) FROM t1 WHERE c2='e'; 32SELECT COUNT(*) FROM t1 WHERE c1='e'; 33DROP TABLE t1; 34CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 35--source suite/engines/funcs/t/data1.inc 36SELECT COUNT(*) FROM t1; 37SELECT COUNT(*) FROM t1 WHERE c2='f'; 38SELECT COUNT(*) FROM t1 WHERE c1='f'; 39DROP TABLE t1; 40CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 41--source suite/engines/funcs/t/data1.inc 42SELECT COUNT(*) FROM t1; 43SELECT COUNT(*) FROM t1 WHERE c2='y'; 44SELECT COUNT(*) FROM t1 WHERE c1='y'; 45DROP TABLE t1; 46CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 47--source suite/engines/funcs/t/data1.inc 48SELECT COUNT(*) FROM t1; 49SELECT COUNT(*) FROM t1 WHERE c2='a'; 50SELECT COUNT(*) FROM t1 WHERE c1='a'; 51DROP TABLE t1; 52CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 53--source suite/engines/funcs/t/data1.inc 54SELECT COUNT(*) FROM t1; 55SELECT COUNT(*) FROM t1 WHERE c2='b'; 56SELECT COUNT(*) FROM t1 WHERE c1='b'; 57DROP TABLE t1; 58CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 59--source suite/engines/funcs/t/data1.inc 60SELECT COUNT(*) FROM t1; 61SELECT COUNT(*) FROM t1 WHERE c2='c'; 62SELECT COUNT(*) FROM t1 WHERE c1='c'; 63DROP TABLE t1; 64CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 65--source suite/engines/funcs/t/data1.inc 66SELECT COUNT(*) FROM t1; 67SELECT COUNT(*) FROM t1 WHERE c2='d'; 68SELECT COUNT(*) FROM t1 WHERE c1='d'; 69DROP TABLE t1; 70CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 71--source suite/engines/funcs/t/data1.inc 72SELECT COUNT(*) FROM t1; 73SELECT COUNT(*) FROM t1 WHERE c2='e'; 74SELECT COUNT(*) FROM t1 WHERE c1='e'; 75DROP TABLE t1; 76CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 77--source suite/engines/funcs/t/data1.inc 78SELECT COUNT(*) FROM t1; 79SELECT COUNT(*) FROM t1 WHERE c2='f'; 80SELECT COUNT(*) FROM t1 WHERE c1='f'; 81DROP TABLE t1; 82CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 83--source suite/engines/funcs/t/data1.inc 84SELECT COUNT(*) FROM t1; 85SELECT COUNT(*) FROM t1 WHERE c2='y'; 86SELECT COUNT(*) FROM t1 WHERE c1='y'; 87DROP TABLE t1; 88CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 89--source suite/engines/funcs/t/data1.inc 90SELECT COUNT(*) FROM t1; 91SELECT COUNT(*) FROM t1 WHERE c2='a'; 92SELECT COUNT(*) FROM t1 WHERE c1='a'; 93DROP TABLE t1; 94CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 95--source suite/engines/funcs/t/data1.inc 96SELECT COUNT(*) FROM t1; 97SELECT COUNT(*) FROM t1 WHERE c2='b'; 98SELECT COUNT(*) FROM t1 WHERE c1='b'; 99DROP TABLE t1; 100CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 101--source suite/engines/funcs/t/data1.inc 102SELECT COUNT(*) FROM t1; 103SELECT COUNT(*) FROM t1 WHERE c2='c'; 104SELECT COUNT(*) FROM t1 WHERE c1='c'; 105DROP TABLE t1; 106CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 107--source suite/engines/funcs/t/data1.inc 108SELECT COUNT(*) FROM t1; 109SELECT COUNT(*) FROM t1 WHERE c2='d'; 110SELECT COUNT(*) FROM t1 WHERE c1='d'; 111DROP TABLE t1; 112CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 113--source suite/engines/funcs/t/data1.inc 114SELECT COUNT(*) FROM t1; 115SELECT COUNT(*) FROM t1 WHERE c2='e'; 116SELECT COUNT(*) FROM t1 WHERE c1='e'; 117DROP TABLE t1; 118CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 119--source suite/engines/funcs/t/data1.inc 120SELECT COUNT(*) FROM t1; 121SELECT COUNT(*) FROM t1 WHERE c2='f'; 122SELECT COUNT(*) FROM t1 WHERE c1='f'; 123DROP TABLE t1; 124CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 125--source suite/engines/funcs/t/data1.inc 126SELECT COUNT(*) FROM t1; 127SELECT COUNT(*) FROM t1 WHERE c2='y'; 128SELECT COUNT(*) FROM t1 WHERE c1='y'; 129DROP TABLE t1; 130CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 131--source suite/engines/funcs/t/data1.inc 132SELECT COUNT(*) FROM t1; 133SELECT COUNT(*) FROM t1 WHERE c2='a'; 134SELECT COUNT(*) FROM t1 WHERE c1='a'; 135DROP TABLE t1; 136CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 137--source suite/engines/funcs/t/data1.inc 138SELECT COUNT(*) FROM t1; 139SELECT COUNT(*) FROM t1 WHERE c2='b'; 140SELECT COUNT(*) FROM t1 WHERE c1='b'; 141DROP TABLE t1; 142CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 143--source suite/engines/funcs/t/data1.inc 144SELECT COUNT(*) FROM t1; 145SELECT COUNT(*) FROM t1 WHERE c2='c'; 146SELECT COUNT(*) FROM t1 WHERE c1='c'; 147DROP TABLE t1; 148CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 149--source suite/engines/funcs/t/data1.inc 150SELECT COUNT(*) FROM t1; 151SELECT COUNT(*) FROM t1 WHERE c2='d'; 152SELECT COUNT(*) FROM t1 WHERE c1='d'; 153DROP TABLE t1; 154CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 155--source suite/engines/funcs/t/data1.inc 156SELECT COUNT(*) FROM t1; 157SELECT COUNT(*) FROM t1 WHERE c2='e'; 158SELECT COUNT(*) FROM t1 WHERE c1='e'; 159DROP TABLE t1; 160CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 161--source suite/engines/funcs/t/data1.inc 162SELECT COUNT(*) FROM t1; 163SELECT COUNT(*) FROM t1 WHERE c2='f'; 164SELECT COUNT(*) FROM t1 WHERE c1='f'; 165DROP TABLE t1; 166CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 167--source suite/engines/funcs/t/data1.inc 168SELECT COUNT(*) FROM t1; 169SELECT COUNT(*) FROM t1 WHERE c2='y'; 170SELECT COUNT(*) FROM t1 WHERE c1='y'; 171DROP TABLE t1; 172CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 173--source suite/engines/funcs/t/data1.inc 174SELECT COUNT(*) FROM t1; 175SELECT COUNT(*) FROM t1 WHERE c2='a'; 176SELECT COUNT(*) FROM t1 WHERE c1='a'; 177DROP TABLE t1; 178CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 179--source suite/engines/funcs/t/data1.inc 180SELECT COUNT(*) FROM t1; 181SELECT COUNT(*) FROM t1 WHERE c2='b'; 182SELECT COUNT(*) FROM t1 WHERE c1='b'; 183DROP TABLE t1; 184CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 185--source suite/engines/funcs/t/data1.inc 186SELECT COUNT(*) FROM t1; 187SELECT COUNT(*) FROM t1 WHERE c2='c'; 188SELECT COUNT(*) FROM t1 WHERE c1='c'; 189DROP TABLE t1; 190CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 191--source suite/engines/funcs/t/data1.inc 192SELECT COUNT(*) FROM t1; 193SELECT COUNT(*) FROM t1 WHERE c2='d'; 194SELECT COUNT(*) FROM t1 WHERE c1='d'; 195DROP TABLE t1; 196CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 197--source suite/engines/funcs/t/data1.inc 198SELECT COUNT(*) FROM t1; 199SELECT COUNT(*) FROM t1 WHERE c2='e'; 200SELECT COUNT(*) FROM t1 WHERE c1='e'; 201DROP TABLE t1; 202CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 203--source suite/engines/funcs/t/data1.inc 204SELECT COUNT(*) FROM t1; 205SELECT COUNT(*) FROM t1 WHERE c2='f'; 206SELECT COUNT(*) FROM t1 WHERE c1='f'; 207DROP TABLE t1; 208CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 209--source suite/engines/funcs/t/data1.inc 210SELECT COUNT(*) FROM t1; 211SELECT COUNT(*) FROM t1 WHERE c2='y'; 212SELECT COUNT(*) FROM t1 WHERE c1='y'; 213DROP TABLE t1; 214CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 215--source suite/engines/funcs/t/data1.inc 216SELECT COUNT(*) FROM t1; 217SELECT COUNT(*) FROM t1 WHERE c2='a'; 218SELECT COUNT(*) FROM t1 WHERE c1='a'; 219DROP TABLE t1; 220CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 221--source suite/engines/funcs/t/data1.inc 222SELECT COUNT(*) FROM t1; 223SELECT COUNT(*) FROM t1 WHERE c2='b'; 224SELECT COUNT(*) FROM t1 WHERE c1='b'; 225DROP TABLE t1; 226CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 227--source suite/engines/funcs/t/data1.inc 228SELECT COUNT(*) FROM t1; 229SELECT COUNT(*) FROM t1 WHERE c2='c'; 230SELECT COUNT(*) FROM t1 WHERE c1='c'; 231DROP TABLE t1; 232CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 233--source suite/engines/funcs/t/data1.inc 234SELECT COUNT(*) FROM t1; 235SELECT COUNT(*) FROM t1 WHERE c2='d'; 236SELECT COUNT(*) FROM t1 WHERE c1='d'; 237DROP TABLE t1; 238CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 239--source suite/engines/funcs/t/data1.inc 240SELECT COUNT(*) FROM t1; 241SELECT COUNT(*) FROM t1 WHERE c2='e'; 242SELECT COUNT(*) FROM t1 WHERE c1='e'; 243DROP TABLE t1; 244CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 245--source suite/engines/funcs/t/data1.inc 246SELECT COUNT(*) FROM t1; 247SELECT COUNT(*) FROM t1 WHERE c2='f'; 248SELECT COUNT(*) FROM t1 WHERE c1='f'; 249DROP TABLE t1; 250CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 251--source suite/engines/funcs/t/data1.inc 252SELECT COUNT(*) FROM t1; 253SELECT COUNT(*) FROM t1 WHERE c2='y'; 254SELECT COUNT(*) FROM t1 WHERE c1='y'; 255DROP TABLE t1; 256 257