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

ASF GitHub Bot commented on IGNITE-3487:
----------------------------------------

GitHub user skalashnikov opened a pull request:

    https://github.com/apache/ignite/pull/1727

    IGNITE-3487: _key and _val fields should be excluded from 'select * from' 
queries

    

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/gridgain/apache-ignite ignite-3487

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/ignite/pull/1727.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #1727
    
----
commit 3a10a319f54085b6f3b59a466ea9244b53eceac9
Author: Sergi Vladykin <[email protected]>
Date:   2017-03-09T13:16:27Z

    ignite-1.9.1 - h2 version upgrade

commit 219e6285a4444c1ab761045df85b73296905cd07
Author: Sergi Vladykin <[email protected]>
Date:   2017-03-09T13:21:55Z

    ignite-1.9.1 - h2 version upgrade - tests fix

commit 143a09461b352c82b02bdbb629d6aa8f90c0745a
Author: Sergi Vladykin <[email protected]>
Date:   2017-03-09T15:24:25Z

    ignite-1.9.1 - sql index hints

commit 8946b312670b0721c3dc271c12933c80c41668ed
Author: skalashnikov <[email protected]>
Date:   2017-03-17T17:57:19Z

    IGNITE-3487: Made _key and _val columns hidden

commit 10ba37183806712994ff193af886d9744da3edc1
Author: skalashnikov <[email protected]>
Date:   2017-03-20T09:25:39Z

    IGNITE-3487: minor fixes

commit 603fe292b27ddc421d42eb9156f03b77dc1c5233
Author: skalashnikov <[email protected]>
Date:   2017-03-28T08:53:25Z

    Merge branch 'master' of https://github.com/apache/ignite into ignite-3487

commit 7a42e62d7b013492a6b704bfb7bdd8440eb0d2da
Author: skalashnikov <[email protected]>
Date:   2017-03-28T10:10:59Z

    Merge branch 'ignite-1.9.1-hints' of 
https://github.com/gridgain/apache-ignite into ignite-3487

commit ca16c40e6fcea231666ed22e27f20bc6b4aa4690
Author: skalashnikov <[email protected]>
Date:   2017-04-04T13:31:52Z

    Merge branch 'master' of https://github.com/apache/ignite into ignite-3487

----


> _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