Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <31955584.1173906909790.JavaMail.jira@brutus>
Date: Wed, 14 Mar 2007 14:15:09 -0700 (PDT)
From: "Kim Haase (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-2261) Questionable use of word "statement"
 in VALUES expression of Derby Reference Manual should be changed to
 "clause"
In-Reply-To: <27372349.1169259750095.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-2261?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12480934 ] 

Kim Haase commented on DERBY-2261:
----------------------------------

Currently it's called "VALUES expression" in the first sentence, "VALUES statement" in the second sentence, and "construct" in the third sentence:

"The VALUES expression allows construction of a row or a table from other values. You use a VALUES statement when you do not have a FROM clause. This construct can be used in all the places where a query can ..."

It would probably be better to call it no more than two different things, rather than three; if it were really a clause we'd have to move it from the "SQL expressions" section to the "SQL clauses" section. 

According to Bernt, the SQL standard calls it a "<table value constructor>". So it would probably be all right to call it either an "expression" or a "construct" --

"The VALUES expression allows construction of a row or a table from other values. You use a VALUES expression when you do not have a FROM clause. This construct can be used in all the places where a query can ..."

"The VALUES expression allows construction of a row or a table from other values. You use a VALUES construct when you do not have a FROM clause. This construct can be used in all the places where a query can ..."

By the way, is there a typo in the syntax also? Note the vertical bar just before the closing brace:

{
    VALUES ( Value {, Value }* )
        [ , ( Value {, Value }* ) ]* |
    VALUES Value [ , Value ]* |
 }

Since the vertical bar means "or" and there's nothing on the other side, shouldn't it be removed?


> Questionable use of word "statement" in VALUES expression of Derby Reference Manual should be changed to "clause"
> -----------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2261
>                 URL: https://issues.apache.org/jira/browse/DERBY-2261
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>         Environment: http://db.apache.org/derby/docs/dev/ref/rrefsqlj11277.html
>            Reporter: Tomohito Nakayama
>         Assigned To: Kim Haase
>
> "VALUES statement" in next one sentence in "VALUES expression" of Derby Reference manual should be changed to "VALUES clause".
> >You use a VALUES statement when you do not have a FROM clause.
> http://mail-archives.apache.org/mod_mbox/db-derby-dev/200701.mbox/%3c45ADFEDB.3070408@basil.ocn.ne.jp%3e

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.