You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by tu...@apache.org on 2022/04/03 11:04:04 UTC
[shardingsphere] branch master updated: Support PostgreSQL/openGauss insert select statement parse and execute (#16570)
This is an automated email from the ASF dual-hosted git repository.
tuichenchuxin pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new fc1de2f Support PostgreSQL/openGauss insert select statement parse and execute (#16570)
fc1de2f is described below
commit fc1de2fd3476a7ebf8368c297586361e799d2dee
Author: Zhengqiang Duan <du...@apache.org>
AuthorDate: Sun Apr 3 19:02:26 2022 +0800
Support PostgreSQL/openGauss insert select statement parse and execute (#16570)
---
.../dml/impl/ShardingInsertStatementValidator.java | 3 +-
.../dml/ShardingInsertStatementValidatorTest.java | 2 +-
.../impl/OpenGaussStatementSQLVisitor.java | 8 +-
.../impl/PostgreSQLStatementSQLVisitor.java | 8 +-
.../main/resources/sql/supported/dml/insert.xml | 4 +-
.../main/resources/sql/unsupported/unsupported.xml | 334 ---------------------
6 files changed, 17 insertions(+), 342 deletions(-)
diff --git a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/route/engine/validator/dml/impl/ShardingInsertStatementValidator.java b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/route/engine/validator/dml/impl/ShardingInsertStatementValidator.java
index ac3bfd3..9506eec 100644
--- a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/route/engine/validator/dml/impl/ShardingInsertStatementValidator.java
+++ b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/route/engine/validator/dml/impl/ShardingInsertStatementValidator.java
@@ -63,7 +63,8 @@ public final class ShardingInsertStatementValidator extends ShardingDMLStatement
throw new ShardingSphereException("INSERT INTO ... SELECT can not support applying keyGenerator to absent generateKeyColumn.");
}
TablesContext tablesContext = sqlStatementContext.getTablesContext();
- if (insertSelectSegment.isPresent() && !isAllSameTables(tablesContext.getTableNames()) && !shardingRule.isAllBindingTables(tablesContext.getTableNames())) {
+ if (insertSelectSegment.isPresent() && shardingRule.tableRuleExists(tablesContext.getTableNames())
+ && !isAllSameTables(tablesContext.getTableNames()) && !shardingRule.isAllBindingTables(tablesContext.getTableNames())) {
throw new ShardingSphereException("The table inserted and the table selected must be the same or bind tables.");
}
}
diff --git a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/test/java/org/apache/shardingsphere/sharding/route/engine/validator/dml/ShardingInsertStatementValidatorTest.java b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/test/java/org/apache/shardingsphere/sharding/route/engine/validator/dml/ShardingInsertStatementValidatorTest.java
index 77f0891..2479e70 100644
--- a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/test/java/org/apache/shardingsphere/sharding/route/engine/validator/dml/ShardingInsertStatementValidatorTest.java
+++ b/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/test/java/org/apache/shardingsphere/sharding/route/engine/validator/dml/ShardingInsertStatementValidatorTest.java
@@ -121,6 +121,7 @@ public final class ShardingInsertStatementValidatorTest {
when(shardingRule.isGenerateKeyColumn("id", "user")).thenReturn(true);
TablesContext multiTablesContext = createMultiTablesContext();
when(shardingRule.isAllBindingTables(multiTablesContext.getTableNames())).thenReturn(false);
+ when(shardingRule.tableRuleExists(multiTablesContext.getTableNames())).thenReturn(true);
SQLStatementContext<InsertStatement> sqlStatementContext = createInsertStatementContext(Collections.singletonList(1), createInsertSelectStatement());
sqlStatementContext.getTablesContext().getTableNames().addAll(multiTablesContext.getTableNames());
new ShardingInsertStatementValidator(shardingConditions).preValidate(shardingRule, sqlStatementContext, Collections.emptyList(), mock(ShardingSphereSchema.class));
@@ -131,7 +132,6 @@ public final class ShardingInsertStatementValidatorTest {
when(shardingRule.findGenerateKeyColumnName("user")).thenReturn(Optional.of("id"));
when(shardingRule.isGenerateKeyColumn("id", "user")).thenReturn(true);
TablesContext multiTablesContext = createMultiTablesContext();
- when(shardingRule.isAllBindingTables(multiTablesContext.getTableNames())).thenReturn(true);
SQLStatementContext<InsertStatement> sqlStatementContext = createInsertStatementContext(Collections.singletonList(1), createInsertSelectStatement());
sqlStatementContext.getTablesContext().getTableNames().addAll(multiTablesContext.getTableNames());
new ShardingInsertStatementValidator(shardingConditions).preValidate(shardingRule, sqlStatementContext, Collections.emptyList(), mock(ShardingSphereSchema.class));
diff --git a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-opengauss/src/main/java/org/apache/shardingsphere/sql/parser/opengauss/visitor/statement/impl/OpenGaussStatementSQLVisitor.java b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-opengauss/src/main/java/org/apache/shardingsphere/sql/parser/opengauss/visitor/statement/impl/OpenGaussStatementSQLVisitor.java
index ee85ec5..79a5563 100644
--- a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-opengauss/src/main/java/org/apache/shardingsphere/sql/parser/opengauss/visitor/statement/impl/OpenGaussStatementSQLVisitor.java
+++ b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-opengauss/src/main/java/org/apache/shardingsphere/sql/parser/opengauss/visitor/statement/impl/OpenGaussStatementSQLVisitor.java
@@ -638,8 +638,12 @@ public abstract class OpenGaussStatementSQLVisitor extends OpenGaussStatementBas
result.setInsertColumns(new InsertColumnsSegment(ctx.start.getStartIndex() - 1, ctx.start.getStartIndex() - 1, Collections.emptyList()));
}
ValuesClauseContext valuesClause = ctx.select().selectNoParens().selectClauseN().simpleSelect().valuesClause();
- Collection<InsertValuesSegment> insertValuesSegments = createInsertValuesSegments(valuesClause);
- result.getValues().addAll(insertValuesSegments);
+ if (null != valuesClause) {
+ result.getValues().addAll(createInsertValuesSegments(valuesClause));
+ } else {
+ OpenGaussSelectStatement selectStatement = (OpenGaussSelectStatement) visit(ctx.select());
+ result.setInsertSelect(new SubquerySegment(ctx.select().start.getStartIndex(), ctx.select().stop.getStopIndex(), selectStatement));
+ }
return result;
}
diff --git a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/java/org/apache/shardingsphere/sql/parser/postgresql/visitor/statement/impl/PostgreSQLStatementSQLVisitor.java b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/java/org/apache/shardingsphere/sql/parser/postgresql/visitor/statement/impl/PostgreSQLStatementSQLVisitor.java
index 35f7679..7efc053 100644
--- a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/java/org/apache/shardingsphere/sql/parser/postgresql/visitor/statement/impl/PostgreSQLStatementSQLVisitor.java
+++ b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-postgresql/src/main/java/org/apache/shardingsphere/sql/parser/postgresql/visitor/statement/impl/PostgreSQLStatementSQLVisitor.java
@@ -632,8 +632,12 @@ public abstract class PostgreSQLStatementSQLVisitor extends PostgreSQLStatementP
result.setInsertColumns(new InsertColumnsSegment(ctx.start.getStartIndex() - 1, ctx.start.getStartIndex() - 1, Collections.emptyList()));
}
ValuesClauseContext valuesClause = ctx.select().selectNoParens().selectClauseN().simpleSelect().valuesClause();
- Collection<InsertValuesSegment> insertValuesSegments = createInsertValuesSegments(valuesClause);
- result.getValues().addAll(insertValuesSegments);
+ if (null != valuesClause) {
+ result.getValues().addAll(createInsertValuesSegments(valuesClause));
+ } else {
+ PostgreSQLSelectStatement selectStatement = (PostgreSQLSelectStatement) visit(ctx.select());
+ result.setInsertSelect(new SubquerySegment(ctx.select().start.getStartIndex(), ctx.select().stop.getStopIndex(), selectStatement));
+ }
return result;
}
diff --git a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dml/insert.xml b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dml/insert.xml
index 293a22c..5dba9f0 100644
--- a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dml/insert.xml
+++ b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/dml/insert.xml
@@ -56,8 +56,8 @@
<sql-case id="insert_on_duplicate_key_update_with_base64_aes_encrypt" value="INSERT INTO t_order SET order_id = ?, user_id = ?, status = convert(to_base64(aes_encrypt(?, 'key')) USING utf8) ON DUPLICATE KEY UPDATE status = VALUES(status)" db-types="MySQL" />
<sql-case id="insert_all_with_all_placeholders" value="INSERT ALL INTO t_order (order_id, user_id, status) VALUES (?, ?, ?) INTO t_order (order_id, user_id, status) VALUES (?, ?, ?) INTO t_order (order_id, user_id, status) VALUES (?, ?, ?) SELECT * FROM dual" db-types="Oracle"/>
<sql-case id="insert_with_str_date_add" value="INSERT INTO t_order(present_date, order_id, user_id) VALUES (date_add(now(),interval ? second), ?, ?)" db-types="MySQL" />
- <sql-case id="insert_select_with_all_columns" value="INSERT INTO t_order (order_id, user_id, status) SELECT order_id, user_id, status FROM t_order WHERE order_id = ?" db-types="MySQL" />
- <sql-case id="insert_select_without_columns" value="INSERT INTO t_order SELECT order_id, user_id, status FROM t_order WHERE order_id = ?" db-types="MySQL" />
+ <sql-case id="insert_select_with_all_columns" value="INSERT INTO t_order (order_id, user_id, status) SELECT order_id, user_id, status FROM t_order WHERE order_id = ?" db-types="MySQL,PostgreSQL,openGauss" />
+ <sql-case id="insert_select_without_columns" value="INSERT INTO t_order SELECT order_id, user_id, status FROM t_order WHERE order_id = ?" db-types="MySQL,PostgreSQL,openGauss" />
<sql-case id="insert_select_with_generate_key_column" value="INSERT INTO t_order_item(item_id, order_id, user_id, status, creation_date) SELECT item_id, order_id, user_id, 'insert', '2017-08-08' FROM t_order_item WHERE item_id = ?" db-types="MySQL" />
<sql-case id="insert_select_without_generate_key_column" value="INSERT INTO t_order_item(order_id, user_id, status, creation_date) SELECT order_id, user_id, 'insert', '2017-08-08' FROM t_order_item WHERE order_id = ?" db-types="MySQL" />
<sql-case id="insert_select_on_duplicate_key_update" value="INSERT INTO t_order(order_id, user_id, status) SELECT order_id, user_id, status FROM t_order WHERE order_id = ? ON DUPLICATE KEY UPDATE status = VALUES(status)" db-types="MySQL" />
diff --git a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/unsupported/unsupported.xml b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/unsupported/unsupported.xml
index 9b81a5d..fcec6047 100644
--- a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/unsupported/unsupported.xml
+++ b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/unsupported/unsupported.xml
@@ -5630,12 +5630,10 @@
<sql-case id="explain_by_postgresql_source_test_case113" value="EXPLAIN (COSTS OFF) SELECT rank() OVER (ORDER BY b <-> point '123,456') n, b <-> point '123,456' dist, id FROM quad_box_tbl;" db-types="PostgreSQL"/>
<sql-case id="explain_by_postgresql_source_test_case114" value="EXPLAIN (COSTS OFF) SELECT rank() OVER (ORDER BY p <-> point '123,456') n, p <-> point '123,456' dist, id FROM quad_poly_tbl WHERE p <@ polygon '((300,300),(400,600),(600,500),(700,200))';" db-types="PostgreSQL"/>
<sql-case id="explain_by_postgresql_source_test_case115" value="EXPLAIN (COSTS OFF) UPDATE current_check SET payload = payload WHERE CURRENT OF current_check_cursor;" db-types="PostgreSQL"/>
- <sql-case id="explain_by_postgresql_source_test_case116" value="EXPLAIN (VERBOSE, COSTS OFF) INSERT INTO rls_tbl SELECT * FROM (SELECT b, c FROM rls_tbl ORDER BY a) ss;" db-types="PostgreSQL"/>
<sql-case id="explain_by_postgresql_source_test_case117" value="EXPLAIN (VERBOSE, COSTS OFF) UPDATE update_test t SET (a, b) = (SELECT b, a FROM update_test s WHERE s.a = t.a) WHERE CURRENT_USER = SESSION_USER;" db-types="PostgreSQL"/>
<sql-case id="explain_by_postgresql_source_test_case118" value="EXPLAIN (costs off) CREATE MATERIALIZED VIEW mvtest_tm AS SELECT type, sum(amt) AS totamt FROM mvtest_t GROUP BY type WITH NO DATA;" db-types="PostgreSQL"/>
<sql-case id="explain_by_postgresql_source_test_case119" value="EXPLAIN (costs off) CREATE MATERIALIZED VIEW mvtest_tvm AS SELECT * FROM mvtest_tv ORDER BY type;" db-types="PostgreSQL"/>
<sql-case id="explain_by_postgresql_source_test_case120" value="EXPLAIN (costs off) CREATE MATERIALIZED VIEW mvtest_tvvm AS SELECT * FROM mvtest_tvv;" db-types="PostgreSQL"/>
- <sql-case id="explain_by_postgresql_source_test_case121" value="EXPLAIN (costs off) WITH data(hat_name, hat_color) AS MATERIALIZED ( VALUES ('h8', 'green'), ('h9', 'blue'), ('h7', 'forbidden') ) INSERT INTO hats SELECT * FROM data RETURNING *;" db-types="PostgreSQL"/>
<sql-case id="fetch_by_postgresql_source_test_case1" value="FETCH 1 FROM c1;" db-types="PostgreSQL"/>
<sql-case id="fetch_by_postgresql_source_test_case2" value="FETCH 1 FROM c1;" db-types="PostgreSQL"/>
<sql-case id="fetch_by_postgresql_source_test_case3" value="FETCH 1 FROM c1;" db-types="PostgreSQL"/>
@@ -5818,20 +5816,6 @@
<sql-case id="insert_by_postgresql_source_test_case14" value="INSERT INTO LINE_TBL VALUES (line(point '(1,0)', point '(1,0)'));" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case15" value="INSERT INTO LINE_TBL VALUES (line(point '(3,1)', point '(3,2)'));" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case16" value="INSERT INTO LSEG_TBL VALUES (lseg(point(11, 22), point(33,44)));" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case17" value="INSERT INTO RANDOM_TBL (random) SELECT count(*) FROM onek WHERE random() < 1.0/10;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case18" value="INSERT INTO RANDOM_TBL (random) SELECT count(*) FROM onek WHERE random() < 1.0/10;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case19" value="INSERT INTO RANDOM_TBL (random) SELECT count(*) FROM onek WHERE random() < 1.0/10;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case20" value="INSERT INTO T SELECT * FROM generate_series(1, 10) a;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case21" value="INSERT INTO T SELECT b, b - 10 FROM generate_series(11, 20) a(b);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case22" value="INSERT INTO T SELECT b, b - 10, (b + 10)::text FROM generate_series(21, 30) a(b);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case23" value="INSERT INTO TEMP_FLOAT (f1) SELECT float8(f1) FROM INT2_TBL;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case24" value="INSERT INTO TEMP_FLOAT (f1) SELECT float8(f1) FROM INT4_TBL;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case25" value="INSERT INTO TEMP_GROUP SELECT 1, (- i.f1), (- f.f1) FROM INT4_TBL i, FLOAT8_TBL f;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case26" value="INSERT INTO TEMP_GROUP SELECT 2, i.f1, f.f1 FROM INT4_TBL i, FLOAT8_TBL f;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case27" value="INSERT INTO TEMP_INT2 (f1) SELECT int2(f1) FROM FLOAT8_TBL WHERE (f1 >= -32767) AND (f1 <= 32767);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case28" value="INSERT INTO TEMP_INT2 (f1) SELECT int2(f1) FROM INT4_TBL WHERE (f1 >= -32767) AND (f1 <= 32767);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case29" value="INSERT INTO TEMP_INT4 (f1) SELECT int4(f1) FROM FLOAT8_TBL WHERE (f1 > -2147483647) AND (f1 < 2147483647);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case30" value="INSERT INTO TEMP_INT4 (f1) SELECT int4(f1) FROM INT2_TBL;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case31" value="INSERT INTO VARBIT_SHIFT_TABLE SELECT CAST(v || B'0' AS BIT VARYING(6)) >>1 FROM VARBIT_SHIFT_TABLE;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case32" value="INSERT INTO VARBIT_SHIFT_TABLE SELECT CAST(v || B'00' AS BIT VARYING(8)) >>2 FROM VARBIT_SHIFT_TABLE;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case33" value="INSERT INTO VARBIT_SHIFT_TABLE SELECT CAST(v || B'0000' AS BIT VARYING(12)) >>4 FROM VARBIT_SHIFT_TABLE;" db-types="PostgreSQL"/>
@@ -5842,101 +5826,25 @@
<sql-case id="insert_by_postgresql_source_test_case38" value="INSERT INTO VARBIT_TABLE VALUES (B'01010101010');" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case39" value="INSERT INTO VARBIT_TABLE VALUES (B'101011111010');" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case40" value="INSERT INTO ab1 SELECT generate_series(1,10), generate_series(1,10), generate_series('2020-10-01'::timestamp, '2020-10-10'::timestamp, interval '1 day'), generate_series('2020-10-01'::timestamptz, '2020-10-10'::timestamptz, interval '1 day');" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case41" value="INSERT INTO ab1 SELECT a, a%23 FROM generate_series(1, 1000) a;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case42" value="INSERT INTO abbrev_abort_uuids (abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing) SELECT ('00000000-0000-0000-0000-'||to_char(g.i, '000000000000FM'))::uuid abort_increasing, ('00000000-0000-0000-0000-'||to_char(20000 - g.i, '000000000000FM'))::uuid abort_decreasing, (to_char(g.i % 10009, '00000000FM')||'-0000-0000-0 [...]
- <sql-case id="insert_by_postgresql_source_test_case43" value="INSERT INTO abbrev_abort_uuids (abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing) SELECT abort_increasing, abort_decreasing, noabort_increasing, noabort_decreasing FROM abbrev_abort_uuids WHERE (id < 10 OR id > 19990) AND id % 3 = 0 AND abort_increasing is not null;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case44" value="INSERT INTO abbrev_abort_uuids DEFAULT VALUES;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case45" value="INSERT INTO abbrev_abort_uuids DEFAULT VALUES;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case46" value="INSERT INTO alpha_neg SELECT -1.0, i, to_char(i % 10, 'FM0000') FROM generate_series(100, 399) i WHERE i % 10 IN (1, 3, 4, 6, 8, 9);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case47" value="INSERT INTO alpha_pos SELECT 1.0, i, to_char(i % 10, 'FM0000') FROM generate_series(100, 399) i WHERE i % 10 IN (1, 3, 4, 6, 8, 9);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case48" value="INSERT INTO array_gin_test SELECT ARRAY[1, g%5, g] FROM generate_series(1, 10000) g;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case49" value="INSERT INTO arrtest (a, b[1:2], c, d[1:2]) VALUES ('{}', '{3,4}', '{foo,bar}', '{bar,foo}');" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case50" value="INSERT INTO arrtest (a, b[1:2][1:2], c, d, e, f, g) VALUES ('{11,12,23}', '{{3,4},{4,5}}', '{"foobar"}', '{{"elt1", "elt2"}}', '{"3.4", "6.7"}', '{"abc","abcde"}', '{"abc","abcde"}');" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case51" value="INSERT INTO arrtest (a[1:5], b[1:1][1:2][1:2], c, d, f, g) VALUES ('{1,2,3,4,5}', '{{{0,0},{1,2}}}', '{}', '{}', '{}', '{}');" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case52" value="INSERT INTO arrtest (b[1:2]) VALUES(now());" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case53" value="INSERT INTO arrtest (b[2]) VALUES(now());" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case54" value="INSERT INTO atest1 SELECT 1, b FROM atest1;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case55" value="INSERT INTO atest1 SELECT 1, b FROM atest1;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case56" value="INSERT INTO b SELECT 1 INTO f;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case57" value="INSERT INTO b1 (SELECT x, md5(x::text) FROM generate_series(-10,10) x);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case58" value="INSERT INTO base_tbl SELECT i, 'Row ' || i FROM generate_series(-2, 2) g(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case59" value="INSERT INTO base_tbl SELECT i, 'Row ' || i FROM generate_series(-2, 2) g(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case60" value="INSERT INTO base_tbl SELECT i, 'Row ' || i FROM generate_series(-2, 2) g(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case61" value="INSERT INTO base_tbl SELECT i, 'Row ' || i FROM generate_series(-2, 2) g(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case62" value="INSERT INTO base_tbl SELECT i, 'Row ' || i FROM generate_series(-2, 2) g(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case63" value="INSERT INTO base_tbl SELECT i, 'Row ' || i FROM generate_series(-2, 2) g(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case64" value="INSERT INTO base_tbl SELECT i/10.0 FROM generate_series(1,10) g(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case65" value="INSERT INTO base_tbl_child SELECT * FROM generate_series(1, 8);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case66" value="INSERT INTO base_tbl_parent SELECT * FROM generate_series(-8, -1);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case67" value="INSERT INTO beta_neg SELECT -1.0, i, to_char(i % 10, 'FM0000') FROM generate_series(100, 149) i WHERE i % 10 IN (2, 3, 4, 6, 7, 9);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case68" value="INSERT INTO beta_neg SELECT -1.0, i, to_char(i % 10, 'FM0000') FROM generate_series(200, 299) i WHERE i % 10 IN (2, 3, 4, 6, 7, 9);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case69" value="INSERT INTO beta_neg SELECT -1.0, i, to_char(i % 10, 'FM0000') FROM generate_series(350, 499) i WHERE i % 10 IN (2, 3, 4, 6, 7, 9);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case70" value="INSERT INTO beta_pos SELECT 1.0, i, to_char(i % 10, 'FM0000') FROM generate_series(100, 149) i WHERE i % 10 IN (2, 3, 4, 6, 7, 9);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case71" value="INSERT INTO beta_pos SELECT 1.0, i, to_char(i % 10, 'FM0000') FROM generate_series(200, 299) i WHERE i % 10 IN (2, 3, 4, 6, 7, 9);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case72" value="INSERT INTO beta_pos SELECT 1.0, i, to_char(i % 10, 'FM0000') FROM generate_series(350, 499) i WHERE i % 10 IN (2, 3, 4, 6, 7, 9);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case73" value="INSERT INTO bit_defaults DEFAULT VALUES;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case74" value="INSERT INTO bmscantest SELECT (r%53), (r%59), 'foooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo' FROM generate_series(1,70000) r;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case75" value="INSERT INTO box_temp SELECT box(point(i, i), point(i * 2, i * 2)) FROM generate_series(1, 50) AS i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case76" value="INSERT INTO brin_large_range SELECT i FROM generate_series(1,10000) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case77" value="INSERT INTO brin_test SELECT x/100,x%100 FROM generate_series(1,10000) x(x);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case78" value="INSERT INTO brin_test_bloom SELECT x/100,x%100 FROM generate_series(1,10000) x(x);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case79" value="INSERT INTO brin_test_multi SELECT x/100,x%100 FROM generate_series(1,10000) x(x);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case80" value="INSERT INTO brintest (inetcol, cidrcol, int4rangecol) SELECT inet 'fe80::6e40:8ff:fea9:8c46' + tenthous, cidr 'fe80::6e40:8ff:fea9:8c46' + tenthous, 'empty'::int4range FROM tenk1 ORDER BY thousand, tenthous LIMIT 25;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case81" value="INSERT INTO brintest SELECT repeat(stringu1, 42)::bytea, substr(stringu1, 1, 1)::"char", stringu1::name, 142857 * tenthous, thousand, twothousand, repeat(stringu1, 42), unique1::oid, format('(%s,%s)', tenthous, twenty)::tid, (four + 1.0)/(hundred+1), odd::float8 / (tenthous + 1), format('%s:00:%s:00:%s:00', to_hex(odd), to_hex(even), to_hex(hundred))::macaddr, inet '10.2.3.4&a [...]
<sql-case id="insert_by_postgresql_source_test_case82" value="INSERT INTO brintest SELECT repeat(stringu1, 8)::bytea, substr(stringu1, 1, 1)::"char", stringu1::name, 142857 * tenthous, thousand, twothousand, repeat(stringu1, 8), unique1::oid, format('(%s,%s)', tenthous, twenty)::tid, (four + 1.0)/(hundred+1), odd::float8 / (tenthous + 1), format('%s:00:%s:00:%s:00', to_hex(odd), to_hex(even), to_hex(hundred))::macaddr, inet '10.2.3.4/24& [...]
<sql-case id="insert_by_postgresql_source_test_case83" value="INSERT INTO brintest_2 VALUES (numrange(0, 2^1000::numeric));" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case84" value="INSERT INTO brintest_bloom (inetcol, cidrcol) SELECT inet 'fe80::6e40:8ff:fea9:8c46' + tenthous, cidr 'fe80::6e40:8ff:fea9:8c46' + tenthous FROM tenk1 ORDER BY thousand, tenthous LIMIT 25;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case85" value="INSERT INTO brintest_bloom SELECT repeat(stringu1, 42)::bytea, substr(stringu1, 1, 1)::"char", stringu1::name, 142857 * tenthous, thousand, twothousand, repeat(stringu1, 42), unique1::oid, (four + 1.0)/(hundred+1), odd::float8 / (tenthous + 1), format('%s:00:%s:00:%s:00', to_hex(odd), to_hex(even), to_hex(hundred))::macaddr, inet '10.2.3.4' + tenthous, cidr '10.2.3/24' + [...]
<sql-case id="insert_by_postgresql_source_test_case86" value="INSERT INTO brintest_bloom SELECT repeat(stringu1, 8)::bytea, substr(stringu1, 1, 1)::"char", stringu1::name, 142857 * tenthous, thousand, twothousand, repeat(stringu1, 8), unique1::oid, (four + 1.0)/(hundred+1), odd::float8 / (tenthous + 1), format('%s:00:%s:00:%s:00', to_hex(odd), to_hex(even), to_hex(hundred))::macaddr, inet '10.2.3.4/24' + tenthous, cidr '10.2.3/24' + [...]
- <sql-case id="insert_by_postgresql_source_test_case87" value="INSERT INTO brintest_multi (inetcol, cidrcol) SELECT inet 'fe80::6e40:8ff:fea9:8c46' + tenthous, cidr 'fe80::6e40:8ff:fea9:8c46' + tenthous FROM tenk1 ORDER BY thousand, tenthous LIMIT 25;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case88" value="INSERT INTO brintest_multi SELECT 142857 * tenthous, thousand, twothousand, unique1::oid, format('(%s,%s)', tenthous, twenty)::tid, (four + 1.0)/(hundred+1), odd::float8 / (tenthous + 1), format('%s:00:%s:00:%s:00', to_hex(odd), to_hex(even), to_hex(hundred))::macaddr, substr(md5(unique1::text), 1, 16)::macaddr8, inet '10.2.3.4' + tenthous, cidr '10.2.3/24' + tenthous, da [...]
<sql-case id="insert_by_postgresql_source_test_case89" value="INSERT INTO brintest_multi SELECT 142857 * tenthous, thousand, twothousand, unique1::oid, format('(%s,%s)', tenthous, twenty)::tid, (four + 1.0)/(hundred+1), odd::float8 / (tenthous + 1), format('%s:00:%s:00:%s:00', to_hex(odd), to_hex(even), to_hex(hundred))::macaddr, substr(md5(unique1::text), 1, 16)::macaddr8, inet '10.2.3.4/24' + tenthous, cidr '10.2.3/24' + tenthous, [...]
- <sql-case id="insert_by_postgresql_source_test_case90" value="INSERT INTO clstr_expression(a, b) SELECT g.i % 42, 'prefix'||g.i FROM generate_series(1, 133) g(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case91" value="INSERT INTO clstr_tst_s (b) SELECT b FROM clstr_tst_s;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case92" value="INSERT INTO clstr_tst_s (b) SELECT b FROM clstr_tst_s;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case93" value="INSERT INTO clstr_tst_s (b) SELECT b FROM clstr_tst_s;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case94" value="INSERT INTO clstr_tst_s (b) SELECT b FROM clstr_tst_s;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case95" value="INSERT INTO clstr_tst_s (b) SELECT b FROM clstr_tst_s;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case96" value="INSERT INTO cmdata1 SELECT large_val() || repeat('a', 4000);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case97" value="INSERT INTO cmdata2 SELECT large_val() || repeat('a', 4000);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case98" value="INSERT INTO cmmove3 SELECT * FROM cmdata1;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case99" value="INSERT INTO cmmove3 SELECT * FROM cmdata;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case100" value="INSERT INTO collate_test2 SELECT * FROM collate_test1;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case101" value="INSERT INTO collate_test3 SELECT * FROM collate_test1;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case102" value="INSERT INTO collate_test4 SELECT * FROM collate_test1;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case103" value="INSERT INTO collate_test5 SELECT * FROM collate_test1;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case104" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case105" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case106" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case107" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case108" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case109" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case110" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case111" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case112" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case113" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case114" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case115" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case116" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case117" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case118" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case119" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case120" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case121" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case122" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case123" value="INSERT INTO combocidtest SELECT 1 LIMIT 0;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case124" value="INSERT INTO copy_t (SELECT x, md5(x::text) FROM generate_series(0,10) x);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case125" value="INSERT INTO ctv_data SELECT 1, x, '*' || x FROM generate_series(1,10) x;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case126" value="INSERT INTO current_check_1 SELECT i, 'p' || i FROM generate_series(1,9) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case127" value="INSERT INTO current_check_2 SELECT i, 'P' || i FROM generate_series(10,19) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case128" value="INSERT INTO dedup_unique_test_table SELECT i FROM generate_series(0,450) i;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case129" value="INSERT INTO default_test DEFAULT VALUES;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case130" value="INSERT INTO delete_test_table SELECT i, 1, 2, 3 FROM generate_series(1,1000) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case131" value="INSERT INTO delete_test_table SELECT i, 1, 2, 3 FROM generate_series(1,80000) i;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case132" value="INSERT INTO domarrtest (testint4arr[1], testint4arr[3]) values (11,22);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case133" value="INSERT INTO expr_stats SELECT mod(i,10), md5(mod(i,10)::text), md5(mod(i,10)::text) FROM generate_series(1,1000) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case134" value="INSERT INTO expr_stats SELECT mod(i,10), mod(i,10), mod(i,10) FROM generate_series(1,1000) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case135" value="INSERT INTO expr_stats SELECT mod(i,10), mod(i,10), mod(i,10) FROM generate_series(1,1000) s(i);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case136" value="INSERT INTO f_star (class, a, c, e, f) VALUES ('f', 19, 'hi claire'::name, '-5'::int2, '(1,3),(2,4)'::polygon);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case137" value="INSERT INTO f_star (class, a, c, f) VALUES ('f', 21, 'hi marcel'::name, '(11,44),(22,55),(33,66)'::polygon);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case138" value="INSERT INTO f_star (class, a, e, f) VALUES ('f', 22, '-7'::int2, '(111,555),(222,666),(333,777),(444,888)'::polygon);" db-types="PostgreSQL"/>
@@ -5945,23 +5853,10 @@
<sql-case id="insert_by_postgresql_source_test_case141" value="INSERT INTO f_star (class, c, f) VALUES ('f', 'hi jeff'::name, '(111111,333333),(222222,444444)'::polygon);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case142" value="INSERT INTO f_star (class, e, f) VALUES ('f', '-11'::int2, '(1111111,3333333),(2222222,4444444)'::polygon);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case143" value="INSERT INTO f_star (class, f) VALUES ('f', '(11111111,33333333),(22222222,44444444)'::polygon);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case144" value="INSERT INTO fast_emp4000 SELECT * FROM slow_emp4000;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case145" value="INSERT INTO foo AS bar DEFAULT VALUES RETURNING *;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case146" value="INSERT INTO foo AS bar DEFAULT VALUES RETURNING bar.*;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case147" value="INSERT INTO foo AS bar DEFAULT VALUES RETURNING bar.f3;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case148" value="INSERT INTO foo AS bar DEFAULT VALUES RETURNING foo.*;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case149" value="INSERT INTO foo SELECT f1+10, f2, f3+99 FROM foo RETURNING *, f1+112 IN (SELECT q1 FROM int8_tbl) AS subplan, EXISTS(SELECT * FROM int4_tbl) AS initplan;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case150" value="INSERT INTO functional_dependencies (a, b, c, filler1) SELECT i, i, i, i FROM generate_series(1,5000) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case151" value="INSERT INTO functional_dependencies (a, b, c, filler1) SELECT mod(i, 5), mod(i, 7), mod(i, 11), i FROM generate_series(1,1000) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case152" value="INSERT INTO functional_dependencies (a, b, c, filler1) SELECT mod(i,100), mod(i,50), mod(i,25), i FROM generate_series(1,5000) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case153" value="INSERT INTO functional_dependencies_multi (a, b, c, d) SELECT mod(i,7), mod(i,7), mod(i,11), mod(i,11) FROM generate_series(1,5000) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case154" value="INSERT INTO hash_split_heap SELECT 1 FROM generate_series(1, 500) a;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case155" value="INSERT INTO hash_split_heap SELECT 1 FROM generate_series(1, 5000) a;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case156" value="INSERT INTO hash_split_heap SELECT a/2 FROM generate_series(1, 25000) a;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case157" value="INSERT INTO hobbies_r (name, person) SELECT 'basketball', p.name FROM person p WHERE p.name = 'joe' or p.name = 'sally';" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case158" value="INSERT INTO hobbies_r (name, person) SELECT 'posthacking', p.name FROM person* p WHERE p.name = 'mike' or p.name = 'jeff';" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case159" value="INSERT INTO idxpart (a, b, c) SELECT i, i, i FROM generate_series(1, 50) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case160" value="INSERT INTO ihighway SELECT * FROM road WHERE name ~ 'I- .*';" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case161" value="INSERT INTO inhf DEFAULT VALUES;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case162" value="INSERT INTO iportaltest (i, d, p) VALUES (1, 3.567, '(3.0,1.0),(4.0,2.0)'::polygon);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case163" value="INSERT INTO iportaltest (i, d, p) VALUES (2, 89.05, '(4.0,2.0),(3.0,1.0)'::polygon);" db-types="PostgreSQL"/>
@@ -5990,50 +5885,15 @@
<sql-case id="insert_by_postgresql_source_test_case186" value="INSERT INTO large_tuple_test (select 3, NULL);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case187" value="INSERT INTO large_tuple_test (select 4, repeat('a', 8126));" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case188" value="INSERT INTO main_table DEFAULT VALUES;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case189" value="INSERT INTO mcv_lists (a, b, c) SELECT 1, 2, 3 FROM generate_series(1,1000) s(i);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case190" value="INSERT INTO mcv_lists (a, b, c, d) SELECT (CASE WHEN mod(i,2) = 0 THEN NULL ELSE 'x' END), (CASE WHEN mod(i,2) = 0 THEN NULL ELSE 0 END), (CASE WHEN mod(i,2) = 0 THEN NULL ELSE 'x' END) FROM generate_series(1,5000) s(i);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case191" value="INSERT INTO mcv_lists (a, b, c, filler1) SELECT (CASE WHEN mod(i,100) = 1 THEN NULL ELSE mod(i,100) END), (CASE WHEN mod(i,50) = 1 THEN NULL ELSE mod(i,50) END), (CASE WHEN mod(i,25) = 1 THEN NULL ELSE mod(i,25) END), i FROM generate_series(1,5000) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case192" value="INSERT INTO mcv_lists (a, b, c, filler1) SELECT i, i, i, i FROM generate_series(1,1000) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case193" value="INSERT INTO mcv_lists (a, b, c, filler1) SELECT i, i, i, i FROM generate_series(1,1000) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case194" value="INSERT INTO mcv_lists (a, b, c, filler1) SELECT mod(i,100), mod(i,50), mod(i,25), i FROM generate_series(1,5000) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case195" value="INSERT INTO mcv_lists (a, b, c, filler1) SELECT mod(i,37), mod(i,41), mod(i,43), mod(i,47) FROM generate_series(1,5000) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case196" value="INSERT INTO mcv_lists_arrays (a, b, c) SELECT ARRAY[md5((i/100)::text), md5((i/100-1)::text), md5((i/100+1)::text)], ARRAY[(i/100-1)::numeric/1000, (i/100)::numeric/1000, (i/100+1)::numeric/1000], ARRAY[(i/100-1), i/100, (i/100+1)] FROM generate_series(1,5000) s(i);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case197" value="INSERT INTO mcv_lists_bool (a, b, c) SELECT (mod(i,2) = 0), (mod(i,4) = 0), (mod(i,8) = 0) FROM generate_series(1,10000) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case198" value="INSERT INTO mcv_lists_multi (a, b, c, d) SELECT mod(i,5), mod(i,5), mod(i,7), mod(i,7) FROM generate_series(1,5000) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case199" value="INSERT INTO mcv_lists_partial (a, b, c) SELECT i, i, i FROM generate_series(0,3999) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case200" value="INSERT INTO mcv_lists_partial (a, b, c) SELECT i, i, i FROM generate_series(0,99) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case201" value="INSERT INTO mcv_lists_partial (a, b, c) SELECT mod(i,10), mod(i,10), mod(i,10) FROM generate_series(0,999) s(i);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case202" value="INSERT INTO mcv_lists_uuid (a, b, c) SELECT md5(mod(i,100)::text)::uuid, md5(mod(i,50)::text)::uuid, md5(mod(i,25)::text)::uuid FROM generate_series(1,5000) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case203" value="INSERT INTO mvtest_foo SELECT * FROM mvtest_foo;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case204" value="INSERT INTO ndistinct (a, b, c, d) SELECT mod(i,3), mod(i,9), mod(i,5), mod(i,20) FROM generate_series(1,1000) s(i);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case205" value="INSERT INTO ndistinct (a, b, c, filler1) SELECT i/100, i/100, i/100, cash_words((i/100)::money) FROM generate_series(1,1000) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case206" value="INSERT INTO ndistinct (a, b, c, filler1) SELECT mod(i,13), mod(i,17), mod(i,19), cash_words(mod(i,23)::int::money) FROM generate_series(1,1000) s(i);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case207" value="INSERT INTO nulltest DEFAULT VALUES;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case208" value="INSERT INTO num_result SELECT id, 0, LN(ABS(val)) FROM num_data WHERE val != '0.0';" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case209" value="INSERT INTO num_result SELECT id, 0, LN(ABS(val)) FROM num_data WHERE val != '0.0';" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case210" value="INSERT INTO num_result SELECT id, 0, LOG('10'::numeric, ABS(val)) FROM num_data WHERE val != '0.0';" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case211" value="INSERT INTO num_result SELECT id, 0, LOG(numeric '10', ABS(val)) FROM num_data WHERE val != '0.0';" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case212" value="INSERT INTO num_result SELECT id, 0, POW(numeric '10', LN(ABS(round(val,1000)))) FROM num_data WHERE val != '0.0';" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case213" value="INSERT INTO num_result SELECT id, 0, POWER(numeric '10', LN(ABS(round(val,200)))) FROM num_data WHERE val != '0.0';" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case214" value="INSERT INTO num_result SELECT id, 0, SQRT(ABS(val)) FROM num_data;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case215" value="INSERT INTO num_result SELECT id, 0, SQRT(ABS(val)) FROM num_data;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case216" value="INSERT INTO num_result SELECT t1.id, t2.id, round(t1.val * t2.val, 30) FROM num_data t1, num_data t2;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case217" value="INSERT INTO num_result SELECT t1.id, t2.id, round(t1.val * t2.val, 30) FROM num_data t1, num_data t2;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case218" value="INSERT INTO num_result SELECT t1.id, t2.id, round(t1.val + t2.val, 10) FROM num_data t1, num_data t2;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case219" value="INSERT INTO num_result SELECT t1.id, t2.id, round(t1.val + t2.val, 10) FROM num_data t1, num_data t2;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case220" value="INSERT INTO num_result SELECT t1.id, t2.id, round(t1.val - t2.val, 40) FROM num_data t1, num_data t2;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case221" value="INSERT INTO num_result SELECT t1.id, t2.id, round(t1.val - t2.val, 40) FROM num_data t1, num_data t2;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case222" value="INSERT INTO num_result SELECT t1.id, t2.id, round(t1.val / t2.val, 80) FROM num_data t1, num_data t2 WHERE t2.val != '0.0';" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case223" value="INSERT INTO num_result SELECT t1.id, t2.id, round(t1.val / t2.val, 80) FROM num_data t1, num_data t2 WHERE t2.val != '0.0';" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case224" value="INSERT INTO num_result SELECT t1.id, t2.id, t1.val * t2.val FROM num_data t1, num_data t2;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case225" value="INSERT INTO num_result SELECT t1.id, t2.id, t1.val * t2.val FROM num_data t1, num_data t2;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case226" value="INSERT INTO num_result SELECT t1.id, t2.id, t1.val + t2.val FROM num_data t1, num_data t2;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case227" value="INSERT INTO num_result SELECT t1.id, t2.id, t1.val + t2.val FROM num_data t1, num_data t2;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case228" value="INSERT INTO num_result SELECT t1.id, t2.id, t1.val - t2.val FROM num_data t1, num_data t2;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case229" value="INSERT INTO num_result SELECT t1.id, t2.id, t1.val - t2.val FROM num_data t1, num_data t2;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case230" value="INSERT INTO num_result SELECT t1.id, t2.id, t1.val / t2.val FROM num_data t1, num_data t2 WHERE t2.val != '0.0';" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case231" value="INSERT INTO num_result SELECT t1.id, t2.id, t1.val / t2.val FROM num_data t1, num_data t2 WHERE t2.val != '0.0';" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case232" value="INSERT INTO num_variance SELECT 9e131071 + x FROM generate_series(1, 5) x;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case233" value="INSERT INTO nummultirange_test VALUES(nummultirange(numrange(1.1, 2.2)));" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case234" value="INSERT INTO nummultirange_test VALUES(nummultirange(numrange(1.7, 1.7, '[]'), numrange(1.7, 1.9)));" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case235" value="INSERT INTO nummultirange_test VALUES(nummultirange(numrange(1.7, 1.7, '[]'), numrange(1.9, 2.1)));" db-types="PostgreSQL"/>
@@ -6046,81 +5906,17 @@
<sql-case id="insert_by_postgresql_source_test_case242" value="INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case243" value="INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2));" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case244" value="INSERT INTO numrange_test2 VALUES(numrange(1.1, 2.2,'()'));" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case245" value="INSERT INTO pagg_tab SELECT i % 20, i % 30, to_char(i % 12, 'FM0000'), i % 30 FROM generate_series(0, 2999) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case246" value="INSERT INTO pagg_tab1 SELECT i % 30, i % 20 FROM generate_series(0, 299, 2) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case247" value="INSERT INTO pagg_tab2 SELECT i % 20, i % 30 FROM generate_series(0, 299, 3) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case248" value="INSERT INTO pagg_tab_m SELECT i % 30, i % 40, i % 50 FROM generate_series(0, 2999) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case249" value="INSERT INTO pagg_tab_ml SELECT i % 30, i % 10, to_char(i % 4, 'FM0000') FROM generate_series(0, 29999) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case250" value="INSERT INTO pagg_tab_para SELECT i % 30, i % 20 FROM generate_series(0, 29999) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case251" value="INSERT INTO pht1 SELECT i, i, to_char(i/50, 'FM0000') FROM generate_series(0, 599, 2) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case252" value="INSERT INTO pht1_e SELECT i, i, 'A' || to_char(i/50, 'FM0000') FROM generate_series(0, 299, 2) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case253" value="INSERT INTO pht2 SELECT i, i, to_char(i/50, 'FM0000') FROM generate_series(0, 599, 3) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case254" value="INSERT INTO plt1 SELECT i, i, to_char(i/50, 'FM0000') FROM generate_series(0, 599, 2) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case255" value="INSERT INTO plt1_adv SELECT i, i, to_char(i % 10, 'FM0000') FROM generate_series(1, 299) i WHERE i % 10 IN (1, 2, 3, 4, 5);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case256" value="INSERT INTO plt1_adv SELECT i, i, to_char(i % 10, 'FM0000') FROM generate_series(1, 299) i WHERE i % 10 IN (1, 3);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case257" value="INSERT INTO plt1_adv SELECT i, i, to_char(i % 10, 'FM0000') FROM generate_series(1, 299) i WHERE i % 10 IN (1, 3, 4, 6, 8, 9);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case258" value="INSERT INTO plt1_adv SELECT i, i, to_char(i % 5, 'FM0000') FROM generate_series(0, 24) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case259" value="INSERT INTO plt1_e SELECT i, i, 'A' || to_char(i/50, 'FM0000') FROM generate_series(0, 599, 2) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case260" value="INSERT INTO plt2 SELECT i, i, to_char(i/50, 'FM0000') FROM generate_series(0, 599, 3) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case261" value="INSERT INTO plt2_adv SELECT i, i, to_char(i % 10, 'FM0000') FROM generate_series(1, 299) i WHERE i % 10 IN (1, 2, 3, 4, 5);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case262" value="INSERT INTO plt2_adv SELECT i, i, to_char(i % 10, 'FM0000') FROM generate_series(1, 299) i WHERE i % 10 IN (1, 3);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case263" value="INSERT INTO plt2_adv SELECT i, i, to_char(i % 10, 'FM0000') FROM generate_series(1, 299) i WHERE i % 10 IN (2, 3, 4, 6, 7, 9);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case264" value="INSERT INTO plt2_adv SELECT i, i, to_char(i % 10, 'FM0000') FROM generate_series(1, 299) i WHERE i % 10 IN (4, 5, 6);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case265" value="INSERT INTO plt2_adv SELECT i, i, to_char(i % 10, 'FM0000') FROM generate_series(1, 299) i WHERE i % 10 IN (4, 6);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case266" value="INSERT INTO plt2_adv SELECT i, i, to_char(i % 10, 'FM0000') FROM generate_series(1, 299) i WHERE i % 10 IN (7, 9);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case267" value="INSERT INTO plt2_adv SELECT i, i, to_char(i % 5, 'FM0000') FROM generate_series(0, 24) i WHERE i % 5 IN (2, 3, 4);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case268" value="INSERT INTO plt3_adv SELECT i, i, to_char(i % 10, 'FM0000') FROM generate_series(1, 299) i WHERE i % 10 IN (4, 6, 7, 9);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case269" value="INSERT INTO plt3_adv SELECT i, i, to_char(i % 5, 'FM0000') FROM generate_series(0, 24) i WHERE i % 5 IN (1, 3, 4);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case270" value="INSERT INTO point_gist_tbl SELECT '(0,0)' FROM generate_series(0,1000);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case271" value="INSERT INTO point_tbl(f1[0]) VALUES(0) RETURNING *;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case272" value="INSERT INTO prt1 SELECT i, i % 25, to_char(i, 'FM0000') FROM generate_series(0, 599) i WHERE i % 2 = 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case273" value="INSERT INTO prt1_adv SELECT i, i % 25, to_char(i, 'FM0000') FROM generate_series(100, 399) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case274" value="INSERT INTO prt1_adv SELECT i, i % 25, to_char(i, 'FM0000') FROM generate_series(100, 399) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case275" value="INSERT INTO prt1_e SELECT i, i, i % 25 FROM generate_series(0, 599, 2) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case276" value="INSERT INTO prt1_l SELECT i, i % 25, to_char(i % 4, 'FM0000') FROM generate_series(0, 599, 2) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case277" value="INSERT INTO prt1_m SELECT i, i, i % 25 FROM generate_series(0, 599, 2) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case278" value="INSERT INTO prt1_n SELECT i, i, to_char(i, 'FM0000') FROM generate_series(0, 499, 2) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case279" value="INSERT INTO prt2 SELECT i % 25, i, to_char(i, 'FM0000') FROM generate_series(0, 599) i WHERE i % 3 = 0;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case280" value="INSERT INTO prt2_adv SELECT i % 25, i, to_char(i, 'FM0000') FROM generate_series(100, 399) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case281" value="INSERT INTO prt2_adv SELECT i % 25, i, to_char(i, 'FM0000') FROM generate_series(350, 499) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case282" value="INSERT INTO prt2_adv SELECT i % 25, i, to_char(i, 'FM0000') FROM generate_series(500, 599) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case283" value="INSERT INTO prt2_adv_p1 SELECT i % 25, i, to_char(i, 'FM0000') FROM generate_series(100, 149) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case284" value="INSERT INTO prt2_adv_p2 SELECT i % 25, i, to_char(i, 'FM0000') FROM generate_series(200, 299) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case285" value="INSERT INTO prt2_adv_p3 SELECT i % 25, i, to_char(i, 'FM0000') FROM generate_series(350, 499) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case286" value="INSERT INTO prt2_e SELECT i, i, i % 25 FROM generate_series(0, 599, 3) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case287" value="INSERT INTO prt2_l SELECT i % 25, i, to_char(i % 4, 'FM0000') FROM generate_series(0, 599, 3) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case288" value="INSERT INTO prt2_m SELECT i, i, i % 25 FROM generate_series(0, 599, 3) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case289" value="INSERT INTO prt2_n SELECT i, i, to_char(i/50, 'FM0000') FROM generate_series(0, 599, 2) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case290" value="INSERT INTO prt2_n SELECT i, i, to_char(i/50, 'FM0000') FROM generate_series(0, 599, 2) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case291" value="INSERT INTO prt3_adv SELECT i, i % 25, to_char(i, 'FM0000') FROM generate_series(200, 399) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case292" value="INSERT INTO prt4_n SELECT i, i, to_char(i, 'FM0000') FROM generate_series(0, 599, 2) i;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case293" value="INSERT INTO pvactst SELECT i, array[1,2,3], point(i, i+1) FROM generate_series(1,1000) i;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case294" value="INSERT INTO quad_box_tbl SELECT (x - 1) * 100 + y, box(point(x * 10, y * 10), point(x * 10 + 5, y * 10 + 5)) FROM generate_series(1, 100) x, generate_series(1, 100) y;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case295" value="INSERT INTO quad_box_tbl SELECT i, '((200, 300),(210, 310))' FROM generate_series(10001, 11000) AS i;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case296" value="INSERT INTO quad_point_tbl SELECT '(333.0,400.0)'::point FROM generate_series(1,1000);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case297" value="INSERT INTO quad_poly_tbl SELECT (x - 1) * 100 + y, polygon(circle(point(x * 10, y * 10), 1 + (x + y) % 10)) FROM generate_series(1, 100) x, generate_series(1, 100) y;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case298" value="INSERT INTO quad_poly_tbl SELECT i, polygon '((200, 300),(210, 310),(230, 290))' FROM generate_series(10001, 11000) AS i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case299" value="INSERT INTO r1 SELECT a + 1 FROM r2 RETURNING *;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case300" value="INSERT INTO radix_text_tbl SELECT 'P0123456789abcdef' FROM generate_series(1,1000);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case301" value="INSERT INTO ref_tbl SELECT * FROM generate_series(1,10);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case302" value="INSERT INTO reindex_before SELECT oid, 'pg_toast_TABLE', relfilenode, relkind, reltoastrelid FROM pg_class WHERE oid IN (SELECT reltoastrelid FROM reindex_before WHERE reltoastrelid > 0);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case303" value="INSERT INTO reindex_before SELECT oid, 'pg_toast_TABLE_index', relfilenode, relkind, reltoastrelid FROM pg_class where oid in (select indexrelid from pg_index where indrelid in (select reltoastrelid from reindex_before where reltoastrelid > 0));" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case304" value="INSERT INTO rls_tbl SELECT * FROM (SELECT b, c FROM rls_tbl ORDER BY a) ss;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case305" value="INSERT INTO rls_tbl SELECT 10, 20, 30;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case306" value="INSERT INTO rls_tbl SELECT x/10 FROM generate_series(1, 100) x;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case307" value="INSERT INTO s1 (SELECT x, md5(x::text) FROM generate_series(-10,10) x);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case308" value="INSERT INTO s2 (SELECT x, md5(x::text) FROM generate_series(-6,6) x);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case309" value="INSERT INTO serializable_update_tab SELECT a, repeat('xyzxz', 100), 'new' FROM generate_series(1, 50) a;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case310" value="INSERT INTO shighway SELECT * FROM road WHERE name ~ 'State Hwy.*';" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case311" value="INSERT INTO t DEFAULT VALUES;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case312" value="INSERT INTO t1 (SELECT x, md5(x::text) FROM generate_series(0,20) x);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case313" value="INSERT INTO t1 SELECT i,i,'t1' FROM generate_series(1,10) g(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case314" value="INSERT INTO t11 SELECT i,i,'t11','t11d' FROM generate_series(1,10) g(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case315" value="INSERT INTO t111 SELECT i,i,'t111','t111d','{1,1,1}'::int[] FROM generate_series(1,10) g(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case316" value="INSERT INTO t12 SELECT i,i,'t12','{1,2}'::int[] FROM generate_series(1,10) g(i);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case317" value="INSERT INTO t2 (SELECT * FROM t1);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case318" value="INSERT INTO table1 SELECT generate_series(1,400);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case319" value="INSERT INTO table2 SELECT generate_series(1,400), 'abc';" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case320" value="INSERT INTO tbl SELECT 1, 2, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case321" value="INSERT INTO tbl SELECT 1, 2, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case322" value="INSERT INTO tbl SELECT 1, 2, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL"/>
@@ -6131,9 +5927,6 @@
<sql-case id="insert_by_postgresql_source_test_case327" value="INSERT INTO tbl SELECT x, 2*x, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case328" value="INSERT INTO tbl SELECT x, 2*x, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case329" value="INSERT INTO tbl SELECT x, 2*x, 3*x, box('4,4,4,4') FROM generate_series(1,1000) AS x;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case330" value="INSERT INTO tbl SELECT x, 2*x, NULL, NULL FROM generate_series(1,10) AS x;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case331" value="INSERT INTO tbl SELECT x, 2*x, NULL, NULL FROM generate_series(1,10) AS x;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case332" value="INSERT INTO tbl SELECT x, 2*x, NULL, NULL FROM generate_series(1,300) AS x;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case333" value="INSERT INTO tbl_gist SELECT x, 2*x, 3*x, box(point(3*x,2*x),point(3*x+1,2*x+1)) FROM generate_series(1,10) AS x;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case334" value="INSERT INTO tbl_gist SELECT x, 2*x, 3*x, box(point(x,x+1),point(2*x,2*x+1)) FROM generate_series(1,10) AS x;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case335" value="INSERT INTO tbl_gist SELECT x, 2*x, 3*x, box(point(x,x+1),point(2*x,2*x+1)) FROM generate_series(1,10) AS x;" db-types="PostgreSQL"/>
@@ -6148,22 +5941,13 @@
<sql-case id="insert_by_postgresql_source_test_case344" value="INSERT INTO tbl_include_reg SELECT x, 2*x, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case345" value="INSERT INTO tbl_include_unique1 SELECT x, 2*x, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case346" value="INSERT INTO tbl_include_unique2 SELECT 1, 2, 3*x, box('4,4,4,4') FROM generate_series(1,10) AS x;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case347" value="INSERT INTO tenk2 SELECT * FROM tenk1;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case348" value="INSERT INTO test6 VALUES (1, U&'\00E4bc');" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case349" value="INSERT INTO test6 VALUES (2, U&'\0061\0308bc');" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case350" value="INSERT INTO test6a VALUES (1, ARRAY[U&'\00E4bc']);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case351" value="INSERT INTO test6a VALUES (2, ARRAY[U&'\0061\0308bc']);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case352" value="INSERT INTO test_mark_restore(col1, col2, col12) SELECT a.i, b.i, a.i * b.i FROM generate_series(1, 500) a(i), generate_series(1, 5) b(i);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case353" value="INSERT INTO test_ns_schema_1.abc DEFAULT VALUES;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case354" value="INSERT INTO test_ns_schema_1.abc DEFAULT VALUES;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case355" value="INSERT INTO test_ns_schema_1.abc DEFAULT VALUES;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case356" value="INSERT INTO test_tablesample SELECT i, repeat(i::text, 200) FROM generate_series(0, 9) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case357" value="INSERT INTO tidrangescan SELECT i,repeat('x', 100) FROM generate_series(1,200) AS s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case358" value="INSERT INTO transition_table_level1 (level1_no) SELECT generate_series(1,200);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case359" value="INSERT INTO transition_table_level1(level1_no) SELECT generate_series(201,1000);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case360" value="INSERT INTO transition_table_level2 (level2_no, parent_no) SELECT level2_no, level2_no / 50 + 1 AS parent_no FROM generate_series(1,9999) level2_no;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case361" value="INSERT INTO transition_table_status (level, node_no, status) SELECT 1, level1_no, 0 FROM transition_table_level1;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case362" value="INSERT INTO transition_table_status (level, node_no, status) SELECT 2, level2_no, 0 FROM transition_table_level2;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case363" value="INSERT INTO trunc_stats_test DEFAULT VALUES;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case364" value="INSERT INTO trunc_stats_test DEFAULT VALUES;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case365" value="INSERT INTO trunc_stats_test DEFAULT VALUES;" db-types="PostgreSQL"/>
@@ -6198,37 +5982,6 @@
<sql-case id="insert_by_postgresql_source_test_case394" value="INSERT INTO truncate_b DEFAULT VALUES;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case395" value="INSERT INTO truncate_b DEFAULT VALUES;" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case396" value="INSERT INTO truncate_b DEFAULT VALUES;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case397" value="INSERT INTO tststats.priv_test_tbl SELECT mod(i,5), mod(i,10) FROM generate_series(1,100) s(i);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case398" value="INSERT INTO update_test SELECT a,b+1,c FROM update_test;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case399" value="INSERT INTO vacparted_i SELECT i, 'test_'|| i from generate_series(1,10) i;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case400" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case401" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case402" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case403" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case404" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case405" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case406" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case407" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case408" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case409" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case410" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case411" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case412" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case413" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case414" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case415" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case416" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case417" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case418" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case419" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case420" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case421" value="INSERT INTO vactst SELECT * FROM vactst;" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case422" value="INSERT INTO vactst SELECT generate_series(1, 300);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case423" value="INSERT INTO vactst SELECT generate_series(301, 400);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case424" value="INSERT INTO y SELECT generate_series(1, 10);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case425" value="INSERT INTO y SELECT generate_series(1, 10);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case426" value="INSERT INTO y SELECT generate_series(1, 10);" db-types="PostgreSQL"/>
- <sql-case id="insert_by_postgresql_source_test_case427" value="INSERT INTO y SELECT generate_series(1, 3);" db-types="PostgreSQL"/>
<sql-case id="insert_by_postgresql_source_test_case428" value="INSERT INTO y2 (SELECT x, md5(x::text) FROM generate_series(0,20) x);" db-types="PostgreSQL"/>
<sql-case id="listen_by_postgresql_source_test_case1" value="LISTEN foo_event;" db-types="PostgreSQL"/>
<sql-case id="listen_by_postgresql_source_test_case2" value="LISTEN notify_async2;" db-types="PostgreSQL"/>
@@ -7789,18 +7542,9 @@
<sql-case id="with_by_postgresql_source_test_case3" value="WITH RECURSIVE t(id, path) AS ( VALUES(1,ARRAY[]::integer[]) UNION ALL SELECT tree.id, t.path || tree.id FROM tree JOIN t ON (tree.parent_id = t.id) ) SELECT t1.id, count(t2.*) FROM t AS t1 JOIN t AS t2 ON (t1.path[1] = t2.path[1] AND array_upper(t1.path,1) = 1 AND array_upper(t2.path,1) > 1) GROUP BY t1.id ORDER BY t1.id;" db-types="PostgreSQL"/>
<sql-case id="with_by_postgresql_source_test_case4" value="WITH RECURSIVE t(id, path) AS ( VALUES(1,ARRAY[]::integer[]) UNION ALL SELECT tree.id, t.path || tree.id FROM tree JOIN t ON (tree.parent_id = t.id) ) SELECT t1.id, t2.path, t2 FROM t AS t1 JOIN t AS t2 ON (t1.id=t2.id);" db-types="PostgreSQL"/>
<sql-case id="with_by_postgresql_source_test_case5" value="WITH RECURSIVE t(n) AS ( VALUES (1::money) UNION SELECT n+1::money FROM t WHERE n < 100::money ) SELECT sum(n) FROM t;" db-types="PostgreSQL"/>
- <sql-case id="with_by_postgresql_source_test_case6" value="WITH data(hat_name, hat_color) AS MATERIALIZED ( VALUES ('h8', 'green'), ('h9', 'blue'), ('h7', 'forbidden') ) INSERT INTO hats SELECT * FROM data RETURNING *;" db-types="PostgreSQL"/>
<sql-case id="with_by_postgresql_source_test_case7" value="WITH objects (classid, objid, objsubid) AS (VALUES ('pg_class'::regclass, 0, ('pg_class'::regclass, 'pg_class'::regclass, 1 ('pg_proc'::regclass, 0, ('pg_type'::regclass, 0, ('pg_cast'::regclass, 0, ('pg_collation'::regclass, 0, ('pg_constraint'::regclass, 0, ('pg_conversion'::regclass, 0, ('pg_at [...]
<sql-case id="with_by_postgresql_source_test_case8" value="WITH objects (type, name, args) AS (VALUES ('table', '{addr_nsp, gentable}'::text[], '{}'::text[]), ('table', '{addr_nsp, parttable}'::text[], '{}'::text[]), ('index', '{addr_nsp, gentable_pkey}', '{}'), ('index', '{addr_nsp, parttable_pkey}', '{}'), ('sequence', '{addr_nsp [...]
- <sql-case id="with_by_postgresql_source_test_case9" value="WITH rand_value AS (SELECT string_agg(md5((-i)::text),'') AS val FROM generate_series(1,60) s(i)) INSERT INTO brintest_3 SELECT val, val, val, val FROM rand_value;" db-types="PostgreSQL"/>
- <sql-case id="with_by_postgresql_source_test_case10" value="WITH rand_value AS (SELECT string_agg(md5(i::text),'') AS val FROM generate_series(1,60) s(i)) INSERT INTO brintest_3 SELECT val, val, val, val FROM rand_value;" db-types="PostgreSQL"/>
<sql-case id="with_by_postgresql_source_test_case11" value="WITH str(j, num) AS ( SELECT jsonb_build_object('s', s), num FROM unnest('{"", "a", "ab", "abc", "abcd", "b", "A", "AB", "ABC", "ABc", "ABcD", "B"}'::text[]) WITH ORDINALITY AS a(s, num) ) SELECT s1.j, s2.j, jsonb_path_query_first(s1.j, '$.s < $s', vars => s2.j) lt, [...]
- <sql-case id="with_by_postgresql_source_test_case12" value="WITH t AS ( SELECT a FROM y ) INSERT INTO y SELECT a+20 FROM t RETURNING *;" db-types="PostgreSQL"/>
- <sql-case id="with_by_postgresql_source_test_case13" value="WITH t AS ( DELETE FROM y WHERE a <= 10 RETURNING * ) INSERT INTO y SELECT -a FROM t RETURNING *;" db-types="PostgreSQL"/>
- <sql-case id="with_by_postgresql_source_test_case14" value="WITH t1 AS ( DELETE FROM bug6051 RETURNING * ) INSERT INTO bug6051 SELECT * FROM t1;" db-types="PostgreSQL"/>
- <sql-case id="with_by_postgresql_source_test_case15" value="WITH t1 AS ( DELETE FROM bug6051 RETURNING * ) INSERT INTO bug6051 SELECT * FROM t1;" db-types="PostgreSQL"/>
- <sql-case id="with_by_postgresql_source_test_case16" value="WITH t1 AS ( DELETE FROM bug6051 RETURNING * ) INSERT INTO bug6051 SELECT * FROM t1;" db-types="PostgreSQL"/>
- <sql-case id="with_by_postgresql_source_test_case17" value="WITH t1 AS ( DELETE FROM bug6051_3 RETURNING * ) INSERT INTO bug6051_3 SELECT * FROM t1;" db-types="PostgreSQL"/>
<sql-case id="with_by_postgresql_source_test_case18" value="WITH v(exp) AS (VALUES(-16379),(-16378),(-1234),(-789),(-45),(-5),(-4),(-3),(-2),(-1),(0), (1),(2),(3),(4),(5),(38),(275),(2345),(45678),(131070),(131071)) SELECT exp, to_char(('1.2345e'||exp)::numeric, '9.999EEEE') as numeric FROM v;" db-types="PostgreSQL"/>
<sql-case id="with_by_postgresql_source_test_case19" value="WITH v(val) AS (VALUES('0'::numeric),('-4.2'),('4.2e9'),('1.2e-5'),('inf'),('-inf'),('nan')) SELECT val, to_char(val, '9.999EEEE') as numeric, to_char(val::float8, '9.999EEEE') as float8, to_char(val::float4, '9.999EEEE') as float4 FROM v;" db-types="PostgreSQL"/>
<sql-case id="with_by_postgresql_source_test_case20" value="WITH v(val) AS (VALUES('0'::numeric),('-4.2'),('4.2e9'),('1.2e-5'),('inf'),('-inf'),('nan')) SELECT val, to_char(val, 'MI99.99') as numeric, to_char(val::float8, 'MI99.99') as float8, to_char(val::float4, 'MI99.99') as float4 FROM v;" db-types="PostgreSQL"/>
@@ -8794,10 +8538,6 @@
<sql-case id="low_fetch_by_postgresql_source_test_case61" value="fetch prior from rf_cur;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case1" value="insert into arr_pk_tbl values (1, '{3,4,5}') on conflict (pk) do update set f1[1] = excluded.f1[1], f1[3] = excluded.f1[3] returning pk, f1;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case2" value="insert into arr_pk_tbl(pk, f1[1:2]) values (1, '{6,7,8}') on conflict (pk) do update set f1[1] = excluded.f1[1], f1[2] = excluded.f1[2], f1[3] = excluded.f1[3] returning pk, f1;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case3" value="insert into bmscantest select r, 'fooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo' FROM generate_series(1,100000) r;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case4" value="insert into btree_bpchar select 'foo' from generate_series(1,1500);" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case5" value="insert into btree_tall_tbl select g, repeat('x', 250) from generate_series(1, 130) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case6" value="insert into bug_16784 select g/10, g from generate_series(1,40) g;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case7" value="insert into capitals values ('Sacramento', 4664.E+5, 30, 'CA') on conflict (name) do update set population = excluded.population;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case8" value="insert into dcomptable (d1[1]) values(row(9,10));" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case9" value="insert into def_test default values;" db-types="PostgreSQL"/>
@@ -8810,99 +8550,40 @@
<sql-case id="low_insert_by_postgresql_source_test_case16" value="insert into defaulttest default values;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case17" value="insert into defaulttest default values;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case18" value="insert into defaulttest default values;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case19" value="insert into dest select array[row(f1,f1)::textandtext] from src;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case20" value="insert into domdeftest default values;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case21" value="insert into domdeftest default values;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case22" value="insert into domdeftest default values;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case23" value="insert into domnotnull default values;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case24" value="insert into exists_tbl select x, x/2, x+1 from generate_series(0,10) x;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case25" value="insert into extremely_skewed select 42 as id, 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' from generate_series(1, 20000);" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case26" value="insert into fk_notpartitioned_pk (a, b) select 2048, x from generate_series(1,10) x;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case27" value="insert into fkest select x, x/10, x/10, x/100 from generate_series(1,1000) x;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case28" value="insert into fkest select x/10, x%10, x from generate_series(1,1000) x;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case29" value="insert into fkest1 select x/10, x%10 from generate_series(1,1000) x;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case30" value="insert into gin_test_tbl select array[1, 2, g] from generate_series(1, 1000) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case31" value="insert into gin_test_tbl select array[1, 2, g] from generate_series(1, 20000) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case32" value="insert into gin_test_tbl select array[1, 3, g] from generate_series(1, 1000) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case33" value="insert into gin_test_tbl select array[1, 3, g] from generate_series(1, 1000) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case34" value="insert into gin_test_tbl select array[3, 1, g] from generate_series(1, 1000) g;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case35" value="insert into gist_point_tbl (id, p) select g+100000, point(g*10+1, g*10+1) from generate_series(1, 10000) g;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case36" value="insert into gist_point_tbl (id, p) select g, point(g*10, g*10) from generate_series(1, 10000) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case37" value="insert into gist_tbl select box(point(0.05*i, 0.05*i), point(0.05*i, 0.05*i)), point(0.05*i, 0.05*i), circle(point(0.05*i, 0.05*i), 1.0) from generate_series(0,10000) as i;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case38" value="insert into gstest4 values (1,1,b'0000','1'), (2,2,b'0001','1'), (3,4,b'0010','2'), (4,8,b'0011','2'), (5,16,b'0000','2'), (6,32,b'0001','2'), (7,64,b'0010','1'), (8,128,b'0011','1');" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case39" value="insert into i8mr_array values (42, array[int8multirange(int8range(1,10)), int8multirange(int8range(2,20))]);" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case40" value="insert into i8r_array values (42, array[int8range(1,10), int8range(2,20)]);" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case41" value="insert into idxpart select 2^g, format('two to power of %s', g) from generate_series(15, 17) g;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case42" value="insert into idxpart select a * 2, b || b from idxpart where a between 2^16 and 2^19;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case43" value="insert into inserttest (f2[1], f2[2]) select 7,8;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case44" value="insert into inserttest (f2[1], f2[2]) values (1,2);" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case45" value="insert into inserttest (f2[1], f2[2]) values (1,default);" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case46" value="insert into inserttest (f2[1], f2[2]) values (3,4), (5,6);" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case47" value="insert into inserttest (f3.if1, f3.if2) select 3, '{baz,quux}';" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case48" value="insert into inserttest (f3.if2[1], f3.if2[2]) select 'bear', 'beer';" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case49" value="insert into inserttest (f3.if2[1], f3.if2[2]) values ('foo', 'bar'), ('baz', 'quux');" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case50" value="insert into inserttest (f3.if2[1], f3.if2[2]) values ('foo', 'bar');" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case51" value="insert into inserttest (f4[1].if2[1], f4[1].if2[2]) select 'bear', 'beer';" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case52" value="insert into inserttest (f4[1].if2[1], f4[1].if2[2]) values ('foo', 'bar'), ('baz', 'quux');" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case53" value="insert into inserttest (f4[1].if2[1], f4[1].if2[2]) values ('foo', 'bar');" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case54" value="insert into list_part select generate_series(1,4);" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case55" value="insert into list_parted select 'Ff', s.a from generate_series(1, 29) s(a);" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case56" value="insert into list_parted select 'gg', s.a from generate_series(1, 9) s(a);" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case57" value="insert into lprt_a select 0 from generate_series(1,100);" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case58" value="insert into ma_test select x,x from generate_series(0,29) t(x);" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case59" value="insert into onerow default values;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case60" value="insert into other_partitioned_fk select 2048, x from generate_series(1,10) x;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case61" value="insert into parted_conflict values (50, 'cincuenta', 2) on conflict (a, b) do update set (a, b, c) = row(excluded.*) where parted_conflict = (50, text 'cincuenta', 1) and excluded = (50, text 'cincuenta', 2);" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case62" value="insert into patest1 select x, x from generate_series(0,1000) x;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case63" value="insert into patest2 select x, x from generate_series(0,1000) x;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case64" value="insert into people select ('Jim', f1, null)::fullname, current_date from pp;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case65" value="insert into permtest_parent select 1, 'a', left(md5(i::text), 5) from generate_series(0, 100) i;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case66" value="insert into prtx1 select 1 + i%30, i, i from generate_series(1,1000) i;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case67" value="insert into prtx2 select 1 + i%30, i, i from generate_series(1,500) i, generate_series(1,10) j;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case68" value="insert into public.brintest_multi (float4col) values (real 'nan');" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case69" value="insert into public.brintest_multi (float8col) values (real 'nan');" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case70" value="insert into reservations values (1, daterange('2018-07-01', '2018-07-07')), (1, daterange('2018-07-07', '2018-07-14')), (1, daterange('2018-07-20', '2018-07-22')), (2, daterange('2018-07-01', '2018-07-03')), (3, NULL), (4, NULL), (4, NULL), (5, NULL), (5, daterange('2018-07-01', '2018-07-03')), (6, daterange('2018-0 [...]
- <sql-case id="low_insert_by_postgresql_source_test_case71" value="insert into rewriteme select x * 1.001 from generate_series(1, 500) as t(x);" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case72" value="insert into rtest_emp select * from rtest_empmass;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case73" value="insert into rtest_nothn1 select * from rtest_nothn4;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case74" value="insert into rtest_nothn2 select * from rtest_nothn4;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case75" value="insert into rtest_t4 select * from rtest_t9 where a < 20;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case76" value="insert into rtest_t4 select * from rtest_t9 where b ~ 'and t8';" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case77" value="insert into rtest_t4 select a + 1, b from rtest_t9 where a in (20, 30, 40);" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case78" value="insert into rtest_v1 (a) select a from rtest_t3;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case79" value="insert into rtest_v1 (b, a) select b, a from rtest_t2;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case80" value="insert into rtest_v1 select * from rtest_t2;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case81" value="insert into rtest_v1 select * from rtest_t3;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case82" value="insert into rtest_v1 select rtest_t2.a, rtest_t3.b from rtest_t2, rtest_t3 where rtest_t2.a = rtest_t3.a;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case83" value="insert into rtest_view3 select * from rtest_vview1 where a < 7;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case84" value="insert into rtest_view3 select * from rtest_vview2 where a != 5 and b !~ '2';" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case85" value="insert into rtest_view3 select * from rtest_vview3;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case86" value="insert into rtest_view4 select * from rtest_vview4 where 3 > refcount;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case87" value="insert into rtest_view4 select * from rtest_vview5 where a > 2 and refcount = 0;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case88" value="insert into shoelace_ok select * from shoelace_arrive;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case89" value="insert into spgist_box_tbl(b) select box(point(i,j),point(i+s,j+s)) from generate_series(1,100,5) i, generate_series(1,100,5) j, generate_series(1,10) s;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case90" value="insert into spgist_point_tbl (id, p) select g+100000, point(g*10+1, g*10+1) from generate_series(1, 10000) g;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case91" value="insert into spgist_point_tbl (id, p) select g, point(g*10, g*10) from generate_series(1, 10000) g;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case92" value="insert into spgist_point_tbl (id, p) select g, point(g*10, g*10) from generate_series(1, 10) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case93" value="insert into spgist_text_tbl (id, t) select -g, 'f' || repeat('o', 100-g) || 'surprise' from generate_series(1, 100) g;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case94" value="insert into spgist_text_tbl (id, t) select g, 'f' || repeat('o', 100) || g from generate_series(1, 10000) g union all select g, 'baaaaaaaaaaaaaar' || g from generate_series(1, 1000) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case95" value="insert into src select string_agg(random()::text,'') from generate_series(1,10000);" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case96" value="insert into stts_t1 select i,i from generate_series(1,100) i;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case97" value="insert into t select mod(i,10),mod(i,10),i from generate_series(1,10000) s(i);" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case98" value="insert into t(a, b) select (case when i < 5 then i else 9 end), i from generate_series(1, 1000) n(i);" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case99" value="insert into t(a, b) select i / 10, i from generate_series(1, 1000) n(i);" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case100" value="insert into t(a, b) select i, i from generate_series(1, 1000) n(i);" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case101" value="insert into t(a, b) select i/100 + 1, i + 1 from generate_series(0, 999) n(i);" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case102" value="insert into t(a, b) select i/50 + 1, i + 1 from generate_series(0, 999) n(i);" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case103" value="insert into t1 select * from generate_series(5,19,1) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case104" value="insert into t_gin_test_tbl select array[1, g, g/10], array[2, g, g/10] from generate_series(1, 20000) g;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case105" value="insert into test_mode select 1 from generate_series(1,1000) union all select 2;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case106" value="insert into test_multirange_gist select '{}'::int4multirange from generate_series(1,500) g;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case107" value="insert into test_multirange_gist select int4multirange(int4range(NULL, g*10, '(]'), int4range(g*10, g*20, '(]')) from generate_series(1,100) g;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case108" value="insert into test_multirange_gist select int4multirange(int4range(g*10, g*20, '(]'), int4range(g*20, NULL, '(]')) from generate_series(1,100) g;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case109" value="insert into test_multirange_gist select int4multirange(int4range(g, g+10),int4range(g+20, g+30),int4range(g+40, g+50)) from generate_series(1,2000) g;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case110" value="insert into test_multirange_gist select int4multirange(int4range(g, g+10000)) from generate_series(1,1000) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case111" value="insert into test_range_elem select i from generate_series(1,100) i;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case112" value="insert into test_range_excl values(int4range(123, 123, '[]'), int4range(1, 1, '[]'), '[2010-01-02 10:00, 2010-01-02 11:00)');" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case113" value="insert into test_range_excl values(int4range(123, 123, '[]'), int4range(2, 2, '[]'), '[2010-01-02 11:00, 2010-01-02 12:00)');" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case114" value="insert into test_range_excl values(int4range(123, 123, '[]'), int4range(3, 3, '[]'), '[2010-01-02 10:10, 2010-01-02 11:00)');" db-types="PostgreSQL"/>
@@ -8910,19 +8591,8 @@
<sql-case id="low_insert_by_postgresql_source_test_case116" value="insert into test_range_excl values(int4range(125, 125, '[]'), int4range(1, 1, '[]'), '[2010-01-02 10:10, 2010-01-02 11:00)');" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case117" value="insert into test_range_gist select 'empty'::int4range from generate_series(1,500) g;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case118" value="insert into test_range_gist select 'empty'::int4range from generate_series(1,500) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case119" value="insert into test_range_gist select int4range(NULL,g*10,'(]') from generate_series(1,100) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case120" value="insert into test_range_gist select int4range(g*10,NULL,'(]') from generate_series(1,100) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case121" value="insert into test_range_gist select int4range(g, g+10) from generate_series(1,2000) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case122" value="insert into test_range_gist select int4range(g, g+10) from generate_series(1,2000) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case123" value="insert into test_range_gist select int4range(g, g+10000) from generate_series(1,1000) g;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case124" value="insert into test_range_spgist select 'empty'::int4range from generate_series(1,500) g;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case125" value="insert into test_range_spgist select 'empty'::int4range from generate_series(1,500) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case126" value="insert into test_range_spgist select int4range(NULL,g*10,'(]') from generate_series(1,100) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case127" value="insert into test_range_spgist select int4range(g*10,NULL,'(]') from generate_series(1,100) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case128" value="insert into test_range_spgist select int4range(g, g+10) from generate_series(1,2000) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case129" value="insert into test_range_spgist select int4range(g, g+10) from generate_series(1,2000) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case130" value="insert into test_range_spgist select int4range(g, g+10000) from generate_series(1,1000) g;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case131" value="insert into test_table select 'a', null from generate_series(1,1000);" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case132" value="insert into trigtest default values;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case133" value="insert into trigtest default values;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case134" value="insert into trigtest default values;" db-types="PostgreSQL"/>
@@ -8930,7 +8600,6 @@
<sql-case id="low_insert_by_postgresql_source_test_case136" value="insert into trigtest default values;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case137" value="insert into trigtest default values;" db-types="PostgreSQL"/>
<sql-case id="low_insert_by_postgresql_source_test_case138" value="insert into trigtest default values;" db-types="PostgreSQL"/>
- <sql-case id="low_insert_by_postgresql_source_test_case139" value="insert into tt3 select x, repeat('xyzzy', 100) from generate_series(1,10000) x;" db-types="PostgreSQL"/>
<sql-case id="low_listen_by_postgresql_source_test_case1" value="listen a;" db-types="PostgreSQL"/>
<sql-case id="low_lock_by_postgresql_source_test_case1" value="lock table pxtest3 in access share mode nowait;" db-types="PostgreSQL"/>
<sql-case id="low_lock_by_postgresql_source_test_case2" value="lock table pxtest3 in access share mode nowait;" db-types="PostgreSQL"/>
@@ -9462,7 +9131,6 @@
<sql-case id="low_update_by_postgresql_source_test_case33" value="update quadtable set q.c1 = 12;" db-types="PostgreSQL"/>
<sql-case id="low_update_by_postgresql_source_test_case34" value="update quadtable set q.c1.r = 12 where f1 = 2;" db-types="PostgreSQL"/>
<sql-case id="low_update_by_postgresql_source_test_case35" value="update t1 set f1[5].q2 = 43;" db-types="PostgreSQL"/>
- <sql-case id="low_with_by_postgresql_source_test_case1" value="with ins (a) as ( insert into parted2_stmt_trig values (1), (2) returning a ) insert into parted_stmt_trig select a from ins returning tableoid::regclass, a;" db-types="PostgreSQL"/>
<sql-case id="low_with_by_postgresql_source_test_case2" value="with r(a,b) as materialized (values (1,row(1,2)), (1,row(null,null)), (1,null), (null,row(1,2)), (null,row(null,null)), (null,null) ) select r, r is null as isnull, r is not null as isnotnull from r;" db-types="PostgreSQL"/>
<sql-case id="low_with_by_postgresql_source_test_case3" value="with recursive a as ( select 1 as b union all select * from a ) cycle b set c using p select * from a;" db-types="PostgreSQL"/>
<sql-case id="low_with_by_postgresql_source_test_case4" value="with recursive graph(f, t, label) as ( values (1, 2, 'arc 1 -> 2'), (1, 3, 'arc 1 -> 3'), (2, 3, 'arc 2 -> 3'), (1, 4, 'arc 1 -> 4'), (4, 5, 'arc 4 -> 5'), (5, 1, 'arc 5 -> 1') ), search_graph(f, t, label) as ( select * from graph g union all select g.* from graph g, [...]
@@ -9491,8 +9159,6 @@
<sql-case id="low_with_by_postgresql_source_test_case27" value="with recursive search_graph(f, t, label, is_cycle, path) as ( select *, false, array[row(g.f, g.t)] from graph g union all select g.*, row(g.f, g.t) = any(path), path || row(g.f, g.t) from graph g, search_graph sg where g.f = sg.t and not is_cycle ) select * from search_graph order by path;" db-types="PostgreSQL"/>
<sql-case id="low_with_by_postgresql_source_test_case28" value="with recursive search_graph(f, t, label, is_cycle, path) as ( select *, false, array[row(g.f, g.t)] from graph g union all select g.*, row(g.f, g.t) = any(path), path || row(g.f, g.t) from graph g, search_graph sg where g.f = sg.t and not is_cycle ) select * from search_graph;" db-types="PostgreSQL"/>
<sql-case id="low_with_by_postgresql_source_test_case29" value="with recursive search_graph(f, t, label, is_cycle, path) as ( select *, false, array[row(g.f, g.t)] from graph g union distinct select g.*, row(g.f, g.t) = any(path), path || row(g.f, g.t) from graph g, search_graph sg where g.f = sg.t and not is_cycle ) select * from search_graph;" db-types="PostgreSQL"/>
- <sql-case id="low_with_by_postgresql_source_test_case30" value="with result as (insert into brtrigpartcon values (1, 'hi there') returning 1) insert into inserttest3 (f3) select * from result;" db-types="PostgreSQL"/>
- <sql-case id="low_with_by_postgresql_source_test_case31" value="with test as (select 42) insert into test select * from test;" db-types="PostgreSQL"/>
<sql-case id="low_with_by_postgresql_source_test_case32" value="with testdata(bits) as (values (x'00000000'), (x'00800000'), (x'00800001'), (x'00800004'), (x'00800005'), (x'00800006'), (x'008002f1'), (x'008002f2'), (x'008002f3'), (x'00800e17'), (x'00800e18'), (x'00800e19'), (x'01000001'), (x'01102843'), (x'01a52c98'), (x&a [...]
<sql-case id="low_with_by_postgresql_source_test_case33" value="with testdata(bits) as (values (x'00000001'), (x'00000002'), (x'00000003'), (x'00000010'), (x'00000011'), (x'00000100'), (x'00000101'), (x'00004000'), (x'00004001'), (x'00080000'), (x'00080001'), (x'0053c4f4') (x'006c85c4') (x'0041ca76') (x'004b7678') (x&a [...]
</sql-cases>