src/test/regress/expected/partition_with_user_defined_function_optimizer.out

CREATE SCHEMA IF NOT EXISTS partition_with_user_defined_function;
-- Given there is a partitioned table
	create table partition_with_user_defined_function.some_partitioned_table
	(
		a integer
	)
	partition by range (a) (
		partition b start (0)
	);
NOTICE:  Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Apache Cloudberry data distribution key for this table.
HINT:  The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
-- And a function that queried the partitioned table
	CREATE OR REPLACE FUNCTION partition_with_user_defined_function.query_a_partition_table() RETURNS VOID AS
	$$
	BEGIN
	    PERFORM * FROM partition_with_user_defined_function.some_partitioned_table;
	END;
	$$ LANGUAGE plpgsql;
-- When I call the function twice
	select partition_with_user_defined_function.query_a_partition_table();
 query_a_partition_table 
-------------------------
 
(1 row)

-- Then I get the same result both times (no rows)
-- Note: We're using a cached plan that includes a Dynamic Seq Scan.
-- Ensure the dynamic table scan information in the cached plan does not get freed.
	select partition_with_user_defined_function.query_a_partition_table();
 query_a_partition_table 
-------------------------
 
(1 row)