[
https://issues.apache.org/jira/browse/IGNITE-10906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Kuznetsov updated IGNITE-10906:
-------------------------------------
Description:
If we created empty table, we can perform UPDATE that sets _val to null.
For non empty tables, validation is ok.
{code:sql}
CREATE TABLE SIMPLE (id INT PRIMARY KEY, name VARCHAR) WITH "wrap_value=false,
wrap_key=false"
UPDATE SIMPLE SET _val = null
{code}
But it should, because underlying cache doesn't support null values.
was:
Currently next query doesn't cause error:
{code:sql}
CREATE TABLE SIMPLE (id INT PRIMARY KEY, name VARCHAR) WITH "wrap_value=false,
wrap_key=false"
UPDATE SIMPLE SET _val = null
{code}
But it should, because underlying cache doesn't support null values.
> SQL: UPDATE statement allows null for entire value cache object for empty
> tables.
> ----------------------------------------------------------------------------------
>
> Key: IGNITE-10906
> URL: https://issues.apache.org/jira/browse/IGNITE-10906
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Pavel Kuznetsov
> Priority: Minor
>
> If we created empty table, we can perform UPDATE that sets _val to null.
> For non empty tables, validation is ok.
> {code:sql}
> CREATE TABLE SIMPLE (id INT PRIMARY KEY, name VARCHAR) WITH
> "wrap_value=false, wrap_key=false"
> UPDATE SIMPLE SET _val = null
> {code}
> But it should, because underlying cache doesn't support null values.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
