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 COUNT(*) FROM t1,t1 AS b; 9SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a'; 10SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a'; 11SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1; 12SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1; 13SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 14SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 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,t1 AS b; 19SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b'; 20SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b'; 21SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1; 22SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1; 23SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 24SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 25DROP TABLE t1; 26CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 27--source suite/engines/funcs/t/data1.inc 28SELECT COUNT(*) FROM t1,t1 AS b; 29SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c'; 30SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c'; 31SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1; 32SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1; 33SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 34SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 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 COUNT(*) FROM t1,t1 AS b; 39SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d'; 40SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d'; 41SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1; 42SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1; 43SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 44SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 45DROP TABLE t1; 46CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 47--source suite/engines/funcs/t/data1.inc 48SELECT COUNT(*) FROM t1,t1 AS b; 49SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e'; 50SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e'; 51SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1; 52SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1; 53SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 54SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 55DROP TABLE t1; 56CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 57--source suite/engines/funcs/t/data1.inc 58SELECT COUNT(*) FROM t1,t1 AS b; 59SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f'; 60SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f'; 61SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1; 62SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1; 63SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 64SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 65DROP TABLE t1; 66CREATE TABLE t1(c1 CHAR(1) NULL, c2 CHAR(1) NULL, c3 INT NULL); 67--source suite/engines/funcs/t/data1.inc 68SELECT COUNT(*) FROM t1,t1 AS b; 69SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y'; 70SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y'; 71SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1; 72SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1; 73SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 74SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 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,t1 AS b; 79SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a'; 80SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a'; 81SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1; 82SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1; 83SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 84SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 85DROP TABLE t1; 86CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 87--source suite/engines/funcs/t/data1.inc 88SELECT COUNT(*) FROM t1,t1 AS b; 89SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b'; 90SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b'; 91SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1; 92SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1; 93SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 94SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 95DROP TABLE t1; 96CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 97--source suite/engines/funcs/t/data1.inc 98SELECT COUNT(*) FROM t1,t1 AS b; 99SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c'; 100SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c'; 101SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1; 102SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1; 103SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 104SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 105DROP TABLE t1; 106CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 107--source suite/engines/funcs/t/data1.inc 108SELECT COUNT(*) FROM t1,t1 AS b; 109SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d'; 110SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d'; 111SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1; 112SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1; 113SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 114SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 115DROP TABLE t1; 116CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 117--source suite/engines/funcs/t/data1.inc 118SELECT COUNT(*) FROM t1,t1 AS b; 119SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e'; 120SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e'; 121SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1; 122SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1; 123SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 124SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 125DROP TABLE t1; 126CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 127--source suite/engines/funcs/t/data1.inc 128SELECT COUNT(*) FROM t1,t1 AS b; 129SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f'; 130SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f'; 131SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1; 132SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1; 133SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 134SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 135DROP TABLE t1; 136CREATE TABLE t1(c1 VARCHAR(1) NULL, c2 VARCHAR(1) NULL, c3 INT NULL); 137--source suite/engines/funcs/t/data1.inc 138SELECT COUNT(*) FROM t1,t1 AS b; 139SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y'; 140SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y'; 141SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1; 142SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1; 143SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 144SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 145DROP TABLE t1; 146CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 147--source suite/engines/funcs/t/data1.inc 148SELECT COUNT(*) FROM t1,t1 AS b; 149SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a'; 150SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a'; 151SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1; 152SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1; 153SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 154SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 155DROP TABLE t1; 156CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 157--source suite/engines/funcs/t/data1.inc 158SELECT COUNT(*) FROM t1,t1 AS b; 159SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b'; 160SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b'; 161SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1; 162SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1; 163SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 164SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 165DROP TABLE t1; 166CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 167--source suite/engines/funcs/t/data1.inc 168SELECT COUNT(*) FROM t1,t1 AS b; 169SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c'; 170SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c'; 171SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1; 172SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1; 173SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 174SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 175DROP TABLE t1; 176CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 177--source suite/engines/funcs/t/data1.inc 178SELECT COUNT(*) FROM t1,t1 AS b; 179SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d'; 180SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d'; 181SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1; 182SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1; 183SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 184SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 185DROP TABLE t1; 186CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 187--source suite/engines/funcs/t/data1.inc 188SELECT COUNT(*) FROM t1,t1 AS b; 189SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e'; 190SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e'; 191SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1; 192SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1; 193SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 194SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 195DROP TABLE t1; 196CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 197--source suite/engines/funcs/t/data1.inc 198SELECT COUNT(*) FROM t1,t1 AS b; 199SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f'; 200SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f'; 201SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1; 202SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1; 203SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 204SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 205DROP TABLE t1; 206CREATE TABLE t1(c1 BINARY(1) NULL, c2 BINARY(1) NULL, c3 INT NULL); 207--source suite/engines/funcs/t/data1.inc 208SELECT COUNT(*) FROM t1,t1 AS b; 209SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y'; 210SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y'; 211SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1; 212SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1; 213SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 214SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 215DROP TABLE t1; 216CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 217--source suite/engines/funcs/t/data1.inc 218SELECT COUNT(*) FROM t1,t1 AS b; 219SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a'; 220SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a'; 221SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1; 222SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1; 223SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 224SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 225DROP TABLE t1; 226CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 227--source suite/engines/funcs/t/data1.inc 228SELECT COUNT(*) FROM t1,t1 AS b; 229SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b'; 230SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b'; 231SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1; 232SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1; 233SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 234SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 235DROP TABLE t1; 236CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 237--source suite/engines/funcs/t/data1.inc 238SELECT COUNT(*) FROM t1,t1 AS b; 239SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c'; 240SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c'; 241SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1; 242SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1; 243SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 244SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 245DROP TABLE t1; 246CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 247--source suite/engines/funcs/t/data1.inc 248SELECT COUNT(*) FROM t1,t1 AS b; 249SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d'; 250SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d'; 251SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1; 252SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1; 253SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 254SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 255DROP TABLE t1; 256CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 257--source suite/engines/funcs/t/data1.inc 258SELECT COUNT(*) FROM t1,t1 AS b; 259SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e'; 260SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e'; 261SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1; 262SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1; 263SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 264SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 265DROP TABLE t1; 266CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 267--source suite/engines/funcs/t/data1.inc 268SELECT COUNT(*) FROM t1,t1 AS b; 269SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f'; 270SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f'; 271SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1; 272SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1; 273SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 274SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 275DROP TABLE t1; 276CREATE TABLE t1(c1 VARBINARY(1) NULL, c2 VARBINARY(1) NULL, c3 INT NULL); 277--source suite/engines/funcs/t/data1.inc 278SELECT COUNT(*) FROM t1,t1 AS b; 279SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y'; 280SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y'; 281SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1; 282SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1; 283SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 284SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 285DROP TABLE t1; 286CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 287--source suite/engines/funcs/t/data1.inc 288SELECT COUNT(*) FROM t1,t1 AS b; 289SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a'; 290SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a'; 291SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1; 292SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1; 293SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 294SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 295DROP TABLE t1; 296CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 297--source suite/engines/funcs/t/data1.inc 298SELECT COUNT(*) FROM t1,t1 AS b; 299SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b'; 300SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b'; 301SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1; 302SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1; 303SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 304SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 305DROP TABLE t1; 306CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 307--source suite/engines/funcs/t/data1.inc 308SELECT COUNT(*) FROM t1,t1 AS b; 309SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c'; 310SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c'; 311SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1; 312SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1; 313SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 314SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 315DROP TABLE t1; 316CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 317--source suite/engines/funcs/t/data1.inc 318SELECT COUNT(*) FROM t1,t1 AS b; 319SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d'; 320SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d'; 321SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1; 322SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1; 323SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 324SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 325DROP TABLE t1; 326CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 327--source suite/engines/funcs/t/data1.inc 328SELECT COUNT(*) FROM t1,t1 AS b; 329SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e'; 330SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e'; 331SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1; 332SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1; 333SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 334SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 335DROP TABLE t1; 336CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 337--source suite/engines/funcs/t/data1.inc 338SELECT COUNT(*) FROM t1,t1 AS b; 339SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f'; 340SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f'; 341SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1; 342SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1; 343SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 344SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 345DROP TABLE t1; 346CREATE TABLE t1(c1 BLOB(1) NULL, c2 BLOB(1) NULL, c3 INT NULL); 347--source suite/engines/funcs/t/data1.inc 348SELECT COUNT(*) FROM t1,t1 AS b; 349SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y'; 350SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y'; 351SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1; 352SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1; 353SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 354SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 355DROP TABLE t1; 356CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 357--source suite/engines/funcs/t/data1.inc 358SELECT COUNT(*) FROM t1,t1 AS b; 359SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a'; 360SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a'; 361SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1; 362SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1; 363SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='a' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 364SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='a' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 365DROP TABLE t1; 366CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 367--source suite/engines/funcs/t/data1.inc 368SELECT COUNT(*) FROM t1,t1 AS b; 369SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b'; 370SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b'; 371SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1; 372SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1; 373SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='b' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 374SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='b' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 375DROP TABLE t1; 376CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 377--source suite/engines/funcs/t/data1.inc 378SELECT COUNT(*) FROM t1,t1 AS b; 379SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c'; 380SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c'; 381SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1; 382SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1; 383SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='c' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 384SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='c' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 385DROP TABLE t1; 386CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 387--source suite/engines/funcs/t/data1.inc 388SELECT COUNT(*) FROM t1,t1 AS b; 389SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d'; 390SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d'; 391SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1; 392SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1; 393SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='d' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 394SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='d' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 395DROP TABLE t1; 396CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 397--source suite/engines/funcs/t/data1.inc 398SELECT COUNT(*) FROM t1,t1 AS b; 399SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e'; 400SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e'; 401SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1; 402SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1; 403SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='e' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 404SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='e' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 405DROP TABLE t1; 406CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 407--source suite/engines/funcs/t/data1.inc 408SELECT COUNT(*) FROM t1,t1 AS b; 409SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f'; 410SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f'; 411SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1; 412SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1; 413SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='f' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 414SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='f' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 415DROP TABLE t1; 416CREATE TABLE t1(c1 TEXT(1) NULL, c2 TEXT(1) NULL, c3 INT NULL); 417--source suite/engines/funcs/t/data1.inc 418SELECT COUNT(*) FROM t1,t1 AS b; 419SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y'; 420SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y'; 421SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1; 422SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1; 423SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c2='y' AND t1.c1 = b.c1 AND t1.c2 = b.c2; 424SELECT COUNT(*) FROM t1,t1 AS b WHERE t1.c1='y' AND t1.c2 = b.c1 AND t1.c1 = b.c2; 425DROP TABLE t1; 426 427