[jira] [Updated] (IGNITE-11434) SQL: Create a view with list of existing COLUMNS

2020-07-03 Thread Aleksey Plekhanov (Jira) 


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

Aleksey Plekhanov updated IGNITE-11434:
---
Fix Version/s: (was: 2.9)

> SQL: Create a view with list of existing COLUMNS
> 
>
> Key: IGNITE-11434
> URL: https://issues.apache.org/jira/browse/IGNITE-11434
> Project: Ignite
>  Issue Type: Task
>  Components: sql
>Reporter: Yury Gerzhedovich
>Priority: Major
>  Labels: iep-29, newbie
>  Time Spent: 1h 40m
>  Remaining Estimate: 0h
>
> 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 |



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Updated] (IGNITE-11434) SQL: Create a view with list of existing COLUMNS

2020-02-05 Thread Yury Gerzhedovich (Jira) 


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

Yury Gerzhedovich updated IGNITE-11434:
---
Labels: iep-29 newbie  (was: iep-29)

> SQL: Create a view with list of existing COLUMNS
> 
>
> Key: IGNITE-11434
> URL: https://issues.apache.org/jira/browse/IGNITE-11434
> Project: Ignite
>  Issue Type: Task
>  Components: sql
>Reporter: Yury Gerzhedovich
>Priority: Major
>  Labels: iep-29, newbie
> Fix For: 2.9
>
>  Time Spent: 1h 40m
>  Remaining Estimate: 0h
>
> 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 |



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Updated] (IGNITE-11434) SQL: Create a view with list of existing COLUMNS

2019-10-10 Thread Maxim Muzafarov (Jira) 


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

Maxim Muzafarov updated IGNITE-11434:
-
Fix Version/s: (was: 2.8)
   2.9

> SQL: Create a view with list of existing COLUMNS
> 
>
> Key: IGNITE-11434
> URL: https://issues.apache.org/jira/browse/IGNITE-11434
> Project: Ignite
>  Issue Type: Task
>  Components: sql
>Reporter: Yury Gerzhedovich
>Assignee: Taras Ledkov
>Priority: Major
>  Labels: iep-29
> Fix For: 2.9
>
>  Time Spent: 1h 40m
>  Remaining Estimate: 0h
>
> 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 |



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Updated] (IGNITE-11434) SQL: Create a view with list of existing COLUMNS

2019-04-16 Thread Andrew Mashenkov (JIRA) 


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

Andrew Mashenkov updated IGNITE-11434:
--
Fix Version/s: 2.8

> SQL: Create a view with list of existing COLUMNS
> 
>
> Key: IGNITE-11434
> URL: https://issues.apache.org/jira/browse/IGNITE-11434
> Project: Ignite
>  Issue Type: Task
>  Components: sql
>Reporter: Yury Gerzhedovich
>Assignee: Taras Ledkov
>Priority: Major
>  Labels: iep-29
> Fix For: 2.8
>
>  Time Spent: 1.5h
>  Remaining Estimate: 0h
>
> 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 |



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (IGNITE-11434) SQL: Create a view with list of existing COLUMNS

2019-04-04 Thread Taras Ledkov (JIRA) 


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

Taras Ledkov updated IGNITE-11434:
--
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 |


  was:
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}} whan the column is affinity key |



> SQL: Create a view with list of existing COLUMNS
> 
>
> Key: IGNITE-11434
> URL: https://issues.apache.org/jira/browse/IGNITE-11434
> Project: Ignite
>  Issue Type: Task
>  Components: sql
>Reporter: Yury Gerzhedovich
>Assignee: Taras Ledkov
>Priority: Major
>  Labels: iep-29
>  Time Spent: 1.5h
>  Remaining Estimate: 0h
>
> 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 |



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (IGNITE-11434) SQL: Create a view with list of existing COLUMNS

2019-04-04 Thread Taras Ledkov (JIRA) 


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

Taras Ledkov updated IGNITE-11434:
--
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}} whan the column is affinity key |


  was:
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_ID | int | Column ID | 
| COLUMN_NAME | string | Column name | 
| DEFAULT VALUE | string | Defaut column's value |
| IS_NULLABLE | boolean | Nullable flag corresponds to 
{{QueryEntity#setNotNullFields}} |
| SQL TYPE | int | SQL data type ID |
| DATA_TYPE | string | SQL data type |
| DISPLAY_SIZE| int | Size (e.g. for VARCHAR) |
| PRECISION | int | Precision |
| SCALE |  int | Scale |
| AFFINITY_KEY | boolean | {{true}} whan the column is affinity key |



> SQL: Create a view with list of existing COLUMNS
> 
>
> Key: IGNITE-11434
> URL: https://issues.apache.org/jira/browse/IGNITE-11434
> Project: Ignite
>  Issue Type: Task
>  Components: sql
>Reporter: Yury Gerzhedovich
>Assignee: Taras Ledkov
>Priority: Major
>  Labels: iep-29
>  Time Spent: 1.5h
>  Remaining Estimate: 0h
>
> 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}} whan the column is affinity key |



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (IGNITE-11434) SQL: Create a view with list of existing COLUMNS

2019-04-02 Thread Taras Ledkov (JIRA) 


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

Taras Ledkov updated IGNITE-11434:
--
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_ID | int | Column ID | 
| COLUMN_NAME | string | Column name | 
| DEFAULT VALUE | string | Defaut column's value |
| IS_NULLABLE | boolean | Nullable flag corresponds to 
{{QueryEntity#setNotNullFields}} |
| SQL TYPE | int | SQL data type ID |
| DATA_TYPE | string | SQL data type |
| DISPLAY_SIZE| int | Size (e.g. for VARCHAR) |
| PRECISION | int | Precision |
| SCALE |  int | Scale |
| AFFINITY_KEY | boolean | {{true}} whan the column is affinity key |


  was:
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_ID | int | Column ID | 
| COLUMN_NAME | string | Column name | 
| DEFAULT VALUE | string | Defaut column's value |
| IS_NULLABLE | boolean | Nullable flag corresponds to 
{{QueryEntity#setNotNullFields}} |
| DATA_TYPE | string | SQL data type |
| DISPLAY_SIZE| int | Size (e.g. for VARCHAR) |
| PRECISION | int | Precision |
| SCALE |  int | Scale |
| AFFINITY_KEY | boolean | {{true}} whan the column is affinity key |



> SQL: Create a view with list of existing COLUMNS
> 
>
> Key: IGNITE-11434
> URL: https://issues.apache.org/jira/browse/IGNITE-11434
> Project: Ignite
>  Issue Type: Task
>  Components: sql
>Reporter: Yury Gerzhedovich
>Assignee: Taras Ledkov
>Priority: Major
>  Labels: iep-29
>  Time Spent: 1.5h
>  Remaining Estimate: 0h
>
> 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_ID | int | Column ID | 
> | COLUMN_NAME | string | Column name | 
> | DEFAULT VALUE | string | Defaut column's value |
> | IS_NULLABLE | boolean | Nullable flag corresponds to 
> {{QueryEntity#setNotNullFields}} |
> | SQL TYPE | int | SQL data type ID |
> | DATA_TYPE | string | SQL data type |
> | DISPLAY_SIZE| int | Size (e.g. for VARCHAR) |
> | PRECISION | int | Precision |
> | SCALE |  int | Scale |
> | AFFINITY_KEY | boolean | {{true}} whan the column is affinity key |



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (IGNITE-11434) SQL: Create a view with list of existing COLUMNS

2019-04-02 Thread Taras Ledkov (JIRA) 


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

Taras Ledkov updated IGNITE-11434:
--
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_ID | int | Column ID | 
| COLUMN_NAME | string | Column name | 
| DEFAULT VALUE | string | Defaut column's value |
| IS_NULLABLE | boolean | Nullable flag corresponds to 
{{QueryEntity#setNotNullFields}} |
| DATA_TYPE | string | SQL data type |
| DISPLAY_SIZE| int | Size (e.g. for VARCHAR) |
| PRECISION | int | Precision |
| SCALE |  int | Scale |
| AFFINITY_KEY | boolean | {{true}} whan the column is affinity key |


  was:
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 | Columns name | 
| DATA_TYPE | string | SQL data type |
| IS_NULLABLE | boolean | Nullable flag corresponds to 
{{QueryEntity#setNotNullFields}} |
| DISPLAY_SIZE| int | Size (e.g. for VARCHAR) |
| PRECISION | int | Precision |
| SCALE |  int | Scale |
| AFFINITY_KEY | boolean | {{true}} whan the column is affinity key |



> SQL: Create a view with list of existing COLUMNS
> 
>
> Key: IGNITE-11434
> URL: https://issues.apache.org/jira/browse/IGNITE-11434
> Project: Ignite
>  Issue Type: Task
>  Components: sql
>Reporter: Yury Gerzhedovich
>Assignee: Taras Ledkov
>Priority: Major
>  Labels: iep-29
>  Time Spent: 1.5h
>  Remaining Estimate: 0h
>
> 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_ID | int | Column ID | 
> | COLUMN_NAME | string | Column name | 
> | DEFAULT VALUE | string | Defaut column's value |
> | IS_NULLABLE | boolean | Nullable flag corresponds to 
> {{QueryEntity#setNotNullFields}} |
> | DATA_TYPE | string | SQL data type |
> | DISPLAY_SIZE| int | Size (e.g. for VARCHAR) |
> | PRECISION | int | Precision |
> | SCALE |  int | Scale |
> | AFFINITY_KEY | boolean | {{true}} whan the column is affinity key |



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (IGNITE-11434) SQL: Create a view with list of existing COLUMNS

2019-03-28 Thread Taras Ledkov (JIRA) 


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

Taras Ledkov updated IGNITE-11434:
--
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 | Columns name | 
| DATA_TYPE | string | SQL data type |
| IS_NULLABLE | boolean | Nullable flag corresponds to 
{{QueryEntity#setNotNullFields}} |
| DISPLAY_SIZE| int | Size (e.g. for VARCHAR) |
| PRECISION | int | Precision |
| SCALE |  int | Scale |
| AFFINITY_KEY | boolean | {{true}} whan the column is affinity key |


  was:
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] 


> SQL: Create a view with list of existing COLUMNS
> 
>
> Key: IGNITE-11434
> URL: https://issues.apache.org/jira/browse/IGNITE-11434
> Project: Ignite
>  Issue Type: Task
>  Components: sql
>Reporter: Yury Gerzhedovich
>Assignee: Taras Ledkov
>Priority: Major
>  Labels: iep-29
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> 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 | Columns name | 
> | DATA_TYPE | string | SQL data type |
> | IS_NULLABLE | boolean | Nullable flag corresponds to 
> {{QueryEntity#setNotNullFields}} |
> | DISPLAY_SIZE| int | Size (e.g. for VARCHAR) |
> | PRECISION | int | Precision |
> | SCALE |  int | Scale |
> | AFFINITY_KEY | boolean | {{true}} whan the column is affinity key |



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Updated] (IGNITE-11434) SQL: Create a view with list of existing COLUMNS

2019-02-27 Thread Yury Gerzhedovich (JIRA) 


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

Yury Gerzhedovich updated IGNITE-11434:
---
Labels: iep-29  (was: )

> SQL: Create a view with list of existing COLUMNS
> 
>
> Key: IGNITE-11434
> URL: https://issues.apache.org/jira/browse/IGNITE-11434
> Project: Ignite
>  Issue Type: Task
>  Components: sql
>Reporter: Yury Gerzhedovich
>Priority: Major
>  Labels: iep-29
>
> 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] 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)