This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
commit c962c3a0255c39e492678576d79657e04f602b6e
Author: lihangyu <15605149...@163.com>
AuthorDate: Tue May 21 14:01:59 2024 +0800
[regression-test](prepared statment) optimize prepared_stmt.groovy to make
test stable (#35087)
---
.../suites/prepared_stmt_p0/prepared_stmt.groovy | 28 +++++++++++++++-------
1 file changed, 19 insertions(+), 9 deletions(-)
diff --git a/regression-test/suites/prepared_stmt_p0/prepared_stmt.groovy
b/regression-test/suites/prepared_stmt_p0/prepared_stmt.groovy
index bf8959e5473..46f8d7629ca 100644
--- a/regression-test/suites/prepared_stmt_p0/prepared_stmt.groovy
+++ b/regression-test/suites/prepared_stmt_p0/prepared_stmt.groovy
@@ -97,15 +97,24 @@ suite("test_prepared_stmt", "nonConcurrent") {
)
"""
- def insert_stmt = prepareStatement """ INSERT INTO ${tableName}
VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?) """
- assertEquals(insert_stmt.class,
com.mysql.cj.jdbc.ServerPreparedStatement);
- insert_prepared insert_stmt, 1231, 119291.11, "ddd", "laooq", null,
"2020-01-01 12:36:38", null, "1022-01-01 11:30:38", "[2022-01-01 11:30:38,
2022-01-01 11:30:38, 2022-01-01 11:30:38]"
- insert_prepared insert_stmt, 1232, 12222.99121135, "xxx", "laooq",
"2023-01-02", "2020-01-01 12:36:38", 522.762, "2022-01-01 11:30:38",
"[2023-01-01 11:30:38, 2023-01-01 11:30:38]"
- insert_prepared insert_stmt, 1233, 1.392932911136, "yyy", "laooq",
"2024-01-02", "2020-01-01 12:36:38", 52.862, "3022-01-01 11:30:38",
"[2024-01-01 11:30:38, 2024-01-01 11:30:38, 2024-01-01 11:30:38]"
- insert_prepared insert_stmt, 1234, 12919291.129191137, "xxddd", "laooq",
"2025-01-02", "2020-01-01 12:36:38", 552.872, "4022-01-01 11:30:38",
"[2025-01-01 11:30:38, 2025-01-01 11:30:38, 2025-01-01 11:30:38]"
- insert_prepared insert_stmt, 1235, 991129292901.11138, "dd", null,
"2120-01-02", "2020-01-01 12:36:38", 652.692, "5022-01-01 11:30:38", "[]"
- insert_prepared insert_stmt, 1236, 100320.11139, "laa ddd", "laooq",
"2220-01-02", "2020-01-01 12:36:38", 2.7692, "6022-01-01 11:30:38", "[null]"
- insert_prepared insert_stmt, 1237, 120939.11130, "a ddd", "laooq",
"2030-01-02", "2020-01-01 12:36:38", 22.822, "7022-01-01 11:30:38",
"[2025-01-01 11:30:38]"
+ // def insert_stmt = prepareStatement """ INSERT INTO ${tableName}
VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?) """
+ // assertEquals(insert_stmt.class,
com.mysql.cj.jdbc.ServerPreparedStatement);
+ // insert_prepared insert_stmt, 1231, 119291.11, "ddd", "laooq", null,
"2020-01-01 12:36:38", null, "1022-01-01 11:30:38", "[2022-01-01 11:30:38,
2022-01-01 11:30:38, 2022-01-01 11:30:38]"
+ // insert_prepared insert_stmt, 1232, 12222.99121135, "xxx", "laooq",
"2023-01-02", "2020-01-01 12:36:38", 522.762, "2022-01-01 11:30:38",
"[2023-01-01 11:30:38, 2023-01-01 11:30:38]"
+ // insert_prepared insert_stmt, 1233, 1.392932911136, "yyy", "laooq",
"2024-01-02", "2020-01-01 12:36:38", 52.862, "3022-01-01 11:30:38",
"[2024-01-01 11:30:38, 2024-01-01 11:30:38, 2024-01-01 11:30:38]"
+ // insert_prepared insert_stmt, 1234, 12919291.129191137, "xxddd",
"laooq", "2025-01-02", "2020-01-01 12:36:38", 552.872, "4022-01-01 11:30:38",
"[2025-01-01 11:30:38, 2025-01-01 11:30:38, 2025-01-01 11:30:38]"
+ // insert_prepared insert_stmt, 1235, 991129292901.11138, "dd", null,
"2120-01-02", "2020-01-01 12:36:38", 652.692, "5022-01-01 11:30:38", "[]"
+ // insert_prepared insert_stmt, 1236, 100320.11139, "laa ddd", "laooq",
"2220-01-02", "2020-01-01 12:36:38", 2.7692, "6022-01-01 11:30:38", "[null]"
+ // insert_prepared insert_stmt, 1237, 120939.11130, "a ddd", "laooq",
"2030-01-02", "2020-01-01 12:36:38", 22.822, "7022-01-01 11:30:38",
"[2025-01-01 11:30:38]"
+
+ sql """ INSERT INTO ${tableName} VALUES(1231, 119291.11, "ddd", "laooq",
null, "2020-01-01 12:36:38", null, "1022-01-01 11:30:38", "[2022-01-01
11:30:38, 2022-01-01 11:30:38, 2022-01-01 11:30:38]") """
+ sql """ INSERT INTO ${tableName} VALUES(1232, 12222.99121135, "xxx",
"laooq", "2023-01-02", "2020-01-01 12:36:38", 522.762, "2022-01-01 11:30:38",
"[2023-01-01 11:30:38, 2023-01-01 11:30:38]") """
+ sql """ INSERT INTO ${tableName} VALUES(1233, 1.392932911136, "yyy",
"laooq", "2024-01-02", "2020-01-01 12:36:38", 52.862, "3022-01-01 11:30:38",
"[2024-01-01 11:30:38, 2024-01-01 11:30:38, 2024-01-01 11:30:38]") """
+ sql """ INSERT INTO ${tableName} VALUES(1234, 12919291.129191137, "xxddd",
"laooq", "2025-01-02", "2020-01-01 12:36:38", 552.872, "4022-01-01 11:30:38",
"[2025-01-01 11:30:38, 2025-01-01 11:30:38, 2025-01-01 11:30:38]") """
+ sql """ INSERT INTO ${tableName} VALUES(1235, 991129292901.11138, "dd",
null, "2120-01-02", "2020-01-01 12:36:38", 652.692, "5022-01-01 11:30:38",
"[]") """
+ sql """ INSERT INTO ${tableName} VALUES(1236, 100320.11139, "laa ddd",
"laooq", "2220-01-02", "2020-01-01 12:36:38", 2.7692, "6022-01-01 11:30:38",
"[null]") """
+ sql """ INSERT INTO ${tableName} VALUES(1237, 120939.11130, "a ddd",
"laooq", "2030-01-02", "2020-01-01 12:36:38", 22.822, "7022-01-01 11:30:38",
"[2025-01-01 11:30:38]") """
+ sql """sync"""
qt_sql """select * from ${tableName} order by 1, 2, 3"""
qt_sql """select * from ${tableName} order by 1, 2, 3"""
@@ -152,6 +161,7 @@ suite("test_prepared_stmt", "nonConcurrent") {
sql """insert into mytable1 values(1,1,'user1',10);"""
sql """insert into mytable1 values(1,1,'user1',10);"""
sql """insert into mytable1 values(1,1,'user1',10);"""
+ sql "sync"
stmt_read = prepareStatement "SELECT *, ? FROM (select *, ? from mytable1
where citycode = ?) AS `SpotfireCustomQuery1` WHERE 1 = 1"
stmt_read.setInt(1, 12345)
stmt_read.setInt(2, 1234)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
