tuhaihe commented on code in PR #1522:
URL: https://github.com/apache/cloudberry/pull/1522#discussion_r2685666557
##########
src/test/binary_swap/sql/upgrading_compatibility/create_table.sql:
##########
@@ -0,0 +1,48 @@
+DROP TABLE IF EXISTS sales_heap;
+CREATE TABLE IF NOT EXISTS sales_heap
+(
+ product_id INT,
+ is_audited BOOLEAN DEFAULT FALSE,
+ quantity SMALLINT,
+ total_sales BIGINT,
+ unit_price REAL,
+ discount DOUBLE PRECISION,
+ description TEXT,
+ sale_date TIMESTAMP,
+ order_date DATE,
+ status CHAR(10),
+ customer_name VARCHAR(20),
+ price DECIMAL(20, 10)
+) DISTRIBUTED BY (product_id);
+
+---
+
+DROP TABLE IF EXISTS sales_partition_heap;
+CREATE TABLE IF NOT EXISTS sales_partition_heap
+(
+ product_id INT,
+ is_audited BOOLEAN DEFAULT FALSE,
+ quantity SMALLINT,
+ total_sales BIGINT,
+ unit_price REAL,
+ discount DOUBLE PRECISION,
+ description TEXT,
+ sale_date TIMESTAMP,
+ order_date DATE,
+ status CHAR(10),
+ customer_name VARCHAR(20),
+ price DECIMAL(20, 10)
+) DISTRIBUTED BY (product_id)
+PARTITION BY LIST (status);
+
+CREATE TABLE sales_partition_heap_part1
+PARTITION OF sales_partition_heap
+FOR VALUES IN ('Cancelled');
+
+CREATE TABLE sales_partition_heap_part2
+PARTITION OF sales_partition_heap
+FOR VALUES IN ('Closed');
+
+CREATE TABLE sales_partition_heap_part3
+PARTITION OF sales_partition_heap
+FOR VALUES IN ('Processing');
Review Comment:
Now we have added these tests.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
