Maksim Zhuravkov created IGNITE-21543:
-----------------------------------------
Summary: Sql. Support arbitrary expressions values in partition
pruning metadata.
Key: IGNITE-21543
URL: https://issues.apache.org/jira/browse/IGNITE-21543
Project: Ignite
Issue Type: Improvement
Components: sql
Reporter: Maksim Zhuravkov
Fix For: 3.0.0-beta2
Initial implementation of partition pruning metadata provided support of two
classes of values: literals and dynamic parameters. it covers a lot of cases
but it rejects trivial expressions such as:
> SELECT * FROM t WHERE date_col = '2001-01-01'::DATE
> SELECT * FROM t WHERE uid_col = '0000-0000-0000-0000'::UUID
Let's allow arbitrary non-volatile (immutable and stable) * expressions as
legal values for partition pruning metadata.
- An expression is immutable if all its sub expressions are immutable.
- An expression is stable if all its sub expressions are stable or immutable.
- An expression is volatile if at least of its subexpressions is volatile.
Immutable expressions: 1 + 2, abs(42).
Stable expressions: current_timestamp.
Volatile functions in IA-3 are random and gen_random_uuid
* See documentation of function volatility in PostgreSQL -
https://www.postgresql.org/docs/current/xfunc-volatility.html
--
This message was sent by Atlassian Jira
(v8.20.10#820010)