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 2E54F200D5D for ; Wed, 20 Dec 2017 22:19:03 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 2CCA0160BF9; Wed, 20 Dec 2017 21:19:03 +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 7BA18160C18 for ; Wed, 20 Dec 2017 22:19:02 +0100 (CET) Received: (qmail 72374 invoked by uid 500); 20 Dec 2017 21:19:01 -0000 Mailing-List: contact commits-help@trafodion.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: commits@trafodion.apache.org Delivered-To: mailing list commits@trafodion.apache.org Received: (qmail 72317 invoked by uid 99); 20 Dec 2017 21:19:01 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 20 Dec 2017 21:19:01 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 274B81A064B for ; Wed, 20 Dec 2017 21:19:01 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -3.721 X-Spam-Level: X-Spam-Status: No, score=-3.721 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, KAM_NUMSUBJECT=0.5, RCVD_IN_DNSWL_HI=-5, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id EcAoPlZs3Fe4 for ; Wed, 20 Dec 2017 21:19:00 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with SMTP id D30B65FB2A for ; Wed, 20 Dec 2017 21:18:59 +0000 (UTC) Received: (qmail 72220 invoked by uid 99); 20 Dec 2017 21:18:59 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 20 Dec 2017 21:18:59 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 3148FE35E9; Wed, 20 Dec 2017 21:18:58 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit From: dbirdsall@apache.org To: commits@trafodion.incubator.apache.org Date: Wed, 20 Dec 2017 21:19:03 -0000 Message-Id: <6f460f2e518347b39b9930a307dc53d0@git.apache.org> In-Reply-To: References: X-Mailer: ASF-Git Admin Mailer Subject: [6/7] incubator-trafodion git commit: Incorporate Comments 2 archived-at: Wed, 20 Dec 2017 21:19:03 -0000 Incorporate Comments 2 Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/b59947f1 Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/b59947f1 Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/b59947f1 Branch: refs/heads/master Commit: b59947f19468a8fb862f9ffb0c09ee9ab8861887 Parents: 2a48db2 Author: liu.yu Authored: Wed Dec 20 14:57:55 2017 +0800 Committer: liu.yu Committed: Wed Dec 20 14:57:55 2017 +0800 ---------------------------------------------------------------------- .../src/asciidoc/_chapters/sql_functions_and_expressions.adoc | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/b59947f1/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc ---------------------------------------------------------------------- diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc index 733256f..1c2a7f6 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc @@ -3489,7 +3489,11 @@ EMPTY_BLOB() ** The dummy LOB handle will get the same datatype as the underlying column. + -For example, if the LOB column was defined as `‘EXTERNAL’` during table creation, then the LOB column gets that type. If it’s not defined, then it is considered as a regular LOB. +For example, ++ +*** If the LOB column is defined as `'EXTERNAL'` during table creation, then the dummy LOB handle will get the type `'EXTERNAL'` and can only process external LOB data. ++ +*** If the LOB column is not defined as `'EXTERNAL'` during table creation, then the dummy LOB handle will be considered as a regular LOB dummy handle. If this handle is used to perform an insert or update operation, the LOB data will be maintained within the Trafodion space in the internal location maintained by Trafodion. * An empty LOB is distinct from a LOB containing a string of length zero or a null LOB.