db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2261) Questionable use of word "statement" in VALUES expression of Derby Reference Manual should be changed to "clause"
Date Wed, 14 Mar 2007 21:15:09 GMT

    [ 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.


Mime
View raw message