Skip to content

Queries on nested properties fail with the LIKE operator #2

Description

@JoeRoddy

BUG

Database: realtime
Data:

users: {
     a: {
          info: {
               email: "[email protected]"
          }
     }
}

the following query works:
select * from users where info.email = "[email protected]";
but this returns no results:
select * from users where info.email LIKE "%@gmail.com";

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions