Jibing-Li commented on code in PR #53488:
URL: https://github.com/apache/doris/pull/53488#discussion_r2215632512
##########
regression-test/suites/point_query_p0/test_point_query.groovy:
##########
@@ -204,6 +204,7 @@ suite("test_point_query", "nonConcurrent") {
"""
sleep(1);
nprep_sql """ INSERT INTO ${tableName} VALUES(1235,
120939.11130, "a ddd", "laooq", "2030-01-02", "2020-01-01 12:36:38", 22.822,
"7022-01-01 11:30:38", 1, 1.1111299, [119291.19291], ["111", "222", "333"], 1)
"""
+ stmt = prepareStatement "select /*+
SET_VAR(enable_nereids_planner=true) */ * from ${tableName} where k1 = ? and k2
= ? and k3 = ?"
Review Comment:
Tested on MySql, it has the same behavior with Doris. The reason is the
first prepare sql is `select * from xxx`, it caches all the columns of old
schema. After schema change, the `select *` sql will get one more fields than
the cached schema, which will cause array index out of bounds. If the sql gives
a specific column name, the old prepareStatement object will be still good to
use.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
