User Activity

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 aProduces:|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.7CREATE TABLE test.t (i int);Neither of these state...
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...
I'm using Exasol 7.0.7This query produces an error:SELECT * FROM VALUES (DATE '2017-01-01'), (NULL);The error being:SQL Error [F49E1]: Unallowed type combination in tupel (Session: 1693304236945178624)Other data types seem to be fine, only DATE and T...
This widget could not be displayed.
This widget could not be displayed.