This is an automated email from the ASF dual-hosted git repository.
chenjinbao1989 pushed a commit to branch cbdb-postgres-merge
in repository https://gitbox.apache.org/repos/asf/cloudberry.git
The following commit(s) were added to refs/heads/cbdb-postgres-merge by this
push:
new 759024a6d5b Fix some answer files
759024a6d5b is described below
commit 759024a6d5bdde5fd21373664b4bdb053d143a2b
Author: Jinbao Chen <[email protected]>
AuthorDate: Mon Feb 16 09:33:34 2026 +0800
Fix some answer files
---
src/test/regress/expected/directory_table.out | 28 +++++++++++++--------------
src/test/regress/expected/oid_wraparound.out | 2 +-
src/test/regress/sql/oid_wraparound.sql | 2 +-
3 files changed, 16 insertions(+), 16 deletions(-)
diff --git a/src/test/regress/expected/directory_table.out
b/src/test/regress/expected/directory_table.out
index e1f045cfdb3..207ed2a7022 100644
--- a/src/test/regress/expected/directory_table.out
+++ b/src/test/regress/expected/directory_table.out
@@ -916,16 +916,11 @@ SELECT relative_path, content FROM
directory_table('dir_table2') ORDER BY 1;
nation4 |
\x307c414c47455249417c307c20686167676c652e206361726566756c6c792066696e616c206465706f736974732064657465637420736c796c7920616761690a317c415247454e54494e417c317c616c20666f7865732070726f6d69736520736c796c79206163636f7264696e6720746f2074686520726567756c6172206163636f756e74732e20626f6c6420726571756573747320616c6f6e0a327c4252415a494c7c317c7920616c6f6e6773696465206f66207468652070656e64696e67206465706f736974732e206361726566756c6c79207370656369616c207061636b61676573206172652061626
[...]
(4 rows)
-\COPY BINARY dir_table1 FROM :'nation_file' 'nation.txt'; -- OK
-ERROR: syntax error at or near "'nation.txt'"
-LINE 1: COPY BINARY dir_table1 FROM STDIN 'nation_file' 'nation.txt'...
- ^
+COPY BINARY dir_table1 FROM :'nation_file' 'nation.txt'; -- OK
+NOTICE: dir_table1 INSERT AFTER ROW (seg0 127.0.1.1:7002 pid=113524)
COPY BINARY dir_table1 FROM :'nation_file' 'nation2.txt'; -- OK
-NOTICE: dir_table1 INSERT AFTER ROW (seg2 127.0.1.1:7004 pid=900444)
-\COPY BINARY "abs.dir_table" FROM :'nation_file' 'aa.bb'; -- OK
-ERROR: syntax error at or near "'aa.bb'"
-LINE 1: ...Y BINARY "abs.dir_table" FROM STDIN 'nation_file' 'aa.bb'; ...
- ^
+NOTICE: dir_table1 INSERT AFTER ROW (seg2 127.0.1.1:7004 pid=113526)
+COPY BINARY "abs.dir_table" FROM :'nation_file' 'aa.bb'; -- OK
COPY BINARY "abs.dir_table" FROM :'nation_file' 'cc.dd'; -- OK
-- Test copy binary from directory table
COPY BINARY dir_table1 FROM :'nation_file' 'nation_failed' (format CSV);
@@ -1272,7 +1267,8 @@ SELECT relative_path, size, tag FROM dir_table1 ORDER BY
1;
nation7 | 2199 |
nation8 | 2199 |
nation9 | 2199 |
-(18 rows)
+ nation.txt | 2199 |
+(19 rows)
SELECT relative_path, size, tag FROM dir_table2 ORDER BY 1;
relative_path | size | tag
@@ -1423,7 +1419,8 @@ SELECT relative_path, size, tag FROM dir_table1 ORDER BY
1;
nation7 | 2199 |
nation8 | 2199 |
nation9 | 2199 |
-(18 rows)
+ nation.txt | 2199 |
+(19 rows)
SELECT relative_path, size, tag FROM dir_table2 ORDER BY 1;
relative_path | size | tag
@@ -1459,7 +1456,8 @@ SELECT relative_path, size, tag FROM dir_table1 ORDER BY
1;
nation7 | 2199 |
nation8 | 2199 |
nation9 | 2199 |
-(18 rows)
+ nation.txt | 2199 |
+(19 rows)
SELECT relative_path, size, tag FROM dir_table2 ORDER BY 1;
relative_path | size | tag
@@ -1552,7 +1550,8 @@ SELECT relative_path, size, tag FROM dir_table1 ORDER BY
1;
nation7 | 2199 | nation_new_tag
nation8 | 2199 | nation_new_tag
nation9 | 2199 | nation_new_tag
-(18 rows)
+ nation.txt | 2199 | nation_new_tag
+(19 rows)
SELECT relative_path, size, tag FROM dir_table2 ORDER BY 1;
relative_path | size | tag
@@ -1660,7 +1659,8 @@ SELECT relative_path, size, tag FROM dir_table1 ORDER BY
1;
nation7 | 2199 | nation_new_tag
nation8 | 2199 | nation_new_tag
nation9 | 2199 | nation_new_tag
-(16 rows)
+ nation.txt | 2199 | nation_new_tag
+(17 rows)
SELECT relative_path, size, tag FROM dir_table2 ORDER BY 1;
relative_path | size | tag
diff --git a/src/test/regress/expected/oid_wraparound.out
b/src/test/regress/expected/oid_wraparound.out
index 41b382040b2..92895d06d97 100644
--- a/src/test/regress/expected/oid_wraparound.out
+++ b/src/test/regress/expected/oid_wraparound.out
@@ -105,7 +105,7 @@ SELECT gp_get_next_oid_segments();
(3 rows)
CREATE TABLE oid_wraparound_table_other AS SELECT 1 AS a;
-SELECT gp_get_next_oid_master();
+SELECT gp_get_next_oid_master() in (16390, 16391);
?column?
----------
t
diff --git a/src/test/regress/sql/oid_wraparound.sql
b/src/test/regress/sql/oid_wraparound.sql
index 9f4bc728172..546938fd0e0 100644
--- a/src/test/regress/sql/oid_wraparound.sql
+++ b/src/test/regress/sql/oid_wraparound.sql
@@ -53,5 +53,5 @@ SELECT gp_set_next_oid_segments(16384);
SELECT gp_get_next_oid_master();
SELECT gp_get_next_oid_segments();
CREATE TABLE oid_wraparound_table_other AS SELECT 1 AS a;
-SELECT gp_get_next_oid_master() in (16391, 16392);
+SELECT gp_get_next_oid_master() in (16390, 16391);
SELECT gp_get_next_oid_segments();
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
