[jira] Commented: (DERBY-2240) "VALUES expression" is written "VALUES statement" in SelectExpression page of Derby Reference Manual

["Laura Stewart (JIRA)" <ji...@apache.org>]

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