You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Sergey Kalashnikov (Jira)" <ji...@apache.org> on 2020/06/03 10:09:00 UTC

[jira] [Created] (IGNITE-13110) An option to validate field types against SQL schema on key-value insert

Sergey Kalashnikov created IGNITE-13110:
-------------------------------------------

             Summary: An option to validate field types against SQL schema on key-value insert
                 Key: IGNITE-13110
                 URL: https://issues.apache.org/jira/browse/IGNITE-13110
             Project: Ignite
          Issue Type: Bug
            Reporter: Sergey Kalashnikov
            Assignee: Sergey Kalashnikov


Let's add a configurable option to prevent insertion of key-value pairs that aren't compatible with SQL schema.

An option can be added on {{SqlConfiguration}} level or even per {{QueryEntity}}.

The checks can be performed within the existing {{GridQueryTypeDescriptor#validateKeyAndValue}} facility that seems to be well suited for this task.

This addition will prevent the problems when values successfully added to the cache later produce errors when queried with SQL.

See discussion : http://apache-ignite-developers.2346864.n4.nabble.com/Prevent-insertion-of-cache-entry-if-the-binary-field-type-and-the-type-of-the-query-entity-do-not-ma-td47678.html







--
This message was sent by Atlassian Jira
(v8.3.4#803005)