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 8c0789e061d [Chore](case) move slow case to p1 (#40860)
8c0789e061d is described below
commit 8c0789e061d7cef67ab7e1feeaf030c2ae26962a
Author: Pxl <pxl...@qq.com>
AuthorDate: Mon Sep 16 00:15:37 2024 +0800
[Chore](case) move slow case to p1 (#40860)
## Proposed changes
move slow case to p1
---
.../data/nereids_syntax_p1/mv/agg_mv_test.dat | 27 +
.../nereids_syntax_p1/mv/aggregate/agg_sync_mv.out | 1516 ++++++++++++++++++++
.../mv/aggregate/agg_sync_mv.groovy | 13 -
.../mv/aggregate/agg_sync_mv.groovy | 0
.../suites/nereids_syntax_p1/mv/load.groovy | 129 ++
5 files changed, 1672 insertions(+), 13 deletions(-)
diff --git a/regression-test/data/nereids_syntax_p1/mv/agg_mv_test.dat
b/regression-test/data/nereids_syntax_p1/mv/agg_mv_test.dat
new file mode 100644
index 00000000000..1d1d05317a2
--- /dev/null
+++ b/regression-test/data/nereids_syntax_p1/mv/agg_mv_test.dat
@@ -0,0 +1,27 @@
+0;0;1;1;1;1;1;0.1;0.1;0.1;0.1;0.1;0.1;0.1;0.1;char11;char21;char31;varchar11;varchar21;varchar31;string1;2012-03-01;2012-03-01;2012-03-01
01:00:01;2012-03-01 01:00:01;2012-03-01 01:00:01;2012-03-01
01:00:01;[0];[0];[1];[1];[1];[1];[1];[0.1];[2012-03-01,2012-03-01];[2012-03-01
01:00:01];[2012-03-01,2012-03-01];[2012-03-01 01:00:01,2012-03-01
01:00:01,2012-03-01 01:00:01,2012-03-01
01:00:01];[char11,char21,char31];[char11,char21,char31,varchar11,varchar21,varchar31];[char21,char31,varchar1
[...]
+1;0;2;2;2;2;2;0.2;0.2;0.2;0.2;0.2;0.2;0.2;0.2;char12;char22;char32;varchar12;varchar22;varchar32;string2;2012-03-02;2012-03-02;2012-03-02
02:01:02;2012-03-02 02:01:02;2012-03-02 02:01:02;2012-03-02
02:01:02;[0];[0];[2];[2];[2];[2];[2];[0.2];[2012-03-02,2012-03-02];[2012-03-02
02:01:02];[2012-03-02,2012-03-02];[2012-03-02 02:01:02,2012-03-02
02:01:02,2012-03-02 02:01:02,2012-03-02
02:01:02];[char12,char22,char32];[char12,char22,char32,varchar12,varchar22,varchar32];[char22,char32,varchar1
[...]
+2;0;3;3;3;3;3;0.3;0.3;0.3;0.3;0.3;0.3;0.3;0.3;char13;char23;char33;varchar13;varchar23;varchar33;string3;2012-03-03;2012-03-03;2012-03-03
03:02:03;2012-03-03 03:02:03;2012-03-03 03:02:03;2012-03-03
03:02:03;[0];[0];[3];[3];[3];[3];[3];[0.3];[2012-03-03,2012-03-03];[2012-03-03
03:02:03];[2012-03-03,2012-03-03];[2012-03-03 03:02:03,2012-03-03
03:02:03,2012-03-03 03:02:03,2012-03-03
03:02:03];[char13,char23,char33];[char13,char23,char33,varchar13,varchar23,varchar33];[char23,char33,varchar1
[...]
+3;0;4;4;4;4;4;0.4;0.4;0.4;0.4;0.4;0.4;0.4;0.4;char11;char21;char31;varchar11;varchar21;varchar31;string1;2012-03-04;2012-03-04;2012-03-04
04:03:04;2012-03-04 04:03:04;2012-03-04 04:03:04;2012-03-04
04:03:04;[0];[0];[4];[4];[4];[4];[4];[0.4];[2012-03-04,2012-03-04];[2012-03-04
04:03:04];[2012-03-04,2012-03-04];[2012-03-04 04:03:04,2012-03-04
04:03:04,2012-03-04 04:03:04,2012-03-04
04:03:04];[char11,char21,char31];[char11,char21,char31,varchar11,varchar21,varchar31];[char21,char31,varchar1
[...]
+4;0;5;5;5;5;5;0.5;0.5;0.5;0.5;0.5;0.5;0.5;0.5;char12;char22;char32;varchar12;varchar22;varchar32;string2;2012-03-05;2012-03-05;2012-03-05
05:04:05;2012-03-05 05:04:05;2012-03-05 05:04:05;2012-03-05
05:04:05;[0];[0];[5];[5];[5];[5];[5];[0.5];[2012-03-05,2012-03-05];[2012-03-05
05:04:05];[2012-03-05,2012-03-05];[2012-03-05 05:04:05,2012-03-05
05:04:05,2012-03-05 05:04:05,2012-03-05
05:04:05];[char12,char22,char32];[char12,char22,char32,varchar12,varchar22,varchar32];[char22,char32,varchar1
[...]
+5;0;6;6;6;6;6;0.6;0.6;0.6;0.6;0.6;0.6;0.6;0.6;char13;char23;char33;varchar13;varchar23;varchar33;string3;2012-03-06;2012-03-06;2012-03-06
06:05:06;2012-03-06 06:05:06;2012-03-06 06:05:06;2012-03-06
06:05:06;[0];[0];[6];[6];[6];[6];[6];[0.6];[2012-03-06,2012-03-06];[2012-03-06
06:05:06];[2012-03-06,2012-03-06];[2012-03-06 06:05:06,2012-03-06
06:05:06,2012-03-06 06:05:06,2012-03-06
06:05:06];[char13,char23,char33];[char13,char23,char33,varchar13,varchar23,varchar33];[char23,char33,varchar1
[...]
+6;0;7;7;7;7;7;0.7;0.7;0.7;0.7;0.7;0.7;0.7;0.7;char11;char21;char31;varchar11;varchar21;varchar31;string1;2012-03-07;2012-03-07;2012-03-07
07:06:07;2012-03-07 07:06:07;2012-03-07 07:06:07;2012-03-07
07:06:07;[0];[0];[7];[7];[7];[7];[7];[0.7];[2012-03-07,2012-03-07];[2012-03-07
07:06:07];[2012-03-07,2012-03-07];[2012-03-07 07:06:07,2012-03-07
07:06:07,2012-03-07 07:06:07,2012-03-07
07:06:07];[char11,char21,char31];[char11,char21,char31,varchar11,varchar21,varchar31];[char21,char31,varchar1
[...]
+7;1;8;8;8;8;8;0.8;0.8;0.8;0.8;0.8;0.8;0.8;0.8;char12;char22;char32;varchar12;varchar22;varchar32;string2;2012-03-08;2012-03-08;2012-03-08
08:07:08;2012-03-08 08:07:08;2012-03-08 08:07:08;2012-03-08
08:07:08;[1];[1];[8];[8];[8];[8];[8];[0.8];[2012-03-08,2012-03-08];[2012-03-08
08:07:08];[2012-03-08,2012-03-08];[2012-03-08 08:07:08,2012-03-08
08:07:08,2012-03-08 08:07:08,2012-03-08
08:07:08];[char12,char22,char32];[char12,char22,char32,varchar12,varchar22,varchar32];[char22,char32,varchar1
[...]
+8;1;9;9;9;9;9;0.9;0.9;0.9;0.9;0.9;0.9;0.9;0.9;char13;char23;char33;varchar13;varchar23;varchar33;string3;2012-03-09;2012-03-09;2012-03-09
09:08:09;2012-03-09 09:08:09;2012-03-09 09:08:09;2012-03-09
09:08:09;[1];[1];[9];[9];[9];[9];[9];[0.9];[2012-03-09,2012-03-09];[2012-03-09
09:08:09];[2012-03-09,2012-03-09];[2012-03-09 09:08:09,2012-03-09
09:08:09,2012-03-09 09:08:09,2012-03-09
09:08:09];[char13,char23,char33];[char13,char23,char33,varchar13,varchar23,varchar33];[char23,char33,varchar1
[...]
+9;1;10;10;10;10;10;1;1;1;1;1;1;1;1;char11;char21;char31;varchar11;varchar21;varchar31;string1;2012-03-10;2012-03-10;2012-03-10
10:09:10;2012-03-10 10:09:10;2012-03-10 10:09:10;2012-03-10
10:09:10;[1];[1];[10];[10];[10];[10];[10];[1];[2012-03-10,2012-03-10];[2012-03-10
10:09:10];[2012-03-10,2012-03-10];[2012-03-10 10:09:10,2012-03-10
10:09:10,2012-03-10 10:09:10,2012-03-10
10:09:10];[char11,char21,char31];[char11,char21,char31,varchar11,varchar21,varchar31];[char21,char31,varchar11,varcha
[...]
+10;1;11;11;11;11;11;1.1;1.1;1.1;1.1;1.1;1.1;1.1;1.1;char12;char22;char32;varchar12;varchar22;varchar32;string2;2012-03-11;2012-03-11;2012-03-11
11:10:11;2012-03-11 11:10:11;2012-03-11 11:10:11;2012-03-11
11:10:11;[1];[1];[11];[11];[11];[11];[11];[1.1];[2012-03-11,2012-03-11];[2012-03-11
11:10:11];[2012-03-11,2012-03-11];[2012-03-11 11:10:11,2012-03-11
11:10:11,2012-03-11 11:10:11,2012-03-11
11:10:11];[char12,char22,char32];[char12,char22,char32,varchar12,varchar22,varchar32];[char22,char
[...]
+11;1;12;12;12;12;12;1.2;1.2;1.2;1.2;1.2;1.2;1.2;1.2;char13;char23;char33;varchar13;varchar23;varchar33;string3;2012-03-12;2012-03-12;2012-03-12
12:11:12;2012-03-12 12:11:12;2012-03-12 12:11:12;2012-03-12
12:11:12;[1];[1];[12];[12];[12];[12];[12];[1.2];[2012-03-12,2012-03-12];[2012-03-12
12:11:12];[2012-03-12,2012-03-12];[2012-03-12 12:11:12,2012-03-12
12:11:12,2012-03-12 12:11:12,2012-03-12
12:11:12];[char13,char23,char33];[char13,char23,char33,varchar13,varchar23,varchar33];[char23,char
[...]
+null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null
+0;0;1;1;1;1;1;0.1;0.1;0.1;0.1;0.1;0.1;0.1;0.1;char11;char21;char31;varchar11;varchar21;varchar31;string1;2012-03-01;2012-03-01;2012-03-01
01:00:01;2012-03-01 01:00:01;2012-03-01 01:00:01;2012-03-01
01:00:01;[0];[0];[1];[1];[1];[1];[1];[0.1];[2012-03-01,2012-03-01];[2012-03-01
01:00:01];[2012-03-01,2012-03-01];[2012-03-01 01:00:01,2012-03-01
01:00:01,2012-03-01 01:00:01,2012-03-01
01:00:01];[char11,char21,char31];[char11,char21,char31,varchar11,varchar21,varchar31];[char21,char31,varchar1
[...]
+1;0;2;2;2;2;2;0.2;0.2;0.2;0.2;0.2;0.2;0.2;0.2;char12;char22;char32;varchar12;varchar22;varchar32;string2;2012-03-02;2012-03-02;2012-03-02
02:01:02;2012-03-02 02:01:02;2012-03-02 02:01:02;2012-03-02
02:01:02;[0];[0];[2];[2];[2];[2];[2];[0.2];[2012-03-02,2012-03-02];[2012-03-02
02:01:02];[2012-03-02,2012-03-02];[2012-03-02 02:01:02,2012-03-02
02:01:02,2012-03-02 02:01:02,2012-03-02
02:01:02];[char12,char22,char32];[char12,char22,char32,varchar12,varchar22,varchar32];[char22,char32,varchar1
[...]
+2;0;3;3;3;3;3;0.3;0.3;0.3;0.3;0.3;0.3;0.3;0.3;char13;char23;char33;varchar13;varchar23;varchar33;string3;2012-03-03;2012-03-03;2012-03-03
03:02:03;2012-03-03 03:02:03;2012-03-03 03:02:03;2012-03-03
03:02:03;[0];[0];[3];[3];[3];[3];[3];[0.3];[2012-03-03,2012-03-03];[2012-03-03
03:02:03];[2012-03-03,2012-03-03];[2012-03-03 03:02:03,2012-03-03
03:02:03,2012-03-03 03:02:03,2012-03-03
03:02:03];[char13,char23,char33];[char13,char23,char33,varchar13,varchar23,varchar33];[char23,char33,varchar1
[...]
+3;0;4;4;4;4;4;0.4;0.4;0.4;0.4;0.4;0.4;0.4;0.4;char11;char21;char31;varchar11;varchar21;varchar31;string1;2012-03-04;2012-03-04;2012-03-04
04:03:04;2012-03-04 04:03:04;2012-03-04 04:03:04;2012-03-04
04:03:04;[0];[0];[4];[4];[4];[4];[4];[0.4];[2012-03-04,2012-03-04];[2012-03-04
04:03:04];[2012-03-04,2012-03-04];[2012-03-04 04:03:04,2012-03-04
04:03:04,2012-03-04 04:03:04,2012-03-04
04:03:04];[char11,char21,char31];[char11,char21,char31,varchar11,varchar21,varchar31];[char21,char31,varchar1
[...]
+4;0;5;5;5;5;5;0.5;0.5;0.5;0.5;0.5;0.5;0.5;0.5;char12;char22;char32;varchar12;varchar22;varchar32;string2;2012-03-05;2012-03-05;2012-03-05
05:04:05;2012-03-05 05:04:05;2012-03-05 05:04:05;2012-03-05
05:04:05;[0];[0];[5];[5];[5];[5];[5];[0.5];[2012-03-05,2012-03-05];[2012-03-05
05:04:05];[2012-03-05,2012-03-05];[2012-03-05 05:04:05,2012-03-05
05:04:05,2012-03-05 05:04:05,2012-03-05
05:04:05];[char12,char22,char32];[char12,char22,char32,varchar12,varchar22,varchar32];[char22,char32,varchar1
[...]
+5;0;6;6;6;6;6;0.6;0.6;0.6;0.6;0.6;0.6;0.6;0.6;char13;char23;char33;varchar13;varchar23;varchar33;string3;2012-03-06;2012-03-06;2012-03-06
06:05:06;2012-03-06 06:05:06;2012-03-06 06:05:06;2012-03-06
06:05:06;[0];[0];[6];[6];[6];[6];[6];[0.6];[2012-03-06,2012-03-06];[2012-03-06
06:05:06];[2012-03-06,2012-03-06];[2012-03-06 06:05:06,2012-03-06
06:05:06,2012-03-06 06:05:06,2012-03-06
06:05:06];[char13,char23,char33];[char13,char23,char33,varchar13,varchar23,varchar33];[char23,char33,varchar1
[...]
+6;0;7;7;7;7;7;0.7;0.7;0.7;0.7;0.7;0.7;0.7;0.7;char11;char21;char31;varchar11;varchar21;varchar31;string1;2012-03-07;2012-03-07;2012-03-07
07:06:07;2012-03-07 07:06:07;2012-03-07 07:06:07;2012-03-07
07:06:07;[0];[0];[7];[7];[7];[7];[7];[0.7];[2012-03-07,2012-03-07];[2012-03-07
07:06:07];[2012-03-07,2012-03-07];[2012-03-07 07:06:07,2012-03-07
07:06:07,2012-03-07 07:06:07,2012-03-07
07:06:07];[char11,char21,char31];[char11,char21,char31,varchar11,varchar21,varchar31];[char21,char31,varchar1
[...]
+7;1;8;8;8;8;8;0.8;0.8;0.8;0.8;0.8;0.8;0.8;0.8;char12;char22;char32;varchar12;varchar22;varchar32;string2;2012-03-08;2012-03-08;2012-03-08
08:07:08;2012-03-08 08:07:08;2012-03-08 08:07:08;2012-03-08
08:07:08;[1];[1];[8];[8];[8];[8];[8];[0.8];[2012-03-08,2012-03-08];[2012-03-08
08:07:08];[2012-03-08,2012-03-08];[2012-03-08 08:07:08,2012-03-08
08:07:08,2012-03-08 08:07:08,2012-03-08
08:07:08];[char12,char22,char32];[char12,char22,char32,varchar12,varchar22,varchar32];[char22,char32,varchar1
[...]
+8;1;9;9;9;9;9;0.9;0.9;0.9;0.9;0.9;0.9;0.9;0.9;char13;char23;char33;varchar13;varchar23;varchar33;string3;2012-03-09;2012-03-09;2012-03-09
09:08:09;2012-03-09 09:08:09;2012-03-09 09:08:09;2012-03-09
09:08:09;[1];[1];[9];[9];[9];[9];[9];[0.9];[2012-03-09,2012-03-09];[2012-03-09
09:08:09];[2012-03-09,2012-03-09];[2012-03-09 09:08:09,2012-03-09
09:08:09,2012-03-09 09:08:09,2012-03-09
09:08:09];[char13,char23,char33];[char13,char23,char33,varchar13,varchar23,varchar33];[char23,char33,varchar1
[...]
+9;1;10;10;10;10;10;1;1;1;1;1;1;1;1;char11;char21;char31;varchar11;varchar21;varchar31;string1;2012-03-10;2012-03-10;2012-03-10
10:09:10;2012-03-10 10:09:10;2012-03-10 10:09:10;2012-03-10
10:09:10;[1];[1];[10];[10];[10];[10];[10];[1];[2012-03-10,2012-03-10];[2012-03-10
10:09:10];[2012-03-10,2012-03-10];[2012-03-10 10:09:10,2012-03-10
10:09:10,2012-03-10 10:09:10,2012-03-10
10:09:10];[char11,char21,char31];[char11,char21,char31,varchar11,varchar21,varchar31];[char21,char31,varchar11,varcha
[...]
+10;1;11;11;11;11;11;1.1;1.1;1.1;1.1;1.1;1.1;1.1;1.1;char12;char22;char32;varchar12;varchar22;varchar32;string2;2012-03-11;2012-03-11;2012-03-11
11:10:11;2012-03-11 11:10:11;2012-03-11 11:10:11;2012-03-11
11:10:11;[1];[1];[11];[11];[11];[11];[11];[1.1];[2012-03-11,2012-03-11];[2012-03-11
11:10:11];[2012-03-11,2012-03-11];[2012-03-11 11:10:11,2012-03-11
11:10:11,2012-03-11 11:10:11,2012-03-11
11:10:11];[char12,char22,char32];[char12,char22,char32,varchar12,varchar22,varchar32];[char22,char
[...]
+11;1;12;12;12;12;12;1.2;1.2;1.2;1.2;1.2;1.2;1.2;1.2;char13;char23;char33;varchar13;varchar23;varchar33;string3;2012-03-12;2012-03-12;2012-03-12
12:11:12;2012-03-12 12:11:12;2012-03-12 12:11:12;2012-03-12
12:11:12;[1];[1];[12];[12];[12];[12];[12];[1.2];[2012-03-12,2012-03-12];[2012-03-12
12:11:12];[2012-03-12,2012-03-12];[2012-03-12 12:11:12,2012-03-12
12:11:12,2012-03-12 12:11:12,2012-03-12
12:11:12];[char13,char23,char33];[char13,char23,char33,varchar13,varchar23,varchar33];[char23,char
[...]
+null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null;null
+null;0;1;1;1;1;1;0.1;0.1;0.1;0.1;0.1;0.1;0.1;0.1;char11;char21;char31;varchar11;varchar21;varchar31;string1;2012-03-01;2012-03-01;2012-03-01
01:00:01;2012-03-01 01:00:01;2012-03-01 01:00:01;2012-03-01
01:00:01;[0];[0];[1];[1];[1];[1];[1];[0.1];[2012-03-01,2012-03-01];[2012-03-01
01:00:01];[2012-03-01,2012-03-01];[2012-03-01 01:00:01,2012-03-01
01:00:01,2012-03-01 01:00:01,2012-03-01
01:00:01];[char11,char21,char31];[char11,char21,char31,varchar11,varchar21,varchar31];[char21,char31,varch
[...]
diff --git
a/regression-test/data/nereids_syntax_p1/mv/aggregate/agg_sync_mv.out
b/regression-test/data/nereids_syntax_p1/mv/aggregate/agg_sync_mv.out
new file mode 100644
index 00000000000..fee553ed3d0
--- /dev/null
+++ b/regression-test/data/nereids_syntax_p1/mv/aggregate/agg_sync_mv.out
@@ -0,0 +1,1516 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !select_any_value --
+\N 1
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !select_any_value_mv --
+\N 1
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !select_approx_count_distinct --
+\N 1
+0 1
+1 1
+2 1
+3 1
+4 1
+5 1
+6 1
+7 1
+8 1
+9 1
+10 1
+11 1
+
+-- !select_approx_count_distinct_mv --
+\N 1
+0 1
+1 1
+2 1
+3 1
+4 1
+5 1
+6 1
+7 1
+8 1
+9 1
+10 1
+11 1
+
+-- !select_collect_set --
+\N [1]
+0 [1]
+1 [2]
+2 [3]
+3 [4]
+4 [5]
+5 [6]
+6 [7]
+7 [8]
+8 [9]
+9 [10]
+10 [11]
+11 [12]
+
+-- !select_collect_set_mv --
+\N [1]
+0 [1]
+1 [2]
+2 [3]
+3 [4]
+4 [5]
+5 [6]
+6 [7]
+7 [8]
+8 [9]
+9 [10]
+10 [11]
+11 [12]
+
+-- !select_collect_list --
+\N [1, 1, 1, 1, 1]
+0 [1, 1, 1, 1, 1, 1, 1, 1, 1, 1]
+1 [2, 2, 2, 2, 2, 2, 2, 2, 2, 2]
+2 [3, 3, 3, 3, 3, 3, 3, 3, 3, 3]
+3 [4, 4, 4, 4, 4, 4, 4, 4, 4, 4]
+4 [5, 5, 5, 5, 5, 5, 5, 5, 5, 5]
+5 [6, 6, 6, 6, 6, 6, 6, 6, 6, 6]
+6 [7, 7, 7, 7, 7, 7, 7, 7, 7, 7]
+7 [8, 8, 8, 8, 8, 8, 8, 8, 8, 8]
+8 [9, 9, 9, 9, 9, 9, 9, 9, 9, 9]
+9 [10, 10, 10, 10, 10, 10, 10, 10, 10, 10]
+10 [11, 11, 11, 11, 11, 11, 11, 11, 11, 11]
+11 [12, 12, 12, 12, 12, 12, 12, 12, 12, 12]
+
+-- !select_collect_list_mv --
+\N [1, 1, 1, 1, 1]
+0 [1, 1, 1, 1, 1, 1, 1, 1, 1, 1]
+1 [2, 2, 2, 2, 2, 2, 2, 2, 2, 2]
+2 [3, 3, 3, 3, 3, 3, 3, 3, 3, 3]
+3 [4, 4, 4, 4, 4, 4, 4, 4, 4, 4]
+4 [5, 5, 5, 5, 5, 5, 5, 5, 5, 5]
+5 [6, 6, 6, 6, 6, 6, 6, 6, 6, 6]
+6 [7, 7, 7, 7, 7, 7, 7, 7, 7, 7]
+7 [8, 8, 8, 8, 8, 8, 8, 8, 8, 8]
+8 [9, 9, 9, 9, 9, 9, 9, 9, 9, 9]
+9 [10, 10, 10, 10, 10, 10, 10, 10, 10, 10]
+10 [11, 11, 11, 11, 11, 11, 11, 11, 11, 11]
+11 [12, 12, 12, 12, 12, 12, 12, 12, 12, 12]
+
+-- !select_corr --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_corr_mv --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_percentile_array --
+\N [1, 1, 1]
+0 [1, 1, 1]
+1 [2, 2, 2]
+2 [3, 3, 3]
+3 [4, 4, 4]
+4 [5, 5, 5]
+5 [6, 6, 6]
+6 [7, 7, 7]
+7 [8, 8, 8]
+8 [9, 9, 9]
+9 [10, 10, 10]
+10 [11, 11, 11]
+11 [12, 12, 12]
+
+-- !select_percentile_array_mv --
+\N [1, 1, 1]
+0 [1, 1, 1]
+1 [2, 2, 2]
+2 [3, 3, 3]
+3 [4, 4, 4]
+4 [5, 5, 5]
+5 [6, 6, 6]
+6 [7, 7, 7]
+7 [8, 8, 8]
+8 [9, 9, 9]
+9 [10, 10, 10]
+10 [11, 11, 11]
+11 [12, 12, 12]
+
+-- !select_quantile_union --
+\N \N
+0 \N
+1 \N
+2 \N
+3 \N
+4 \N
+5 \N
+6 \N
+7 \N
+8 \N
+9 \N
+10 \N
+11 \N
+
+-- !select_quantile_union_mv --
+\N \N
+0 \N
+1 \N
+2 \N
+3 \N
+4 \N
+5 \N
+6 \N
+7 \N
+8 \N
+9 \N
+10 \N
+11 \N
+
+-- !select_count_by_enum --
+\N [{"cbe":{"string1":5,"null":10},"notnull":15,"null":0,"all":15}]
+0 [{"cbe":{"string1":10},"notnull":10,"null":0,"all":10}]
+1 [{"cbe":{"string2":10},"notnull":10,"null":0,"all":10}]
+2 [{"cbe":{"string3":10},"notnull":10,"null":0,"all":10}]
+3 [{"cbe":{"string1":10},"notnull":10,"null":0,"all":10}]
+4 [{"cbe":{"string2":10},"notnull":10,"null":0,"all":10}]
+5 [{"cbe":{"string3":10},"notnull":10,"null":0,"all":10}]
+6 [{"cbe":{"string1":10},"notnull":10,"null":0,"all":10}]
+7 [{"cbe":{"string2":10},"notnull":10,"null":0,"all":10}]
+8 [{"cbe":{"string3":10},"notnull":10,"null":0,"all":10}]
+9 [{"cbe":{"string1":10},"notnull":10,"null":0,"all":10}]
+10 [{"cbe":{"string2":10},"notnull":10,"null":0,"all":10}]
+11 [{"cbe":{"string3":10},"notnull":10,"null":0,"all":10}]
+
+-- !select_count_by_enum_mv --
+\N [{"cbe":{"string1":5,"null":10},"notnull":15,"null":0,"all":15}]
+0 [{"cbe":{"string1":10},"notnull":10,"null":0,"all":10}]
+1 [{"cbe":{"string2":10},"notnull":10,"null":0,"all":10}]
+2 [{"cbe":{"string3":10},"notnull":10,"null":0,"all":10}]
+3 [{"cbe":{"string1":10},"notnull":10,"null":0,"all":10}]
+4 [{"cbe":{"string2":10},"notnull":10,"null":0,"all":10}]
+5 [{"cbe":{"string3":10},"notnull":10,"null":0,"all":10}]
+6 [{"cbe":{"string1":10},"notnull":10,"null":0,"all":10}]
+7 [{"cbe":{"string2":10},"notnull":10,"null":0,"all":10}]
+8 [{"cbe":{"string3":10},"notnull":10,"null":0,"all":10}]
+9 [{"cbe":{"string1":10},"notnull":10,"null":0,"all":10}]
+10 [{"cbe":{"string2":10},"notnull":10,"null":0,"all":10}]
+11 [{"cbe":{"string3":10},"notnull":10,"null":0,"all":10}]
+
+-- !select_avg_weighted --
+\N 1.0
+0 1.0
+1 2.0
+2 3.0
+3 4.0
+4 5.0
+5 6.0
+6 6.999999999999999
+7 8.0
+8 9.0
+9 10.0
+10 11.000000000000002
+11 12.0
+
+-- !select_avg_weighted_mv --
+\N 1.0
+0 1.0
+1 2.0
+2 3.0
+3 4.0
+4 5.0
+5 6.0
+6 6.999999999999999
+7 8.0
+8 9.0
+9 10.0
+10 11.000000000000002
+11 12.0
+
+-- !select_bitmap_intersect --
+\N \N
+0 \N
+1 \N
+2 \N
+3 \N
+4 \N
+5 \N
+6 \N
+7 \N
+8 \N
+9 \N
+10 \N
+11 \N
+
+-- !select_bitmap_intersect_mv --
+\N \N
+0 \N
+1 \N
+2 \N
+3 \N
+4 \N
+5 \N
+6 \N
+7 \N
+8 \N
+9 \N
+10 \N
+11 \N
+
+-- !select_bitmap_agg --
+\N \N
+0 \N
+1 \N
+2 \N
+3 \N
+4 \N
+5 \N
+6 \N
+7 \N
+8 \N
+9 \N
+10 \N
+11 \N
+
+-- !select_bitmap_agg_mv --
+\N \N
+0 \N
+1 \N
+2 \N
+3 \N
+4 \N
+5 \N
+6 \N
+7 \N
+8 \N
+9 \N
+10 \N
+11 \N
+
+-- !select_bitmap_union --
+\N \N
+0 \N
+1 \N
+2 \N
+3 \N
+4 \N
+5 \N
+6 \N
+7 \N
+8 \N
+9 \N
+10 \N
+11 \N
+
+-- !select_bitmap_union_mv --
+\N \N
+0 \N
+1 \N
+2 \N
+3 \N
+4 \N
+5 \N
+6 \N
+7 \N
+8 \N
+9 \N
+10 \N
+11 \N
+
+-- !select_bitmap_union_count --
+\N 1
+0 1
+1 1
+2 1
+3 1
+4 1
+5 1
+6 1
+7 1
+8 1
+9 1
+10 1
+11 1
+
+-- !select_bitmap_union_count_mv --
+\N 1
+0 1
+1 1
+2 1
+3 1
+4 1
+5 1
+6 1
+7 1
+8 1
+9 1
+10 1
+11 1
+
+-- !select_bitmap_union_int --
+\N 1
+0 1
+1 1
+2 1
+3 1
+4 1
+5 1
+6 1
+7 1
+8 1
+9 1
+10 1
+11 1
+
+-- !select_bitmap_union_int_mv --
+\N 1
+0 1
+1 1
+2 1
+3 1
+4 1
+5 1
+6 1
+7 1
+8 1
+9 1
+10 1
+11 1
+
+-- !select_group_array_intersect --
+\N []
+0 [1]
+1 [2]
+2 [3]
+3 [4]
+4 [5]
+5 [6]
+6 [7]
+7 [8]
+8 [9]
+9 [10]
+10 [11]
+11 [12]
+
+-- !select_group_array_intersect_mv --
+\N []
+0 [1]
+1 [2]
+2 [3]
+3 [4]
+4 [5]
+5 [6]
+6 [7]
+7 [8]
+8 [9]
+9 [10]
+10 [11]
+11 [12]
+
+-- !select_group_bit_and --
+\N 1
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !select_group_bit_and_mv --
+\N 1
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !select_group_bit_or --
+\N 1
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !select_group_bit_or_mv --
+\N 1
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !select_group_bit_xor --
+\N 1
+0 0
+1 0
+2 0
+3 0
+4 0
+5 0
+6 0
+7 0
+8 0
+9 0
+10 0
+11 0
+
+-- !select_group_bit_xor_mv --
+\N 1
+0 0
+1 0
+2 0
+3 0
+4 0
+5 0
+6 0
+7 0
+8 0
+9 0
+10 0
+11 0
+
+-- !select_group_bitmap_xor --
+\N \N
+0 \N
+1 \N
+2 \N
+3 \N
+4 \N
+5 \N
+6 \N
+7 \N
+8 \N
+9 \N
+10 \N
+11 \N
+
+-- !select_group_bitmap_xor_mv --
+\N \N
+0 \N
+1 \N
+2 \N
+3 \N
+4 \N
+5 \N
+6 \N
+7 \N
+8 \N
+9 \N
+10 \N
+11 \N
+
+-- !select_hll_union_agg --
+\N 1
+0 1
+1 1
+2 1
+3 1
+4 1
+5 1
+6 1
+7 1
+8 1
+9 1
+10 1
+11 1
+
+-- !select_hll_union_agg_mv --
+\N 1
+0 1
+1 1
+2 1
+3 1
+4 1
+5 1
+6 1
+7 1
+8 1
+9 1
+10 1
+11 1
+
+-- !select_hll_union --
+\N \N
+0 \N
+1 \N
+2 \N
+3 \N
+4 \N
+5 \N
+6 \N
+7 \N
+8 \N
+9 \N
+10 \N
+11 \N
+
+-- !select_hll_union_mv --
+\N \N
+0 \N
+1 \N
+2 \N
+3 \N
+4 \N
+5 \N
+6 \N
+7 \N
+8 \N
+9 \N
+10 \N
+11 \N
+
+-- !select_intersect_count --
+\N 0
+0 0
+1 0
+2 0
+3 0
+4 0
+5 0
+6 0
+7 0
+8 0
+9 0
+10 0
+11 0
+
+-- !select_intersect_count_mv --
+\N 0
+0 0
+1 0
+2 0
+3 0
+4 0
+5 0
+6 0
+7 0
+8 0
+9 0
+10 0
+11 0
+
+-- !select_group_concat --
+\N 1,1,1,1,1
+0 1,1,1,1,1,1,1,1,1,1
+1 2,2,2,2,2,2,2,2,2,2
+2 3,3,3,3,3,3,3,3,3,3
+3 4,4,4,4,4,4,4,4,4,4
+4 5,5,5,5,5,5,5,5,5,5
+5 6,6,6,6,6,6,6,6,6,6
+6 7,7,7,7,7,7,7,7,7,7
+7 8,8,8,8,8,8,8,8,8,8
+8 9,9,9,9,9,9,9,9,9,9
+9 10,10,10,10,10,10,10,10,10,10
+10 11,11,11,11,11,11,11,11,11,11
+11 12,12,12,12,12,12,12,12,12,12
+
+-- !select_group_concat_mv --
+\N 1,1,1,1,1
+0 1,1,1,1,1,1,1,1,1,1
+1 2,2,2,2,2,2,2,2,2,2
+2 3,3,3,3,3,3,3,3,3,3
+3 4,4,4,4,4,4,4,4,4,4
+4 5,5,5,5,5,5,5,5,5,5
+5 6,6,6,6,6,6,6,6,6,6
+6 7,7,7,7,7,7,7,7,7,7
+7 8,8,8,8,8,8,8,8,8,8
+8 9,9,9,9,9,9,9,9,9,9
+9 10,10,10,10,10,10,10,10,10,10
+10 11,11,11,11,11,11,11,11,11,11
+11 12,12,12,12,12,12,12,12,12,12
+
+-- !select_multi_distinct_group_concat --
+\N 1
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !select_multi_distinct_group_concat_mv --
+\N 1
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !select_multi_distinct_sum0 --
+\N 1
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !select_multi_distinct_sum0_mv --
+\N 1
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !select_multi_distinct_sum --
+\N 1
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !select_multi_distinct_sum_mv --
+\N 1
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !select_histogram --
+\N
{"num_buckets":1,"buckets":[{"lower":"1","upper":"1","ndv":1,"count":5,"pre_sum":0}]}
+0
{"num_buckets":1,"buckets":[{"lower":"1","upper":"1","ndv":1,"count":10,"pre_sum":0}]}
+1
{"num_buckets":1,"buckets":[{"lower":"2","upper":"2","ndv":1,"count":10,"pre_sum":0}]}
+2
{"num_buckets":1,"buckets":[{"lower":"3","upper":"3","ndv":1,"count":10,"pre_sum":0}]}
+3
{"num_buckets":1,"buckets":[{"lower":"4","upper":"4","ndv":1,"count":10,"pre_sum":0}]}
+4
{"num_buckets":1,"buckets":[{"lower":"5","upper":"5","ndv":1,"count":10,"pre_sum":0}]}
+5
{"num_buckets":1,"buckets":[{"lower":"6","upper":"6","ndv":1,"count":10,"pre_sum":0}]}
+6
{"num_buckets":1,"buckets":[{"lower":"7","upper":"7","ndv":1,"count":10,"pre_sum":0}]}
+7
{"num_buckets":1,"buckets":[{"lower":"8","upper":"8","ndv":1,"count":10,"pre_sum":0}]}
+8
{"num_buckets":1,"buckets":[{"lower":"9","upper":"9","ndv":1,"count":10,"pre_sum":0}]}
+9
{"num_buckets":1,"buckets":[{"lower":"10","upper":"10","ndv":1,"count":10,"pre_sum":0}]}
+10
{"num_buckets":1,"buckets":[{"lower":"11","upper":"11","ndv":1,"count":10,"pre_sum":0}]}
+11
{"num_buckets":1,"buckets":[{"lower":"12","upper":"12","ndv":1,"count":10,"pre_sum":0}]}
+
+-- !select_histogram_mv --
+\N
{"num_buckets":1,"buckets":[{"lower":"1","upper":"1","ndv":1,"count":5,"pre_sum":0}]}
+0
{"num_buckets":1,"buckets":[{"lower":"1","upper":"1","ndv":1,"count":10,"pre_sum":0}]}
+1
{"num_buckets":1,"buckets":[{"lower":"2","upper":"2","ndv":1,"count":10,"pre_sum":0}]}
+2
{"num_buckets":1,"buckets":[{"lower":"3","upper":"3","ndv":1,"count":10,"pre_sum":0}]}
+3
{"num_buckets":1,"buckets":[{"lower":"4","upper":"4","ndv":1,"count":10,"pre_sum":0}]}
+4
{"num_buckets":1,"buckets":[{"lower":"5","upper":"5","ndv":1,"count":10,"pre_sum":0}]}
+5
{"num_buckets":1,"buckets":[{"lower":"6","upper":"6","ndv":1,"count":10,"pre_sum":0}]}
+6
{"num_buckets":1,"buckets":[{"lower":"7","upper":"7","ndv":1,"count":10,"pre_sum":0}]}
+7
{"num_buckets":1,"buckets":[{"lower":"8","upper":"8","ndv":1,"count":10,"pre_sum":0}]}
+8
{"num_buckets":1,"buckets":[{"lower":"9","upper":"9","ndv":1,"count":10,"pre_sum":0}]}
+9
{"num_buckets":1,"buckets":[{"lower":"10","upper":"10","ndv":1,"count":10,"pre_sum":0}]}
+10
{"num_buckets":1,"buckets":[{"lower":"11","upper":"11","ndv":1,"count":10,"pre_sum":0}]}
+11
{"num_buckets":1,"buckets":[{"lower":"12","upper":"12","ndv":1,"count":10,"pre_sum":0}]}
+
+-- !select_max_by --
+\N 1
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !select_max_by_mv --
+\N 1
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !select_min_by --
+\N 1
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !select_min_by_mv --
+\N 1
+0 1
+1 2
+2 3
+3 4
+4 5
+5 6
+6 7
+7 8
+8 9
+9 10
+10 11
+11 12
+
+-- !select_multi_distinct_count --
+\N 1
+0 1
+1 1
+2 1
+3 1
+4 1
+5 1
+6 1
+7 1
+8 1
+9 1
+10 1
+11 1
+
+-- !select_multi_distinct_count_mv --
+\N 1
+0 1
+1 1
+2 1
+3 1
+4 1
+5 1
+6 1
+7 1
+8 1
+9 1
+10 1
+11 1
+
+-- !select_ndv --
+\N 1
+0 1
+1 1
+2 1
+3 1
+4 1
+5 1
+6 1
+7 1
+8 1
+9 1
+10 1
+11 1
+
+-- !select_ndv_mv --
+\N 1
+0 1
+1 1
+2 1
+3 1
+4 1
+5 1
+6 1
+7 1
+8 1
+9 1
+10 1
+11 1
+
+-- !select_covar --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_covar_mv --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_covar_samp --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_covar_samp_mv --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_percentile --
+\N 1.0
+0 1.0
+1 2.0
+2 3.0
+3 4.0
+4 5.0
+5 6.0
+6 7.0
+7 8.0
+8 9.0
+9 10.0
+10 11.0
+11 12.0
+
+-- !select_percentile_mv --
+\N 1.0
+0 1.0
+1 2.0
+2 3.0
+3 4.0
+4 5.0
+5 6.0
+6 7.0
+7 8.0
+8 9.0
+9 10.0
+10 11.0
+11 12.0
+
+-- !select_percentile_approx --
+\N 1.0
+0 1.0
+1 2.0
+2 3.0
+3 4.0
+4 5.0
+5 6.0
+6 7.0
+7 8.0
+8 9.0
+9 10.0
+10 11.0
+11 12.0
+
+-- !select_percentile_approx_mv --
+\N 1.0
+0 1.0
+1 2.0
+2 3.0
+3 4.0
+4 5.0
+5 6.0
+6 7.0
+7 8.0
+8 9.0
+9 10.0
+10 11.0
+11 12.0
+
+-- !select_sequence_count --
+\N 0
+0 0
+1 0
+2 0
+3 0
+4 0
+5 0
+6 0
+7 0
+8 0
+9 0
+10 0
+11 0
+
+-- !select_sequence_count_mv --
+\N 0
+0 0
+1 0
+2 0
+3 0
+4 0
+5 0
+6 0
+7 0
+8 0
+9 0
+10 0
+11 0
+
+-- !select_sequence_match --
+\N false
+0 false
+1 false
+2 false
+3 false
+4 false
+5 false
+6 false
+7 false
+8 false
+9 false
+10 false
+11 false
+
+-- !select_sequence_match_mv --
+\N false
+0 false
+1 false
+2 false
+3 false
+4 false
+5 false
+6 false
+7 false
+8 false
+9 false
+10 false
+11 false
+
+-- !select_stddev --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_stddev_mv --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_stddev_pop --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_stddev_pop_mv --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_stddev_samp --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_stddev_samp_mv --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_sum0 --
+\N 5
+0 10
+1 20
+2 30
+3 40
+4 50
+5 60
+6 70
+7 80
+8 90
+9 100
+10 110
+11 120
+
+-- !select_sum0_mv --
+\N 5
+0 10
+1 20
+2 30
+3 40
+4 50
+5 60
+6 70
+7 80
+8 90
+9 100
+10 110
+11 120
+
+-- !select_topn --
+\N {"null":10,"varchar11":5}
+0 {"varchar11":10}
+1 {"varchar12":10}
+2 {"varchar13":10}
+3 {"varchar11":10}
+4 {"varchar12":10}
+5 {"varchar13":10}
+6 {"varchar11":10}
+7 {"varchar12":10}
+8 {"varchar13":10}
+9 {"varchar11":10}
+10 {"varchar12":10}
+11 {"varchar13":10}
+
+-- !select_topn_mv --
+\N {"null":10,"varchar11":5}
+0 {"varchar11":10}
+1 {"varchar12":10}
+2 {"varchar13":10}
+3 {"varchar11":10}
+4 {"varchar12":10}
+5 {"varchar13":10}
+6 {"varchar11":10}
+7 {"varchar12":10}
+8 {"varchar13":10}
+9 {"varchar11":10}
+10 {"varchar12":10}
+11 {"varchar13":10}
+
+-- !select_topn_array --
+\N ["null", "varchar11"]
+0 ["varchar11"]
+1 ["varchar12"]
+2 ["varchar13"]
+3 ["varchar11"]
+4 ["varchar12"]
+5 ["varchar13"]
+6 ["varchar11"]
+7 ["varchar12"]
+8 ["varchar13"]
+9 ["varchar11"]
+10 ["varchar12"]
+11 ["varchar13"]
+
+-- !select_topn_array_mv --
+\N ["null", "varchar11"]
+0 ["varchar11"]
+1 ["varchar12"]
+2 ["varchar13"]
+3 ["varchar11"]
+4 ["varchar12"]
+5 ["varchar13"]
+6 ["varchar11"]
+7 ["varchar12"]
+8 ["varchar13"]
+9 ["varchar11"]
+10 ["varchar12"]
+11 ["varchar13"]
+
+-- !select_topn_weighted --
+\N ["varchar11"]
+0 ["varchar11"]
+1 ["varchar12"]
+2 ["varchar13"]
+3 ["varchar11"]
+4 ["varchar12"]
+5 ["varchar13"]
+6 ["varchar11"]
+7 ["varchar12"]
+8 ["varchar13"]
+9 ["varchar11"]
+10 ["varchar12"]
+11 ["varchar13"]
+
+-- !select_topn_weighted_mv --
+\N ["varchar11"]
+0 ["varchar11"]
+1 ["varchar12"]
+2 ["varchar13"]
+3 ["varchar11"]
+4 ["varchar12"]
+5 ["varchar13"]
+6 ["varchar11"]
+7 ["varchar12"]
+8 ["varchar13"]
+9 ["varchar11"]
+10 ["varchar12"]
+11 ["varchar13"]
+
+-- !select_variance --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_variance_mv --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_var_pop --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_var_pop_mv --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_variance_samp --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_variance_samp_mv --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_var_samp --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_var_samp_mv --
+\N 0.0
+0 0.0
+1 0.0
+2 0.0
+3 0.0
+4 0.0
+5 0.0
+6 0.0
+7 0.0
+8 0.0
+9 0.0
+10 0.0
+11 0.0
+
+-- !select_window_funnel --
+\N 1
+0 1
+1 0
+2 0
+3 0
+4 0
+5 0
+6 0
+7 0
+8 0
+9 0
+10 0
+11 0
+
+-- !select_window_funnel_mv --
+\N 1
+0 1
+1 0
+2 0
+3 0
+4 0
+5 0
+6 0
+7 0
+8 0
+9 0
+10 0
+11 0
+
+-- !select_retention --
+\N [0, 0]
+0 [0, 0]
+1 [0, 0]
+2 [0, 0]
+3 [0, 0]
+4 [0, 0]
+5 [0, 0]
+6 [0, 0]
+7 [0, 0]
+8 [0, 0]
+9 [0, 0]
+10 [0, 0]
+11 [0, 0]
+
+-- !select_retention_mv --
+\N [0, 0]
+0 [0, 0]
+1 [0, 0]
+2 [0, 0]
+3 [0, 0]
+4 [0, 0]
+5 [0, 0]
+6 [0, 0]
+7 [0, 0]
+8 [0, 0]
+9 [0, 0]
+10 [0, 0]
+11 [0, 0]
+
+-- !test --
+\N {}
+1 {0:"string1"}
+2 {1:"string2"}
+3 {2:"string3"}
+4 {3:"string1"}
+5 {4:"string2"}
+6 {5:"string3"}
+7 {6:"string1"}
+8 {7:"string2"}
+9 {8:"string3"}
+10 {9:"string1"}
+11 {10:"string2"}
+12 {11:"string3"}
+
diff --git
a/regression-test/suites/nereids_syntax_p0/mv/aggregate/agg_sync_mv.groovy
b/regression-test/suites/nereids_syntax_p0/mv/aggregate/agg_sync_mv.groovy
index b0f384c472c..60e3ec316da 100644
--- a/regression-test/suites/nereids_syntax_p0/mv/aggregate/agg_sync_mv.groovy
+++ b/regression-test/suites/nereids_syntax_p0/mv/aggregate/agg_sync_mv.groovy
@@ -534,19 +534,6 @@ suite("agg_sync_mv") {
sql "insert into agg_mv_test select * from agg_mv_test;"
- sql "insert into agg_mv_test select * from agg_mv_test;"
- sql "insert into agg_mv_test select * from agg_mv_test;"
- sql "insert into agg_mv_test select * from agg_mv_test;"
- sql "insert into agg_mv_test select * from agg_mv_test;"
- sql "insert into agg_mv_test select * from agg_mv_test;"
- sql "insert into agg_mv_test select * from agg_mv_test;"
- sql "insert into agg_mv_test select * from agg_mv_test;"
- sql "insert into agg_mv_test select * from agg_mv_test;"
- sql "insert into agg_mv_test select * from agg_mv_test;"
- sql "insert into agg_mv_test select * from agg_mv_test;"
- sql "insert into agg_mv_test select * from agg_mv_test;"
- sql "insert into agg_mv_test select * from agg_mv_test;"
-
sql "set parallel_pipeline_task_num=1"
qt_test "select kbint, map_agg(id, kstr) from agg_mv_test group by kbint
order by kbint;"
}
diff --git
a/regression-test/suites/nereids_syntax_p0/mv/aggregate/agg_sync_mv.groovy
b/regression-test/suites/nereids_syntax_p1/mv/aggregate/agg_sync_mv.groovy
similarity index 100%
copy from
regression-test/suites/nereids_syntax_p0/mv/aggregate/agg_sync_mv.groovy
copy to regression-test/suites/nereids_syntax_p1/mv/aggregate/agg_sync_mv.groovy
diff --git a/regression-test/suites/nereids_syntax_p1/mv/load.groovy
b/regression-test/suites/nereids_syntax_p1/mv/load.groovy
new file mode 100644
index 00000000000..23b625a127f
--- /dev/null
+++ b/regression-test/suites/nereids_syntax_p1/mv/load.groovy
@@ -0,0 +1,129 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+suite("load") {
+ sql "drop table if exists agg_mv_test"
+ sql """
+ CREATE TABLE IF NOT EXISTS `agg_mv_test` (
+ `id` int null,
+ `kbool` boolean null,
+ `ktint` tinyint(4) null,
+ `ksint` smallint(6) null,
+ `kint` int(11) null,
+ `kbint` bigint(20) null,
+ `klint` largeint(40) null,
+ `kfloat` float null,
+ `kdbl` double null,
+ `kdcmls1` decimal(9, 3) null,
+ `kdcmls2` decimal(15, 5) null,
+ `kdcmls3` decimal(27, 9) null,
+ `kdcmlv3s1` decimalv3(9, 3) null,
+ `kdcmlv3s2` decimalv3(15, 5) null,
+ `kdcmlv3s3` decimalv3(27, 9) null,
+ `kchrs1` char(10) null,
+ `kchrs2` char(20) null,
+ `kchrs3` char(50) null,
+ `kvchrs1` varchar(10) null,
+ `kvchrs2` varchar(20) null,
+ `kvchrs3` varchar(50) null,
+ `kstr` string null,
+ `kdt` date null,
+ `kdtv2` datev2 null,
+ `kdtm` datetime null,
+ `kdtmv2s1` datetimev2(0) null,
+ `kdtmv2s2` datetimev2(4) null,
+ `kdtmv2s3` datetimev2(6) null,
+ `kabool` array<boolean> null,
+ `katint` array<tinyint(4)> null,
+ `kasint` array<smallint(6)> null,
+ `kaint` array<int> null,
+ `kabint` array<bigint(20)> null,
+ `kalint` array<largeint(40)> null,
+ `kafloat` array<float> null,
+ `kadbl` array<double> null,
+ `kadt` array<date> null,
+ `kadtm` array<datetime> null,
+ `kadtv2` array<datev2> null,
+ `kadtmv2` array<datetimev2(6)> null,
+ `kachr` array<char(50)> null,
+ `kavchr` array<varchar(50)> null,
+ `kastr` array<string> null,
+ `kadcml` array<decimal(27, 9)> null,
+ `st_point_str` string null,
+ `st_point_vc` varchar(50) null,
+ `x_lng` double null,
+ `x_lat` double null,
+ `y_lng` double null,
+ `y_lat` double null,
+ `z_lng` double null,
+ `z_lat` double null,
+ `radius` double null,
+ `linestring_wkt` varchar(50) null,
+ `polygon_wkt` varchar(50) null,
+ `km_bool_tint` map<boolean, tinyint> null,
+ `km_tint_tint` map<tinyint, tinyint> null,
+ `km_sint_tint` map<smallint, tinyint> null,
+ `km_int_tint` map<int, tinyint> null,
+ `km_bint_tint` map<bigint, tinyint> null,
+ `km_lint_tint` map<largeint, tinyint> null,
+ `km_float_tint` map<float, tinyint> null,
+ `km_dbl_tint` map<double, tinyint> null,
+ `km_dcml_tint` map<decimal(22,9), tinyint> null,
+ `km_chr_tint` map<char(5), tinyint> null,
+ `km_vchr_tint` map<varchar(50), tinyint> null,
+ `km_str_tint` map<string, tinyint> null,
+ `km_date_tint` map<date, tinyint> null,
+ `km_dtm_tint` map<datetime, tinyint> null,
+ `km_tint_bool` map<tinyint, boolean> null,
+ `km_int_int` map<int, int> null,
+ `km_tint_sint` map<tinyint, smallint> null,
+ `km_tint_int` map<tinyint, int> null,
+ `km_tint_bint` map<tinyint, bigint> null,
+ `km_tint_lint` map<tinyint, largeint> null,
+ `km_tint_float` map<tinyint, float> null,
+ `km_tint_dbl` map<tinyint, double> null,
+ `km_tint_dcml` map<tinyint, decimal(22,9)> null,
+ `km_tint_chr` map<tinyint, char(5)> null,
+ `km_tint_vchr` map<tinyint, varchar(50)> null,
+ `km_tint_str` map<tinyint, string> null,
+ `km_tint_date` map<tinyint, date> null,
+ `km_tint_dtm` map<tinyint, datetime> null,
+ `kjson` JSON null,
+ `kstruct` STRUCT<id: int> null
+ ) engine=olap
+ DISTRIBUTED BY HASH(`id`) BUCKETS 4
+ properties("replication_num" = "1")
+ """
+
+ streamLoad {
+ table "agg_mv_test"
+ db "regression_test_nereids_syntax_p0_mv"
+ set 'column_separator', ';'
+ set 'columns', '''
+ id, kbool, ktint, ksint, kint, kbint, klint, kfloat, kdbl,
kdcmls1, kdcmls2, kdcmls3,
+ kdcmlv3s1, kdcmlv3s2, kdcmlv3s3, kchrs1, kchrs2, kchrs3, kvchrs1,
kvchrs2, kvchrs3, kstr,
+ kdt, kdtv2, kdtm, kdtmv2s1, kdtmv2s2, kdtmv2s3, kabool, katint,
kasint, kaint,
+ kabint, kalint, kafloat, kadbl, kadt, kadtm, kadtv2, kadtmv2,
kachr, kavchr, kastr, kadcml,
+ st_point_str, st_point_vc, x_lng, x_lat, y_lng, y_lat, z_lng,
z_lat, radius, linestring_wkt, polygon_wkt,
+ km_bool_tint, km_tint_tint, km_sint_tint, km_int_tint,
km_bint_tint, km_lint_tint, km_float_tint,
+ km_dbl_tint, km_dcml_tint, km_chr_tint, km_vchr_tint, km_str_tint,
km_date_tint, km_dtm_tint,
+ km_tint_bool, km_int_int, km_tint_sint, km_tint_int, km_tint_bint,
km_tint_lint, km_tint_float,
+ km_tint_dbl, km_tint_dcml, km_tint_chr, km_tint_vchr, km_tint_str,
km_tint_date, km_tint_dtm, kjson, kstruct
+ '''
+ file "agg_mv_test.dat"
+ }
+}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
