[ 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)