SurrealDB Stream #22: 1.4.0 Improved Table & Graph Schemas
Vložit
- čas přidán 24. 08. 2024
- Join co-founder Tobie Morgan Hitchcock, Senior Software Engineer Emmanuel Keller and Engineering Intern Raphael Darley as we dive into Improved Table & Graph Schemas. Ask questions, leave comments, and get involved.
🔍 Focus:
- Improvements to table and graph relation schemas, including stricter enforcement of table type and ergonomic graph edge definition
- Optimisations to database performance; unveiling query execution plans, index impact analysis and execution plan influence strategies
@10:35 I think the boolean logic in your query planner is broken.
When he added `AND < 2018`, I don't think the query should have changed because AND < 2015 is more restrictive/a subset of < 2018.
Likewise, when AND > 2012 was added, the planner didn't change - it remained looking for >=2010
If the query is `>= 2010 AND > 2012 AND < 2015 AND < 2018`, it should be searching and returning > 2012 and < 2015.
Or am I the one missing something fundamental?
Thanks for flagging. This is a known bug that’s in the process of being resolved.