eldenmoon commented on code in PR #45371:
URL: https://github.com/apache/doris/pull/45371#discussion_r1883262035
##########
regression-test/suites/point_query_p0/test_point_query.groovy:
##########
@@ -330,4 +328,60 @@ suite("test_point_query", "nonConcurrent") {
qt_sql "select * from table_3821461 where col1 = 10 and col2 = 20 and loc3
= 'aabc';"
sql "update table_3821461 set value = 'update value' where col1 = -10 or
col1 = 20;"
qt_sql """select * from table_3821461 where col1 = -10 and col2 = 20 and
loc3 = 'aabc'"""
+
+ sql "DROP TABLE IF EXISTS test_partial_prepared_statement"
+ sql """
+ CREATE TABLE `test_partial_prepared_statement` (
+ `user_guid` varchar(64) NOT NULL,
+ `feature` varchar(256) NOT NULL,
+ `sk` varchar(256) NOT NULL,
+ `feature_value` text NULL,
+ `data_time` datetime NOT NULL
+ ) ENGINE=OLAP
+ UNIQUE KEY(`user_guid`, `feature`, `sk`)
+ DISTRIBUTED BY HASH(`user_guid`) BUCKETS 32
+ PROPERTIES (
+ "enable_unique_key_merge_on_write" = "true",
+ "light_schema_change" = "true",
+ "function_column.sequence_col" = "data_time",
+ "store_row_column" = "true",
+ "replication_num" = "1",
+ "row_store_page_size" = "16384"
+ );
+ """
+ sql "insert into test_partial_prepared_statement values ('user_guid',
'feature', 'sk','feature_value', '2021-01-01 00:00:00')"
+ def result2 = connect(user, password, prepare_url) {
+ def partial_prepared_stmt = prepareStatement "select /*+
SET_VAR(enable_nereids_planner=true) */ * from
regression_test_point_query_p0.test_partial_prepared_statement where sk = 'sk'
and user_guid = 'user_guid' and feature = ? "
Review Comment:
get
--
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: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
