[
https://issues.apache.org/jira/browse/DERBY-6353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13778602#comment-13778602
]
Knut Anders Hatlen commented on DERBY-6353:
-------------------------------------------
I think the "special meaning" of the asterisk is in queries such as
- {{select * from t}}
- {{select t1.* from t1 natural join t2}}
- {{select count(\*) from t}}
See syntax for SelectItem here:
http://db.apache.org/derby/docs/10.10/ref/rrefselectexpression.html
And the COUNT(\*) function here:
http://db.apache.org/derby/docs/10.10/ref/rrefsqlj66113.html
> Update syntax description in Getting Started, use in Reference Manual too
> -------------------------------------------------------------------------
>
> Key: DERBY-6353
> URL: https://issues.apache.org/jira/browse/DERBY-6353
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.10.1.1
> Reporter: Kim Haase
> Assignee: Kim Haase
> Priority: Minor
>
> The "SQL Syntax" topic in the Getting Started guide
> (http://db.apache.org/derby/docs/10.10/getstart/rgsdocs10012.html) does not
> describe the curly braces ("{ }") as they are actually used in syntax
> statements, where they actually group required items, normally so choices can
> be separated by vertical bars ("|"). This should be corrected.
> I also plan to adopt the suggestion made in DERBY-6121 that the topic be
> added to the Reference Manual, where syntax is most used.
> Does anything else in the topic need fixing? I am confused by the statement
> that the asterisk "has a special meaning in some SQL statements." What
> special meaning can it have other than marking repeatable items?
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
