opteryx
opteryx copied to clipboard
mabel-dev
🦖 A SQL-on-everything Query Engine you can execute over multiple databases and file formats. Query your data, where it lives.
While users are unlikely to run this query - it is possible as part of a more complex query that a null column and a numeric column are combined on.
### Thank you for taking the time to report a problem with Opteryx. _To help us respond to your request, please provide the following details about the bug._ --- **Describe...
Customer has a query which they cannot share. It generally follows this pattern: ~~~sql SELECT CASE WHEN col IS NULL THEN [] ELSE col END as COL FROM table ~~~...
~~~sql SELECT 1, COUNT(*) AS c FROM hits GROUP BY 1 ORDER BY c DESC LIMIT 10; ~~~ returns COUNT(*) as 100, which is the number of files, not the...
Found that - projection pushdown is required - redundant option needed if there's subqueries
Estimating the cost of inStr on blobs and VARCHAR throws an error
### Thank you for taking the time to report a problem with Opteryx. _To help us respond to your request, please provide the following details about the bug._ **Sample Code/Statement**...
### Thank you for taking the time to report a problem with Opteryx. _To help us respond to your request, please provide the following details about the bug._ --- **Describe...
### Thank you for taking the time to report a problem with Opteryx. _To help us respond to your request, please provide the following details about the bug._ --- **Describe...