testing results for: sql
mac-mini Cla-Dar-i64 | mac-mini Cla-Dar-i64 | lab01 Cla-Fed-i64 | lab04 GNU-Fed-i64 | lab05 GNU-Fed-i64 | lab05 GNU-Fed-i64 | lab05 GNU-Fed-i64 | lab04 GNU-Fed-i64 | lab05 GNU-Fed-i64 | lab01 GNU-Fed-i64 | lab05 GNU-Fed-i64 | lab01 Int-Fed-i64 | power8 GNU-Fed-p64 | power8 GNU-Fed-p64 | win2k12r2 Mic-Win-i32 | win2k12r2 Mic-Win-i64 | lab03 Int-Win-i64 | lab03 Mic-Win-i64 | |||||||||||||||||||
sql/jdbc/tests | 22.644 | 23.318 | 19.148 | 21.996 | 9.220 | 8.988 | 37.476 | 17.270 | 8.149 | 27.352 | 14.960 | 19.704 | 18.304 | 18.007 | 40.908 | 38.107 | 38.766 | 38.532 | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
JDBC_API_Tester | O O | 8.037 | O O | 8.346 | O O | 6.094 | O O | 6.849 | O O | 2.857 | O O | 2.860 | O O | 23.571 | O O | 5.897 | O O | 2.775 | O O | 7.902 | O O | 4.630 | O O | 6.087 | O O | 5.182 | O O | 5.108 | X O | 11.614 | X O | 9.695 | X O | 12.386 | X O | 13.338 |
SQLcopyinto | X O | 0.294 | X O | 0.302 | X O | 0.237 | X O | 0.231 | X O | 0.126 | X O | 0.113 | X O | 0.135 | X O | 0.237 | X O | 0.126 | X O | 0.281 | X O | 0.135 | X O | 0.239 | X O | 0.224 | X O | 0.206 | X O | 0.405 | X O | 0.612 | X O | 0.406 | X O | 0.390 |
Test_Int128 | X O | 0.288 | X O | 0.314 | X O | 0.223 | X O | 0.226 | X O | 0.125 | - - | -.--- | X O | 0.129 | X O | 0.239 | X O | 0.112 | X O | 0.269 | X O | 0.135 | X O | 0.240 | X O | 0.207 | - - | -.--- | - - | -.--- | - - | -.--- | - - | -.--- | - - | -.--- |
Test_JdbcClient | X O | 1.989 | X O | 1.948 | X O | 1.757 | X O | 1.893 | X O | 0.850 | X O | 0.847 | X O | 1.572 | X O | 1.677 | X O | 0.744 | X O | 2.315 | X O | 1.216 | X O | 1.780 | X O | 1.686 | X O | 1.638 | X O | 3.268 | X O | 2.981 | X O | 3.229 | X O | 3.323 |
bogus-auto-generated-keys | O X | 0.365 | O X | 0.360 | O X | 0.225 | O X | 0.219 | O X | 0.122 | O X | 0.116 | O X | 0.117 | O X | 0.221 | O X | 0.118 | O X | 0.224 | O X | 0.116 | O X | 0.226 | O X | 0.193 | O X | 0.191 | X O | 0.361 | X O | 0.832 | X O | 0.406 | X O | 0.390 |
BugConcurrent_clients_SF_1504657 | X O | 0.477 | X O | 0.359 | X O | 0.277 | X O | 0.272 | X O | 0.125 | X O | 0.129 | X O | 0.170 | X O | 0.273 | X O | 0.125 | X O | 0.289 | X O | 0.138 | X O | 0.272 | X O | 0.238 | X O | 0.241 | X O | 0.421 | X O | 0.562 | X O | 0.437 | X O | 0.452 |
BugConcurrent_sequences | X O | 0.368 | X O | 0.333 | X O | 0.271 | X O | 0.273 | X O | 0.128 | X O | 0.136 | X O | 0.167 | X O | 0.275 | X O | 0.122 | X O | 0.265 | X O | 0.131 | X O | 0.290 | X O | 0.245 | X O | 0.243 | X O | 0.463 | X O | 0.517 | X O | 0.593 | X O | 0.484 |
BugExecuteUpdate_Bug_3350 | X O | 0.370 | X O | 0.347 | X O | 0.238 | X O | 0.238 | X O | 0.111 | X O | 0.109 | X O | 0.152 | X O | 0.229 | X O | 0.115 | X O | 0.224 | X O | 0.114 | X O | 0.221 | X O | 0.208 | X O | 0.207 | X O | 0.383 | X O | 0.287 | X O | 0.406 | X O | 0.437 |
BugDatabaseMetaData_Bug_3356 | X O | 0.467 | X O | 0.330 | X O | 0.260 | X O | 0.264 | X O | 0.132 | X O | 0.132 | X O | 0.160 | X O | 0.251 | X O | 0.126 | X O | 0.281 | X O | 0.152 | X O | 0.256 | X O | 0.239 | X O | 0.222 | X O | 0.403 | X O | 0.295 | X O | 0.406 | X O | 0.421 |
BugSetQueryTimeout_Bug_3357 | X O | 0.321 | X O | 0.318 | X O | 0.223 | X O | 0.236 | X O | 0.116 | X O | 0.115 | X O | 0.117 | X O | 0.225 | X O | 0.109 | X O | 0.223 | X O | 0.106 | X O | 0.221 | X O | 0.201 | X O | 0.203 | X O | 0.437 | X O | 0.283 | X O | 0.374 | X O | 0.390 |
BugDecimalRound_Bug_3561 | X O | 0.372 | X O | 0.315 | X O | 0.227 | X O | 0.235 | X O | 0.109 | X O | 0.113 | X O | 0.117 | X O | 0.230 | X O | 0.113 | X O | 0.229 | X O | 0.110 | X O | 0.231 | X O | 0.203 | X O | 0.213 | X O | 0.328 | X O | 0.298 | X O | 0.390 | X O | 0.468 |
BugResultSetMetaData_Bug_6183 | X O | 0.441 | X O | 0.382 | X O | 0.258 | X O | 0.268 | X O | 0.132 | X O | 0.119 | X O | 0.163 | X O | 0.258 | X O | 0.123 | X O | 0.268 | X O | 0.130 | X O | 0.262 | X O | 0.229 | X O | 0.229 | X O | 0.431 | X O | 0.303 | X O | 0.499 | X O | 0.499 |
Bug_PrepStmtSetObject_CLOB_6349 | X O | 0.408 | X O | 0.352 | X O | 0.234 | X O | 0.247 | X O | 0.116 | X O | 0.108 | X O | 0.121 | X O | 0.262 | X O | 0.118 | X O | 0.239 | X O | 0.113 | X O | 0.231 | X O | 0.207 | X O | 0.214 | X O | 0.447 | X O | 0.310 | X O | 0.390 | X O | 0.390 |
Bug_Connect_as_voc_getMetaData_Failure_Bug_6388 | X O | 0.438 | X O | 0.335 | X O | 0.258 | X O | 0.269 | X O | 0.127 | X O | 0.135 | X O | 0.161 | X O | 0.257 | X O | 0.121 | X O | 0.296 | X O | 0.151 | X O | 0.267 | X O | 0.241 | X O | 0.245 | X O | 0.430 | X O | 0.361 | X O | 0.484 | X O | 0.452 |
Bug_PrepStmtSetString_6382 | X O | 0.442 | X O | 0.302 | X O | 0.264 | X O | 0.302 | X O | 0.116 | X O | 0.124 | X O | 0.134 | X O | 0.257 | X O | 0.129 | X O | 0.276 | X O | 0.128 | X O | 0.267 | X O | 0.226 | X O | 0.254 | X O | 0.429 | X O | 0.438 | X O | 0.421 | X O | 0.421 |
Bug_LargeQueries_6571_6693 | X O | 0.844 | X O | 1.283 | X O | 0.739 | X O | 0.822 | X O | 0.344 | X O | 0.343 | X O | 0.778 | X O | 0.703 | X O | 0.336 | X O | 0.792 | X O | 0.339 | X O | 0.766 | X O | 0.727 | X O | 0.748 | X O | 1.237 | X O | 0.847 | X O | 1.061 | X O | 1.030 |
Bug_IsValid_Timeout_Bug_6782 | X O | 0.278 | X O | 0.502 | X O | 0.231 | X O | 0.238 | X O | 0.106 | X O | 0.111 | X O | 0.119 | X O | 0.219 | X O | 0.107 | X O | 0.222 | X O | 0.109 | X O | 0.230 | X O | 0.199 | X O | 0.197 | X O | 0.356 | X O | 0.303 | X O | 0.374 | X O | 0.390 |
Bug_PrepStmt_With_Errors_Jira292 | X O | 0.291 | X O | 0.300 | X O | 0.258 | X O | 0.263 | X O | 0.117 | X O | 0.116 | X O | 0.142 | X O | 0.247 | X O | 0.118 | X O | 0.283 | X O | 0.121 | X O | 0.270 | X O | 0.227 | X O | 0.224 | X O | 0.569 | X O | 0.338 | X O | 0.452 | X O | 0.437 |
ValidateSystemCatalogTables | X O | 6.155 | X O | 6.589 | X O | 6.873 | X O | 8.651 | X O | 3.360 | X O | 3.262 | X O | 9.450 | X O | 5.314 | X O | 2.510 | X O | 12.474 | X O | 6.887 | X O | 7.348 | X O | 7.422 | X O | 7.425 | X O | 18.925 | X O | 18.847 | X O | 16.052 | X O | 14.820 |
sql/test | 14.571 | 14.289 | 19.647 | 21.380 | 9.557 | 9.496 | 20.684 | 19.093 | 8.829 | 25.011 | 13.556 | 19.797 | 19.669 | 19.479 | 31.517 | 29.220 | 34.039 | 33.415 | ||||||||||||||||||
sessioncontrol | O O | 0.031 | O O | 0.041 | O O | 0.048 | O O | 0.048 | O O | 0.019 | O O | 0.027 | O O | 0.050 | O O | 0.036 | O X | 0.025 | O O | 0.082 | O O | 0.051 | O O | 0.045 | O O | 0.041 | O O | 0.044 | O O | 0.094 | O O | 0.172 | O O | 0.125 | O O | 0.172 |
sql/test/BugTracker-2017 | 8.003 | 8.654 | 8.717 | 11.049 | 4.048 | 3.922 | 10.234 | 7.306 | 3.606 | 15.401 | 7.824 | 10.097 | 9.412 | 9.177 | 37.533 | 28.969 | 24.554 | 24.804 | ||||||||||||||||||
insert_self_ref_FK.Bug-6131 | X X | 0.083 | X X | 0.064 | X X | 0.094 | X X | 0.110 | X X | 0.038 | X X | 0.037 | X X | 0.095 | X X | 0.078 | X X | 0.034 | X X | 0.093 | X X | 0.040 | X X | 0.114 | X X | 0.070 | X X | 0.066 | X X | 0.938 | X X | 0.078 | X X | 0.187 | X X | 0.343 |
sql/test/BugTracker-2020 | 8.462 | 8.203 | 14.578 | 15.804 | 7.020 | 7.053 | 12.494 | 14.073 | 6.871 | 16.718 | 8.395 | 14.967 | 11.609 | 11.325 | 19.016 | 17.782 | 18.408 | 19.172 | ||||||||||||||||||
wrong-key-error.Bug-6983 | O X | 0.033 | O X | 0.031 | O X | 0.039 | O X | 0.039 | O X | 0.018 | O X | 0.019 | O X | 0.051 | O X | 0.031 | O X | 0.014 | O X | 0.076 | O X | 0.043 | O X | 0.037 | O X | 0.037 | O X | 0.037 | O X | 0.156 | O X | 0.187 | O X | 0.156 | O X | 0.156 |
dbfarm-foreign-chars.Bug-7031 | O O | 1.189 | O O | 1.092 | O O | 1.615 | O O | 1.771 | O O | 0.988 | O O | 0.899 | O O | 1.872 | O O | 1.623 | O O | 0.826 | O O | 1.648 | O O | 0.902 | O O | 1.621 | O O | 1.673 | O O | 1.623 | O X | 2.328 | O X | 2.266 | O X | 2.418 | O X | 2.480 |
sql/test/SQLancer | 3.256 | 2.722 | 3.454 | 3.686 | 1.436 | 1.423 | 4.288 | 3.036 | 1.228 | 4.309 | 2.034 | 3.436 | 2.173 | 2.234 | 4.875 | 5.907 | 5.788 | 6.848 | ||||||||||||||||||
sqlancer09 | O X | 0.321 | O X | 0.230 | O X | 0.288 | O X | 0.318 | O X | 0.128 | O X | 0.123 | O X | 0.370 | O X | 0.266 | O X | 0.112 | O X | 0.393 | O X | 0.179 | O X | 0.310 | O X | 0.209 | O X | 0.245 | O X | 0.469 | O X | 0.391 | O X | 0.421 | O X | 0.468 |
sql/test/Triggers | 0.952 | 1.037 | 1.263 | 1.260 | 0.516 | 0.494 | 1.056 | 1.120 | 0.430 | 1.545 | 0.741 | 1.197 | 1.137 | 1.105 | 3.578 | 5.750 | 2.543 | 2.995 | ||||||||||||||||||
mac-mini Cla-Dar-i64 | mac-mini Cla-Dar-i64 | lab01 Cla-Fed-i64 | lab04 GNU-Fed-i64 | lab05 GNU-Fed-i64 | lab05 GNU-Fed-i64 | lab05 GNU-Fed-i64 | lab04 GNU-Fed-i64 | lab05 GNU-Fed-i64 | lab01 GNU-Fed-i64 | lab05 GNU-Fed-i64 | lab01 Int-Fed-i64 | power8 GNU-Fed-p64 | power8 GNU-Fed-p64 | win2k12r2 Mic-Win-i32 | win2k12r2 Mic-Win-i64 | lab03 Int-Win-i64 | lab03 Mic-Win-i64 | |||||||||||||||||||
79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | |||||||||||||||||||
trigger_action | X X | 0.064 | X X | 0.040 | X X | 0.072 | X X | 0.076 | X X | 0.032 | X X | 0.026 | X X | 0.063 | X X | 0.060 | X X | 0.033 | X X | 0.061 | X X | 0.028 | X X | 0.074 | X X | 0.075 | X X | 0.079 | X X | 0.219 | X X | 0.594 | X X | 0.140 | X X | 0.203 |
trigger_projection | X X | 0.019 | X X | 0.023 | X X | 0.038 | X X | 0.036 | X X | 0.011 | X X | 0.013 | X X | 0.026 | X X | 0.028 | X X | 0.019 | X X | 0.031 | X X | 0.013 | X X | 0.037 | X X | 0.028 | X X | 0.027 | X X | 0.047 | X X | 0.125 | X X | 0.031 | X X | 0.109 |
sql/test/VOC | 3.533 | 4.590 | 12.951 | 14.360 | 2.130 | 2.126 | 3.494 | 12.991 | 2.117 | 14.273 | 2.243 | 13.123 | 5.378 | 5.348 | 3.453 | 365.855 | 4.040 | 3.916 | ||||||||||||||||||
VOC | O O | 3.473 | O O | 4.419 | O O | 12.871 | O O | 14.246 | O O | 2.092 | O O | 2.091 | O O | 3.398 | O O | 12.929 | O O | 2.087 | O O | 14.119 | O O | 2.155 | O O | 13.042 | O O | 5.237 | O O | 5.238 | O O | 2.969 | O T | 365.089 | O O | 3.666 | O O | 3.650 |
sql/test/analytics | 2.727 | 3.343 | 4.141 | 4.391 | 1.754 | 1.744 | 4.270 | 3.465 | 1.397 | 5.137 | 2.561 | 4.164 | 4.125 | 4.119 | 9.469 | 13.751 | 7.004 | 7.660 | ||||||||||||||||||
analytics00 | O O | 0.209 | O O | 0.245 | O O | 0.300 | O O | 0.334 | O O | 0.121 | O O | 0.113 | O O | 0.308 | O O | 0.248 | O O | 0.085 | O O | 0.396 | O O | 0.198 | O O | 0.315 | O O | 0.266 | O O | 0.263 | O O | 0.906 | O O | 0.906 | O O | 0.562 | O X | 0.967 |
analytics09 | O O | 0.090 | O O | 0.096 | O O | 0.140 | O O | 0.136 | O O | 0.064 | O O | 0.067 | O O | 0.177 | O O | 0.092 | O O | 0.038 | O O | 0.198 | O O | 0.107 | O O | 0.149 | O O | 0.118 | O O | 0.123 | O O | 0.422 | O O | 0.703 | O O | 0.265 | O X | 0.265 |
sql/test/emptydb | 1.136 | 1.331 | 10.575 | 12.566 | 5.622 | 5.386 | 17.200 | 6.325 | 3.305 | 32.589 | 20.424 | 10.770 | 10.740 | 10.448 | 2.672 | 3.109 | 2.699 | 2.714 | ||||||||||||||||||
check | - - | -.--- | - - | -.--- | O O | 8.755 | O O | 10.499 | O O | 4.683 | O X | 4.476 | O O | 14.813 | O O | 4.548 | O O | 2.380 | O O | 30.539 | O O | 19.338 | O O | 8.966 | O O | 8.956 | O X | 8.636 | - - | -.--- | - - | -.--- | - - | -.--- | - - | -.--- |
sql/test/emptydb-upgrade | 0.000 | 0.000 | 11.287 | 13.600 | 6.106 | 5.693 | 18.627 | 6.969 | 3.772 | 33.432 | 20.878 | 11.592 | 11.765 | 11.195 | 0.000 | 0.000 | 0.000 | 0.000 | ||||||||||||||||||
check | - - | -.--- | - - | -.--- | O O | 8.897 | O O | 10.822 | O O | 4.890 | O X | 4.590 | O O | 14.736 | O O | 4.662 | O O | 2.582 | O O | 30.668 | O O | 19.437 | O O | 9.095 | O O | 9.274 | O X | 8.975 | - - | -.--- | - - | -.--- | - - | -.--- | - - | -.--- |
sql/test/emptydb-upgrade-chain | 0.000 | 0.000 | 11.581 | 13.623 | 6.045 | 5.612 | 19.288 | 7.472 | 3.525 | 33.471 | 20.950 | 12.023 | 12.293 | 11.519 | 0.000 | 0.000 | 0.000 | 0.000 | ||||||||||||||||||
check | - - | -.--- | - - | -.--- | O X | 9.092 | O X | 10.733 | O X | 4.791 | O X | 4.484 | O X | 15.260 | O X | 5.087 | O X | 2.287 | O X | 30.568 | O X | 19.444 | O X | 9.397 | O X | 9.585 | O X | 9.182 | - - | -.--- | - - | -.--- | - - | -.--- | - - | -.--- |
sql/test/emptydb-upgrade-chain-hge | 0.000 | 0.000 | 11.422 | 13.255 | 5.921 | 0.000 | 19.445 | 7.241 | 3.702 | 33.549 | 21.463 | 11.864 | 12.069 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | ||||||||||||||||||
check | - - | -.--- | - - | -.--- | O X | 8.899 | O X | 10.431 | O X | 4.694 | - - | -.--- | O X | 15.538 | O X | 4.880 | O X | 2.489 | O X | 30.787 | O X | 20.040 | O X | 9.316 | O X | 9.480 | - - | -.--- | - - | -.--- | - - | -.--- | - - | -.--- | - - | -.--- |
sql/test/mergetables | 1.959 | 1.919 | 2.255 | 2.363 | 0.988 | 0.990 | 2.479 | 1.787 | 0.729 | 3.244 | 1.676 | 2.242 | 2.131 | 2.129 | 5.485 | 4.250 | 4.727 | 5.226 | ||||||||||||||||||
singlekeyconstraint | O X | 0.052 | O X | 0.065 | O X | 0.070 | O X | 0.071 | O X | 0.031 | O X | 0.032 | O X | 0.096 | O X | 0.064 | O X | 0.025 | O X | 0.109 | O X | 0.061 | O X | 0.074 | O X | 0.085 | O X | 0.056 | O X | 0.219 | O X | 0.156 | O X | 0.156 | O X | 0.265 |
sql/test/miscellaneous | 3.687 | 3.475 | 4.422 | 4.557 | 1.913 | 1.939 | 3.434 | 4.019 | 1.706 | 5.197 | 2.544 | 4.597 | 4.285 | 4.320 | 6.469 | 5.923 | 7.129 | 6.880 | ||||||||||||||||||
simple_selects | O X | 0.225 | O X | 0.184 | O X | 0.253 | O X | 0.262 | O X | 0.092 | O X | 0.099 | O X | 0.232 | O X | 0.227 | O X | 0.068 | O X | 0.310 | O X | 0.128 | O X | 0.226 | O X | 0.173 | O X | 0.198 | O X | 0.375 | O X | 0.297 | O X | 0.468 | O X | 0.437 |
sql/test/sys-schema | 9.546 | 10.116 | 10.787 | 15.037 | 5.124 | 5.074 | 14.516 | 8.286 | 4.455 | 20.549 | 10.649 | 12.306 | 12.429 | 12.245 | 30.275 | 49.860 | 25.740 | 25.974 | ||||||||||||||||||
ValidateSystemCatalogTables | X O | 6.050 | X O | 6.279 | X O | 6.839 | X O | 9.213 | X O | 3.283 | X O | 3.248 | X O | 9.321 | X O | 5.228 | X O | 2.696 | X O | 12.904 | X O | 6.880 | X O | 7.590 | X O | 7.815 | X O | 7.706 | X O | 18.994 | X O | 32.406 | X O | 16.130 | X O | 16.723 |
sql/test/testdb-upgrade | 5.654 | 6.081 | 6.777 | 7.248 | 3.251 | 3.108 | 8.661 | 5.639 | 2.799 | 10.617 | 5.896 | 6.687 | 6.927 | 6.612 | 2.578 | 2.453 | 3.104 | 3.120 | ||||||||||||||||||
upgrade | O O | 2.301 | O O | 2.320 | O O | 2.699 | O O | 2.932 | O O | 1.364 | O O | 1.226 | O O | 3.881 | O O | 2.577 | O O | 1.318 | O O | 2.975 | O O | 1.466 | O O | 2.694 | O O | 2.757 | O O | 2.452 | O X | 2.578 | O X | 2.453 | O X | 3.104 | O X | 3.120 |
sql/test/testdb-upgrade-chain | 4.645 | 4.910 | 5.503 | 6.235 | 2.683 | 2.569 | 7.185 | 5.444 | 2.666 | 7.195 | 3.665 | 5.784 | 6.079 | 5.887 | 2.609 | 2.688 | 3.260 | 3.167 | ||||||||||||||||||
upgrade | O O | 2.400 | O O | 2.502 | O O | 2.835 | O O | 3.030 | O O | 1.397 | O O | 1.291 | O O | 4.130 | O O | 3.082 | O O | 1.384 | O O | 3.066 | O O | 1.543 | O O | 2.806 | O O | 2.912 | O O | 2.633 | O X | 2.609 | O X | 2.688 | O X | 3.260 | O X | 3.167 |
total | 608.822 | 706.864 | 782.461 | 1239.199 | 372.673 | 348.089 | 1178.843 | 711.132 | 395.217 | 1308.245 | 603.578 | 893.903 | 917.273 | 863.403 | 1441.112 | 1927.907 | 1334.582 | 1365.595 | ||||||||||||||||||
79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) | 79411 (default) |