firebase-sql
firebase-sql copied to clipboard
JoeRoddy
Queries on nested properties fail with the LIKE operator
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";
Lots of operators on nested props broken:
select * from users where info.email != null;
select * from users where info.height > 10;
^Return every record