[IMPALA-9311] test_show_create_table failed with primary key mismatch

• Type: Test
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 3.4.0
• Fix Version/s: Impala 3.4.0
• Labels: broken-build
• Epic Color: ghx-label-10
• Assignee: Anurag Mantripragada
• Reporter: Xiaomeng Zhang
• Created: 22/Jan/20 00:10
• Updated: 29/Jan/20 00:00
• Resolved: 29/Jan/20 00:00

Description

Error Messagemetadata/test_show_create_table.py:62: in test_show_create_table     unique_database) metadata/test_show_create_table.py:110: in __run_show_create_table_test_case     self.__compare_result(expected_result, create_table_result) metadata/test_show_create_table.py:146: in __compare_result     assert expected_sql_filtered == actual_sql_filtered E   assert "CREATE EXTER...parent_table'" == "CREATE EXTERN...parent_table'" E     Skipping 71 identical leading characters in diff, use -v to show E     Skipping 126 identical trailing characters in diff, use -v to show E     - MARY KEY (year, id)) ROW FO E     ?               ---- E     + MARY KEY (id, year)) ROW FO E     ?           ++++Stacktracemetadata/test_show_create_table.py:62: in test_show_create_table
    unique_database)
metadata/test_show_create_table.py:110: in __run_show_create_table_test_case
    self.__compare_result(expected_result, create_table_result)
metadata/test_show_create_table.py:146: in __compare_result
    assert expected_sql_filtered == actual_sql_filtered
E   assert "CREATE EXTER...parent_table'" == "CREATE EXTERN...parent_table'"
E     Skipping 71 identical leading characters in diff, use -v to show
E     Skipping 126 identical trailing characters in diff, use -v to show
E     - MARY KEY (year, id)) ROW FO
E     ?               ----
E     + MARY KEY (id, year)) ROW FO
E     ?           ++++

I think this is due to commit https://github.com/apache/impala/commit/cfe60858da110cf1256bd3aa5d4f8d374578a33d