[
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/[EMAIL
> PROTECTED]
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
