You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Alexander Belyak (Jira)" <ji...@apache.org> on 2023/06/11 17:02:00 UTC

[jira] [Created] (IGNITE-19702) Unable to create column with default value with literal convertion

Alexander Belyak created IGNITE-19702:
-----------------------------------------

             Summary: Unable to create column with default value with literal convertion
                 Key: IGNITE-19702
                 URL: https://issues.apache.org/jira/browse/IGNITE-19702
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 3.0
            Reporter: Alexander Belyak


DDL command to create a column with default value fails if it require some type of conversion (string to time, date, timestamp, uuid). For example:
{noformat}
create table ttt6(key int primary key, val TIMESTAMP default '2022-02-01 12:12:12');{noformat}
returns
{noformat}
[Code: 0, SQL State: 50000]  Exception while executing query [query=create table ttt6(key int primary key, val TIMESTAMP default '2022-02-01 12:12:12')]. Error message:Unable co convert literal{noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)