[
https://issues.apache.org/jira/browse/IGNITE-22968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Igor updated IGNITE-22968:
--------------------------
Description:
*Steps:*
1.
{code:sql}
create table tmp_table_from (key_field INT PRIMARY KEY,field1 VARCHAR);
{code}
2.
{code:sql}
insert into tmp_table_from (key_field, field1) values (1, '2017-11-09');
{code}
3.
{code:sql}
create table tmp_table_to (key_field INT PRIMARY KEY,field1 DATE);
{code}
4.
{code:sql}
insert into tmp_table_to (key_field, field1) values (1, (select CONVERT(field1,
DATE) from tmp_table_from where key_field = 1));
{code}
*Expected:*
All queries passed.
Actual:
Erorr on step 4:
{code:sql}
// Some comments here
Failed to parse query: Incorrect syntax near the keyword 'DATE' at line 1,
column 81,
{code}
The similar error for types: TIME, TIMESTAMP, DATE,
But for VARCHAR there is a different error:
{code:sql}
insert into tmp_table_to (key_field, field1) values (1, (select CONVERT(field1,
VARCHAR) from tmp_table_from where key_field = 1));
Failed to parse query: Encountered ")" at line 1, column 88,
{code}
*Comments:*
The DOC for GG8
https://www.gridgain.com/docs/latest/sql-reference/system-functions#convert
(didn't find for GG9)
Calcite link https://calcite.apache.org/docs/reference.html#conversion
was:
*Steps:*
1.
{code:sql}
create table tmp_table_from (key_field INT PRIMARY KEY,field1 VARCHAR);
{code}
2.
{code:sql}
insert into tmp_table_from (key_field, field1) values (1, '2017-11-09');
{code}
3.
{code:sql}
create table tmp_table_to (key_field INT PRIMARY KEY,field1 DATE);
{code}
4.
{code:sql}
insert into tmp_table_to (key_field, field1) values (1, (select CONVERT(field1,
DATE) from tmp_table_from where key_field = 1));
{code}
*Expected:*
All queries passed.
Actual:
Erorr on step 4:
{code:sql}
// Some comments here
Failed to parse query: Incorrect syntax near the keyword 'DATE' at line 1,
column 81,
{code}
The similar error for types: TIME, TIMESTAMP, DATE,
But for VARCHAR there is a different error:
{code:sql}
insert into tmp_table_to (key_field, field1) values (1, (select CONVERT(field1,
VARCHAR) from tmp_table_from where key_field = 1));
Failed to parse query: Encountered ")" at line 1, column 88,
{code}
*Comments:*
The DOC for GG8
https://www.gridgain.com/docs/latest/sql-reference/system-functions#convert
(didn't find for GG9)
> CONVERT function returns error "Failed to parse query"
> ------------------------------------------------------
>
> Key: IGNITE-22968
> URL: https://issues.apache.org/jira/browse/IGNITE-22968
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 3.0.0-beta2
> Reporter: Igor
> Priority: Major
> Labels: ignite-3, sql
>
> *Steps:*
> 1.
> {code:sql}
> create table tmp_table_from (key_field INT PRIMARY KEY,field1 VARCHAR);
> {code}
> 2.
> {code:sql}
> insert into tmp_table_from (key_field, field1) values (1, '2017-11-09');
> {code}
> 3.
> {code:sql}
> create table tmp_table_to (key_field INT PRIMARY KEY,field1 DATE);
> {code}
> 4.
> {code:sql}
> insert into tmp_table_to (key_field, field1) values (1, (select
> CONVERT(field1, DATE) from tmp_table_from where key_field = 1));
> {code}
> *Expected:*
> All queries passed.
> Actual:
> Erorr on step 4:
> {code:sql}
> // Some comments here
> Failed to parse query: Incorrect syntax near the keyword 'DATE' at line 1,
> column 81,
> {code}
> The similar error for types: TIME, TIMESTAMP, DATE,
> But for VARCHAR there is a different error:
> {code:sql}
> insert into tmp_table_to (key_field, field1) values (1, (select
> CONVERT(field1, VARCHAR) from tmp_table_from where key_field = 1));
> Failed to parse query: Encountered ")" at line 1, column 88,
> {code}
> *Comments:*
> The DOC for GG8
> https://www.gridgain.com/docs/latest/sql-reference/system-functions#convert
> (didn't find for GG9)
> Calcite link https://calcite.apache.org/docs/reference.html#conversion
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
