[
https://issues.apache.org/jira/browse/DERBY-2240?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535989
]
Kim Haase commented on DERBY-2240:
----------------------------------
I think it's true that it depends on context -- as the main topic
(ref\rrefsqlj11277.dita) says,
A VALUES expression can be used in all the places where a query can, and thus
can be used in any of the following ways:
* As a statement that returns a ResultSet
* Within expressions and statements wherever subqueries are permitted
* As the source of values for an INSERT statement (in an INSERT statement,
you normally use a VALUES expression when you do not use a SelectExpression)
So "statement", "clause", and "expression" can all be correct -- though it is
true that in the sentence cited in this issue, "statement" is incorrect. I
think either "clause" or "expression" would be correct, and since the contrast
here is with a SelectExpression, probably "expression" would be best.
I think "expression" is the most general term, and "clause" is normally used
for a VALUES expression that doesn't stand alone, while "statement" is used for
one that does. But I'm open to correction on this, since I don't know how SQL
defines these terms (if it does).
I notice that the error messages table at one point (42X59) refers to a "VALUES
constructor," using the SQL standard term. Elsewhere this table is consistent
in using "VALUES clause."
> "VALUES expression" is written "VALUES statement" in SelectExpression page
> of Derby Reference Manual
> -----------------------------------------------------------------------------------------------------
>
> Key: DERBY-2240
> URL: https://issues.apache.org/jira/browse/DERBY-2240
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment:
> http://db.apache.org/derby/docs/dev/ref/rrefselectexpression.html
> Reporter: Tomohito Nakayama
>
> Next description ....
> When a query does not have a FROM clause (when you are constructing a value,
> not getting data out of a table), you use a VALUES statement, not a
> SelectExpression.
> I think VALUES statement is not correct .
> It must be VALUES expression.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
