This is an automated email from the ASF dual-hosted git repository.
dataroaring pushed a commit to branch branch-3.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-3.0 by this push:
new 0ca6c39c644 [regression-test](PreparedStatement) fix unstable cases
when session var changed (#39903)
0ca6c39c644 is described below
commit 0ca6c39c64457c6d52df0919ba2e6ef56fc055a2
Author: lihangyu <15605149...@163.com>
AuthorDate: Mon Aug 26 15:59:19 2024 +0800
[regression-test](PreparedStatement) fix unstable cases when session var
changed (#39903)
---
regression-test/suites/prepared_stmt_p0/prepared_stmt.groovy | 7 +++++++
.../suites/prepared_stmt_p0/prepared_stmt_in_list.groovy | 1 +
2 files changed, 8 insertions(+)
diff --git a/regression-test/suites/prepared_stmt_p0/prepared_stmt.groovy
b/regression-test/suites/prepared_stmt_p0/prepared_stmt.groovy
index 18fd7978a54..7e3732fd69a 100644
--- a/regression-test/suites/prepared_stmt_p0/prepared_stmt.groovy
+++ b/regression-test/suites/prepared_stmt_p0/prepared_stmt.groovy
@@ -58,6 +58,7 @@ suite("test_prepared_stmt", "nonConcurrent") {
qt_sql """select * from ${tableName} order by 1, 2, 3"""
qt_sql """select * from ${tableName} order by 1, 2, 3"""
sql "set global max_prepared_stmt_count = 10000"
+ sql "set enable_fallback_to_original_planner = false"
def stmt_read = prepareStatement "select * from ${tableName} where k1
= ? order by k1"
assertEquals(stmt_read.class,
com.mysql.cj.jdbc.ServerPreparedStatement);
@@ -239,5 +240,11 @@ suite("test_prepared_stmt", "nonConcurrent") {
// not stable
// qe_select16 stmt_read
stmt_read.close()
+
+ stmt_read = prepareStatement "SELECT connection_id()"
+ assertEquals(com.mysql.cj.jdbc.ServerPreparedStatement,
stmt_read.class)
+ result = stmt_read.execute()
+ logger.info("connection_id: ${result}")
+ // qe_select16 stmt_read
}
}
diff --git
a/regression-test/suites/prepared_stmt_p0/prepared_stmt_in_list.groovy
b/regression-test/suites/prepared_stmt_p0/prepared_stmt_in_list.groovy
index d83e644af27..630fe7fa720 100644
--- a/regression-test/suites/prepared_stmt_p0/prepared_stmt_in_list.groovy
+++ b/regression-test/suites/prepared_stmt_p0/prepared_stmt_in_list.groovy
@@ -22,6 +22,7 @@ suite("test_prepared_stmt_in_list", "nonConcurrent") {
def user = context.config.jdbcUser
def password = context.config.jdbcPassword
def url = context.config.jdbcUrl + "&useServerPrepStmts=true"
+ sql """set global max_prepared_stmt_count = 1024"""
def result1 = connect(user=user, password=password, url=url) {
sql """DROP TABLE IF EXISTS ${tableName} """
sql """
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
