[IGNITE-11434] SQL: Create a view with list of existing COLUMNS

• Type: Task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: sql
• Labels: iep-29 newbie
• Ignite Flags: Docs Required
• Assignee: Unassigned
• Reporter: Iurii Gerzhedovich
• Created: 27/Feb/19 11:19
• Updated: 03/Jul/20 06:49

Description

Need to expose SQL system view with COLUMNS information.

Need to investigate more deeper which of information should be there.

 

As start point we can take https://dev.mysql.com/doc/refman/8.0/en/columns-table.html 

Columns description:

Name	Type	Description
SCHEMA_NAME	string	Schema name
TABLE_NAME	string	Table name
COLUMN_NAME	string	Column name
ORDINAL_POSITION	int	Column ordinal. Starts with 1
DEFAULT VALUE	string	Defaut column's value
IS_NULLABLE	boolean	Nullable flag corresponds to QueryEntity#setNotNullFields
DATA_TYPE	string	SQL data type
CHARACTER_LENGTH	int	Size for char CAHR and VARCHAR types
NUMERIC_PRECISION	int	Precision for numeric types
NUMERIC_SCALE	int	Scale for numeric types
IS_AFFINITY_KEY	boolean	true whan the column is affinity key
IS_HIDDEN	boolean	true for hidden _ley nad _val columns. false for all columns available by asterisk mask

Issue Links

• blocks: IGNITE-10745 SQL: jdbc metadata's getColumns returns wrong value for "ORDINAL_POSITION"
• blocks: IGNITE-11440 H2 SHOW commands support
• blocks: IGNITE-11720 Document new SQL system view "COLUMNS"
• is blocked by: IGNITE-11470 Views don't show in Dbeaver
• links to: GitHub Pull Request #6240
• links to: Tests results