doris
doris copied to clipboard
apache
[fix](short circurt) fix return default value issue
Proposed changes
Issue Number: close #34056
-
problem
When using short circurt for point-checking, if a field in the table constructor clause has a default value and a NULL value is written later, the query returns the default value instead of the NULL value -
recurrence
CREATE TABLE IF NOT EXISTS test.test_001 (
id int NOT NULL COMMENT "id",
test_time DATETIMEV2(3) DEFAULT "1970-01-01 00:00:00.111" COMMENT "access time"
) UNIQUE KEY(id) DISTRIBUTED BY HASH(id) BUCKETS 1 PROPERTIES (
"replication_num" = "1",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"store_row_column" = "true"
);
insert into test.test_001 values (1, NULL);
set experimental_enable_nereids_planner = false;
select test_time from test.test_001 where id= 1;
The query result is 1970-01-01 00:00:00.111
3、after restoration
Query returns NULL after repair
Further comments
If this is a relatively large or complex change, kick off the discussion at [email protected] by explaining why you chose the solution you did and what alternatives you considered, etc...
Thank you for your contribution to Apache Doris. Don't know what should be done next? See How to process your PR
Since 2024-03-18, the Document has been moved to doris-website. See Doris Document.
![github-actions[bot] avatar](https://avatars.githubusercontent.com/in/15368?v=4 "Published by a pub.dev verified publisher"){kind=small}
TeamCity be ut coverage result: Function Coverage: 35.52% (8926/25130) Line Coverage: 27.14% (73463/270638) Region Coverage: 26.33% (37950/144126) Branch Coverage: 23.12% (19334/83610) Coverage Report: http://coverage.selectdb-in.cc/coverage/53af774126ff4658e86f0ad44291e357804e5129_53af774126ff4658e86f0ad44291e357804e5129/report/index.html
TPC-H: Total hot run time: 41108 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 53af774126ff4658e86f0ad44291e357804e5129, data reload: false
------ Round 1 ----------------------------------
q1 17693 4345 4219 4219
q2 2023 187 190 187
q3 10539 1257 1174 1174
q4 10207 753 715 715
q5 7522 2772 2746 2746
q6 217 127 128 127
q7 1040 627 606 606
q8 9210 2138 2086 2086
q9 9557 6942 6833 6833
q10 9039 3966 3903 3903
q11 453 240 234 234
q12 538 214 226 214
q13 17262 3141 3204 3141
q14 297 230 231 230
q15 504 462 464 462
q16 477 394 405 394
q17 973 659 712 659
q18 8370 7718 7865 7718
q19 6117 1554 1504 1504
q20 644 336 312 312
q21 5260 4198 3370 3370
q22 342 274 289 274
Total cold run time: 118284 ms
Total hot run time: 41108 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4524 4383 4408 4383
q2 361 277 278 277
q3 3220 2930 3003 2930
q4 1922 1604 1603 1603
q5 5458 5558 5569 5558
q6 208 122 125 122
q7 2341 1983 1997 1983
q8 3309 3451 3389 3389
q9 8870 9009 8971 8971
q10 4047 3718 3860 3718
q11 592 503 499 499
q12 827 620 668 620
q13 16899 3209 3189 3189
q14 302 313 307 307
q15 533 502 489 489
q16 498 452 449 449
q17 1807 1481 1482 1481
q18 7996 7709 7495 7495
q19 7136 1619 1497 1497
q20 2048 1766 1735 1735
q21 13940 5060 4943 4943
q22 620 512 553 512
Total cold run time: 87458 ms
Total hot run time: 56150 ms
TPC-DS: Total hot run time: 186957 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 53af774126ff4658e86f0ad44291e357804e5129, data reload: false
query1 2624 382 356 356
query2 8473 2355 2328 2328
query3 7849 229 215 215
query4 25857 21172 21223 21172
query5 4107 414 425 414
query6 259 187 194 187
query7 4587 279 274 274
query8 240 179 181 179
query9 8712 2314 2290 2290
query10 441 265 247 247
query11 14774 14150 14269 14150
query12 136 91 85 85
query13 1637 368 368 368
query14 10557 8201 8223 8201
query15 276 169 167 167
query16 8255 272 262 262
query17 2034 565 561 561
query18 2144 287 281 281
query19 344 151 152 151
query20 95 86 87 86
query21 197 130 130 130
query22 5022 4815 4851 4815
query23 33929 33043 33102 33043
query24 9270 2906 2941 2906
query25 590 416 389 389
query26 697 154 149 149
query27 2082 315 317 315
query28 5735 2000 2007 2000
query29 909 611 594 594
query30 293 152 155 152
query31 1006 755 729 729
query32 92 54 55 54
query33 612 241 241 241
query34 877 464 486 464
query35 760 686 659 659
query36 1045 874 886 874
query37 107 62 68 62
query38 3147 3033 2989 2989
query39 1644 1517 1532 1517
query40 200 127 124 124
query41 41 38 37 37
query42 105 93 98 93
query43 541 543 551 543
query44 1103 719 730 719
query45 287 270 267 267
query46 1068 719 699 699
query47 1939 1833 1861 1833
query48 364 305 288 288
query49 956 407 392 392
query50 771 364 379 364
query51 6900 6714 6753 6714
query52 95 89 91 89
query53 347 274 277 274
query54 272 229 230 229
query55 77 71 71 71
query56 244 222 212 212
query57 1201 1154 1105 1105
query58 220 192 207 192
query59 3380 3244 3032 3032
query60 253 230 235 230
query61 116 91 89 89
query62 621 452 446 446
query63 299 273 276 273
query64 8243 7133 7105 7105
query65 3092 3014 3056 3014
query66 819 336 350 336
query67 15698 14964 15322 14964
query68 5797 538 533 533
query69 520 302 306 302
query70 1158 1155 1151 1151
query71 476 265 265 265
query72 8222 2596 2453 2453
query73 724 313 324 313
query74 6505 6145 6024 6024
query75 3756 2656 2697 2656
query76 4150 1002 942 942
query77 655 258 263 258
query78 11191 10103 10081 10081
query79 8724 530 513 513
query80 1621 439 434 434
query81 546 223 216 216
query82 1654 91 88 88
query83 200 162 164 162
query84 266 83 82 82
query85 1379 294 255 255
query86 458 318 275 275
query87 3276 3123 3129 3123
query88 5076 2311 2297 2297
query89 560 368 372 368
query90 2018 184 182 182
query91 123 96 94 94
query92 55 45 50 45
query93 6855 521 496 496
query94 1186 181 181 181
query95 1097 1099 1093 1093
query96 604 264 261 261
query97 3201 2953 2958 2953
query98 236 220 214 214
query99 1225 857 881 857
Total cold run time: 304181 ms
Total hot run time: 186957 ms
TPC-H: Total hot run time: 40682 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 5536bf5f5b00dbcceb8848820be62cee793d48ff, data reload: false
------ Round 1 ----------------------------------
q1 17622 4464 4376 4376
q2 2415 185 193 185
q3 11059 1216 1211 1211
q4 10521 786 760 760
q5 7690 2803 2725 2725
q6 219 134 135 134
q7 1079 620 611 611
q8 9626 2161 2074 2074
q9 9370 6762 6656 6656
q10 8815 3780 3752 3752
q11 460 238 254 238
q12 389 222 219 219
q13 18632 2948 2971 2948
q14 267 233 234 233
q15 519 483 477 477
q16 511 397 393 393
q17 952 691 684 684
q18 8085 7590 7580 7580
q19 1622 1570 1511 1511
q20 658 292 323 292
q21 5140 3953 3345 3345
q22 350 278 287 278
Total cold run time: 116001 ms
Total hot run time: 40682 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4272 4187 4244 4187
q2 384 261 269 261
q3 3021 2745 2776 2745
q4 1869 1536 1537 1536
q5 5307 5344 5300 5300
q6 204 120 123 120
q7 2252 1890 1911 1890
q8 3179 3309 3344 3309
q9 8589 8618 8583 8583
q10 3893 3735 3678 3678
q11 583 484 503 484
q12 764 577 569 569
q13 16317 2989 2960 2960
q14 301 284 282 282
q15 509 498 481 481
q16 462 421 419 419
q17 1743 1484 1457 1457
q18 7613 7561 7513 7513
q19 1633 1550 1510 1510
q20 1966 1754 1757 1754
q21 5030 4826 4884 4826
q22 582 502 511 502
Total cold run time: 70473 ms
Total hot run time: 54366 ms
TeamCity be ut coverage result: Function Coverage: 35.51% (8923/25130) Line Coverage: 27.13% (73433/270638) Region Coverage: 26.32% (37939/144126) Branch Coverage: 23.11% (19321/83610) Coverage Report: http://coverage.selectdb-in.cc/coverage/5536bf5f5b00dbcceb8848820be62cee793d48ff_5536bf5f5b00dbcceb8848820be62cee793d48ff/report/index.html
TPC-DS: Total hot run time: 187298 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 5536bf5f5b00dbcceb8848820be62cee793d48ff, data reload: false
query1 918 361 345 345
query2 6470 2466 2266 2266
query3 6651 202 206 202
query4 23560 21118 21149 21118
query5 4162 434 412 412
query6 257 174 171 171
query7 4584 297 291 291
query8 255 207 188 188
query9 8314 2343 2330 2330
query10 438 247 254 247
query11 14690 14280 14331 14280
query12 145 94 88 88
query13 1657 377 388 377
query14 9457 7654 7542 7542
query15 247 172 177 172
query16 8061 251 269 251
query17 1864 555 539 539
query18 2074 274 273 273
query19 198 151 147 147
query20 106 92 92 92
query21 192 125 126 125
query22 5022 4864 4778 4778
query23 33914 33366 33272 33272
query24 11845 2962 2960 2960
query25 663 367 364 364
query26 1782 158 150 150
query27 3115 321 329 321
query28 7692 2005 2020 2005
query29 1040 605 594 594
query30 301 148 151 148
query31 1001 738 728 728
query32 87 51 55 51
query33 746 261 244 244
query34 1094 482 480 480
query35 819 704 668 668
query36 1055 924 926 924
query37 274 71 70 70
query38 3168 3033 2984 2984
query39 1635 1556 1530 1530
query40 276 123 127 123
query41 42 39 39 39
query42 106 96 93 93
query43 564 553 531 531
query44 1219 732 756 732
query45 288 278 250 250
query46 1075 702 720 702
query47 1907 1871 1856 1856
query48 368 301 296 296
query49 1214 425 418 418
query50 769 399 384 384
query51 6834 6867 6724 6724
query52 106 96 93 93
query53 352 282 280 280
query54 319 247 249 247
query55 79 75 73 73
query56 249 230 231 230
query57 1222 1122 1143 1122
query58 239 201 200 200
query59 3535 3273 3260 3260
query60 262 251 243 243
query61 111 108 107 107
query62 639 438 437 437
query63 308 285 280 280
query64 9585 7216 7201 7201
query65 3121 3054 3037 3037
query66 1409 348 361 348
query67 15633 14991 15105 14991
query68 8464 563 576 563
query69 538 312 311 311
query70 1235 1102 1148 1102
query71 580 267 277 267
query72 8095 2602 2454 2454
query73 740 320 323 320
query74 6614 6132 6156 6132
query75 4103 2662 2683 2662
query76 5051 989 986 986
query77 623 259 262 259
query78 11086 10139 10379 10139
query79 12693 520 509 509
query80 1813 434 417 417
query81 491 227 216 216
query82 729 91 92 91
query83 199 168 164 164
query84 269 80 80 80
query85 1516 258 254 254
query86 403 287 277 277
query87 3427 3060 3076 3060
query88 5441 2321 2312 2312
query89 544 370 379 370
query90 1977 182 173 173
query91 120 93 95 93
query92 54 45 46 45
query93 7617 526 510 510
query94 1225 182 171 171
query95 1093 1100 1091 1091
query96 617 264 263 263
query97 3161 2921 2927 2921
query98 244 219 214 214
query99 1289 848 851 848
Total cold run time: 313435 ms
Total hot run time: 187298 ms
PR approved by at least one committer and no changes requested.
TPC-H: Total hot run time: 39770 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 796ccaa8cb00f478d4ee0905bd3f9bb53de7753b, data reload: false
------ Round 1 ----------------------------------
q1 4949 4685 4244 4244
q2 1829 190 183 183
q3 1473 1158 1154 1154
q4 1180 727 733 727
q5 2660 2713 2613 2613
q6 218 136 136 136
q7 952 528 526 526
q8 9261 2186 2173 2173
q9 9212 6528 6491 6491
q10 8974 3750 3737 3737
q11 445 235 234 234
q12 392 208 215 208
q13 17763 2922 2946 2922
q14 265 234 224 224
q15 509 489 479 479
q16 474 386 390 386
q17 962 635 709 635
q18 8190 7440 7360 7360
q19 6091 1544 1489 1489
q20 644 303 308 303
q21 5035 3270 3320 3270
q22 355 276 276 276
Total cold run time: 81833 ms
Total hot run time: 39770 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4335 4228 4199 4199
q2 383 273 278 273
q3 2990 2751 2707 2707
q4 1900 1601 1593 1593
q5 5277 5313 5306 5306
q6 218 123 125 123
q7 1782 1365 1361 1361
q8 3182 3359 3371 3359
q9 8337 8346 8342 8342
q10 3867 3661 3666 3661
q11 596 491 503 491
q12 758 602 596 596
q13 17127 2933 2976 2933
q14 290 253 245 245
q15 506 492 460 460
q16 477 404 408 404
q17 1785 1490 1454 1454
q18 7646 7534 7544 7534
q19 1661 1576 1572 1572
q20 1972 1819 1758 1758
q21 4913 4869 4741 4741
q22 566 488 488 488
Total cold run time: 70568 ms
Total hot run time: 53600 ms
TPC-DS: Total hot run time: 186951 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 796ccaa8cb00f478d4ee0905bd3f9bb53de7753b, data reload: false
query1 897 378 345 345
query2 6451 2310 2252 2252
query3 6660 201 211 201
query4 22863 21245 21101 21101
query5 4162 409 416 409
query6 265 166 175 166
query7 4587 296 292 292
query8 243 185 190 185
query9 8509 2435 2453 2435
query10 424 246 241 241
query11 14809 14193 14199 14193
query12 135 92 86 86
query13 1646 378 382 378
query14 9814 7656 8394 7656
query15 271 166 170 166
query16 8166 260 266 260
query17 1883 548 525 525
query18 2118 293 269 269
query19 261 150 152 150
query20 90 87 87 87
query21 194 133 126 126
query22 5102 4867 4941 4867
query23 34424 33521 33545 33521
query24 7482 2875 2950 2875
query25 586 359 363 359
query26 706 150 155 150
query27 2157 314 329 314
query28 5405 2090 2079 2079
query29 858 615 592 592
query30 288 148 150 148
query31 970 746 737 737
query32 96 50 54 50
query33 548 246 249 246
query34 886 487 476 476
query35 756 676 677 676
query36 1074 878 899 878
query37 103 66 67 66
query38 2857 2791 2749 2749
query39 1629 1551 1549 1549
query40 225 129 123 123
query41 42 38 38 38
query42 102 93 97 93
query43 578 538 553 538
query44 1066 725 745 725
query45 264 253 252 252
query46 1067 750 716 716
query47 2001 1858 1877 1858
query48 379 302 294 294
query49 1030 398 400 398
query50 775 389 391 389
query51 6825 6779 6816 6779
query52 99 94 92 92
query53 358 286 283 283
query54 535 429 441 429
query55 73 73 73 73
query56 242 219 222 219
query57 1237 1130 1149 1130
query58 221 200 205 200
query59 3435 3173 3307 3173
query60 253 244 271 244
query61 89 88 88 88
query62 632 480 480 480
query63 309 275 284 275
query64 8508 7354 7319 7319
query65 3165 3066 3082 3066
query66 820 349 344 344
query67 15650 15460 14928 14928
query68 4595 526 530 526
query69 484 301 297 297
query70 1090 1164 1127 1127
query71 383 263 263 263
query72 7220 2556 2369 2369
query73 702 329 328 328
query74 6598 6076 6125 6076
query75 3396 2631 2595 2595
query76 2494 1015 907 907
query77 442 263 258 258
query78 10548 10158 10079 10079
query79 2426 523 511 511
query80 1149 450 430 430
query81 536 226 218 218
query82 720 91 93 91
query83 242 171 172 171
query84 241 88 81 81
query85 1455 329 365 329
query86 475 317 313 313
query87 3266 3177 3086 3086
query88 4094 2456 2457 2456
query89 466 380 399 380
query90 1950 187 186 186
query91 120 97 97 97
query92 61 47 47 47
query93 1970 503 496 496
query94 1192 179 228 179
query95 380 290 299 290
query96 589 282 268 268
query97 3187 2991 2981 2981
query98 224 218 214 214
query99 1216 961 901 901
Total cold run time: 274266 ms
Total hot run time: 186951 ms
TeamCity be ut coverage result: Function Coverage: 35.70% (9018/25261) Line Coverage: 27.34% (74556/272708) Region Coverage: 26.55% (38539/145172) Branch Coverage: 23.40% (19660/84028) Coverage Report: http://coverage.selectdb-in.cc/coverage/a29bba6b92af41e6c5610b6c777ba88f37467bf1_a29bba6b92af41e6c5610b6c777ba88f37467bf1/report/index.html
TPC-H: Total hot run time: 42128 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit a29bba6b92af41e6c5610b6c777ba88f37467bf1, data reload: false
------ Round 1 ----------------------------------
q1 17607 4297 4261 4261
q2 2021 210 190 190
q3 10439 1263 1280 1263
q4 10191 860 802 802
q5 7456 2716 2732 2716
q6 233 129 138 129
q7 1006 584 594 584
q8 9226 2139 2081 2081
q9 9037 6772 6795 6772
q10 9561 3872 3911 3872
q11 457 241 250 241
q12 422 223 234 223
q13 17215 3188 3306 3188
q14 282 218 217 217
q15 498 460 475 460
q16 488 393 392 392
q17 988 769 775 769
q18 8421 7808 7710 7710
q19 1826 1548 1553 1548
q20 642 327 320 320
q21 5288 4262 4111 4111
q22 339 279 279 279
Total cold run time: 113643 ms
Total hot run time: 42128 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4553 4367 4334 4334
q2 370 280 276 276
q3 3174 3001 2880 2880
q4 1858 1597 1646 1597
q5 5514 5490 5490 5490
q6 240 123 130 123
q7 2313 1967 2028 1967
q8 3227 3416 3352 3352
q9 8651 8712 8640 8640
q10 3916 3847 3797 3797
q11 599 512 502 502
q12 792 585 624 585
q13 15871 3147 3170 3147
q14 323 281 282 281
q15 525 483 484 483
q16 488 420 435 420
q17 1755 1504 1469 1469
q18 7765 7481 7517 7481
q19 2567 1546 1542 1542
q20 1995 1843 1772 1772
q21 4924 4901 4961 4901
q22 551 498 505 498
Total cold run time: 71971 ms
Total hot run time: 55537 ms
TPC-DS: Total hot run time: 181354 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit a29bba6b92af41e6c5610b6c777ba88f37467bf1, data reload: false
query1 914 380 363 363
query2 6427 2390 2333 2333
query3 6645 215 214 214
query4 25356 21352 21226 21226
query5 4191 425 429 425
query6 268 178 184 178
query7 4722 307 297 297
query8 248 196 186 186
query9 9654 2454 2451 2451
query10 438 260 257 257
query11 15017 14164 14196 14164
query12 133 89 86 86
query13 1652 376 383 376
query14 9759 7680 7940 7680
query15 217 172 176 172
query16 7498 271 267 267
query17 1755 548 539 539
query18 1343 285 267 267
query19 200 147 147 147
query20 94 88 88 88
query21 195 132 127 127
query22 5060 4838 4922 4838
query23 34222 33591 33435 33435
query24 10504 2888 2950 2888
query25 579 364 364 364
query26 711 151 151 151
query27 2192 320 327 320
query28 5813 2033 2015 2015
query29 844 627 588 588
query30 262 185 178 178
query31 1018 768 733 733
query32 89 51 55 51
query33 665 245 245 245
query34 882 474 482 474
query35 798 678 655 655
query36 1055 907 904 904
query37 103 69 68 68
query38 2857 2765 2739 2739
query39 1625 1572 1561 1561
query40 198 125 126 125
query41 45 44 44 44
query42 106 97 97 97
query43 607 567 523 523
query44 1076 727 742 727
query45 266 252 257 252
query46 1070 734 708 708
query47 1963 1855 1892 1855
query48 359 300 284 284
query49 855 382 393 382
query50 773 377 371 371
query51 6890 6758 6819 6758
query52 102 91 89 89
query53 344 282 282 282
query54 852 424 415 415
query55 76 71 73 71
query56 238 223 218 218
query57 1228 1156 1168 1156
query58 217 193 197 193
query59 3404 3168 3097 3097
query60 251 227 233 227
query61 92 106 92 92
query62 617 479 470 470
query63 310 280 284 280
query64 8503 2217 1717 1717
query65 3158 3093 3116 3093
query66 786 342 336 336
query67 15336 15003 15034 15003
query68 4600 527 521 521
query69 484 300 308 300
query70 1209 1150 1115 1115
query71 353 266 265 265
query72 7159 2580 2358 2358
query73 722 315 322 315
query74 6657 6282 6147 6147
query75 3333 2645 2653 2645
query76 2182 942 922 922
query77 406 256 267 256
query78 10623 10121 10034 10034
query79 2442 522 525 522
query80 908 449 423 423
query81 533 244 244 244
query82 844 97 95 95
query83 251 164 164 164
query84 248 83 84 83
query85 1465 274 270 270
query86 462 311 301 301
query87 3218 3113 3097 3097
query88 4052 2308 2310 2308
query89 468 372 380 372
query90 1997 193 187 187
query91 132 100 99 99
query92 61 48 94 48
query93 1968 498 492 492
query94 1257 182 178 178
query95 389 304 293 293
query96 590 268 268 268
query97 3199 3006 3035 3006
query98 240 230 215 215
query99 1188 926 896 896
Total cold run time: 279367 ms
Total hot run time: 181354 ms
ClickBench: Total hot run time: 29.76 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit a29bba6b92af41e6c5610b6c777ba88f37467bf1, data reload: false
query1 0.03 0.03 0.03
query2 0.09 0.04 0.04
query3 0.24 0.06 0.05
query4 1.67 0.07 0.09
query5 0.49 0.49 0.50
query6 1.12 0.72 0.73
query7 0.02 0.01 0.02
query8 0.05 0.04 0.04
query9 0.55 0.50 0.48
query10 0.54 0.53 0.54
query11 0.15 0.11 0.12
query12 0.14 0.12 0.12
query13 0.59 0.60 0.59
query14 0.77 0.78 0.79
query15 0.82 0.83 0.80
query16 0.35 0.38 0.37
query17 0.99 0.95 1.02
query18 0.20 0.27 0.23
query19 1.84 1.71 1.70
query20 0.01 0.00 0.01
query21 15.43 0.69 0.68
query22 5.28 7.05 1.24
query23 18.29 1.42 1.18
query24 1.86 0.25 0.22
query25 0.15 0.08 0.08
query26 0.27 0.18 0.16
query27 0.08 0.08 0.07
query28 13.27 1.02 1.00
query29 13.25 3.28 3.26
query30 0.23 0.05 0.05
query31 2.87 0.40 0.39
query32 3.29 0.47 0.46
query33 2.84 2.94 2.87
query34 17.17 4.43 4.45
query35 4.51 4.51 4.60
query36 0.65 0.46 0.46
query37 0.18 0.16 0.15
query38 0.15 0.15 0.15
query39 0.05 0.03 0.04
query40 0.17 0.15 0.14
query41 0.09 0.04 0.04
query42 0.06 0.04 0.05
query43 0.04 0.04 0.04
Total cold run time: 110.84 s
Total hot run time: 29.76 s