[ https://issues.apache.org/jira/browse/IGNITE-20970?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Maksim Zhuravkov updated IGNITE-20970: -------------------------------------- Description: Let's disallow null dynamic parameters in LIMIT/OFFSET clauses. The following statements should be rejected by SQL validator, because null is not valid value for limit / offset clause: {code:java} sql("SELECT * FROM t LIMIT ?", new Object{}[null]); sql("SELECT * FROM t OFFSET ?", new Object{}[null]); sql("SELECT * FROM t LIMIT ? OFFSET ?", new Object{}[null]); {code} was: Let's disallow null dynamic parameters in LIMIT/OFFSET clauses. > Sql. Disallow null dynamic parameters in LIMIT/OFFSET clauses. > -------------------------------------------------------------- > > Key: IGNITE-20970 > URL: https://issues.apache.org/jira/browse/IGNITE-20970 > Project: Ignite > Issue Type: Improvement > Components: sql > Reporter: Maksim Zhuravkov > Priority: Minor > Labels: ignite-3 > Fix For: 3.0.0-beta2 > > > Let's disallow null dynamic parameters in LIMIT/OFFSET clauses. The > following statements should be rejected by SQL validator, because null is not > valid value for limit / offset clause: > {code:java} > sql("SELECT * FROM t LIMIT ?", new Object{}[null]); > sql("SELECT * FROM t OFFSET ?", new Object{}[null]); > sql("SELECT * FROM t LIMIT ? OFFSET ?", new Object{}[null]); > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)