Skip to content

Queries on nested properties fail with the LIKE operator #2

@JoeRoddy

Description

@JoeRoddy

BUG

Database: realtime
Data:

users: {
     a: {
          info: {
               email: "myemail@gmail.com"
          }
     }
}

the following query works:
select * from users where info.email = "myemail@gmail.com";
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