User Activity

I'm using Exasol 7.1.8 on Windows with Docker:docker pull exasol/docker-db docker run --name EXASOL -p 127.0.0.1:9563:8563 --detach --privileged --stop-timeout 120 exasol/docker-db:latestUsing this schema: create table t (i int, j int); insert into t...
Here's a fun bug: I'm using Exasol 7.0.9: create table t (i int primary key); insert into t values (1),(2),(3),(4); select t.i from t where ( t.i between 2 and 3 and t.i between symmetric 2 and 3 and t.i between symmetric 3 and 2 ) order by t.i; This...
I'm using Exasol 7.0.9. The following query: select a, first_value(a) over (), last_value(a) over () from (values(1), (2), (3), (4)) as t(a) order by a Produces: |A |FIRST_VALUE(T.A) OVER()|LAST_VALUE(T.A) OVER()| |---|-----------------------|-------...
This is probably a bit of an edge case that does not arise as often in "ordinary SQL", but I still haven't found many other RDBMS that have this limitation, so I'll report this anyway. On Exasol 7.0.7 CREATE TABLE test.t (i int); Neither of these sta...
I'm using Exasol 7.0.7. The problem can be reproduced as follows:CREATE TABLE t (i int); CREATE TABLE u (i int); INSERT INTO t VALUES (1); INSERT INTO u VALUES (1); SELECT i FROM t WHERE 0 = ( SELECT count(*) FROM u WHERE t.i = u.i AND FALSE )The que...
This widget could not be displayed.
This widget could not be displayed.