[ 
https://issues.apache.org/jira/browse/IGNITE-3487?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15885380#comment-15885380
 ] 

Sergey Kalashnikov commented on IGNITE-3487:
--------------------------------------------

Implemented draft solution.
Ignite PR is https://github.com/apache/ignite/pull/1573
H2 changes can be found here : 
https://github.com/zkillingjar/h2database/tree/dev-syscolumns

[~sergi.vladykin], [~vozerov], could you please take a look at the changes? 
Thanks!

> _key and _val fields should be excluded from 'select * from' queries
> --------------------------------------------------------------------
>
>                 Key: IGNITE-3487
>                 URL: https://issues.apache.org/jira/browse/IGNITE-3487
>             Project: Ignite
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 1.6
>            Reporter: Valentin Kulichenko
>            Assignee: Sergey Kalashnikov
>              Labels: important
>             Fix For: 2.0
>
>
> We have a pretty serious usability issue - predefined {{_key}} and {{_val}} 
> fields are returned when query like {{select * from}} is executed. First of 
> all, this is counterintuitive because user never defines or configures these 
> fields. Second of all, they actually duplicate all other fields. And finally, 
> they cause serialization exceptions because classes for key and value are not 
> always available.
> We should exclude these fields from {{select * from}} queries, but this is a 
> compatibility breaking change. It should be done in 2.0.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to