QGIS » QGIS Application

Hello,

when you load an Oracle table with comments, the following query is made:
SELECT column_name,comments FROM all_col_comments t WHERE t.owner='USER' AND t.table_name='TABLE' AND t.column_name<>"COLUMN_NAME";

It does work for geographic tables because the "COLUMN_NAME" is the name of the geometry table.
But for non-geographic table, "COLUMN_NAME" is NULL and the query becomes:
SELECT column_name,comments FROM all_col_comments t WHERE t.owner='USER' AND t.table_name='TABLE' AND t.column_name<>NULL;

Which doesn't work (returns an empty query). Oracle (at least since 10g) can't use '<>' operator for NULL values (I know, it's painful but this is Oracle...). You have to use 'IS NOT NULL' instead.

No urge on this bug... Just a reminder !