regression-test/data/nereids_syntax_p0/using_join.out

-- This file is automatically generated. You should know what you did if you want to edit this
-- !two_relations --
1	1	1	[1, 2, 3, 4]	11	1	21
1	1	1	[1, 2, 3, 4]	11	2	22
1	1	1	[1, 2, 3, 4]	11	3	23

-- !two_relations_by_two_slot --
1	1	1	[1, 2, 3, 4]	11	21

-- !two_relations_with_right_slot --
1	1	1	[1, 2, 3, 4]	11	1	21	1
1	1	1	[1, 2, 3, 4]	11	2	22	1
1	1	1	[1, 2, 3, 4]	11	3	23	1

-- !two_relations_with_alias --
1	1	1	[1, 2, 3, 4]	11	1	21
1	1	1	[1, 2, 3, 4]	11	2	22
1	1	1	[1, 2, 3, 4]	11	3	23

-- !three_relations --
1	1	1	[1, 2, 3, 4]	11	31	1	21
2	3	4	[5, 6, 7, 8]	12	32	1	23

-- !one_plus_two_relations --
1	1	21	1	1	[1, 2, 3, 4]	11	31
1	2	22	1	1	[1, 2, 3, 4]	11	31
1	3	23	1	1	[1, 2, 3, 4]	11	31

-- !one_plus_two_cross_join --
1	1	1	[1, 2, 3, 4]	11	1	21	1	31
1	1	1	[1, 2, 3, 4]	11	1	21	2	32
1	1	1	[1, 2, 3, 4]	11	1	21	3	33
1	1	1	[1, 2, 3, 4]	11	1	21	4	34
2	3	4	[5, 6, 7, 8]	12	1	23	1	31
2	3	4	[5, 6, 7, 8]	12	1	23	2	32
2	3	4	[5, 6, 7, 8]	12	1	23	3	33
2	3	4	[5, 6, 7, 8]	12	1	23	4	34

-- !one_cross_join_with_two --
1	1	1	[1, 2, 3, 4]	11	1	1	21	31
1	1	1	[1, 2, 3, 4]	11	1	2	22	31
1	1	1	[1, 2, 3, 4]	11	1	3	23	31
2	3	4	[5, 6, 7, 8]	12	1	1	21	31
2	3	4	[5, 6, 7, 8]	12	1	2	22	31
2	3	4	[5, 6, 7, 8]	12	1	3	23	31

-- !with_lateral_view --
1	1	1	[1, 2, 3, 4]	11	1	31	1	21	1	41
1	1	1	[1, 2, 3, 4]	11	2	31	1	21	1	42
1	1	1	[1, 2, 3, 4]	11	3	31	1	21	1	43
1	1	1	[1, 2, 3, 4]	11	4	31	1	21	1	44
2	3	4	[5, 6, 7, 8]	12	5	32	1	23	1	45
2	3	4	[5, 6, 7, 8]	12	6	32	1	23	1	46
2	3	4	[5, 6, 7, 8]	12	7	32	1	23	1	47
2	3	4	[5, 6, 7, 8]	12	8	32	1	23	1	48

-- !with_aggregate_project --
1	6

-- !with_aggregate_by_right_slot_project --
1	6

-- !with_project_aggregate --
1	1
2	4

-- !with_extend_aggregate --
\N	\N	1	1
\N	\N	4	4
\N	1	\N	1
\N	3	\N	4
1	\N	\N	1
2	\N	\N	4

-- !with_order_by --
1	1	1	[1, 2, 3, 4]	11	31	1	21
1	1	1	[1, 2, 3, 4]	11	31	2	22
1	1	1	[1, 2, 3, 4]	11	31	3	23

-- !with_limit --
1	1	1	[1, 2, 3, 4]	11	31	1	21
1	1	1	[1, 2, 3, 4]	11	31	2	22
1	1	1	[1, 2, 3, 4]	11	31	3	23

-- !with_union_all --
1	1	1	[1, 2, 3, 4]	11	31
1	1	1	[1, 2, 3, 4]	11	31
2	3	4	[5, 6, 7, 8]	12	32
2	3	4	[5, 6, 7, 8]	12	32

-- !with_filter --
1	1	1	[1, 2, 3, 4]	11	1	21
1	1	1	[1, 2, 3, 4]	11	2	22
1	1	1	[1, 2, 3, 4]	11	3	23