[ https://issues.apache.org/jira/browse/DERBY-2240?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535313 ]
Laura Stewart commented on DERBY-2240: -------------------------------------- I agree that this should not be VALUES statement. In the documentation we have both "VALUES expression" and "VALUES clause". We should decide if there is a difference between a "VALUES expression" and "VALUES clause" or if just one term should be used. Some examples are: VALUES clause: ref\rrefexcept71493.dita Null is only allowed in a VALUES clause within an INSERT statement. ..VALUES clause must contain at least one element. Empty elements are not allowed. The DEFAULT keyword is only allowed in a VALUES clause when the VALUES clause appears within an INSERT statement. rrefidentityvallocal.dita ...statement using a VALUES clause. ... a VALUES clause on a table containing an identity column. The assigned value... ... a VALUES clause has not been issued for a table containing an identity column. A single row INSERT statement with a VALUES clause for a table without... A multiple row INSERT statement with a VALUES clause rrefscalarsubquery.dita ... using a query which selects from a VALUES clause (which is an ... ref\rrefsqlj35034.dita ...using a query which selects from a VALUES clause (which is an ... VALUES expression: ref\refderby.ditamap rrefsqlj11277.dita" navtitle="VALUES expression" rrefselectexpression.dita href="rrefsqlj11277.dita#rrefsqlj11277">VALUES Expression</xref> ref\rrefsqlj11277.dita ..<title>VALUES expression</title> <keywords><indexterm><VALUES expression></indexterm></keywords> The VALUES expression allows construction of a row or a table ... ... from other values. A VALUES expression can be used in all the places where a ... ... you normally use a VALUES expression when you do not use a ... ref\rrefsqlj19433.dita href="rrefsqlj11277.dita#rrefsqlj11277">VALUES Expression</xref> ref\rrefsqlj21571.dita href="rrefsqlj11277.dita#rrefsqlj11277">VALUES Expression</xref> ... a values expression rrefsqlj40774.dita ... a multiple-row VALUES expression. Single-row and multiple-row lists ... href="rrefsqlj11277.dita#rrefsqlj11277">VALUES Expression</xref> rrefsqlj41360.dita ... construct is SELECT. (Query includes the VALUES expression and UNION, INTERSECT, and EXCEPT ... rreftableexpression.dita When a <xref href="rrefsqlj11277.dita#rrefsqlj11277">VALUES expression</xref> is used as a ... ... the columns of a <xref href="rrefsqlj11277.dita#rrefsqlj11277">VALUES expression</xref> rreftablesubquery.dita ... a subquery (values expression) used as a TableExpression... > "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.