[
https://issues.apache.org/jira/browse/DERBY-6983?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16381450#comment-16381450
]
Rick Hillegas commented on DERBY-6983:
--------------------------------------
Hi Lukas,
I hope we're not talking past one another.
1) I did not mean to cause offense by lecturing you about which asterisk was
the problem. That comment was not directed at you. It was a note to the
contributor (whoever that is) who ends up addressing this issue. I was hoping
to help that person understand the issue faster.
2) I'm sorry if the meaning of "deviation from the Standard" was confusing. It
is meant to indicate that Derby is violating the Standard by not accepting the
asterisk in the subquery. Do you disagree?
Thanks,
-Rick
> Support SELECT * for IN predicate subqueries when it is "obvious" that the
> asterisk expands to exactly one column
> -----------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-6983
> URL: https://issues.apache.org/jira/browse/DERBY-6983
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 10.14.1.0
> Reporter: Lukas Eder
> Priority: Major
>
> The following query is not allowed in Derby:
> {code:java}
> SELECT *
> FROM sys.systables
> WHERE tablename IN (
> SELECT *
> FROM (
> SELECT 'SYSTABLES' t
> FROM sysibm.sysdummy1
> ) t
> ){code}
> The error I'm getting is:
> {code:java}
> 'SELECT *' only allowed in EXISTS and NOT EXISTS subqueries.{code}
> In this case, it is "obvious" that the asterisk (also a qualified asterisk:
> t.*) expands to exactly one column and the query should be perfectly fine.
> I'm not aware of any other databases with such a restriction.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
