Fully managed cloud. 30-day FREE full featured trial. Start Now
cancel
Showing results for 
Search instead for 
Did you mean: 

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;

 

3 ACCEPTED SOLUTIONS

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

exa-Benjamin
Team Exasol
Team Exasol

Hi Lukas,

We fixed this problem in version 7.1.2.

Best wishes,
Benjamin.

View solution in original post

lukaseder
SQL-Fighter

Thanks a lot for the update!

View solution in original post

3 REPLIES 3

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.

exa-Benjamin
Team Exasol
Team Exasol

Hi Lukas,

We fixed this problem in version 7.1.2.

Best wishes,
Benjamin.

lukaseder
SQL-Fighter

Thanks a lot for the update!