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