bugs.core_4809_test HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses and join is based on DBKEY concatenations UTC 2025.06.30 16:17 pavel-zotov Added/Updated tests\bugs\core_4809_test.py: Separated expected output for FB major versions prior/since 6.x. Checked on 6.0.0.881; 5.0.3.1668; 4.0.6.3214; 3.0.13.33813. https://github.com/FirebirdSQL/firebird-qa/commit/e0ca9a5397f1866ec68685556426aae871761081 ---------------------------------------- UTC 2023.07.31 11:02 pavel-zotov Added/Updated tests\bugs\core_4809_test.py: Adjusted expected execution plans for FB 5.x. Explained by dimitr, letter 31-JUL-2023 11:00, see notes. https://github.com/FirebirdSQL/firebird-qa/commit/317e4a06bace3e9598a3b910a8d2889cc5fc60a2 ---------------------------------------- UTC 2023.03.04 18:26 pavel-zotov Updated C:\FBTESTING\qa\firebird-qa\tests\bugs\core_4809_test.py: adjust expected stdout/stderr to current FB version. https://github.com/FirebirdSQL/firebird-qa/commit/5ae25e01792ee8552630a2bf2f38e0cfa6ce9a67 ---------------------------------------- UTC 2022.04.08 11:16 zotov 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. https://github.com/FirebirdSQL/firebird-qa/commit/0e933ea00b436a077addad5764e567a3c088b992 ---------------------------------------- UTC 2022.04.07 18:21 zotov Added/Updated bugs\core_4809_test.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. https://github.com/FirebirdSQL/firebird-qa/commit/75905ca8d4e6451f761015f886dd0f63af60bccc ---------------------------------------- UTC 2022.02.02 14:46 pcisar New metadata (missing FBTEST ID) + cleanup https://github.com/FirebirdSQL/firebird-qa/commit/924743b4dc587676d0b7850716b9909d225d9564 ---------------------------------------- UTC 2022.01.24 19:27 pcisar New metadata + cleanup https://github.com/FirebirdSQL/firebird-qa/commit/dc224afdf407ac08dbf3cd894d36b35e98b2158d ---------------------------------------- UTC 2021.12.22 19:23 pcisar refactoring and other changes https://github.com/FirebirdSQL/firebird-qa/commit/62202b87c78ecbebf1e64b54dec883e6fb3f14d5 ---------------------------------------- UTC 2021.04.28 10:42 pcisar Change name scheme for tests https://github.com/FirebirdSQL/firebird-qa/commit/a4111205c3e26fb684f5c2fbd511731c93301783