This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 090be20ca4 [cases](regresstests) add negative case for agg table and
fix agg table support replace typ… #24715
090be20ca4 is described below
commit 090be20ca4420f6d7ee9ed766fbf4f3c4209ab64
Author: amory <[email protected]>
AuthorDate: Fri Sep 22 09:05:20 2023 +0800
[cases](regresstests) add negative case for agg table and fix agg table
support replace typ… #24715
add negative case for agg table
fix agg table support replace agg type for complex type , and Now We only
support complex type with agg state for replace only
fix test output
---
.../org/apache/doris/analysis/CreateTableStmt.java | 4 -
...est_nested_types_insert_into_with_agg_table.out | 16 ++
.../suites/datatype_p0/nested_types/load.groovy | 151 +++++++++++++++
...nested_types_insert_into_with_agg_table.groovy} | 213 +++++++++++----------
..._nested_types_insert_into_with_dup_table.groovy | 40 ++--
...sted_types_insert_into_with_unique_table.groovy | 80 ++++----
6 files changed, 334 insertions(+), 170 deletions(-)
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/analysis/CreateTableStmt.java
b/fe/fe-core/src/main/java/org/apache/doris/analysis/CreateTableStmt.java
index b0859b8db7..d97e746db6 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/analysis/CreateTableStmt.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/analysis/CreateTableStmt.java
@@ -520,10 +520,6 @@ public class CreateTableStmt extends DdlStmt {
columnDef.analyze(engineName.equals("olap"));
if (columnDef.getType().isComplexType() &&
engineName.equals("olap")) {
- if (columnDef.getAggregateType() == AggregateType.REPLACE
- && keysDesc.getKeysType() == KeysType.AGG_KEYS) {
- throw new AnalysisException("Aggregate table can't support
replace array/map/struct value now");
- }
if (columnDef.getAggregateType() != null
&& columnDef.getAggregateType() != AggregateType.NONE
&& columnDef.getAggregateType() !=
AggregateType.REPLACE) {
diff --git
a/regression-test/data/datatype_p0/nested_types/negative_cases/test_nested_types_insert_into_with_agg_table.out
b/regression-test/data/datatype_p0/nested_types/negative_cases/test_nested_types_insert_into_with_agg_table.out
new file mode 100644
index 0000000000..254ecfa7b0
--- /dev/null
+++
b/regression-test/data/datatype_p0/nested_types/negative_cases/test_nested_types_insert_into_with_agg_table.out
@@ -0,0 +1,16 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !sql_nested_table_agg_c --
+1
+
+-- !sql_nested_table_agg2_c --
+1
+
+-- !sql_nested_table_map_agg_c --
+1
+
+-- !sql_nested_table_array_map_agg_c --
+1
+
+-- !sql_nested_table_map_array_agg_c --
+1
+
diff --git a/regression-test/suites/datatype_p0/nested_types/load.groovy
b/regression-test/suites/datatype_p0/nested_types/load.groovy
index 564628ac5c..3ceffc30cd 100644
--- a/regression-test/suites/datatype_p0/nested_types/load.groovy
+++ b/regression-test/suites/datatype_p0/nested_types/load.groovy
@@ -529,4 +529,155 @@ suite("load") {
PROPERTIES("replication_num" = "1", "enable_unique_key_merge_on_write"
= "true");
"""
+ // agg table
+ // define agg key table with nested table types with one nested scala
+ def nested_table_agg = "tbl_array_nested_types_agg"
+ sql "DROP TABLE IF EXISTS ${nested_table_agg}"
+ sql """
+ CREATE TABLE IF NOT EXISTS ${nested_table_agg} (
+ `k1` bigint(11) NULL,
+ `c_bool` array<boolean> REPLACE,
+ `c_tinyint` array<tinyint(4)> REPLACE,
+ `c_smallint` array<smallint(6)> REPLACE,
+ `c_int` array<int(11)> REPLACE,
+ `c_bigint` array<bigint(20)> REPLACE,
+ `c_largeint` array<largeint(40)> REPLACE,
+ `c_float` array<float> REPLACE,
+ `c_double` array<double> REPLACE,
+ `c_decimal` array<decimal(20, 3)> REPLACE,
+ `c_decimalv3` array<decimalv3(20, 3)> REPLACE,
+ `c_date` array<date> REPLACE,
+ `c_datetime` array<datetime> REPLACE,
+ `c_datev2` array<datev2> REPLACE,
+ `c_datetimev2` array<datetimev2(0)> REPLACE,
+ `c_char` array<char(15)> REPLACE,
+ `c_varchar` array<varchar(100)> REPLACE,
+ `c_string` array<text> REPLACE
+ ) ENGINE=OLAP
+ AGGREGATE KEY(`k1`)
+ COMMENT 'OLAP'
+ DISTRIBUTED BY HASH(`k1`) BUCKETS 10
+ PROPERTIES("replication_num" = "1");
+ """
+
+ // define agg key table with nested table types with two nested scala
+ def nested_table_agg2 = "tbl_array_nested_types_agg2"
+ sql "DROP TABLE IF EXISTS ${nested_table_agg2}"
+ sql """
+ CREATE TABLE IF NOT EXISTS ${nested_table_agg2} (
+ `k1` bigint(11) NULL,
+ `c_bool` array<array<boolean>> REPLACE,
+ `c_tinyint` array<array<tinyint(4)>> REPLACE,
+ `c_smallint` array<array<smallint(6)>> REPLACE,
+ `c_int` array<array<int(11)>> REPLACE,
+ `c_bigint` array<array<bigint(20)>> REPLACE,
+ `c_largeint` array<array<largeint(40)>> REPLACE,
+ `c_float` array<array<float>> REPLACE,
+ `c_double` array<array<double>> REPLACE,
+ `c_decimal` array<array<decimal(20, 3)>> REPLACE,
+ `c_decimalv3` array<array<decimalv3(20, 3)>> REPLACE,
+ `c_date` array<array<date>> REPLACE,
+ `c_datetime` array<array<datetime>> REPLACE,
+ `c_datev2` array<array<datev2>> REPLACE,
+ `c_datetimev2` array<array<datetimev2(0)>> REPLACE,
+ `c_char` array<array<char(15)>> REPLACE,
+ `c_varchar` array<array<varchar(100)>> REPLACE,
+ `c_string` array<array<text>> REPLACE
+ ) ENGINE=OLAP
+ AGGREGATE KEY(`k1`)
+ COMMENT 'OLAP'
+ DISTRIBUTED BY HASH(`k1`) BUCKETS 10
+ PROPERTIES("replication_num" = "1");
+ """
+
+ // define mor key table with map types with one nested scala
+ def nested_table_map_agg = "tbl_map_types_agg"
+ sql "DROP TABLE IF EXISTS ${nested_table_map_agg}"
+ sql """
+ CREATE TABLE IF NOT EXISTS ${nested_table_map_agg} (
+ `k1` bigint(11) NULL,
+ `c_bool` map<boolean, boolean> REPLACE,
+ `c_tinyint` map<tinyint(4), tinyint(4)> REPLACE,
+ `c_smallint` map<smallint(6), smallint(6)> REPLACE,
+ `c_int` map<int(11), int(11)> REPLACE,
+ `c_bigint` map<bigint(20), bigint(20)> REPLACE,
+ `c_largeint` map<largeint(40), largeint(40)> REPLACE,
+ `c_float` map<float, float> REPLACE,
+ `c_double` map<double, double> REPLACE,
+ `c_decimal` map<decimal(20, 3), decimal(20, 3)> REPLACE,
+ `c_decimalv3` map<decimalv3(20, 3), decimalv3(20, 3)> REPLACE,
+ `c_date` map<date, date> REPLACE,
+ `c_datetime` map<datetime, datetime> REPLACE,
+ `c_datev2` map<datev2, datev2> REPLACE,
+ `c_datetimev2` map<datetimev2(0), datetimev2(0)> REPLACE,
+ `c_char` map<char(15), char(15)> REPLACE,
+ `c_varchar` map<varchar(100), varchar(100)> REPLACE,
+ `c_string` map<text, text> REPLACE
+ ) ENGINE=OLAP
+ AGGREGATE KEY(`k1`)
+ COMMENT 'OLAP'
+ DISTRIBUTED BY HASH(`k1`) BUCKETS 10
+ PROPERTIES("replication_num" = "1");
+ """
+
+
+ // define agg key table with array nested map table types with one nested
scala
+ def nested_table_array_map_agg = "tbl_array_map_types_agg"
+ sql "DROP TABLE IF EXISTS ${nested_table_array_map_agg}"
+ sql """
+ CREATE TABLE IF NOT EXISTS ${nested_table_array_map_agg} (
+ `k1` bigint(11) NULL,
+ `c_bool` array<map<boolean, boolean>> REPLACE,
+ `c_tinyint` array<map<tinyint(4), tinyint(4)>> REPLACE,
+ `c_smallint` array<map<smallint(6), smallint(6)>> REPLACE,
+ `c_int` array<map<int(11), int(11)>> REPLACE,
+ `c_bigint` array<map<bigint(20), bigint(20)>> REPLACE,
+ `c_largeint` array<map<largeint(40), largeint(40)>> REPLACE,
+ `c_float` array<map<float, float>> REPLACE,
+ `c_double` array<map<double, double>> REPLACE,
+ `c_decimal` array<map<decimal(20, 3), decimal(20, 3)>> REPLACE,
+ `c_decimalv3` array<map<decimalv3(20, 3), decimalv3(20, 3)>>
REPLACE,
+ `c_date` array<map<date, date>> REPLACE,
+ `c_datetime` array<map<datetime, datetime>> REPLACE,
+ `c_datev2` array<map<datev2, datev2>> REPLACE,
+ `c_datetimev2` array<map<datetimev2(0), datetimev2(0)>> REPLACE,
+ `c_char` array<map<char(15), char(15)>> REPLACE,
+ `c_varchar` array<map<varchar(100), varchar(100)>> REPLACE,
+ `c_string` array<map<text, text>> REPLACE
+ ) ENGINE=OLAP
+ AGGREGATE KEY(`k1`)
+ COMMENT 'OLAP'
+ DISTRIBUTED BY HASH(`k1`) BUCKETS 10
+ PROPERTIES("replication_num" = "1");
+ """
+
+ // define agg key table with map nested value array table types with one
nested scala
+ def nested_table_map_array_agg = "tbl_map_array_types_agg"
+ sql "DROP TABLE IF EXISTS ${nested_table_map_array_agg}"
+ sql """
+ CREATE TABLE IF NOT EXISTS ${nested_table_map_array_agg} (
+ `k1` bigint(11) NULL,
+ `c_bool` map<boolean, array<boolean>> REPLACE,
+ `c_tinyint` map<tinyint(4), array<tinyint(4)>> REPLACE,
+ `c_smallint` map<smallint(6), array<smallint(6)>> REPLACE,
+ `c_int` map<int(11), array<int(11)>> REPLACE,
+ `c_bigint` map<bigint(20), array<bigint(20)>> REPLACE,
+ `c_largeint` map<largeint(40), array<largeint(40)>> REPLACE,
+ `c_float` map<float, array<float>> REPLACE,
+ `c_double` map<double, array<double>> REPLACE,
+ `c_decimal` map<decimal(20, 3), array<decimal(20, 3)>> REPLACE,
+ `c_decimalv3` map<decimalv3(20, 3), array<decimalv3(20, 3)>>
REPLACE,
+ `c_date` map<date, array<date>> REPLACE,
+ `c_datetime` map<datetime, array<datetime>> REPLACE,
+ `c_datev2` map<datev2, array<datev2>> REPLACE,
+ `c_datetimev2` map<datetimev2(0), array<datetimev2(0)>> REPLACE,
+ `c_char` map<char(15), array<char(15)>> REPLACE,
+ `c_varchar` map<varchar(100), array<varchar(100)>> REPLACE,
+ `c_string` map<text, array<text>> REPLACE
+ ) ENGINE=OLAP
+ AGGREGATE KEY(`k1`)
+ COMMENT 'OLAP'
+ DISTRIBUTED BY HASH(`k1`) BUCKETS 10
+ PROPERTIES("replication_num" = "1");
+ """
}
diff --git
a/regression-test/suites/datatype_p0/nested_types/negative_cases/test_nested_types_insert_into_with_dup_table.groovy
b/regression-test/suites/datatype_p0/nested_types/negative_cases/test_nested_types_insert_into_with_agg_table.groovy
similarity index 71%
copy from
regression-test/suites/datatype_p0/nested_types/negative_cases/test_nested_types_insert_into_with_dup_table.groovy
copy to
regression-test/suites/datatype_p0/nested_types/negative_cases/test_nested_types_insert_into_with_agg_table.groovy
index e8e9b363da..b015a73f58 100644
---
a/regression-test/suites/datatype_p0/nested_types/negative_cases/test_nested_types_insert_into_with_dup_table.groovy
+++
b/regression-test/suites/datatype_p0/nested_types/negative_cases/test_nested_types_insert_into_with_agg_table.groovy
@@ -17,426 +17,427 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
-suite("test_nested_types_insert_into_with_dup_table", "p0") {
+suite("test_nested_types_insert_into_with_agg_table", "p0") {
sql 'use regression_test_datatype_p0_nested_types'
sql 'set enable_nereids_planner=false'
// test action for scala to array with scala type
// current we support char family to insert nested type
+ // agg table test
test {
- sql "insert into tbl_array_nested_types_dup (c_bool) select c_bool
from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg (c_bool) select c_bool
from tbl_scalar_types_dup"
exception "java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type BOOLEAN to target type=ARRAY<BOOLEAN>"
}
test {
- sql "insert into tbl_array_nested_types_dup (c_tinyint) select
c_tinyint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<TINYINT(4)>")
+ sql "insert into tbl_array_nested_types_agg (c_tinyint) select
c_tinyint from tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<TINYINT>")
}
test {
- sql "insert into tbl_array_nested_types_dup (c_smallint) select
c_smallint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<SMALLINT(6)>")
+ sql "insert into tbl_array_nested_types_agg (c_smallint) select
c_smallint from tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<SMALLINT>")
}
test {
- sql "insert into tbl_array_nested_types_dup (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<INT(11)>")
+ sql "insert into tbl_array_nested_types_agg (c_int) select c_int from
tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<INT>")
}
test {
- sql "insert into tbl_array_nested_types_dup (c_largeint) select
c_largeint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<LARGEINT(40)>")
+ sql "insert into tbl_array_nested_types_agg (c_largeint) select
c_largeint from tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<LARGEINT>")
}
test {
- sql "insert into tbl_array_nested_types_dup (c_float) select c_float
from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg (c_float) select c_float
from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type FLOAT to target type=ARRAY<FLOAT>")
}
test {
- sql "insert into tbl_array_nested_types_dup (c_double) select c_double
from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg (c_double) select c_double
from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DOUBLE to target type=ARRAY<DOUBLE>")
}
test {
- sql "insert into tbl_array_nested_types_dup (c_decimal) select
c_decimal from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg (c_decimal) select
c_decimal from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DECIMALV3(20, 3) to target type=ARRAY<DECIMALV3(20, 3)>")
}
test {
- sql "insert into tbl_array_nested_types_dup (c_decimalv3) select
c_decimalv3 from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg (c_decimalv3) select
c_decimalv3 from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DECIMALV3(20, 3) to target type=ARRAY<DECIMALV3(20, 3)>")
}
test {
- sql "insert into tbl_array_nested_types_dup (c_date) select c_date
from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg (c_date) select c_date
from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATEV2 to target type=ARRAY<DATEV2>")
}
test {
- sql "insert into tbl_array_nested_types_dup (c_datetime) select
c_datetime from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg (c_datetime) select
c_datetime from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATETIMEV2(0) to target type=ARRAY<DATETIMEV2(0)>")
}
test {
- sql "insert into tbl_array_nested_types_dup (c_datev2) select c_datev2
from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg (c_datev2) select c_datev2
from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATEV2 to target type=ARRAY<DATEV2>")
}
test {
- sql "insert into tbl_array_nested_types_dup (c_datetimev2) select
c_datetimev2 from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg (c_datetimev2) select
c_datetimev2 from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATETIMEV2(0) to target type=ARRAY<DATETIMEV2(0)>")
}
test {
- sql "insert into tbl_array_nested_types_dup (c_char) select c_char
from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg (c_char) select c_char
from tbl_scalar_types_dup"
exception null
}
test {
- sql "insert into tbl_array_nested_types_dup (c_varchar) select
c_varchar from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg (c_varchar) select
c_varchar from tbl_scalar_types_dup"
exception null
}
test {
- sql "insert into tbl_array_nested_types_dup (c_string) select c_string
from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg (c_string) select c_string
from tbl_scalar_types_dup"
exception null
}
- qt_sql_nested_table_dup_c """select count() from
tbl_array_nested_types_dup;"""
+ qt_sql_nested_table_agg_c """select count() from
tbl_array_nested_types_agg;"""
// test action for scala to array with array-scala type
test {
- sql "insert into tbl_array_nested_types_dup2 (c_bool) select c_bool
from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg2 (c_bool) select c_bool
from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type BOOLEAN to target type=ARRAY<ARRAY<BOOLEAN>>")
}
test {
- sql "insert into tbl_array_nested_types_dup2 (c_tinyint) select
c_tinyint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<ARRAY<TINYINT(4)>>")
+ sql "insert into tbl_array_nested_types_agg2 (c_tinyint) select
c_tinyint from tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<ARRAY<TINYINT>>")
}
test {
- sql "insert into tbl_array_nested_types_dup2 (c_smallint) select
c_smallint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<ARRAY<SMALLINT(6)>>")
+ sql "insert into tbl_array_nested_types_agg2 (c_smallint) select
c_smallint from tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<ARRAY<SMALLINT>>")
}
test {
- sql "insert into tbl_array_nested_types_dup2 (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<ARRAY<INT(11)>>")
+ sql "insert into tbl_array_nested_types_agg2 (c_int) select c_int from
tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<ARRAY<INT>>")
}
test {
- sql "insert into tbl_array_nested_types_dup2 (c_largeint) select
c_largeint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<ARRAY<LARGEINT(40)>>")
+ sql "insert into tbl_array_nested_types_agg2 (c_largeint) select
c_largeint from tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<ARRAY<LARGEINT>>")
}
test {
- sql "insert into tbl_array_nested_types_dup2 (c_float) select c_float
from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg2 (c_float) select c_float
from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type FLOAT to target type=ARRAY<ARRAY<FLOAT>>")
}
test {
- sql "insert into tbl_array_nested_types_dup2 (c_double) select
c_double from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg2 (c_double) select
c_double from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DOUBLE to target type=ARRAY<ARRAY<DOUBLE>>")
}
test {
- sql "insert into tbl_array_nested_types_dup2 (c_decimal) select
c_decimal from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg2 (c_decimal) select
c_decimal from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DECIMALV3(20, 3) to target type=ARRAY<ARRAY<DECIMALV3(20,
3)>>")
}
test {
- sql "insert into tbl_array_nested_types_dup2 (c_decimalv3) select
c_decimalv3 from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg2 (c_decimalv3) select
c_decimalv3 from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DECIMALV3(20, 3) to target type=ARRAY<ARRAY<DECIMALV3(20,
3)>>")
}
test {
- sql "insert into tbl_array_nested_types_dup2 (c_date) select c_date
from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg2 (c_date) select c_date
from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATEV2 to target type=ARRAY<ARRAY<DATEV2>>")
}
test {
- sql "insert into tbl_array_nested_types_dup2 (c_datetime) select
c_datetime from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg2 (c_datetime) select
c_datetime from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATETIMEV2(0) to target type=ARRAY<ARRAY<DATETIMEV2(0)>>")
}
test {
- sql "insert into tbl_array_nested_types_dup2 (c_datev2) select
c_datev2 from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg2 (c_datev2) select
c_datev2 from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATEV2 to target type=ARRAY<ARRAY<DATEV2>>")
}
test {
- sql "insert into tbl_array_nested_types_dup2 (c_datetimev2) select
c_datetimev2 from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg2 (c_datetimev2) select
c_datetimev2 from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATETIMEV2(0) to target type=ARRAY<ARRAY<DATETIMEV2(0)>>")
}
test {
- sql "insert into tbl_array_nested_types_dup2 (c_char) select c_char
from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg2 (c_char) select c_char
from tbl_scalar_types_dup"
exception null
}
test {
- sql "insert into tbl_array_nested_types_dup2 (c_varchar) select
c_varchar from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg2 (c_varchar) select
c_varchar from tbl_scalar_types_dup"
exception null
}
test {
- sql "insert into tbl_array_nested_types_dup2 (c_string) select
c_string from tbl_scalar_types_dup"
+ sql "insert into tbl_array_nested_types_agg2 (c_string) select
c_string from tbl_scalar_types_dup"
exception null
}
- qt_sql_nested_table_dup2_c """select count() from
tbl_array_nested_types_dup2;"""
+ qt_sql_nested_table_agg2_c """select count() from
tbl_array_nested_types_agg2;"""
// test action for scala to map with map-scala-scala type
test {
- sql "insert into tbl_map_types_dup (c_bool) select c_bool from
tbl_scalar_types_dup"
+ sql "insert into tbl_map_types_agg (c_bool) select c_bool from
tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type BOOLEAN to target type=MAP<BOOLEAN,BOOLEAN>")
}
test {
- sql "insert into tbl_map_types_dup (c_tinyint) select c_tinyint from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=MAP<TINYINT(4),TINYINT(4)>")
+ sql "insert into tbl_map_types_agg (c_tinyint) select c_tinyint from
tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=MAP<TINYINT,TINYINT>")
}
test {
- sql "insert into tbl_map_types_dup (c_smallint) select c_smallint from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=MAP<SMALLINT(6),SMALLINT(6)>")
+ sql "insert into tbl_map_types_agg (c_smallint) select c_smallint from
tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=MAP<SMALLINT,SMALLINT>")
}
test {
- sql "insert into tbl_map_types_dup (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=MAP<INT(11),INT(11)>")
+ sql "insert into tbl_map_types_agg (c_int) select c_int from
tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=MAP<INT,INT>")
}
test {
- sql "insert into tbl_map_types_dup (c_largeint) select c_largeint from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=MAP<LARGEINT(40),LARGEINT(40)>")
+ sql "insert into tbl_map_types_agg (c_largeint) select c_largeint from
tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=MAP<LARGEINT,LARGEINT>")
}
test {
- sql "insert into tbl_map_types_dup (c_float) select c_float from
tbl_scalar_types_dup"
+ sql "insert into tbl_map_types_agg (c_float) select c_float from
tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type FLOAT to target type=MAP<FLOAT,FLOAT>")
}
test {
- sql "insert into tbl_map_types_dup (c_double) select c_double from
tbl_scalar_types_dup"
+ sql "insert into tbl_map_types_agg (c_double) select c_double from
tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DOUBLE to target type=MAP<DOUBLE,DOUBLE>")
}
test {
- sql "insert into tbl_map_types_dup (c_decimal) select c_decimal from
tbl_scalar_types_dup"
+ sql "insert into tbl_map_types_agg (c_decimal) select c_decimal from
tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DECIMALV3(20, 3) to target type=MAP<DECIMALV3(20,
3),DECIMALV3(20, 3)>")
}
test {
- sql "insert into tbl_map_types_dup (c_decimalv3) select c_decimalv3
from tbl_scalar_types_dup"
+ sql "insert into tbl_map_types_agg (c_decimalv3) select c_decimalv3
from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DECIMALV3(20, 3) to target type=MAP<DECIMALV3(20,
3),DECIMALV3(20, 3)>")
}
test {
- sql "insert into tbl_map_types_dup (c_date) select c_date from
tbl_scalar_types_dup"
+ sql "insert into tbl_map_types_agg (c_date) select c_date from
tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATEV2 to target type=MAP<DATEV2,DATEV2>")
}
test {
- sql "insert into tbl_map_types_dup (c_datetime) select c_datetime from
tbl_scalar_types_dup"
+ sql "insert into tbl_map_types_agg (c_datetime) select c_datetime from
tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATETIMEV2(0) to target
type=MAP<DATETIMEV2(0),DATETIMEV2(0)>")
}
test {
- sql "insert into tbl_map_types_dup (c_datev2) select c_datev2 from
tbl_scalar_types_dup"
+ sql "insert into tbl_map_types_agg (c_datev2) select c_datev2 from
tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATEV2 to target type=MAP<DATEV2,DATEV2>")
}
test {
- sql "insert into tbl_map_types_dup (c_datetimev2) select c_datetimev2
from tbl_scalar_types_dup"
+ sql "insert into tbl_map_types_agg (c_datetimev2) select c_datetimev2
from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATETIMEV2(0) to target
type=MAP<DATETIMEV2(0),DATETIMEV2(0)>")
}
test {
- sql "insert into tbl_map_types_dup (c_char) select c_char from
tbl_scalar_types_dup"
+ sql "insert into tbl_map_types_agg (c_char) select c_char from
tbl_scalar_types_dup"
exception null
}
test {
- sql "insert into tbl_map_types_dup (c_varchar) select c_varchar from
tbl_scalar_types_dup"
+ sql "insert into tbl_map_types_agg (c_varchar) select c_varchar from
tbl_scalar_types_dup"
exception null
}
test {
- sql "insert into tbl_map_types_dup (c_string) select c_string from
tbl_scalar_types_dup"
+ sql "insert into tbl_map_types_agg (c_string) select c_string from
tbl_scalar_types_dup"
exception null
}
- qt_sql_nested_table_map_dup_c """select count() from tbl_map_types_dup;"""
+ qt_sql_nested_table_map_agg_c """select count() from tbl_map_types_agg;"""
// test action for scala to array with map-scala-scala type
test {
- sql "insert into tbl_array_map_types_dup (c_bool) select c_bool from
tbl_scalar_types_dup"
+ sql "insert into tbl_array_map_types_agg (c_bool) select c_bool from
tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type BOOLEAN to target type=ARRAY<MAP<BOOLEAN,BOOLEAN>>")
}
test {
- sql "insert into tbl_array_map_types_dup (c_tinyint) select c_tinyint
from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<MAP<TINYINT(4),TINYINT(4)>>")
+ sql "insert into tbl_array_map_types_agg (c_tinyint) select c_tinyint
from tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<MAP<TINYINT,TINYINT>>")
}
test {
- sql "insert into tbl_array_map_types_dup (c_smallint) select
c_smallint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target
type=ARRAY<MAP<SMALLINT(6),SMALLINT(6)>>")
+ sql "insert into tbl_array_map_types_agg (c_smallint) select
c_smallint from tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<MAP<SMALLINT,SMALLINT>>")
}
test {
- sql "insert into tbl_array_map_types_dup (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<MAP<INT(11),INT(11)>>")
+ sql "insert into tbl_array_map_types_agg (c_int) select c_int from
tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<MAP<INT,INT>>")
}
test {
- sql "insert into tbl_array_map_types_dup (c_largeint) select
c_largeint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target
type=ARRAY<MAP<LARGEINT(40),LARGEINT(40)>>")
+ sql "insert into tbl_array_map_types_agg (c_largeint) select
c_largeint from tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<MAP<LARGEINT,LARGEINT>>")
}
test {
- sql "insert into tbl_array_map_types_dup (c_float) select c_float from
tbl_scalar_types_dup"
+ sql "insert into tbl_array_map_types_agg (c_float) select c_float from
tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type FLOAT to target type=ARRAY<MAP<FLOAT,FLOAT>>")
}
test {
- sql "insert into tbl_array_map_types_dup (c_double) select c_double
from tbl_scalar_types_dup"
+ sql "insert into tbl_array_map_types_agg (c_double) select c_double
from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DOUBLE to target type=ARRAY<MAP<DOUBLE,DOUBLE>>")
}
test {
- sql "insert into tbl_array_map_types_dup (c_decimal) select c_decimal
from tbl_scalar_types_dup"
+ sql "insert into tbl_array_map_types_agg (c_decimal) select c_decimal
from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DECIMALV3(20, 3) to target type=ARRAY<MAP<DECIMALV3(20,
3),DECIMALV3(20, 3)>>")
}
test {
- sql "insert into tbl_array_map_types_dup (c_decimalv3) select
c_decimalv3 from tbl_scalar_types_dup"
+ sql "insert into tbl_array_map_types_agg (c_decimalv3) select
c_decimalv3 from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DECIMALV3(20, 3) to target type=ARRAY<MAP<DECIMALV3(20,
3),DECIMALV3(20, 3)>>")
}
test {
- sql "insert into tbl_array_map_types_dup (c_date) select c_date from
tbl_scalar_types_dup"
+ sql "insert into tbl_array_map_types_agg (c_date) select c_date from
tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATEV2 to target type=ARRAY<MAP<DATEV2,DATEV2>>")
}
test {
- sql "insert into tbl_array_map_types_dup (c_datetime) select
c_datetime from tbl_scalar_types_dup"
+ sql "insert into tbl_array_map_types_agg (c_datetime) select
c_datetime from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATETIMEV2(0) to target
type=ARRAY<MAP<DATETIMEV2(0),DATETIMEV2(0)>>")
}
test {
- sql "insert into tbl_array_map_types_dup (c_datev2) select c_datev2
from tbl_scalar_types_dup"
+ sql "insert into tbl_array_map_types_agg (c_datev2) select c_datev2
from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATEV2 to target type=ARRAY<MAP<DATEV2,DATEV2>>")
}
test {
- sql "insert into tbl_array_map_types_dup (c_datetimev2) select
c_datetimev2 from tbl_scalar_types_dup"
+ sql "insert into tbl_array_map_types_agg (c_datetimev2) select
c_datetimev2 from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATETIMEV2(0) to target
type=ARRAY<MAP<DATETIMEV2(0),DATETIMEV2(0)>>")
}
test {
- sql "insert into tbl_array_map_types_dup (c_char) select c_char from
tbl_scalar_types_dup"
+ sql "insert into tbl_array_map_types_agg (c_char) select c_char from
tbl_scalar_types_dup"
exception null
}
test {
- sql "insert into tbl_array_map_types_dup (c_varchar) select c_varchar
from tbl_scalar_types_dup"
+ sql "insert into tbl_array_map_types_agg (c_varchar) select c_varchar
from tbl_scalar_types_dup"
exception null
}
test {
- sql "insert into tbl_array_map_types_dup (c_string) select c_string
from tbl_scalar_types_dup"
+ sql "insert into tbl_array_map_types_agg (c_string) select c_string
from tbl_scalar_types_dup"
exception null
}
- qt_sql_nested_table_array_map_dup_c """select count() from
tbl_array_map_types_dup;"""
+ qt_sql_nested_table_array_map_agg_c """select count() from
tbl_array_map_types_agg;"""
// test action for map with scala array-scala
// test action for scala to array with array-scala type
test {
- sql "insert into tbl_map_array_types_dup (c_bool) select c_bool from
tbl_scalar_types_dup"
+ sql "insert into tbl_map_array_types_agg (c_bool) select c_bool from
tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type BOOLEAN to target type=MAP<BOOLEAN,ARRAY<BOOLEAN>>")
}
test {
- sql "insert into tbl_map_array_types_dup (c_tinyint) select c_tinyint
from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=MAP<TINYINT(4),ARRAY<TINYINT(4)>>")
+ sql "insert into tbl_map_array_types_agg (c_tinyint) select c_tinyint
from tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=MAP<TINYINT,ARRAY<TINYINT>>")
}
test {
- sql "insert into tbl_map_array_types_dup (c_smallint) select
c_smallint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target
type=MAP<SMALLINT(6),ARRAY<SMALLINT(6)>>")
+ sql "insert into tbl_map_array_types_agg (c_smallint) select
c_smallint from tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=MAP<SMALLINT,ARRAY<SMALLINT>>")
}
test {
- sql "insert into tbl_map_array_types_dup (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=MAP<INT(11),ARRAY<INT(11)>>")
+ sql "insert into tbl_map_array_types_agg (c_int) select c_int from
tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=MAP<INT,ARRAY<INT>>")
}
test {
- sql "insert into tbl_map_array_types_dup (c_largeint) select
c_largeint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target
type=MAP<LARGEINT(40),ARRAY<LARGEINT(40)>>")
+ sql "insert into tbl_map_array_types_agg (c_largeint) select
c_largeint from tbl_scalar_types_dup"
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=MAP<LARGEINT,ARRAY<LARGEINT>>")
}
test {
- sql "insert into tbl_map_array_types_dup (c_float) select c_float from
tbl_scalar_types_dup"
+ sql "insert into tbl_map_array_types_agg (c_float) select c_float from
tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type FLOAT to target type=MAP<FLOAT,ARRAY<FLOAT>>")
}
test {
- sql "insert into tbl_map_array_types_dup (c_double) select c_double
from tbl_scalar_types_dup"
+ sql "insert into tbl_map_array_types_agg (c_double) select c_double
from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DOUBLE to target type=MAP<DOUBLE,ARRAY<DOUBLE>>")
}
test {
- sql "insert into tbl_map_array_types_dup (c_decimal) select c_decimal
from tbl_scalar_types_dup"
+ sql "insert into tbl_map_array_types_agg (c_decimal) select c_decimal
from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DECIMALV3(20, 3) to target type=MAP<DECIMALV3(20,
3),ARRAY<DECIMALV3(20, 3)>>")
}
test {
- sql "insert into tbl_map_array_types_dup (c_decimalv3) select
c_decimalv3 from tbl_scalar_types_dup"
+ sql "insert into tbl_map_array_types_agg (c_decimalv3) select
c_decimalv3 from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DECIMALV3(20, 3) to target type=MAP<DECIMALV3(20,
3),ARRAY<DECIMALV3(20, 3)>>")
}
test {
- sql "insert into tbl_map_array_types_dup (c_date) select c_date from
tbl_scalar_types_dup"
+ sql "insert into tbl_map_array_types_agg (c_date) select c_date from
tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATEV2 to target type=MAP<DATEV2,ARRAY<DATEV2>>")
}
test {
- sql "insert into tbl_map_array_types_dup (c_datetime) select
c_datetime from tbl_scalar_types_dup"
+ sql "insert into tbl_map_array_types_agg (c_datetime) select
c_datetime from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATETIMEV2(0) to target
type=MAP<DATETIMEV2(0),ARRAY<DATETIMEV2(0)>>")
}
test {
- sql "insert into tbl_map_array_types_dup (c_datev2) select c_datev2
from tbl_scalar_types_dup"
+ sql "insert into tbl_map_array_types_agg (c_datev2) select c_datev2
from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATEV2 to target type=MAP<DATEV2,ARRAY<DATEV2>>")
}
test {
- sql "insert into tbl_map_array_types_dup (c_datetimev2) select
c_datetimev2 from tbl_scalar_types_dup"
+ sql "insert into tbl_map_array_types_agg (c_datetimev2) select
c_datetimev2 from tbl_scalar_types_dup"
exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type DATETIMEV2(0) to target
type=MAP<DATETIMEV2(0),ARRAY<DATETIMEV2(0)>>")
}
test {
- sql "insert into tbl_map_array_types_dup (c_char) select c_char from
tbl_scalar_types_dup"
+ sql "insert into tbl_map_array_types_agg (c_char) select c_char from
tbl_scalar_types_dup"
exception null
}
test {
- sql "insert into tbl_map_array_types_dup (c_varchar) select c_varchar
from tbl_scalar_types_dup"
+ sql "insert into tbl_map_array_types_agg (c_varchar) select c_varchar
from tbl_scalar_types_dup"
exception null
}
test {
- sql "insert into tbl_map_array_types_dup (c_string) select c_string
from tbl_scalar_types_dup"
+ sql "insert into tbl_map_array_types_agg (c_string) select c_string
from tbl_scalar_types_dup"
exception null
}
- qt_sql_nested_table_map_array_dup_c """select count() from
tbl_map_array_types_dup;"""
+ qt_sql_nested_table_map_array_agg_c """select count() from
tbl_map_array_types_agg;"""
}
diff --git
a/regression-test/suites/datatype_p0/nested_types/negative_cases/test_nested_types_insert_into_with_dup_table.groovy
b/regression-test/suites/datatype_p0/nested_types/negative_cases/test_nested_types_insert_into_with_dup_table.groovy
index e8e9b363da..f6ce940868 100644
---
a/regression-test/suites/datatype_p0/nested_types/negative_cases/test_nested_types_insert_into_with_dup_table.groovy
+++
b/regression-test/suites/datatype_p0/nested_types/negative_cases/test_nested_types_insert_into_with_dup_table.groovy
@@ -30,22 +30,22 @@ suite("test_nested_types_insert_into_with_dup_table", "p0")
{
test {
sql "insert into tbl_array_nested_types_dup (c_tinyint) select
c_tinyint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<TINYINT(4)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<TINYINT>")
}
test {
sql "insert into tbl_array_nested_types_dup (c_smallint) select
c_smallint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<SMALLINT(6)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<SMALLINT>")
}
test {
sql "insert into tbl_array_nested_types_dup (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<INT(11)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<INT>")
}
test {
sql "insert into tbl_array_nested_types_dup (c_largeint) select
c_largeint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<LARGEINT(40)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<LARGEINT>")
}
test {
@@ -113,22 +113,22 @@ suite("test_nested_types_insert_into_with_dup_table",
"p0") {
test {
sql "insert into tbl_array_nested_types_dup2 (c_tinyint) select
c_tinyint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<ARRAY<TINYINT(4)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<ARRAY<TINYINT>>")
}
test {
sql "insert into tbl_array_nested_types_dup2 (c_smallint) select
c_smallint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<ARRAY<SMALLINT(6)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<ARRAY<SMALLINT>>")
}
test {
sql "insert into tbl_array_nested_types_dup2 (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<ARRAY<INT(11)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<ARRAY<INT>>")
}
test {
sql "insert into tbl_array_nested_types_dup2 (c_largeint) select
c_largeint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<ARRAY<LARGEINT(40)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<ARRAY<LARGEINT>>")
}
test {
@@ -197,22 +197,22 @@ suite("test_nested_types_insert_into_with_dup_table",
"p0") {
test {
sql "insert into tbl_map_types_dup (c_tinyint) select c_tinyint from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=MAP<TINYINT(4),TINYINT(4)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=MAP<TINYINT,TINYINT>")
}
test {
sql "insert into tbl_map_types_dup (c_smallint) select c_smallint from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=MAP<SMALLINT(6),SMALLINT(6)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=MAP<SMALLINT,SMALLINT>")
}
test {
sql "insert into tbl_map_types_dup (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=MAP<INT(11),INT(11)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=MAP<INT,INT>")
}
test {
sql "insert into tbl_map_types_dup (c_largeint) select c_largeint from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=MAP<LARGEINT(40),LARGEINT(40)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=MAP<LARGEINT,LARGEINT>")
}
test {
@@ -280,22 +280,22 @@ suite("test_nested_types_insert_into_with_dup_table",
"p0") {
test {
sql "insert into tbl_array_map_types_dup (c_tinyint) select c_tinyint
from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<MAP<TINYINT(4),TINYINT(4)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<MAP<TINYINT,TINYINT>>")
}
test {
sql "insert into tbl_array_map_types_dup (c_smallint) select
c_smallint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target
type=ARRAY<MAP<SMALLINT(6),SMALLINT(6)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<MAP<SMALLINT,SMALLINT>>")
}
test {
sql "insert into tbl_array_map_types_dup (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<MAP<INT(11),INT(11)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<MAP<INT,INT>>")
}
test {
sql "insert into tbl_array_map_types_dup (c_largeint) select
c_largeint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target
type=ARRAY<MAP<LARGEINT(40),LARGEINT(40)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<MAP<LARGEINT,LARGEINT>>")
}
test {
@@ -364,22 +364,22 @@ suite("test_nested_types_insert_into_with_dup_table",
"p0") {
test {
sql "insert into tbl_map_array_types_dup (c_tinyint) select c_tinyint
from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=MAP<TINYINT(4),ARRAY<TINYINT(4)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=MAP<TINYINT,ARRAY<TINYINT>>")
}
test {
sql "insert into tbl_map_array_types_dup (c_smallint) select
c_smallint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target
type=MAP<SMALLINT(6),ARRAY<SMALLINT(6)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=MAP<SMALLINT,ARRAY<SMALLINT>>")
}
test {
sql "insert into tbl_map_array_types_dup (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=MAP<INT(11),ARRAY<INT(11)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=MAP<INT,ARRAY<INT>>")
}
test {
sql "insert into tbl_map_array_types_dup (c_largeint) select
c_largeint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target
type=MAP<LARGEINT(40),ARRAY<LARGEINT(40)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=MAP<LARGEINT,ARRAY<LARGEINT>>")
}
test {
diff --git
a/regression-test/suites/datatype_p0/nested_types/negative_cases/test_nested_types_insert_into_with_unique_table.groovy
b/regression-test/suites/datatype_p0/nested_types/negative_cases/test_nested_types_insert_into_with_unique_table.groovy
index 2e7f8257c6..9956a88e4c 100644
---
a/regression-test/suites/datatype_p0/nested_types/negative_cases/test_nested_types_insert_into_with_unique_table.groovy
+++
b/regression-test/suites/datatype_p0/nested_types/negative_cases/test_nested_types_insert_into_with_unique_table.groovy
@@ -31,22 +31,22 @@ suite("test_nested_types_insert_into_with_unique_table",
"p0") {
test {
sql "insert into tbl_array_nested_types_mor (c_tinyint) select
c_tinyint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<TINYINT(4)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<TINYINT>")
}
test {
sql "insert into tbl_array_nested_types_mor (c_smallint) select
c_smallint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<SMALLINT(6)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<SMALLINT>")
}
test {
sql "insert into tbl_array_nested_types_mor (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<INT(11)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<INT>")
}
test {
sql "insert into tbl_array_nested_types_mor (c_largeint) select
c_largeint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<LARGEINT(40)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<LARGEINT>")
}
test {
@@ -114,22 +114,22 @@ suite("test_nested_types_insert_into_with_unique_table",
"p0") {
test {
sql "insert into tbl_array_nested_types_mor2 (c_tinyint) select
c_tinyint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<ARRAY<TINYINT(4)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<ARRAY<TINYINT>>")
}
test {
sql "insert into tbl_array_nested_types_mor2 (c_smallint) select
c_smallint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<ARRAY<SMALLINT(6)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<ARRAY<SMALLINT>>")
}
test {
sql "insert into tbl_array_nested_types_mor2 (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<ARRAY<INT(11)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<ARRAY<INT>>")
}
test {
sql "insert into tbl_array_nested_types_mor2 (c_largeint) select
c_largeint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<ARRAY<LARGEINT(40)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<ARRAY<LARGEINT>>")
}
test {
@@ -198,22 +198,22 @@ suite("test_nested_types_insert_into_with_unique_table",
"p0") {
test {
sql "insert into tbl_map_types_mor (c_tinyint) select c_tinyint from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=MAP<TINYINT(4),TINYINT(4)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=MAP<TINYINT,TINYINT>")
}
test {
sql "insert into tbl_map_types_mor (c_smallint) select c_smallint from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=MAP<SMALLINT(6),SMALLINT(6)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=MAP<SMALLINT,SMALLINT>")
}
test {
sql "insert into tbl_map_types_mor (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=MAP<INT(11),INT(11)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=MAP<INT,INT>")
}
test {
sql "insert into tbl_map_types_mor (c_largeint) select c_largeint from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=MAP<LARGEINT(40),LARGEINT(40)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=MAP<LARGEINT,LARGEINT>")
}
test {
@@ -281,22 +281,22 @@ suite("test_nested_types_insert_into_with_unique_table",
"p0") {
test {
sql "insert into tbl_array_map_types_mor (c_tinyint) select c_tinyint
from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<MAP<TINYINT(4),TINYINT(4)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<MAP<TINYINT,TINYINT>>")
}
test {
sql "insert into tbl_array_map_types_mor (c_smallint) select
c_smallint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target
type=ARRAY<MAP<SMALLINT(6),SMALLINT(6)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<MAP<SMALLINT,SMALLINT>>")
}
test {
sql "insert into tbl_array_map_types_mor (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<MAP<INT(11),INT(11)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<MAP<INT,INT>>")
}
test {
sql "insert into tbl_array_map_types_mor (c_largeint) select
c_largeint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target
type=ARRAY<MAP<LARGEINT(40),LARGEINT(40)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<MAP<LARGEINT,LARGEINT>>")
}
test {
@@ -365,22 +365,22 @@ suite("test_nested_types_insert_into_with_unique_table",
"p0") {
test {
sql "insert into tbl_map_array_types_mor (c_tinyint) select c_tinyint
from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=MAP<TINYINT(4),ARRAY<TINYINT(4)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=MAP<TINYINT,ARRAY<TINYINT>>")
}
test {
sql "insert into tbl_map_array_types_mor (c_smallint) select
c_smallint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target
type=MAP<SMALLINT(6),ARRAY<SMALLINT(6)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=MAP<SMALLINT,ARRAY<SMALLINT>>")
}
test {
sql "insert into tbl_map_array_types_mor (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=MAP<INT(11),ARRAY<INT(11)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=MAP<INT,ARRAY<INT>>")
}
test {
sql "insert into tbl_map_array_types_mor (c_largeint) select
c_largeint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target
type=MAP<LARGEINT(40),ARRAY<LARGEINT(40)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=MAP<LARGEINT,ARRAY<LARGEINT>>")
}
test {
@@ -449,22 +449,22 @@ suite("test_nested_types_insert_into_with_unique_table",
"p0") {
test {
sql "insert into tbl_array_nested_types_mow (c_tinyint) select
c_tinyint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<TINYINT(4)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<TINYINT>")
}
test {
sql "insert into tbl_array_nested_types_mow (c_smallint) select
c_smallint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<SMALLINT(6)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<SMALLINT>")
}
test {
sql "insert into tbl_array_nested_types_mow (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<INT(11)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<INT>")
}
test {
sql "insert into tbl_array_nested_types_mow (c_largeint) select
c_largeint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<LARGEINT(40)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<LARGEINT>")
}
test {
@@ -532,22 +532,22 @@ suite("test_nested_types_insert_into_with_unique_table",
"p0") {
test {
sql "insert into tbl_array_nested_types_mow2 (c_tinyint) select
c_tinyint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<ARRAY<TINYINT(4)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<ARRAY<TINYINT>>")
}
test {
sql "insert into tbl_array_nested_types_mow2 (c_smallint) select
c_smallint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<ARRAY<SMALLINT(6)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<ARRAY<SMALLINT>>")
}
test {
sql "insert into tbl_array_nested_types_mow2 (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<ARRAY<INT(11)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<ARRAY<INT>>")
}
test {
sql "insert into tbl_array_nested_types_mow2 (c_largeint) select
c_largeint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<ARRAY<LARGEINT(40)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<ARRAY<LARGEINT>>")
}
test {
@@ -616,22 +616,22 @@ suite("test_nested_types_insert_into_with_unique_table",
"p0") {
test {
sql "insert into tbl_map_types_mow (c_tinyint) select c_tinyint from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=MAP<TINYINT(4),TINYINT(4)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=MAP<TINYINT,TINYINT>")
}
test {
sql "insert into tbl_map_types_mow (c_smallint) select c_smallint from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=MAP<SMALLINT(6),SMALLINT(6)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=MAP<SMALLINT,SMALLINT>")
}
test {
sql "insert into tbl_map_types_mow (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=MAP<INT(11),INT(11)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=MAP<INT,INT>")
}
test {
sql "insert into tbl_map_types_mow (c_largeint) select c_largeint from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=MAP<LARGEINT(40),LARGEINT(40)>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=MAP<LARGEINT,LARGEINT>")
}
test {
@@ -699,22 +699,22 @@ suite("test_nested_types_insert_into_with_unique_table",
"p0") {
test {
sql "insert into tbl_array_map_types_mow (c_tinyint) select c_tinyint
from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<MAP<TINYINT(4),TINYINT(4)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=ARRAY<MAP<TINYINT,TINYINT>>")
}
test {
sql "insert into tbl_array_map_types_mow (c_smallint) select
c_smallint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target
type=ARRAY<MAP<SMALLINT(6),SMALLINT(6)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=ARRAY<MAP<SMALLINT,SMALLINT>>")
}
test {
sql "insert into tbl_array_map_types_mow (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<MAP<INT(11),INT(11)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=ARRAY<MAP<INT,INT>>")
}
test {
sql "insert into tbl_array_map_types_mow (c_largeint) select
c_largeint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target
type=ARRAY<MAP<LARGEINT(40),LARGEINT(40)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=ARRAY<MAP<LARGEINT,LARGEINT>>")
}
test {
@@ -783,22 +783,22 @@ suite("test_nested_types_insert_into_with_unique_table",
"p0") {
test {
sql "insert into tbl_map_array_types_mow (c_tinyint) select c_tinyint
from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=MAP<TINYINT(4),ARRAY<TINYINT(4)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type TINYINT to target type=MAP<TINYINT,ARRAY<TINYINT>>")
}
test {
sql "insert into tbl_map_array_types_mow (c_smallint) select
c_smallint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target
type=MAP<SMALLINT(6),ARRAY<SMALLINT(6)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type SMALLINT to target type=MAP<SMALLINT,ARRAY<SMALLINT>>")
}
test {
sql "insert into tbl_map_array_types_mow (c_int) select c_int from
tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=MAP<INT(11),ARRAY<INT(11)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type INT to target type=MAP<INT,ARRAY<INT>>")
}
test {
sql "insert into tbl_map_array_types_mow (c_largeint) select
c_largeint from tbl_scalar_types_dup"
- exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target
type=MAP<LARGEINT(40),ARRAY<LARGEINT(40)>>")
+ exception("java.sql.SQLException: errCode = 2, detailMessage = can not
cast from origin type LARGEINT to target type=MAP<LARGEINT,ARRAY<LARGEINT>>")
}
test {
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
