You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Tomohito Nakayama (JIRA)" <ji...@apache.org> on 2007/01/13 12:17:27 UTC
[jira] Created: (DERBY-2240) "VALUES expression" is written
"VALUES statement" in SelectExpression page of Derby Reference Manual
"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.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-2240) "VALUES expression" is written
"VALUES statement" in SelectExpression page of Derby Reference Manual
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2240?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12540747 ]
Tomohito Nakayama commented on DERBY-2240:
------------------------------------------
Committed.
Sending src/ref/rrefselectexpression.dita
Transmitting file data .
Committed revision 592751.
> "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
> Assignee: Kim Haase
> Attachments: DERBY-2240.diff, rrefselectexpression.html
>
>
> 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.
[jira] Commented: (DERBY-2240) "VALUES expression" is written
"VALUES statement" in SelectExpression page of Derby Reference Manual
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2240?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535895 ]
Tomohito Nakayama commented on DERBY-2240:
------------------------------------------
I remember the discussion started from next message.
http://mail-archives.apache.org/mod_mbox/db-derby-dev/200701.mbox/%3c45A91844.6050708@basil.ocn.ne.jp%3e
http://mail-archives.apache.org/mod_mbox/db-derby-dev/200701.mbox/thread?6
My conclusion was that the appropriate word would depend on context.
> "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.
[jira] Commented: (DERBY-2240) "VALUES expression" is written
"VALUES statement" in SelectExpression page of Derby Reference Manual
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2240?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535549 ]
Tomohito Nakayama commented on DERBY-2240:
------------------------------------------
We have "VALUES expression" page in reference manual. (http://db.apache.org/derby/docs/dev/ref/rrefsqlj11277.html)
I think this word is moderate.
> "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.
[jira] Updated: (DERBY-2240) "VALUES expression" is written
"VALUES statement" in SelectExpression page of Derby Reference Manual
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-2240:
-----------------------------
Attachment: rrefselectexpression.html
DERBY-2240.diff
Since the suggested fix seems to be the way to go, I've attached DERBY-2240.diff and the corrected rrefselectexpression.html file. Please let me know if further changes are necessary.
> "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
> Assignee: Kim Haase
> Attachments: DERBY-2240.diff, rrefselectexpression.html
>
>
> 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.
[jira] Commented: (DERBY-2240) "VALUES expression" is written
"VALUES statement" in SelectExpression page of Derby Reference Manual
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2240?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12540759 ]
Kim Haase commented on DERBY-2240:
----------------------------------
Thanks very much!
> "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
> Assignee: Kim Haase
> Attachments: DERBY-2240.diff, rrefselectexpression.html
>
>
> 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.
[jira] Assigned: (DERBY-2240) "VALUES expression" is written
"VALUES statement" in SelectExpression page of Derby Reference Manual
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase reassigned DERBY-2240:
--------------------------------
Assignee: Kim Haase
> "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
> Assignee: Kim Haase
>
> 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.
[jira] Commented: (DERBY-2240) "VALUES expression" is written
"VALUES statement" in SelectExpression page of Derby Reference Manual
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (DERBY-2240) "VALUES expression" is written
"VALUES statement" in SelectExpression page of Derby Reference Manual
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2240?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12540031 ]
Tomohito Nakayama commented on DERBY-2240:
------------------------------------------
I think this patch is OK.
If there comes no objection, I will commit the patch.
> "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
> Assignee: Kim Haase
> Attachments: DERBY-2240.diff, rrefselectexpression.html
>
>
> 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.
[jira] Commented: (DERBY-2240) "VALUES expression" is written
"VALUES statement" in SelectExpression page of Derby Reference Manual
Posted by "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.
[jira] Closed: (DERBY-2240) "VALUES expression" is written "VALUES
statement" in SelectExpression page of Derby Reference Manual
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase closed DERBY-2240.
----------------------------
Closing, since this was fixed a year ago.
> "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
> Assignee: Kim Haase
> Fix For: 10.4.1.3
>
> Attachments: DERBY-2240.diff, rrefselectexpression.html
>
>
> 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.
[jira] Commented: (DERBY-2240) "VALUES expression" is written
"VALUES statement" in SelectExpression page of Derby Reference Manual
Posted by "Daniel John Debrunner (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2240?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535603 ]
Daniel John Debrunner commented on DERBY-2240:
----------------------------------------------
The SQL standard name for this use of VALUES is <table value constructor>
Note that Derby does have a VALUES statement, e.g. VALUES 1,2,3
> "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.
[jira] Resolved: (DERBY-2240) "VALUES expression" is written
"VALUES statement" in SelectExpression page of Derby Reference Manual
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase resolved DERBY-2240.
------------------------------
Resolution: Fixed
Fix Version/s: 10.4.0.0
I believe this can be marked resolved, since the fix was committed to the trunk last week.
> "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
> Assignee: Kim Haase
> Fix For: 10.4.0.0
>
> Attachments: DERBY-2240.diff, rrefselectexpression.html
>
>
> 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.