doris
doris copied to clipboard
Published
20 hours ago •
apache
apache
[feature](block) add check type in block data type and column
Proposed changes
mysql [test]>select cast(j as int) from test_json_not_null;
ERROR 1105 (HY000): errCode = 2, detailMessage = (127.0.0.1)[CANCELLED][INTERNAL_ERROR]block column type check failed , reason : check failed in data type = Int32 , column name : (CAST j(JSONB) TO Int32) , colunm expect datatype : Int32
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.56% (8932/25115) Line Coverage: 27.20% (73635/270717) Region Coverage: 26.39% (38034/144128) Branch Coverage: 23.17% (19385/83648) Coverage Report: http://coverage.selectdb-in.cc/coverage/738265170cd915f2e92c8396c5d636b6ba19e422_738265170cd915f2e92c8396c5d636b6ba19e422/report/index.html
TPC-DS: Total hot run time: 187163 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 738265170cd915f2e92c8396c5d636b6ba19e422, data reload: false
query1 894 365 348 348
query2 6284 2386 2207 2207
query3 6675 215 220 215
query4 23135 21953 22165 21953
query5 3780 424 425 424
query6 274 193 182 182
query7 4548 283 285 283
query8 236 198 183 183
query9 8451 2397 2391 2391
query10 414 259 256 256
query11 15405 14792 14921 14792
query12 116 88 92 88
query13 1601 399 363 363
query14 10405 7523 8391 7523
query15 251 174 166 166
query16 8187 265 269 265
query17 1757 573 557 557
query18 2104 274 281 274
query19 335 150 150 150
query20 94 82 84 82
query21 192 128 131 128
query22 4999 4815 4793 4793
query23 33418 33040 33139 33040
query24 10741 2984 2913 2913
query25 628 379 383 379
query26 1350 151 149 149
query27 2883 318 320 318
query28 7149 2031 2001 2001
query29 887 602 613 602
query30 250 152 148 148
query31 984 740 758 740
query32 87 49 52 49
query33 729 245 239 239
query34 1028 479 462 462
query35 796 669 670 669
query36 1089 935 885 885
query37 130 66 63 63
query38 3171 3005 3012 3005
query39 1621 1546 1534 1534
query40 240 127 123 123
query41 40 37 40 37
query42 103 98 95 95
query43 570 509 539 509
query44 1219 737 745 737
query45 271 253 266 253
query46 1082 731 750 731
query47 1949 1873 1840 1840
query48 362 302 286 286
query49 874 426 382 382
query50 760 370 370 370
query51 6856 6852 6684 6684
query52 106 98 89 89
query53 351 275 274 274
query54 287 232 251 232
query55 80 75 71 71
query56 235 213 214 213
query57 1202 1124 1100 1100
query58 222 193 193 193
query59 3414 3072 3162 3072
query60 246 232 230 230
query61 107 85 84 84
query62 639 444 436 436
query63 310 280 284 280
query64 8812 7175 7110 7110
query65 3058 3051 3024 3024
query66 989 340 357 340
query67 15355 15264 14944 14944
query68 9617 542 548 542
query69 589 300 307 300
query70 1299 1130 1101 1101
query71 552 274 263 263
query72 8475 2582 2476 2476
query73 1584 317 322 317
query74 6723 6131 6111 6111
query75 5330 2691 2649 2649
query76 5953 1077 980 980
query77 789 265 268 265
query78 11123 10144 10237 10144
query79 12329 528 528 528
query80 1533 426 430 426
query81 486 221 216 216
query82 305 92 89 89
query83 203 167 168 167
query84 263 82 81 81
query85 1050 259 262 259
query86 347 286 293 286
query87 3274 3114 3127 3114
query88 4915 2337 2324 2324
query89 522 378 374 374
query90 2099 183 190 183
query91 130 93 93 93
query92 60 49 49 49
query93 7302 511 503 503
query94 1370 178 184 178
query95 396 302 315 302
query96 620 262 275 262
query97 3177 2978 2941 2941
query98 230 215 217 215
query99 1227 867 874 867
Total cold run time: 310689 ms
Total hot run time: 187163 ms
TeamCity be ut coverage result: Function Coverage: 35.57% (8934/25116) Line Coverage: 27.21% (73656/270720) Region Coverage: 26.40% (38056/144129) Branch Coverage: 23.18% (19392/83648) Coverage Report: http://coverage.selectdb-in.cc/coverage/786b733bb5fa229f5a9de1c5126d7411f5dc62ce_786b733bb5fa229f5a9de1c5126d7411f5dc62ce/report/index.html
TPC-DS: Total hot run time: 188087 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 786b733bb5fa229f5a9de1c5126d7411f5dc62ce, data reload: false
query1 903 364 345 345
query2 6291 2424 2358 2358
query3 6662 203 201 201
query4 25174 21869 21756 21756
query5 3830 408 409 408
query6 262 196 175 175
query7 4612 290 291 290
query8 240 191 192 191
query9 8579 2358 2373 2358
query10 416 262 256 256
query11 15129 14894 14796 14796
query12 120 89 88 88
query13 1633 372 369 369
query14 9627 8429 8387 8387
query15 261 176 173 173
query16 8154 264 260 260
query17 1896 564 561 561
query18 2090 282 283 282
query19 323 150 151 150
query20 91 82 84 82
query21 196 128 124 124
query22 5056 4976 4869 4869
query23 34020 33087 33282 33087
query24 10668 2927 2948 2927
query25 608 385 378 378
query26 1250 148 147 147
query27 2876 314 316 314
query28 7429 1977 1971 1971
query29 879 615 619 615
query30 306 150 151 150
query31 957 739 727 727
query32 88 48 49 48
query33 736 235 238 235
query34 1064 455 475 455
query35 812 661 683 661
query36 1035 949 938 938
query37 131 65 64 64
query38 3189 3040 3096 3040
query39 1636 1529 1523 1523
query40 189 127 124 124
query41 40 37 38 37
query42 99 91 92 91
query43 581 554 537 537
query44 1208 731 739 731
query45 281 256 259 256
query46 1070 746 717 717
query47 1968 1863 1850 1850
query48 360 302 295 295
query49 846 393 380 380
query50 770 393 381 381
query51 6880 6685 6698 6685
query52 97 93 84 84
query53 347 272 271 271
query54 324 229 235 229
query55 85 72 75 72
query56 239 234 218 218
query57 1191 1111 1122 1111
query58 217 196 193 193
query59 3470 3340 3144 3144
query60 248 231 232 231
query61 87 83 83 83
query62 650 453 435 435
query63 303 275 276 275
query64 8534 7124 7138 7124
query65 3048 3048 2980 2980
query66 946 331 329 329
query67 15670 14940 15075 14940
query68 9381 542 548 542
query69 551 306 304 304
query70 1213 1127 1149 1127
query71 514 265 263 263
query72 8177 2586 2424 2424
query73 1334 321 323 321
query74 6655 6240 6094 6094
query75 4619 2634 2664 2634
query76 5696 943 922 922
query77 660 267 261 261
query78 11103 10196 10277 10196
query79 12706 509 500 500
query80 2219 430 414 414
query81 489 217 214 214
query82 595 93 91 91
query83 214 163 172 163
query84 260 90 83 83
query85 1350 267 261 261
query86 400 313 305 305
query87 3352 3153 3080 3080
query88 5445 2425 2395 2395
query89 548 381 372 372
query90 2109 179 186 179
query91 123 96 96 96
query92 60 48 47 47
query93 8073 494 493 493
query94 1328 180 185 180
query95 395 297 297 297
query96 623 274 264 264
query97 3209 2973 2951 2951
query98 239 217 209 209
query99 1306 843 886 843
Total cold run time: 313923 ms
Total hot run time: 188087 ms
TPC-H: Total hot run time: 41176 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 1606af6cfba7b5dc0490c0096ef1de22230971ce, data reload: false
------ Round 1 ----------------------------------
q1 17773 5164 4497 4497
q2 2640 193 197 193
q3 12067 1173 1225 1173
q4 10366 852 839 839
q5 7563 2752 2639 2639
q6 221 133 136 133
q7 999 585 562 562
q8 9223 2100 2074 2074
q9 9003 6593 6593 6593
q10 9033 3760 3758 3758
q11 438 241 236 236
q12 463 220 221 220
q13 17863 2962 2964 2962
q14 268 226 228 226
q15 509 467 479 467
q16 519 395 367 367
q17 983 690 704 690
q18 7992 7539 7490 7490
q19 4541 1544 1544 1544
q20 647 312 311 311
q21 5177 3920 4160 3920
q22 347 287 282 282
Total cold run time: 118635 ms
Total hot run time: 41176 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4361 4258 4268 4258
q2 381 277 266 266
q3 3001 2764 2741 2741
q4 1882 1566 1599 1566
q5 5253 5320 5262 5262
q6 218 124 125 124
q7 2234 1902 1852 1852
q8 3220 3366 3340 3340
q9 8479 8465 8456 8456
q10 3934 3718 3711 3711
q11 585 480 481 480
q12 762 618 592 592
q13 17328 2979 2940 2940
q14 282 279 283 279
q15 516 471 480 471
q16 469 417 399 399
q17 1764 1491 1468 1468
q18 7641 7548 7425 7425
q19 1654 1531 1583 1531
q20 1958 1751 1793 1751
q21 5114 4921 4829 4829
q22 590 483 476 476
Total cold run time: 71626 ms
Total hot run time: 54217 ms
TeamCity be ut coverage result: Function Coverage: 35.55% (8934/25133) Line Coverage: 27.20% (73716/271005) Region Coverage: 26.39% (38075/144263) Branch Coverage: 23.18% (19405/83726) Coverage Report: http://coverage.selectdb-in.cc/coverage/1606af6cfba7b5dc0490c0096ef1de22230971ce_1606af6cfba7b5dc0490c0096ef1de22230971ce/report/index.html
TPC-H: Total hot run time: 40326 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 2aba86f6673d78dd7f7ed33655caa5ee3bfc7f74, data reload: false
------ Round 1 ----------------------------------
q1 18108 4772 4427 4427
q2 2558 198 207 198
q3 10922 1265 1286 1265
q4 10398 725 769 725
q5 7539 2764 2693 2693
q6 219 131 133 131
q7 1048 622 586 586
q8 9246 2073 2064 2064
q9 9151 6644 6532 6532
q10 8982 3679 3684 3679
q11 447 237 242 237
q12 520 212 222 212
q13 17778 3006 2995 2995
q14 277 206 214 206
q15 515 459 482 459
q16 513 374 374 374
q17 979 709 714 709
q18 7950 7479 7402 7402
q19 2290 1537 1537 1537
q20 647 309 305 305
q21 5255 3323 4032 3323
q22 357 267 286 267
Total cold run time: 115699 ms
Total hot run time: 40326 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4331 4232 4273 4232
q2 376 272 269 269
q3 3030 2797 2775 2775
q4 1930 1670 1605 1605
q5 5325 5327 5302 5302
q6 216 124 126 124
q7 2280 1886 1877 1877
q8 3218 3394 3368 3368
q9 8513 8455 8487 8455
q10 3918 3685 3712 3685
q11 580 507 496 496
q12 753 573 597 573
q13 17234 3001 2973 2973
q14 304 251 279 251
q15 521 499 479 479
q16 463 422 415 415
q17 1757 1489 1453 1453
q18 7616 7636 7414 7414
q19 4893 1584 1597 1584
q20 1968 1749 1771 1749
q21 5055 4797 4977 4797
q22 572 478 501 478
Total cold run time: 74853 ms
Total hot run time: 54354 ms
TPC-DS: Total hot run time: 185521 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 2aba86f6673d78dd7f7ed33655caa5ee3bfc7f74, data reload: false
query1 921 365 354 354
query2 6478 2362 2300 2300
query3 6653 206 208 206
query4 22818 21126 21182 21126
query5 4198 414 421 414
query6 281 181 176 176
query7 4594 293 287 287
query8 239 218 181 181
query9 8516 2375 2348 2348
query10 444 246 242 242
query11 14703 14096 14099 14096
query12 133 86 91 86
query13 1637 366 371 366
query14 9678 7576 7390 7390
query15 237 169 187 169
query16 7865 271 267 267
query17 1844 584 559 559
query18 1971 293 282 282
query19 205 156 155 155
query20 95 85 88 85
query21 192 129 128 128
query22 5024 4784 4837 4784
query23 33880 33233 33139 33139
query24 11942 2852 2933 2852
query25 674 381 376 376
query26 1765 158 154 154
query27 3003 320 314 314
query28 7623 2056 2054 2054
query29 1120 628 635 628
query30 303 156 152 152
query31 983 745 730 730
query32 95 56 58 56
query33 763 259 249 249
query34 1023 493 505 493
query35 817 672 690 672
query36 1085 912 961 912
query37 222 71 80 71
query38 3138 3009 2989 2989
query39 1614 1542 1535 1535
query40 285 128 127 127
query41 45 43 40 40
query42 106 97 98 97
query43 577 532 521 521
query44 1286 742 757 742
query45 268 259 259 259
query46 1073 759 731 731
query47 1944 1859 1865 1859
query48 377 300 296 296
query49 1211 407 412 407
query50 851 384 391 384
query51 6816 6664 6844 6664
query52 104 96 89 89
query53 354 290 284 284
query54 310 233 232 232
query55 75 71 74 71
query56 241 222 222 222
query57 1223 1138 1132 1132
query58 213 200 196 196
query59 3295 3161 3070 3070
query60 259 235 235 235
query61 93 104 89 89
query62 644 444 449 444
query63 327 282 284 282
query64 9630 7224 7199 7199
query65 3115 3071 3070 3070
query66 1418 345 337 337
query67 15711 14781 14898 14781
query68 9772 553 556 553
query69 588 307 305 305
query70 1288 1053 1116 1053
query71 487 277 263 263
query72 8581 2605 2379 2379
query73 1574 317 320 317
query74 6477 6044 6111 6044
query75 4571 2634 2696 2634
query76 5578 1059 1008 1008
query77 668 269 266 266
query78 11145 10302 10086 10086
query79 9889 531 525 525
query80 1788 440 438 438
query81 507 226 217 217
query82 216 93 98 93
query83 210 171 165 165
query84 267 84 87 84
query85 953 271 267 267
query86 357 295 284 284
query87 3312 3082 3055 3055
query88 4845 2310 2305 2305
query89 522 388 383 383
query90 2002 182 188 182
query91 131 98 98 98
query92 66 49 47 47
query93 6523 520 508 508
query94 1365 185 180 180
query95 410 299 303 299
query96 641 270 261 261
query97 3157 2915 2966 2915
query98 246 223 221 221
query99 1250 867 849 849
Total cold run time: 310013 ms
Total hot run time: 185521 ms
TeamCity be ut coverage result: Function Coverage: 35.61% (8973/25201) Line Coverage: 27.28% (74038/271356) Region Coverage: 26.51% (38248/144267) Branch Coverage: 23.31% (19479/83560) Coverage Report: http://coverage.selectdb-in.cc/coverage/2aba86f6673d78dd7f7ed33655caa5ee3bfc7f74_2aba86f6673d78dd7f7ed33655caa5ee3bfc7f74/report/index.html
TPC-H: Total hot run time: 40029 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit b204a2439f191158deb595cdffbdf4d3575131dc, data reload: false
------ Round 1 ----------------------------------
q1 17809 4618 4360 4360
q2 2673 195 188 188
q3 11327 1306 1173 1173
q4 10173 834 867 834
q5 7505 2746 2659 2659
q6 224 133 139 133
q7 1014 589 564 564
q8 9231 2108 2061 2061
q9 8737 6547 6523 6523
q10 8890 3788 3688 3688
q11 440 240 246 240
q12 433 220 221 220
q13 18868 2917 2974 2917
q14 269 210 220 210
q15 505 462 479 462
q16 482 396 379 379
q17 964 677 703 677
q18 8007 7424 7453 7424
q19 5347 1517 1506 1506
q20 657 306 300 300
q21 5096 3239 4083 3239
q22 354 272 289 272
Total cold run time: 119005 ms
Total hot run time: 40029 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4348 4245 4255 4245
q2 367 270 264 264
q3 2993 2738 2751 2738
q4 1866 1585 1585 1585
q5 5323 5272 5290 5272
q6 212 125 124 124
q7 2244 1888 1862 1862
q8 3240 3393 3385 3385
q9 8377 8377 8381 8377
q10 3910 3738 3738 3738
q11 583 494 478 478
q12 767 575 552 552
q13 17522 2914 2920 2914
q14 293 285 261 261
q15 513 481 493 481
q16 493 409 417 409
q17 1765 1492 1482 1482
q18 7649 7572 7485 7485
q19 1660 1630 1524 1524
q20 1958 1799 1756 1756
q21 4986 4823 4809 4809
q22 586 485 492 485
Total cold run time: 71655 ms
Total hot run time: 54226 ms
TPC-DS: Total hot run time: 187547 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 b204a2439f191158deb595cdffbdf4d3575131dc, data reload: false
query1 904 362 353 353
query2 6469 2368 2336 2336
query3 6664 209 210 209
query4 23175 21149 21214 21149
query5 4152 439 434 434
query6 269 178 176 176
query7 4588 303 290 290
query8 233 188 174 174
query9 8841 2421 2402 2402
query10 442 260 277 260
query11 14853 14181 14236 14181
query12 140 87 88 87
query13 1635 380 371 371
query14 10699 8849 8519 8519
query15 281 185 175 175
query16 8143 260 254 254
query17 1872 583 539 539
query18 2051 285 266 266
query19 198 144 149 144
query20 91 82 82 82
query21 196 133 129 129
query22 5009 4799 4844 4799
query23 34201 33537 33499 33499
query24 11668 2895 2897 2895
query25 647 362 358 358
query26 1742 156 152 152
query27 2934 322 314 314
query28 7206 2087 2064 2064
query29 994 600 616 600
query30 286 149 153 149
query31 1013 740 740 740
query32 94 53 55 53
query33 748 258 253 253
query34 1061 496 481 481
query35 818 702 683 683
query36 1105 933 936 933
query37 163 67 72 67
query38 2853 2760 2802 2760
query39 1672 1570 1579 1570
query40 280 141 130 130
query41 44 41 39 39
query42 109 97 98 97
query43 559 537 576 537
query44 1192 728 747 728
query45 271 251 256 251
query46 1069 730 713 713
query47 1988 1891 1903 1891
query48 378 291 292 291
query49 1165 409 391 391
query50 764 394 404 394
query51 6778 6648 6688 6648
query52 102 93 88 88
query53 347 294 285 285
query54 984 426 448 426
query55 79 76 73 73
query56 240 225 224 224
query57 1225 1134 1143 1134
query58 229 202 197 197
query59 3304 3111 3019 3019
query60 256 236 239 236
query61 88 87 87 87
query62 668 466 484 466
query63 312 286 282 282
query64 9760 7400 7334 7334
query65 3198 3142 3113 3113
query66 1381 341 335 335
query67 15493 14899 15114 14899
query68 4595 529 530 529
query69 475 300 320 300
query70 1167 1090 1030 1030
query71 360 267 278 267
query72 7177 2582 2358 2358
query73 705 342 344 342
query74 6490 6130 6087 6087
query75 3343 2653 2583 2583
query76 2473 1051 995 995
query77 386 265 270 265
query78 10608 10104 9881 9881
query79 2288 512 500 500
query80 946 431 442 431
query81 518 223 224 223
query82 643 94 89 89
query83 232 163 162 162
query84 235 91 84 84
query85 1887 268 256 256
query86 509 318 316 316
query87 3275 3101 3117 3101
query88 4129 2449 2469 2449
query89 472 393 385 385
query90 1890 189 193 189
query91 123 97 99 97
query92 62 52 50 50
query93 2286 513 493 493
query94 1200 182 188 182
query95 385 305 307 305
query96 591 270 272 270
query97 3140 3023 3010 3010
query98 234 217 218 217
query99 1132 907 893 893
Total cold run time: 286329 ms
Total hot run time: 187547 ms
TPC-H: Total hot run time: 41986 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 1a47edfdf8f80e1e0b28f9d9657bcbaa99c9907a, data reload: false
------ Round 1 ----------------------------------
q1 17611 4368 4250 4250
q2 2013 189 199 189
q3 10453 1300 1197 1197
q4 10190 870 894 870
q5 7453 2729 2764 2729
q6 219 138 136 136
q7 1028 600 590 590
q8 9227 2174 2101 2101
q9 9206 6794 6770 6770
q10 9173 3806 3965 3806
q11 443 246 243 243
q12 449 228 222 222
q13 17504 3125 3249 3125
q14 256 214 210 210
q15 504 473 466 466
q16 513 399 396 396
q17 997 740 698 698
q18 8420 7882 7723 7723
q19 6941 1612 1590 1590
q20 653 314 326 314
q21 5224 4084 4096 4084
q22 366 277 298 277
Total cold run time: 118843 ms
Total hot run time: 41986 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4517 4374 4392 4374
q2 377 275 273 273
q3 3094 2947 2724 2724
q4 1880 1630 1671 1630
q5 5508 5543 5480 5480
q6 218 127 125 125
q7 2291 1970 1955 1955
q8 3243 3443 3373 3373
q9 8700 8663 8739 8663
q10 3929 3843 3814 3814
q11 600 487 510 487
q12 808 638 609 609
q13 15840 3114 3063 3063
q14 297 282 262 262
q15 518 508 483 483
q16 484 431 432 431
q17 1816 1489 1471 1471
q18 7690 7560 7421 7421
q19 1655 1575 1539 1539
q20 1962 1769 1781 1769
q21 4978 4782 4796 4782
q22 565 487 488 487
Total cold run time: 70970 ms
Total hot run time: 55215 ms
TPC-DS: Total hot run time: 186657 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 1a47edfdf8f80e1e0b28f9d9657bcbaa99c9907a, data reload: false
query1 920 372 348 348
query2 6445 2424 2353 2353
query3 6632 203 205 203
query4 22932 21244 21483 21244
query5 4149 416 412 412
query6 259 177 173 173
query7 4588 297 292 292
query8 243 186 190 186
query9 8557 2400 2373 2373
query10 433 243 264 243
query11 14680 14239 14185 14185
query12 130 95 88 88
query13 1635 377 361 361
query14 11233 7706 7759 7706
query15 219 171 170 170
query16 7173 279 277 277
query17 1291 549 537 537
query18 1903 287 263 263
query19 195 143 150 143
query20 103 88 88 88
query21 196 132 132 132
query22 5114 4848 4848 4848
query23 33941 33344 33400 33344
query24 5003 2977 3005 2977
query25 458 362 369 362
query26 686 154 152 152
query27 1844 325 323 323
query28 3596 2040 2034 2034
query29 848 594 604 594
query30 235 153 155 153
query31 910 737 746 737
query32 60 53 54 53
query33 389 253 242 242
query34 867 479 481 479
query35 757 673 666 666
query36 1055 922 907 907
query37 101 66 65 65
query38 2884 2764 2764 2764
query39 1623 1548 1535 1535
query40 196 127 124 124
query41 41 38 38 38
query42 100 96 96 96
query43 596 546 568 546
query44 1092 732 746 732
query45 275 286 255 255
query46 1062 712 697 697
query47 1947 1877 1915 1877
query48 376 303 296 296
query49 765 394 394 394
query50 770 390 390 390
query51 6974 6768 6870 6768
query52 96 95 90 90
query53 356 277 282 277
query54 528 419 441 419
query55 76 75 75 75
query56 237 221 228 221
query57 1213 1121 1158 1121
query58 212 215 200 200
query59 3599 3296 3270 3270
query60 262 248 249 248
query61 140 85 89 85
query62 560 484 484 484
query63 311 279 278 278
query64 7666 7386 7311 7311
query65 3119 3154 3041 3041
query66 679 349 360 349
query67 15295 14811 14741 14741
query68 4557 590 532 532
query69 467 295 305 295
query70 1117 1116 1109 1109
query71 412 269 273 269
query72 7485 2569 2350 2350
query73 697 318 320 318
query74 6520 6138 6055 6055
query75 3289 2620 2616 2616
query76 2312 956 973 956
query77 381 260 262 260
query78 10628 10163 9960 9960
query79 1558 509 518 509
query80 1117 435 429 429
query81 511 223 220 220
query82 929 91 92 91
query83 234 166 167 166
query84 247 84 90 84
query85 903 315 260 260
query86 380 304 308 304
query87 3331 3083 3102 3083
query88 3408 2329 2346 2329
query89 463 375 380 375
query90 1978 189 190 189
query91 125 97 98 97
query92 64 49 48 48
query93 1182 516 507 507
query94 1107 185 188 185
query95 397 302 299 299
query96 570 266 262 262
query97 3140 2995 2969 2969
query98 234 228 209 209
query99 1262 926 887 887
Total cold run time: 263835 ms
Total hot run time: 186657 ms