1DROP TABLE IF EXISTS t1,t2,t3; 2CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 3CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 4INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 5CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 6INSERT INTO t3 (c1) VALUES(5); 7SELECT COUNT(c1),SUM(c1) FROM t1; 8COUNT(c1) SUM(c1) 90 NULL 10SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 11COUNT(c1) SUM(c1) 120 NULL 13REPLACE t1 VALUES (5); 14SELECT COUNT(c1),SUM(c1) FROM t1; 15COUNT(c1) SUM(c1) 161 5 17SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 18COUNT(c1) SUM(c1) 190 NULL 20DROP TABLE t1,t2,t3; 21CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 22CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 23INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 24CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 25INSERT INTO t3 (c1) VALUES(5); 26SELECT COUNT(c1),SUM(c1) FROM t1; 27COUNT(c1) SUM(c1) 280 NULL 29SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 30COUNT(c1) SUM(c1) 310 NULL 32REPLACE t1 VALUES (5); 33SELECT COUNT(c1),SUM(c1) FROM t1; 34COUNT(c1) SUM(c1) 351 5 36SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 37COUNT(c1) SUM(c1) 380 NULL 39DROP TABLE t1,t2,t3; 40CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 41CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 42INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 43CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 44INSERT INTO t3 (c1) VALUES(5); 45SELECT COUNT(c1),SUM(c1) FROM t1; 46COUNT(c1) SUM(c1) 470 NULL 48SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 49COUNT(c1) SUM(c1) 500 NULL 51REPLACE t1 VALUES (5); 52SELECT COUNT(c1),SUM(c1) FROM t1; 53COUNT(c1) SUM(c1) 541 5 55SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 56COUNT(c1) SUM(c1) 570 NULL 58DROP TABLE t1,t2,t3; 59CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 60CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 61INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 62CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 63INSERT INTO t3 (c1) VALUES(5); 64SELECT COUNT(c1),SUM(c1) FROM t1; 65COUNT(c1) SUM(c1) 660 NULL 67SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 68COUNT(c1) SUM(c1) 690 NULL 70REPLACE t1 VALUES (5); 71SELECT COUNT(c1),SUM(c1) FROM t1; 72COUNT(c1) SUM(c1) 731 5 74SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 75COUNT(c1) SUM(c1) 760 NULL 77DROP TABLE t1,t2,t3; 78CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 79CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 80INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 81CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 82INSERT INTO t3 (c1) VALUES(5); 83SELECT COUNT(c1),SUM(c1) FROM t1; 84COUNT(c1) SUM(c1) 850 NULL 86SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 87COUNT(c1) SUM(c1) 880 NULL 89REPLACE t1 VALUES (5); 90SELECT COUNT(c1),SUM(c1) FROM t1; 91COUNT(c1) SUM(c1) 921 5 93SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 94COUNT(c1) SUM(c1) 950 NULL 96DROP TABLE t1,t2,t3; 97CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 98CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 99INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 100CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 101INSERT INTO t3 (c1) VALUES(5); 102SELECT COUNT(c1),SUM(c1) FROM t1; 103COUNT(c1) SUM(c1) 1040 NULL 105SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 106COUNT(c1) SUM(c1) 1070 NULL 108REPLACE t1 VALUES (5); 109SELECT COUNT(c1),SUM(c1) FROM t1; 110COUNT(c1) SUM(c1) 1111 5 112SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 < 5; 113COUNT(c1) SUM(c1) 1140 NULL 115DROP TABLE t1,t2,t3; 116CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 117CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 118INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 119CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 120INSERT INTO t3 (c1) VALUES(5); 121SELECT COUNT(c1),SUM(c1) FROM t2; 122COUNT(c1) SUM(c1) 12310 45 124SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 125COUNT(c1) SUM(c1) 1265 10 127REPLACE t2 VALUES (5); 128SELECT COUNT(c1),SUM(c1) FROM t2; 129COUNT(c1) SUM(c1) 13010 45 131SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 132COUNT(c1) SUM(c1) 1335 10 134DROP TABLE t1,t2,t3; 135CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 136CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 137INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 138CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 139INSERT INTO t3 (c1) VALUES(5); 140SELECT COUNT(c1),SUM(c1) FROM t2; 141COUNT(c1) SUM(c1) 14210 45 143SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 144COUNT(c1) SUM(c1) 1455 10 146REPLACE t2 VALUES (5); 147SELECT COUNT(c1),SUM(c1) FROM t2; 148COUNT(c1) SUM(c1) 14910 45 150SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 151COUNT(c1) SUM(c1) 1525 10 153DROP TABLE t1,t2,t3; 154CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 155CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 156INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 157CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 158INSERT INTO t3 (c1) VALUES(5); 159SELECT COUNT(c1),SUM(c1) FROM t2; 160COUNT(c1) SUM(c1) 16110 45 162SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 163COUNT(c1) SUM(c1) 1645 10 165REPLACE t2 VALUES (5); 166SELECT COUNT(c1),SUM(c1) FROM t2; 167COUNT(c1) SUM(c1) 16810 45 169SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 170COUNT(c1) SUM(c1) 1715 10 172DROP TABLE t1,t2,t3; 173CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 174CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 175INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 176CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 177INSERT INTO t3 (c1) VALUES(5); 178SELECT COUNT(c1),SUM(c1) FROM t2; 179COUNT(c1) SUM(c1) 18010 45 181SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 182COUNT(c1) SUM(c1) 1835 10 184REPLACE t2 VALUES (5); 185SELECT COUNT(c1),SUM(c1) FROM t2; 186COUNT(c1) SUM(c1) 18710 45 188SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 189COUNT(c1) SUM(c1) 1905 10 191DROP TABLE t1,t2,t3; 192CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 193CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 194INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 195CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 196INSERT INTO t3 (c1) VALUES(5); 197SELECT COUNT(c1),SUM(c1) FROM t2; 198COUNT(c1) SUM(c1) 19910 45 200SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 201COUNT(c1) SUM(c1) 2025 10 203REPLACE t2 VALUES (5); 204SELECT COUNT(c1),SUM(c1) FROM t2; 205COUNT(c1) SUM(c1) 20610 45 207SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 208COUNT(c1) SUM(c1) 2095 10 210DROP TABLE t1,t2,t3; 211CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 212CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 213INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 214CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 215INSERT INTO t3 (c1) VALUES(5); 216SELECT COUNT(c1),SUM(c1) FROM t2; 217COUNT(c1) SUM(c1) 21810 45 219SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 220COUNT(c1) SUM(c1) 2215 10 222REPLACE t2 VALUES (5); 223SELECT COUNT(c1),SUM(c1) FROM t2; 224COUNT(c1) SUM(c1) 22510 45 226SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 < 5; 227COUNT(c1) SUM(c1) 2285 10 229DROP TABLE t1,t2,t3; 230CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 231CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 232INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 233CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 234INSERT INTO t3 (c1) VALUES(5); 235SELECT COUNT(c1),SUM(c1) FROM t3; 236COUNT(c1) SUM(c1) 2371 5 238SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 239COUNT(c1) SUM(c1) 2400 NULL 241REPLACE t3 VALUES (5); 242SELECT COUNT(c1),SUM(c1) FROM t3; 243COUNT(c1) SUM(c1) 2441 5 245SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 246COUNT(c1) SUM(c1) 2470 NULL 248DROP TABLE t1,t2,t3; 249CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 250CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 251INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 252CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 253INSERT INTO t3 (c1) VALUES(5); 254SELECT COUNT(c1),SUM(c1) FROM t3; 255COUNT(c1) SUM(c1) 2561 5 257SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 258COUNT(c1) SUM(c1) 2590 NULL 260REPLACE t3 VALUES (5); 261SELECT COUNT(c1),SUM(c1) FROM t3; 262COUNT(c1) SUM(c1) 2631 5 264SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 265COUNT(c1) SUM(c1) 2660 NULL 267DROP TABLE t1,t2,t3; 268CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 269CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 270INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 271CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 272INSERT INTO t3 (c1) VALUES(5); 273SELECT COUNT(c1),SUM(c1) FROM t3; 274COUNT(c1) SUM(c1) 2751 5 276SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 277COUNT(c1) SUM(c1) 2780 NULL 279REPLACE t3 VALUES (5); 280SELECT COUNT(c1),SUM(c1) FROM t3; 281COUNT(c1) SUM(c1) 2821 5 283SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 284COUNT(c1) SUM(c1) 2850 NULL 286DROP TABLE t1,t2,t3; 287CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 288CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 289INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 290CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 291INSERT INTO t3 (c1) VALUES(5); 292SELECT COUNT(c1),SUM(c1) FROM t3; 293COUNT(c1) SUM(c1) 2941 5 295SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 296COUNT(c1) SUM(c1) 2970 NULL 298REPLACE t3 VALUES (5); 299SELECT COUNT(c1),SUM(c1) FROM t3; 300COUNT(c1) SUM(c1) 3011 5 302SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 303COUNT(c1) SUM(c1) 3040 NULL 305DROP TABLE t1,t2,t3; 306CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 307CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 308INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 309CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 310INSERT INTO t3 (c1) VALUES(5); 311SELECT COUNT(c1),SUM(c1) FROM t3; 312COUNT(c1) SUM(c1) 3131 5 314SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 315COUNT(c1) SUM(c1) 3160 NULL 317REPLACE t3 VALUES (5); 318SELECT COUNT(c1),SUM(c1) FROM t3; 319COUNT(c1) SUM(c1) 3201 5 321SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 322COUNT(c1) SUM(c1) 3230 NULL 324DROP TABLE t1,t2,t3; 325CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 326CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 327INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 328CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 329INSERT INTO t3 (c1) VALUES(5); 330SELECT COUNT(c1),SUM(c1) FROM t3; 331COUNT(c1) SUM(c1) 3321 5 333SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 334COUNT(c1) SUM(c1) 3350 NULL 336REPLACE t3 VALUES (5); 337SELECT COUNT(c1),SUM(c1) FROM t3; 338COUNT(c1) SUM(c1) 3391 5 340SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 < 5; 341COUNT(c1) SUM(c1) 3420 NULL 343DROP TABLE t1,t2,t3; 344CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 345CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 346INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 347CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 348INSERT INTO t3 (c1) VALUES(5); 349SELECT COUNT(c1),SUM(c1) FROM t1; 350COUNT(c1) SUM(c1) 3510 NULL 352SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 353COUNT(c1) SUM(c1) 3540 NULL 355REPLACE t1 VALUES (5); 356SELECT COUNT(c1),SUM(c1) FROM t1; 357COUNT(c1) SUM(c1) 3581 5 359SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 360COUNT(c1) SUM(c1) 3611 5 362DROP TABLE t1,t2,t3; 363CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 364CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 365INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 366CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 367INSERT INTO t3 (c1) VALUES(5); 368SELECT COUNT(c1),SUM(c1) FROM t1; 369COUNT(c1) SUM(c1) 3700 NULL 371SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 372COUNT(c1) SUM(c1) 3730 NULL 374REPLACE t1 VALUES (5); 375SELECT COUNT(c1),SUM(c1) FROM t1; 376COUNT(c1) SUM(c1) 3771 5 378SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 379COUNT(c1) SUM(c1) 3801 5 381DROP TABLE t1,t2,t3; 382CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 383CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 384INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 385CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 386INSERT INTO t3 (c1) VALUES(5); 387SELECT COUNT(c1),SUM(c1) FROM t1; 388COUNT(c1) SUM(c1) 3890 NULL 390SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 391COUNT(c1) SUM(c1) 3920 NULL 393REPLACE t1 VALUES (5); 394SELECT COUNT(c1),SUM(c1) FROM t1; 395COUNT(c1) SUM(c1) 3961 5 397SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 398COUNT(c1) SUM(c1) 3991 5 400DROP TABLE t1,t2,t3; 401CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 402CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 403INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 404CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 405INSERT INTO t3 (c1) VALUES(5); 406SELECT COUNT(c1),SUM(c1) FROM t1; 407COUNT(c1) SUM(c1) 4080 NULL 409SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 410COUNT(c1) SUM(c1) 4110 NULL 412REPLACE t1 VALUES (5); 413SELECT COUNT(c1),SUM(c1) FROM t1; 414COUNT(c1) SUM(c1) 4151 5 416SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 417COUNT(c1) SUM(c1) 4181 5 419DROP TABLE t1,t2,t3; 420CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 421CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 422INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 423CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 424INSERT INTO t3 (c1) VALUES(5); 425SELECT COUNT(c1),SUM(c1) FROM t1; 426COUNT(c1) SUM(c1) 4270 NULL 428SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 429COUNT(c1) SUM(c1) 4300 NULL 431REPLACE t1 VALUES (5); 432SELECT COUNT(c1),SUM(c1) FROM t1; 433COUNT(c1) SUM(c1) 4341 5 435SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 436COUNT(c1) SUM(c1) 4371 5 438DROP TABLE t1,t2,t3; 439CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 440CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 441INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 442CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 443INSERT INTO t3 (c1) VALUES(5); 444SELECT COUNT(c1),SUM(c1) FROM t1; 445COUNT(c1) SUM(c1) 4460 NULL 447SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 448COUNT(c1) SUM(c1) 4490 NULL 450REPLACE t1 VALUES (5); 451SELECT COUNT(c1),SUM(c1) FROM t1; 452COUNT(c1) SUM(c1) 4531 5 454SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <= 5; 455COUNT(c1) SUM(c1) 4561 5 457DROP TABLE t1,t2,t3; 458CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 459CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 460INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 461CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 462INSERT INTO t3 (c1) VALUES(5); 463SELECT COUNT(c1),SUM(c1) FROM t2; 464COUNT(c1) SUM(c1) 46510 45 466SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 467COUNT(c1) SUM(c1) 4686 15 469REPLACE t2 VALUES (5); 470SELECT COUNT(c1),SUM(c1) FROM t2; 471COUNT(c1) SUM(c1) 47210 45 473SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 474COUNT(c1) SUM(c1) 4756 15 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; 483COUNT(c1) SUM(c1) 48410 45 485SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 486COUNT(c1) SUM(c1) 4876 15 488REPLACE t2 VALUES (5); 489SELECT COUNT(c1),SUM(c1) FROM t2; 490COUNT(c1) SUM(c1) 49110 45 492SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 493COUNT(c1) SUM(c1) 4946 15 495DROP TABLE t1,t2,t3; 496CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 497CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 498INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 499CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 500INSERT INTO t3 (c1) VALUES(5); 501SELECT COUNT(c1),SUM(c1) FROM t2; 502COUNT(c1) SUM(c1) 50310 45 504SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 505COUNT(c1) SUM(c1) 5066 15 507REPLACE t2 VALUES (5); 508SELECT COUNT(c1),SUM(c1) FROM t2; 509COUNT(c1) SUM(c1) 51010 45 511SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 512COUNT(c1) SUM(c1) 5136 15 514DROP TABLE t1,t2,t3; 515CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 516CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 517INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 518CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 519INSERT INTO t3 (c1) VALUES(5); 520SELECT COUNT(c1),SUM(c1) FROM t2; 521COUNT(c1) SUM(c1) 52210 45 523SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 524COUNT(c1) SUM(c1) 5256 15 526REPLACE t2 VALUES (5); 527SELECT COUNT(c1),SUM(c1) FROM t2; 528COUNT(c1) SUM(c1) 52910 45 530SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 531COUNT(c1) SUM(c1) 5326 15 533DROP TABLE t1,t2,t3; 534CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 535CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 536INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 537CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 538INSERT INTO t3 (c1) VALUES(5); 539SELECT COUNT(c1),SUM(c1) FROM t2; 540COUNT(c1) SUM(c1) 54110 45 542SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 543COUNT(c1) SUM(c1) 5446 15 545REPLACE t2 VALUES (5); 546SELECT COUNT(c1),SUM(c1) FROM t2; 547COUNT(c1) SUM(c1) 54810 45 549SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 550COUNT(c1) SUM(c1) 5516 15 552DROP TABLE t1,t2,t3; 553CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 554CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 555INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 556CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 557INSERT INTO t3 (c1) VALUES(5); 558SELECT COUNT(c1),SUM(c1) FROM t2; 559COUNT(c1) SUM(c1) 56010 45 561SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 562COUNT(c1) SUM(c1) 5636 15 564REPLACE t2 VALUES (5); 565SELECT COUNT(c1),SUM(c1) FROM t2; 566COUNT(c1) SUM(c1) 56710 45 568SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <= 5; 569COUNT(c1) SUM(c1) 5706 15 571DROP TABLE t1,t2,t3; 572CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 573CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 574INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 575CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 576INSERT INTO t3 (c1) VALUES(5); 577SELECT COUNT(c1),SUM(c1) FROM t3; 578COUNT(c1) SUM(c1) 5791 5 580SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 581COUNT(c1) SUM(c1) 5821 5 583REPLACE t3 VALUES (5); 584SELECT COUNT(c1),SUM(c1) FROM t3; 585COUNT(c1) SUM(c1) 5861 5 587SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 588COUNT(c1) SUM(c1) 5891 5 590DROP TABLE t1,t2,t3; 591CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 592CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 593INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 594CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 595INSERT INTO t3 (c1) VALUES(5); 596SELECT COUNT(c1),SUM(c1) FROM t3; 597COUNT(c1) SUM(c1) 5981 5 599SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 600COUNT(c1) SUM(c1) 6011 5 602REPLACE t3 VALUES (5); 603SELECT COUNT(c1),SUM(c1) FROM t3; 604COUNT(c1) SUM(c1) 6051 5 606SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 607COUNT(c1) SUM(c1) 6081 5 609DROP TABLE t1,t2,t3; 610CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 611CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 612INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 613CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 614INSERT INTO t3 (c1) VALUES(5); 615SELECT COUNT(c1),SUM(c1) FROM t3; 616COUNT(c1) SUM(c1) 6171 5 618SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 619COUNT(c1) SUM(c1) 6201 5 621REPLACE t3 VALUES (5); 622SELECT COUNT(c1),SUM(c1) FROM t3; 623COUNT(c1) SUM(c1) 6241 5 625SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 626COUNT(c1) SUM(c1) 6271 5 628DROP TABLE t1,t2,t3; 629CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 630CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 631INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 632CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 633INSERT INTO t3 (c1) VALUES(5); 634SELECT COUNT(c1),SUM(c1) FROM t3; 635COUNT(c1) SUM(c1) 6361 5 637SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 638COUNT(c1) SUM(c1) 6391 5 640REPLACE t3 VALUES (5); 641SELECT COUNT(c1),SUM(c1) FROM t3; 642COUNT(c1) SUM(c1) 6431 5 644SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 645COUNT(c1) SUM(c1) 6461 5 647DROP TABLE t1,t2,t3; 648CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 649CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 650INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 651CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 652INSERT INTO t3 (c1) VALUES(5); 653SELECT COUNT(c1),SUM(c1) FROM t3; 654COUNT(c1) SUM(c1) 6551 5 656SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 657COUNT(c1) SUM(c1) 6581 5 659REPLACE t3 VALUES (5); 660SELECT COUNT(c1),SUM(c1) FROM t3; 661COUNT(c1) SUM(c1) 6621 5 663SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 664COUNT(c1) SUM(c1) 6651 5 666DROP TABLE t1,t2,t3; 667CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 668CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 669INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 670CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 671INSERT INTO t3 (c1) VALUES(5); 672SELECT COUNT(c1),SUM(c1) FROM t3; 673COUNT(c1) SUM(c1) 6741 5 675SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 676COUNT(c1) SUM(c1) 6771 5 678REPLACE t3 VALUES (5); 679SELECT COUNT(c1),SUM(c1) FROM t3; 680COUNT(c1) SUM(c1) 6811 5 682SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <= 5; 683COUNT(c1) SUM(c1) 6841 5 685DROP TABLE t1,t2,t3; 686CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 687CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 688INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 689CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 690INSERT INTO t3 (c1) VALUES(5); 691SELECT COUNT(c1),SUM(c1) FROM t1; 692COUNT(c1) SUM(c1) 6930 NULL 694SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 695COUNT(c1) SUM(c1) 6960 NULL 697REPLACE t1 VALUES (5); 698SELECT COUNT(c1),SUM(c1) FROM t1; 699COUNT(c1) SUM(c1) 7001 5 701SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 702COUNT(c1) SUM(c1) 7031 5 704DROP TABLE t1,t2,t3; 705CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 706CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 707INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 708CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 709INSERT INTO t3 (c1) VALUES(5); 710SELECT COUNT(c1),SUM(c1) FROM t1; 711COUNT(c1) SUM(c1) 7120 NULL 713SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 714COUNT(c1) SUM(c1) 7150 NULL 716REPLACE t1 VALUES (5); 717SELECT COUNT(c1),SUM(c1) FROM t1; 718COUNT(c1) SUM(c1) 7191 5 720SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 721COUNT(c1) SUM(c1) 7221 5 723DROP TABLE t1,t2,t3; 724CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 725CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 726INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 727CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 728INSERT INTO t3 (c1) VALUES(5); 729SELECT COUNT(c1),SUM(c1) FROM t1; 730COUNT(c1) SUM(c1) 7310 NULL 732SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 733COUNT(c1) SUM(c1) 7340 NULL 735REPLACE t1 VALUES (5); 736SELECT COUNT(c1),SUM(c1) FROM t1; 737COUNT(c1) SUM(c1) 7381 5 739SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 740COUNT(c1) SUM(c1) 7411 5 742DROP TABLE t1,t2,t3; 743CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 744CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 745INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 746CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 747INSERT INTO t3 (c1) VALUES(5); 748SELECT COUNT(c1),SUM(c1) FROM t1; 749COUNT(c1) SUM(c1) 7500 NULL 751SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 752COUNT(c1) SUM(c1) 7530 NULL 754REPLACE t1 VALUES (5); 755SELECT COUNT(c1),SUM(c1) FROM t1; 756COUNT(c1) SUM(c1) 7571 5 758SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 759COUNT(c1) SUM(c1) 7601 5 761DROP TABLE t1,t2,t3; 762CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 763CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 764INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 765CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 766INSERT INTO t3 (c1) VALUES(5); 767SELECT COUNT(c1),SUM(c1) FROM t1; 768COUNT(c1) SUM(c1) 7690 NULL 770SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 771COUNT(c1) SUM(c1) 7720 NULL 773REPLACE t1 VALUES (5); 774SELECT COUNT(c1),SUM(c1) FROM t1; 775COUNT(c1) SUM(c1) 7761 5 777SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 778COUNT(c1) SUM(c1) 7791 5 780DROP TABLE t1,t2,t3; 781CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 782CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 783INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 784CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 785INSERT INTO t3 (c1) VALUES(5); 786SELECT COUNT(c1),SUM(c1) FROM t1; 787COUNT(c1) SUM(c1) 7880 NULL 789SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 790COUNT(c1) SUM(c1) 7910 NULL 792REPLACE t1 VALUES (5); 793SELECT COUNT(c1),SUM(c1) FROM t1; 794COUNT(c1) SUM(c1) 7951 5 796SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 = 5; 797COUNT(c1) SUM(c1) 7981 5 799DROP TABLE t1,t2,t3; 800CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 801CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 802INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 803CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 804INSERT INTO t3 (c1) VALUES(5); 805SELECT COUNT(c1),SUM(c1) FROM t2; 806COUNT(c1) SUM(c1) 80710 45 808SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 809COUNT(c1) SUM(c1) 8101 5 811REPLACE t2 VALUES (5); 812SELECT COUNT(c1),SUM(c1) FROM t2; 813COUNT(c1) SUM(c1) 81410 45 815SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 816COUNT(c1) SUM(c1) 8171 5 818DROP TABLE t1,t2,t3; 819CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 820CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 821INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 822CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 823INSERT INTO t3 (c1) VALUES(5); 824SELECT COUNT(c1),SUM(c1) FROM t2; 825COUNT(c1) SUM(c1) 82610 45 827SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 828COUNT(c1) SUM(c1) 8291 5 830REPLACE t2 VALUES (5); 831SELECT COUNT(c1),SUM(c1) FROM t2; 832COUNT(c1) SUM(c1) 83310 45 834SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 835COUNT(c1) SUM(c1) 8361 5 837DROP TABLE t1,t2,t3; 838CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 839CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 840INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 841CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 842INSERT INTO t3 (c1) VALUES(5); 843SELECT COUNT(c1),SUM(c1) FROM t2; 844COUNT(c1) SUM(c1) 84510 45 846SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 847COUNT(c1) SUM(c1) 8481 5 849REPLACE t2 VALUES (5); 850SELECT COUNT(c1),SUM(c1) FROM t2; 851COUNT(c1) SUM(c1) 85210 45 853SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 854COUNT(c1) SUM(c1) 8551 5 856DROP TABLE t1,t2,t3; 857CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 858CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 859INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 860CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 861INSERT INTO t3 (c1) VALUES(5); 862SELECT COUNT(c1),SUM(c1) FROM t2; 863COUNT(c1) SUM(c1) 86410 45 865SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 866COUNT(c1) SUM(c1) 8671 5 868REPLACE t2 VALUES (5); 869SELECT COUNT(c1),SUM(c1) FROM t2; 870COUNT(c1) SUM(c1) 87110 45 872SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 873COUNT(c1) SUM(c1) 8741 5 875DROP TABLE t1,t2,t3; 876CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 877CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 878INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 879CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 880INSERT INTO t3 (c1) VALUES(5); 881SELECT COUNT(c1),SUM(c1) FROM t2; 882COUNT(c1) SUM(c1) 88310 45 884SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 885COUNT(c1) SUM(c1) 8861 5 887REPLACE t2 VALUES (5); 888SELECT COUNT(c1),SUM(c1) FROM t2; 889COUNT(c1) SUM(c1) 89010 45 891SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 892COUNT(c1) SUM(c1) 8931 5 894DROP TABLE t1,t2,t3; 895CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 896CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 897INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 898CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 899INSERT INTO t3 (c1) VALUES(5); 900SELECT COUNT(c1),SUM(c1) FROM t2; 901COUNT(c1) SUM(c1) 90210 45 903SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 904COUNT(c1) SUM(c1) 9051 5 906REPLACE t2 VALUES (5); 907SELECT COUNT(c1),SUM(c1) FROM t2; 908COUNT(c1) SUM(c1) 90910 45 910SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 = 5; 911COUNT(c1) SUM(c1) 9121 5 913DROP TABLE t1,t2,t3; 914CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 915CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 916INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 917CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 918INSERT INTO t3 (c1) VALUES(5); 919SELECT COUNT(c1),SUM(c1) FROM t3; 920COUNT(c1) SUM(c1) 9211 5 922SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 923COUNT(c1) SUM(c1) 9241 5 925REPLACE t3 VALUES (5); 926SELECT COUNT(c1),SUM(c1) FROM t3; 927COUNT(c1) SUM(c1) 9281 5 929SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 930COUNT(c1) SUM(c1) 9311 5 932DROP TABLE t1,t2,t3; 933CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 934CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 935INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 936CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 937INSERT INTO t3 (c1) VALUES(5); 938SELECT COUNT(c1),SUM(c1) FROM t3; 939COUNT(c1) SUM(c1) 9401 5 941SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 942COUNT(c1) SUM(c1) 9431 5 944REPLACE t3 VALUES (5); 945SELECT COUNT(c1),SUM(c1) FROM t3; 946COUNT(c1) SUM(c1) 9471 5 948SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 949COUNT(c1) SUM(c1) 9501 5 951DROP TABLE t1,t2,t3; 952CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 953CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 954INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 955CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 956INSERT INTO t3 (c1) VALUES(5); 957SELECT COUNT(c1),SUM(c1) FROM t3; 958COUNT(c1) SUM(c1) 9591 5 960SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 961COUNT(c1) SUM(c1) 9621 5 963REPLACE t3 VALUES (5); 964SELECT COUNT(c1),SUM(c1) FROM t3; 965COUNT(c1) SUM(c1) 9661 5 967SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 968COUNT(c1) SUM(c1) 9691 5 970DROP TABLE t1,t2,t3; 971CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 972CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 973INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 974CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 975INSERT INTO t3 (c1) VALUES(5); 976SELECT COUNT(c1),SUM(c1) FROM t3; 977COUNT(c1) SUM(c1) 9781 5 979SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 980COUNT(c1) SUM(c1) 9811 5 982REPLACE t3 VALUES (5); 983SELECT COUNT(c1),SUM(c1) FROM t3; 984COUNT(c1) SUM(c1) 9851 5 986SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 987COUNT(c1) SUM(c1) 9881 5 989DROP TABLE t1,t2,t3; 990CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 991CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 992INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 993CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 994INSERT INTO t3 (c1) VALUES(5); 995SELECT COUNT(c1),SUM(c1) FROM t3; 996COUNT(c1) SUM(c1) 9971 5 998SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 999COUNT(c1) SUM(c1) 10001 5 1001REPLACE t3 VALUES (5); 1002SELECT COUNT(c1),SUM(c1) FROM t3; 1003COUNT(c1) SUM(c1) 10041 5 1005SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 1006COUNT(c1) SUM(c1) 10071 5 1008DROP TABLE t1,t2,t3; 1009CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 1010CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 1011INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1012CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 1013INSERT INTO t3 (c1) VALUES(5); 1014SELECT COUNT(c1),SUM(c1) FROM t3; 1015COUNT(c1) SUM(c1) 10161 5 1017SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 1018COUNT(c1) SUM(c1) 10191 5 1020REPLACE t3 VALUES (5); 1021SELECT COUNT(c1),SUM(c1) FROM t3; 1022COUNT(c1) SUM(c1) 10231 5 1024SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 = 5; 1025COUNT(c1) SUM(c1) 10261 5 1027DROP TABLE t1,t2,t3; 1028CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 1029CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 1030INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1031CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 1032INSERT INTO t3 (c1) VALUES(5); 1033SELECT COUNT(c1),SUM(c1) FROM t1; 1034COUNT(c1) SUM(c1) 10350 NULL 1036SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 1037COUNT(c1) SUM(c1) 10380 NULL 1039REPLACE t1 VALUES (5); 1040SELECT COUNT(c1),SUM(c1) FROM t1; 1041COUNT(c1) SUM(c1) 10421 5 1043SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 1044COUNT(c1) SUM(c1) 10451 5 1046DROP TABLE t1,t2,t3; 1047CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 1048CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 1049INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1050CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 1051INSERT INTO t3 (c1) VALUES(5); 1052SELECT COUNT(c1),SUM(c1) FROM t1; 1053COUNT(c1) SUM(c1) 10540 NULL 1055SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 1056COUNT(c1) SUM(c1) 10570 NULL 1058REPLACE t1 VALUES (5); 1059SELECT COUNT(c1),SUM(c1) FROM t1; 1060COUNT(c1) SUM(c1) 10611 5 1062SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 1063COUNT(c1) SUM(c1) 10641 5 1065DROP TABLE t1,t2,t3; 1066CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1067CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1068INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1069CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1070INSERT INTO t3 (c1) VALUES(5); 1071SELECT COUNT(c1),SUM(c1) FROM t1; 1072COUNT(c1) SUM(c1) 10730 NULL 1074SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 1075COUNT(c1) SUM(c1) 10760 NULL 1077REPLACE t1 VALUES (5); 1078SELECT COUNT(c1),SUM(c1) FROM t1; 1079COUNT(c1) SUM(c1) 10801 5 1081SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 1082COUNT(c1) SUM(c1) 10831 5 1084DROP TABLE t1,t2,t3; 1085CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 1086CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 1087INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1088CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 1089INSERT INTO t3 (c1) VALUES(5); 1090SELECT COUNT(c1),SUM(c1) FROM t1; 1091COUNT(c1) SUM(c1) 10920 NULL 1093SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 1094COUNT(c1) SUM(c1) 10950 NULL 1096REPLACE t1 VALUES (5); 1097SELECT COUNT(c1),SUM(c1) FROM t1; 1098COUNT(c1) SUM(c1) 10991 5 1100SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 1101COUNT(c1) SUM(c1) 11021 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 t1; 1110COUNT(c1) SUM(c1) 11110 NULL 1112SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 1113COUNT(c1) SUM(c1) 11140 NULL 1115REPLACE t1 VALUES (5); 1116SELECT COUNT(c1),SUM(c1) FROM t1; 1117COUNT(c1) SUM(c1) 11181 5 1119SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 1120COUNT(c1) SUM(c1) 11211 5 1122DROP TABLE t1,t2,t3; 1123CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 1124CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 1125INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1126CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 1127INSERT INTO t3 (c1) VALUES(5); 1128SELECT COUNT(c1),SUM(c1) FROM t1; 1129COUNT(c1) SUM(c1) 11300 NULL 1131SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 1132COUNT(c1) SUM(c1) 11330 NULL 1134REPLACE t1 VALUES (5); 1135SELECT COUNT(c1),SUM(c1) FROM t1; 1136COUNT(c1) SUM(c1) 11371 5 1138SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 >= 5; 1139COUNT(c1) SUM(c1) 11401 5 1141DROP TABLE t1,t2,t3; 1142CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 1143CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 1144INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1145CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 1146INSERT INTO t3 (c1) VALUES(5); 1147SELECT COUNT(c1),SUM(c1) FROM t2; 1148COUNT(c1) SUM(c1) 114910 45 1150SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 1151COUNT(c1) SUM(c1) 11525 35 1153REPLACE t2 VALUES (5); 1154SELECT COUNT(c1),SUM(c1) FROM t2; 1155COUNT(c1) SUM(c1) 115610 45 1157SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 1158COUNT(c1) SUM(c1) 11595 35 1160DROP TABLE t1,t2,t3; 1161CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 1162CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 1163INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1164CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 1165INSERT INTO t3 (c1) VALUES(5); 1166SELECT COUNT(c1),SUM(c1) FROM t2; 1167COUNT(c1) SUM(c1) 116810 45 1169SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 1170COUNT(c1) SUM(c1) 11715 35 1172REPLACE t2 VALUES (5); 1173SELECT COUNT(c1),SUM(c1) FROM t2; 1174COUNT(c1) SUM(c1) 117510 45 1176SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 1177COUNT(c1) SUM(c1) 11785 35 1179DROP TABLE t1,t2,t3; 1180CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1181CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1182INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1183CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1184INSERT INTO t3 (c1) VALUES(5); 1185SELECT COUNT(c1),SUM(c1) FROM t2; 1186COUNT(c1) SUM(c1) 118710 45 1188SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 1189COUNT(c1) SUM(c1) 11905 35 1191REPLACE t2 VALUES (5); 1192SELECT COUNT(c1),SUM(c1) FROM t2; 1193COUNT(c1) SUM(c1) 119410 45 1195SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 1196COUNT(c1) SUM(c1) 11975 35 1198DROP TABLE t1,t2,t3; 1199CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 1200CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 1201INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1202CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 1203INSERT INTO t3 (c1) VALUES(5); 1204SELECT COUNT(c1),SUM(c1) FROM t2; 1205COUNT(c1) SUM(c1) 120610 45 1207SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 1208COUNT(c1) SUM(c1) 12095 35 1210REPLACE t2 VALUES (5); 1211SELECT COUNT(c1),SUM(c1) FROM t2; 1212COUNT(c1) SUM(c1) 121310 45 1214SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 1215COUNT(c1) SUM(c1) 12165 35 1217DROP TABLE t1,t2,t3; 1218CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 1219CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 1220INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1221CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 1222INSERT INTO t3 (c1) VALUES(5); 1223SELECT COUNT(c1),SUM(c1) FROM t2; 1224COUNT(c1) SUM(c1) 122510 45 1226SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 1227COUNT(c1) SUM(c1) 12285 35 1229REPLACE t2 VALUES (5); 1230SELECT COUNT(c1),SUM(c1) FROM t2; 1231COUNT(c1) SUM(c1) 123210 45 1233SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 1234COUNT(c1) SUM(c1) 12355 35 1236DROP TABLE t1,t2,t3; 1237CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 1238CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 1239INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1240CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 1241INSERT INTO t3 (c1) VALUES(5); 1242SELECT COUNT(c1),SUM(c1) FROM t2; 1243COUNT(c1) SUM(c1) 124410 45 1245SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 1246COUNT(c1) SUM(c1) 12475 35 1248REPLACE t2 VALUES (5); 1249SELECT COUNT(c1),SUM(c1) FROM t2; 1250COUNT(c1) SUM(c1) 125110 45 1252SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 >= 5; 1253COUNT(c1) SUM(c1) 12545 35 1255DROP TABLE t1,t2,t3; 1256CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 1257CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 1258INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1259CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 1260INSERT INTO t3 (c1) VALUES(5); 1261SELECT COUNT(c1),SUM(c1) FROM t3; 1262COUNT(c1) SUM(c1) 12631 5 1264SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 1265COUNT(c1) SUM(c1) 12661 5 1267REPLACE t3 VALUES (5); 1268SELECT COUNT(c1),SUM(c1) FROM t3; 1269COUNT(c1) SUM(c1) 12701 5 1271SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 1272COUNT(c1) SUM(c1) 12731 5 1274DROP TABLE t1,t2,t3; 1275CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 1276CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 1277INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1278CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 1279INSERT INTO t3 (c1) VALUES(5); 1280SELECT COUNT(c1),SUM(c1) FROM t3; 1281COUNT(c1) SUM(c1) 12821 5 1283SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 1284COUNT(c1) SUM(c1) 12851 5 1286REPLACE t3 VALUES (5); 1287SELECT COUNT(c1),SUM(c1) FROM t3; 1288COUNT(c1) SUM(c1) 12891 5 1290SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 1291COUNT(c1) SUM(c1) 12921 5 1293DROP TABLE t1,t2,t3; 1294CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1295CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1296INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1297CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1298INSERT INTO t3 (c1) VALUES(5); 1299SELECT COUNT(c1),SUM(c1) FROM t3; 1300COUNT(c1) SUM(c1) 13011 5 1302SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 1303COUNT(c1) SUM(c1) 13041 5 1305REPLACE t3 VALUES (5); 1306SELECT COUNT(c1),SUM(c1) FROM t3; 1307COUNT(c1) SUM(c1) 13081 5 1309SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 1310COUNT(c1) SUM(c1) 13111 5 1312DROP TABLE t1,t2,t3; 1313CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 1314CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 1315INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1316CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 1317INSERT INTO t3 (c1) VALUES(5); 1318SELECT COUNT(c1),SUM(c1) FROM t3; 1319COUNT(c1) SUM(c1) 13201 5 1321SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 1322COUNT(c1) SUM(c1) 13231 5 1324REPLACE t3 VALUES (5); 1325SELECT COUNT(c1),SUM(c1) FROM t3; 1326COUNT(c1) SUM(c1) 13271 5 1328SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 1329COUNT(c1) SUM(c1) 13301 5 1331DROP TABLE t1,t2,t3; 1332CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 1333CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 1334INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1335CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 1336INSERT INTO t3 (c1) VALUES(5); 1337SELECT COUNT(c1),SUM(c1) FROM t3; 1338COUNT(c1) SUM(c1) 13391 5 1340SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 1341COUNT(c1) SUM(c1) 13421 5 1343REPLACE t3 VALUES (5); 1344SELECT COUNT(c1),SUM(c1) FROM t3; 1345COUNT(c1) SUM(c1) 13461 5 1347SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 1348COUNT(c1) SUM(c1) 13491 5 1350DROP TABLE t1,t2,t3; 1351CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 1352CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 1353INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1354CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 1355INSERT INTO t3 (c1) VALUES(5); 1356SELECT COUNT(c1),SUM(c1) FROM t3; 1357COUNT(c1) SUM(c1) 13581 5 1359SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 1360COUNT(c1) SUM(c1) 13611 5 1362REPLACE t3 VALUES (5); 1363SELECT COUNT(c1),SUM(c1) FROM t3; 1364COUNT(c1) SUM(c1) 13651 5 1366SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 >= 5; 1367COUNT(c1) SUM(c1) 13681 5 1369DROP TABLE t1,t2,t3; 1370CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 1371CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 1372INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1373CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 1374INSERT INTO t3 (c1) VALUES(5); 1375SELECT COUNT(c1),SUM(c1) FROM t1; 1376COUNT(c1) SUM(c1) 13770 NULL 1378SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 1379COUNT(c1) SUM(c1) 13800 NULL 1381REPLACE t1 VALUES (5); 1382SELECT COUNT(c1),SUM(c1) FROM t1; 1383COUNT(c1) SUM(c1) 13841 5 1385SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 1386COUNT(c1) SUM(c1) 13870 NULL 1388DROP TABLE t1,t2,t3; 1389CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 1390CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 1391INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1392CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 1393INSERT INTO t3 (c1) VALUES(5); 1394SELECT COUNT(c1),SUM(c1) FROM t1; 1395COUNT(c1) SUM(c1) 13960 NULL 1397SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 1398COUNT(c1) SUM(c1) 13990 NULL 1400REPLACE t1 VALUES (5); 1401SELECT COUNT(c1),SUM(c1) FROM t1; 1402COUNT(c1) SUM(c1) 14031 5 1404SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 1405COUNT(c1) SUM(c1) 14060 NULL 1407DROP TABLE t1,t2,t3; 1408CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1409CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1410INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1411CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1412INSERT INTO t3 (c1) VALUES(5); 1413SELECT COUNT(c1),SUM(c1) FROM t1; 1414COUNT(c1) SUM(c1) 14150 NULL 1416SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 1417COUNT(c1) SUM(c1) 14180 NULL 1419REPLACE t1 VALUES (5); 1420SELECT COUNT(c1),SUM(c1) FROM t1; 1421COUNT(c1) SUM(c1) 14221 5 1423SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 1424COUNT(c1) SUM(c1) 14250 NULL 1426DROP TABLE t1,t2,t3; 1427CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 1428CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 1429INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1430CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 1431INSERT INTO t3 (c1) VALUES(5); 1432SELECT COUNT(c1),SUM(c1) FROM t1; 1433COUNT(c1) SUM(c1) 14340 NULL 1435SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 1436COUNT(c1) SUM(c1) 14370 NULL 1438REPLACE t1 VALUES (5); 1439SELECT COUNT(c1),SUM(c1) FROM t1; 1440COUNT(c1) SUM(c1) 14411 5 1442SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 1443COUNT(c1) SUM(c1) 14440 NULL 1445DROP TABLE t1,t2,t3; 1446CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 1447CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 1448INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1449CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 1450INSERT INTO t3 (c1) VALUES(5); 1451SELECT COUNT(c1),SUM(c1) FROM t1; 1452COUNT(c1) SUM(c1) 14530 NULL 1454SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 1455COUNT(c1) SUM(c1) 14560 NULL 1457REPLACE t1 VALUES (5); 1458SELECT COUNT(c1),SUM(c1) FROM t1; 1459COUNT(c1) SUM(c1) 14601 5 1461SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 1462COUNT(c1) SUM(c1) 14630 NULL 1464DROP TABLE t1,t2,t3; 1465CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 1466CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 1467INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1468CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 1469INSERT INTO t3 (c1) VALUES(5); 1470SELECT COUNT(c1),SUM(c1) FROM t1; 1471COUNT(c1) SUM(c1) 14720 NULL 1473SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 1474COUNT(c1) SUM(c1) 14750 NULL 1476REPLACE t1 VALUES (5); 1477SELECT COUNT(c1),SUM(c1) FROM t1; 1478COUNT(c1) SUM(c1) 14791 5 1480SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 != 5; 1481COUNT(c1) SUM(c1) 14820 NULL 1483DROP TABLE t1,t2,t3; 1484CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 1485CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 1486INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1487CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 1488INSERT INTO t3 (c1) VALUES(5); 1489SELECT COUNT(c1),SUM(c1) FROM t2; 1490COUNT(c1) SUM(c1) 149110 45 1492SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 1493COUNT(c1) SUM(c1) 14949 40 1495REPLACE t2 VALUES (5); 1496SELECT COUNT(c1),SUM(c1) FROM t2; 1497COUNT(c1) SUM(c1) 149810 45 1499SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 1500COUNT(c1) SUM(c1) 15019 40 1502DROP TABLE t1,t2,t3; 1503CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 1504CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 1505INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1506CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 1507INSERT INTO t3 (c1) VALUES(5); 1508SELECT COUNT(c1),SUM(c1) FROM t2; 1509COUNT(c1) SUM(c1) 151010 45 1511SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 1512COUNT(c1) SUM(c1) 15139 40 1514REPLACE t2 VALUES (5); 1515SELECT COUNT(c1),SUM(c1) FROM t2; 1516COUNT(c1) SUM(c1) 151710 45 1518SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 1519COUNT(c1) SUM(c1) 15209 40 1521DROP TABLE t1,t2,t3; 1522CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1523CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1524INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1525CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1526INSERT INTO t3 (c1) VALUES(5); 1527SELECT COUNT(c1),SUM(c1) FROM t2; 1528COUNT(c1) SUM(c1) 152910 45 1530SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 1531COUNT(c1) SUM(c1) 15329 40 1533REPLACE t2 VALUES (5); 1534SELECT COUNT(c1),SUM(c1) FROM t2; 1535COUNT(c1) SUM(c1) 153610 45 1537SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 1538COUNT(c1) SUM(c1) 15399 40 1540DROP TABLE t1,t2,t3; 1541CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 1542CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 1543INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1544CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 1545INSERT INTO t3 (c1) VALUES(5); 1546SELECT COUNT(c1),SUM(c1) FROM t2; 1547COUNT(c1) SUM(c1) 154810 45 1549SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 1550COUNT(c1) SUM(c1) 15519 40 1552REPLACE t2 VALUES (5); 1553SELECT COUNT(c1),SUM(c1) FROM t2; 1554COUNT(c1) SUM(c1) 155510 45 1556SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 1557COUNT(c1) SUM(c1) 15589 40 1559DROP TABLE t1,t2,t3; 1560CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 1561CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 1562INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1563CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 1564INSERT INTO t3 (c1) VALUES(5); 1565SELECT COUNT(c1),SUM(c1) FROM t2; 1566COUNT(c1) SUM(c1) 156710 45 1568SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 1569COUNT(c1) SUM(c1) 15709 40 1571REPLACE t2 VALUES (5); 1572SELECT COUNT(c1),SUM(c1) FROM t2; 1573COUNT(c1) SUM(c1) 157410 45 1575SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 1576COUNT(c1) SUM(c1) 15779 40 1578DROP TABLE t1,t2,t3; 1579CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 1580CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 1581INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1582CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 1583INSERT INTO t3 (c1) VALUES(5); 1584SELECT COUNT(c1),SUM(c1) FROM t2; 1585COUNT(c1) SUM(c1) 158610 45 1587SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 1588COUNT(c1) SUM(c1) 15899 40 1590REPLACE t2 VALUES (5); 1591SELECT COUNT(c1),SUM(c1) FROM t2; 1592COUNT(c1) SUM(c1) 159310 45 1594SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 != 5; 1595COUNT(c1) SUM(c1) 15969 40 1597DROP TABLE t1,t2,t3; 1598CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 1599CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 1600INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1601CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 1602INSERT INTO t3 (c1) VALUES(5); 1603SELECT COUNT(c1),SUM(c1) FROM t3; 1604COUNT(c1) SUM(c1) 16051 5 1606SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 1607COUNT(c1) SUM(c1) 16080 NULL 1609REPLACE t3 VALUES (5); 1610SELECT COUNT(c1),SUM(c1) FROM t3; 1611COUNT(c1) SUM(c1) 16121 5 1613SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 1614COUNT(c1) SUM(c1) 16150 NULL 1616DROP TABLE t1,t2,t3; 1617CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 1618CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 1619INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1620CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 1621INSERT INTO t3 (c1) VALUES(5); 1622SELECT COUNT(c1),SUM(c1) FROM t3; 1623COUNT(c1) SUM(c1) 16241 5 1625SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 1626COUNT(c1) SUM(c1) 16270 NULL 1628REPLACE t3 VALUES (5); 1629SELECT COUNT(c1),SUM(c1) FROM t3; 1630COUNT(c1) SUM(c1) 16311 5 1632SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 1633COUNT(c1) SUM(c1) 16340 NULL 1635DROP TABLE t1,t2,t3; 1636CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1637CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1638INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1639CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1640INSERT INTO t3 (c1) VALUES(5); 1641SELECT COUNT(c1),SUM(c1) FROM t3; 1642COUNT(c1) SUM(c1) 16431 5 1644SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 1645COUNT(c1) SUM(c1) 16460 NULL 1647REPLACE t3 VALUES (5); 1648SELECT COUNT(c1),SUM(c1) FROM t3; 1649COUNT(c1) SUM(c1) 16501 5 1651SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 1652COUNT(c1) SUM(c1) 16530 NULL 1654DROP TABLE t1,t2,t3; 1655CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 1656CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 1657INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1658CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 1659INSERT INTO t3 (c1) VALUES(5); 1660SELECT COUNT(c1),SUM(c1) FROM t3; 1661COUNT(c1) SUM(c1) 16621 5 1663SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 1664COUNT(c1) SUM(c1) 16650 NULL 1666REPLACE t3 VALUES (5); 1667SELECT COUNT(c1),SUM(c1) FROM t3; 1668COUNT(c1) SUM(c1) 16691 5 1670SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 1671COUNT(c1) SUM(c1) 16720 NULL 1673DROP TABLE t1,t2,t3; 1674CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 1675CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 1676INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1677CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 1678INSERT INTO t3 (c1) VALUES(5); 1679SELECT COUNT(c1),SUM(c1) FROM t3; 1680COUNT(c1) SUM(c1) 16811 5 1682SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 1683COUNT(c1) SUM(c1) 16840 NULL 1685REPLACE t3 VALUES (5); 1686SELECT COUNT(c1),SUM(c1) FROM t3; 1687COUNT(c1) SUM(c1) 16881 5 1689SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 1690COUNT(c1) SUM(c1) 16910 NULL 1692DROP TABLE t1,t2,t3; 1693CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 1694CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 1695INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1696CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 1697INSERT INTO t3 (c1) VALUES(5); 1698SELECT COUNT(c1),SUM(c1) FROM t3; 1699COUNT(c1) SUM(c1) 17001 5 1701SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 1702COUNT(c1) SUM(c1) 17030 NULL 1704REPLACE t3 VALUES (5); 1705SELECT COUNT(c1),SUM(c1) FROM t3; 1706COUNT(c1) SUM(c1) 17071 5 1708SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 != 5; 1709COUNT(c1) SUM(c1) 17100 NULL 1711DROP TABLE t1,t2,t3; 1712CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 1713CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 1714INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1715CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 1716INSERT INTO t3 (c1) VALUES(5); 1717SELECT COUNT(c1),SUM(c1) FROM t1; 1718COUNT(c1) SUM(c1) 17190 NULL 1720SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1721COUNT(c1) SUM(c1) 17220 NULL 1723REPLACE t1 VALUES (5); 1724SELECT COUNT(c1),SUM(c1) FROM t1; 1725COUNT(c1) SUM(c1) 17261 5 1727SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1728COUNT(c1) SUM(c1) 17290 NULL 1730DROP TABLE t1,t2,t3; 1731CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 1732CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 1733INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1734CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 1735INSERT INTO t3 (c1) VALUES(5); 1736SELECT COUNT(c1),SUM(c1) FROM t1; 1737COUNT(c1) SUM(c1) 17380 NULL 1739SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1740COUNT(c1) SUM(c1) 17410 NULL 1742REPLACE t1 VALUES (5); 1743SELECT COUNT(c1),SUM(c1) FROM t1; 1744COUNT(c1) SUM(c1) 17451 5 1746SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1747COUNT(c1) SUM(c1) 17480 NULL 1749DROP TABLE t1,t2,t3; 1750CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1751CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1752INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1753CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1754INSERT INTO t3 (c1) VALUES(5); 1755SELECT COUNT(c1),SUM(c1) FROM t1; 1756COUNT(c1) SUM(c1) 17570 NULL 1758SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1759COUNT(c1) SUM(c1) 17600 NULL 1761REPLACE t1 VALUES (5); 1762SELECT COUNT(c1),SUM(c1) FROM t1; 1763COUNT(c1) SUM(c1) 17641 5 1765SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1766COUNT(c1) SUM(c1) 17670 NULL 1768DROP TABLE t1,t2,t3; 1769CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 1770CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 1771INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1772CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 1773INSERT INTO t3 (c1) VALUES(5); 1774SELECT COUNT(c1),SUM(c1) FROM t1; 1775COUNT(c1) SUM(c1) 17760 NULL 1777SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1778COUNT(c1) SUM(c1) 17790 NULL 1780REPLACE t1 VALUES (5); 1781SELECT COUNT(c1),SUM(c1) FROM t1; 1782COUNT(c1) SUM(c1) 17831 5 1784SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1785COUNT(c1) SUM(c1) 17860 NULL 1787DROP TABLE t1,t2,t3; 1788CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 1789CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 1790INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1791CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 1792INSERT INTO t3 (c1) VALUES(5); 1793SELECT COUNT(c1),SUM(c1) FROM t1; 1794COUNT(c1) SUM(c1) 17950 NULL 1796SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1797COUNT(c1) SUM(c1) 17980 NULL 1799REPLACE t1 VALUES (5); 1800SELECT COUNT(c1),SUM(c1) FROM t1; 1801COUNT(c1) SUM(c1) 18021 5 1803SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1804COUNT(c1) SUM(c1) 18050 NULL 1806DROP TABLE t1,t2,t3; 1807CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 1808CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 1809INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1810CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 1811INSERT INTO t3 (c1) VALUES(5); 1812SELECT COUNT(c1),SUM(c1) FROM t1; 1813COUNT(c1) SUM(c1) 18140 NULL 1815SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1816COUNT(c1) SUM(c1) 18170 NULL 1818REPLACE t1 VALUES (5); 1819SELECT COUNT(c1),SUM(c1) FROM t1; 1820COUNT(c1) SUM(c1) 18211 5 1822SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <> 5; 1823COUNT(c1) SUM(c1) 18240 NULL 1825DROP TABLE t1,t2,t3; 1826CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 1827CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 1828INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1829CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 1830INSERT INTO t3 (c1) VALUES(5); 1831SELECT COUNT(c1),SUM(c1) FROM t2; 1832COUNT(c1) SUM(c1) 183310 45 1834SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1835COUNT(c1) SUM(c1) 18369 40 1837REPLACE t2 VALUES (5); 1838SELECT COUNT(c1),SUM(c1) FROM t2; 1839COUNT(c1) SUM(c1) 184010 45 1841SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1842COUNT(c1) SUM(c1) 18439 40 1844DROP TABLE t1,t2,t3; 1845CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 1846CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 1847INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1848CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 1849INSERT INTO t3 (c1) VALUES(5); 1850SELECT COUNT(c1),SUM(c1) FROM t2; 1851COUNT(c1) SUM(c1) 185210 45 1853SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1854COUNT(c1) SUM(c1) 18559 40 1856REPLACE t2 VALUES (5); 1857SELECT COUNT(c1),SUM(c1) FROM t2; 1858COUNT(c1) SUM(c1) 185910 45 1860SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1861COUNT(c1) SUM(c1) 18629 40 1863DROP TABLE t1,t2,t3; 1864CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1865CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1866INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1867CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1868INSERT INTO t3 (c1) VALUES(5); 1869SELECT COUNT(c1),SUM(c1) FROM t2; 1870COUNT(c1) SUM(c1) 187110 45 1872SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1873COUNT(c1) SUM(c1) 18749 40 1875REPLACE t2 VALUES (5); 1876SELECT COUNT(c1),SUM(c1) FROM t2; 1877COUNT(c1) SUM(c1) 187810 45 1879SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1880COUNT(c1) SUM(c1) 18819 40 1882DROP TABLE t1,t2,t3; 1883CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 1884CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 1885INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1886CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 1887INSERT INTO t3 (c1) VALUES(5); 1888SELECT COUNT(c1),SUM(c1) FROM t2; 1889COUNT(c1) SUM(c1) 189010 45 1891SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1892COUNT(c1) SUM(c1) 18939 40 1894REPLACE t2 VALUES (5); 1895SELECT COUNT(c1),SUM(c1) FROM t2; 1896COUNT(c1) SUM(c1) 189710 45 1898SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1899COUNT(c1) SUM(c1) 19009 40 1901DROP TABLE t1,t2,t3; 1902CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 1903CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 1904INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1905CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 1906INSERT INTO t3 (c1) VALUES(5); 1907SELECT COUNT(c1),SUM(c1) FROM t2; 1908COUNT(c1) SUM(c1) 190910 45 1910SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1911COUNT(c1) SUM(c1) 19129 40 1913REPLACE t2 VALUES (5); 1914SELECT COUNT(c1),SUM(c1) FROM t2; 1915COUNT(c1) SUM(c1) 191610 45 1917SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1918COUNT(c1) SUM(c1) 19199 40 1920DROP TABLE t1,t2,t3; 1921CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 1922CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 1923INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1924CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 1925INSERT INTO t3 (c1) VALUES(5); 1926SELECT COUNT(c1),SUM(c1) FROM t2; 1927COUNT(c1) SUM(c1) 192810 45 1929SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1930COUNT(c1) SUM(c1) 19319 40 1932REPLACE t2 VALUES (5); 1933SELECT COUNT(c1),SUM(c1) FROM t2; 1934COUNT(c1) SUM(c1) 193510 45 1936SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <> 5; 1937COUNT(c1) SUM(c1) 19389 40 1939DROP TABLE t1,t2,t3; 1940CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 1941CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 1942INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1943CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 1944INSERT INTO t3 (c1) VALUES(5); 1945SELECT COUNT(c1),SUM(c1) FROM t3; 1946COUNT(c1) SUM(c1) 19471 5 1948SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 1949COUNT(c1) SUM(c1) 19500 NULL 1951REPLACE t3 VALUES (5); 1952SELECT COUNT(c1),SUM(c1) FROM t3; 1953COUNT(c1) SUM(c1) 19541 5 1955SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 1956COUNT(c1) SUM(c1) 19570 NULL 1958DROP TABLE t1,t2,t3; 1959CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 1960CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 1961INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1962CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 1963INSERT INTO t3 (c1) VALUES(5); 1964SELECT COUNT(c1),SUM(c1) FROM t3; 1965COUNT(c1) SUM(c1) 19661 5 1967SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 1968COUNT(c1) SUM(c1) 19690 NULL 1970REPLACE t3 VALUES (5); 1971SELECT COUNT(c1),SUM(c1) FROM t3; 1972COUNT(c1) SUM(c1) 19731 5 1974SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 1975COUNT(c1) SUM(c1) 19760 NULL 1977DROP TABLE t1,t2,t3; 1978CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1979CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1980INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 1981CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 1982INSERT INTO t3 (c1) VALUES(5); 1983SELECT COUNT(c1),SUM(c1) FROM t3; 1984COUNT(c1) SUM(c1) 19851 5 1986SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 1987COUNT(c1) SUM(c1) 19880 NULL 1989REPLACE t3 VALUES (5); 1990SELECT COUNT(c1),SUM(c1) FROM t3; 1991COUNT(c1) SUM(c1) 19921 5 1993SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 1994COUNT(c1) SUM(c1) 19950 NULL 1996DROP TABLE t1,t2,t3; 1997CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 1998CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 1999INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2000CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 2001INSERT INTO t3 (c1) VALUES(5); 2002SELECT COUNT(c1),SUM(c1) FROM t3; 2003COUNT(c1) SUM(c1) 20041 5 2005SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 2006COUNT(c1) SUM(c1) 20070 NULL 2008REPLACE t3 VALUES (5); 2009SELECT COUNT(c1),SUM(c1) FROM t3; 2010COUNT(c1) SUM(c1) 20111 5 2012SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 2013COUNT(c1) SUM(c1) 20140 NULL 2015DROP TABLE t1,t2,t3; 2016CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 2017CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 2018INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2019CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 2020INSERT INTO t3 (c1) VALUES(5); 2021SELECT COUNT(c1),SUM(c1) FROM t3; 2022COUNT(c1) SUM(c1) 20231 5 2024SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 2025COUNT(c1) SUM(c1) 20260 NULL 2027REPLACE t3 VALUES (5); 2028SELECT COUNT(c1),SUM(c1) FROM t3; 2029COUNT(c1) SUM(c1) 20301 5 2031SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 2032COUNT(c1) SUM(c1) 20330 NULL 2034DROP TABLE t1,t2,t3; 2035CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 2036CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 2037INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2038CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 2039INSERT INTO t3 (c1) VALUES(5); 2040SELECT COUNT(c1),SUM(c1) FROM t3; 2041COUNT(c1) SUM(c1) 20421 5 2043SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 2044COUNT(c1) SUM(c1) 20450 NULL 2046REPLACE t3 VALUES (5); 2047SELECT COUNT(c1),SUM(c1) FROM t3; 2048COUNT(c1) SUM(c1) 20491 5 2050SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <> 5; 2051COUNT(c1) SUM(c1) 20520 NULL 2053DROP TABLE t1,t2,t3; 2054CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 2055CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 2056INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2057CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 2058INSERT INTO t3 (c1) VALUES(5); 2059SELECT COUNT(c1),SUM(c1) FROM t1; 2060COUNT(c1) SUM(c1) 20610 NULL 2062SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 2063COUNT(c1) SUM(c1) 20640 NULL 2065REPLACE t1 VALUES (5); 2066SELECT COUNT(c1),SUM(c1) FROM t1; 2067COUNT(c1) SUM(c1) 20681 5 2069SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 2070COUNT(c1) SUM(c1) 20711 5 2072DROP TABLE t1,t2,t3; 2073CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 2074CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 2075INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2076CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 2077INSERT INTO t3 (c1) VALUES(5); 2078SELECT COUNT(c1),SUM(c1) FROM t1; 2079COUNT(c1) SUM(c1) 20800 NULL 2081SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 2082COUNT(c1) SUM(c1) 20830 NULL 2084REPLACE t1 VALUES (5); 2085SELECT COUNT(c1),SUM(c1) FROM t1; 2086COUNT(c1) SUM(c1) 20871 5 2088SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 2089COUNT(c1) SUM(c1) 20901 5 2091DROP TABLE t1,t2,t3; 2092CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 2093CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 2094INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2095CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 2096INSERT INTO t3 (c1) VALUES(5); 2097SELECT COUNT(c1),SUM(c1) FROM t1; 2098COUNT(c1) SUM(c1) 20990 NULL 2100SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 2101COUNT(c1) SUM(c1) 21020 NULL 2103REPLACE t1 VALUES (5); 2104SELECT COUNT(c1),SUM(c1) FROM t1; 2105COUNT(c1) SUM(c1) 21061 5 2107SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 2108COUNT(c1) SUM(c1) 21091 5 2110DROP TABLE t1,t2,t3; 2111CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 2112CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 2113INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2114CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 2115INSERT INTO t3 (c1) VALUES(5); 2116SELECT COUNT(c1),SUM(c1) FROM t1; 2117COUNT(c1) SUM(c1) 21180 NULL 2119SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 2120COUNT(c1) SUM(c1) 21210 NULL 2122REPLACE t1 VALUES (5); 2123SELECT COUNT(c1),SUM(c1) FROM t1; 2124COUNT(c1) SUM(c1) 21251 5 2126SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 2127COUNT(c1) SUM(c1) 21281 5 2129DROP TABLE t1,t2,t3; 2130CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 2131CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 2132INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2133CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 2134INSERT INTO t3 (c1) VALUES(5); 2135SELECT COUNT(c1),SUM(c1) FROM t1; 2136COUNT(c1) SUM(c1) 21370 NULL 2138SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 2139COUNT(c1) SUM(c1) 21400 NULL 2141REPLACE t1 VALUES (5); 2142SELECT COUNT(c1),SUM(c1) FROM t1; 2143COUNT(c1) SUM(c1) 21441 5 2145SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 2146COUNT(c1) SUM(c1) 21471 5 2148DROP TABLE t1,t2,t3; 2149CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 2150CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 2151INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2152CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 2153INSERT INTO t3 (c1) VALUES(5); 2154SELECT COUNT(c1),SUM(c1) FROM t1; 2155COUNT(c1) SUM(c1) 21560 NULL 2157SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 2158COUNT(c1) SUM(c1) 21590 NULL 2160REPLACE t1 VALUES (5); 2161SELECT COUNT(c1),SUM(c1) FROM t1; 2162COUNT(c1) SUM(c1) 21631 5 2164SELECT COUNT(c1),SUM(c1) FROM t1 WHERE c1 <=> 5; 2165COUNT(c1) SUM(c1) 21661 5 2167DROP TABLE t1,t2,t3; 2168CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 2169CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 2170INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2171CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 2172INSERT INTO t3 (c1) VALUES(5); 2173SELECT COUNT(c1),SUM(c1) FROM t2; 2174COUNT(c1) SUM(c1) 217510 45 2176SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 2177COUNT(c1) SUM(c1) 21781 5 2179REPLACE t2 VALUES (5); 2180SELECT COUNT(c1),SUM(c1) FROM t2; 2181COUNT(c1) SUM(c1) 218210 45 2183SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 2184COUNT(c1) SUM(c1) 21851 5 2186DROP TABLE t1,t2,t3; 2187CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 2188CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 2189INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2190CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 2191INSERT INTO t3 (c1) VALUES(5); 2192SELECT COUNT(c1),SUM(c1) FROM t2; 2193COUNT(c1) SUM(c1) 219410 45 2195SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 2196COUNT(c1) SUM(c1) 21971 5 2198REPLACE t2 VALUES (5); 2199SELECT COUNT(c1),SUM(c1) FROM t2; 2200COUNT(c1) SUM(c1) 220110 45 2202SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 2203COUNT(c1) SUM(c1) 22041 5 2205DROP TABLE t1,t2,t3; 2206CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 2207CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 2208INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2209CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 2210INSERT INTO t3 (c1) VALUES(5); 2211SELECT COUNT(c1),SUM(c1) FROM t2; 2212COUNT(c1) SUM(c1) 221310 45 2214SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 2215COUNT(c1) SUM(c1) 22161 5 2217REPLACE t2 VALUES (5); 2218SELECT COUNT(c1),SUM(c1) FROM t2; 2219COUNT(c1) SUM(c1) 222010 45 2221SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 2222COUNT(c1) SUM(c1) 22231 5 2224DROP TABLE t1,t2,t3; 2225CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 2226CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 2227INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2228CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 2229INSERT INTO t3 (c1) VALUES(5); 2230SELECT COUNT(c1),SUM(c1) FROM t2; 2231COUNT(c1) SUM(c1) 223210 45 2233SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 2234COUNT(c1) SUM(c1) 22351 5 2236REPLACE t2 VALUES (5); 2237SELECT COUNT(c1),SUM(c1) FROM t2; 2238COUNT(c1) SUM(c1) 223910 45 2240SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 2241COUNT(c1) SUM(c1) 22421 5 2243DROP TABLE t1,t2,t3; 2244CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 2245CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 2246INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2247CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 2248INSERT INTO t3 (c1) VALUES(5); 2249SELECT COUNT(c1),SUM(c1) FROM t2; 2250COUNT(c1) SUM(c1) 225110 45 2252SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 2253COUNT(c1) SUM(c1) 22541 5 2255REPLACE t2 VALUES (5); 2256SELECT COUNT(c1),SUM(c1) FROM t2; 2257COUNT(c1) SUM(c1) 225810 45 2259SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 2260COUNT(c1) SUM(c1) 22611 5 2262DROP TABLE t1,t2,t3; 2263CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 2264CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 2265INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2266CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 2267INSERT INTO t3 (c1) VALUES(5); 2268SELECT COUNT(c1),SUM(c1) FROM t2; 2269COUNT(c1) SUM(c1) 227010 45 2271SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 2272COUNT(c1) SUM(c1) 22731 5 2274REPLACE t2 VALUES (5); 2275SELECT COUNT(c1),SUM(c1) FROM t2; 2276COUNT(c1) SUM(c1) 227710 45 2278SELECT COUNT(c1),SUM(c1) FROM t2 WHERE c1 <=> 5; 2279COUNT(c1) SUM(c1) 22801 5 2281DROP TABLE t1,t2,t3; 2282CREATE TABLE t1(c1 TINYINT NOT NULL PRIMARY KEY); 2283CREATE TABLE t2(c1 TINYINT NOT NULL PRIMARY KEY); 2284INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2285CREATE TABLE t3(c1 TINYINT NOT NULL PRIMARY KEY); 2286INSERT INTO t3 (c1) VALUES(5); 2287SELECT COUNT(c1),SUM(c1) FROM t3; 2288COUNT(c1) SUM(c1) 22891 5 2290SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 2291COUNT(c1) SUM(c1) 22921 5 2293REPLACE t3 VALUES (5); 2294SELECT COUNT(c1),SUM(c1) FROM t3; 2295COUNT(c1) SUM(c1) 22961 5 2297SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 2298COUNT(c1) SUM(c1) 22991 5 2300DROP TABLE t1,t2,t3; 2301CREATE TABLE t1(c1 SMALLINT NOT NULL PRIMARY KEY); 2302CREATE TABLE t2(c1 SMALLINT NOT NULL PRIMARY KEY); 2303INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2304CREATE TABLE t3(c1 SMALLINT NOT NULL PRIMARY KEY); 2305INSERT INTO t3 (c1) VALUES(5); 2306SELECT COUNT(c1),SUM(c1) FROM t3; 2307COUNT(c1) SUM(c1) 23081 5 2309SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 2310COUNT(c1) SUM(c1) 23111 5 2312REPLACE t3 VALUES (5); 2313SELECT COUNT(c1),SUM(c1) FROM t3; 2314COUNT(c1) SUM(c1) 23151 5 2316SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 2317COUNT(c1) SUM(c1) 23181 5 2319DROP TABLE t1,t2,t3; 2320CREATE TABLE t1(c1 MEDIUMINT NOT NULL PRIMARY KEY); 2321CREATE TABLE t2(c1 MEDIUMINT NOT NULL PRIMARY KEY); 2322INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2323CREATE TABLE t3(c1 MEDIUMINT NOT NULL PRIMARY KEY); 2324INSERT INTO t3 (c1) VALUES(5); 2325SELECT COUNT(c1),SUM(c1) FROM t3; 2326COUNT(c1) SUM(c1) 23271 5 2328SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 2329COUNT(c1) SUM(c1) 23301 5 2331REPLACE t3 VALUES (5); 2332SELECT COUNT(c1),SUM(c1) FROM t3; 2333COUNT(c1) SUM(c1) 23341 5 2335SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 2336COUNT(c1) SUM(c1) 23371 5 2338DROP TABLE t1,t2,t3; 2339CREATE TABLE t1(c1 INT NOT NULL PRIMARY KEY); 2340CREATE TABLE t2(c1 INT NOT NULL PRIMARY KEY); 2341INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2342CREATE TABLE t3(c1 INT NOT NULL PRIMARY KEY); 2343INSERT INTO t3 (c1) VALUES(5); 2344SELECT COUNT(c1),SUM(c1) FROM t3; 2345COUNT(c1) SUM(c1) 23461 5 2347SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 2348COUNT(c1) SUM(c1) 23491 5 2350REPLACE t3 VALUES (5); 2351SELECT COUNT(c1),SUM(c1) FROM t3; 2352COUNT(c1) SUM(c1) 23531 5 2354SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 2355COUNT(c1) SUM(c1) 23561 5 2357DROP TABLE t1,t2,t3; 2358CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); 2359CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); 2360INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2361CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); 2362INSERT INTO t3 (c1) VALUES(5); 2363SELECT COUNT(c1),SUM(c1) FROM t3; 2364COUNT(c1) SUM(c1) 23651 5 2366SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 2367COUNT(c1) SUM(c1) 23681 5 2369REPLACE t3 VALUES (5); 2370SELECT COUNT(c1),SUM(c1) FROM t3; 2371COUNT(c1) SUM(c1) 23721 5 2373SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 2374COUNT(c1) SUM(c1) 23751 5 2376DROP TABLE t1,t2,t3; 2377CREATE TABLE t1(c1 BIGINT NOT NULL PRIMARY KEY); 2378CREATE TABLE t2(c1 BIGINT NOT NULL PRIMARY KEY); 2379INSERT INTO t2 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 2380CREATE TABLE t3(c1 BIGINT NOT NULL PRIMARY KEY); 2381INSERT INTO t3 (c1) VALUES(5); 2382SELECT COUNT(c1),SUM(c1) FROM t3; 2383COUNT(c1) SUM(c1) 23841 5 2385SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 2386COUNT(c1) SUM(c1) 23871 5 2388REPLACE t3 VALUES (5); 2389SELECT COUNT(c1),SUM(c1) FROM t3; 2390COUNT(c1) SUM(c1) 23911 5 2392SELECT COUNT(c1),SUM(c1) FROM t3 WHERE c1 <=> 5; 2393COUNT(c1) SUM(c1) 23941 5 2395DROP TABLE t1,t2,t3; 2396