You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2018/01/05 09:13:00 UTC

[jira] [Commented] (IGNITE-5623) DDL needs to support DEFAULT operator

    [ https://issues.apache.org/jira/browse/IGNITE-5623?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16312751#comment-16312751 ] 

ASF GitHub Bot commented on IGNITE-5623:
----------------------------------------

Github user asfgit closed the pull request at:

    https://github.com/apache/ignite/pull/3256


> DDL needs to support DEFAULT operator 
> --------------------------------------
>
>                 Key: IGNITE-5623
>                 URL: https://issues.apache.org/jira/browse/IGNITE-5623
>             Project: Ignite
>          Issue Type: Task
>          Components: sql
>    Affects Versions: 2.0
>            Reporter: Denis Magda
>            Assignee: Taras Ledkov
>              Labels: important
>             Fix For: 2.4
>
>
> There should be a way to set a default value for a column/field if the one is not specified during an insert operation. In general, we need to support {{<field> DEFAULT <value>}} in a way it's show below:
> {code}
> CREATE TABLE Persons (
>   ID int,
>   FirstName varchar(255),
>   Age int,
>   City varchar(255) DEFAULT 'Sandnes'
> );
> {code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)