Maksim Zhuravkov created IGNITE-24227:
-----------------------------------------
Summary: Sql. Improve type checking in LIMIT / OFFSET clauses
Key: IGNITE-24227
URL: https://issues.apache.org/jira/browse/IGNITE-24227
Project: Ignite
Issue Type: Improvement
Components: sql
Reporter: Maksim Zhuravkov
IgniteSqlValidator checkIntegerLimit accepts all numeric types (including
DECIMAL) in LIMIT / OFFSET clause, which causes runtime errors instead of
validation errors.
{code:java}
sql-cli> CREATE TABLE t (id INT PRIMARY KEY, val INT);
Updated 0 rows.
sql-cli> SELECT * FROM t LIMIT 1.0
SQL query execution error
class java.math.BigDecimal cannot be cast to class java.lang.Integer
(java.math.BigDecimal and java.lang.Integer are in module java.base of loader
'bootstrap')
sql-cli>
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)