Closed exaSR closed 1 year ago
Hello @exaSR @redcatbear and me have the same assumption:
getColumns()
in JDBC driver accepts wildcards and simply returns all matching tables or all columns of all matching tables Proposed change
I will add a test in VSEXA, see https://github.com/exasol/exasol-virtual-schema/issues/94
(again tested using exasol dialect, but is jdbc standard problem)
setup
Bug: Column lookup passes 'HELLO_WORLD' to jdbc's
getColumns()
call, which is interpreted as SQL wildcardreturns
Of course, column
X
is not really there and any access will result in errors.On top of that, neither the VS adapter nor the database backend checks for duplicate column names...