This is an automated email from the ASF dual-hosted git repository. djwang pushed a commit to branch merge-with-upstream in repository https://gitbox.apache.org/repos/asf/cloudberry-pxf.git
commit b099e6099dd47dd4477036ede98fb96bd1aabae4 Author: Himanshu Pandey <[email protected]> AuthorDate: Fri Sep 23 15:03:40 2022 -0700 Fixing Tinc tests --- automation/sqlrepo/features/general/alter/csv/expected/query01.ans | 6 ++++++ automation/sqlrepo/features/general/alter/csv/sql/query01.sql | 6 ++++++ .../general/alter/pxfwritable_export/parquet/expected/query01.ans | 7 +++++++ .../general/alter/pxfwritable_export/parquet/sql/query01.sql | 6 ++++++ .../without_column_projection/expected/query01.ans | 3 +++ .../pxfwritable_import/without_column_projection/sql/query01.sql | 3 +++ 6 files changed, 31 insertions(+) diff --git a/automation/sqlrepo/features/general/alter/csv/expected/query01.ans b/automation/sqlrepo/features/general/alter/csv/expected/query01.ans index 387649e3..e420274b 100644 --- a/automation/sqlrepo/features/general/alter/csv/expected/query01.ans +++ b/automation/sqlrepo/features/general/alter/csv/expected/query01.ans @@ -12,6 +12,12 @@ -- m/ERROR/ -- s/ERROR: missing data for column "bool"/ERROR: invalid input syntax for integer: "1.0"/g -- +-- m/ERROR/ +-- s/ERROR: invalid input syntax for integer: "1.0"/ERROR: invalid input syntax for type integer: "1.0"/g +-- +-- m/ALTER/ +-- s/ALTER EXTERNAL TABLE/ALTER FOREIGN TABLE/g +-- -- m/pxf:\/\/(.*)\/pxf_automation_data/ -- s/pxf:\/\/.*alter-tests.*/pxf:\/\/pxf_automation_data?PROFILE=*:text/ -- diff --git a/automation/sqlrepo/features/general/alter/csv/sql/query01.sql b/automation/sqlrepo/features/general/alter/csv/sql/query01.sql index 55b43906..204bdb71 100644 --- a/automation/sqlrepo/features/general/alter/csv/sql/query01.sql +++ b/automation/sqlrepo/features/general/alter/csv/sql/query01.sql @@ -10,6 +10,12 @@ -- m/ERROR/ -- s/ERROR: missing data for column "bool"/ERROR: invalid input syntax for integer: "1.0"/g -- +-- m/ERROR/ +-- s/ERROR: invalid input syntax for integer: "1.0"/ERROR: invalid input syntax for type integer: "1.0"/g +-- +-- m/ALTER/ +-- s/ALTER EXTERNAL TABLE/ALTER FOREIGN TABLE/g +-- -- m/pxf:\/\/(.*)\/pxf_automation_data/ -- s/pxf:\/\/.*alter-tests.*/pxf:\/\/pxf_automation_data?PROFILE=*:text/ -- diff --git a/automation/sqlrepo/features/general/alter/pxfwritable_export/parquet/expected/query01.ans b/automation/sqlrepo/features/general/alter/pxfwritable_export/parquet/expected/query01.ans index 8a16cafa..50d1f85c 100644 --- a/automation/sqlrepo/features/general/alter/pxfwritable_export/parquet/expected/query01.ans +++ b/automation/sqlrepo/features/general/alter/pxfwritable_export/parquet/expected/query01.ans @@ -1,3 +1,10 @@ +-- start_matchsubs +-- +-- m/ALTER/ +-- s/ALTER EXTERNAL TABLE/ALTER FOREIGN TABLE/g +-- +-- end_matchsubs + -- start_ignore -- end_ignore -- @description query01 test altering table, dropping columns during write diff --git a/automation/sqlrepo/features/general/alter/pxfwritable_export/parquet/sql/query01.sql b/automation/sqlrepo/features/general/alter/pxfwritable_export/parquet/sql/query01.sql index 50a20423..05d98b50 100644 --- a/automation/sqlrepo/features/general/alter/pxfwritable_export/parquet/sql/query01.sql +++ b/automation/sqlrepo/features/general/alter/pxfwritable_export/parquet/sql/query01.sql @@ -1,4 +1,10 @@ -- @description query01 test altering table, dropping columns during write +-- start_matchsubs +-- +-- m/ALTER/ +-- s/ALTER EXTERNAL TABLE/ALTER FOREIGN TABLE/g +-- +-- end_matchsubs -- Insert all columns INSERT INTO pxf_alter_write_parquet_table diff --git a/automation/sqlrepo/features/general/alter/pxfwritable_import/without_column_projection/expected/query01.ans b/automation/sqlrepo/features/general/alter/pxfwritable_import/without_column_projection/expected/query01.ans index 27078841..09bed38a 100644 --- a/automation/sqlrepo/features/general/alter/pxfwritable_import/without_column_projection/expected/query01.ans +++ b/automation/sqlrepo/features/general/alter/pxfwritable_import/without_column_projection/expected/query01.ans @@ -11,6 +11,9 @@ -- m/,.*line (.*)/ -- s/,.*line (.*)//g -- +-- m/ALTER/ +-- s/ALTER EXTERNAL TABLE/ALTER FOREIGN TABLE/g +-- -- end_matchsubs -- sets the bytea output to the expected by the tests SET bytea_output='escape'; diff --git a/automation/sqlrepo/features/general/alter/pxfwritable_import/without_column_projection/sql/query01.sql b/automation/sqlrepo/features/general/alter/pxfwritable_import/without_column_projection/sql/query01.sql index d8230707..ce2d0c4e 100644 --- a/automation/sqlrepo/features/general/alter/pxfwritable_import/without_column_projection/sql/query01.sql +++ b/automation/sqlrepo/features/general/alter/pxfwritable_import/without_column_projection/sql/query01.sql @@ -10,6 +10,9 @@ -- m/,.*line (.*)/ -- s/,.*line (.*)//g -- +-- m/ALTER/ +-- s/ALTER EXTERNAL TABLE/ALTER FOREIGN TABLE/g +-- -- end_matchsubs -- sets the bytea output to the expected by the tests --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
