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-2261) Questionable use of word "statement" in VALUES expression of Derby Reference Manual should be changed to "clause"
Date Thu, 15 Mar 2007 21:57:09 GMT

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

View raw message