1#Want to skip this test from daily Valgrind execution 2--source include/no_valgrind_without_big.inc 3--disable_warnings 4DROP TABLE IF EXISTS t1; 5--enable_warnings 6CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 7--source suite/engines/funcs/t/data1.inc 8SELECT * FROM t1 LIMIT 1; 9SELECT * FROM t1 WHERE c1='a' LIMIT 1; 10SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 1; 11DROP TABLE t1; 12CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 13--source suite/engines/funcs/t/data1.inc 14SELECT * FROM t1 LIMIT 1; 15SELECT * FROM t1 WHERE c1='b' LIMIT 1; 16SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 1; 17DROP TABLE t1; 18CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 19--source suite/engines/funcs/t/data1.inc 20SELECT * FROM t1 LIMIT 1; 21SELECT * FROM t1 WHERE c1='c' LIMIT 1; 22SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 1; 23DROP TABLE t1; 24CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 25--source suite/engines/funcs/t/data1.inc 26SELECT * FROM t1 LIMIT 1; 27SELECT * FROM t1 WHERE c1='d' LIMIT 1; 28SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 1; 29DROP TABLE t1; 30CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 31--source suite/engines/funcs/t/data1.inc 32SELECT * FROM t1 LIMIT 1; 33SELECT * FROM t1 WHERE c1='e' LIMIT 1; 34SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 1; 35DROP TABLE t1; 36CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 37--source suite/engines/funcs/t/data1.inc 38SELECT * FROM t1 LIMIT 1; 39SELECT * FROM t1 WHERE c1='f' LIMIT 1; 40SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 1; 41DROP TABLE t1; 42CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 43--source suite/engines/funcs/t/data1.inc 44SELECT * FROM t1 LIMIT 1; 45SELECT * FROM t1 WHERE c1='y' LIMIT 1; 46SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 1; 47DROP TABLE t1; 48CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 49--source suite/engines/funcs/t/data1.inc 50SELECT * FROM t1 LIMIT 1; 51SELECT * FROM t1 WHERE c1='a' LIMIT 1; 52SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 1; 53DROP TABLE t1; 54CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 55--source suite/engines/funcs/t/data1.inc 56SELECT * FROM t1 LIMIT 1; 57SELECT * FROM t1 WHERE c1='b' LIMIT 1; 58SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 1; 59DROP TABLE t1; 60CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 61--source suite/engines/funcs/t/data1.inc 62SELECT * FROM t1 LIMIT 1; 63SELECT * FROM t1 WHERE c1='c' LIMIT 1; 64SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 1; 65DROP TABLE t1; 66CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 67--source suite/engines/funcs/t/data1.inc 68SELECT * FROM t1 LIMIT 1; 69SELECT * FROM t1 WHERE c1='d' LIMIT 1; 70SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 1; 71DROP TABLE t1; 72CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 73--source suite/engines/funcs/t/data1.inc 74SELECT * FROM t1 LIMIT 1; 75SELECT * FROM t1 WHERE c1='e' LIMIT 1; 76SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 1; 77DROP TABLE t1; 78CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 79--source suite/engines/funcs/t/data1.inc 80SELECT * FROM t1 LIMIT 1; 81SELECT * FROM t1 WHERE c1='f' LIMIT 1; 82SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 1; 83DROP TABLE t1; 84CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 85--source suite/engines/funcs/t/data1.inc 86SELECT * FROM t1 LIMIT 1; 87SELECT * FROM t1 WHERE c1='y' LIMIT 1; 88SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 1; 89DROP TABLE t1; 90CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 91--source suite/engines/funcs/t/data1.inc 92SELECT * FROM t1 LIMIT 1; 93SELECT * FROM t1 WHERE c1='a' LIMIT 1; 94SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 1; 95DROP TABLE t1; 96CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 97--source suite/engines/funcs/t/data1.inc 98SELECT * FROM t1 LIMIT 1; 99SELECT * FROM t1 WHERE c1='b' LIMIT 1; 100SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 1; 101DROP TABLE t1; 102CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 103--source suite/engines/funcs/t/data1.inc 104SELECT * FROM t1 LIMIT 1; 105SELECT * FROM t1 WHERE c1='c' LIMIT 1; 106SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 1; 107DROP TABLE t1; 108CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 109--source suite/engines/funcs/t/data1.inc 110SELECT * FROM t1 LIMIT 1; 111SELECT * FROM t1 WHERE c1='d' LIMIT 1; 112SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 1; 113DROP TABLE t1; 114CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 115--source suite/engines/funcs/t/data1.inc 116SELECT * FROM t1 LIMIT 1; 117SELECT * FROM t1 WHERE c1='e' LIMIT 1; 118SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 1; 119DROP TABLE t1; 120CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 121--source suite/engines/funcs/t/data1.inc 122SELECT * FROM t1 LIMIT 1; 123SELECT * FROM t1 WHERE c1='f' LIMIT 1; 124SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 1; 125DROP TABLE t1; 126CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 127--source suite/engines/funcs/t/data1.inc 128SELECT * FROM t1 LIMIT 1; 129SELECT * FROM t1 WHERE c1='y' LIMIT 1; 130SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 1; 131DROP TABLE t1; 132CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 133--source suite/engines/funcs/t/data1.inc 134SELECT * FROM t1 LIMIT 1; 135SELECT * FROM t1 WHERE c1='a' LIMIT 1; 136SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 1; 137DROP TABLE t1; 138CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 139--source suite/engines/funcs/t/data1.inc 140SELECT * FROM t1 LIMIT 1; 141SELECT * FROM t1 WHERE c1='b' LIMIT 1; 142SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 1; 143DROP TABLE t1; 144CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 145--source suite/engines/funcs/t/data1.inc 146SELECT * FROM t1 LIMIT 1; 147SELECT * FROM t1 WHERE c1='c' LIMIT 1; 148SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 1; 149DROP TABLE t1; 150CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 151--source suite/engines/funcs/t/data1.inc 152SELECT * FROM t1 LIMIT 1; 153SELECT * FROM t1 WHERE c1='d' LIMIT 1; 154SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 1; 155DROP TABLE t1; 156CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 157--source suite/engines/funcs/t/data1.inc 158SELECT * FROM t1 LIMIT 1; 159SELECT * FROM t1 WHERE c1='e' LIMIT 1; 160SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 1; 161DROP TABLE t1; 162CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 163--source suite/engines/funcs/t/data1.inc 164SELECT * FROM t1 LIMIT 1; 165SELECT * FROM t1 WHERE c1='f' LIMIT 1; 166SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 1; 167DROP TABLE t1; 168CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 169--source suite/engines/funcs/t/data1.inc 170SELECT * FROM t1 LIMIT 1; 171SELECT * FROM t1 WHERE c1='y' LIMIT 1; 172SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 1; 173DROP TABLE t1; 174CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 175--source suite/engines/funcs/t/data1.inc 176SELECT * FROM t1 LIMIT 1; 177SELECT * FROM t1 WHERE c1='a' LIMIT 1; 178SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 1; 179DROP TABLE t1; 180CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 181--source suite/engines/funcs/t/data1.inc 182SELECT * FROM t1 LIMIT 1; 183SELECT * FROM t1 WHERE c1='b' LIMIT 1; 184SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 1; 185DROP TABLE t1; 186CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 187--source suite/engines/funcs/t/data1.inc 188SELECT * FROM t1 LIMIT 1; 189SELECT * FROM t1 WHERE c1='c' LIMIT 1; 190SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 1; 191DROP TABLE t1; 192CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 193--source suite/engines/funcs/t/data1.inc 194SELECT * FROM t1 LIMIT 1; 195SELECT * FROM t1 WHERE c1='d' LIMIT 1; 196SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 1; 197DROP TABLE t1; 198CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 199--source suite/engines/funcs/t/data1.inc 200SELECT * FROM t1 LIMIT 1; 201SELECT * FROM t1 WHERE c1='e' LIMIT 1; 202SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 1; 203DROP TABLE t1; 204CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 205--source suite/engines/funcs/t/data1.inc 206SELECT * FROM t1 LIMIT 1; 207SELECT * FROM t1 WHERE c1='f' LIMIT 1; 208SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 1; 209DROP TABLE t1; 210CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 211--source suite/engines/funcs/t/data1.inc 212SELECT * FROM t1 LIMIT 1; 213SELECT * FROM t1 WHERE c1='y' LIMIT 1; 214SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 1; 215DROP TABLE t1; 216CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 217--source suite/engines/funcs/t/data1.inc 218SELECT * FROM t1 LIMIT 1; 219SELECT * FROM t1 WHERE c1='a' LIMIT 1; 220SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 1; 221DROP TABLE t1; 222CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 223--source suite/engines/funcs/t/data1.inc 224SELECT * FROM t1 LIMIT 1; 225SELECT * FROM t1 WHERE c1='b' LIMIT 1; 226SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 1; 227DROP TABLE t1; 228CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 229--source suite/engines/funcs/t/data1.inc 230SELECT * FROM t1 LIMIT 1; 231SELECT * FROM t1 WHERE c1='c' LIMIT 1; 232SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 1; 233DROP TABLE t1; 234CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 235--source suite/engines/funcs/t/data1.inc 236SELECT * FROM t1 LIMIT 1; 237SELECT * FROM t1 WHERE c1='d' LIMIT 1; 238SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 1; 239DROP TABLE t1; 240CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 241--source suite/engines/funcs/t/data1.inc 242SELECT * FROM t1 LIMIT 1; 243SELECT * FROM t1 WHERE c1='e' LIMIT 1; 244SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 1; 245DROP TABLE t1; 246CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 247--source suite/engines/funcs/t/data1.inc 248SELECT * FROM t1 LIMIT 1; 249SELECT * FROM t1 WHERE c1='f' LIMIT 1; 250SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 1; 251DROP TABLE t1; 252CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 253--source suite/engines/funcs/t/data1.inc 254SELECT * FROM t1 LIMIT 1; 255SELECT * FROM t1 WHERE c1='y' LIMIT 1; 256SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 1; 257DROP TABLE t1; 258CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 259--source suite/engines/funcs/t/data1.inc 260SELECT * FROM t1 LIMIT 5; 261SELECT * FROM t1 WHERE c1='a' LIMIT 5; 262SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 5; 263DROP TABLE t1; 264CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 265--source suite/engines/funcs/t/data1.inc 266SELECT * FROM t1 LIMIT 5; 267SELECT * FROM t1 WHERE c1='b' LIMIT 5; 268SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 5; 269DROP TABLE t1; 270CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 271--source suite/engines/funcs/t/data1.inc 272SELECT * FROM t1 LIMIT 5; 273SELECT * FROM t1 WHERE c1='c' LIMIT 5; 274SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 5; 275DROP TABLE t1; 276CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 277--source suite/engines/funcs/t/data1.inc 278SELECT * FROM t1 LIMIT 5; 279SELECT * FROM t1 WHERE c1='d' LIMIT 5; 280SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 5; 281DROP TABLE t1; 282CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 283--source suite/engines/funcs/t/data1.inc 284SELECT * FROM t1 LIMIT 5; 285SELECT * FROM t1 WHERE c1='e' LIMIT 5; 286SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 5; 287DROP TABLE t1; 288CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 289--source suite/engines/funcs/t/data1.inc 290SELECT * FROM t1 LIMIT 5; 291SELECT * FROM t1 WHERE c1='f' LIMIT 5; 292SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 5; 293DROP TABLE t1; 294CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 295--source suite/engines/funcs/t/data1.inc 296SELECT * FROM t1 LIMIT 5; 297SELECT * FROM t1 WHERE c1='y' LIMIT 5; 298SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 5; 299DROP TABLE t1; 300CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 301--source suite/engines/funcs/t/data1.inc 302SELECT * FROM t1 LIMIT 5; 303SELECT * FROM t1 WHERE c1='a' LIMIT 5; 304SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 5; 305DROP TABLE t1; 306CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 307--source suite/engines/funcs/t/data1.inc 308SELECT * FROM t1 LIMIT 5; 309SELECT * FROM t1 WHERE c1='b' LIMIT 5; 310SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 5; 311DROP TABLE t1; 312CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 313--source suite/engines/funcs/t/data1.inc 314SELECT * FROM t1 LIMIT 5; 315SELECT * FROM t1 WHERE c1='c' LIMIT 5; 316SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 5; 317DROP TABLE t1; 318CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 319--source suite/engines/funcs/t/data1.inc 320SELECT * FROM t1 LIMIT 5; 321SELECT * FROM t1 WHERE c1='d' LIMIT 5; 322SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 5; 323DROP TABLE t1; 324CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 325--source suite/engines/funcs/t/data1.inc 326SELECT * FROM t1 LIMIT 5; 327SELECT * FROM t1 WHERE c1='e' LIMIT 5; 328SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 5; 329DROP TABLE t1; 330CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 331--source suite/engines/funcs/t/data1.inc 332SELECT * FROM t1 LIMIT 5; 333SELECT * FROM t1 WHERE c1='f' LIMIT 5; 334SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 5; 335DROP TABLE t1; 336CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 337--source suite/engines/funcs/t/data1.inc 338SELECT * FROM t1 LIMIT 5; 339SELECT * FROM t1 WHERE c1='y' LIMIT 5; 340SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 5; 341DROP TABLE t1; 342CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 343--source suite/engines/funcs/t/data1.inc 344SELECT * FROM t1 LIMIT 5; 345SELECT * FROM t1 WHERE c1='a' LIMIT 5; 346SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 5; 347DROP TABLE t1; 348CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 349--source suite/engines/funcs/t/data1.inc 350SELECT * FROM t1 LIMIT 5; 351SELECT * FROM t1 WHERE c1='b' LIMIT 5; 352SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 5; 353DROP TABLE t1; 354CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 355--source suite/engines/funcs/t/data1.inc 356SELECT * FROM t1 LIMIT 5; 357SELECT * FROM t1 WHERE c1='c' LIMIT 5; 358SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 5; 359DROP TABLE t1; 360CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 361--source suite/engines/funcs/t/data1.inc 362SELECT * FROM t1 LIMIT 5; 363SELECT * FROM t1 WHERE c1='d' LIMIT 5; 364SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 5; 365DROP TABLE t1; 366CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 367--source suite/engines/funcs/t/data1.inc 368SELECT * FROM t1 LIMIT 5; 369SELECT * FROM t1 WHERE c1='e' LIMIT 5; 370SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 5; 371DROP TABLE t1; 372CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 373--source suite/engines/funcs/t/data1.inc 374SELECT * FROM t1 LIMIT 5; 375SELECT * FROM t1 WHERE c1='f' LIMIT 5; 376SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 5; 377DROP TABLE t1; 378CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 379--source suite/engines/funcs/t/data1.inc 380SELECT * FROM t1 LIMIT 5; 381SELECT * FROM t1 WHERE c1='y' LIMIT 5; 382SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 5; 383DROP TABLE t1; 384CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 385--source suite/engines/funcs/t/data1.inc 386SELECT * FROM t1 LIMIT 5; 387SELECT * FROM t1 WHERE c1='a' LIMIT 5; 388SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 5; 389DROP TABLE t1; 390CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 391--source suite/engines/funcs/t/data1.inc 392SELECT * FROM t1 LIMIT 5; 393SELECT * FROM t1 WHERE c1='b' LIMIT 5; 394SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 5; 395DROP TABLE t1; 396CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 397--source suite/engines/funcs/t/data1.inc 398SELECT * FROM t1 LIMIT 5; 399SELECT * FROM t1 WHERE c1='c' LIMIT 5; 400SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 5; 401DROP TABLE t1; 402CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 403--source suite/engines/funcs/t/data1.inc 404SELECT * FROM t1 LIMIT 5; 405SELECT * FROM t1 WHERE c1='d' LIMIT 5; 406SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 5; 407DROP TABLE t1; 408CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 409--source suite/engines/funcs/t/data1.inc 410SELECT * FROM t1 LIMIT 5; 411SELECT * FROM t1 WHERE c1='e' LIMIT 5; 412SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 5; 413DROP TABLE t1; 414CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 415--source suite/engines/funcs/t/data1.inc 416SELECT * FROM t1 LIMIT 5; 417SELECT * FROM t1 WHERE c1='f' LIMIT 5; 418SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 5; 419DROP TABLE t1; 420CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 421--source suite/engines/funcs/t/data1.inc 422SELECT * FROM t1 LIMIT 5; 423SELECT * FROM t1 WHERE c1='y' LIMIT 5; 424SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 5; 425DROP TABLE t1; 426CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 427--source suite/engines/funcs/t/data1.inc 428SELECT * FROM t1 LIMIT 5; 429SELECT * FROM t1 WHERE c1='a' LIMIT 5; 430SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 5; 431DROP TABLE t1; 432CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 433--source suite/engines/funcs/t/data1.inc 434SELECT * FROM t1 LIMIT 5; 435SELECT * FROM t1 WHERE c1='b' LIMIT 5; 436SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 5; 437DROP TABLE t1; 438CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 439--source suite/engines/funcs/t/data1.inc 440SELECT * FROM t1 LIMIT 5; 441SELECT * FROM t1 WHERE c1='c' LIMIT 5; 442SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 5; 443DROP TABLE t1; 444CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 445--source suite/engines/funcs/t/data1.inc 446SELECT * FROM t1 LIMIT 5; 447SELECT * FROM t1 WHERE c1='d' LIMIT 5; 448SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 5; 449DROP TABLE t1; 450CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 451--source suite/engines/funcs/t/data1.inc 452SELECT * FROM t1 LIMIT 5; 453SELECT * FROM t1 WHERE c1='e' LIMIT 5; 454SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 5; 455DROP TABLE t1; 456CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 457--source suite/engines/funcs/t/data1.inc 458SELECT * FROM t1 LIMIT 5; 459SELECT * FROM t1 WHERE c1='f' LIMIT 5; 460SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 5; 461DROP TABLE t1; 462CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 463--source suite/engines/funcs/t/data1.inc 464SELECT * FROM t1 LIMIT 5; 465SELECT * FROM t1 WHERE c1='y' LIMIT 5; 466SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 5; 467DROP TABLE t1; 468CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 469--source suite/engines/funcs/t/data1.inc 470SELECT * FROM t1 LIMIT 5; 471SELECT * FROM t1 WHERE c1='a' LIMIT 5; 472SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 5; 473DROP TABLE t1; 474CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 475--source suite/engines/funcs/t/data1.inc 476SELECT * FROM t1 LIMIT 5; 477SELECT * FROM t1 WHERE c1='b' LIMIT 5; 478SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 5; 479DROP TABLE t1; 480CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 481--source suite/engines/funcs/t/data1.inc 482SELECT * FROM t1 LIMIT 5; 483SELECT * FROM t1 WHERE c1='c' LIMIT 5; 484SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 5; 485DROP TABLE t1; 486CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 487--source suite/engines/funcs/t/data1.inc 488SELECT * FROM t1 LIMIT 5; 489SELECT * FROM t1 WHERE c1='d' LIMIT 5; 490SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 5; 491DROP TABLE t1; 492CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 493--source suite/engines/funcs/t/data1.inc 494SELECT * FROM t1 LIMIT 5; 495SELECT * FROM t1 WHERE c1='e' LIMIT 5; 496SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 5; 497DROP TABLE t1; 498CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 499--source suite/engines/funcs/t/data1.inc 500SELECT * FROM t1 LIMIT 5; 501SELECT * FROM t1 WHERE c1='f' LIMIT 5; 502SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 5; 503DROP TABLE t1; 504CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 505--source suite/engines/funcs/t/data1.inc 506SELECT * FROM t1 LIMIT 5; 507SELECT * FROM t1 WHERE c1='y' LIMIT 5; 508SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 5; 509DROP TABLE t1; 510CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 511--source suite/engines/funcs/t/data1.inc 512SELECT * FROM t1 LIMIT 100; 513SELECT * FROM t1 WHERE c1='a' LIMIT 100; 514SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 100; 515DROP TABLE t1; 516CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 517--source suite/engines/funcs/t/data1.inc 518SELECT * FROM t1 LIMIT 100; 519SELECT * FROM t1 WHERE c1='b' LIMIT 100; 520SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 100; 521DROP TABLE t1; 522CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 523--source suite/engines/funcs/t/data1.inc 524SELECT * FROM t1 LIMIT 100; 525SELECT * FROM t1 WHERE c1='c' LIMIT 100; 526SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 100; 527DROP TABLE t1; 528CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 529--source suite/engines/funcs/t/data1.inc 530SELECT * FROM t1 LIMIT 100; 531SELECT * FROM t1 WHERE c1='d' LIMIT 100; 532SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 100; 533DROP TABLE t1; 534CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 535--source suite/engines/funcs/t/data1.inc 536SELECT * FROM t1 LIMIT 100; 537SELECT * FROM t1 WHERE c1='e' LIMIT 100; 538SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 100; 539DROP TABLE t1; 540CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 541--source suite/engines/funcs/t/data1.inc 542SELECT * FROM t1 LIMIT 100; 543SELECT * FROM t1 WHERE c1='f' LIMIT 100; 544SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 100; 545DROP TABLE t1; 546CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 547--source suite/engines/funcs/t/data1.inc 548SELECT * FROM t1 LIMIT 100; 549SELECT * FROM t1 WHERE c1='y' LIMIT 100; 550SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 100; 551DROP TABLE t1; 552CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 553--source suite/engines/funcs/t/data1.inc 554SELECT * FROM t1 LIMIT 100; 555SELECT * FROM t1 WHERE c1='a' LIMIT 100; 556SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 100; 557DROP TABLE t1; 558CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 559--source suite/engines/funcs/t/data1.inc 560SELECT * FROM t1 LIMIT 100; 561SELECT * FROM t1 WHERE c1='b' LIMIT 100; 562SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 100; 563DROP TABLE t1; 564CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 565--source suite/engines/funcs/t/data1.inc 566SELECT * FROM t1 LIMIT 100; 567SELECT * FROM t1 WHERE c1='c' LIMIT 100; 568SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 100; 569DROP TABLE t1; 570CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 571--source suite/engines/funcs/t/data1.inc 572SELECT * FROM t1 LIMIT 100; 573SELECT * FROM t1 WHERE c1='d' LIMIT 100; 574SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 100; 575DROP TABLE t1; 576CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 577--source suite/engines/funcs/t/data1.inc 578SELECT * FROM t1 LIMIT 100; 579SELECT * FROM t1 WHERE c1='e' LIMIT 100; 580SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 100; 581DROP TABLE t1; 582CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 583--source suite/engines/funcs/t/data1.inc 584SELECT * FROM t1 LIMIT 100; 585SELECT * FROM t1 WHERE c1='f' LIMIT 100; 586SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 100; 587DROP TABLE t1; 588CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 589--source suite/engines/funcs/t/data1.inc 590SELECT * FROM t1 LIMIT 100; 591SELECT * FROM t1 WHERE c1='y' LIMIT 100; 592SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 100; 593DROP TABLE t1; 594CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 595--source suite/engines/funcs/t/data1.inc 596SELECT * FROM t1 LIMIT 100; 597SELECT * FROM t1 WHERE c1='a' LIMIT 100; 598SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 100; 599DROP TABLE t1; 600CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 601--source suite/engines/funcs/t/data1.inc 602SELECT * FROM t1 LIMIT 100; 603SELECT * FROM t1 WHERE c1='b' LIMIT 100; 604SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 100; 605DROP TABLE t1; 606CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 607--source suite/engines/funcs/t/data1.inc 608SELECT * FROM t1 LIMIT 100; 609SELECT * FROM t1 WHERE c1='c' LIMIT 100; 610SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 100; 611DROP TABLE t1; 612CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 613--source suite/engines/funcs/t/data1.inc 614SELECT * FROM t1 LIMIT 100; 615SELECT * FROM t1 WHERE c1='d' LIMIT 100; 616SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 100; 617DROP TABLE t1; 618CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 619--source suite/engines/funcs/t/data1.inc 620SELECT * FROM t1 LIMIT 100; 621SELECT * FROM t1 WHERE c1='e' LIMIT 100; 622SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 100; 623DROP TABLE t1; 624CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 625--source suite/engines/funcs/t/data1.inc 626SELECT * FROM t1 LIMIT 100; 627SELECT * FROM t1 WHERE c1='f' LIMIT 100; 628SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 100; 629DROP TABLE t1; 630CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 631--source suite/engines/funcs/t/data1.inc 632SELECT * FROM t1 LIMIT 100; 633SELECT * FROM t1 WHERE c1='y' LIMIT 100; 634SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 100; 635DROP TABLE t1; 636CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 637--source suite/engines/funcs/t/data1.inc 638SELECT * FROM t1 LIMIT 100; 639SELECT * FROM t1 WHERE c1='a' LIMIT 100; 640SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 100; 641DROP TABLE t1; 642CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 643--source suite/engines/funcs/t/data1.inc 644SELECT * FROM t1 LIMIT 100; 645SELECT * FROM t1 WHERE c1='b' LIMIT 100; 646SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 100; 647DROP TABLE t1; 648CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 649--source suite/engines/funcs/t/data1.inc 650SELECT * FROM t1 LIMIT 100; 651SELECT * FROM t1 WHERE c1='c' LIMIT 100; 652SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 100; 653DROP TABLE t1; 654CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 655--source suite/engines/funcs/t/data1.inc 656SELECT * FROM t1 LIMIT 100; 657SELECT * FROM t1 WHERE c1='d' LIMIT 100; 658SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 100; 659DROP TABLE t1; 660CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 661--source suite/engines/funcs/t/data1.inc 662SELECT * FROM t1 LIMIT 100; 663SELECT * FROM t1 WHERE c1='e' LIMIT 100; 664SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 100; 665DROP TABLE t1; 666CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 667--source suite/engines/funcs/t/data1.inc 668SELECT * FROM t1 LIMIT 100; 669SELECT * FROM t1 WHERE c1='f' LIMIT 100; 670SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 100; 671DROP TABLE t1; 672CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 673--source suite/engines/funcs/t/data1.inc 674SELECT * FROM t1 LIMIT 100; 675SELECT * FROM t1 WHERE c1='y' LIMIT 100; 676SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 100; 677DROP TABLE t1; 678CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 679--source suite/engines/funcs/t/data1.inc 680SELECT * FROM t1 LIMIT 100; 681SELECT * FROM t1 WHERE c1='a' LIMIT 100; 682SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 100; 683DROP TABLE t1; 684CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 685--source suite/engines/funcs/t/data1.inc 686SELECT * FROM t1 LIMIT 100; 687SELECT * FROM t1 WHERE c1='b' LIMIT 100; 688SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 100; 689DROP TABLE t1; 690CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 691--source suite/engines/funcs/t/data1.inc 692SELECT * FROM t1 LIMIT 100; 693SELECT * FROM t1 WHERE c1='c' LIMIT 100; 694SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 100; 695DROP TABLE t1; 696CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 697--source suite/engines/funcs/t/data1.inc 698SELECT * FROM t1 LIMIT 100; 699SELECT * FROM t1 WHERE c1='d' LIMIT 100; 700SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 100; 701DROP TABLE t1; 702CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 703--source suite/engines/funcs/t/data1.inc 704SELECT * FROM t1 LIMIT 100; 705SELECT * FROM t1 WHERE c1='e' LIMIT 100; 706SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 100; 707DROP TABLE t1; 708CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 709--source suite/engines/funcs/t/data1.inc 710SELECT * FROM t1 LIMIT 100; 711SELECT * FROM t1 WHERE c1='f' LIMIT 100; 712SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 100; 713DROP TABLE t1; 714CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 715--source suite/engines/funcs/t/data1.inc 716SELECT * FROM t1 LIMIT 100; 717SELECT * FROM t1 WHERE c1='y' LIMIT 100; 718SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 100; 719DROP TABLE t1; 720CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 721--source suite/engines/funcs/t/data1.inc 722SELECT * FROM t1 LIMIT 100; 723SELECT * FROM t1 WHERE c1='a' LIMIT 100; 724SELECT * FROM t1 WHERE c1='a' AND c2 = 'a' LIMIT 100; 725DROP TABLE t1; 726CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 727--source suite/engines/funcs/t/data1.inc 728SELECT * FROM t1 LIMIT 100; 729SELECT * FROM t1 WHERE c1='b' LIMIT 100; 730SELECT * FROM t1 WHERE c1='b' AND c2 = 'b' LIMIT 100; 731DROP TABLE t1; 732CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 733--source suite/engines/funcs/t/data1.inc 734SELECT * FROM t1 LIMIT 100; 735SELECT * FROM t1 WHERE c1='c' LIMIT 100; 736SELECT * FROM t1 WHERE c1='c' AND c2 = 'c' LIMIT 100; 737DROP TABLE t1; 738CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 739--source suite/engines/funcs/t/data1.inc 740SELECT * FROM t1 LIMIT 100; 741SELECT * FROM t1 WHERE c1='d' LIMIT 100; 742SELECT * FROM t1 WHERE c1='d' AND c2 = 'd' LIMIT 100; 743DROP TABLE t1; 744CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 745--source suite/engines/funcs/t/data1.inc 746SELECT * FROM t1 LIMIT 100; 747SELECT * FROM t1 WHERE c1='e' LIMIT 100; 748SELECT * FROM t1 WHERE c1='e' AND c2 = 'e' LIMIT 100; 749DROP TABLE t1; 750CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 751--source suite/engines/funcs/t/data1.inc 752SELECT * FROM t1 LIMIT 100; 753SELECT * FROM t1 WHERE c1='f' LIMIT 100; 754SELECT * FROM t1 WHERE c1='f' AND c2 = 'f' LIMIT 100; 755DROP TABLE t1; 756CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 757--source suite/engines/funcs/t/data1.inc 758SELECT * FROM t1 LIMIT 100; 759SELECT * FROM t1 WHERE c1='y' LIMIT 100; 760SELECT * FROM t1 WHERE c1='y' AND c2 = 'y' LIMIT 100; 761DROP TABLE t1; 762 763