[
https://issues.apache.org/jira/browse/IGNITE-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vladimir Ozerov closed IGNITE-2641.
-----------------------------------
> Improve usability of "SELECT *" SqlQuery.
> -----------------------------------------
>
> Key: IGNITE-2641
> URL: https://issues.apache.org/jira/browse/IGNITE-2641
> Project: Ignite
> Issue Type: Task
> Components: cache
> Affects Versions: 1.5.0.final
> Reporter: Vladimir Ozerov
> Assignee: Vladimir Ozerov
> Labels: important
> Fix For: 1.6
>
>
> *Case 1*:
> {code}SELECT * FROM Employee e{code}
> Result: exception:
> Reason: query is expanded to
> {code}SELECT Employee._key, Employee._val FROM EMPLOYEE e{code}
> instead of
> {code}SELECT e._key, e._val FROM EMPLOYEE e{code}
> *Case 2*
> {code}SELECT e.* FROM Employee e{code}
> Result: exception
> Reason: hard-coded check in IgniteH2Indexing.generateQuery():
> {code}
> if (!qry.startsWith("*"))
> throw new IgniteCheckedException(...);
> {code}
> *Proposed solution*
> Instead of checking for asteriks, we must also check for "[table/alias].*"
> pattern.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
