You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladimir Ozerov (JIRA)" <ji...@apache.org> on 2017/09/04 13:26:00 UTC
[jira] [Updated] (IGNITE-5623) DDL needs to support DEFAULT
operator
[ https://issues.apache.org/jira/browse/IGNITE-5623?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vladimir Ozerov updated IGNITE-5623:
------------------------------------
Fix Version/s: (was: 2.3)
> 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: Alexander Paschenko
>
> 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)