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/20 03:22:30 UTC
[jira] Created: (DERBY-2261) Questionable use of word "expression"
in VALUES expression of Derby Reference Manual should be changed to
"clause"
Questionable use of word "expression" 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
"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/%3c45ADFEDB.3070408@basil.ocn.ne.jp%3e
--
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] Resolved: (DERBY-2261) Questionable use of word "statement"
in VALUES expression of Derby Reference Manual should be changed to
"clause"
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tomohito Nakayama resolved DERBY-2261.
--------------------------------------
Resolution: Fixed
> 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
> Attachments: DERBY-2261.diff, rrefsqlj11277.html
>
>
> "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/%3c45ADFEDB.3070408@basil.ocn.ne.jp%3e
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2261) Questionable use of word "statement"
in VALUES expression of Derby Reference Manual should be changed to
"clause"
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-2261:
-----------------------------
Attachment: rrefsqlj11277.html
DERBY-2261.diff
Thanks very much. The information about being able to use a VALUES expression as a statement is in the topic, but is not as easy to find as it should be.
I'm attaching a patch to rrefsqlj11277.dita that does the following:
1) Removes the incorrect statement about the FROM clause
2) Moves the information about the uses of the VALUES expression into a bullet list so it is easier to see
3) Removes the incorrect vertical bar
Please let me know if further corrections are needed.
> 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
> Attachments: DERBY-2261.diff, rrefsqlj11277.html
>
>
> "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/%3c45ADFEDB.3070408@basil.ocn.ne.jp%3e
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2261) Questionable use of word "statement"
in VALUES expression of Derby Reference Manual should be changed to
"clause"
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tomohito Nakayama updated DERBY-2261:
-------------------------------------
Summary: Questionable use of word "statement" in VALUES expression of Derby Reference Manual should be changed to "clause" (was: Questionable use of word "expression" in VALUES expression of Derby Reference Manual should be changed to "clause")
Ooops ...
The current word is not expression but statement ....
> 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
>
> "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/%3c45ADFEDB.3070408@basil.ocn.ne.jp%3e
--
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-2261) Questionable use of word "statement"
in VALUES expression of Derby Reference Manual should be changed to
"clause"
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2261?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12481133 ]
Tomohito Nakayama commented on DERBY-2261:
------------------------------------------
Reading Kim's comment, I found that those three word, expression, sentence, construct, refer different concept and wording itself is correct.
However I think just wording is not sufficient to describe different concepts in this page.
I think some kind of structure in article is prefered than wording ....
> 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/%3c45ADFEDB.3070408@basil.ocn.ne.jp%3e
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2261) Questionable use of word "statement"
in VALUES expression of Derby Reference Manual should be changed to
"clause"
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2261?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12481197 ]
Tomohito Nakayama commented on DERBY-2261:
------------------------------------------
I think examples in VALUES expression page shows that we can call it statement .....
-- 3 rows of 1 column
VALUES (1),(2),(3)
-- 3 rows of 1 column
VALUES 1, 2, 3
-- 1 row of 3 columns
VALUES (1, 2, 3)
-- using a built-in function
VALUES CURRENT_DATE
-- getting the value of an arbitrary expression
VALUES (3*29, 26.0E0/3)
-- getting a value returned by a built-in function
values char(1)
Now I understood that there exists both of VALUES expression and VALUES statement.
Then I think wording itself is not problem.
// Sorry that my opinion is different from first one ....
However, I think information for VALUES statement is placed too suddenly in context of VALUES expression page.
Because VALUES statement is not so familiar with many reader, I think some of care is needed.
> 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/%3c45ADFEDB.3070408@basil.ocn.ne.jp%3e
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2261) Questionable use of word "statement"
in VALUES expression of Derby Reference Manual should be changed to
"clause"
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2261?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12482693 ]
Tomohito Nakayama commented on DERBY-2261:
------------------------------------------
I committed.
Sending src/ref/rrefsqlj11277.dita
Transmitting file data .
Committed revision 520822.
> 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
> Attachments: DERBY-2261.diff, rrefsqlj11277.html
>
>
> "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/%3c45ADFEDB.3070408@basil.ocn.ne.jp%3e
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2261) Questionable use of word "statement"
in VALUES expression of Derby Reference Manual should be changed to
"clause"
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2261?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12482458 ]
Kim Haase commented on DERBY-2261:
----------------------------------
Thank you very much. I guess this is ready to commit, then.
svn stat src/ref/rrefsqlj11277.dita
M src/ref/rrefsqlj11277.dita
> 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
> Attachments: DERBY-2261.diff, rrefsqlj11277.html
>
>
> "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/%3c45ADFEDB.3070408@basil.ocn.ne.jp%3e
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2261) Questionable use of word "statement"
in VALUES expression of Derby Reference Manual should be changed to
"clause"
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2261?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12481335 ]
Kim Haase commented on DERBY-2261:
----------------------------------
Thanks. I think what we're learning is that VALUES can be either a standalone statement or a clause within a statement -- sort of like SELECT, which is actually documented as both a statement and an expression. Maybe the topic should state this explicitly?
It may be that VALUES is called an "expression" precisely because it has this flexibility of being either a statement or a clause. So maybe it would make sense to stick with "VALUES expression". (Making an extra topic called "VALUES statement" would be overkill in this case; the "SELECT statement" and "SelectExpression" topics are quite different, but there's a lot less to say about VALUES and having two topics seems unnecessary.)
What really confuses me is the whole second sentence: "You use a VALUES [whatever] when you do not have a FROM clause." A FROM clause is required in a SelectExpression but occurs nowhere else. So there is no chance of replacing a FROM clause with a VALUES expression, is there? However, an INSERT statement usually consists of either a VALUES expression or a SelectExpression. So might it be more accurate to say, "In an INSERT statement, you normally use a VALUES expression when you do not use a SelectExpression." ? Or is there something I'm not understanding? I'm not a SQL expert.
Thanks for the clarification that it's okay to drop the second vertical bar in the syntax.
> 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/%3c45ADFEDB.3070408@basil.ocn.ne.jp%3e
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2261) Questionable use of word "statement"
in VALUES expression of Derby Reference Manual should be changed to
"clause"
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2261?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12481134 ]
Tomohito Nakayama commented on DERBY-2261:
------------------------------------------
By the way, I think VALUES expression can't be empty string.
Then I think last vertical bar is mistaken.
> 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/%3c45ADFEDB.3070408@basil.ocn.ne.jp%3e
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (DERBY-2261) Questionable use of word "statement"
in VALUES expression of Derby Reference Manual should be changed to
"clause"
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase reassigned DERBY-2261:
--------------------------------
Assignee: Kim Haase
> 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/%3c45ADFEDB.3070408@basil.ocn.ne.jp%3e
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2261) Questionable use of word "statement"
in VALUES expression of Derby Reference Manual should be changed to
"clause"
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2261?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12481918 ]
Tomohito Nakayama commented on DERBY-2261:
------------------------------------------
I think the topic for VALUES expression should explicitly state that VALUES expression can construct VALUES statement.
In my experience, VALUES statement has not been used in many cases,
then it should be described in manual of Derby explicitly to inform user.
// I think support for VALUES statement is proof for flexibility of SQL grammer in Derby.
I think reference for FROM clause in the topic is not appropriate now.
Explicit reference for select statement would be needed for reference for FROM clause, because VALUES statement is not SELECT statement, I think.
> 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/%3c45ADFEDB.3070408@basil.ocn.ne.jp%3e
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2261) Questionable use of word "statement"
in VALUES expression of Derby Reference Manual should be changed to
"clause"
Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2261?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12481189 ]
Laura Stewart commented on DERBY-2261:
--------------------------------------
I agree that it should be called only one thing. My vote is for clause.
In my research, VALUES is a form of a query, that takes "expressions" as it's arguments. The typical SQL syntax is:
VALUES ( expression [, ...] ) [, ...]
Syntactically, VALUES followed by a list of expression is treated as equivalent to
SELECT select_list FROM table_expression
VALUES is most commonly used as the data source in an INSERT statement, and next most commonly as a subquery.
So, to me, it is a SQL clause, not an expression. "Construct" seems vague to me.
Also for me, because VALUES is used within INSERT or as a subquery (and not as a stand alone statement), I would not call it a statement.
If I can go to a command prompt and type VALUES (without it being side another statement) and have data returned, then we should call it a statement.
> 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/%3c45ADFEDB.3070408@basil.ocn.ne.jp%3e
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2261) Questionable use of word "statement"
in VALUES expression of Derby Reference Manual should be changed to
"clause"
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-2261:
-----------------------------
Derby Info: [Patch Available]
> 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
> Attachments: DERBY-2261.diff, rrefsqlj11277.html
>
>
> "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/%3c45ADFEDB.3070408@basil.ocn.ne.jp%3e
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2261) Questionable use of word "statement"
in VALUES expression of Derby Reference Manual should be changed to
"clause"
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ 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/%3c45ADFEDB.3070408@basil.ocn.ne.jp%3e
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2261) Questionable use of word "statement"
in VALUES expression of Derby Reference Manual should be changed to
"clause"
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2261?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12482404 ]
Tomohito Nakayama commented on DERBY-2261:
------------------------------------------
+1
> 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
> Attachments: DERBY-2261.diff, rrefsqlj11277.html
>
>
> "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/%3c45ADFEDB.3070408@basil.ocn.ne.jp%3e
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.