1--disable_warnings 2DROP TABLE IF EXISTS t1,t2,t3,t4; 3--enable_warnings 4CREATE TABLE t1(c1 TINYINT NOT NULL); 5CREATE TABLE t2(c1 TINYINT NULL); 6CREATE TABLE t3(c1 TINYINT NOT NULL); 7CREATE TABLE t4(c1 TINYINT NULL); 8INSERT INTO t2 (c1) VALUES(NULL); 9INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 10INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 11SELECT AVG(c1) AS value FROM t1; 12SELECT AVG(c1) AS value FROM t1 WHERE c1 < 0; 13SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 14SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 15DROP TABLE t1,t2,t3,t4; 16CREATE TABLE t1(c1 SMALLINT NOT NULL); 17CREATE TABLE t2(c1 SMALLINT NULL); 18CREATE TABLE t3(c1 SMALLINT NOT NULL); 19CREATE TABLE t4(c1 SMALLINT NULL); 20INSERT INTO t2 (c1) VALUES(NULL); 21INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 22INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 23SELECT AVG(c1) AS value FROM t1; 24SELECT AVG(c1) AS value FROM t1 WHERE c1 < 0; 25SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 26SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 27DROP TABLE t1,t2,t3,t4; 28CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 29CREATE TABLE t2(c1 MEDIUMINT NULL); 30CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 31CREATE TABLE t4(c1 MEDIUMINT NULL); 32INSERT INTO t2 (c1) VALUES(NULL); 33INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 34INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 35SELECT AVG(c1) AS value FROM t1; 36SELECT AVG(c1) AS value FROM t1 WHERE c1 < 0; 37SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 38SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 39DROP TABLE t1,t2,t3,t4; 40CREATE TABLE t1(c1 INT NOT NULL); 41CREATE TABLE t2(c1 INT NULL); 42CREATE TABLE t3(c1 INT NOT NULL); 43CREATE TABLE t4(c1 INT NULL); 44INSERT INTO t2 (c1) VALUES(NULL); 45INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 46INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 47SELECT AVG(c1) AS value FROM t1; 48SELECT AVG(c1) AS value FROM t1 WHERE c1 < 0; 49SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 50SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 51DROP TABLE t1,t2,t3,t4; 52CREATE TABLE t1(c1 INTEGER NOT NULL); 53CREATE TABLE t2(c1 INTEGER NULL); 54CREATE TABLE t3(c1 INTEGER NOT NULL); 55CREATE TABLE t4(c1 INTEGER NULL); 56INSERT INTO t2 (c1) VALUES(NULL); 57INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 58INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 59SELECT AVG(c1) AS value FROM t1; 60SELECT AVG(c1) AS value FROM t1 WHERE c1 < 0; 61SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 62SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 63DROP TABLE t1,t2,t3,t4; 64CREATE TABLE t1(c1 BIGINT NOT NULL); 65CREATE TABLE t2(c1 BIGINT NULL); 66CREATE TABLE t3(c1 BIGINT NOT NULL); 67CREATE TABLE t4(c1 BIGINT NULL); 68INSERT INTO t2 (c1) VALUES(NULL); 69INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 70INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 71SELECT AVG(c1) AS value FROM t1; 72SELECT AVG(c1) AS value FROM t1 WHERE c1 < 0; 73SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 74SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 75DROP TABLE t1,t2,t3,t4; 76CREATE TABLE t1(c1 TINYINT NOT NULL); 77CREATE TABLE t2(c1 TINYINT NULL); 78CREATE TABLE t3(c1 TINYINT NOT NULL); 79CREATE TABLE t4(c1 TINYINT NULL); 80INSERT INTO t2 (c1) VALUES(NULL); 81INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 82INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 83SELECT AVG(c1) AS value FROM t2; 84SELECT AVG(c1) AS value FROM t2 WHERE c1 < 0; 85SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 86SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 87DROP TABLE t1,t2,t3,t4; 88CREATE TABLE t1(c1 SMALLINT NOT NULL); 89CREATE TABLE t2(c1 SMALLINT NULL); 90CREATE TABLE t3(c1 SMALLINT NOT NULL); 91CREATE TABLE t4(c1 SMALLINT NULL); 92INSERT INTO t2 (c1) VALUES(NULL); 93INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 94INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 95SELECT AVG(c1) AS value FROM t2; 96SELECT AVG(c1) AS value FROM t2 WHERE c1 < 0; 97SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 98SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 99DROP TABLE t1,t2,t3,t4; 100CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 101CREATE TABLE t2(c1 MEDIUMINT NULL); 102CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 103CREATE TABLE t4(c1 MEDIUMINT NULL); 104INSERT INTO t2 (c1) VALUES(NULL); 105INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 106INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 107SELECT AVG(c1) AS value FROM t2; 108SELECT AVG(c1) AS value FROM t2 WHERE c1 < 0; 109SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 110SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 111DROP TABLE t1,t2,t3,t4; 112CREATE TABLE t1(c1 INT NOT NULL); 113CREATE TABLE t2(c1 INT NULL); 114CREATE TABLE t3(c1 INT NOT NULL); 115CREATE TABLE t4(c1 INT NULL); 116INSERT INTO t2 (c1) VALUES(NULL); 117INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 118INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 119SELECT AVG(c1) AS value FROM t2; 120SELECT AVG(c1) AS value FROM t2 WHERE c1 < 0; 121SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 122SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 123DROP TABLE t1,t2,t3,t4; 124CREATE TABLE t1(c1 INTEGER NOT NULL); 125CREATE TABLE t2(c1 INTEGER NULL); 126CREATE TABLE t3(c1 INTEGER NOT NULL); 127CREATE TABLE t4(c1 INTEGER NULL); 128INSERT INTO t2 (c1) VALUES(NULL); 129INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 130INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 131SELECT AVG(c1) AS value FROM t2; 132SELECT AVG(c1) AS value FROM t2 WHERE c1 < 0; 133SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 134SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 135DROP TABLE t1,t2,t3,t4; 136CREATE TABLE t1(c1 BIGINT NOT NULL); 137CREATE TABLE t2(c1 BIGINT NULL); 138CREATE TABLE t3(c1 BIGINT NOT NULL); 139CREATE TABLE t4(c1 BIGINT NULL); 140INSERT INTO t2 (c1) VALUES(NULL); 141INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 142INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 143SELECT AVG(c1) AS value FROM t2; 144SELECT AVG(c1) AS value FROM t2 WHERE c1 < 0; 145SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 146SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 147DROP TABLE t1,t2,t3,t4; 148CREATE TABLE t1(c1 TINYINT NOT NULL); 149CREATE TABLE t2(c1 TINYINT NULL); 150CREATE TABLE t3(c1 TINYINT NOT NULL); 151CREATE TABLE t4(c1 TINYINT NULL); 152INSERT INTO t2 (c1) VALUES(NULL); 153INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 154INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 155SELECT AVG(c1) AS value FROM t3; 156SELECT AVG(c1) AS value FROM t3 WHERE c1 < 0; 157SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 158SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 159DROP TABLE t1,t2,t3,t4; 160CREATE TABLE t1(c1 SMALLINT NOT NULL); 161CREATE TABLE t2(c1 SMALLINT NULL); 162CREATE TABLE t3(c1 SMALLINT NOT NULL); 163CREATE TABLE t4(c1 SMALLINT NULL); 164INSERT INTO t2 (c1) VALUES(NULL); 165INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 166INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 167SELECT AVG(c1) AS value FROM t3; 168SELECT AVG(c1) AS value FROM t3 WHERE c1 < 0; 169SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 170SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 171DROP TABLE t1,t2,t3,t4; 172CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 173CREATE TABLE t2(c1 MEDIUMINT NULL); 174CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 175CREATE TABLE t4(c1 MEDIUMINT NULL); 176INSERT INTO t2 (c1) VALUES(NULL); 177INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 178INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 179SELECT AVG(c1) AS value FROM t3; 180SELECT AVG(c1) AS value FROM t3 WHERE c1 < 0; 181SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 182SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 183DROP TABLE t1,t2,t3,t4; 184CREATE TABLE t1(c1 INT NOT NULL); 185CREATE TABLE t2(c1 INT NULL); 186CREATE TABLE t3(c1 INT NOT NULL); 187CREATE TABLE t4(c1 INT NULL); 188INSERT INTO t2 (c1) VALUES(NULL); 189INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 190INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 191SELECT AVG(c1) AS value FROM t3; 192SELECT AVG(c1) AS value FROM t3 WHERE c1 < 0; 193SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 194SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 195DROP TABLE t1,t2,t3,t4; 196CREATE TABLE t1(c1 INTEGER NOT NULL); 197CREATE TABLE t2(c1 INTEGER NULL); 198CREATE TABLE t3(c1 INTEGER NOT NULL); 199CREATE TABLE t4(c1 INTEGER NULL); 200INSERT INTO t2 (c1) VALUES(NULL); 201INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 202INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 203SELECT AVG(c1) AS value FROM t3; 204SELECT AVG(c1) AS value FROM t3 WHERE c1 < 0; 205SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 206SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 207DROP TABLE t1,t2,t3,t4; 208CREATE TABLE t1(c1 BIGINT NOT NULL); 209CREATE TABLE t2(c1 BIGINT NULL); 210CREATE TABLE t3(c1 BIGINT NOT NULL); 211CREATE TABLE t4(c1 BIGINT NULL); 212INSERT INTO t2 (c1) VALUES(NULL); 213INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 214INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 215SELECT AVG(c1) AS value FROM t3; 216SELECT AVG(c1) AS value FROM t3 WHERE c1 < 0; 217SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 218SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 219DROP TABLE t1,t2,t3,t4; 220CREATE TABLE t1(c1 TINYINT NOT NULL); 221CREATE TABLE t2(c1 TINYINT NULL); 222CREATE TABLE t3(c1 TINYINT NOT NULL); 223CREATE TABLE t4(c1 TINYINT NULL); 224INSERT INTO t2 (c1) VALUES(NULL); 225INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 226INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 227SELECT AVG(c1) AS value FROM t4; 228SELECT AVG(c1) AS value FROM t4 WHERE c1 < 0; 229SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 230SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 231DROP TABLE t1,t2,t3,t4; 232CREATE TABLE t1(c1 SMALLINT NOT NULL); 233CREATE TABLE t2(c1 SMALLINT NULL); 234CREATE TABLE t3(c1 SMALLINT NOT NULL); 235CREATE TABLE t4(c1 SMALLINT NULL); 236INSERT INTO t2 (c1) VALUES(NULL); 237INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 238INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 239SELECT AVG(c1) AS value FROM t4; 240SELECT AVG(c1) AS value FROM t4 WHERE c1 < 0; 241SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 242SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 243DROP TABLE t1,t2,t3,t4; 244CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 245CREATE TABLE t2(c1 MEDIUMINT NULL); 246CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 247CREATE TABLE t4(c1 MEDIUMINT NULL); 248INSERT INTO t2 (c1) VALUES(NULL); 249INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 250INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 251SELECT AVG(c1) AS value FROM t4; 252SELECT AVG(c1) AS value FROM t4 WHERE c1 < 0; 253SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 254SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 255DROP TABLE t1,t2,t3,t4; 256CREATE TABLE t1(c1 INT NOT NULL); 257CREATE TABLE t2(c1 INT NULL); 258CREATE TABLE t3(c1 INT NOT NULL); 259CREATE TABLE t4(c1 INT NULL); 260INSERT INTO t2 (c1) VALUES(NULL); 261INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 262INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 263SELECT AVG(c1) AS value FROM t4; 264SELECT AVG(c1) AS value FROM t4 WHERE c1 < 0; 265SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 266SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 267DROP TABLE t1,t2,t3,t4; 268CREATE TABLE t1(c1 INTEGER NOT NULL); 269CREATE TABLE t2(c1 INTEGER NULL); 270CREATE TABLE t3(c1 INTEGER NOT NULL); 271CREATE TABLE t4(c1 INTEGER NULL); 272INSERT INTO t2 (c1) VALUES(NULL); 273INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 274INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 275SELECT AVG(c1) AS value FROM t4; 276SELECT AVG(c1) AS value FROM t4 WHERE c1 < 0; 277SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 278SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 279DROP TABLE t1,t2,t3,t4; 280CREATE TABLE t1(c1 BIGINT NOT NULL); 281CREATE TABLE t2(c1 BIGINT NULL); 282CREATE TABLE t3(c1 BIGINT NOT NULL); 283CREATE TABLE t4(c1 BIGINT NULL); 284INSERT INTO t2 (c1) VALUES(NULL); 285INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 286INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 287SELECT AVG(c1) AS value FROM t4; 288SELECT AVG(c1) AS value FROM t4 WHERE c1 < 0; 289SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 290SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 291DROP TABLE t1,t2,t3,t4; 292CREATE TABLE t1(c1 TINYINT NOT NULL); 293CREATE TABLE t2(c1 TINYINT NULL); 294CREATE TABLE t3(c1 TINYINT NOT NULL); 295CREATE TABLE t4(c1 TINYINT NULL); 296INSERT INTO t2 (c1) VALUES(NULL); 297INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 298INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 299SELECT AVG(c1) AS value FROM t1; 300SELECT AVG(c1) AS value FROM t1 WHERE c1 <= 0; 301SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 302SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 303DROP TABLE t1,t2,t3,t4; 304CREATE TABLE t1(c1 SMALLINT NOT NULL); 305CREATE TABLE t2(c1 SMALLINT NULL); 306CREATE TABLE t3(c1 SMALLINT NOT NULL); 307CREATE TABLE t4(c1 SMALLINT NULL); 308INSERT INTO t2 (c1) VALUES(NULL); 309INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 310INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 311SELECT AVG(c1) AS value FROM t1; 312SELECT AVG(c1) AS value FROM t1 WHERE c1 <= 0; 313SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 314SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 315DROP TABLE t1,t2,t3,t4; 316CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 317CREATE TABLE t2(c1 MEDIUMINT NULL); 318CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 319CREATE TABLE t4(c1 MEDIUMINT NULL); 320INSERT INTO t2 (c1) VALUES(NULL); 321INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 322INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 323SELECT AVG(c1) AS value FROM t1; 324SELECT AVG(c1) AS value FROM t1 WHERE c1 <= 0; 325SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 326SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 327DROP TABLE t1,t2,t3,t4; 328CREATE TABLE t1(c1 INT NOT NULL); 329CREATE TABLE t2(c1 INT NULL); 330CREATE TABLE t3(c1 INT NOT NULL); 331CREATE TABLE t4(c1 INT NULL); 332INSERT INTO t2 (c1) VALUES(NULL); 333INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 334INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 335SELECT AVG(c1) AS value FROM t1; 336SELECT AVG(c1) AS value FROM t1 WHERE c1 <= 0; 337SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 338SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 339DROP TABLE t1,t2,t3,t4; 340CREATE TABLE t1(c1 INTEGER NOT NULL); 341CREATE TABLE t2(c1 INTEGER NULL); 342CREATE TABLE t3(c1 INTEGER NOT NULL); 343CREATE TABLE t4(c1 INTEGER NULL); 344INSERT INTO t2 (c1) VALUES(NULL); 345INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 346INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 347SELECT AVG(c1) AS value FROM t1; 348SELECT AVG(c1) AS value FROM t1 WHERE c1 <= 0; 349SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 350SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 351DROP TABLE t1,t2,t3,t4; 352CREATE TABLE t1(c1 BIGINT NOT NULL); 353CREATE TABLE t2(c1 BIGINT NULL); 354CREATE TABLE t3(c1 BIGINT NOT NULL); 355CREATE TABLE t4(c1 BIGINT NULL); 356INSERT INTO t2 (c1) VALUES(NULL); 357INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 358INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 359SELECT AVG(c1) AS value FROM t1; 360SELECT AVG(c1) AS value FROM t1 WHERE c1 <= 0; 361SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 362SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 363DROP TABLE t1,t2,t3,t4; 364CREATE TABLE t1(c1 TINYINT NOT NULL); 365CREATE TABLE t2(c1 TINYINT NULL); 366CREATE TABLE t3(c1 TINYINT NOT NULL); 367CREATE TABLE t4(c1 TINYINT NULL); 368INSERT INTO t2 (c1) VALUES(NULL); 369INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 370INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 371SELECT AVG(c1) AS value FROM t2; 372SELECT AVG(c1) AS value FROM t2 WHERE c1 <= 0; 373SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 374SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 375DROP TABLE t1,t2,t3,t4; 376CREATE TABLE t1(c1 SMALLINT NOT NULL); 377CREATE TABLE t2(c1 SMALLINT NULL); 378CREATE TABLE t3(c1 SMALLINT NOT NULL); 379CREATE TABLE t4(c1 SMALLINT NULL); 380INSERT INTO t2 (c1) VALUES(NULL); 381INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 382INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 383SELECT AVG(c1) AS value FROM t2; 384SELECT AVG(c1) AS value FROM t2 WHERE c1 <= 0; 385SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 386SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 387DROP TABLE t1,t2,t3,t4; 388CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 389CREATE TABLE t2(c1 MEDIUMINT NULL); 390CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 391CREATE TABLE t4(c1 MEDIUMINT NULL); 392INSERT INTO t2 (c1) VALUES(NULL); 393INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 394INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 395SELECT AVG(c1) AS value FROM t2; 396SELECT AVG(c1) AS value FROM t2 WHERE c1 <= 0; 397SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 398SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 399DROP TABLE t1,t2,t3,t4; 400CREATE TABLE t1(c1 INT NOT NULL); 401CREATE TABLE t2(c1 INT NULL); 402CREATE TABLE t3(c1 INT NOT NULL); 403CREATE TABLE t4(c1 INT NULL); 404INSERT INTO t2 (c1) VALUES(NULL); 405INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 406INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 407SELECT AVG(c1) AS value FROM t2; 408SELECT AVG(c1) AS value FROM t2 WHERE c1 <= 0; 409SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 410SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 411DROP TABLE t1,t2,t3,t4; 412CREATE TABLE t1(c1 INTEGER NOT NULL); 413CREATE TABLE t2(c1 INTEGER NULL); 414CREATE TABLE t3(c1 INTEGER NOT NULL); 415CREATE TABLE t4(c1 INTEGER NULL); 416INSERT INTO t2 (c1) VALUES(NULL); 417INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 418INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 419SELECT AVG(c1) AS value FROM t2; 420SELECT AVG(c1) AS value FROM t2 WHERE c1 <= 0; 421SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 422SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 423DROP TABLE t1,t2,t3,t4; 424CREATE TABLE t1(c1 BIGINT NOT NULL); 425CREATE TABLE t2(c1 BIGINT NULL); 426CREATE TABLE t3(c1 BIGINT NOT NULL); 427CREATE TABLE t4(c1 BIGINT NULL); 428INSERT INTO t2 (c1) VALUES(NULL); 429INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 430INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 431SELECT AVG(c1) AS value FROM t2; 432SELECT AVG(c1) AS value FROM t2 WHERE c1 <= 0; 433SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 434SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 435DROP TABLE t1,t2,t3,t4; 436CREATE TABLE t1(c1 TINYINT NOT NULL); 437CREATE TABLE t2(c1 TINYINT NULL); 438CREATE TABLE t3(c1 TINYINT NOT NULL); 439CREATE TABLE t4(c1 TINYINT NULL); 440INSERT INTO t2 (c1) VALUES(NULL); 441INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 442INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 443SELECT AVG(c1) AS value FROM t3; 444SELECT AVG(c1) AS value FROM t3 WHERE c1 <= 0; 445SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 446SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 447DROP TABLE t1,t2,t3,t4; 448CREATE TABLE t1(c1 SMALLINT NOT NULL); 449CREATE TABLE t2(c1 SMALLINT NULL); 450CREATE TABLE t3(c1 SMALLINT NOT NULL); 451CREATE TABLE t4(c1 SMALLINT NULL); 452INSERT INTO t2 (c1) VALUES(NULL); 453INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 454INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 455SELECT AVG(c1) AS value FROM t3; 456SELECT AVG(c1) AS value FROM t3 WHERE c1 <= 0; 457SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 458SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 459DROP TABLE t1,t2,t3,t4; 460CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 461CREATE TABLE t2(c1 MEDIUMINT NULL); 462CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 463CREATE TABLE t4(c1 MEDIUMINT NULL); 464INSERT INTO t2 (c1) VALUES(NULL); 465INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 466INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 467SELECT AVG(c1) AS value FROM t3; 468SELECT AVG(c1) AS value FROM t3 WHERE c1 <= 0; 469SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 470SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 471DROP TABLE t1,t2,t3,t4; 472CREATE TABLE t1(c1 INT NOT NULL); 473CREATE TABLE t2(c1 INT NULL); 474CREATE TABLE t3(c1 INT NOT NULL); 475CREATE TABLE t4(c1 INT NULL); 476INSERT INTO t2 (c1) VALUES(NULL); 477INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 478INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 479SELECT AVG(c1) AS value FROM t3; 480SELECT AVG(c1) AS value FROM t3 WHERE c1 <= 0; 481SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 482SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 483DROP TABLE t1,t2,t3,t4; 484CREATE TABLE t1(c1 INTEGER NOT NULL); 485CREATE TABLE t2(c1 INTEGER NULL); 486CREATE TABLE t3(c1 INTEGER NOT NULL); 487CREATE TABLE t4(c1 INTEGER NULL); 488INSERT INTO t2 (c1) VALUES(NULL); 489INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 490INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 491SELECT AVG(c1) AS value FROM t3; 492SELECT AVG(c1) AS value FROM t3 WHERE c1 <= 0; 493SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 494SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 495DROP TABLE t1,t2,t3,t4; 496CREATE TABLE t1(c1 BIGINT NOT NULL); 497CREATE TABLE t2(c1 BIGINT NULL); 498CREATE TABLE t3(c1 BIGINT NOT NULL); 499CREATE TABLE t4(c1 BIGINT NULL); 500INSERT INTO t2 (c1) VALUES(NULL); 501INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 502INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 503SELECT AVG(c1) AS value FROM t3; 504SELECT AVG(c1) AS value FROM t3 WHERE c1 <= 0; 505SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 506SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 507DROP TABLE t1,t2,t3,t4; 508CREATE TABLE t1(c1 TINYINT NOT NULL); 509CREATE TABLE t2(c1 TINYINT NULL); 510CREATE TABLE t3(c1 TINYINT NOT NULL); 511CREATE TABLE t4(c1 TINYINT NULL); 512INSERT INTO t2 (c1) VALUES(NULL); 513INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 514INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 515SELECT AVG(c1) AS value FROM t4; 516SELECT AVG(c1) AS value FROM t4 WHERE c1 <= 0; 517SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 518SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 519DROP TABLE t1,t2,t3,t4; 520CREATE TABLE t1(c1 SMALLINT NOT NULL); 521CREATE TABLE t2(c1 SMALLINT NULL); 522CREATE TABLE t3(c1 SMALLINT NOT NULL); 523CREATE TABLE t4(c1 SMALLINT NULL); 524INSERT INTO t2 (c1) VALUES(NULL); 525INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 526INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 527SELECT AVG(c1) AS value FROM t4; 528SELECT AVG(c1) AS value FROM t4 WHERE c1 <= 0; 529SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 530SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 531DROP TABLE t1,t2,t3,t4; 532CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 533CREATE TABLE t2(c1 MEDIUMINT NULL); 534CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 535CREATE TABLE t4(c1 MEDIUMINT NULL); 536INSERT INTO t2 (c1) VALUES(NULL); 537INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 538INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 539SELECT AVG(c1) AS value FROM t4; 540SELECT AVG(c1) AS value FROM t4 WHERE c1 <= 0; 541SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 542SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 543DROP TABLE t1,t2,t3,t4; 544CREATE TABLE t1(c1 INT NOT NULL); 545CREATE TABLE t2(c1 INT NULL); 546CREATE TABLE t3(c1 INT NOT NULL); 547CREATE TABLE t4(c1 INT NULL); 548INSERT INTO t2 (c1) VALUES(NULL); 549INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 550INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 551SELECT AVG(c1) AS value FROM t4; 552SELECT AVG(c1) AS value FROM t4 WHERE c1 <= 0; 553SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 554SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 555DROP TABLE t1,t2,t3,t4; 556CREATE TABLE t1(c1 INTEGER NOT NULL); 557CREATE TABLE t2(c1 INTEGER NULL); 558CREATE TABLE t3(c1 INTEGER NOT NULL); 559CREATE TABLE t4(c1 INTEGER NULL); 560INSERT INTO t2 (c1) VALUES(NULL); 561INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 562INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 563SELECT AVG(c1) AS value FROM t4; 564SELECT AVG(c1) AS value FROM t4 WHERE c1 <= 0; 565SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 566SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 567DROP TABLE t1,t2,t3,t4; 568CREATE TABLE t1(c1 BIGINT NOT NULL); 569CREATE TABLE t2(c1 BIGINT NULL); 570CREATE TABLE t3(c1 BIGINT NOT NULL); 571CREATE TABLE t4(c1 BIGINT NULL); 572INSERT INTO t2 (c1) VALUES(NULL); 573INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 574INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 575SELECT AVG(c1) AS value FROM t4; 576SELECT AVG(c1) AS value FROM t4 WHERE c1 <= 0; 577SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 578SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 579DROP TABLE t1,t2,t3,t4; 580CREATE TABLE t1(c1 TINYINT NOT NULL); 581CREATE TABLE t2(c1 TINYINT NULL); 582CREATE TABLE t3(c1 TINYINT NOT NULL); 583CREATE TABLE t4(c1 TINYINT NULL); 584INSERT INTO t2 (c1) VALUES(NULL); 585INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 586INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 587SELECT AVG(c1) AS value FROM t1; 588SELECT AVG(c1) AS value FROM t1 WHERE c1 = 0; 589SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 590SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 591DROP TABLE t1,t2,t3,t4; 592CREATE TABLE t1(c1 SMALLINT NOT NULL); 593CREATE TABLE t2(c1 SMALLINT NULL); 594CREATE TABLE t3(c1 SMALLINT NOT NULL); 595CREATE TABLE t4(c1 SMALLINT NULL); 596INSERT INTO t2 (c1) VALUES(NULL); 597INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 598INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 599SELECT AVG(c1) AS value FROM t1; 600SELECT AVG(c1) AS value FROM t1 WHERE c1 = 0; 601SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 602SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 603DROP TABLE t1,t2,t3,t4; 604CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 605CREATE TABLE t2(c1 MEDIUMINT NULL); 606CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 607CREATE TABLE t4(c1 MEDIUMINT NULL); 608INSERT INTO t2 (c1) VALUES(NULL); 609INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 610INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 611SELECT AVG(c1) AS value FROM t1; 612SELECT AVG(c1) AS value FROM t1 WHERE c1 = 0; 613SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 614SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 615DROP TABLE t1,t2,t3,t4; 616CREATE TABLE t1(c1 INT NOT NULL); 617CREATE TABLE t2(c1 INT NULL); 618CREATE TABLE t3(c1 INT NOT NULL); 619CREATE TABLE t4(c1 INT NULL); 620INSERT INTO t2 (c1) VALUES(NULL); 621INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 622INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 623SELECT AVG(c1) AS value FROM t1; 624SELECT AVG(c1) AS value FROM t1 WHERE c1 = 0; 625SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 626SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 627DROP TABLE t1,t2,t3,t4; 628CREATE TABLE t1(c1 INTEGER NOT NULL); 629CREATE TABLE t2(c1 INTEGER NULL); 630CREATE TABLE t3(c1 INTEGER NOT NULL); 631CREATE TABLE t4(c1 INTEGER NULL); 632INSERT INTO t2 (c1) VALUES(NULL); 633INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 634INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 635SELECT AVG(c1) AS value FROM t1; 636SELECT AVG(c1) AS value FROM t1 WHERE c1 = 0; 637SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 638SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 639DROP TABLE t1,t2,t3,t4; 640CREATE TABLE t1(c1 BIGINT NOT NULL); 641CREATE TABLE t2(c1 BIGINT NULL); 642CREATE TABLE t3(c1 BIGINT NOT NULL); 643CREATE TABLE t4(c1 BIGINT NULL); 644INSERT INTO t2 (c1) VALUES(NULL); 645INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 646INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 647SELECT AVG(c1) AS value FROM t1; 648SELECT AVG(c1) AS value FROM t1 WHERE c1 = 0; 649SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 650SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 651DROP TABLE t1,t2,t3,t4; 652CREATE TABLE t1(c1 TINYINT NOT NULL); 653CREATE TABLE t2(c1 TINYINT NULL); 654CREATE TABLE t3(c1 TINYINT NOT NULL); 655CREATE TABLE t4(c1 TINYINT NULL); 656INSERT INTO t2 (c1) VALUES(NULL); 657INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 658INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 659SELECT AVG(c1) AS value FROM t2; 660SELECT AVG(c1) AS value FROM t2 WHERE c1 = 0; 661SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 662SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 663DROP TABLE t1,t2,t3,t4; 664CREATE TABLE t1(c1 SMALLINT NOT NULL); 665CREATE TABLE t2(c1 SMALLINT NULL); 666CREATE TABLE t3(c1 SMALLINT NOT NULL); 667CREATE TABLE t4(c1 SMALLINT NULL); 668INSERT INTO t2 (c1) VALUES(NULL); 669INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 670INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 671SELECT AVG(c1) AS value FROM t2; 672SELECT AVG(c1) AS value FROM t2 WHERE c1 = 0; 673SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 674SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 675DROP TABLE t1,t2,t3,t4; 676CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 677CREATE TABLE t2(c1 MEDIUMINT NULL); 678CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 679CREATE TABLE t4(c1 MEDIUMINT NULL); 680INSERT INTO t2 (c1) VALUES(NULL); 681INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 682INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 683SELECT AVG(c1) AS value FROM t2; 684SELECT AVG(c1) AS value FROM t2 WHERE c1 = 0; 685SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 686SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 687DROP TABLE t1,t2,t3,t4; 688CREATE TABLE t1(c1 INT NOT NULL); 689CREATE TABLE t2(c1 INT NULL); 690CREATE TABLE t3(c1 INT NOT NULL); 691CREATE TABLE t4(c1 INT NULL); 692INSERT INTO t2 (c1) VALUES(NULL); 693INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 694INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 695SELECT AVG(c1) AS value FROM t2; 696SELECT AVG(c1) AS value FROM t2 WHERE c1 = 0; 697SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 698SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 699DROP TABLE t1,t2,t3,t4; 700CREATE TABLE t1(c1 INTEGER NOT NULL); 701CREATE TABLE t2(c1 INTEGER NULL); 702CREATE TABLE t3(c1 INTEGER NOT NULL); 703CREATE TABLE t4(c1 INTEGER NULL); 704INSERT INTO t2 (c1) VALUES(NULL); 705INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 706INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 707SELECT AVG(c1) AS value FROM t2; 708SELECT AVG(c1) AS value FROM t2 WHERE c1 = 0; 709SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 710SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 711DROP TABLE t1,t2,t3,t4; 712CREATE TABLE t1(c1 BIGINT NOT NULL); 713CREATE TABLE t2(c1 BIGINT NULL); 714CREATE TABLE t3(c1 BIGINT NOT NULL); 715CREATE TABLE t4(c1 BIGINT NULL); 716INSERT INTO t2 (c1) VALUES(NULL); 717INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 718INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 719SELECT AVG(c1) AS value FROM t2; 720SELECT AVG(c1) AS value FROM t2 WHERE c1 = 0; 721SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 722SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 723DROP TABLE t1,t2,t3,t4; 724CREATE TABLE t1(c1 TINYINT NOT NULL); 725CREATE TABLE t2(c1 TINYINT NULL); 726CREATE TABLE t3(c1 TINYINT NOT NULL); 727CREATE TABLE t4(c1 TINYINT NULL); 728INSERT INTO t2 (c1) VALUES(NULL); 729INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 730INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 731SELECT AVG(c1) AS value FROM t3; 732SELECT AVG(c1) AS value FROM t3 WHERE c1 = 0; 733SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 734SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 735DROP TABLE t1,t2,t3,t4; 736CREATE TABLE t1(c1 SMALLINT NOT NULL); 737CREATE TABLE t2(c1 SMALLINT NULL); 738CREATE TABLE t3(c1 SMALLINT NOT NULL); 739CREATE TABLE t4(c1 SMALLINT NULL); 740INSERT INTO t2 (c1) VALUES(NULL); 741INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 742INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 743SELECT AVG(c1) AS value FROM t3; 744SELECT AVG(c1) AS value FROM t3 WHERE c1 = 0; 745SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 746SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 747DROP TABLE t1,t2,t3,t4; 748CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 749CREATE TABLE t2(c1 MEDIUMINT NULL); 750CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 751CREATE TABLE t4(c1 MEDIUMINT NULL); 752INSERT INTO t2 (c1) VALUES(NULL); 753INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 754INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 755SELECT AVG(c1) AS value FROM t3; 756SELECT AVG(c1) AS value FROM t3 WHERE c1 = 0; 757SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 758SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 759DROP TABLE t1,t2,t3,t4; 760CREATE TABLE t1(c1 INT NOT NULL); 761CREATE TABLE t2(c1 INT NULL); 762CREATE TABLE t3(c1 INT NOT NULL); 763CREATE TABLE t4(c1 INT NULL); 764INSERT INTO t2 (c1) VALUES(NULL); 765INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 766INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 767SELECT AVG(c1) AS value FROM t3; 768SELECT AVG(c1) AS value FROM t3 WHERE c1 = 0; 769SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 770SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 771DROP TABLE t1,t2,t3,t4; 772CREATE TABLE t1(c1 INTEGER NOT NULL); 773CREATE TABLE t2(c1 INTEGER NULL); 774CREATE TABLE t3(c1 INTEGER NOT NULL); 775CREATE TABLE t4(c1 INTEGER NULL); 776INSERT INTO t2 (c1) VALUES(NULL); 777INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 778INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 779SELECT AVG(c1) AS value FROM t3; 780SELECT AVG(c1) AS value FROM t3 WHERE c1 = 0; 781SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 782SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 783DROP TABLE t1,t2,t3,t4; 784CREATE TABLE t1(c1 BIGINT NOT NULL); 785CREATE TABLE t2(c1 BIGINT NULL); 786CREATE TABLE t3(c1 BIGINT NOT NULL); 787CREATE TABLE t4(c1 BIGINT NULL); 788INSERT INTO t2 (c1) VALUES(NULL); 789INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 790INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 791SELECT AVG(c1) AS value FROM t3; 792SELECT AVG(c1) AS value FROM t3 WHERE c1 = 0; 793SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 794SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 795DROP TABLE t1,t2,t3,t4; 796CREATE TABLE t1(c1 TINYINT NOT NULL); 797CREATE TABLE t2(c1 TINYINT NULL); 798CREATE TABLE t3(c1 TINYINT NOT NULL); 799CREATE TABLE t4(c1 TINYINT NULL); 800INSERT INTO t2 (c1) VALUES(NULL); 801INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 802INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 803SELECT AVG(c1) AS value FROM t4; 804SELECT AVG(c1) AS value FROM t4 WHERE c1 = 0; 805SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 806SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 807DROP TABLE t1,t2,t3,t4; 808CREATE TABLE t1(c1 SMALLINT NOT NULL); 809CREATE TABLE t2(c1 SMALLINT NULL); 810CREATE TABLE t3(c1 SMALLINT NOT NULL); 811CREATE TABLE t4(c1 SMALLINT NULL); 812INSERT INTO t2 (c1) VALUES(NULL); 813INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 814INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 815SELECT AVG(c1) AS value FROM t4; 816SELECT AVG(c1) AS value FROM t4 WHERE c1 = 0; 817SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 818SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 819DROP TABLE t1,t2,t3,t4; 820CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 821CREATE TABLE t2(c1 MEDIUMINT NULL); 822CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 823CREATE TABLE t4(c1 MEDIUMINT NULL); 824INSERT INTO t2 (c1) VALUES(NULL); 825INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 826INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 827SELECT AVG(c1) AS value FROM t4; 828SELECT AVG(c1) AS value FROM t4 WHERE c1 = 0; 829SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 830SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 831DROP TABLE t1,t2,t3,t4; 832CREATE TABLE t1(c1 INT NOT NULL); 833CREATE TABLE t2(c1 INT NULL); 834CREATE TABLE t3(c1 INT NOT NULL); 835CREATE TABLE t4(c1 INT NULL); 836INSERT INTO t2 (c1) VALUES(NULL); 837INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 838INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 839SELECT AVG(c1) AS value FROM t4; 840SELECT AVG(c1) AS value FROM t4 WHERE c1 = 0; 841SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 842SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 843DROP TABLE t1,t2,t3,t4; 844CREATE TABLE t1(c1 INTEGER NOT NULL); 845CREATE TABLE t2(c1 INTEGER NULL); 846CREATE TABLE t3(c1 INTEGER NOT NULL); 847CREATE TABLE t4(c1 INTEGER NULL); 848INSERT INTO t2 (c1) VALUES(NULL); 849INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 850INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 851SELECT AVG(c1) AS value FROM t4; 852SELECT AVG(c1) AS value FROM t4 WHERE c1 = 0; 853SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 854SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 855DROP TABLE t1,t2,t3,t4; 856CREATE TABLE t1(c1 BIGINT NOT NULL); 857CREATE TABLE t2(c1 BIGINT NULL); 858CREATE TABLE t3(c1 BIGINT NOT NULL); 859CREATE TABLE t4(c1 BIGINT NULL); 860INSERT INTO t2 (c1) VALUES(NULL); 861INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 862INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 863SELECT AVG(c1) AS value FROM t4; 864SELECT AVG(c1) AS value FROM t4 WHERE c1 = 0; 865SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 866SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 867DROP TABLE t1,t2,t3,t4; 868CREATE TABLE t1(c1 TINYINT NOT NULL); 869CREATE TABLE t2(c1 TINYINT NULL); 870CREATE TABLE t3(c1 TINYINT NOT NULL); 871CREATE TABLE t4(c1 TINYINT NULL); 872INSERT INTO t2 (c1) VALUES(NULL); 873INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 874INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 875SELECT AVG(c1) AS value FROM t1; 876SELECT AVG(c1) AS value FROM t1 WHERE c1 >= 0; 877SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 878SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 879DROP TABLE t1,t2,t3,t4; 880CREATE TABLE t1(c1 SMALLINT NOT NULL); 881CREATE TABLE t2(c1 SMALLINT NULL); 882CREATE TABLE t3(c1 SMALLINT NOT NULL); 883CREATE TABLE t4(c1 SMALLINT NULL); 884INSERT INTO t2 (c1) VALUES(NULL); 885INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 886INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 887SELECT AVG(c1) AS value FROM t1; 888SELECT AVG(c1) AS value FROM t1 WHERE c1 >= 0; 889SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 890SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 891DROP TABLE t1,t2,t3,t4; 892CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 893CREATE TABLE t2(c1 MEDIUMINT NULL); 894CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 895CREATE TABLE t4(c1 MEDIUMINT NULL); 896INSERT INTO t2 (c1) VALUES(NULL); 897INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 898INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 899SELECT AVG(c1) AS value FROM t1; 900SELECT AVG(c1) AS value FROM t1 WHERE c1 >= 0; 901SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 902SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 903DROP TABLE t1,t2,t3,t4; 904CREATE TABLE t1(c1 INT NOT NULL); 905CREATE TABLE t2(c1 INT NULL); 906CREATE TABLE t3(c1 INT NOT NULL); 907CREATE TABLE t4(c1 INT NULL); 908INSERT INTO t2 (c1) VALUES(NULL); 909INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 910INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 911SELECT AVG(c1) AS value FROM t1; 912SELECT AVG(c1) AS value FROM t1 WHERE c1 >= 0; 913SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 914SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 915DROP TABLE t1,t2,t3,t4; 916CREATE TABLE t1(c1 INTEGER NOT NULL); 917CREATE TABLE t2(c1 INTEGER NULL); 918CREATE TABLE t3(c1 INTEGER NOT NULL); 919CREATE TABLE t4(c1 INTEGER NULL); 920INSERT INTO t2 (c1) VALUES(NULL); 921INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 922INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 923SELECT AVG(c1) AS value FROM t1; 924SELECT AVG(c1) AS value FROM t1 WHERE c1 >= 0; 925SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 926SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 927DROP TABLE t1,t2,t3,t4; 928CREATE TABLE t1(c1 BIGINT NOT NULL); 929CREATE TABLE t2(c1 BIGINT NULL); 930CREATE TABLE t3(c1 BIGINT NOT NULL); 931CREATE TABLE t4(c1 BIGINT NULL); 932INSERT INTO t2 (c1) VALUES(NULL); 933INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 934INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 935SELECT AVG(c1) AS value FROM t1; 936SELECT AVG(c1) AS value FROM t1 WHERE c1 >= 0; 937SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 938SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 939DROP TABLE t1,t2,t3,t4; 940CREATE TABLE t1(c1 TINYINT NOT NULL); 941CREATE TABLE t2(c1 TINYINT NULL); 942CREATE TABLE t3(c1 TINYINT NOT NULL); 943CREATE TABLE t4(c1 TINYINT NULL); 944INSERT INTO t2 (c1) VALUES(NULL); 945INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 946INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 947SELECT AVG(c1) AS value FROM t2; 948SELECT AVG(c1) AS value FROM t2 WHERE c1 >= 0; 949SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 950SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 951DROP TABLE t1,t2,t3,t4; 952CREATE TABLE t1(c1 SMALLINT NOT NULL); 953CREATE TABLE t2(c1 SMALLINT NULL); 954CREATE TABLE t3(c1 SMALLINT NOT NULL); 955CREATE TABLE t4(c1 SMALLINT NULL); 956INSERT INTO t2 (c1) VALUES(NULL); 957INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 958INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 959SELECT AVG(c1) AS value FROM t2; 960SELECT AVG(c1) AS value FROM t2 WHERE c1 >= 0; 961SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 962SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 963DROP TABLE t1,t2,t3,t4; 964CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 965CREATE TABLE t2(c1 MEDIUMINT NULL); 966CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 967CREATE TABLE t4(c1 MEDIUMINT NULL); 968INSERT INTO t2 (c1) VALUES(NULL); 969INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 970INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 971SELECT AVG(c1) AS value FROM t2; 972SELECT AVG(c1) AS value FROM t2 WHERE c1 >= 0; 973SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 974SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 975DROP TABLE t1,t2,t3,t4; 976CREATE TABLE t1(c1 INT NOT NULL); 977CREATE TABLE t2(c1 INT NULL); 978CREATE TABLE t3(c1 INT NOT NULL); 979CREATE TABLE t4(c1 INT NULL); 980INSERT INTO t2 (c1) VALUES(NULL); 981INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 982INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 983SELECT AVG(c1) AS value FROM t2; 984SELECT AVG(c1) AS value FROM t2 WHERE c1 >= 0; 985SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 986SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 987DROP TABLE t1,t2,t3,t4; 988CREATE TABLE t1(c1 INTEGER NOT NULL); 989CREATE TABLE t2(c1 INTEGER NULL); 990CREATE TABLE t3(c1 INTEGER NOT NULL); 991CREATE TABLE t4(c1 INTEGER NULL); 992INSERT INTO t2 (c1) VALUES(NULL); 993INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 994INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 995SELECT AVG(c1) AS value FROM t2; 996SELECT AVG(c1) AS value FROM t2 WHERE c1 >= 0; 997SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 998SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 999DROP TABLE t1,t2,t3,t4; 1000CREATE TABLE t1(c1 BIGINT NOT NULL); 1001CREATE TABLE t2(c1 BIGINT NULL); 1002CREATE TABLE t3(c1 BIGINT NOT NULL); 1003CREATE TABLE t4(c1 BIGINT NULL); 1004INSERT INTO t2 (c1) VALUES(NULL); 1005INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1006INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1007SELECT AVG(c1) AS value FROM t2; 1008SELECT AVG(c1) AS value FROM t2 WHERE c1 >= 0; 1009SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 1010SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 1011DROP TABLE t1,t2,t3,t4; 1012CREATE TABLE t1(c1 TINYINT NOT NULL); 1013CREATE TABLE t2(c1 TINYINT NULL); 1014CREATE TABLE t3(c1 TINYINT NOT NULL); 1015CREATE TABLE t4(c1 TINYINT NULL); 1016INSERT INTO t2 (c1) VALUES(NULL); 1017INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1018INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1019SELECT AVG(c1) AS value FROM t3; 1020SELECT AVG(c1) AS value FROM t3 WHERE c1 >= 0; 1021SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1022SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1023DROP TABLE t1,t2,t3,t4; 1024CREATE TABLE t1(c1 SMALLINT NOT NULL); 1025CREATE TABLE t2(c1 SMALLINT NULL); 1026CREATE TABLE t3(c1 SMALLINT NOT NULL); 1027CREATE TABLE t4(c1 SMALLINT NULL); 1028INSERT INTO t2 (c1) VALUES(NULL); 1029INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1030INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1031SELECT AVG(c1) AS value FROM t3; 1032SELECT AVG(c1) AS value FROM t3 WHERE c1 >= 0; 1033SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1034SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1035DROP TABLE t1,t2,t3,t4; 1036CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1037CREATE TABLE t2(c1 MEDIUMINT NULL); 1038CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 1039CREATE TABLE t4(c1 MEDIUMINT NULL); 1040INSERT INTO t2 (c1) VALUES(NULL); 1041INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1042INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1043SELECT AVG(c1) AS value FROM t3; 1044SELECT AVG(c1) AS value FROM t3 WHERE c1 >= 0; 1045SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1046SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1047DROP TABLE t1,t2,t3,t4; 1048CREATE TABLE t1(c1 INT NOT NULL); 1049CREATE TABLE t2(c1 INT NULL); 1050CREATE TABLE t3(c1 INT NOT NULL); 1051CREATE TABLE t4(c1 INT NULL); 1052INSERT INTO t2 (c1) VALUES(NULL); 1053INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1054INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1055SELECT AVG(c1) AS value FROM t3; 1056SELECT AVG(c1) AS value FROM t3 WHERE c1 >= 0; 1057SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1058SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1059DROP TABLE t1,t2,t3,t4; 1060CREATE TABLE t1(c1 INTEGER NOT NULL); 1061CREATE TABLE t2(c1 INTEGER NULL); 1062CREATE TABLE t3(c1 INTEGER NOT NULL); 1063CREATE TABLE t4(c1 INTEGER NULL); 1064INSERT INTO t2 (c1) VALUES(NULL); 1065INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1066INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1067SELECT AVG(c1) AS value FROM t3; 1068SELECT AVG(c1) AS value FROM t3 WHERE c1 >= 0; 1069SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1070SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1071DROP TABLE t1,t2,t3,t4; 1072CREATE TABLE t1(c1 BIGINT NOT NULL); 1073CREATE TABLE t2(c1 BIGINT NULL); 1074CREATE TABLE t3(c1 BIGINT NOT NULL); 1075CREATE TABLE t4(c1 BIGINT NULL); 1076INSERT INTO t2 (c1) VALUES(NULL); 1077INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1078INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1079SELECT AVG(c1) AS value FROM t3; 1080SELECT AVG(c1) AS value FROM t3 WHERE c1 >= 0; 1081SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1082SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1083DROP TABLE t1,t2,t3,t4; 1084CREATE TABLE t1(c1 TINYINT NOT NULL); 1085CREATE TABLE t2(c1 TINYINT NULL); 1086CREATE TABLE t3(c1 TINYINT NOT NULL); 1087CREATE TABLE t4(c1 TINYINT NULL); 1088INSERT INTO t2 (c1) VALUES(NULL); 1089INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1090INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1091SELECT AVG(c1) AS value FROM t4; 1092SELECT AVG(c1) AS value FROM t4 WHERE c1 >= 0; 1093SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1094SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1095DROP TABLE t1,t2,t3,t4; 1096CREATE TABLE t1(c1 SMALLINT NOT NULL); 1097CREATE TABLE t2(c1 SMALLINT NULL); 1098CREATE TABLE t3(c1 SMALLINT NOT NULL); 1099CREATE TABLE t4(c1 SMALLINT NULL); 1100INSERT INTO t2 (c1) VALUES(NULL); 1101INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1102INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1103SELECT AVG(c1) AS value FROM t4; 1104SELECT AVG(c1) AS value FROM t4 WHERE c1 >= 0; 1105SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1106SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1107DROP TABLE t1,t2,t3,t4; 1108CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1109CREATE TABLE t2(c1 MEDIUMINT NULL); 1110CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 1111CREATE TABLE t4(c1 MEDIUMINT NULL); 1112INSERT INTO t2 (c1) VALUES(NULL); 1113INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1114INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1115SELECT AVG(c1) AS value FROM t4; 1116SELECT AVG(c1) AS value FROM t4 WHERE c1 >= 0; 1117SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1118SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1119DROP TABLE t1,t2,t3,t4; 1120CREATE TABLE t1(c1 INT NOT NULL); 1121CREATE TABLE t2(c1 INT NULL); 1122CREATE TABLE t3(c1 INT NOT NULL); 1123CREATE TABLE t4(c1 INT NULL); 1124INSERT INTO t2 (c1) VALUES(NULL); 1125INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1126INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1127SELECT AVG(c1) AS value FROM t4; 1128SELECT AVG(c1) AS value FROM t4 WHERE c1 >= 0; 1129SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1130SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1131DROP TABLE t1,t2,t3,t4; 1132CREATE TABLE t1(c1 INTEGER NOT NULL); 1133CREATE TABLE t2(c1 INTEGER NULL); 1134CREATE TABLE t3(c1 INTEGER NOT NULL); 1135CREATE TABLE t4(c1 INTEGER NULL); 1136INSERT INTO t2 (c1) VALUES(NULL); 1137INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1138INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1139SELECT AVG(c1) AS value FROM t4; 1140SELECT AVG(c1) AS value FROM t4 WHERE c1 >= 0; 1141SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1142SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1143DROP TABLE t1,t2,t3,t4; 1144CREATE TABLE t1(c1 BIGINT NOT NULL); 1145CREATE TABLE t2(c1 BIGINT NULL); 1146CREATE TABLE t3(c1 BIGINT NOT NULL); 1147CREATE TABLE t4(c1 BIGINT NULL); 1148INSERT INTO t2 (c1) VALUES(NULL); 1149INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1150INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1151SELECT AVG(c1) AS value FROM t4; 1152SELECT AVG(c1) AS value FROM t4 WHERE c1 >= 0; 1153SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1154SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1155DROP TABLE t1,t2,t3,t4; 1156CREATE TABLE t1(c1 TINYINT NOT NULL); 1157CREATE TABLE t2(c1 TINYINT NULL); 1158CREATE TABLE t3(c1 TINYINT NOT NULL); 1159CREATE TABLE t4(c1 TINYINT NULL); 1160INSERT INTO t2 (c1) VALUES(NULL); 1161INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1162INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1163SELECT AVG(c1) AS value FROM t1; 1164SELECT AVG(c1) AS value FROM t1 WHERE c1 != 0; 1165SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 1166SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 1167DROP TABLE t1,t2,t3,t4; 1168CREATE TABLE t1(c1 SMALLINT NOT NULL); 1169CREATE TABLE t2(c1 SMALLINT NULL); 1170CREATE TABLE t3(c1 SMALLINT NOT NULL); 1171CREATE TABLE t4(c1 SMALLINT NULL); 1172INSERT INTO t2 (c1) VALUES(NULL); 1173INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1174INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1175SELECT AVG(c1) AS value FROM t1; 1176SELECT AVG(c1) AS value FROM t1 WHERE c1 != 0; 1177SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 1178SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 1179DROP TABLE t1,t2,t3,t4; 1180CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1181CREATE TABLE t2(c1 MEDIUMINT NULL); 1182CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 1183CREATE TABLE t4(c1 MEDIUMINT NULL); 1184INSERT INTO t2 (c1) VALUES(NULL); 1185INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1186INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1187SELECT AVG(c1) AS value FROM t1; 1188SELECT AVG(c1) AS value FROM t1 WHERE c1 != 0; 1189SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 1190SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 1191DROP TABLE t1,t2,t3,t4; 1192CREATE TABLE t1(c1 INT NOT NULL); 1193CREATE TABLE t2(c1 INT NULL); 1194CREATE TABLE t3(c1 INT NOT NULL); 1195CREATE TABLE t4(c1 INT NULL); 1196INSERT INTO t2 (c1) VALUES(NULL); 1197INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1198INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1199SELECT AVG(c1) AS value FROM t1; 1200SELECT AVG(c1) AS value FROM t1 WHERE c1 != 0; 1201SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 1202SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 1203DROP TABLE t1,t2,t3,t4; 1204CREATE TABLE t1(c1 INTEGER NOT NULL); 1205CREATE TABLE t2(c1 INTEGER NULL); 1206CREATE TABLE t3(c1 INTEGER NOT NULL); 1207CREATE TABLE t4(c1 INTEGER NULL); 1208INSERT INTO t2 (c1) VALUES(NULL); 1209INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1210INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1211SELECT AVG(c1) AS value FROM t1; 1212SELECT AVG(c1) AS value FROM t1 WHERE c1 != 0; 1213SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 1214SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 1215DROP TABLE t1,t2,t3,t4; 1216CREATE TABLE t1(c1 BIGINT NOT NULL); 1217CREATE TABLE t2(c1 BIGINT NULL); 1218CREATE TABLE t3(c1 BIGINT NOT NULL); 1219CREATE TABLE t4(c1 BIGINT NULL); 1220INSERT INTO t2 (c1) VALUES(NULL); 1221INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1222INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1223SELECT AVG(c1) AS value FROM t1; 1224SELECT AVG(c1) AS value FROM t1 WHERE c1 != 0; 1225SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 1226SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 1227DROP TABLE t1,t2,t3,t4; 1228CREATE TABLE t1(c1 TINYINT NOT NULL); 1229CREATE TABLE t2(c1 TINYINT NULL); 1230CREATE TABLE t3(c1 TINYINT NOT NULL); 1231CREATE TABLE t4(c1 TINYINT NULL); 1232INSERT INTO t2 (c1) VALUES(NULL); 1233INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1234INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1235SELECT AVG(c1) AS value FROM t2; 1236SELECT AVG(c1) AS value FROM t2 WHERE c1 != 0; 1237SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 1238SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 1239DROP TABLE t1,t2,t3,t4; 1240CREATE TABLE t1(c1 SMALLINT NOT NULL); 1241CREATE TABLE t2(c1 SMALLINT NULL); 1242CREATE TABLE t3(c1 SMALLINT NOT NULL); 1243CREATE TABLE t4(c1 SMALLINT NULL); 1244INSERT INTO t2 (c1) VALUES(NULL); 1245INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1246INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1247SELECT AVG(c1) AS value FROM t2; 1248SELECT AVG(c1) AS value FROM t2 WHERE c1 != 0; 1249SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 1250SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 1251DROP TABLE t1,t2,t3,t4; 1252CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1253CREATE TABLE t2(c1 MEDIUMINT NULL); 1254CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 1255CREATE TABLE t4(c1 MEDIUMINT NULL); 1256INSERT INTO t2 (c1) VALUES(NULL); 1257INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1258INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1259SELECT AVG(c1) AS value FROM t2; 1260SELECT AVG(c1) AS value FROM t2 WHERE c1 != 0; 1261SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 1262SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 1263DROP TABLE t1,t2,t3,t4; 1264CREATE TABLE t1(c1 INT NOT NULL); 1265CREATE TABLE t2(c1 INT NULL); 1266CREATE TABLE t3(c1 INT NOT NULL); 1267CREATE TABLE t4(c1 INT NULL); 1268INSERT INTO t2 (c1) VALUES(NULL); 1269INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1270INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1271SELECT AVG(c1) AS value FROM t2; 1272SELECT AVG(c1) AS value FROM t2 WHERE c1 != 0; 1273SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 1274SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 1275DROP TABLE t1,t2,t3,t4; 1276CREATE TABLE t1(c1 INTEGER NOT NULL); 1277CREATE TABLE t2(c1 INTEGER NULL); 1278CREATE TABLE t3(c1 INTEGER NOT NULL); 1279CREATE TABLE t4(c1 INTEGER NULL); 1280INSERT INTO t2 (c1) VALUES(NULL); 1281INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1282INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1283SELECT AVG(c1) AS value FROM t2; 1284SELECT AVG(c1) AS value FROM t2 WHERE c1 != 0; 1285SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 1286SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 1287DROP TABLE t1,t2,t3,t4; 1288CREATE TABLE t1(c1 BIGINT NOT NULL); 1289CREATE TABLE t2(c1 BIGINT NULL); 1290CREATE TABLE t3(c1 BIGINT NOT NULL); 1291CREATE TABLE t4(c1 BIGINT NULL); 1292INSERT INTO t2 (c1) VALUES(NULL); 1293INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1294INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1295SELECT AVG(c1) AS value FROM t2; 1296SELECT AVG(c1) AS value FROM t2 WHERE c1 != 0; 1297SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 1298SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 1299DROP TABLE t1,t2,t3,t4; 1300CREATE TABLE t1(c1 TINYINT NOT NULL); 1301CREATE TABLE t2(c1 TINYINT NULL); 1302CREATE TABLE t3(c1 TINYINT NOT NULL); 1303CREATE TABLE t4(c1 TINYINT NULL); 1304INSERT INTO t2 (c1) VALUES(NULL); 1305INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1306INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1307SELECT AVG(c1) AS value FROM t3; 1308SELECT AVG(c1) AS value FROM t3 WHERE c1 != 0; 1309SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1310SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1311DROP TABLE t1,t2,t3,t4; 1312CREATE TABLE t1(c1 SMALLINT NOT NULL); 1313CREATE TABLE t2(c1 SMALLINT NULL); 1314CREATE TABLE t3(c1 SMALLINT NOT NULL); 1315CREATE TABLE t4(c1 SMALLINT NULL); 1316INSERT INTO t2 (c1) VALUES(NULL); 1317INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1318INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1319SELECT AVG(c1) AS value FROM t3; 1320SELECT AVG(c1) AS value FROM t3 WHERE c1 != 0; 1321SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1322SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1323DROP TABLE t1,t2,t3,t4; 1324CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1325CREATE TABLE t2(c1 MEDIUMINT NULL); 1326CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 1327CREATE TABLE t4(c1 MEDIUMINT NULL); 1328INSERT INTO t2 (c1) VALUES(NULL); 1329INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1330INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1331SELECT AVG(c1) AS value FROM t3; 1332SELECT AVG(c1) AS value FROM t3 WHERE c1 != 0; 1333SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1334SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1335DROP TABLE t1,t2,t3,t4; 1336CREATE TABLE t1(c1 INT NOT NULL); 1337CREATE TABLE t2(c1 INT NULL); 1338CREATE TABLE t3(c1 INT NOT NULL); 1339CREATE TABLE t4(c1 INT NULL); 1340INSERT INTO t2 (c1) VALUES(NULL); 1341INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1342INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1343SELECT AVG(c1) AS value FROM t3; 1344SELECT AVG(c1) AS value FROM t3 WHERE c1 != 0; 1345SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1346SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1347DROP TABLE t1,t2,t3,t4; 1348CREATE TABLE t1(c1 INTEGER NOT NULL); 1349CREATE TABLE t2(c1 INTEGER NULL); 1350CREATE TABLE t3(c1 INTEGER NOT NULL); 1351CREATE TABLE t4(c1 INTEGER NULL); 1352INSERT INTO t2 (c1) VALUES(NULL); 1353INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1354INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1355SELECT AVG(c1) AS value FROM t3; 1356SELECT AVG(c1) AS value FROM t3 WHERE c1 != 0; 1357SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1358SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1359DROP TABLE t1,t2,t3,t4; 1360CREATE TABLE t1(c1 BIGINT NOT NULL); 1361CREATE TABLE t2(c1 BIGINT NULL); 1362CREATE TABLE t3(c1 BIGINT NOT NULL); 1363CREATE TABLE t4(c1 BIGINT NULL); 1364INSERT INTO t2 (c1) VALUES(NULL); 1365INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1366INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1367SELECT AVG(c1) AS value FROM t3; 1368SELECT AVG(c1) AS value FROM t3 WHERE c1 != 0; 1369SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1370SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1371DROP TABLE t1,t2,t3,t4; 1372CREATE TABLE t1(c1 TINYINT NOT NULL); 1373CREATE TABLE t2(c1 TINYINT NULL); 1374CREATE TABLE t3(c1 TINYINT NOT NULL); 1375CREATE TABLE t4(c1 TINYINT NULL); 1376INSERT INTO t2 (c1) VALUES(NULL); 1377INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1378INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1379SELECT AVG(c1) AS value FROM t4; 1380SELECT AVG(c1) AS value FROM t4 WHERE c1 != 0; 1381SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1382SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1383DROP TABLE t1,t2,t3,t4; 1384CREATE TABLE t1(c1 SMALLINT NOT NULL); 1385CREATE TABLE t2(c1 SMALLINT NULL); 1386CREATE TABLE t3(c1 SMALLINT NOT NULL); 1387CREATE TABLE t4(c1 SMALLINT NULL); 1388INSERT INTO t2 (c1) VALUES(NULL); 1389INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1390INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1391SELECT AVG(c1) AS value FROM t4; 1392SELECT AVG(c1) AS value FROM t4 WHERE c1 != 0; 1393SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1394SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1395DROP TABLE t1,t2,t3,t4; 1396CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1397CREATE TABLE t2(c1 MEDIUMINT NULL); 1398CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 1399CREATE TABLE t4(c1 MEDIUMINT NULL); 1400INSERT INTO t2 (c1) VALUES(NULL); 1401INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1402INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1403SELECT AVG(c1) AS value FROM t4; 1404SELECT AVG(c1) AS value FROM t4 WHERE c1 != 0; 1405SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1406SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1407DROP TABLE t1,t2,t3,t4; 1408CREATE TABLE t1(c1 INT NOT NULL); 1409CREATE TABLE t2(c1 INT NULL); 1410CREATE TABLE t3(c1 INT NOT NULL); 1411CREATE TABLE t4(c1 INT NULL); 1412INSERT INTO t2 (c1) VALUES(NULL); 1413INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1414INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1415SELECT AVG(c1) AS value FROM t4; 1416SELECT AVG(c1) AS value FROM t4 WHERE c1 != 0; 1417SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1418SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1419DROP TABLE t1,t2,t3,t4; 1420CREATE TABLE t1(c1 INTEGER NOT NULL); 1421CREATE TABLE t2(c1 INTEGER NULL); 1422CREATE TABLE t3(c1 INTEGER NOT NULL); 1423CREATE TABLE t4(c1 INTEGER NULL); 1424INSERT INTO t2 (c1) VALUES(NULL); 1425INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1426INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1427SELECT AVG(c1) AS value FROM t4; 1428SELECT AVG(c1) AS value FROM t4 WHERE c1 != 0; 1429SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1430SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1431DROP TABLE t1,t2,t3,t4; 1432CREATE TABLE t1(c1 BIGINT NOT NULL); 1433CREATE TABLE t2(c1 BIGINT NULL); 1434CREATE TABLE t3(c1 BIGINT NOT NULL); 1435CREATE TABLE t4(c1 BIGINT NULL); 1436INSERT INTO t2 (c1) VALUES(NULL); 1437INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1438INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1439SELECT AVG(c1) AS value FROM t4; 1440SELECT AVG(c1) AS value FROM t4 WHERE c1 != 0; 1441SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1442SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1443DROP TABLE t1,t2,t3,t4; 1444CREATE TABLE t1(c1 TINYINT NOT NULL); 1445CREATE TABLE t2(c1 TINYINT NULL); 1446CREATE TABLE t3(c1 TINYINT NOT NULL); 1447CREATE TABLE t4(c1 TINYINT NULL); 1448INSERT INTO t2 (c1) VALUES(NULL); 1449INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1450INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1451SELECT AVG(c1) AS value FROM t1; 1452SELECT AVG(c1) AS value FROM t1 WHERE c1 <> 0; 1453SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 1454SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 1455DROP TABLE t1,t2,t3,t4; 1456CREATE TABLE t1(c1 SMALLINT NOT NULL); 1457CREATE TABLE t2(c1 SMALLINT NULL); 1458CREATE TABLE t3(c1 SMALLINT NOT NULL); 1459CREATE TABLE t4(c1 SMALLINT NULL); 1460INSERT INTO t2 (c1) VALUES(NULL); 1461INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1462INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1463SELECT AVG(c1) AS value FROM t1; 1464SELECT AVG(c1) AS value FROM t1 WHERE c1 <> 0; 1465SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 1466SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 1467DROP TABLE t1,t2,t3,t4; 1468CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1469CREATE TABLE t2(c1 MEDIUMINT NULL); 1470CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 1471CREATE TABLE t4(c1 MEDIUMINT NULL); 1472INSERT INTO t2 (c1) VALUES(NULL); 1473INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1474INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1475SELECT AVG(c1) AS value FROM t1; 1476SELECT AVG(c1) AS value FROM t1 WHERE c1 <> 0; 1477SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 1478SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 1479DROP TABLE t1,t2,t3,t4; 1480CREATE TABLE t1(c1 INT NOT NULL); 1481CREATE TABLE t2(c1 INT NULL); 1482CREATE TABLE t3(c1 INT NOT NULL); 1483CREATE TABLE t4(c1 INT NULL); 1484INSERT INTO t2 (c1) VALUES(NULL); 1485INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1486INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1487SELECT AVG(c1) AS value FROM t1; 1488SELECT AVG(c1) AS value FROM t1 WHERE c1 <> 0; 1489SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 1490SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 1491DROP TABLE t1,t2,t3,t4; 1492CREATE TABLE t1(c1 INTEGER NOT NULL); 1493CREATE TABLE t2(c1 INTEGER NULL); 1494CREATE TABLE t3(c1 INTEGER NOT NULL); 1495CREATE TABLE t4(c1 INTEGER NULL); 1496INSERT INTO t2 (c1) VALUES(NULL); 1497INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1498INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1499SELECT AVG(c1) AS value FROM t1; 1500SELECT AVG(c1) AS value FROM t1 WHERE c1 <> 0; 1501SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 1502SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 1503DROP TABLE t1,t2,t3,t4; 1504CREATE TABLE t1(c1 BIGINT NOT NULL); 1505CREATE TABLE t2(c1 BIGINT NULL); 1506CREATE TABLE t3(c1 BIGINT NOT NULL); 1507CREATE TABLE t4(c1 BIGINT NULL); 1508INSERT INTO t2 (c1) VALUES(NULL); 1509INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1510INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1511SELECT AVG(c1) AS value FROM t1; 1512SELECT AVG(c1) AS value FROM t1 WHERE c1 <> 0; 1513SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 1514SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 1515DROP TABLE t1,t2,t3,t4; 1516CREATE TABLE t1(c1 TINYINT NOT NULL); 1517CREATE TABLE t2(c1 TINYINT NULL); 1518CREATE TABLE t3(c1 TINYINT NOT NULL); 1519CREATE TABLE t4(c1 TINYINT NULL); 1520INSERT INTO t2 (c1) VALUES(NULL); 1521INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1522INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1523SELECT AVG(c1) AS value FROM t2; 1524SELECT AVG(c1) AS value FROM t2 WHERE c1 <> 0; 1525SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 1526SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 1527DROP TABLE t1,t2,t3,t4; 1528CREATE TABLE t1(c1 SMALLINT NOT NULL); 1529CREATE TABLE t2(c1 SMALLINT NULL); 1530CREATE TABLE t3(c1 SMALLINT NOT NULL); 1531CREATE TABLE t4(c1 SMALLINT NULL); 1532INSERT INTO t2 (c1) VALUES(NULL); 1533INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1534INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1535SELECT AVG(c1) AS value FROM t2; 1536SELECT AVG(c1) AS value FROM t2 WHERE c1 <> 0; 1537SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 1538SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 1539DROP TABLE t1,t2,t3,t4; 1540CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1541CREATE TABLE t2(c1 MEDIUMINT NULL); 1542CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 1543CREATE TABLE t4(c1 MEDIUMINT NULL); 1544INSERT INTO t2 (c1) VALUES(NULL); 1545INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1546INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1547SELECT AVG(c1) AS value FROM t2; 1548SELECT AVG(c1) AS value FROM t2 WHERE c1 <> 0; 1549SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 1550SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 1551DROP TABLE t1,t2,t3,t4; 1552CREATE TABLE t1(c1 INT NOT NULL); 1553CREATE TABLE t2(c1 INT NULL); 1554CREATE TABLE t3(c1 INT NOT NULL); 1555CREATE TABLE t4(c1 INT NULL); 1556INSERT INTO t2 (c1) VALUES(NULL); 1557INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1558INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1559SELECT AVG(c1) AS value FROM t2; 1560SELECT AVG(c1) AS value FROM t2 WHERE c1 <> 0; 1561SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 1562SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 1563DROP TABLE t1,t2,t3,t4; 1564CREATE TABLE t1(c1 INTEGER NOT NULL); 1565CREATE TABLE t2(c1 INTEGER NULL); 1566CREATE TABLE t3(c1 INTEGER NOT NULL); 1567CREATE TABLE t4(c1 INTEGER NULL); 1568INSERT INTO t2 (c1) VALUES(NULL); 1569INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1570INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1571SELECT AVG(c1) AS value FROM t2; 1572SELECT AVG(c1) AS value FROM t2 WHERE c1 <> 0; 1573SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 1574SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 1575DROP TABLE t1,t2,t3,t4; 1576CREATE TABLE t1(c1 BIGINT NOT NULL); 1577CREATE TABLE t2(c1 BIGINT NULL); 1578CREATE TABLE t3(c1 BIGINT NOT NULL); 1579CREATE TABLE t4(c1 BIGINT NULL); 1580INSERT INTO t2 (c1) VALUES(NULL); 1581INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1582INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1583SELECT AVG(c1) AS value FROM t2; 1584SELECT AVG(c1) AS value FROM t2 WHERE c1 <> 0; 1585SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 1586SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 1587DROP TABLE t1,t2,t3,t4; 1588CREATE TABLE t1(c1 TINYINT NOT NULL); 1589CREATE TABLE t2(c1 TINYINT NULL); 1590CREATE TABLE t3(c1 TINYINT NOT NULL); 1591CREATE TABLE t4(c1 TINYINT NULL); 1592INSERT INTO t2 (c1) VALUES(NULL); 1593INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1594INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1595SELECT AVG(c1) AS value FROM t3; 1596SELECT AVG(c1) AS value FROM t3 WHERE c1 <> 0; 1597SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1598SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1599DROP TABLE t1,t2,t3,t4; 1600CREATE TABLE t1(c1 SMALLINT NOT NULL); 1601CREATE TABLE t2(c1 SMALLINT NULL); 1602CREATE TABLE t3(c1 SMALLINT NOT NULL); 1603CREATE TABLE t4(c1 SMALLINT NULL); 1604INSERT INTO t2 (c1) VALUES(NULL); 1605INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1606INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1607SELECT AVG(c1) AS value FROM t3; 1608SELECT AVG(c1) AS value FROM t3 WHERE c1 <> 0; 1609SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1610SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1611DROP TABLE t1,t2,t3,t4; 1612CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1613CREATE TABLE t2(c1 MEDIUMINT NULL); 1614CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 1615CREATE TABLE t4(c1 MEDIUMINT NULL); 1616INSERT INTO t2 (c1) VALUES(NULL); 1617INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1618INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1619SELECT AVG(c1) AS value FROM t3; 1620SELECT AVG(c1) AS value FROM t3 WHERE c1 <> 0; 1621SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1622SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1623DROP TABLE t1,t2,t3,t4; 1624CREATE TABLE t1(c1 INT NOT NULL); 1625CREATE TABLE t2(c1 INT NULL); 1626CREATE TABLE t3(c1 INT NOT NULL); 1627CREATE TABLE t4(c1 INT NULL); 1628INSERT INTO t2 (c1) VALUES(NULL); 1629INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1630INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1631SELECT AVG(c1) AS value FROM t3; 1632SELECT AVG(c1) AS value FROM t3 WHERE c1 <> 0; 1633SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1634SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1635DROP TABLE t1,t2,t3,t4; 1636CREATE TABLE t1(c1 INTEGER NOT NULL); 1637CREATE TABLE t2(c1 INTEGER NULL); 1638CREATE TABLE t3(c1 INTEGER NOT NULL); 1639CREATE TABLE t4(c1 INTEGER NULL); 1640INSERT INTO t2 (c1) VALUES(NULL); 1641INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1642INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1643SELECT AVG(c1) AS value FROM t3; 1644SELECT AVG(c1) AS value FROM t3 WHERE c1 <> 0; 1645SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1646SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1647DROP TABLE t1,t2,t3,t4; 1648CREATE TABLE t1(c1 BIGINT NOT NULL); 1649CREATE TABLE t2(c1 BIGINT NULL); 1650CREATE TABLE t3(c1 BIGINT NOT NULL); 1651CREATE TABLE t4(c1 BIGINT NULL); 1652INSERT INTO t2 (c1) VALUES(NULL); 1653INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1654INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1655SELECT AVG(c1) AS value FROM t3; 1656SELECT AVG(c1) AS value FROM t3 WHERE c1 <> 0; 1657SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1658SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1659DROP TABLE t1,t2,t3,t4; 1660CREATE TABLE t1(c1 TINYINT NOT NULL); 1661CREATE TABLE t2(c1 TINYINT NULL); 1662CREATE TABLE t3(c1 TINYINT NOT NULL); 1663CREATE TABLE t4(c1 TINYINT NULL); 1664INSERT INTO t2 (c1) VALUES(NULL); 1665INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1666INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1667SELECT AVG(c1) AS value FROM t4; 1668SELECT AVG(c1) AS value FROM t4 WHERE c1 <> 0; 1669SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1670SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1671DROP TABLE t1,t2,t3,t4; 1672CREATE TABLE t1(c1 SMALLINT NOT NULL); 1673CREATE TABLE t2(c1 SMALLINT NULL); 1674CREATE TABLE t3(c1 SMALLINT NOT NULL); 1675CREATE TABLE t4(c1 SMALLINT NULL); 1676INSERT INTO t2 (c1) VALUES(NULL); 1677INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1678INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1679SELECT AVG(c1) AS value FROM t4; 1680SELECT AVG(c1) AS value FROM t4 WHERE c1 <> 0; 1681SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1682SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1683DROP TABLE t1,t2,t3,t4; 1684CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1685CREATE TABLE t2(c1 MEDIUMINT NULL); 1686CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 1687CREATE TABLE t4(c1 MEDIUMINT NULL); 1688INSERT INTO t2 (c1) VALUES(NULL); 1689INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1690INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1691SELECT AVG(c1) AS value FROM t4; 1692SELECT AVG(c1) AS value FROM t4 WHERE c1 <> 0; 1693SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1694SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1695DROP TABLE t1,t2,t3,t4; 1696CREATE TABLE t1(c1 INT NOT NULL); 1697CREATE TABLE t2(c1 INT NULL); 1698CREATE TABLE t3(c1 INT NOT NULL); 1699CREATE TABLE t4(c1 INT NULL); 1700INSERT INTO t2 (c1) VALUES(NULL); 1701INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1702INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1703SELECT AVG(c1) AS value FROM t4; 1704SELECT AVG(c1) AS value FROM t4 WHERE c1 <> 0; 1705SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1706SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1707DROP TABLE t1,t2,t3,t4; 1708CREATE TABLE t1(c1 INTEGER NOT NULL); 1709CREATE TABLE t2(c1 INTEGER NULL); 1710CREATE TABLE t3(c1 INTEGER NOT NULL); 1711CREATE TABLE t4(c1 INTEGER NULL); 1712INSERT INTO t2 (c1) VALUES(NULL); 1713INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1714INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1715SELECT AVG(c1) AS value FROM t4; 1716SELECT AVG(c1) AS value FROM t4 WHERE c1 <> 0; 1717SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1718SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1719DROP TABLE t1,t2,t3,t4; 1720CREATE TABLE t1(c1 BIGINT NOT NULL); 1721CREATE TABLE t2(c1 BIGINT NULL); 1722CREATE TABLE t3(c1 BIGINT NOT NULL); 1723CREATE TABLE t4(c1 BIGINT NULL); 1724INSERT INTO t2 (c1) VALUES(NULL); 1725INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1726INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1727SELECT AVG(c1) AS value FROM t4; 1728SELECT AVG(c1) AS value FROM t4 WHERE c1 <> 0; 1729SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1730SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1731DROP TABLE t1,t2,t3,t4; 1732CREATE TABLE t1(c1 TINYINT NOT NULL); 1733CREATE TABLE t2(c1 TINYINT NULL); 1734CREATE TABLE t3(c1 TINYINT NOT NULL); 1735CREATE TABLE t4(c1 TINYINT NULL); 1736INSERT INTO t2 (c1) VALUES(NULL); 1737INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1738INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1739SELECT AVG(c1) AS value FROM t1; 1740SELECT AVG(c1) AS value FROM t1 WHERE c1 <=> 0; 1741SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 1742SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 1743DROP TABLE t1,t2,t3,t4; 1744CREATE TABLE t1(c1 SMALLINT NOT NULL); 1745CREATE TABLE t2(c1 SMALLINT NULL); 1746CREATE TABLE t3(c1 SMALLINT NOT NULL); 1747CREATE TABLE t4(c1 SMALLINT NULL); 1748INSERT INTO t2 (c1) VALUES(NULL); 1749INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1750INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1751SELECT AVG(c1) AS value FROM t1; 1752SELECT AVG(c1) AS value FROM t1 WHERE c1 <=> 0; 1753SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 1754SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 1755DROP TABLE t1,t2,t3,t4; 1756CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1757CREATE TABLE t2(c1 MEDIUMINT NULL); 1758CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 1759CREATE TABLE t4(c1 MEDIUMINT NULL); 1760INSERT INTO t2 (c1) VALUES(NULL); 1761INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1762INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1763SELECT AVG(c1) AS value FROM t1; 1764SELECT AVG(c1) AS value FROM t1 WHERE c1 <=> 0; 1765SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 1766SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 1767DROP TABLE t1,t2,t3,t4; 1768CREATE TABLE t1(c1 INT NOT NULL); 1769CREATE TABLE t2(c1 INT NULL); 1770CREATE TABLE t3(c1 INT NOT NULL); 1771CREATE TABLE t4(c1 INT NULL); 1772INSERT INTO t2 (c1) VALUES(NULL); 1773INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1774INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1775SELECT AVG(c1) AS value FROM t1; 1776SELECT AVG(c1) AS value FROM t1 WHERE c1 <=> 0; 1777SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 1778SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 1779DROP TABLE t1,t2,t3,t4; 1780CREATE TABLE t1(c1 INTEGER NOT NULL); 1781CREATE TABLE t2(c1 INTEGER NULL); 1782CREATE TABLE t3(c1 INTEGER NOT NULL); 1783CREATE TABLE t4(c1 INTEGER NULL); 1784INSERT INTO t2 (c1) VALUES(NULL); 1785INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1786INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1787SELECT AVG(c1) AS value FROM t1; 1788SELECT AVG(c1) AS value FROM t1 WHERE c1 <=> 0; 1789SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 1790SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 1791DROP TABLE t1,t2,t3,t4; 1792CREATE TABLE t1(c1 BIGINT NOT NULL); 1793CREATE TABLE t2(c1 BIGINT NULL); 1794CREATE TABLE t3(c1 BIGINT NOT NULL); 1795CREATE TABLE t4(c1 BIGINT NULL); 1796INSERT INTO t2 (c1) VALUES(NULL); 1797INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1798INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1799SELECT AVG(c1) AS value FROM t1; 1800SELECT AVG(c1) AS value FROM t1 WHERE c1 <=> 0; 1801SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; 1802SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NOT NULL; 1803DROP TABLE t1,t2,t3,t4; 1804CREATE TABLE t1(c1 TINYINT NOT NULL); 1805CREATE TABLE t2(c1 TINYINT NULL); 1806CREATE TABLE t3(c1 TINYINT NOT NULL); 1807CREATE TABLE t4(c1 TINYINT NULL); 1808INSERT INTO t2 (c1) VALUES(NULL); 1809INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1810INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1811SELECT AVG(c1) AS value FROM t2; 1812SELECT AVG(c1) AS value FROM t2 WHERE c1 <=> 0; 1813SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 1814SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 1815DROP TABLE t1,t2,t3,t4; 1816CREATE TABLE t1(c1 SMALLINT NOT NULL); 1817CREATE TABLE t2(c1 SMALLINT NULL); 1818CREATE TABLE t3(c1 SMALLINT NOT NULL); 1819CREATE TABLE t4(c1 SMALLINT NULL); 1820INSERT INTO t2 (c1) VALUES(NULL); 1821INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1822INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1823SELECT AVG(c1) AS value FROM t2; 1824SELECT AVG(c1) AS value FROM t2 WHERE c1 <=> 0; 1825SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 1826SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 1827DROP TABLE t1,t2,t3,t4; 1828CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1829CREATE TABLE t2(c1 MEDIUMINT NULL); 1830CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 1831CREATE TABLE t4(c1 MEDIUMINT NULL); 1832INSERT INTO t2 (c1) VALUES(NULL); 1833INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1834INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1835SELECT AVG(c1) AS value FROM t2; 1836SELECT AVG(c1) AS value FROM t2 WHERE c1 <=> 0; 1837SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 1838SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 1839DROP TABLE t1,t2,t3,t4; 1840CREATE TABLE t1(c1 INT NOT NULL); 1841CREATE TABLE t2(c1 INT NULL); 1842CREATE TABLE t3(c1 INT NOT NULL); 1843CREATE TABLE t4(c1 INT NULL); 1844INSERT INTO t2 (c1) VALUES(NULL); 1845INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1846INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1847SELECT AVG(c1) AS value FROM t2; 1848SELECT AVG(c1) AS value FROM t2 WHERE c1 <=> 0; 1849SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 1850SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 1851DROP TABLE t1,t2,t3,t4; 1852CREATE TABLE t1(c1 INTEGER NOT NULL); 1853CREATE TABLE t2(c1 INTEGER NULL); 1854CREATE TABLE t3(c1 INTEGER NOT NULL); 1855CREATE TABLE t4(c1 INTEGER NULL); 1856INSERT INTO t2 (c1) VALUES(NULL); 1857INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1858INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1859SELECT AVG(c1) AS value FROM t2; 1860SELECT AVG(c1) AS value FROM t2 WHERE c1 <=> 0; 1861SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 1862SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 1863DROP TABLE t1,t2,t3,t4; 1864CREATE TABLE t1(c1 BIGINT NOT NULL); 1865CREATE TABLE t2(c1 BIGINT NULL); 1866CREATE TABLE t3(c1 BIGINT NOT NULL); 1867CREATE TABLE t4(c1 BIGINT NULL); 1868INSERT INTO t2 (c1) VALUES(NULL); 1869INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1870INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1871SELECT AVG(c1) AS value FROM t2; 1872SELECT AVG(c1) AS value FROM t2 WHERE c1 <=> 0; 1873SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NULL; 1874SELECT AVG(c1) AS value FROM t2 WHERE c1 IS NOT NULL; 1875DROP TABLE t1,t2,t3,t4; 1876CREATE TABLE t1(c1 TINYINT NOT NULL); 1877CREATE TABLE t2(c1 TINYINT NULL); 1878CREATE TABLE t3(c1 TINYINT NOT NULL); 1879CREATE TABLE t4(c1 TINYINT NULL); 1880INSERT INTO t2 (c1) VALUES(NULL); 1881INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1882INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1883SELECT AVG(c1) AS value FROM t3; 1884SELECT AVG(c1) AS value FROM t3 WHERE c1 <=> 0; 1885SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1886SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1887DROP TABLE t1,t2,t3,t4; 1888CREATE TABLE t1(c1 SMALLINT NOT NULL); 1889CREATE TABLE t2(c1 SMALLINT NULL); 1890CREATE TABLE t3(c1 SMALLINT NOT NULL); 1891CREATE TABLE t4(c1 SMALLINT NULL); 1892INSERT INTO t2 (c1) VALUES(NULL); 1893INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1894INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1895SELECT AVG(c1) AS value FROM t3; 1896SELECT AVG(c1) AS value FROM t3 WHERE c1 <=> 0; 1897SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1898SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1899DROP TABLE t1,t2,t3,t4; 1900CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1901CREATE TABLE t2(c1 MEDIUMINT NULL); 1902CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 1903CREATE TABLE t4(c1 MEDIUMINT NULL); 1904INSERT INTO t2 (c1) VALUES(NULL); 1905INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1906INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1907SELECT AVG(c1) AS value FROM t3; 1908SELECT AVG(c1) AS value FROM t3 WHERE c1 <=> 0; 1909SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1910SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1911DROP TABLE t1,t2,t3,t4; 1912CREATE TABLE t1(c1 INT NOT NULL); 1913CREATE TABLE t2(c1 INT NULL); 1914CREATE TABLE t3(c1 INT NOT NULL); 1915CREATE TABLE t4(c1 INT NULL); 1916INSERT INTO t2 (c1) VALUES(NULL); 1917INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1918INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1919SELECT AVG(c1) AS value FROM t3; 1920SELECT AVG(c1) AS value FROM t3 WHERE c1 <=> 0; 1921SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1922SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1923DROP TABLE t1,t2,t3,t4; 1924CREATE TABLE t1(c1 INTEGER NOT NULL); 1925CREATE TABLE t2(c1 INTEGER NULL); 1926CREATE TABLE t3(c1 INTEGER NOT NULL); 1927CREATE TABLE t4(c1 INTEGER NULL); 1928INSERT INTO t2 (c1) VALUES(NULL); 1929INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1930INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1931SELECT AVG(c1) AS value FROM t3; 1932SELECT AVG(c1) AS value FROM t3 WHERE c1 <=> 0; 1933SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1934SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1935DROP TABLE t1,t2,t3,t4; 1936CREATE TABLE t1(c1 BIGINT NOT NULL); 1937CREATE TABLE t2(c1 BIGINT NULL); 1938CREATE TABLE t3(c1 BIGINT NOT NULL); 1939CREATE TABLE t4(c1 BIGINT NULL); 1940INSERT INTO t2 (c1) VALUES(NULL); 1941INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1942INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1943SELECT AVG(c1) AS value FROM t3; 1944SELECT AVG(c1) AS value FROM t3 WHERE c1 <=> 0; 1945SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NULL; 1946SELECT AVG(c1) AS value FROM t3 WHERE c1 IS NOT NULL; 1947DROP TABLE t1,t2,t3,t4; 1948CREATE TABLE t1(c1 TINYINT NOT NULL); 1949CREATE TABLE t2(c1 TINYINT NULL); 1950CREATE TABLE t3(c1 TINYINT NOT NULL); 1951CREATE TABLE t4(c1 TINYINT NULL); 1952INSERT INTO t2 (c1) VALUES(NULL); 1953INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1954INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1955SELECT AVG(c1) AS value FROM t4; 1956SELECT AVG(c1) AS value FROM t4 WHERE c1 <=> 0; 1957SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1958SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1959DROP TABLE t1,t2,t3,t4; 1960CREATE TABLE t1(c1 SMALLINT NOT NULL); 1961CREATE TABLE t2(c1 SMALLINT NULL); 1962CREATE TABLE t3(c1 SMALLINT NOT NULL); 1963CREATE TABLE t4(c1 SMALLINT NULL); 1964INSERT INTO t2 (c1) VALUES(NULL); 1965INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1966INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1967SELECT AVG(c1) AS value FROM t4; 1968SELECT AVG(c1) AS value FROM t4 WHERE c1 <=> 0; 1969SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1970SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1971DROP TABLE t1,t2,t3,t4; 1972CREATE TABLE t1(c1 MEDIUMINT NOT NULL); 1973CREATE TABLE t2(c1 MEDIUMINT NULL); 1974CREATE TABLE t3(c1 MEDIUMINT NOT NULL); 1975CREATE TABLE t4(c1 MEDIUMINT NULL); 1976INSERT INTO t2 (c1) VALUES(NULL); 1977INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1978INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1979SELECT AVG(c1) AS value FROM t4; 1980SELECT AVG(c1) AS value FROM t4 WHERE c1 <=> 0; 1981SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1982SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1983DROP TABLE t1,t2,t3,t4; 1984CREATE TABLE t1(c1 INT NOT NULL); 1985CREATE TABLE t2(c1 INT NULL); 1986CREATE TABLE t3(c1 INT NOT NULL); 1987CREATE TABLE t4(c1 INT NULL); 1988INSERT INTO t2 (c1) VALUES(NULL); 1989INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1990INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1991SELECT AVG(c1) AS value FROM t4; 1992SELECT AVG(c1) AS value FROM t4 WHERE c1 <=> 0; 1993SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 1994SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 1995DROP TABLE t1,t2,t3,t4; 1996CREATE TABLE t1(c1 INTEGER NOT NULL); 1997CREATE TABLE t2(c1 INTEGER NULL); 1998CREATE TABLE t3(c1 INTEGER NOT NULL); 1999CREATE TABLE t4(c1 INTEGER NULL); 2000INSERT INTO t2 (c1) VALUES(NULL); 2001INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2002INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2003SELECT AVG(c1) AS value FROM t4; 2004SELECT AVG(c1) AS value FROM t4 WHERE c1 <=> 0; 2005SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 2006SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 2007DROP TABLE t1,t2,t3,t4; 2008CREATE TABLE t1(c1 BIGINT NOT NULL); 2009CREATE TABLE t2(c1 BIGINT NULL); 2010CREATE TABLE t3(c1 BIGINT NOT NULL); 2011CREATE TABLE t4(c1 BIGINT NULL); 2012INSERT INTO t2 (c1) VALUES(NULL); 2013INSERT INTO t3 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2014INSERT INTO t4 (c1) VALUES(NULL), (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2015SELECT AVG(c1) AS value FROM t4; 2016SELECT AVG(c1) AS value FROM t4 WHERE c1 <=> 0; 2017SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NULL; 2018SELECT AVG(c1) AS value FROM t4 WHERE c1 IS NOT NULL; 2019DROP TABLE t1,t2,t3,t4; 2020 2021