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

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

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.0.0
    • Fix Version/s: 5.0.1
    • Labels:
      None
    • Environment:
      linux
    • Flags:
      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

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

              Dates

              • Created:
                Updated:
                Resolved: