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 4c5df543fe9 Fix some answer files
4c5df543fe9 is described below
commit 4c5df543fe9621d7d8d51ba79719df724478700b
Author: Jinbao Chen <[email protected]>
AuthorDate: Sat Jan 3 23:23:22 2026 +0800
Fix some answer files
---
src/test/regress/expected/aocs.out | 12 ++--
src/test/regress/expected/auth_constraint.out | 4 +-
src/test/regress/expected/dispatch.out | 18 +++---
.../regress/expected/resource_queue_function.out | 4 +-
src/test/regress/expected/rpt_tpch.out | 71 +++++++++++++---------
src/test/regress/sql/aocs.sql | 12 ++--
src/test/regress/sql/auth_constraint.sql | 4 +-
src/test/regress/sql/dispatch.sql | 14 +++--
src/test/regress/sql/resource_queue_function.sql | 5 +-
src/test/regress/sql/rpt_tpch.sql | 71 +++++++++++++---------
10 files changed, 126 insertions(+), 89 deletions(-)
diff --git a/src/test/regress/expected/aocs.out
b/src/test/regress/expected/aocs.out
index df82c244344..605692b1a29 100644
--- a/src/test/regress/expected/aocs.out
+++ b/src/test/regress/expected/aocs.out
@@ -104,11 +104,13 @@ SELECT c.relname, count(a.attnum) FROM
pg_attribute_encoding a, pg_class c WHERE
-- supported sql
--------------------
-- COPY
-COPY tenk_heap_for_aocs FROM '@abs_srcdir@/data/tenk.data';
-COPY tenk_aocs1 FROM '@abs_srcdir@/data/tenk.data';
-COPY tenk_aocs2 FROM '@abs_srcdir@/data/tenk.data';
-COPY tenk_aocs3 FROM '@abs_srcdir@/data/tenk.data';
-COPY tenk_aocs4 FROM '@abs_srcdir@/data/tenk.data';
+\getenv abs_srcdir PG_ABS_SRCDIR
+\set tenk_file :abs_srcdir '/data/tenk.data'
+COPY tenk_heap_for_aocs FROM :'tenk_file';
+COPY tenk_aocs1 FROM :'tenk_file';
+COPY tenk_aocs2 FROM :'tenk_file';
+COPY tenk_aocs3 FROM :'tenk_file';
+COPY tenk_aocs4 FROM :'tenk_file';
-- SELECT
SELECT count(*) FROM tenk_heap_for_aocs;
count
diff --git a/src/test/regress/expected/auth_constraint.out
b/src/test/regress/expected/auth_constraint.out
index adfef8d7faf..4a1337e34c7 100755
--- a/src/test/regress/expected/auth_constraint.out
+++ b/src/test/regress/expected/auth_constraint.out
@@ -1,9 +1,11 @@
-- By design, every boolean query (which doesn't error out) in this test must
return true.
-- For reference, 2011-08-30 was a Tuesday!
--
+\getenv abs_builddir PG_ABS_BUILDDIR
+\set regress_dll :abs_builddir '/regress.so'
CREATE FUNCTION check_auth_time_constraints(cstring, timestamptz)
RETURNS bool
- AS '@abs_builddir@/regress@DLSUFFIX@'
+ AS :'regress_dll'
LANGUAGE C IMMUTABLE STRICT NO SQL;
--
-- invalid timestamp should error out
diff --git a/src/test/regress/expected/dispatch.out
b/src/test/regress/expected/dispatch.out
index c2a37c8af6e..41b0ae1c630 100644
--- a/src/test/regress/expected/dispatch.out
+++ b/src/test/regress/expected/dispatch.out
@@ -263,14 +263,16 @@ HINT: The 'DISTRIBUTED BY' clause determines the
distribution of data. Make sur
insert into dispatch_test_t1 values (1,1,2);
insert into dispatch_test_t2 values (2,1,2);
insert into dispatch_test_t3 values (3,1,2);
+\getenv abs_builddir PG_ABS_BUILDDIR
+\set regress_dll :abs_builddir '/regress.so'
CREATE OR REPLACE FUNCTION cleanupAllGangs() RETURNS BOOL
-AS '@abs_builddir@/regress@DLSUFFIX@', 'cleanupAllGangs' LANGUAGE C;
+AS :'regress_dll', 'cleanupAllGangs' LANGUAGE C;
-- check if segments has backend running
CREATE OR REPLACE FUNCTION hasBackendsExist(int) RETURNS SETOF BOOL
-AS '@abs_builddir@/regress@DLSUFFIX@', 'hasBackendsExist' LANGUAGE C EXECUTE
ON ALL SEGMENTS;
+AS :'regress_dll', 'hasBackendsExist' LANGUAGE C EXECUTE ON ALL SEGMENTS;
-- check if QD has reusable gangs
CREATE OR REPLACE FUNCTION hasGangsExist() RETURNS BOOL
-AS '@abs_builddir@/regress@DLSUFFIX@', 'hasGangsExist' LANGUAGE C;
+AS :'regress_dll', 'hasGangsExist' LANGUAGE C;
-- test log debug related code within dispatch
set gp_log_gang to debug;
set log_min_messages to DEBUG;
@@ -599,7 +601,7 @@ reset max_parallel_workers_per_gather;
SET gp_log_gang = 'debug';
-- test INFO raised from segments with various kinds of fields
CREATE OR REPLACE FUNCTION udf_raise_info() RETURNS BOOL
-AS '@abs_builddir@/regress@DLSUFFIX@', 'gangRaiseInfo' LANGUAGE C;
+AS :'regress_dll', 'gangRaiseInfo' LANGUAGE C;
SELECT udf_raise_info() FROM gp_dist_random('gp_id') WHERE gp_segment_id = 0;
INFO: testing hook function MPPnoticeReceiver (seg0 slice1 127.0.0.1:40000
pid=11337)
DETAIL: this test aims at covering code paths not hit before
@@ -631,13 +633,13 @@ $$
LANGUAGE plpgSQL READS SQL DATA;
SELECT dtx_dispatch_f(foo.c1) FROM (SELECT c1 FROM dtx_dispatch_t WHERE c1='1'
limit 1) foo;
ERROR: query plan with multiple segworker groups is not supported
-HINT: dispatching DTX commands to a busy gang
-CONTEXT: PL/pgSQL function "dtx_dispatch_f" line 1 during statement block
entry
+HINT: likely caused by a function that reads or modifies data in a
distributed table
+CONTEXT: PL/pgSQL function dtx_dispatch_f(integer) line 2 during statement
block entry
DROP FUNCTION dtx_dispatch_f(integer);
DROP TABLE dtx_dispatch_t;
-- Test interconnect is shut down under portal failure
CREATE OR REPLACE FUNCTION numActiveMotionConns() RETURNS INT
-AS '@abs_builddir@/regress@DLSUFFIX@', 'numActiveMotionConns' LANGUAGE C;
+AS :'regress_dll', 'numActiveMotionConns' LANGUAGE C;
CREATE TABLE foo_test AS SELECT i AS c1 FROM generate_series(1, 10) i;
NOTICE: Table doesn't have 'DISTRIBUTED BY' clause. Creating a NULL policy
entry.
SELECT c1/0 FROM foo_test WHERE c1 = 1;
@@ -908,7 +910,7 @@ SELECT
gp_inject_fault('cdbcomponent_recycle_idle_qe_error', 'reset', dbid, curr
drop table t13393;
-- test for print create time for gang.
CREATE OR REPLACE FUNCTION cleanupAllGangs() RETURNS BOOL
-AS '@abs_builddir@/regress@DLSUFFIX@', 'cleanupAllGangs' LANGUAGE C;
+AS :'regress_dll', 'cleanupAllGangs' LANGUAGE C;
-- cleanupAllGangs();
select cleanupAllGangs();
cleanupallgangs
diff --git a/src/test/regress/expected/resource_queue_function.out
b/src/test/regress/expected/resource_queue_function.out
index d2dd4a0a203..267b3afe3bb 100644
--- a/src/test/regress/expected/resource_queue_function.out
+++ b/src/test/regress/expected/resource_queue_function.out
@@ -1,5 +1,7 @@
+\getenv abs_builddir PG_ABS_BUILDDIR
+\set regress_dll :abs_builddir '/regress.so'
CREATE FUNCTION checkResourceQueueMemoryLimits(cstring) RETURNS boolean
-AS '@abs_srcdir@/regress.so', 'checkResourceQueueMemoryLimits' LANGUAGE C
READS SQL DATA;
+AS :'regress_dll', 'checkResourceQueueMemoryLimits' LANGUAGE C READS SQL DATA;
CREATE TABLE test_table(c1 int, c2 int);
NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c1'
as the Apache Cloudberry data distribution key for this table.
HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
diff --git a/src/test/regress/expected/rpt_tpch.out
b/src/test/regress/expected/rpt_tpch.out
index 5c6265eedec..976778151bf 100644
--- a/src/test/regress/expected/rpt_tpch.out
+++ b/src/test/regress/expected/rpt_tpch.out
@@ -86,16 +86,27 @@ CREATE TABLE heap_supplier (
s_comment character varying(101) NOT NULL
)
WITH (appendonly=false) DISTRIBUTED REPLICATED;
-\copy heap_customer
(C_CUSTKEY,C_NAME,C_ADDRESS,C_NATIONKEY,C_PHONE,C_ACCTBAL,C_MKTSEGMENT,C_COMMENT)
from '@abs_srcdir@/data/customer.csv' with delimiter '|';
-\copy heap_lineitem ( L_ORDERKEY, L_PARTKEY,
L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from '@abs_srcdir@/data/lineitem_small.csv' with delimiter '|';
-\copy heap_lineitem ( L_ORDERKEY, L_PARTKEY,
L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from '@abs_srcdir@/data/lineitem.csv' with delimiter '|';
-\copy heap_nation (N_NATIONKEY ,N_NAME, N_REGIONKEY,N_COMMENT) from
'@abs_srcdir@/data/nation.csv' with delimiter '|';
-\copy heap_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from '@abs_srcdir@/data/order_small.csv' with delimiter '|';
-\copy heap_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from '@abs_srcdir@/data/order.csv' with delimiter '|';
-\copy heap_part
(P_PARTKEY,P_NAME,P_MFGR,P_BRAND,P_TYPE,P_SIZE,P_CONTAINER,P_RETAILPRICE,P_COMMENT)from
'@abs_srcdir@/data/part.csv' with delimiter '|';
-\copy heap_partsupp
(PS_PARTKEY,PS_SUPPKEY,PS_AVAILQTY,PS_SUPPLYCOST,PS_COMMENT ) from
'@abs_srcdir@/data/partsupp.csv' with delimiter '|';
-\copy heap_region ( R_REGIONKEY,R_NAME,R_COMMENT) from
'@abs_srcdir@/data/region.csv' with delimiter '|';
-\copy heap_supplier
(S_SUPPKEY,S_NAME,S_ADDRESS,S_NATIONKEY,S_PHONE,S_ACCTBAL,S_COMMENT) from
'@abs_srcdir@/data/supplier.csv' with delimiter '|';
+\getenv abs_srcdir PG_ABS_SRCDIR
+\set customer_file :abs_srcdir '/data/customer.csv'
+\set lineitem_small_file :abs_srcdir '/data/lineitem_small.csv'
+\set lineitem_file :abs_srcdir '/data/lineitem.csv'
+\set nation_file :abs_srcdir '/data/nation.csv'
+\set order_small_file :abs_srcdir '/data/order_small.csv'
+\set order_file :abs_srcdir '/data/order.csv'
+\set part_file :abs_srcdir '/data/part.csv'
+\set partsupp_file :abs_srcdir '/data/partsupp.csv'
+\set region_file :abs_srcdir '/data/region.csv'
+\set supplier_file :abs_srcdir '/data/supplier.csv'
+copy heap_customer
(C_CUSTKEY,C_NAME,C_ADDRESS,C_NATIONKEY,C_PHONE,C_ACCTBAL,C_MKTSEGMENT,C_COMMENT)
from :'customer_file' with delimiter '|';
+copy heap_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from :'lineitem_small_file' with delimiter '|';
+copy heap_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from :'lineitem_file' with delimiter '|';
+copy heap_nation (N_NATIONKEY ,N_NAME, N_REGIONKEY,N_COMMENT) from
:'nation_file' with delimiter '|';
+copy heap_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from :'order_small_file' with delimiter '|';
+copy heap_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from :'order_file' with delimiter '|';
+copy heap_part
(P_PARTKEY,P_NAME,P_MFGR,P_BRAND,P_TYPE,P_SIZE,P_CONTAINER,P_RETAILPRICE,P_COMMENT)from
:'part_file' with delimiter '|';
+copy heap_partsupp (PS_PARTKEY,PS_SUPPKEY,PS_AVAILQTY,PS_SUPPLYCOST,PS_COMMENT
) from :'partsupp_file' with delimiter '|';
+copy heap_region ( R_REGIONKEY,R_NAME,R_COMMENT) from :'region_file' with
delimiter '|';
+copy heap_supplier
(S_SUPPKEY,S_NAME,S_ADDRESS,S_NATIONKEY,S_PHONE,S_ACCTBAL,S_COMMENT) from
:'supplier_file' with delimiter '|';
ANALYZE heap_customer;
ANALYZE heap_lineitem;
ANALYZE heap_nation;
@@ -189,16 +200,16 @@ CREATE TABLE ao_supplier (
s_comment character varying(101) NOT NULL
)
WITH (appendonly=true) DISTRIBUTED REPLICATED;
-\copy ao_customer
(C_CUSTKEY,C_NAME,C_ADDRESS,C_NATIONKEY,C_PHONE,C_ACCTBAL,C_MKTSEGMENT,C_COMMENT)
from '@abs_srcdir@/data/customer.csv' with delimiter '|';
-\copy ao_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from '@abs_srcdir@/data/lineitem_small.csv' with delimiter '|';
-\copy ao_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from '@abs_srcdir@/data/lineitem.csv' with delimiter '|';
-\copy ao_nation (N_NATIONKEY ,N_NAME, N_REGIONKEY,N_COMMENT) from
'@abs_srcdir@/data/nation.csv' with delimiter '|';
-\copy ao_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from '@abs_srcdir@/data/order_small.csv' with delimiter '|';
-\copy ao_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from '@abs_srcdir@/data/order.csv' with delimiter '|';
-\copy ao_part
(P_PARTKEY,P_NAME,P_MFGR,P_BRAND,P_TYPE,P_SIZE,P_CONTAINER,P_RETAILPRICE,P_COMMENT)from
'@abs_srcdir@/data/part.csv' with delimiter '|';
-\copy ao_partsupp (PS_PARTKEY,PS_SUPPKEY,PS_AVAILQTY,PS_SUPPLYCOST,PS_COMMENT
) from '@abs_srcdir@/data/partsupp.csv' with delimiter '|';
-\copy ao_region ( R_REGIONKEY,R_NAME,R_COMMENT) from
'@abs_srcdir@/data/region.csv' with delimiter '|';
-\copy ao_supplier
(S_SUPPKEY,S_NAME,S_ADDRESS,S_NATIONKEY,S_PHONE,S_ACCTBAL,S_COMMENT) from
'@abs_srcdir@/data/supplier.csv' with delimiter '|';
+copy ao_customer
(C_CUSTKEY,C_NAME,C_ADDRESS,C_NATIONKEY,C_PHONE,C_ACCTBAL,C_MKTSEGMENT,C_COMMENT)
from :'customer_file' with delimiter '|';
+copy ao_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from :'lineitem_small_file' with delimiter '|';
+copy ao_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from :'lineitem_file' with delimiter '|';
+copy ao_nation (N_NATIONKEY ,N_NAME, N_REGIONKEY,N_COMMENT) from
:'nation_file' with delimiter '|';
+copy ao_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from :'order_small_file' with delimiter '|';
+copy ao_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from :'order_file' with delimiter '|';
+copy ao_part
(P_PARTKEY,P_NAME,P_MFGR,P_BRAND,P_TYPE,P_SIZE,P_CONTAINER,P_RETAILPRICE,P_COMMENT)from
:'part_file' with delimiter '|';
+copy ao_partsupp (PS_PARTKEY,PS_SUPPKEY,PS_AVAILQTY,PS_SUPPLYCOST,PS_COMMENT )
from :'partsupp_file' with delimiter '|';
+copy ao_region ( R_REGIONKEY,R_NAME,R_COMMENT) from :'region_file' with
delimiter '|';
+copy ao_supplier
(S_SUPPKEY,S_NAME,S_ADDRESS,S_NATIONKEY,S_PHONE,S_ACCTBAL,S_COMMENT) from
:'supplier_file' with delimiter '|';
ANALYZE ao_customer;
ANALYZE ao_lineitem;
ANALYZE ao_nation;
@@ -292,16 +303,16 @@ CREATE TABLE co_supplier (
s_comment character varying(101) NOT NULL ENCODING
(compresstype=none,blocksize=32768,compresslevel=0)
)
WITH (appendonly=true, orientation=column) DISTRIBUTED BY (s_suppkey);
-\copy co_customer
(C_CUSTKEY,C_NAME,C_ADDRESS,C_NATIONKEY,C_PHONE,C_ACCTBAL,C_MKTSEGMENT,C_COMMENT)
from '@abs_srcdir@/data/customer.csv' with delimiter '|';
-\copy co_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from '@abs_srcdir@/data/lineitem_small.csv' with delimiter '|';
-\copy co_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from '@abs_srcdir@/data/lineitem.csv' with delimiter '|';
-\copy co_nation (N_NATIONKEY ,N_NAME, N_REGIONKEY,N_COMMENT) from
'@abs_srcdir@/data/nation.csv' with delimiter '|';
-\copy co_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from '@abs_srcdir@/data/order_small.csv' with delimiter '|';
-\copy co_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from '@abs_srcdir@/data/order.csv' with delimiter '|';
-\copy co_part
(P_PARTKEY,P_NAME,P_MFGR,P_BRAND,P_TYPE,P_SIZE,P_CONTAINER,P_RETAILPRICE,P_COMMENT)
from '@abs_srcdir@/data/part.csv' with delimiter '|';
-\copy co_partsupp (PS_PARTKEY,PS_SUPPKEY,PS_AVAILQTY,PS_SUPPLYCOST,PS_COMMENT
) from '@abs_srcdir@/data/partsupp.csv' with delimiter '|';
-\copy co_region ( R_REGIONKEY,R_NAME,R_COMMENT) from
'@abs_srcdir@/data/region.csv' with delimiter '|';
-\copy co_supplier
(S_SUPPKEY,S_NAME,S_ADDRESS,S_NATIONKEY,S_PHONE,S_ACCTBAL,S_COMMENT) from
'@abs_srcdir@/data/supplier.csv' with delimiter '|';
+copy co_customer
(C_CUSTKEY,C_NAME,C_ADDRESS,C_NATIONKEY,C_PHONE,C_ACCTBAL,C_MKTSEGMENT,C_COMMENT)
from :'customer_file' with delimiter '|';
+copy co_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from :'lineitem_small_file' with delimiter '|';
+copy co_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from :'lineitem_file' with delimiter '|';
+copy co_nation (N_NATIONKEY ,N_NAME, N_REGIONKEY,N_COMMENT) from
:'nation_file' with delimiter '|';
+copy co_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from :'order_small_file' with delimiter '|';
+copy co_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from :'order_file' with delimiter '|';
+copy co_part
(P_PARTKEY,P_NAME,P_MFGR,P_BRAND,P_TYPE,P_SIZE,P_CONTAINER,P_RETAILPRICE,P_COMMENT)
from :'part_file' with delimiter '|';
+copy co_partsupp (PS_PARTKEY,PS_SUPPKEY,PS_AVAILQTY,PS_SUPPLYCOST,PS_COMMENT )
from :'partsupp_file' with delimiter '|';
+copy co_region ( R_REGIONKEY,R_NAME,R_COMMENT) from :'region_file' with
delimiter '|';
+copy co_supplier
(S_SUPPKEY,S_NAME,S_ADDRESS,S_NATIONKEY,S_PHONE,S_ACCTBAL,S_COMMENT) from
:'supplier_file' with delimiter '|';
ANALYZE co_customer;
ANALYZE co_lineitem;
ANALYZE co_nation;
diff --git a/src/test/regress/sql/aocs.sql b/src/test/regress/sql/aocs.sql
index 74f040665fc..1291cdce0b2 100644
--- a/src/test/regress/sql/aocs.sql
+++ b/src/test/regress/sql/aocs.sql
@@ -77,11 +77,13 @@ SELECT c.relname, count(a.attnum) FROM
pg_attribute_encoding a, pg_class c WHERE
--------------------
-- COPY
-COPY tenk_heap_for_aocs FROM '@abs_srcdir@/data/tenk.data';
-COPY tenk_aocs1 FROM '@abs_srcdir@/data/tenk.data';
-COPY tenk_aocs2 FROM '@abs_srcdir@/data/tenk.data';
-COPY tenk_aocs3 FROM '@abs_srcdir@/data/tenk.data';
-COPY tenk_aocs4 FROM '@abs_srcdir@/data/tenk.data';
+\getenv abs_srcdir PG_ABS_SRCDIR
+\set tenk_file :abs_srcdir '/data/tenk.data'
+COPY tenk_heap_for_aocs FROM :'tenk_file';
+COPY tenk_aocs1 FROM :'tenk_file';
+COPY tenk_aocs2 FROM :'tenk_file';
+COPY tenk_aocs3 FROM :'tenk_file';
+COPY tenk_aocs4 FROM :'tenk_file';
-- SELECT
SELECT count(*) FROM tenk_heap_for_aocs;
diff --git a/src/test/regress/sql/auth_constraint.sql
b/src/test/regress/sql/auth_constraint.sql
index 2cc316c40fd..5598776bc10 100755
--- a/src/test/regress/sql/auth_constraint.sql
+++ b/src/test/regress/sql/auth_constraint.sql
@@ -1,9 +1,11 @@
-- By design, every boolean query (which doesn't error out) in this test must
return true.
-- For reference, 2011-08-30 was a Tuesday!
--
+\getenv abs_builddir PG_ABS_BUILDDIR
+\set regress_dll :abs_builddir '/regress.so'
CREATE FUNCTION check_auth_time_constraints(cstring, timestamptz)
RETURNS bool
- AS '@abs_builddir@/regress@DLSUFFIX@'
+ AS :'regress_dll'
LANGUAGE C IMMUTABLE STRICT NO SQL;
--
diff --git a/src/test/regress/sql/dispatch.sql
b/src/test/regress/sql/dispatch.sql
index af71c03422f..d9e642b71f1 100644
--- a/src/test/regress/sql/dispatch.sql
+++ b/src/test/regress/sql/dispatch.sql
@@ -178,16 +178,18 @@ insert into dispatch_test_t1 values (1,1,2);
insert into dispatch_test_t2 values (2,1,2);
insert into dispatch_test_t3 values (3,1,2);
+\getenv abs_builddir PG_ABS_BUILDDIR
+\set regress_dll :abs_builddir '/regress.so'
CREATE OR REPLACE FUNCTION cleanupAllGangs() RETURNS BOOL
-AS '@abs_builddir@/regress@DLSUFFIX@', 'cleanupAllGangs' LANGUAGE C;
+AS :'regress_dll', 'cleanupAllGangs' LANGUAGE C;
-- check if segments has backend running
CREATE OR REPLACE FUNCTION hasBackendsExist(int) RETURNS SETOF BOOL
-AS '@abs_builddir@/regress@DLSUFFIX@', 'hasBackendsExist' LANGUAGE C EXECUTE
ON ALL SEGMENTS;
+AS :'regress_dll', 'hasBackendsExist' LANGUAGE C EXECUTE ON ALL SEGMENTS;
-- check if QD has reusable gangs
CREATE OR REPLACE FUNCTION hasGangsExist() RETURNS BOOL
-AS '@abs_builddir@/regress@DLSUFFIX@', 'hasGangsExist' LANGUAGE C;
+AS :'regress_dll', 'hasGangsExist' LANGUAGE C;
-- test log debug related code within dispatch
set gp_log_gang to debug;
@@ -357,7 +359,7 @@ SET gp_log_gang = 'debug';
-- test INFO raised from segments with various kinds of fields
CREATE OR REPLACE FUNCTION udf_raise_info() RETURNS BOOL
-AS '@abs_builddir@/regress@DLSUFFIX@', 'gangRaiseInfo' LANGUAGE C;
+AS :'regress_dll', 'gangRaiseInfo' LANGUAGE C;
SELECT udf_raise_info() FROM gp_dist_random('gp_id') WHERE gp_segment_id = 0;
@@ -387,7 +389,7 @@ DROP TABLE dtx_dispatch_t;
-- Test interconnect is shut down under portal failure
CREATE OR REPLACE FUNCTION numActiveMotionConns() RETURNS INT
-AS '@abs_builddir@/regress@DLSUFFIX@', 'numActiveMotionConns' LANGUAGE C;
+AS :'regress_dll', 'numActiveMotionConns' LANGUAGE C;
CREATE TABLE foo_test AS SELECT i AS c1 FROM generate_series(1, 10) i;
@@ -561,7 +563,7 @@ drop table t13393;
-- test for print create time for gang.
CREATE OR REPLACE FUNCTION cleanupAllGangs() RETURNS BOOL
-AS '@abs_builddir@/regress@DLSUFFIX@', 'cleanupAllGangs' LANGUAGE C;
+AS :'regress_dll', 'cleanupAllGangs' LANGUAGE C;
-- cleanupAllGangs();
select cleanupAllGangs();
diff --git a/src/test/regress/sql/resource_queue_function.sql
b/src/test/regress/sql/resource_queue_function.sql
index 936dc16a565..98ee3a28704 100644
--- a/src/test/regress/sql/resource_queue_function.sql
+++ b/src/test/regress/sql/resource_queue_function.sql
@@ -1,6 +1,7 @@
-
+\getenv abs_builddir PG_ABS_BUILDDIR
+\set regress_dll :abs_builddir '/regress.so'
CREATE FUNCTION checkResourceQueueMemoryLimits(cstring) RETURNS boolean
-AS '@abs_builddir@/regress@DLSUFFIX@', 'checkResourceQueueMemoryLimits'
LANGUAGE C READS SQL DATA;
+AS :'regress_dll', 'checkResourceQueueMemoryLimits' LANGUAGE C READS SQL DATA;
CREATE TABLE test_table(c1 int, c2 int);
INSERT INTO test_table values(1, 2);
diff --git a/src/test/regress/sql/rpt_tpch.sql
b/src/test/regress/sql/rpt_tpch.sql
index 750fabf6b85..19f7b04460c 100644
--- a/src/test/regress/sql/rpt_tpch.sql
+++ b/src/test/regress/sql/rpt_tpch.sql
@@ -95,16 +95,27 @@ CREATE TABLE heap_supplier (
)
WITH (appendonly=false) DISTRIBUTED REPLICATED;
-\copy heap_customer
(C_CUSTKEY,C_NAME,C_ADDRESS,C_NATIONKEY,C_PHONE,C_ACCTBAL,C_MKTSEGMENT,C_COMMENT)
from '@abs_srcdir@/data/customer.csv' with delimiter '|';
-\copy heap_lineitem ( L_ORDERKEY, L_PARTKEY,
L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from '@abs_srcdir@/data/lineitem_small.csv' with delimiter '|';
-\copy heap_lineitem ( L_ORDERKEY, L_PARTKEY,
L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from '@abs_srcdir@/data/lineitem.csv' with delimiter '|';
-\copy heap_nation (N_NATIONKEY ,N_NAME, N_REGIONKEY,N_COMMENT) from
'@abs_srcdir@/data/nation.csv' with delimiter '|';
-\copy heap_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from '@abs_srcdir@/data/order_small.csv' with delimiter '|';
-\copy heap_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from '@abs_srcdir@/data/order.csv' with delimiter '|';
-\copy heap_part
(P_PARTKEY,P_NAME,P_MFGR,P_BRAND,P_TYPE,P_SIZE,P_CONTAINER,P_RETAILPRICE,P_COMMENT)from
'@abs_srcdir@/data/part.csv' with delimiter '|';
-\copy heap_partsupp
(PS_PARTKEY,PS_SUPPKEY,PS_AVAILQTY,PS_SUPPLYCOST,PS_COMMENT ) from
'@abs_srcdir@/data/partsupp.csv' with delimiter '|';
-\copy heap_region ( R_REGIONKEY,R_NAME,R_COMMENT) from
'@abs_srcdir@/data/region.csv' with delimiter '|';
-\copy heap_supplier
(S_SUPPKEY,S_NAME,S_ADDRESS,S_NATIONKEY,S_PHONE,S_ACCTBAL,S_COMMENT) from
'@abs_srcdir@/data/supplier.csv' with delimiter '|';
+\getenv abs_srcdir PG_ABS_SRCDIR
+\set customer_file :abs_srcdir '/data/customer.csv'
+\set lineitem_small_file :abs_srcdir '/data/lineitem_small.csv'
+\set lineitem_file :abs_srcdir '/data/lineitem.csv'
+\set nation_file :abs_srcdir '/data/nation.csv'
+\set order_small_file :abs_srcdir '/data/order_small.csv'
+\set order_file :abs_srcdir '/data/order.csv'
+\set part_file :abs_srcdir '/data/part.csv'
+\set partsupp_file :abs_srcdir '/data/partsupp.csv'
+\set region_file :abs_srcdir '/data/region.csv'
+\set supplier_file :abs_srcdir '/data/supplier.csv'
+copy heap_customer
(C_CUSTKEY,C_NAME,C_ADDRESS,C_NATIONKEY,C_PHONE,C_ACCTBAL,C_MKTSEGMENT,C_COMMENT)
from :'customer_file' with delimiter '|';
+copy heap_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from :'lineitem_small_file' with delimiter '|';
+copy heap_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from :'lineitem_file' with delimiter '|';
+copy heap_nation (N_NATIONKEY ,N_NAME, N_REGIONKEY,N_COMMENT) from
:'nation_file' with delimiter '|';
+copy heap_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from :'order_small_file' with delimiter '|';
+copy heap_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from :'order_file' with delimiter '|';
+copy heap_part
(P_PARTKEY,P_NAME,P_MFGR,P_BRAND,P_TYPE,P_SIZE,P_CONTAINER,P_RETAILPRICE,P_COMMENT)from
:'part_file' with delimiter '|';
+copy heap_partsupp (PS_PARTKEY,PS_SUPPKEY,PS_AVAILQTY,PS_SUPPLYCOST,PS_COMMENT
) from :'partsupp_file' with delimiter '|';
+copy heap_region ( R_REGIONKEY,R_NAME,R_COMMENT) from :'region_file' with
delimiter '|';
+copy heap_supplier
(S_SUPPKEY,S_NAME,S_ADDRESS,S_NATIONKEY,S_PHONE,S_ACCTBAL,S_COMMENT) from
:'supplier_file' with delimiter '|';
ANALYZE heap_customer;
ANALYZE heap_lineitem;
@@ -209,16 +220,16 @@ CREATE TABLE ao_supplier (
)
WITH (appendonly=true) DISTRIBUTED REPLICATED;
-\copy ao_customer
(C_CUSTKEY,C_NAME,C_ADDRESS,C_NATIONKEY,C_PHONE,C_ACCTBAL,C_MKTSEGMENT,C_COMMENT)
from '@abs_srcdir@/data/customer.csv' with delimiter '|';
-\copy ao_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from '@abs_srcdir@/data/lineitem_small.csv' with delimiter '|';
-\copy ao_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from '@abs_srcdir@/data/lineitem.csv' with delimiter '|';
-\copy ao_nation (N_NATIONKEY ,N_NAME, N_REGIONKEY,N_COMMENT) from
'@abs_srcdir@/data/nation.csv' with delimiter '|';
-\copy ao_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from '@abs_srcdir@/data/order_small.csv' with delimiter '|';
-\copy ao_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from '@abs_srcdir@/data/order.csv' with delimiter '|';
-\copy ao_part
(P_PARTKEY,P_NAME,P_MFGR,P_BRAND,P_TYPE,P_SIZE,P_CONTAINER,P_RETAILPRICE,P_COMMENT)from
'@abs_srcdir@/data/part.csv' with delimiter '|';
-\copy ao_partsupp (PS_PARTKEY,PS_SUPPKEY,PS_AVAILQTY,PS_SUPPLYCOST,PS_COMMENT
) from '@abs_srcdir@/data/partsupp.csv' with delimiter '|';
-\copy ao_region ( R_REGIONKEY,R_NAME,R_COMMENT) from
'@abs_srcdir@/data/region.csv' with delimiter '|';
-\copy ao_supplier
(S_SUPPKEY,S_NAME,S_ADDRESS,S_NATIONKEY,S_PHONE,S_ACCTBAL,S_COMMENT) from
'@abs_srcdir@/data/supplier.csv' with delimiter '|';
+copy ao_customer
(C_CUSTKEY,C_NAME,C_ADDRESS,C_NATIONKEY,C_PHONE,C_ACCTBAL,C_MKTSEGMENT,C_COMMENT)
from :'customer_file' with delimiter '|';
+copy ao_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from :'lineitem_small_file' with delimiter '|';
+copy ao_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from :'lineitem_file' with delimiter '|';
+copy ao_nation (N_NATIONKEY ,N_NAME, N_REGIONKEY,N_COMMENT) from
:'nation_file' with delimiter '|';
+copy ao_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from :'order_small_file' with delimiter '|';
+copy ao_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from :'order_file' with delimiter '|';
+copy ao_part
(P_PARTKEY,P_NAME,P_MFGR,P_BRAND,P_TYPE,P_SIZE,P_CONTAINER,P_RETAILPRICE,P_COMMENT)from
:'part_file' with delimiter '|';
+copy ao_partsupp (PS_PARTKEY,PS_SUPPKEY,PS_AVAILQTY,PS_SUPPLYCOST,PS_COMMENT )
from :'partsupp_file' with delimiter '|';
+copy ao_region ( R_REGIONKEY,R_NAME,R_COMMENT) from :'region_file' with
delimiter '|';
+copy ao_supplier
(S_SUPPKEY,S_NAME,S_ADDRESS,S_NATIONKEY,S_PHONE,S_ACCTBAL,S_COMMENT) from
:'supplier_file' with delimiter '|';
ANALYZE ao_customer;
ANALYZE ao_lineitem;
@@ -323,16 +334,16 @@ CREATE TABLE co_supplier (
)
WITH (appendonly=true, orientation=column) DISTRIBUTED BY (s_suppkey);
-\copy co_customer
(C_CUSTKEY,C_NAME,C_ADDRESS,C_NATIONKEY,C_PHONE,C_ACCTBAL,C_MKTSEGMENT,C_COMMENT)
from '@abs_srcdir@/data/customer.csv' with delimiter '|';
-\copy co_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from '@abs_srcdir@/data/lineitem_small.csv' with delimiter '|';
-\copy co_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from '@abs_srcdir@/data/lineitem.csv' with delimiter '|';
-\copy co_nation (N_NATIONKEY ,N_NAME, N_REGIONKEY,N_COMMENT) from
'@abs_srcdir@/data/nation.csv' with delimiter '|';
-\copy co_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from '@abs_srcdir@/data/order_small.csv' with delimiter '|';
-\copy co_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from '@abs_srcdir@/data/order.csv' with delimiter '|';
-\copy co_part
(P_PARTKEY,P_NAME,P_MFGR,P_BRAND,P_TYPE,P_SIZE,P_CONTAINER,P_RETAILPRICE,P_COMMENT)
from '@abs_srcdir@/data/part.csv' with delimiter '|';
-\copy co_partsupp (PS_PARTKEY,PS_SUPPKEY,PS_AVAILQTY,PS_SUPPLYCOST,PS_COMMENT
) from '@abs_srcdir@/data/partsupp.csv' with delimiter '|';
-\copy co_region ( R_REGIONKEY,R_NAME,R_COMMENT) from
'@abs_srcdir@/data/region.csv' with delimiter '|';
-\copy co_supplier
(S_SUPPKEY,S_NAME,S_ADDRESS,S_NATIONKEY,S_PHONE,S_ACCTBAL,S_COMMENT) from
'@abs_srcdir@/data/supplier.csv' with delimiter '|';
+copy co_customer
(C_CUSTKEY,C_NAME,C_ADDRESS,C_NATIONKEY,C_PHONE,C_ACCTBAL,C_MKTSEGMENT,C_COMMENT)
from :'customer_file' with delimiter '|';
+copy co_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from :'lineitem_small_file' with delimiter '|';
+copy co_lineitem ( L_ORDERKEY, L_PARTKEY, L_SUPPKEY,L_LINENUMBER,L_QUANTITY,
L_EXTENDEDPRICE,L_DISCOUNT,L_TAX,L_RETURNFLAG,L_LINESTATUS,L_SHIPDATE,L_COMMITDATE,L_RECEIPTDATE,L_SHIPINSTRUCT,L_SHIPMODE,L_COMMENT)
from :'lineitem_file' with delimiter '|';
+copy co_nation (N_NATIONKEY ,N_NAME, N_REGIONKEY,N_COMMENT) from
:'nation_file' with delimiter '|';
+copy co_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from :'order_small_file' with delimiter '|';
+copy co_orders (
O_ORDERKEY,O_CUSTKEY,O_ORDERSTATUS,O_TOTALPRICE,O_ORDERDATE,O_ORDERPRIORITY,O_CLERK,O_SHIPPRIORITY,O_COMMENT)
from :'order_file' with delimiter '|';
+copy co_part
(P_PARTKEY,P_NAME,P_MFGR,P_BRAND,P_TYPE,P_SIZE,P_CONTAINER,P_RETAILPRICE,P_COMMENT)
from :'part_file' with delimiter '|';
+copy co_partsupp (PS_PARTKEY,PS_SUPPKEY,PS_AVAILQTY,PS_SUPPLYCOST,PS_COMMENT )
from :'partsupp_file' with delimiter '|';
+copy co_region ( R_REGIONKEY,R_NAME,R_COMMENT) from :'region_file' with
delimiter '|';
+copy co_supplier
(S_SUPPKEY,S_NAME,S_ADDRESS,S_NATIONKEY,S_PHONE,S_ACCTBAL,S_COMMENT) from
:'supplier_file' with delimiter '|';
ANALYZE co_customer;
ANALYZE co_lineitem;
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
