You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Yury Gerzhedovich (Jira)" <ji...@apache.org> on 2021/12/22 14:16:00 UTC

[jira] [Updated] (IGNITE-16192) Calcite. Support hidden columns

     [ https://issues.apache.org/jira/browse/IGNITE-16192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yury Gerzhedovich updated IGNITE-16192:
---------------------------------------
    Description: 
We should have ability to hide some columns. At first glance it's *_key* column. It really important for autogenerated PK.
Such columns couldn't be accessed for 'select * ' query, but available for explicit use in select statement. 
Another example of hidden column is Oracle *rownum*.
Also another databases (Oracle, SQLSERVER, MySQL) have support hidden (invisible) columns which could be created user explicitly and amend the visibility through ALTER statement.  Maybe we should consider possible extension it for future to support one.

  was:
We should have ability to hide some columns. At first glance it's *_key* column. It really important for autogenerated PK.
Such columns couldn't be accessed for 'select * ' query, but available for explicit use in select statement. 
Another example of hidden column is Oracle *rownum*.
Also another databases have support hidden (invisible) columns which could be created user explicitly and amend the visibility through ALTER statement.  Maybe we should consider possible extension it for future to support one.


> Calcite. Support hidden columns
> -------------------------------
>
>                 Key: IGNITE-16192
>                 URL: https://issues.apache.org/jira/browse/IGNITE-16192
>             Project: Ignite
>          Issue Type: New Feature
>          Components: sql
>            Reporter: Yury Gerzhedovich
>            Priority: Major
>              Labels: calcite2-required, calcite3-required, ignite-3
>
> We should have ability to hide some columns. At first glance it's *_key* column. It really important for autogenerated PK.
> Such columns couldn't be accessed for 'select * ' query, but available for explicit use in select statement. 
> Another example of hidden column is Oracle *rownum*.
> Also another databases (Oracle, SQLSERVER, MySQL) have support hidden (invisible) columns which could be created user explicitly and amend the visibility through ALTER statement.  Maybe we should consider possible extension it for future to support one.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)