Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 6ADE1200D09 for ; Tue, 12 Sep 2017 09:52:04 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 626331609C7; Tue, 12 Sep 2017 07:52:04 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id ABC661609C6 for ; Tue, 12 Sep 2017 09:52:03 +0200 (CEST) Received: (qmail 92477 invoked by uid 500); 12 Sep 2017 07:52:02 -0000 Mailing-List: contact issues-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ignite.apache.org Delivered-To: mailing list issues@ignite.apache.org Received: (qmail 92286 invoked by uid 99); 12 Sep 2017 07:52:02 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Sep 2017 07:52:02 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 3773ADC14B for ; Tue, 12 Sep 2017 07:52:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -99.202 X-Spam-Level: X-Spam-Status: No, score=-99.202 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, RP_MATCHES_RCVD=-0.001, SPF_PASS=-0.001, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id qT1DLluu2PAb for ; Tue, 12 Sep 2017 07:52:01 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 6647A5FDCE for ; Tue, 12 Sep 2017 07:52:01 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 838AEE06C4 for ; Tue, 12 Sep 2017 07:52:00 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 247672414B for ; Tue, 12 Sep 2017 07:52:00 +0000 (UTC) Date: Tue, 12 Sep 2017 07:52:00 +0000 (UTC) From: "Sergey Kalashnikov (JIRA)" To: issues@ignite.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (IGNITE-5648) DDL: NOT NULL constraint support for CREATE TABLE operator MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Tue, 12 Sep 2017 07:52:04 -0000 [ https://issues.apache.org/jira/browse/IGNITE-5648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16162634#comment-16162634 ] Sergey Kalashnikov commented on IGNITE-5648: -------------------------------------------- [~sboikov], [~vozerov], Points 1, 2 - fixed. However, I skipped the parts related to cache interceptor and other infrequently used facilities for now. We discussed this with Vova and decided to address this in separate tickets (in fact, we want to forbid using NOT_NULL fields when a cache has interceptor/read-through/conflict resolver configured). Point 3 - It is only possible to create index on a cache that already have QueryEntity configured. So, I think the way GridCacheContext.isQueryEnabled() implemented is ok (at least for the time being). > DDL: NOT NULL constraint support for CREATE TABLE operator > ---------------------------------------------------------- > > Key: IGNITE-5648 > URL: https://issues.apache.org/jira/browse/IGNITE-5648 > Project: Ignite > Issue Type: New Feature > Components: sql > Affects Versions: 2.0 > Reporter: Denis Magda > Assignee: Sergey Kalashnikov > Fix For: 2.3 > > > This is an umbrella ticket intended to aggregate all the activities related to {{NOT NULL}} constraint support for {{CREATE TABLE}} commands. > {code} > CREATE TABLE legs(legid INT NOT NULL); > {code} > Ignite must prevent setting {{legid}} to {{null}} value. > The feature has to be supported for: > * ODBC and JDBC drivers. > * Native APIs (Java, .NET, C++) -- This message was sent by Atlassian JIRA (v6.4.14#64029)