[
https://issues.apache.org/jira/browse/IGNITE-24227?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky reassigned IGNITE-24227:
-------------------------------------------
Assignee: Evgeny Stanilovsky
> 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
> Assignee: Evgeny Stanilovsky
> Priority: Major
> Labels: ignite-3
>
> 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)
