SELECT validate_expression('calamity.part_test', 'valval');/* not ok */

ERROR: cannot find type name for attribute "valval" of relation "part_test"

SELECT validate_expression('calamity.part_test', 'random()');/* not ok */

ERROR:functions inpartitioning expressionmust be marked IMMUTABLE

ERROR:failed to analyzepartitioning expression(random())

SELECT validate_expression('calamity.part_test', 'val');/* OK */

validate_expression

---------------------

5

(1 row)

/* Try using constant expression */

SELECT create_hash_partitions('test_exprs.hash_rel', '1 + 1', 4);

ERROR: partitioning expression should reference table "hash_rel"

\set VERBOSITY default

/* Try using mutable expression */

SELECT create_hash_partitions('test_exprs.hash_rel', 'random()', 4);

ERROR: functions in partitioning expression must be marked IMMUTABLE

ERROR: failed to analyze partitioning expression (random())

DETAIL: functions in partitioning expression must be marked IMMUTABLE

CONTEXT: SQL statement "SELECT public.validate_expression(parent_relid, expression)"

PL/pgSQL function prepare_for_partitioning(regclass,text,boolean) line 9 at PERFORM

SQL statement "SELECT public.prepare_for_partitioning(parent_relid,

expression,

partition_data)"

PL/pgSQL function create_hash_partitions(regclass,text,integer,boolean,text[],text[]) line 4 at PERFORM

/* Check that 'pathman_hooks_enabled' is true (1 partition in plan) */

EXPLAIN (COSTS OFF) INSERT INTO test_exprs.canary_copy

SELECT * FROM test_exprs.canary WHERE val = 1;

Filter: (val = 1)

(4 rows)

SELECT create_hash_partitions('test_exprs.hash_rel', 'value * value2))', 4);

ERROR: failed to parse partitioning expression (value * value2)))

DETAIL: syntax error at or near ")"

CREATE TABLE test_exprs.range_rel (id SERIAL PRIMARY KEY, dt TIMESTAMP, txt TEXT);

INSERT INTO test_exprs.range_rel (dt, txt)

SELECT g, md5(g::TEXT) FROM generate_series('2015-01-01', '2020-04-30', '1 month'::interval) as g;

SELECT create_range_partitions('test_exprs.range_rel', 'RANDOM()', '15 years'::INTERVAL, '1 year'::INTERVAL, 10);

ERROR: functions in partitioning expression must be marked IMMUTABLE

/* Try using constant expression */

SELECT create_range_partitions('test_exprs.range_rel', '''16 years''::interval',

'15 years'::INTERVAL, '1 year'::INTERVAL, 10);

ERROR: partitioning expression should reference table "range_rel"

\set VERBOSITY default

/* Try using mutable expression */

SELECT create_range_partitions('test_exprs.range_rel', 'RANDOM()',

'15 years'::INTERVAL, '1 year'::INTERVAL, 10);

ERROR: failed to analyze partitioning expression (RANDOM())

DETAIL: functions in partitioning expression must be marked IMMUTABLE

CONTEXT: SQL statement "SELECT public.validate_expression(parent_relid, expression)"

PL/pgSQL function prepare_for_partitioning(regclass,text,boolean) line 9 at PERFORM

SQL statement "SELECT public.prepare_for_partitioning(parent_relid,

expression,

partition_data)"

PL/pgSQL function create_range_partitions(regclass,text,anyelement,interval,integer,boolean) line 12 at PERFORM

/* Check that 'pathman_hooks_enabled' is true (1 partition in plan) */

EXPLAIN (COSTS OFF) INSERT INTO test_exprs.canary_copy

SELECT * FROM test_exprs.canary WHERE val = 1;

QUERY PLAN

----------------------------------

Insert on canary_copy

-> Append

-> Seq Scan on canary_0

Filter: (val = 1)

(4 rows)

\set VERBOSITY terse

SELECT create_range_partitions('test_exprs.range_rel', 'AGE(dt, ''2000-01-01''::DATE)',

'15 years'::INTERVAL, '1 year'::INTERVAL, 10);

'15 years'::INTERVAL, '1 year'::INTERVAL, 10);

create_range_partitions

-------------------------

10

SELECT val, val*2FROM generate_series(1,5) val;

SELECTCOUNT(*)FROMtest_exprs.hash_rel;

SELECT create_hash_partitions('test_exprs.hash_rel','1 + 1',4);

\set VERBOSITY default

SELECT create_hash_partitions('test_exprs.hash_rel','random()',4);

EXPLAIN (COSTS OFF)INSERT INTOtest_exprs.canary_copy

SELECT*FROMtest_exprs.canaryWHERE val=1;

\set VERBOSITY default

SELECT create_hash_partitions('test_exprs.hash_rel','value * value2))',4);

SELECT create_hash_partitions('test_exprs.hash_rel','value * value3',4);

INSERT INTOtest_exprs.range_rel (dt, txt)

SELECT g, md5(g::TEXT)FROM generate_series('2015-01-01','2020-04-30','1 month'::interval)as g;

SELECT create_range_partitions('test_exprs.range_rel','RANDOM()','15 years'::INTERVAL,'1 year'::INTERVAL,10);

SELECT create_range_partitions('test_exprs.range_rel','''16 years''::interval',

'15 years'::INTERVAL,'1 year'::INTERVAL,10);

\set VERBOSITY default

SELECT create_range_partitions('test_exprs.range_rel','RANDOM()',

'15 years'::INTERVAL,'1 year'::INTERVAL,10);

EXPLAIN (COSTS OFF)INSERT INTOtest_exprs.canary_copy

SELECT*FROMtest_exprs.canaryWHERE val=1;

\set VERBOSITY terse

SELECT create_range_partitions('test_exprs.range_rel','AGE(dt,''2000-01-01''::DATE)',

'15 years'::INTERVAL,'1 year'::INTERVAL,10);

'15 years'::INTERVAL,'1 year'::INTERVAL,10);

INSERT INTOtest_exprs.range_rel_1 (dt, txt)VALUES ('2020-01-01'::DATE, md5('asdf'));

SELECTCOUNT(*)FROMtest_exprs.range_rel_6;

INSERT INTOtest_exprs.range_rel_6 (dt, txt)VALUES ('2020-01-01'::DATE, md5('asdf'));

fix_opfuncids(prel->expr);

expr_varnos=pull_varnos(prel->expr);

if (bms_singleton_member(expr_varnos)!=PART_EXPR_VARNO)

elog(ERROR,"partitioning expression may reference only one table");

if (bms_num_members(expr_varnos)!=1)

elog(ERROR,"partitioning expression should reference table \"%s\"",

get_rel_name(relid));

prel->expr_vars=NIL;

*raw_expr;

List*query_tree_list;

volatileboolok_rewrite= false;/* must be volatile, else

char*query_string,

*expr_serialized="";/* keep compiler happy */

AssertTemporaryContext();

(void)ok_rewrite;

query_tree_list=pg_analyze_and_rewrite(parse_tree,query_string,NULL,0);

ok_rewrite= true;/* tell PG_CATCH that we're fine */

if (list_length(query_tree_list)!=1)

elog(ERROR,"partitioning expression produced more than 1 query");

pathman_hooks_enabled= true;

if (ok_rewrite)

PG_RE_THROW();

MemoryContextSwitchTo(old_mcxt);

error=CopyErrorData();