db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2240) "VALUES expression" is written "VALUES statement" in SelectExpression page of Derby Reference Manual
Date Thu, 18 Oct 2007 17:36:51 GMT

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

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.

View raw message