regression-test/data/query_p0/set_operations/except.out

-- This file is automatically generated. You should know what you did if you want to edit this
-- !except_left_deep --
1	a
2	b
3	c
4	d
5	e
6	f
7	g
8	h
9	i

-- !except_left_deep_shape --
PhysicalResultSink
--PhysicalExcept build RFs:RF0 a->a RF1 a->a 
----filter((t1.__DORIS_DELETE_SIGN__ = 0))
------PhysicalOlapScan[t1]
----filter((t2.__DORIS_DELETE_SIGN__ = 0))
------PhysicalOlapScan[t2] apply RFs: RF0
----filter((t3.__DORIS_DELETE_SIGN__ = 0))
------PhysicalOlapScan[t3] apply RFs: RF1

-- !except_right_deep --
1	a
10	j
2	b
3	c
4	d
5	e
6	f
7	g
8	h
9	i

-- !except_right_deep_shape --
PhysicalResultSink
--PhysicalExcept build RFs:RF1 a->a RF2 a->a 
----filter((t1.__DORIS_DELETE_SIGN__ = 0))
------PhysicalOlapScan[t1]
----PhysicalExcept build RFs:RF0 a->a 
------filter((t2.__DORIS_DELETE_SIGN__ = 0))
--------PhysicalOlapScan[t2] apply RFs: RF1
------filter((t3.__DORIS_DELETE_SIGN__ = 0))
--------PhysicalOlapScan[t3] apply RFs: RF0 RF2

-- !except_left_deep_right_deep --
1	a
2	b
3	c
4	d
5	e
6	f
7	g
8	h
9	i

-- !except_left_deep_right_deep_shape --
PhysicalResultSink
--PhysicalExcept build RFs:RF1 a->a RF2 a->a RF3 a->a 
----filter((t1.__DORIS_DELETE_SIGN__ = 0))
------PhysicalOlapScan[t1]
----filter((t2.__DORIS_DELETE_SIGN__ = 0))
------PhysicalOlapScan[t2] apply RFs: RF1
----PhysicalExcept build RFs:RF0 a->a 
------filter((t3.__DORIS_DELETE_SIGN__ = 0))
--------PhysicalOlapScan[t3] apply RFs: RF2
------filter((t2.__DORIS_DELETE_SIGN__ = 0))
--------PhysicalOlapScan[t2] apply RFs: RF0 RF3

-- !except_left_deep --
1	a
2	b
3	c
3	l
4	d
5	e
6	f
7	g
8	h
9	i
9	o

-- !except_left_deep_shape --
PhysicalResultSink
--PhysicalExcept build RFs:RF0 a->a 
----hashAgg[GLOBAL]
------hashAgg[LOCAL]
--------PhysicalUnion
----------filter((t1.__DORIS_DELETE_SIGN__ = 0))
------------PhysicalOlapScan[t1]
----------filter((t2.__DORIS_DELETE_SIGN__ = 0))
------------PhysicalOlapScan[t2]
----filter((t3.__DORIS_DELETE_SIGN__ = 0))
------PhysicalOlapScan[t3] apply RFs: RF0

-- !except_right_deep --
1	a
2	b
3	c
4	d
5	e
6	f
7	g
8	h
9	i

-- !except_right_deep_shape --
PhysicalResultSink
--PhysicalExcept build RFs:RF0 a->a RF1 a->a 
----filter((t1.__DORIS_DELETE_SIGN__ = 0))
------PhysicalOlapScan[t1]
----hashAgg[GLOBAL]
------hashAgg[LOCAL]
--------PhysicalUnion
----------filter((t2.__DORIS_DELETE_SIGN__ = 0))
------------PhysicalOlapScan[t2] apply RFs: RF0
----------filter((t3.__DORIS_DELETE_SIGN__ = 0))
------------PhysicalOlapScan[t3] apply RFs: RF1

-- !except_left_deep_right_deep --
1	a
2	b
3	c
4	d
5	e
6	f
7	g
8	h
9	i

-- !except_left_deep_right_deep_shape --
PhysicalResultSink
--PhysicalExcept build RFs:RF0 a->a RF1 a->a 
----hashAgg[GLOBAL]
------hashAgg[LOCAL]
--------PhysicalUnion
----------filter((t1.__DORIS_DELETE_SIGN__ = 0))
------------PhysicalOlapScan[t1]
----------filter((t2.__DORIS_DELETE_SIGN__ = 0))
------------PhysicalOlapScan[t2]
----hashAgg[GLOBAL]
------hashAgg[LOCAL]
--------PhysicalUnion
----------filter((t3.__DORIS_DELETE_SIGN__ = 0))
------------PhysicalOlapScan[t3] apply RFs: RF0
----------filter((t2.__DORIS_DELETE_SIGN__ = 0))
------------PhysicalOlapScan[t2] apply RFs: RF1