This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 6124eea55e [Fix](regression-test)fix unstable test_default_limit case.
(#23270)
6124eea55e is described below
commit 6124eea55ea5156d4d444f27b4d0486148a47bd6
Author: mch_ucchi <[email protected]>
AuthorDate: Tue Aug 22 18:59:48 2023 +0800
[Fix](regression-test)fix unstable test_default_limit case. (#23270)
[Fix](regression-test)fix unstable test_default_limit case. #23270
---
.../session_variable/test_default_limit.groovy | 33 +++++++++++++++++++++-
.../session_variable/test_default_limit.groovy | 32 ++++++++++++++++++++-
2 files changed, 63 insertions(+), 2 deletions(-)
diff --git
a/regression-test/suites/nereids_p0/session_variable/test_default_limit.groovy
b/regression-test/suites/nereids_p0/session_variable/test_default_limit.groovy
index c2995fee41..525dbbf112 100644
---
a/regression-test/suites/nereids_p0/session_variable/test_default_limit.groovy
+++
b/regression-test/suites/nereids_p0/session_variable/test_default_limit.groovy
@@ -16,9 +16,40 @@
// under the License.
suite('test_default_limit') {
- sql 'use nereids_test_query_db'
sql 'set enable_nereids_planner=true'
sql 'set enable_fallback_to_original_planner=false'
+
+ sql 'drop table if exists baseall'
+ sql 'drop table if exists bigtable'
+
+ sql '''
+ create table baseall (
+ k0 int,
+ k1 int,
+ k2 int,
+ )
+ distributed by hash(k0) buckets 16
+ properties(
+ 'replication_num'='1'
+ )
+ '''
+
+ sql '''
+ create table bigtable (
+ k0 int,
+ k1 int,
+ k2 int,
+ )
+ distributed by hash(k0) buckets 16
+ properties(
+ 'replication_num'='1'
+ )
+ '''
+
+ def values = (1..15).collect { "(${(int) (it / 8)}, $it, ${it + 1})"
}.join(', ')
+ sql "insert into baseall values $values"
+ sql "insert into baseall values (null, null, null)"
+ sql "insert into bigtable select * from baseall"
for (int i = 0; i < 2; ++i) {
if (i == 0) {
diff --git
a/regression-test/suites/query_p0/session_variable/test_default_limit.groovy
b/regression-test/suites/query_p0/session_variable/test_default_limit.groovy
index 139c46bcd8..162eda1954 100644
--- a/regression-test/suites/query_p0/session_variable/test_default_limit.groovy
+++ b/regression-test/suites/query_p0/session_variable/test_default_limit.groovy
@@ -16,7 +16,37 @@
// under the License.
suite('test_default_limit') {
- sql 'use test_query_db'
+ sql 'drop table if exists baseall'
+ sql 'drop table if exists bigtable'
+
+ sql '''
+ create table baseall (
+ k0 int,
+ k1 int,
+ k2 int,
+ )
+ distributed by hash(k0) buckets 16
+ properties(
+ 'replication_num'='1'
+ )
+ '''
+
+ sql '''
+ create table bigtable (
+ k0 int,
+ k1 int,
+ k2 int,
+ )
+ distributed by hash(k0) buckets 16
+ properties(
+ 'replication_num'='1'
+ )
+ '''
+
+ def values = (1..15).collect { "(${(int) (it / 8)}, $it, ${it + 1})"
}.join(', ')
+ sql "insert into baseall values $values"
+ sql "insert into baseall values (null, null, null)"
+ sql "insert into bigtable select * from baseall"
for (int i = 0; i < 2; ++i) {
if (i == 0) {
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
