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)