englefly commented on code in PR #24355:
URL: https://github.com/apache/doris/pull/24355#discussion_r1325510244
##########
regression-test/suites/nereids_p0/subquery/test_subquery.groovy:
##########
@@ -64,4 +64,25 @@ suite("test_subquery") {
qt_uncorrelated_scalar_with_sort_and_limit """
select * from nereids_test_query_db.baseall where k1 = (select k1
from nereids_test_query_db.baseall order by k1 desc limit 1)
"""
+
+ sql """drop table if exists test_one_row_relation;"""
+ sql """
+ CREATE TABLE `test_one_row_relation` (
+ `user_id` int(11) NULL
+ )
+ UNIQUE KEY(`user_id`)
+ COMMENT 'test'
+ DISTRIBUTED BY HASH(`user_id`) BUCKETS 1
+ PROPERTIES (
+ "replication_allocation" = "tag.location.default: 1"
+ );
+ """
+
+ sql """ set enable_nereids_dml=true; """
+
+ sql """insert into test_one_row_relation select (select 1);"""
Review Comment:
why not
qt_sql_subquery_one_row_relation "select (select 1)"
--
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]
