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