Uploaded image for project: 'Apache MetaModel (Retired)'
  1. Apache MetaModel (Retired)
  2. METAMODEL-1173

unable to select all columns with map used as predicate in where clause

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 5.0.0
    • 5.0.1
    • None
    • linux
    • Important

    Description

      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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            AnandRai AnandRai
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: