| bugs.core_0203_test | CREATE VIEW ignores PLAN |
| bugs.core_1549_test | Subquery-based predicates are not evaluated early in the join order |
| bugs.core_2264_test | ALTER DOMAIN with dependencies may leave a transaction handle in inconsistent state causing segmentation faults |
| bugs.core_2650_test | Improve sorting performance when long VARCHARs are involved |
| bugs.core_3076_test | Better performance for (table.field = :param OR :param = -1) in where clause |
| bugs.core_3450_test | Inefficient optimization (regression) |
| bugs.core_4165_test | Replace the hierarchical union execution with the plain one |
| bugs.core_4285_test | Choose the best matching index for navigation |
| bugs.core_4318_test | Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation |
| bugs.core_4921_test | Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans |
| bugs.core_5020_test | Regression: ORDER BY clause on compound index may disable usage of other indices |
| bugs.core_5070_test | Compound index cannot be used for filtering in some ORDER/GROUP BY queries |
| bugs.core_5236_test | IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins |
| bugs.core_6278_test | Efficient table scans for DBKEY-based range conditions |
| bugs.gh_4314_test | Sub-optimal predicate checking while selecting from a view [CORE3981] |
| bugs.gh_4954_test | subselect losing the index when where clause includes coalesce() [CORE4640] |
| bugs.gh_6802_test | When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired |
| bugs.gh_7137_test | Optimizer regression: bad plan (HASH instead of JOIN) is chosen for some inner joins |
| bugs.gh_7398_test | Worst plan sort created to execute an indexed tables |
| bugs.gh_8161_test | Cardinality estimation should use primary record versions only |
| bugs.gh_8488_test | MIN/MAX aggregates may badly affect the join order in queries with mixed INNER/LEFT joins |
| bugs.gh_8821_test | REGRESSION: natural plan instead of primary/unique index |
| functional.arno.optimizer.test_opt_aggregate_distribution_01 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_02 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_03 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_04 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_05 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_06 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_07 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_08 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_09 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_10 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_11 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_12 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_13 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_aggregate_distribution_14 | Try to deliver HAVING CLAUSE conjunctions to the WHERE clause |
| functional.arno.optimizer.test_opt_full_join_01 | FULL OUTER JOIN, list all values |
| functional.arno.optimizer.test_opt_full_join_02 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
| functional.arno.optimizer.test_opt_full_join_03 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
| functional.arno.optimizer.test_opt_full_join_04 | FULL OUTER JOIN, list all values, but filtered in WHERE clause |
| functional.arno.optimizer.test_opt_inner_join_01 | INNER JOIN join order |
| functional.arno.optimizer.test_opt_inner_join_02 | INNER JOIN join order |
| functional.arno.optimizer.test_opt_inner_join_03 | INNER JOIN join order |
| functional.arno.optimizer.test_opt_inner_join_04 | INNER JOIN join order LIKE and IS NULL |
| functional.arno.optimizer.test_opt_inner_join_05 | INNER JOIN join order LIKE and STARTING WITH |
| functional.arno.optimizer.test_opt_inner_join_06 | INNER JOIN join order and VIEW |
| functional.arno.optimizer.test_opt_inner_join_07 | INNER JOIN join order and VIEW |
| functional.arno.optimizer.test_opt_inner_join_08 | INNER JOIN join order and VIEW |
| functional.arno.optimizer.test_opt_inner_join_09 | INNER JOIN join order and distribution |
| functional.arno.optimizer.test_opt_inner_join_10 | INNER JOIN join order |
| functional.arno.optimizer.test_opt_inner_join_merge_01 | INNER JOIN join merge |
| functional.arno.optimizer.test_opt_inner_join_merge_02 | INNER JOIN join merge |
| functional.arno.optimizer.test_opt_inner_join_merge_03 | INNER JOIN join merge |
| functional.arno.optimizer.test_opt_inner_join_merge_04 | INNER JOIN join merge and NULLs |
| functional.arno.optimizer.test_opt_inner_join_merge_05 | INNER JOIN join merge and VIEWs |
| functional.arno.optimizer.test_opt_inner_join_merge_06 | INNER JOIN join merge and SP |
| functional.arno.optimizer.test_opt_left_join_01 | LEFT OUTER JOIN with no match at all |
| functional.arno.optimizer.test_opt_left_join_02 | LEFT OUTER JOIN with no match and IS NULL in WHERE clause |
| functional.arno.optimizer.test_opt_left_join_03 | LEFT OUTER JOIN with full match and reference in WHERE clause |
| functional.arno.optimizer.test_opt_left_join_04 | LEFT OUTER JOIN with full match |
| functional.arno.optimizer.test_opt_left_join_05 | LEFT OUTER JOIN with full match, but limited in ON clause |
| functional.arno.optimizer.test_opt_left_join_08 | LEFT OUTER JOIN with full match, but limited in ON and WHERE clause |
| functional.arno.optimizer.test_opt_left_join_09 | LEFT OUTER JOIN with full match, but limited in ON and WHERE clause |
| functional.arno.optimizer.test_opt_left_join_10 | LEFT OUTER JOIN with IS NULL burried in WHERE clause |
| functional.arno.optimizer.test_opt_left_join_12 | LEFT OUTER JOIN with distribution CASE |
| functional.arno.optimizer.test_opt_left_join_13 | LEFT OUTER JOIN VIEW with full match |
| functional.arno.optimizer.test_opt_mixed_joins_01 | Mixed JOINS |
| functional.arno.optimizer.test_opt_mixed_joins_02 | Mixed JOINS |
| functional.arno.optimizer.test_opt_mixed_joins_03 | Mixed JOINS |
| functional.arno.optimizer.test_opt_mixed_joins_04 | Mixed JOINS |
| functional.arno.optimizer.test_opt_mixed_joins_05 | Mixed JOINS |
| functional.arno.optimizer.test_opt_mixed_joins_06 | Mixed JOINS |
| functional.arno.optimizer.test_opt_multi_index_selection_01 | Unique index selection (multi segment) |
| functional.arno.optimizer.test_opt_multi_index_selection_02 | Best match index selection (multi segment) |
| functional.arno.optimizer.test_opt_multi_index_selection_03 | Best match index selection (multi segment) |
| functional.arno.optimizer.test_opt_multi_index_selection_04 | Best match index selection (multi segment) |
| functional.arno.optimizer.test_opt_multi_index_selection_05 | Best match index selection (multi segment) |
| functional.arno.optimizer.test_opt_multi_index_selection_06 | Best match index selection (multi segment) |
| functional.arno.optimizer.test_opt_multi_index_selection_07 | Best match index selection (multi segment) |
| functional.arno.optimizer.test_opt_multi_index_selection_08 | Best match index selection (multi segment) |
| functional.arno.optimizer.test_opt_single_index_selection_01 | Unique index selection (single segment) |
| functional.arno.optimizer.test_opt_single_index_selection_02 | Best match index selection (single segment) |
| functional.arno.optimizer.test_opt_single_index_selection_03 | Best match index selection (single segment) |
| functional.arno.optimizer.test_opt_single_index_selection_04 | Best match index selection (single segment) |
| functional.arno.optimizer.test_opt_single_index_selection_05 | Best match index selection (single segment) ASC and DESC |
| functional.arno.optimizer.test_opt_single_index_selection_06 | Best match index selection (single segment) |
| functional.arno.optimizer.test_opt_single_index_selection_07 | Best match index selection (single segment) |
| functional.arno.optimizer.test_opt_single_index_selection_08 | Best match index selection (single segment) |
| functional.arno.optimizer.test_opt_single_index_selection_09 | Best match index selection (single segment) OR |
| functional.arno.optimizer.test_opt_single_index_selection_10 | Best match index selection (single segment) OR |
| functional.arno.optimizer.test_opt_single_index_selection_11 | Best match index selection (single segment) |
| functional.arno.optimizer.test_opt_sort_by_index_01 | ORDER BY ASC using index (unique) |
| functional.arno.optimizer.test_opt_sort_by_index_02 | ORDER BY DESC using index (unique) |
| functional.arno.optimizer.test_opt_sort_by_index_03 | ORDER BY ASC using index (non-unique) |
| functional.arno.optimizer.test_opt_sort_by_index_04 | ORDER BY DESC using index (non-unique) |
| functional.arno.optimizer.test_opt_sort_by_index_05 | MAX() and DESC index (non-unique) |
| functional.arno.optimizer.test_opt_sort_by_index_06 | MAX() and ASC index (non-unique) |
| functional.arno.optimizer.test_opt_sort_by_index_07 | MIN() and ASC index (non-unique) |
| functional.arno.optimizer.test_opt_sort_by_index_08 | MIN() and DESC index (non-unique) |
| functional.arno.optimizer.test_opt_sort_by_index_09 | ORDER BY ASC using index (non-unique) |
| functional.arno.optimizer.test_opt_sort_by_index_10 | ORDER BY ASC using index (multi) |
| functional.arno.optimizer.test_opt_sort_by_index_11 | ORDER BY ASC using index (multi) |
| functional.arno.optimizer.test_opt_sort_by_index_12 | ORDER BY ASC, DESC using index (multi) |
| functional.arno.optimizer.test_opt_sort_by_index_13 | ORDER BY ASC using index (multi) |
| functional.arno.optimizer.test_opt_sort_by_index_14 | ORDER BY ASC NULLS FIRST using index |
| functional.arno.optimizer.test_opt_sort_by_index_15 | ORDER BY ASC NULLS LAST using index |
| functional.arno.optimizer.test_opt_sort_by_index_16 | ORDER BY DESC NULLS FIRST using index |
| functional.arno.optimizer.test_opt_sort_by_index_17 | ORDER BY DESC NULLS LAST using index |
| functional.arno.optimizer.test_opt_sort_by_index_18 | ORDER BY ASC using index (single) and WHERE clause |
| functional.arno.optimizer.test_opt_sort_by_index_19 | ORDER BY ASC using index (multi) and WHERE clause |