1--disable_warnings 2DROP TABLE IF EXISTS t1,t2,t3; 3--enable_warnings 4CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 5CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 6INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 7CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 8INSERT INTO t3 (c1) VALUES(5); 9SELECT COUNT(c1),SUM(c1) FROM t1; 10SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 11REPLACE t1 VALUES (5); 12SELECT COUNT(c1),SUM(c1) FROM t1; 13SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 14DROP TABLE t1,t2,t3; 15CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 16CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 17INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 18CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 19INSERT INTO t3 (c1) VALUES(5); 20SELECT COUNT(c1),SUM(c1) FROM t1; 21SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 22REPLACE t1 VALUES (5); 23SELECT COUNT(c1),SUM(c1) FROM t1; 24SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 25DROP TABLE t1,t2,t3; 26CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 27CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 28INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 29CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 30INSERT INTO t3 (c1) VALUES(5); 31SELECT COUNT(c1),SUM(c1) FROM t1; 32SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 33REPLACE t1 VALUES (5); 34SELECT COUNT(c1),SUM(c1) FROM t1; 35SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 36DROP TABLE t1,t2,t3; 37CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 38CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 39INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 40CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 41INSERT INTO t3 (c1) VALUES(5); 42SELECT COUNT(c1),SUM(c1) FROM t1; 43SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 44REPLACE t1 VALUES (5); 45SELECT COUNT(c1),SUM(c1) FROM t1; 46SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 47DROP TABLE t1,t2,t3; 48CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 49CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 50INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 51CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 52INSERT INTO t3 (c1) VALUES(5); 53SELECT COUNT(c1),SUM(c1) FROM t1; 54SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 55REPLACE t1 VALUES (5); 56SELECT COUNT(c1),SUM(c1) FROM t1; 57SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 58DROP TABLE t1,t2,t3; 59CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 60CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 61INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 62CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 63INSERT INTO t3 (c1) VALUES(5); 64SELECT COUNT(c1),SUM(c1) FROM t1; 65SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 66REPLACE t1 VALUES (5); 67SELECT COUNT(c1),SUM(c1) FROM t1; 68SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 69DROP TABLE t1,t2,t3; 70CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 71CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 72INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 73CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 74INSERT INTO t3 (c1) VALUES(5); 75SELECT COUNT(c1),SUM(c1) FROM t2; 76SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 77REPLACE t2 VALUES (5); 78SELECT COUNT(c1),SUM(c1) FROM t2; 79SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 80DROP TABLE t1,t2,t3; 81CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 82CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 83INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 84CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 85INSERT INTO t3 (c1) VALUES(5); 86SELECT COUNT(c1),SUM(c1) FROM t2; 87SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 88REPLACE t2 VALUES (5); 89SELECT COUNT(c1),SUM(c1) FROM t2; 90SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 91DROP TABLE t1,t2,t3; 92CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 93CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 94INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 95CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 96INSERT INTO t3 (c1) VALUES(5); 97SELECT COUNT(c1),SUM(c1) FROM t2; 98SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 99REPLACE t2 VALUES (5); 100SELECT COUNT(c1),SUM(c1) FROM t2; 101SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 102DROP TABLE t1,t2,t3; 103CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 104CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 105INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 106CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 107INSERT INTO t3 (c1) VALUES(5); 108SELECT COUNT(c1),SUM(c1) FROM t2; 109SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 110REPLACE t2 VALUES (5); 111SELECT COUNT(c1),SUM(c1) FROM t2; 112SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 113DROP TABLE t1,t2,t3; 114CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 115CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 116INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 117CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 118INSERT INTO t3 (c1) VALUES(5); 119SELECT COUNT(c1),SUM(c1) FROM t2; 120SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 121REPLACE t2 VALUES (5); 122SELECT COUNT(c1),SUM(c1) FROM t2; 123SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 124DROP TABLE t1,t2,t3; 125CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 126CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 127INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 128CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 129INSERT INTO t3 (c1) VALUES(5); 130SELECT COUNT(c1),SUM(c1) FROM t2; 131SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 132REPLACE t2 VALUES (5); 133SELECT COUNT(c1),SUM(c1) FROM t2; 134SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 135DROP TABLE t1,t2,t3; 136CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 137CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 138INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 139CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 140INSERT INTO t3 (c1) VALUES(5); 141SELECT COUNT(c1),SUM(c1) FROM t3; 142SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 143REPLACE t3 VALUES (5); 144SELECT COUNT(c1),SUM(c1) FROM t3; 145SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 146DROP TABLE t1,t2,t3; 147CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 148CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 149INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 150CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 151INSERT INTO t3 (c1) VALUES(5); 152SELECT COUNT(c1),SUM(c1) FROM t3; 153SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 154REPLACE t3 VALUES (5); 155SELECT COUNT(c1),SUM(c1) FROM t3; 156SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 157DROP TABLE t1,t2,t3; 158CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 159CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 160INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 161CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 162INSERT INTO t3 (c1) VALUES(5); 163SELECT COUNT(c1),SUM(c1) FROM t3; 164SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 165REPLACE t3 VALUES (5); 166SELECT COUNT(c1),SUM(c1) FROM t3; 167SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 168DROP TABLE t1,t2,t3; 169CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 170CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 171INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 172CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 173INSERT INTO t3 (c1) VALUES(5); 174SELECT COUNT(c1),SUM(c1) FROM t3; 175SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 176REPLACE t3 VALUES (5); 177SELECT COUNT(c1),SUM(c1) FROM t3; 178SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 179DROP TABLE t1,t2,t3; 180CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 181CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 182INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 183CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 184INSERT INTO t3 (c1) VALUES(5); 185SELECT COUNT(c1),SUM(c1) FROM t3; 186SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 187REPLACE t3 VALUES (5); 188SELECT COUNT(c1),SUM(c1) FROM t3; 189SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 190DROP TABLE t1,t2,t3; 191CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 192CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 193INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 194CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 195INSERT INTO t3 (c1) VALUES(5); 196SELECT COUNT(c1),SUM(c1) FROM t3; 197SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 198REPLACE t3 VALUES (5); 199SELECT COUNT(c1),SUM(c1) FROM t3; 200SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 201DROP TABLE t1,t2,t3; 202CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 203CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 204INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 205CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 206INSERT INTO t3 (c1) VALUES(5); 207SELECT COUNT(c1),SUM(c1) FROM t1; 208SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 209REPLACE t1 VALUES (5); 210SELECT COUNT(c1),SUM(c1) FROM t1; 211SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 212DROP TABLE t1,t2,t3; 213CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 214CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 215INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 216CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 217INSERT INTO t3 (c1) VALUES(5); 218SELECT COUNT(c1),SUM(c1) FROM t1; 219SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 220REPLACE t1 VALUES (5); 221SELECT COUNT(c1),SUM(c1) FROM t1; 222SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 223DROP TABLE t1,t2,t3; 224CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 225CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 226INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 227CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 228INSERT INTO t3 (c1) VALUES(5); 229SELECT COUNT(c1),SUM(c1) FROM t1; 230SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 231REPLACE t1 VALUES (5); 232SELECT COUNT(c1),SUM(c1) FROM t1; 233SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 234DROP TABLE t1,t2,t3; 235CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 236CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 237INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 238CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 239INSERT INTO t3 (c1) VALUES(5); 240SELECT COUNT(c1),SUM(c1) FROM t1; 241SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 242REPLACE t1 VALUES (5); 243SELECT COUNT(c1),SUM(c1) FROM t1; 244SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 245DROP TABLE t1,t2,t3; 246CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 247CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 248INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 249CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 250INSERT INTO t3 (c1) VALUES(5); 251SELECT COUNT(c1),SUM(c1) FROM t1; 252SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 253REPLACE t1 VALUES (5); 254SELECT COUNT(c1),SUM(c1) FROM t1; 255SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 256DROP TABLE t1,t2,t3; 257CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 258CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 259INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 260CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 261INSERT INTO t3 (c1) VALUES(5); 262SELECT COUNT(c1),SUM(c1) FROM t1; 263SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 264REPLACE t1 VALUES (5); 265SELECT COUNT(c1),SUM(c1) FROM t1; 266SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 267DROP TABLE t1,t2,t3; 268CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 269CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 270INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 271CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 272INSERT INTO t3 (c1) VALUES(5); 273SELECT COUNT(c1),SUM(c1) FROM t2; 274SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 275REPLACE t2 VALUES (5); 276SELECT COUNT(c1),SUM(c1) FROM t2; 277SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 278DROP TABLE t1,t2,t3; 279CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 280CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 281INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 282CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 283INSERT INTO t3 (c1) VALUES(5); 284SELECT COUNT(c1),SUM(c1) FROM t2; 285SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 286REPLACE t2 VALUES (5); 287SELECT COUNT(c1),SUM(c1) FROM t2; 288SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 289DROP TABLE t1,t2,t3; 290CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 291CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 292INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 293CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 294INSERT INTO t3 (c1) VALUES(5); 295SELECT COUNT(c1),SUM(c1) FROM t2; 296SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 297REPLACE t2 VALUES (5); 298SELECT COUNT(c1),SUM(c1) FROM t2; 299SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 300DROP TABLE t1,t2,t3; 301CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 302CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 303INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 304CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 305INSERT INTO t3 (c1) VALUES(5); 306SELECT COUNT(c1),SUM(c1) FROM t2; 307SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 308REPLACE t2 VALUES (5); 309SELECT COUNT(c1),SUM(c1) FROM t2; 310SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 311DROP TABLE t1,t2,t3; 312CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 313CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 314INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 315CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 316INSERT INTO t3 (c1) VALUES(5); 317SELECT COUNT(c1),SUM(c1) FROM t2; 318SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 319REPLACE t2 VALUES (5); 320SELECT COUNT(c1),SUM(c1) FROM t2; 321SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 322DROP TABLE t1,t2,t3; 323CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 324CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 325INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 326CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 327INSERT INTO t3 (c1) VALUES(5); 328SELECT COUNT(c1),SUM(c1) FROM t2; 329SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 330REPLACE t2 VALUES (5); 331SELECT COUNT(c1),SUM(c1) FROM t2; 332SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 333DROP TABLE t1,t2,t3; 334CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 335CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 336INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 337CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 338INSERT INTO t3 (c1) VALUES(5); 339SELECT COUNT(c1),SUM(c1) FROM t3; 340SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 341REPLACE t3 VALUES (5); 342SELECT COUNT(c1),SUM(c1) FROM t3; 343SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 344DROP TABLE t1,t2,t3; 345CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 346CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 347INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 348CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 349INSERT INTO t3 (c1) VALUES(5); 350SELECT COUNT(c1),SUM(c1) FROM t3; 351SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 352REPLACE t3 VALUES (5); 353SELECT COUNT(c1),SUM(c1) FROM t3; 354SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 355DROP TABLE t1,t2,t3; 356CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 357CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 358INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 359CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 360INSERT INTO t3 (c1) VALUES(5); 361SELECT COUNT(c1),SUM(c1) FROM t3; 362SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 363REPLACE t3 VALUES (5); 364SELECT COUNT(c1),SUM(c1) FROM t3; 365SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 366DROP TABLE t1,t2,t3; 367CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 368CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 369INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 370CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 371INSERT INTO t3 (c1) VALUES(5); 372SELECT COUNT(c1),SUM(c1) FROM t3; 373SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 374REPLACE t3 VALUES (5); 375SELECT COUNT(c1),SUM(c1) FROM t3; 376SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 377DROP TABLE t1,t2,t3; 378CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 379CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 380INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 381CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 382INSERT INTO t3 (c1) VALUES(5); 383SELECT COUNT(c1),SUM(c1) FROM t3; 384SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 385REPLACE t3 VALUES (5); 386SELECT COUNT(c1),SUM(c1) FROM t3; 387SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 388DROP TABLE t1,t2,t3; 389CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 390CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 391INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 392CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 393INSERT INTO t3 (c1) VALUES(5); 394SELECT COUNT(c1),SUM(c1) FROM t3; 395SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 396REPLACE t3 VALUES (5); 397SELECT COUNT(c1),SUM(c1) FROM t3; 398SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 399DROP TABLE t1,t2,t3; 400CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 401CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 402INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 403CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 404INSERT INTO t3 (c1) VALUES(5); 405SELECT COUNT(c1),SUM(c1) FROM t1; 406SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 407REPLACE t1 VALUES (5); 408SELECT COUNT(c1),SUM(c1) FROM t1; 409SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 410DROP TABLE t1,t2,t3; 411CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 412CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 413INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 414CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 415INSERT INTO t3 (c1) VALUES(5); 416SELECT COUNT(c1),SUM(c1) FROM t1; 417SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 418REPLACE t1 VALUES (5); 419SELECT COUNT(c1),SUM(c1) FROM t1; 420SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 421DROP TABLE t1,t2,t3; 422CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 423CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 424INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 425CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 426INSERT INTO t3 (c1) VALUES(5); 427SELECT COUNT(c1),SUM(c1) FROM t1; 428SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 429REPLACE t1 VALUES (5); 430SELECT COUNT(c1),SUM(c1) FROM t1; 431SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 432DROP TABLE t1,t2,t3; 433CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 434CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 435INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 436CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 437INSERT INTO t3 (c1) VALUES(5); 438SELECT COUNT(c1),SUM(c1) FROM t1; 439SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 440REPLACE t1 VALUES (5); 441SELECT COUNT(c1),SUM(c1) FROM t1; 442SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 443DROP TABLE t1,t2,t3; 444CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 445CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 446INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 447CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 448INSERT INTO t3 (c1) VALUES(5); 449SELECT COUNT(c1),SUM(c1) FROM t1; 450SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 451REPLACE t1 VALUES (5); 452SELECT COUNT(c1),SUM(c1) FROM t1; 453SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 454DROP TABLE t1,t2,t3; 455CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 456CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 457INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 458CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 459INSERT INTO t3 (c1) VALUES(5); 460SELECT COUNT(c1),SUM(c1) FROM t1; 461SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 462REPLACE t1 VALUES (5); 463SELECT COUNT(c1),SUM(c1) FROM t1; 464SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 465DROP TABLE t1,t2,t3; 466CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 467CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 468INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 469CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 470INSERT INTO t3 (c1) VALUES(5); 471SELECT COUNT(c1),SUM(c1) FROM t2; 472SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 473REPLACE t2 VALUES (5); 474SELECT COUNT(c1),SUM(c1) FROM t2; 475SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 476DROP TABLE t1,t2,t3; 477CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 478CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 479INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 480CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 481INSERT INTO t3 (c1) VALUES(5); 482SELECT COUNT(c1),SUM(c1) FROM t2; 483SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 484REPLACE t2 VALUES (5); 485SELECT COUNT(c1),SUM(c1) FROM t2; 486SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 487DROP TABLE t1,t2,t3; 488CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 489CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 490INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 491CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 492INSERT INTO t3 (c1) VALUES(5); 493SELECT COUNT(c1),SUM(c1) FROM t2; 494SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 495REPLACE t2 VALUES (5); 496SELECT COUNT(c1),SUM(c1) FROM t2; 497SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 498DROP TABLE t1,t2,t3; 499CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 500CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 501INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 502CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 503INSERT INTO t3 (c1) VALUES(5); 504SELECT COUNT(c1),SUM(c1) FROM t2; 505SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 506REPLACE t2 VALUES (5); 507SELECT COUNT(c1),SUM(c1) FROM t2; 508SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 509DROP TABLE t1,t2,t3; 510CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 511CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 512INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 513CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 514INSERT INTO t3 (c1) VALUES(5); 515SELECT COUNT(c1),SUM(c1) FROM t2; 516SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 517REPLACE t2 VALUES (5); 518SELECT COUNT(c1),SUM(c1) FROM t2; 519SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 520DROP TABLE t1,t2,t3; 521CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 522CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 523INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 524CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 525INSERT INTO t3 (c1) VALUES(5); 526SELECT COUNT(c1),SUM(c1) FROM t2; 527SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 528REPLACE t2 VALUES (5); 529SELECT COUNT(c1),SUM(c1) FROM t2; 530SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 531DROP TABLE t1,t2,t3; 532CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 533CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 534INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 535CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 536INSERT INTO t3 (c1) VALUES(5); 537SELECT COUNT(c1),SUM(c1) FROM t3; 538SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 539REPLACE t3 VALUES (5); 540SELECT COUNT(c1),SUM(c1) FROM t3; 541SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 542DROP TABLE t1,t2,t3; 543CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 544CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 545INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 546CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 547INSERT INTO t3 (c1) VALUES(5); 548SELECT COUNT(c1),SUM(c1) FROM t3; 549SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 550REPLACE t3 VALUES (5); 551SELECT COUNT(c1),SUM(c1) FROM t3; 552SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 553DROP TABLE t1,t2,t3; 554CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 555CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 556INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 557CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 558INSERT INTO t3 (c1) VALUES(5); 559SELECT COUNT(c1),SUM(c1) FROM t3; 560SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 561REPLACE t3 VALUES (5); 562SELECT COUNT(c1),SUM(c1) FROM t3; 563SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 564DROP TABLE t1,t2,t3; 565CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 566CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 567INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 568CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 569INSERT INTO t3 (c1) VALUES(5); 570SELECT COUNT(c1),SUM(c1) FROM t3; 571SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 572REPLACE t3 VALUES (5); 573SELECT COUNT(c1),SUM(c1) FROM t3; 574SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 575DROP TABLE t1,t2,t3; 576CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 577CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 578INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 579CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 580INSERT INTO t3 (c1) VALUES(5); 581SELECT COUNT(c1),SUM(c1) FROM t3; 582SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 583REPLACE t3 VALUES (5); 584SELECT COUNT(c1),SUM(c1) FROM t3; 585SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 586DROP TABLE t1,t2,t3; 587CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 588CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 589INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 590CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 591INSERT INTO t3 (c1) VALUES(5); 592SELECT COUNT(c1),SUM(c1) FROM t3; 593SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 594REPLACE t3 VALUES (5); 595SELECT COUNT(c1),SUM(c1) FROM t3; 596SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 597DROP TABLE t1,t2,t3; 598CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 599CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 600INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 601CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 602INSERT INTO t3 (c1) VALUES(5); 603SELECT COUNT(c1),SUM(c1) FROM t1; 604SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 605REPLACE t1 VALUES (5); 606SELECT COUNT(c1),SUM(c1) FROM t1; 607SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 608DROP TABLE t1,t2,t3; 609CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 610CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 611INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 612CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 613INSERT INTO t3 (c1) VALUES(5); 614SELECT COUNT(c1),SUM(c1) FROM t1; 615SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 616REPLACE t1 VALUES (5); 617SELECT COUNT(c1),SUM(c1) FROM t1; 618SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 619DROP TABLE t1,t2,t3; 620CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 621CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 622INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 623CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 624INSERT INTO t3 (c1) VALUES(5); 625SELECT COUNT(c1),SUM(c1) FROM t1; 626SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 627REPLACE t1 VALUES (5); 628SELECT COUNT(c1),SUM(c1) FROM t1; 629SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 630DROP TABLE t1,t2,t3; 631CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 632CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 633INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 634CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 635INSERT INTO t3 (c1) VALUES(5); 636SELECT COUNT(c1),SUM(c1) FROM t1; 637SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 638REPLACE t1 VALUES (5); 639SELECT COUNT(c1),SUM(c1) FROM t1; 640SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 641DROP TABLE t1,t2,t3; 642CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 643CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 644INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 645CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 646INSERT INTO t3 (c1) VALUES(5); 647SELECT COUNT(c1),SUM(c1) FROM t1; 648SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 649REPLACE t1 VALUES (5); 650SELECT COUNT(c1),SUM(c1) FROM t1; 651SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 652DROP TABLE t1,t2,t3; 653CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 654CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 655INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 656CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 657INSERT INTO t3 (c1) VALUES(5); 658SELECT COUNT(c1),SUM(c1) FROM t1; 659SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 660REPLACE t1 VALUES (5); 661SELECT COUNT(c1),SUM(c1) FROM t1; 662SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 663DROP TABLE t1,t2,t3; 664CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 665CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 666INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 667CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 668INSERT INTO t3 (c1) VALUES(5); 669SELECT COUNT(c1),SUM(c1) FROM t2; 670SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 671REPLACE t2 VALUES (5); 672SELECT COUNT(c1),SUM(c1) FROM t2; 673SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 674DROP TABLE t1,t2,t3; 675CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 676CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 677INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 678CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 679INSERT INTO t3 (c1) VALUES(5); 680SELECT COUNT(c1),SUM(c1) FROM t2; 681SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 682REPLACE t2 VALUES (5); 683SELECT COUNT(c1),SUM(c1) FROM t2; 684SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 685DROP TABLE t1,t2,t3; 686CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 687CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 688INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 689CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 690INSERT INTO t3 (c1) VALUES(5); 691SELECT COUNT(c1),SUM(c1) FROM t2; 692SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 693REPLACE t2 VALUES (5); 694SELECT COUNT(c1),SUM(c1) FROM t2; 695SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 696DROP TABLE t1,t2,t3; 697CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 698CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 699INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 700CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 701INSERT INTO t3 (c1) VALUES(5); 702SELECT COUNT(c1),SUM(c1) FROM t2; 703SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 704REPLACE t2 VALUES (5); 705SELECT COUNT(c1),SUM(c1) FROM t2; 706SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 707DROP TABLE t1,t2,t3; 708CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 709CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 710INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 711CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 712INSERT INTO t3 (c1) VALUES(5); 713SELECT COUNT(c1),SUM(c1) FROM t2; 714SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 715REPLACE t2 VALUES (5); 716SELECT COUNT(c1),SUM(c1) FROM t2; 717SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 718DROP TABLE t1,t2,t3; 719CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 720CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 721INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 722CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 723INSERT INTO t3 (c1) VALUES(5); 724SELECT COUNT(c1),SUM(c1) FROM t2; 725SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 726REPLACE t2 VALUES (5); 727SELECT COUNT(c1),SUM(c1) FROM t2; 728SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 729DROP TABLE t1,t2,t3; 730CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 731CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 732INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 733CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 734INSERT INTO t3 (c1) VALUES(5); 735SELECT COUNT(c1),SUM(c1) FROM t3; 736SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 737REPLACE t3 VALUES (5); 738SELECT COUNT(c1),SUM(c1) FROM t3; 739SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 740DROP TABLE t1,t2,t3; 741CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 742CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 743INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 744CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 745INSERT INTO t3 (c1) VALUES(5); 746SELECT COUNT(c1),SUM(c1) FROM t3; 747SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 748REPLACE t3 VALUES (5); 749SELECT COUNT(c1),SUM(c1) FROM t3; 750SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 751DROP TABLE t1,t2,t3; 752CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 753CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 754INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 755CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 756INSERT INTO t3 (c1) VALUES(5); 757SELECT COUNT(c1),SUM(c1) FROM t3; 758SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 759REPLACE t3 VALUES (5); 760SELECT COUNT(c1),SUM(c1) FROM t3; 761SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 762DROP TABLE t1,t2,t3; 763CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 764CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 765INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 766CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 767INSERT INTO t3 (c1) VALUES(5); 768SELECT COUNT(c1),SUM(c1) FROM t3; 769SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 770REPLACE t3 VALUES (5); 771SELECT COUNT(c1),SUM(c1) FROM t3; 772SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 773DROP TABLE t1,t2,t3; 774CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 775CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 776INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 777CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 778INSERT INTO t3 (c1) VALUES(5); 779SELECT COUNT(c1),SUM(c1) FROM t3; 780SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 781REPLACE t3 VALUES (5); 782SELECT COUNT(c1),SUM(c1) FROM t3; 783SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 784DROP TABLE t1,t2,t3; 785CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 786CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 787INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 788CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 789INSERT INTO t3 (c1) VALUES(5); 790SELECT COUNT(c1),SUM(c1) FROM t3; 791SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 792REPLACE t3 VALUES (5); 793SELECT COUNT(c1),SUM(c1) FROM t3; 794SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 795DROP TABLE t1,t2,t3; 796CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 797CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 798INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 799CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 800INSERT INTO t3 (c1) VALUES(5); 801SELECT COUNT(c1),SUM(c1) FROM t1; 802SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 803REPLACE t1 VALUES (5); 804SELECT COUNT(c1),SUM(c1) FROM t1; 805SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 806DROP TABLE t1,t2,t3; 807CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 808CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 809INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 810CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 811INSERT INTO t3 (c1) VALUES(5); 812SELECT COUNT(c1),SUM(c1) FROM t1; 813SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 814REPLACE t1 VALUES (5); 815SELECT COUNT(c1),SUM(c1) FROM t1; 816SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 817DROP TABLE t1,t2,t3; 818CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 819CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 820INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 821CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 822INSERT INTO t3 (c1) VALUES(5); 823SELECT COUNT(c1),SUM(c1) FROM t1; 824SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 825REPLACE t1 VALUES (5); 826SELECT COUNT(c1),SUM(c1) FROM t1; 827SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 828DROP TABLE t1,t2,t3; 829CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 830CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 831INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 832CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 833INSERT INTO t3 (c1) VALUES(5); 834SELECT COUNT(c1),SUM(c1) FROM t1; 835SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 836REPLACE t1 VALUES (5); 837SELECT COUNT(c1),SUM(c1) FROM t1; 838SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 839DROP TABLE t1,t2,t3; 840CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 841CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 842INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 843CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 844INSERT INTO t3 (c1) VALUES(5); 845SELECT COUNT(c1),SUM(c1) FROM t1; 846SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 847REPLACE t1 VALUES (5); 848SELECT COUNT(c1),SUM(c1) FROM t1; 849SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 850DROP TABLE t1,t2,t3; 851CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 852CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 853INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 854CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 855INSERT INTO t3 (c1) VALUES(5); 856SELECT COUNT(c1),SUM(c1) FROM t1; 857SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 858REPLACE t1 VALUES (5); 859SELECT COUNT(c1),SUM(c1) FROM t1; 860SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 861DROP TABLE t1,t2,t3; 862CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 863CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 864INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 865CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 866INSERT INTO t3 (c1) VALUES(5); 867SELECT COUNT(c1),SUM(c1) FROM t2; 868SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 869REPLACE t2 VALUES (5); 870SELECT COUNT(c1),SUM(c1) FROM t2; 871SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 872DROP TABLE t1,t2,t3; 873CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 874CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 875INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 876CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 877INSERT INTO t3 (c1) VALUES(5); 878SELECT COUNT(c1),SUM(c1) FROM t2; 879SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 880REPLACE t2 VALUES (5); 881SELECT COUNT(c1),SUM(c1) FROM t2; 882SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 883DROP TABLE t1,t2,t3; 884CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 885CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 886INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 887CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 888INSERT INTO t3 (c1) VALUES(5); 889SELECT COUNT(c1),SUM(c1) FROM t2; 890SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 891REPLACE t2 VALUES (5); 892SELECT COUNT(c1),SUM(c1) FROM t2; 893SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 894DROP TABLE t1,t2,t3; 895CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 896CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 897INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 898CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 899INSERT INTO t3 (c1) VALUES(5); 900SELECT COUNT(c1),SUM(c1) FROM t2; 901SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 902REPLACE t2 VALUES (5); 903SELECT COUNT(c1),SUM(c1) FROM t2; 904SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 905DROP TABLE t1,t2,t3; 906CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 907CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 908INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 909CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 910INSERT INTO t3 (c1) VALUES(5); 911SELECT COUNT(c1),SUM(c1) FROM t2; 912SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 913REPLACE t2 VALUES (5); 914SELECT COUNT(c1),SUM(c1) FROM t2; 915SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 916DROP TABLE t1,t2,t3; 917CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 918CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 919INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 920CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 921INSERT INTO t3 (c1) VALUES(5); 922SELECT COUNT(c1),SUM(c1) FROM t2; 923SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 924REPLACE t2 VALUES (5); 925SELECT COUNT(c1),SUM(c1) FROM t2; 926SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 927DROP TABLE t1,t2,t3; 928CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 929CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 930INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 931CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 932INSERT INTO t3 (c1) VALUES(5); 933SELECT COUNT(c1),SUM(c1) FROM t3; 934SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 935REPLACE t3 VALUES (5); 936SELECT COUNT(c1),SUM(c1) FROM t3; 937SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 938DROP TABLE t1,t2,t3; 939CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 940CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 941INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 942CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 943INSERT INTO t3 (c1) VALUES(5); 944SELECT COUNT(c1),SUM(c1) FROM t3; 945SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 946REPLACE t3 VALUES (5); 947SELECT COUNT(c1),SUM(c1) FROM t3; 948SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 949DROP TABLE t1,t2,t3; 950CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 951CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 952INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 953CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 954INSERT INTO t3 (c1) VALUES(5); 955SELECT COUNT(c1),SUM(c1) FROM t3; 956SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 957REPLACE t3 VALUES (5); 958SELECT COUNT(c1),SUM(c1) FROM t3; 959SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 960DROP TABLE t1,t2,t3; 961CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 962CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 963INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 964CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 965INSERT INTO t3 (c1) VALUES(5); 966SELECT COUNT(c1),SUM(c1) FROM t3; 967SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 968REPLACE t3 VALUES (5); 969SELECT COUNT(c1),SUM(c1) FROM t3; 970SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 971DROP TABLE t1,t2,t3; 972CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 973CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 974INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 975CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 976INSERT INTO t3 (c1) VALUES(5); 977SELECT COUNT(c1),SUM(c1) FROM t3; 978SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 979REPLACE t3 VALUES (5); 980SELECT COUNT(c1),SUM(c1) FROM t3; 981SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 982DROP TABLE t1,t2,t3; 983CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 984CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 985INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 986CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 987INSERT INTO t3 (c1) VALUES(5); 988SELECT COUNT(c1),SUM(c1) FROM t3; 989SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 990REPLACE t3 VALUES (5); 991SELECT COUNT(c1),SUM(c1) FROM t3; 992SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 993DROP TABLE t1,t2,t3; 994CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 995CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 996INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 997CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 998INSERT INTO t3 (c1) VALUES(5); 999SELECT COUNT(c1),SUM(c1) FROM t1; 1000SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1001REPLACE t1 VALUES (5); 1002SELECT COUNT(c1),SUM(c1) FROM t1; 1003SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1004DROP TABLE t1,t2,t3; 1005CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 1006CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 1007INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1008CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 1009INSERT INTO t3 (c1) VALUES(5); 1010SELECT COUNT(c1),SUM(c1) FROM t1; 1011SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1012REPLACE t1 VALUES (5); 1013SELECT COUNT(c1),SUM(c1) FROM t1; 1014SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1015DROP TABLE t1,t2,t3; 1016CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1017CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1018INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1019CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1020INSERT INTO t3 (c1) VALUES(5); 1021SELECT COUNT(c1),SUM(c1) FROM t1; 1022SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1023REPLACE t1 VALUES (5); 1024SELECT COUNT(c1),SUM(c1) FROM t1; 1025SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1026DROP TABLE t1,t2,t3; 1027CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 1028CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 1029INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1030CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 1031INSERT INTO t3 (c1) VALUES(5); 1032SELECT COUNT(c1),SUM(c1) FROM t1; 1033SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1034REPLACE t1 VALUES (5); 1035SELECT COUNT(c1),SUM(c1) FROM t1; 1036SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1037DROP TABLE t1,t2,t3; 1038CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 1039CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 1040INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1041CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 1042INSERT INTO t3 (c1) VALUES(5); 1043SELECT COUNT(c1),SUM(c1) FROM t1; 1044SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1045REPLACE t1 VALUES (5); 1046SELECT COUNT(c1),SUM(c1) FROM t1; 1047SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1048DROP TABLE t1,t2,t3; 1049CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 1050CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 1051INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1052CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 1053INSERT INTO t3 (c1) VALUES(5); 1054SELECT COUNT(c1),SUM(c1) FROM t1; 1055SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1056REPLACE t1 VALUES (5); 1057SELECT COUNT(c1),SUM(c1) FROM t1; 1058SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1059DROP TABLE t1,t2,t3; 1060CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 1061CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 1062INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1063CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 1064INSERT INTO t3 (c1) VALUES(5); 1065SELECT COUNT(c1),SUM(c1) FROM t2; 1066SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1067REPLACE t2 VALUES (5); 1068SELECT COUNT(c1),SUM(c1) FROM t2; 1069SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1070DROP TABLE t1,t2,t3; 1071CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 1072CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 1073INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1074CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 1075INSERT INTO t3 (c1) VALUES(5); 1076SELECT COUNT(c1),SUM(c1) FROM t2; 1077SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1078REPLACE t2 VALUES (5); 1079SELECT COUNT(c1),SUM(c1) FROM t2; 1080SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1081DROP TABLE t1,t2,t3; 1082CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1083CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1084INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1085CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1086INSERT INTO t3 (c1) VALUES(5); 1087SELECT COUNT(c1),SUM(c1) FROM t2; 1088SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1089REPLACE t2 VALUES (5); 1090SELECT COUNT(c1),SUM(c1) FROM t2; 1091SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1092DROP TABLE t1,t2,t3; 1093CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 1094CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 1095INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1096CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 1097INSERT INTO t3 (c1) VALUES(5); 1098SELECT COUNT(c1),SUM(c1) FROM t2; 1099SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1100REPLACE t2 VALUES (5); 1101SELECT COUNT(c1),SUM(c1) FROM t2; 1102SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1103DROP TABLE t1,t2,t3; 1104CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 1105CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 1106INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1107CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 1108INSERT INTO t3 (c1) VALUES(5); 1109SELECT COUNT(c1),SUM(c1) FROM t2; 1110SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1111REPLACE t2 VALUES (5); 1112SELECT COUNT(c1),SUM(c1) FROM t2; 1113SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1114DROP TABLE t1,t2,t3; 1115CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 1116CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 1117INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1118CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 1119INSERT INTO t3 (c1) VALUES(5); 1120SELECT COUNT(c1),SUM(c1) FROM t2; 1121SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1122REPLACE t2 VALUES (5); 1123SELECT COUNT(c1),SUM(c1) FROM t2; 1124SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1125DROP TABLE t1,t2,t3; 1126CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 1127CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 1128INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1129CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 1130INSERT INTO t3 (c1) VALUES(5); 1131SELECT COUNT(c1),SUM(c1) FROM t3; 1132SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 1133REPLACE t3 VALUES (5); 1134SELECT COUNT(c1),SUM(c1) FROM t3; 1135SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 1136DROP TABLE t1,t2,t3; 1137CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 1138CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 1139INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1140CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 1141INSERT INTO t3 (c1) VALUES(5); 1142SELECT COUNT(c1),SUM(c1) FROM t3; 1143SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 1144REPLACE t3 VALUES (5); 1145SELECT COUNT(c1),SUM(c1) FROM t3; 1146SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 1147DROP TABLE t1,t2,t3; 1148CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1149CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1150INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1151CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1152INSERT INTO t3 (c1) VALUES(5); 1153SELECT COUNT(c1),SUM(c1) FROM t3; 1154SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 1155REPLACE t3 VALUES (5); 1156SELECT COUNT(c1),SUM(c1) FROM t3; 1157SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 1158DROP TABLE t1,t2,t3; 1159CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 1160CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 1161INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1162CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 1163INSERT INTO t3 (c1) VALUES(5); 1164SELECT COUNT(c1),SUM(c1) FROM t3; 1165SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 1166REPLACE t3 VALUES (5); 1167SELECT COUNT(c1),SUM(c1) FROM t3; 1168SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 1169DROP TABLE t1,t2,t3; 1170CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 1171CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 1172INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1173CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 1174INSERT INTO t3 (c1) VALUES(5); 1175SELECT COUNT(c1),SUM(c1) FROM t3; 1176SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 1177REPLACE t3 VALUES (5); 1178SELECT COUNT(c1),SUM(c1) FROM t3; 1179SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 1180DROP TABLE t1,t2,t3; 1181CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 1182CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 1183INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1184CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 1185INSERT INTO t3 (c1) VALUES(5); 1186SELECT COUNT(c1),SUM(c1) FROM t3; 1187SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 1188REPLACE t3 VALUES (5); 1189SELECT COUNT(c1),SUM(c1) FROM t3; 1190SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 1191DROP TABLE t1,t2,t3; 1192CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 1193CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 1194INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1195CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 1196INSERT INTO t3 (c1) VALUES(5); 1197SELECT COUNT(c1),SUM(c1) FROM t1; 1198SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 1199REPLACE t1 VALUES (5); 1200SELECT COUNT(c1),SUM(c1) FROM t1; 1201SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 1202DROP TABLE t1,t2,t3; 1203CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 1204CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 1205INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1206CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 1207INSERT INTO t3 (c1) VALUES(5); 1208SELECT COUNT(c1),SUM(c1) FROM t1; 1209SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 1210REPLACE t1 VALUES (5); 1211SELECT COUNT(c1),SUM(c1) FROM t1; 1212SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 1213DROP TABLE t1,t2,t3; 1214CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1215CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1216INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1217CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1218INSERT INTO t3 (c1) VALUES(5); 1219SELECT COUNT(c1),SUM(c1) FROM t1; 1220SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 1221REPLACE t1 VALUES (5); 1222SELECT COUNT(c1),SUM(c1) FROM t1; 1223SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 1224DROP TABLE t1,t2,t3; 1225CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 1226CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 1227INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1228CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 1229INSERT INTO t3 (c1) VALUES(5); 1230SELECT COUNT(c1),SUM(c1) FROM t1; 1231SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 1232REPLACE t1 VALUES (5); 1233SELECT COUNT(c1),SUM(c1) FROM t1; 1234SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 1235DROP TABLE t1,t2,t3; 1236CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 1237CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 1238INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1239CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 1240INSERT INTO t3 (c1) VALUES(5); 1241SELECT COUNT(c1),SUM(c1) FROM t1; 1242SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 1243REPLACE t1 VALUES (5); 1244SELECT COUNT(c1),SUM(c1) FROM t1; 1245SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 1246DROP TABLE t1,t2,t3; 1247CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 1248CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 1249INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1250CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 1251INSERT INTO t3 (c1) VALUES(5); 1252SELECT COUNT(c1),SUM(c1) FROM t1; 1253SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 1254REPLACE t1 VALUES (5); 1255SELECT COUNT(c1),SUM(c1) FROM t1; 1256SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 1257DROP TABLE t1,t2,t3; 1258CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 1259CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 1260INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1261CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 1262INSERT INTO t3 (c1) VALUES(5); 1263SELECT COUNT(c1),SUM(c1) FROM t2; 1264SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 1265REPLACE t2 VALUES (5); 1266SELECT COUNT(c1),SUM(c1) FROM t2; 1267SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 1268DROP TABLE t1,t2,t3; 1269CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 1270CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 1271INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1272CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 1273INSERT INTO t3 (c1) VALUES(5); 1274SELECT COUNT(c1),SUM(c1) FROM t2; 1275SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 1276REPLACE t2 VALUES (5); 1277SELECT COUNT(c1),SUM(c1) FROM t2; 1278SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 1279DROP TABLE t1,t2,t3; 1280CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1281CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1282INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1283CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1284INSERT INTO t3 (c1) VALUES(5); 1285SELECT COUNT(c1),SUM(c1) FROM t2; 1286SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 1287REPLACE t2 VALUES (5); 1288SELECT COUNT(c1),SUM(c1) FROM t2; 1289SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 1290DROP TABLE t1,t2,t3; 1291CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 1292CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 1293INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1294CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 1295INSERT INTO t3 (c1) VALUES(5); 1296SELECT COUNT(c1),SUM(c1) FROM t2; 1297SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 1298REPLACE t2 VALUES (5); 1299SELECT COUNT(c1),SUM(c1) FROM t2; 1300SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 1301DROP TABLE t1,t2,t3; 1302CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 1303CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 1304INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1305CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 1306INSERT INTO t3 (c1) VALUES(5); 1307SELECT COUNT(c1),SUM(c1) FROM t2; 1308SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 1309REPLACE t2 VALUES (5); 1310SELECT COUNT(c1),SUM(c1) FROM t2; 1311SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 1312DROP TABLE t1,t2,t3; 1313CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 1314CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 1315INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1316CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 1317INSERT INTO t3 (c1) VALUES(5); 1318SELECT COUNT(c1),SUM(c1) FROM t2; 1319SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 1320REPLACE t2 VALUES (5); 1321SELECT COUNT(c1),SUM(c1) FROM t2; 1322SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 1323DROP TABLE t1,t2,t3; 1324CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 1325CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 1326INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1327CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 1328INSERT INTO t3 (c1) VALUES(5); 1329SELECT COUNT(c1),SUM(c1) FROM t3; 1330SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 1331REPLACE t3 VALUES (5); 1332SELECT COUNT(c1),SUM(c1) FROM t3; 1333SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 1334DROP TABLE t1,t2,t3; 1335CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 1336CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 1337INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1338CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 1339INSERT INTO t3 (c1) VALUES(5); 1340SELECT COUNT(c1),SUM(c1) FROM t3; 1341SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 1342REPLACE t3 VALUES (5); 1343SELECT COUNT(c1),SUM(c1) FROM t3; 1344SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 1345DROP TABLE t1,t2,t3; 1346CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1347CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1348INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1349CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1350INSERT INTO t3 (c1) VALUES(5); 1351SELECT COUNT(c1),SUM(c1) FROM t3; 1352SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 1353REPLACE t3 VALUES (5); 1354SELECT COUNT(c1),SUM(c1) FROM t3; 1355SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 1356DROP TABLE t1,t2,t3; 1357CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 1358CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 1359INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1360CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 1361INSERT INTO t3 (c1) VALUES(5); 1362SELECT COUNT(c1),SUM(c1) FROM t3; 1363SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 1364REPLACE t3 VALUES (5); 1365SELECT COUNT(c1),SUM(c1) FROM t3; 1366SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 1367DROP TABLE t1,t2,t3; 1368CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 1369CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 1370INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1371CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 1372INSERT INTO t3 (c1) VALUES(5); 1373SELECT COUNT(c1),SUM(c1) FROM t3; 1374SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 1375REPLACE t3 VALUES (5); 1376SELECT COUNT(c1),SUM(c1) FROM t3; 1377SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 1378DROP TABLE t1,t2,t3; 1379CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 1380CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 1381INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1382CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 1383INSERT INTO t3 (c1) VALUES(5); 1384SELECT COUNT(c1),SUM(c1) FROM t3; 1385SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 1386REPLACE t3 VALUES (5); 1387SELECT COUNT(c1),SUM(c1) FROM t3; 1388SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 1389DROP TABLE t1,t2,t3; 1390 1391