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)

Reply via email to