Unable to fully qualify column references when table has not been fully qualified

lukaseder
SQL-Fighter

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 statements work:

UPDATE t
SET test.t.i = 1
WHERE 1 = 1;

SELECT test.t.i
FROM t;

There seems to be a requirement for the table to be declared as a fully qualified table, despite this not being strictly necessary (in my opinion). Of course, the full column qualification is also not necessary in this case.

These work as expected:

UPDATE test.t
SET test.t.i = 1
WHERE 1 = 1;

SELECT test.t.i
FROM test.t;
1 ACCEPTED SOLUTION

Accepted Solutions

exa-Benjamin
Team Exasol
Team Exasol

Hi Lukas,

Thank you for reporting this bug.  The R&D team will investigate and keep you posted with any news.

Best wishes,
Benjamin.

View solution in original post

1 REPLY 1

exa-Benjamin
Team Exasol
Team Exasol

Hi Lukas,

Thank you for reporting this bug.  The R&D team will investigate and keep you posted with any news.

Best wishes,
Benjamin.

View solution in original post