2 @message |
assert
- PLAN HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL)
+ PLAN HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL)
- PLAN HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL, DATASOURCE_C TK NATURAL)
+ PLAN HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL, "DATASOURCE_C" "PUBLIC"."TK" NATURAL)
- PLAN HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL, DATASOURCE_C TK NATURAL, DATASOURCE_D TK NATURAL)
+ PLAN HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL, "DATASOURCE_C" "PUBLIC"."TK" NATURAL, "DATASOURCE_D" "PUBLIC"."TK" NATURAL)
- PLAN HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL)
+ PLAN HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL)
- PLAN HASH (HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL), DATASOURCE_C TK NATURAL)
+ PLAN HASH (HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL), "DATASOURCE_C" "PUBLIC"."TK" NATURAL)
- PLAN HASH (HASH (HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL), DATASOURCE_C TK NATURAL), DATASOURCE_D TK NATURAL)
+ PLAN HASH (HASH (HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL), "DATASOURCE_C" "PUBLIC"."TK" NATURAL), "DATASOURCE_D" "PUBLIC"."TK" NATURAL)
- PLAN HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL)
+ PLAN HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL)
- PLAN HASH (HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL), DATASOURCE_C TK NATURAL)
+ PLAN HASH (HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL), "DATASOURCE_C" "PUBLIC"."TK" NATURAL)
- PLAN HASH (HASH (HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL), DATASOURCE_C TK NATURAL), DATASOURCE_D TK NATURAL)
+ PLAN HASH (HASH (HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL), "DATASOURCE_C" "PUBLIC"."TK" NATURAL), "DATASOURCE_D" "PUBLIC"."TK" NATURAL)
- PLAN HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL)
+ PLAN HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL)
- PLAN HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL, DATASOURCE_C TF NATURAL)
+ PLAN HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL, "DATASOURCE_C" "PUBLIC"."TF" NATURAL)
- PLAN HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL, DATASOURCE_C TF NATURAL, DATASOURCE_D TF NATURAL)
+ PLAN HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL, "DATASOURCE_C" "PUBLIC"."TF" NATURAL, "DATASOURCE_D" "PUBLIC"."TF" NATURAL)
- PLAN HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL)
+ PLAN HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL)
- PLAN HASH (HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL), DATASOURCE_C TF NATURAL)
+ PLAN HASH (HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL), "DATASOURCE_C" "PUBLIC"."TF" NATURAL)
- PLAN HASH (HASH (HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL), DATASOURCE_C TF NATURAL), DATASOURCE_D TF NATURAL)
+ PLAN HASH (HASH (HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL), "DATASOURCE_C" "PUBLIC"."TF" NATURAL), "DATASOURCE_D" "PUBLIC"."TF" NATURAL)
- PLAN HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL)
+ PLAN HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL)
- PLAN HASH (HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL), DATASOURCE_C TF NATURAL)
+ PLAN HASH (HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL), "DATASOURCE_C" "PUBLIC"."TF" NATURAL)
- PLAN HASH (HASH (HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL), DATASOURCE_C TF NATURAL), DATASOURCE_D TF NATURAL)
+ PLAN HASH (HASH (HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL), "DATASOURCE_C" "PUBLIC"."TF" NATURAL), "DATASOURCE_D" "PUBLIC"."TF" NATURAL)
LOG DETAILS:
2025-06-27 05:15:24.900
2025-06-27 05:15:24.907 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-27 05:15:24.917
2025-06-27 05:15:24.926 @pytest.mark.version('>=3.0')
2025-06-27 05:15:24.934 def test_1(act: Action):
2025-06-27 05:15:24.945 act.expected_stdout = fb3x_checked_stdout if act.is_version('<4') else fb4x_checked_stdout if act.is_version('<5') else fb5x_checked_stdout
2025-06-27 05:15:24.955 act.execute(combine_output = True)
2025-06-27 05:15:24.967 > assert act.clean_stdout == act.clean_expected_stdout
2025-06-27 05:15:24.977 E assert
2025-06-27 05:15:24.989 E - PLAN HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL)
2025-06-27 05:15:25.006 E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL)
2025-06-27 05:15:25.019 E - PLAN HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL, DATASOURCE_C TK NATURAL)
2025-06-27 05:15:25.036 E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL, "DATASOURCE_C" "PUBLIC"."TK" NATURAL)
2025-06-27 05:15:25.060 E - PLAN HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL, DATASOURCE_C TK NATURAL, DATASOURCE_D TK NATURAL)
2025-06-27 05:15:25.076 E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL, "DATASOURCE_C" "PUBLIC"."TK" NATURAL, "DATASOURCE_D" "PUBLIC"."TK" NATURAL)
2025-06-27 05:15:25.090 E - PLAN HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL)
2025-06-27 05:15:25.102 E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL)
2025-06-27 05:15:25.115 E - PLAN HASH (HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL), DATASOURCE_C TK NATURAL)
2025-06-27 05:15:25.136 E + PLAN HASH (HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL), "DATASOURCE_C" "PUBLIC"."TK" NATURAL)
2025-06-27 05:15:25.149 E - PLAN HASH (HASH (HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL), DATASOURCE_C TK NATURAL), DATASOURCE_D TK NATURAL)
2025-06-27 05:15:25.160 E + PLAN HASH (HASH (HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL), "DATASOURCE_C" "PUBLIC"."TK" NATURAL), "DATASOURCE_D" "PUBLIC"."TK" NATURAL)
2025-06-27 05:15:25.169 E - PLAN HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL)
2025-06-27 05:15:25.179 E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL)
2025-06-27 05:15:25.188 E - PLAN HASH (HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL), DATASOURCE_C TK NATURAL)
2025-06-27 05:15:25.198 E + PLAN HASH (HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL), "DATASOURCE_C" "PUBLIC"."TK" NATURAL)
2025-06-27 05:15:25.210 E - PLAN HASH (HASH (HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL), DATASOURCE_C TK NATURAL), DATASOURCE_D TK NATURAL)
2025-06-27 05:15:25.223 E + PLAN HASH (HASH (HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL), "DATASOURCE_C" "PUBLIC"."TK" NATURAL), "DATASOURCE_D" "PUBLIC"."TK" NATURAL)
2025-06-27 05:15:25.235 E - PLAN HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL)
2025-06-27 05:15:25.251 E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL)
2025-06-27 05:15:25.273 E - PLAN HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL, DATASOURCE_C TF NATURAL)
2025-06-27 05:15:25.294 E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL, "DATASOURCE_C" "PUBLIC"."TF" NATURAL)
2025-06-27 05:15:25.308 E - PLAN HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL, DATASOURCE_C TF NATURAL, DATASOURCE_D TF NATURAL)
2025-06-27 05:15:25.319 E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL, "DATASOURCE_C" "PUBLIC"."TF" NATURAL, "DATASOURCE_D" "PUBLIC"."TF" NATURAL)
2025-06-27 05:15:25.332 E - PLAN HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL)
2025-06-27 05:15:25.347 E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL)
2025-06-27 05:15:25.364 E - PLAN HASH (HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL), DATASOURCE_C TF NATURAL)
2025-06-27 05:15:25.379 E + PLAN HASH (HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL), "DATASOURCE_C" "PUBLIC"."TF" NATURAL)
2025-06-27 05:15:25.392 E - PLAN HASH (HASH (HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL), DATASOURCE_C TF NATURAL), DATASOURCE_D TF NATURAL)
2025-06-27 05:15:25.404 E + PLAN HASH (HASH (HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL), "DATASOURCE_C" "PUBLIC"."TF" NATURAL), "DATASOURCE_D" "PUBLIC"."TF" NATURAL)
2025-06-27 05:15:25.413 E - PLAN HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL)
2025-06-27 05:15:25.425 E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL)
2025-06-27 05:15:25.437 E - PLAN HASH (HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL), DATASOURCE_C TF NATURAL)
2025-06-27 05:15:25.459 E + PLAN HASH (HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL), "DATASOURCE_C" "PUBLIC"."TF" NATURAL)
2025-06-27 05:15:25.474 E - PLAN HASH (HASH (HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL), DATASOURCE_C TF NATURAL), DATASOURCE_D TF NATURAL)
2025-06-27 05:15:25.492 E + PLAN HASH (HASH (HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL), "DATASOURCE_C" "PUBLIC"."TF" NATURAL), "DATASOURCE_D" "PUBLIC"."TF" NATURAL)
2025-06-27 05:15:25.506
2025-06-27 05:15:25.512 tests/bugs/core_4809_test.py:234: AssertionError
2025-06-27 05:15:25.518 ---------------------------- Captured stdout setup -----------------------------
2025-06-27 05:15:25.525 Creating db: localhost:/var/tmp/qa_2024/test_1949/test.fdb [page_size=None, sql_dialect=None, charset='NONE', user=SYSDBA, password=masterkey]
|
3 #text |
act = <firebird.qa.plugin.Action pytest object at [hex]>
@pytest.mark.version('>=3.0')
def test_1(act: Action):
act.expected_stdout = fb3x_checked_stdout if act.is_version('<4') else fb4x_checked_stdout if act.is_version('<5') else fb5x_checked_stdout
act.execute(combine_output = True)
> assert act.clean_stdout == act.clean_expected_stdout
E assert
E - PLAN HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL)
E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL)
E - PLAN HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL, DATASOURCE_C TK NATURAL)
E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL, "DATASOURCE_C" "PUBLIC"."TK" NATURAL)
E - PLAN HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL, DATASOURCE_C TK NATURAL, DATASOURCE_D TK NATURAL)
E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL, "DATASOURCE_C" "PUBLIC"."TK" NATURAL, "DATASOURCE_D" "PUBLIC"."TK" NATURAL)
E - PLAN HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL)
E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL)
E - PLAN HASH (HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL), DATASOURCE_C TK NATURAL)
E + PLAN HASH (HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL), "DATASOURCE_C" "PUBLIC"."TK" NATURAL)
E - PLAN HASH (HASH (HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL), DATASOURCE_C TK NATURAL), DATASOURCE_D TK NATURAL)
E + PLAN HASH (HASH (HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL), "DATASOURCE_C" "PUBLIC"."TK" NATURAL), "DATASOURCE_D" "PUBLIC"."TK" NATURAL)
E - PLAN HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL)
E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL)
E - PLAN HASH (HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL), DATASOURCE_C TK NATURAL)
E + PLAN HASH (HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL), "DATASOURCE_C" "PUBLIC"."TK" NATURAL)
E - PLAN HASH (HASH (HASH (DATASOURCE_A TK NATURAL, DATASOURCE_B TK NATURAL), DATASOURCE_C TK NATURAL), DATASOURCE_D TK NATURAL)
E + PLAN HASH (HASH (HASH ("DATASOURCE_A" "PUBLIC"."TK" NATURAL, "DATASOURCE_B" "PUBLIC"."TK" NATURAL), "DATASOURCE_C" "PUBLIC"."TK" NATURAL), "DATASOURCE_D" "PUBLIC"."TK" NATURAL)
E - PLAN HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL)
E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL)
E - PLAN HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL, DATASOURCE_C TF NATURAL)
E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL, "DATASOURCE_C" "PUBLIC"."TF" NATURAL)
E - PLAN HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL, DATASOURCE_C TF NATURAL, DATASOURCE_D TF NATURAL)
E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL, "DATASOURCE_C" "PUBLIC"."TF" NATURAL, "DATASOURCE_D" "PUBLIC"."TF" NATURAL)
E - PLAN HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL)
E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL)
E - PLAN HASH (HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL), DATASOURCE_C TF NATURAL)
E + PLAN HASH (HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL), "DATASOURCE_C" "PUBLIC"."TF" NATURAL)
E - PLAN HASH (HASH (HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL), DATASOURCE_C TF NATURAL), DATASOURCE_D TF NATURAL)
E + PLAN HASH (HASH (HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL), "DATASOURCE_C" "PUBLIC"."TF" NATURAL), "DATASOURCE_D" "PUBLIC"."TF" NATURAL)
E - PLAN HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL)
E + PLAN HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL)
E - PLAN HASH (HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL), DATASOURCE_C TF NATURAL)
E + PLAN HASH (HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL), "DATASOURCE_C" "PUBLIC"."TF" NATURAL)
E - PLAN HASH (HASH (HASH (DATASOURCE_A TF NATURAL, DATASOURCE_B TF NATURAL), DATASOURCE_C TF NATURAL), DATASOURCE_D TF NATURAL)
E + PLAN HASH (HASH (HASH ("DATASOURCE_A" "PUBLIC"."TF" NATURAL, "DATASOURCE_B" "PUBLIC"."TF" NATURAL), "DATASOURCE_C" "PUBLIC"."TF" NATURAL), "DATASOURCE_D" "PUBLIC"."TF" NATURAL)
tests/bugs/core_4809_test.py:234: AssertionError
|