Igor created IGNITE-22968:
-----------------------------
Summary: 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
*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)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
