6
0
mirror of https://github.com/FirebirdSQL/firebird-qa.git synced 2025-01-22 13:33:07 +01:00
firebird-qa/tests/functional/arno/optimizer
2024-11-17 13:51:40 +03:00
..
__init__.py Firebird engine tests 2021-04-26 20:07:00 +02:00
test_opt_aggregate_distribution_01.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_aggregate_distribution_02.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_aggregate_distribution_03.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_aggregate_distribution_04.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_aggregate_distribution_05.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_aggregate_distribution_06.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_aggregate_distribution_07.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_aggregate_distribution_08.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_aggregate_distribution_09.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_aggregate_distribution_10.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_aggregate_distribution_11.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_aggregate_distribution_12.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_aggregate_distribution_13.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_aggregate_distribution_14.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_avoid_index_usage.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_full_join_01.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_full_join_02.py 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
test_opt_full_join_03.py 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
test_opt_full_join_04.py 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
test_opt_inner_join_01.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_inner_join_02.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_inner_join_03.py 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
test_opt_inner_join_04.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_inner_join_05.py 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
test_opt_inner_join_06.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_inner_join_07.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_inner_join_08.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_inner_join_09.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_inner_join_10.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_inner_join_merge_01.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_inner_join_merge_02.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_inner_join_merge_03.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_inner_join_merge_04.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_inner_join_merge_05.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_inner_join_merge_06.py 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
test_opt_left_join_01.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_left_join_02.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_left_join_03.py 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
test_opt_left_join_04.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_left_join_05.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_left_join_06.py 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
test_opt_left_join_07.py 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
test_opt_left_join_08.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_left_join_09.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_left_join_10.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_left_join_11.py 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
test_opt_left_join_12.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_left_join_13.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_mixed_joins_01.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_mixed_joins_02.py 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
test_opt_mixed_joins_03.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_mixed_joins_04.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_mixed_joins_05.py 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
test_opt_mixed_joins_06.py 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
test_opt_multi_index_selection_01.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_multi_index_selection_02.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_multi_index_selection_03.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_multi_index_selection_04.py Fixed a few ambiguous tests 2022-02-10 12:12:49 +03:00
test_opt_multi_index_selection_05.py Fixed a few ambiguous tests 2022-02-10 12:12:49 +03:00
test_opt_multi_index_selection_06.py 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
test_opt_multi_index_selection_07.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_multi_index_selection_08.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_selectivity_01.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_selectivity_02.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_selectivity_03.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_single_index_selection_01.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_single_index_selection_02.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_single_index_selection_03.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_single_index_selection_04.py Add a test tests/functional/arno/optimizer/test_opt_single_index_selection_04.py from fbtest. 2023-03-09 10:25:37 +03:00
test_opt_single_index_selection_05.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_single_index_selection_06.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_single_index_selection_07.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_single_index_selection_08.py Fixed a few ambiguous tests 2022-02-10 12:12:49 +03:00
test_opt_single_index_selection_09.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_single_index_selection_10.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_single_index_selection_11.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_sort_by_index_01.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_sort_by_index_02.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_sort_by_index_03.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_sort_by_index_04.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_sort_by_index_05.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_sort_by_index_06.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_sort_by_index_07.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_sort_by_index_08.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_sort_by_index_09.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_sort_by_index_10.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_sort_by_index_11.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_sort_by_index_12.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_sort_by_index_13.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_sort_by_index_14.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_sort_by_index_15.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_sort_by_index_16.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_sort_by_index_17.py New metadata + cleanup 2022-02-04 19:05:19 +01:00
test_opt_sort_by_index_18.py 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
test_opt_sort_by_index_19.py New metadata + cleanup 2022-02-04 19:05:19 +01:00