Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Wed, 4 Sep 2013 14:59:51 +0000 (UTC)
From: "Aron Rodrigues (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: <JIRA.12666897.1378306769870.77981.1378306791557@arcas>
In-Reply-To: <JIRA.12666897.1378306769870@arcas>
References: <JIRA.12666897.1378306769870@arcas>
Subject: [jira] [Created] (DERBY-6332) Support SQL92 Interval on 10.9.1
 (ships with glassfish)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Aron Rodrigues created DERBY-6332:
-------------------------------------

             Summary: Support SQL92 Interval on 10.9.1 (ships with glassfish)
                 Key: DERBY-6332
                 URL: https://issues.apache.org/jira/browse/DERBY-6332
             Project: Derby
          Issue Type: Task
          Components: SQL
    Affects Versions: 10.9.1.0
         Environment: javadb shipped with glassfish
            Reporter: Aron Rodrigues


I can't run sql92 queries like

create table c (c datetime);

insert into c values(CURRENT_TIMESTAMP - INTERVAL 2 DAY);

insert into c values(CURRENT_TIMESTAMP - INTERVAL '1' DAY);

insert into c values(CURRENT_TIMESTAMP - INTERVAL '1' HOUR);

insert into c values(CURRENT_TIMESTAMP-INTERVAL '-1' DAY);

select * from c;

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira