sqlite-jdbc icon indicating copy to clipboard operation
sqlite-jdbc copied to clipboard

JDBC3DatabaseMetaData.getColumns seems to ignore schema when issuing "PRAGMA table_info" command

Open AshwinJay opened this issue 6 years ago • 2 comments

It looks like the table_info command that is issued in the getColumns call is ignoring the Schema name.

It should've been PRAGMA schema.table_info(table-name) instead of PRAGMA table_info(table-name);

Ref:

  • https://github.com/xerial/sqlite-jdbc/blob/master/src/main/java/org/sqlite/jdbc3/JDBC3DatabaseMetaData.java#L1239
  • https://www.sqlite.org/pragma.html#pragma_table_info

AshwinJay avatar Aug 23 '19 16:08 AshwinJay

~~Is this still happening on the latest version?~~

gotson avatar Jul 28 '22 08:07 gotson

Do you have any issue stemming from that, and if yes could you provide some details ?

gotson avatar Sep 13 '22 09:09 gotson