This is an automated email from the ASF dual-hosted git repository. avamingli pushed a commit to branch main in repository https://gitbox.apache.org/repos/asf/cloudberry.git
commit 6cc9a78a82e7d2d7a67105161b14606438adc49c Author: Jingwen Yang <[email protected]> AuthorDate: Thu Mar 28 11:27:50 2024 +0800 Fix pipeline diff caused by different length of ----- (#17263) Fix pipeline diff caused by different length of `--------` in SELECT result. --- gpcontrib/gp_exttable_fdw/input/gp_exttable_fdw.source | 2 ++ gpcontrib/gp_exttable_fdw/output/gp_exttable_fdw.source | 14 ++++++-------- 2 files changed, 8 insertions(+), 8 deletions(-) diff --git a/gpcontrib/gp_exttable_fdw/input/gp_exttable_fdw.source b/gpcontrib/gp_exttable_fdw/input/gp_exttable_fdw.source index d2ffe47e4f..033dddd521 100644 --- a/gpcontrib/gp_exttable_fdw/input/gp_exttable_fdw.source +++ b/gpcontrib/gp_exttable_fdw/input/gp_exttable_fdw.source @@ -74,6 +74,8 @@ CREATE FOREIGN TABLE ext_special_uri(a int, b int) SERVER gp_exttable_server OPTIONS (format 'csv', delimiter ',', location_uris 'file://@hostname@@abs_srcdir@/data/spe\\cial1\||file://@hostname@@abs_srcdir@/data/\|special2\\'); +\a SELECT urilocation FROM pg_exttable WHERE reloid = 'public.ext_special_uri'::regclass; SELECT ftoptions FROM pg_foreign_table WHERE ftrelid='public.ext_special_uri'::regclass; +\a SELECT * FROM ext_special_uri ORDER BY a; diff --git a/gpcontrib/gp_exttable_fdw/output/gp_exttable_fdw.source b/gpcontrib/gp_exttable_fdw/output/gp_exttable_fdw.source index 4efc7ef29e..337d21a99e 100644 --- a/gpcontrib/gp_exttable_fdw/output/gp_exttable_fdw.source +++ b/gpcontrib/gp_exttable_fdw/output/gp_exttable_fdw.source @@ -78,18 +78,16 @@ CREATE FOREIGN TABLE ext_special_uri(a int, b int) SERVER gp_exttable_server OPTIONS (format 'csv', delimiter ',', location_uris 'file://@hostname@@abs_srcdir@/data/spe\\cial1\||file://@hostname@@abs_srcdir@/data/\|special2\\'); +\a SELECT urilocation FROM pg_exttable WHERE reloid = 'public.ext_special_uri'::regclass; - urilocation ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ - {"file://@hostname@@abs_srcdir@/data/spe\\cial1|","file://@hostname@@abs_srcdir@/data/|special2\\"} +urilocation +{"file://@hostname@@abs_srcdir@/data/spe\\cial1|","file://@hostname@@abs_srcdir@/data/|special2\\"} (1 row) - SELECT ftoptions FROM pg_foreign_table WHERE ftrelid='public.ext_special_uri'::regclass; - ftoptions --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - {format=csv,"delimiter=,","location_uris=file://@hostname@@abs_srcdir@/data/spe\\\\cial1\\||file://@hostname@@abs_srcdir@/data/\\|special2\\\\"} +ftoptions +{format=csv,"delimiter=,","location_uris=file://@hostname@@abs_srcdir@/data/spe\\\\cial1\\||file://@hostname@@abs_srcdir@/data/\\|special2\\\\"} (1 row) - +\a SELECT * FROM ext_special_uri ORDER BY a; a | b ---+--- --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
