Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 1425AC773 for ; Tue, 1 Oct 2013 08:13:52 +0000 (UTC) Received: (qmail 64696 invoked by uid 500); 1 Oct 2013 08:04:50 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 64507 invoked by uid 500); 1 Oct 2013 08:04:37 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 64397 invoked by uid 99); 1 Oct 2013 08:04:26 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Oct 2013 08:04:26 +0000 Date: Tue, 1 Oct 2013 08:04:25 +0000 (UTC) From: "ASF subversion and git services (JIRA)" To: derby-dev@db.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (DERBY-6357) CREATE TRIGGER doesn't detect all illegal references to SESSION schema MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DERBY-6357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13782702#comment-13782702 ] ASF subversion and git services commented on DERBY-6357: -------------------------------------------------------- Commit 1527963 from [~knutanders] in branch 'code/trunk' [ https://svn.apache.org/r1527963 ] DERBY-6357: CREATE TRIGGER doesn't detect all illegal references to SESSION schema > CREATE TRIGGER doesn't detect all illegal references to SESSION schema > ---------------------------------------------------------------------- > > Key: DERBY-6357 > URL: https://issues.apache.org/jira/browse/DERBY-6357 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.10.1.1 > Reporter: Knut Anders Hatlen > Assignee: Knut Anders Hatlen > Attachments: d6357-1a.diff > > > The reference manual's section on the DECLARE GLOBAL TEMPORARY TABLE statement says: Temporary tables cannot be referenced in a triggered-SQL-statement > It detects most cases and reports: > ERROR XCL51: The requested function can not reference tables in SESSION schema. > However, some references are not detected if they are in a subquery. For example: > ij version 10.10 > ij> connect 'jdbc:derby:memory:db;create=true'; > ij> declare global temporary table temptable(x int) not logged; > 0 rows inserted/updated/deleted > ij> create table t1(x int); > 0 rows inserted/updated/deleted > ij> create table t2(b boolean); > 0 rows inserted/updated/deleted > ij> create trigger tr1 after insert on t1 insert into t2 values exists(select * from session.temptable); > 0 rows inserted/updated/deleted > This CREATE TRIGGER statement should have raised an error. -- This message was sent by Atlassian JIRA (v6.1#6144)