6
0
mirror of https://github.com/FirebirdSQL/firebird-qa.git synced 2025-01-22 21:43:06 +01:00
Commit Graph

36 Commits

Author SHA1 Message Date
pavel-zotov
5709c6696c Added/Updated tests\functional\arno\optimizer\test_opt_sort_by_index_18.py: 'OPTIMIZE FOR FIRST ROWS' is used for 6.x - suggesed by dimitr, letter 16.11.2024 15:15. Checked on 6.0.0.532; 5.0.2.1567 2024-11-17 13:51:40 +03:00
pavel-zotov
aabe3479b7 Added/Updated tests\functional\arno\optimizer\test_opt_sort_by_index_18.py: re-implemented after #26e64e9c: Cost-based decision between ORDER and SORT plans (#8316). Checked on 6.0.0.532; 5.0.2.1567; 4.0.6.3168; 3.0.13.33794. 2024-11-17 12:55:43 +03:00
pavel-zotov
920dd0fc36 Added/Updated tests\functional\arno\optimizer\test_opt_inner_join_05.py: changed comment about explained plan in 6.x 2024-10-31 15:48:16 +03:00
pavel-zotov
a8d5d389f7 Added/Updated tests\functional\arno\optimizer\test_opt_inner_join_05.py: Adjusted expected_out discuss with dimitr. Explained plans for 5.x and 6.x are now identical. Checked on 3.0.13.33794, 4.0.6.3165, 5.0.2.1551, 6.0.0.515 2024-10-31 11:19:40 +03:00
pavel-zotov
b57a88bd18 Added/Updated tests\functional\arno\optimizer\test_opt_inner_join_05.py: Splitted expected_out : added separate block for FB 5.x after discuss with dimitr. 2024-10-30 11:48:01 +03:00
pavel-zotov
9d34fda531 Added/Updated tests\functional\arno\optimizer\test_opt_inner_join_05.py: Changed substitutions: one need to suppress '(keys: N, total key length: M)' in FB 6.x after commit c50b0aa6 ('Add key info to the hash join plan output'). 2024-09-24 00:01:37 +03:00
pavel-zotov
e08a65108a Added/Updated tests\functional\arno\optimizer\test_opt_inner_join_03.py: Adjusted expected plan for FB 3.x after #8030 (discussed with dimitr). 2024-03-15 12:22:37 +03:00
pavel-zotov
56b765306e Added/Updated tests\functional\arno\optimizer\test_opt_inner_join_05.py: adjusted expected output according to recent FB 5.x and 6.x versions. Re-implemented: check explained plan instead of legacy one. Data not shown. See notes. 2023-12-15 14:31:56 +03:00
pavel-zotov
cae18186f8 Added/Updated tests\functional\arno\optimizer\test_opt_full_join_04.py: Adjusted plan to actual for FB 5.x after letter from dimitr. 2023-08-01 02:02:56 +03:00
pavel-zotov
9bf25ac8e6 Added/Updated tests\functional\arno\optimizer\test_opt_left_join_11.py: excluded from execution under FB 5.x: no more sense in it for this FB version. Discussed with dimitr, letter 30.07.2023 2023-07-31 00:16:39 +03:00
pavel-zotov
451f4d9ef1 Added/Updated tests\functional\arno\optimizer\test_opt_left_join_07.py: excluded from execution under FB 5.x: no more sense in it for this FB version. Discussed with dimitr, letter 30.07.2023 2023-07-31 00:15:38 +03:00
pavel-zotov
f524c3d410 Added/Updated tests\functional\arno\optimizer\test_opt_left_join_06.py: excluded from execution under FB 5.x: no more sense in it for this FB version. Discussed with dimitr, letter 30.07.2023 2023-07-31 00:14:33 +03:00
pavel-zotov
c6705b92c1 Added/Updated tests\functional\arno\optimizer\test_opt_left_join_03.py: excluded from execution under FB 5.x: no more sense in it for this FB version. Discussed with dimitr, letter 30.07.2023 2023-07-31 00:13:09 +03:00
pavel-zotov
16d07d6101 Added/Updated tests\functional\arno\optimizer\test_opt_multi_index_selection_06.py: -m Adjusted allowed versions: FB 3.x and 4.x issue same execution plan. Plan in FB 5.x differs. Version 5.x is not checked currently. Wait for resolution. 2023-03-09 14:10:06 +03:00
Anton Zuev
68492ca2a0 Restrict a version of the test tests/functional/arno/optimizer/test_opt_multi_index_selection_06.py to 3.0. 2023-03-09 10:38:13 +03:00
Anton Zuev
07b7af8652 Add a test tests/functional/arno/optimizer/test_opt_single_index_selection_04.py from fbtest. 2023-03-09 10:25:37 +03:00
Anton Zuev
841cdcb554 Add a test tests/functional/arno/optimizer/test_opt_multi_index_selection_06.py from fbtest. 2023-03-09 10:19:29 +03:00
pavel-zotov
67ff49b951 Added/Updated tests\functional\arno\optimizer\test_opt_full_join_03.py: Replaced WHERE-expr: added coalesce() after discussion with dimitr. Checked on 3.0.11.33665, 4.0.3.2904, 5.0.0.970 2023-03-07 17:19:59 +03:00
pavel-zotov
796854a2f6 Added/Updated tests\functional\arno\optimizer\test_opt_full_join_02.py: Replaced WHERE-expr: added coalesce() after discussion with dimitr. Checked on 3.0.11.33665, 4.0.3.2904, 5.0.0.970 2023-03-07 17:16:17 +03:00
zotov
0e933ea00b Engine version should be compared with tested value via Action.is_version() rather than excessive connect to services and obtaining it from srv.info. Changed code after suggestion by pcisar. 2022-04-08 14:16:01 +03:00
zotov
452005b356 Added/Updated functional\arno\optimizer\test_opt_mixed_joins_06.py: Expected stdout depends now on major FB version because of changes since 5.0.0.455: data source with greatest cardinality will be specified at left-most position in the plan when HASH JOIN is choosen. See details in NOTES to this test. 2022-04-08 10:00:29 +03:00
zotov
410c403fa3 Added NOTES section. 2022-04-08 09:56:23 +03:00
zotov
0a457d5f74 Added/Updated functional\arno\optimizer\test_opt_mixed_joins_05.py: Expected stdout depends now on major FB version because of changes since 5.0.0.455: data source with greatest cardinality will be specified at left-most position in the plan when HASH JOIN is choosen. See details in NOTES to this test. 2022-04-08 09:55:35 +03:00
zotov
2bc4b4e3ad Added/Updated functional\arno\optimizer\test_opt_mixed_joins_02.py: Expected stdout depends now on major FB version because of changes since 5.0.0.455 in PLAN HASH when data sources have the same cardinality. 2022-04-08 09:45:42 +03:00
zotov
ec71edd3f0 Added/Updated functional\arno\optimizer\test_opt_inner_join_merge_06.py: Expected stdout depends now on major FB version because of changes since 5.0.0.455 in PLAN HASH when data sources have the same cardinality. 2022-04-08 09:41:53 +03:00
Dmitry Yemanov
3655598c1a Fixed a few ambiguous tests 2022-02-10 12:12:49 +03:00
9a10f3468e Corrections for FB 4.0.1 2022-02-07 18:03:19 +01:00
91781e9231 New metadata + cleanup 2022-02-04 19:05:19 +01:00
cb52f90685 New metadata + cleanup 2022-01-28 18:56:36 +01:00
c282bd46fc Fix test 2022-01-16 12:38:16 +01:00
c8af46bc79 refactoring, python tests, added missing test from fbt 2021-12-22 20:25:10 +01:00
b458cecb1e Fixes for FB 4 2021-11-09 11:01:26 +01:00
59fcb66ce0 Changes in plugin + some tests fixed 2021-08-03 23:29:08 +02:00
9ec943fc6d Change name scheme for tests 2021-04-28 12:52:50 +02:00
a4111205c3 Change name scheme for tests 2021-04-28 12:42:11 +02:00
7a9962e6bf Firebird engine tests 2021-04-26 20:07:00 +02:00