You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@metamodel.apache.org by "Kasper Sørensen (JIRA)" <ji...@apache.org> on 2017/12/10 06:35:00 UTC
[jira] [Resolved] (METAMODEL-1173) unable to select all columns
with map used as predicate in where clause
[ https://issues.apache.org/jira/browse/METAMODEL-1173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kasper Sørensen resolved METAMODEL-1173.
----------------------------------------
Resolution: Fixed
> unable to select all columns with map used as predicate in where clause
> -----------------------------------------------------------------------
>
> Key: METAMODEL-1173
> URL: https://issues.apache.org/jira/browse/METAMODEL-1173
> Project: Apache MetaModel
> Issue Type: Bug
> Affects Versions: 5.0.0
> Environment: linux
> Reporter: AnandRai
> Fix For: 5.0.1
>
>
> Given table with column name address of type map with key {Building,street, zipcode}
> Now if I search through this table like
> select * from restaurants where address.building='49'
> it gives no result
>
> however if I use query
> select _id,borough,address.building from restaurants where address.building='49'
> it produces result.
>
> Seems like it works only if item in where clause(address.building) is present in select item list.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)