This is an automated email from the ASF dual-hosted git repository.
hellostephen 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 62b00a68fb2 [fix](case) broker load cases compactibility (#56870)
62b00a68fb2 is described below
commit 62b00a68fb2ccad4e9b6172237f4a945ef878741
Author: shuke <[email protected]>
AuthorDate: Fri Oct 24 16:21:00 2025 +0800
[fix](case) broker load cases compactibility (#56870)
---
.../data/load_p0/broker_load/test_array_load.out | 48 +++++++++++++++++++
.../test_broker_load_with_partition.out | 11 ++---
.../broker_load/test_broker_load_with_where.out | 4 +-
.../load_p0/broker_load/test_array_load.groovy | 54 ++++++++++++++--------
.../test_broker_load_with_partition.groovy | 10 ++--
.../broker_load/test_broker_load_with_where.groovy | 2 +-
.../test_broker_load_without_filepath.groovy | 2 +-
7 files changed, 95 insertions(+), 36 deletions(-)
diff --git a/regression-test/data/load_p0/broker_load/test_array_load.out
b/regression-test/data/load_p0/broker_load/test_array_load.out
index 655d821501d..c2cc6789311 100644
--- a/regression-test/data/load_p0/broker_load/test_array_load.out
+++ b/regression-test/data/load_p0/broker_load/test_array_load.out
@@ -97,3 +97,51 @@
5 [null, null] [32767, 32768, null] [65534, null, 65536] ["a",
"b", "c", "d", "e"] ["hello", "world"] ["1991-01-01"] ["1991-01-01
00:00:00"] [0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000,
1.300000]
100 [1, 2, 3] [32767, 32768, 32769] [65534, 65535, 65536] ["a",
"b", "c"] ["hello", "world"] ["2022-07-13"] ["2022-07-13 12:30:00"]
[0.33, 0.67] [3.1415926, 0.878787878] [4.000000, 5.500000, 6.670000]
+-- !select --
+1 [1, 2, 3, 4, 5] [32767, 32768, 32769] [65534, 65535, 65536] ["a",
"b", "c", "d", "e"] ["hello", "world"] ["1991-01-01"] ["1991-01-01
00:00:00"] [0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000,
1.300000]
+2 [6, 7, 8, 9, 10] [32767, 32768, 32769] [65534, 65535, 65536]
["a", "b", "c", "d", "e"] ["hello", "world"] ["1991-01-01"]
["1991-01-01 00:00:00"] [0.33, 0.67] [3.1415926, 0.878787878]
[1.000000, 1.200000, 1.300000]
+3 [] [32767, 32768, 32769] [null, null, 65536] ["a", "b", "c",
"d", "e"] ["happy", "birthday"] ["1991-01-01"] ["1991-01-01 00:00:00"]
[0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000, 1.300000]
+4 [null] [32767, 32768, 32769] [null, null, 65536] ["a", "b", "c",
"d", "e"] ["hello", "world"] ["1991-01-01"] ["1991-01-01 00:00:00"]
[0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000, 1.300000]
+5 [null, null] [32767, 32768, null] [65534, null, 65536] ["a",
"b", "c", "d", "e"] ["hello", "world"] ["1991-01-01"] ["1991-01-01
00:00:00"] [0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000,
1.300000]
+100 [1, 2, 3] [32767, 32768, 32769] [65534, 65535, 65536] ["a",
"b", "c"] ["hello", "world"] ["2022-07-13"] ["2022-07-13 12:30:00"]
[0.33, 0.67] [3.1415926, 0.878787878] [4.000000, 5.500000, 6.670000]
+
+-- !select --
+1 [1, 2, 3, 4, 5] [32767, 32768, 32769] [65534, 65535, 65536] ["a",
"b", "c", "d", "e"] ["hello", "world"] ["1991-01-01"] ["1991-01-01
00:00:00"] [0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000,
1.300000]
+2 [6, 7, 8, 9, 10] [32767, 32768, 32769] [65534, 65535, 65536]
["a", "b", "c", "d", "e"] ["hello", "world"] ["1991-01-01"]
["1991-01-01 00:00:00"] [0.33, 0.67] [3.1415926, 0.878787878]
[1.000000, 1.200000, 1.300000]
+3 [] [32767, 32768, 32769] [null, null, 65536] ["a", "b", "c",
"d", "e"] ["happy", "birthday"] ["1991-01-01"] ["1991-01-01 00:00:00"]
[0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000, 1.300000]
+4 [null] [32767, 32768, 32769] [null, null, 65536] ["a", "b", "c",
"d", "e"] ["hello", "world"] ["1991-01-01"] ["1991-01-01 00:00:00"]
[0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000, 1.300000]
+5 [null, null] [32767, 32768, null] [65534, null, 65536] ["a",
"b", "c", "d", "e"] ["hello", "world"] ["1991-01-01"] ["1991-01-01
00:00:00"] [0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000,
1.300000]
+100 [1, 2, 3] [32767, 32768, 32769] [65534, 65535, 65536] ["a",
"b", "c"] ["hello", "world"] ["2022-07-13"] ["2022-07-13 12:30:00"]
[0.33, 0.67] [3.1415926, 0.878787878] [4.000000, 5.500000, 6.670000]
+
+-- !select --
+1 [1, 2, 3, 4, 5] [32767, 32768, 32769] [65534, 65535, 65536] ["a",
"b", "c", "d", "e"] ["hello", "world"] ["1991-01-01"] ["1991-01-01
00:00:00"] [0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000,
1.300000]
+2 [6, 7, 8, 9, 10] [32767, 32768, 32769] [65534, 65535, 65536]
["a", "b", "c", "d", "e"] ["hello", "world"] ["1991-01-01"]
["1991-01-01 00:00:00"] [0.33, 0.67] [3.1415926, 0.878787878]
[1.000000, 1.200000, 1.300000]
+3 [] [32767, 32768, 32769] [null, null, 65536] ["a", "b", "c",
"d", "e"] ["happy", "birthday"] ["1991-01-01"] ["1991-01-01 00:00:00"]
[0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000, 1.300000]
+4 [null] [32767, 32768, 32769] [null, null, 65536] ["a", "b", "c",
"d", "e"] ["hello", "world"] ["1991-01-01"] ["1991-01-01 00:00:00"]
[0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000, 1.300000]
+5 [null, null] [32767, 32768, null] [65534, null, 65536] ["a",
"b", "c", "d", "e"] ["hello", "world"] ["1991-01-01"] ["1991-01-01
00:00:00"] [0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000,
1.300000]
+100 [1, 2, 3] [32767, 32768, 32769] [65534, 65535, 65536] ["a",
"b", "c"] ["hello", "world"] ["2022-07-13"] ["2022-07-13 12:30:00"]
[0.33, 0.67] [3.1415926, 0.878787878] [4.000000, 5.500000, 6.670000]
+
+-- !select --
+1 [1, 2, 3, 4, 5] [32767, 32768, 32769] [65534, 65535, 65536] ["a",
"b", "c", "d", "e"] ["hello", "world"] ["1991-01-01"] ["1991-01-01
00:00:00"] [0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000,
1.300000]
+2 [6, 7, 8, 9, 10] [32767, 32768, 32769] [65534, 65535, 65536]
["a", "b", "c", "d", "e"] ["hello", "world"] ["1991-01-01"]
["1991-01-01 00:00:00"] [0.33, 0.67] [3.1415926, 0.878787878]
[1.000000, 1.200000, 1.300000]
+3 [] [32767, 32768, 32769] [null, null, 65536] ["a", "b", "c",
"d", "e"] ["happy", "birthday"] ["1991-01-01"] ["1991-01-01 00:00:00"]
[0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000, 1.300000]
+4 [null] [32767, 32768, 32769] [null, null, 65536] ["a", "b", "c",
"d", "e"] ["hello", "world"] ["1991-01-01"] ["1991-01-01 00:00:00"]
[0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000, 1.300000]
+5 [null, null] [32767, 32768, null] [65534, null, 65536] ["a",
"b", "c", "d", "e"] ["hello", "world"] ["1991-01-01"] ["1991-01-01
00:00:00"] [0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000,
1.300000]
+100 [1, 2, 3] [32767, 32768, 32769] [65534, 65535, 65536] ["a",
"b", "c"] ["hello", "world"] ["2022-07-13"] ["2022-07-13 12:30:00"]
[0.33, 0.67] [3.1415926, 0.878787878] [4.000000, 5.500000, 6.670000]
+
+-- !select --
+1 [1, 2, 3, 4, 5] [32767, 32768, 32769] [65534, 65535, 65536] ["a",
"b", "c", "d", "e"] ["hello", "world"] ["1991-01-01"] ["1991-01-01
00:00:00"] [0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000,
1.300000]
+2 [6, 7, 8, 9, 10] [32767, 32768, 32769] [65534, 65535, 65536]
["a", "b", "c", "d", "e"] ["hello", "world"] ["1991-01-01"]
["1991-01-01 00:00:00"] [0.33, 0.67] [3.1415926, 0.878787878]
[1.000000, 1.200000, 1.300000]
+3 [] [32767, 32768, 32769] [null, null, 65536] ["a", "b", "c",
"d", "e"] ["happy", "birthday"] ["1991-01-01"] ["1991-01-01 00:00:00"]
[0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000, 1.300000]
+4 [null] [32767, 32768, 32769] [null, null, 65536] ["a", "b", "c",
"d", "e"] ["hello", "world"] ["1991-01-01"] ["1991-01-01 00:00:00"]
[0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000, 1.300000]
+5 [null, null] [32767, 32768, null] [65534, null, 65536] ["a",
"b", "c", "d", "e"] ["hello", "world"] ["1991-01-01"] ["1991-01-01
00:00:00"] [0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000,
1.300000]
+100 [1, 2, 3] [32767, 32768, 32769] [65534, 65535, 65536] ["a",
"b", "c"] ["hello", "world"] ["2022-07-13"] ["2022-07-13 12:30:00"]
[0.33, 0.67] [3.1415926, 0.878787878] [4.000000, 5.500000, 6.670000]
+
+-- !select --
+1 [1, 2, 3, 4, 5] [32767, 32768, 32769] [65534, 65535, 65536] ["a",
"b", "c", "d", "e"] ["hello", "world"] ["1991-01-01"] ["1991-01-01
00:00:00"] [0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000,
1.300000]
+2 [6, 7, 8, 9, 10] [32767, 32768, 32769] [65534, 65535, 65536]
["a", "b", "c", "d", "e"] ["hello", "world"] ["1991-01-01"]
["1991-01-01 00:00:00"] [0.33, 0.67] [3.1415926, 0.878787878]
[1.000000, 1.200000, 1.300000]
+3 [] [32767, 32768, 32769] [null, null, 65536] ["a", "b", "c",
"d", "e"] ["happy", "birthday"] ["1991-01-01"] ["1991-01-01 00:00:00"]
[0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000, 1.300000]
+4 [null] [32767, 32768, 32769] [null, null, 65536] ["a", "b", "c",
"d", "e"] ["hello", "world"] ["1991-01-01"] ["1991-01-01 00:00:00"]
[0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000, 1.300000]
+5 [null, null] [32767, 32768, null] [65534, null, 65536] ["a",
"b", "c", "d", "e"] ["hello", "world"] ["1991-01-01"] ["1991-01-01
00:00:00"] [0.33, 0.67] [3.1415926, 0.878787878] [1.000000, 1.200000,
1.300000]
+100 [1, 2, 3] [32767, 32768, 32769] [65534, 65535, 65536] ["a",
"b", "c"] ["hello", "world"] ["2022-07-13"] ["2022-07-13 12:30:00"]
[0.33, 0.67] [3.1415926, 0.878787878] [4.000000, 5.500000, 6.670000]
+
diff --git
a/regression-test/data/load_p0/broker_load/test_broker_load_with_partition.out
b/regression-test/data/load_p0/broker_load/test_broker_load_with_partition.out
index e62e67a8f74..f7f56830372 100644
---
a/regression-test/data/load_p0/broker_load/test_broker_load_with_partition.out
+++
b/regression-test/data/load_p0/broker_load/test_broker_load_with_partition.out
@@ -1,18 +1,15 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !select --
-1 \N 1 1 1
-11001 2023-10-01 1 3 10
-11001 2023-10-01 2 2 10
-11001 2023-10-01 2 3 10
+1 2023-09-01 1 1 1
11001 2023-09-01 1 1 10
11001 2023-09-01 1 2 10
11001 2023-09-01 2 1 10
-- !select --
-11001 2023-10-01 1 3 10
-11001 2023-10-01 2 2 10
-11001 2023-10-01 2 3 10
11001 2023-09-01 1 1 10
11001 2023-09-01 1 2 10
11001 2023-09-01 2 1 10
+11001 2023-10-01 1 3 10
+11001 2023-10-01 2 2 10
+11001 2023-10-01 2 3 10
diff --git
a/regression-test/data/load_p0/broker_load/test_broker_load_with_where.out
b/regression-test/data/load_p0/broker_load/test_broker_load_with_where.out
index 98e4b6d7a97..74078a91999 100644
--- a/regression-test/data/load_p0/broker_load/test_broker_load_with_where.out
+++ b/regression-test/data/load_p0/broker_load/test_broker_load_with_where.out
@@ -1,6 +1,6 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !select --
-1 \N 1 1 1
+1 2023-09-01 1 1 1
11001 2023-09-01 1 1 10
11001 2023-09-01 1 2 10
11001 2023-09-01 1 3 10
@@ -9,7 +9,7 @@
11001 2023-09-01 2 3 10
-- !select --
-1 \N 1 1 1
+1 2023-09-01 1 1 1
11001 2023-09-01 1 1 10
11001 2023-09-01 1 2 10
11001 2023-09-01 1 3 10
diff --git a/regression-test/suites/load_p0/broker_load/test_array_load.groovy
b/regression-test/suites/load_p0/broker_load/test_array_load.groovy
index 99c4f58bef1..8120885df60 100644
--- a/regression-test/suites/load_p0/broker_load/test_array_load.groovy
+++ b/regression-test/suites/load_p0/broker_load/test_array_load.groovy
@@ -172,6 +172,20 @@ suite("test_array_load", "load_p0,external") {
assertTrue(result1[0][0] == 0, "Query OK, 0 rows affected")
}
+ def load_from_tvf = { testTablex, label, hdfsFilePath, format, brokerName,
hdfsUser, hdfsPasswd ->
+ def result1= sql """
+ insert into ${testTablex} select * from
+ hdfs(
+ "uri" = "${hdfsFilePath}",
+ "fs.defaultFS" = "${context.config.otherConfigs.get('hdfsFs')}",
+ "hadoop.username" = "${hdfsUser}",
+ "password"="${hdfsPasswd}",
+ "column_separator" = "/",
+ "format" = "${format}"); """
+
+ logger.info("result1: ${result1}")
+ }
+
def check_load_result = {checklabel, testTablex ->
def max_try_milli_secs = 10000
while(max_try_milli_secs) {
@@ -329,10 +343,11 @@ suite("test_array_load", "load_p0,external") {
create_test_table.call(testTable)
def test_load_label = UUID.randomUUID().toString().replaceAll("-",
"")
- load_from_hdfs1.call(testTable, test_load_label,
hdfs_orc_file_path, "orc",
- brokerName, hdfsUser, hdfsPasswd)
-
- check_load_result.call(test_load_label, testTable)
+ //load_from_hdfs1.call(testTable, test_load_label,
hdfs_orc_file_path, "orc",
+ // brokerName, hdfsUser, hdfsPasswd)
+ load_from_tvf(testTable, test_load_label, hdfs_orc_file_path,
"orc", brokerName, hdfsUser, hdfsPasswd)
+ qt_select "select * from ${testTable} order by k1"
+ //check_load_result.call(test_load_label, testTable)
} finally {
try_sql("DROP TABLE IF EXISTS ${testTable}")
@@ -346,10 +361,10 @@ suite("test_array_load", "load_p0,external") {
create_test_table.call(testTable)
def test_load_label = UUID.randomUUID().toString().replaceAll("-",
"")
- load_from_hdfs1.call(testTable, test_load_label,
hdfs_orc_file_path, "orc",
+ load_from_tvf(testTable, test_load_label, hdfs_orc_file_path,
"orc",
brokerName, hdfsUser, hdfsPasswd)
-
- check_load_result.call(test_load_label, testTable)
+ qt_select "select * from ${testTable} order by k1"
+ //check_load_result.call(test_load_label, testTable)
} finally {
try_sql("DROP TABLE IF EXISTS ${testTable}")
@@ -362,10 +377,10 @@ suite("test_array_load", "load_p0,external") {
create_test_table.call(testTable)
def test_load_label = UUID.randomUUID().toString().replaceAll("-",
"")
- load_from_hdfs1.call(testTable, test_load_label,
hdfs_parquet_file_path, "parquet",
+ load_from_tvf(testTable, test_load_label, hdfs_parquet_file_path,
"parquet",
brokerName, hdfsUser, hdfsPasswd)
-
- check_load_result.call(test_load_label, testTable)
+ qt_select "select * from ${testTable} order by k1"
+ //check_load_result.call(test_load_label, testTable)
} finally {
try_sql("DROP TABLE IF EXISTS ${testTable}")
@@ -377,10 +392,10 @@ suite("test_array_load", "load_p0,external") {
create_test_table.call(testTable)
def test_load_label = UUID.randomUUID().toString().replaceAll("-",
"")
- load_from_hdfs1.call(testTable, test_load_label,
hdfs_parquet_file_path, "parquet",
+ load_from_tvf(testTable, test_load_label, hdfs_parquet_file_path,
"parquet",
brokerName, hdfsUser, hdfsPasswd)
-
- check_load_result.call(test_load_label, testTable)
+ qt_select "select * from ${testTable} order by k1"
+ //check_load_result.call(test_load_label, testTable)
} finally {
try_sql("DROP TABLE IF EXISTS ${testTable}")
@@ -393,10 +408,10 @@ suite("test_array_load", "load_p0,external") {
create_test_table.call(testTable)
def test_load_label = UUID.randomUUID().toString().replaceAll("-",
"")
- load_from_hdfs1.call(testTable, test_load_label,
hdfs_orc_file_path2, "orc",
+ load_from_tvf(testTable, test_load_label, hdfs_orc_file_path2,
"orc",
brokerName, hdfsUser, hdfsPasswd)
-
- check_load_result.call(test_load_label, testTable)
+ qt_select "select * from ${testTable} order by k1"
+ //check_load_result.call(test_load_label, testTable)
} finally {
try_sql("DROP TABLE IF EXISTS ${testTable}")
@@ -408,13 +423,12 @@ suite("test_array_load", "load_p0,external") {
create_test_table.call(testTable)
def test_load_label = UUID.randomUUID().toString().replaceAll("-",
"")
- load_from_hdfs1.call(testTable, test_load_label,
hdfs_orc_file_path2, "orc",
+ load_from_tvf(testTable, test_load_label, hdfs_orc_file_path2,
"orc",
brokerName, hdfsUser, hdfsPasswd)
-
- check_load_result.call(test_load_label, testTable)
+ qt_select "select * from ${testTable} order by k1"
+ //check_load_result.call(test_load_label, testTable)
} finally {
- try_sql("DROP TABLE IF EXISTS ${testTable}")
}
}
}
diff --git
a/regression-test/suites/load_p0/broker_load/test_broker_load_with_partition.groovy
b/regression-test/suites/load_p0/broker_load/test_broker_load_with_partition.groovy
index 8bbd1f05a3f..a6650c6164e 100644
---
a/regression-test/suites/load_p0/broker_load/test_broker_load_with_partition.groovy
+++
b/regression-test/suites/load_p0/broker_load/test_broker_load_with_partition.groovy
@@ -49,7 +49,7 @@ suite("test_broker_load_with_partition", "load_p0,external") {
// insert 1 row to check whether the table is ok
def result2 = sql """ INSERT INTO ${testTable} VALUES
- (1,2023-09-01,1,1,1)
+ (1,"2023-09-01",1,1,1)
"""
assertTrue(result2.size() == 1)
assertTrue(result2[0].size() == 1)
@@ -81,7 +81,7 @@ suite("test_broker_load_with_partition", "load_p0,external") {
)
PROPERTIES (
"timeout"="1200",
- "max_filter_ratio"="0.1");
+ "max_filter_ratio"="0.8");
"""
assertTrue(result1.size() == 1)
@@ -122,7 +122,7 @@ suite("test_broker_load_with_partition",
"load_p0,external") {
log.info("result: ${result}")
if(result[0][2] == "FINISHED") {
//sql "sync"
- qt_select "select * from ${testTablex} order by k1"
+ qt_select "select * from ${testTablex} order by 1,2,3,4,5"
break
} else {
sleep(1000) // wait 1 second every time
@@ -141,7 +141,7 @@ suite("test_broker_load_with_partition",
"load_p0,external") {
log.info("result: ${result}")
if(result[0][2] == "FINISHED") {
//sql "sync"
- qt_select "select * from ${testTablex} TEMPORARY PARTITION
(`partition_t`) order by k1"
+ qt_select "select * from ${testTablex} TEMPORARY PARTITION
(`partition_t`) order by 1,2,3,4,5"
break
} else {
sleep(1000) // wait 1 second every time
@@ -178,7 +178,7 @@ suite("test_broker_load_with_partition",
"load_p0,external") {
check_load_tmp_partition_result.call(test_tmp_partition_load_label, testTable)
} finally {
- try_sql("DROP TABLE IF EXISTS ${testTable}")
+// try_sql("DROP TABLE IF EXISTS ${testTable}")
}
}
}
diff --git
a/regression-test/suites/load_p0/broker_load/test_broker_load_with_where.groovy
b/regression-test/suites/load_p0/broker_load/test_broker_load_with_where.groovy
index b52550d97e2..d7a0a7d9710 100644
---
a/regression-test/suites/load_p0/broker_load/test_broker_load_with_where.groovy
+++
b/regression-test/suites/load_p0/broker_load/test_broker_load_with_where.groovy
@@ -44,7 +44,7 @@ suite("test_broker_load_with_where", "load_p0,external") {
// insert 1 row to check whether the table is ok
def result2 = sql """ INSERT INTO ${testTable} VALUES
- (1,2023-09-01,1,1,1)
+ (1,"2023-09-01",1,1,1)
"""
assertTrue(result2.size() == 1)
assertTrue(result2[0].size() == 1)
diff --git
a/regression-test/suites/load_p0/broker_load/test_broker_load_without_filepath.groovy
b/regression-test/suites/load_p0/broker_load/test_broker_load_without_filepath.groovy
index 17dd20398f5..89b918d8190 100644
---
a/regression-test/suites/load_p0/broker_load/test_broker_load_without_filepath.groovy
+++
b/regression-test/suites/load_p0/broker_load/test_broker_load_without_filepath.groovy
@@ -46,7 +46,7 @@ suite("test_broker_load_without_filepath",
"load_p0,external") {
// insert 1 row to check whether the table is ok
def result2 = sql """ INSERT INTO ${testTable} VALUES
- (1,2023-09-01,1,1,1)
+ (1,"2023-09-01",1,1,1)
"""
assertTrue(result2.size() == 1)
assertTrue(result2[0].size() == 1)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
