stefanos mavros
stefanos mavros
On latest 'geo-update' branch (hg id: f73972d12bf5) given a table ``` CREATE TABLE "sys"."test" ( "id" INTEGER, "g" GEOMETRY ); ``` the query ``` create table test2 as select id,...
*Non SQL standard* To compare two datatypes treating at the same time `NULL` as a comparable value some databases implement the `IS [NOT] DISTINCT FROM`. This means that any not-null...
*Non SQL standard* Ops like `INSERT`, `UPDATE` and `DELETE` could return the same number of rows as the ones affected so a second `SELECT` query is not needed. It is...
the query ```sql select * from f where f.c in (select b.c from b); ``` translates to a SEMIJOIN operator between tables `f`(left) and `b` (right) ``` project ( |...
the GROUP BY common sub-expression elimination (CSE) optimizer is not acting upon ``` select f.n, b.n from f join b on f.n = b.n group by f.n, b.n; ``` the...
in case that two tables are having a double alias the NATURAL JOIN seems to not eliminating the common columns e.g. ``` select * from (select n n1, n n2,...
## Errors - [ ] `JSONTest` issue #52, 87 failures due to lack of dialect support for JSON type - [ ] `IdentityColumnTest` the errors comes from the fact that...
### Describe the bug when an outer-join relational operator is processed by `rel_out2inner()` opt any column expression in the expression subtree of a wrapping select must be searched in the...
### Describe the bug Create a table with a single decimal type column and some data **just** below the decimal type limit ```sql CREATE TABLE IF NOT EXISTS foo (n...
When connection to the monetdb server is lost both Connection and Cursor creation raise builtin exceptions instead of DBAPI ones ## `connect()` example ```py # monetdb server is NOT running...