search

squirrel-sql-client / squirrel-sql-code

Share of the SQuirreL SQL source code originating from SourceForge, see https://squirrelsql.org
GNU Lesser General Public License v2.1
59 stars 11 forks source link

Does no longer show "Indexes" for h2databases greater then version 2.0 #11

Closed keinhaar closed 1 year ago

keinhaar commented 1 year ago

after switching to h2 database driver 2.0.206 the tab "Indexes" is just empty. The Indexes are shown in the tree view, but only the Inof Tab is filled. No Details, no Source.

gerdwagner commented 1 year ago

Fixed and committed to our GIT repository. Will be available in future snapshots and versions.

Excerpt from change log: H2 DB versions greater than 2.* didn't show indexes in the Object tree's index details tab. The reason was that H2 changed the table type of ordinary tables from "TABLE" from to "BASE TABLE".

keinhaar commented 1 year ago

@gerdwagner I tried the latest snapshot. Sorry, this does not fix the issue for me. The index is shown in the tree, but the "Deatils" and the "Source" Tab are still empty. Also when selecting the Table in the tree, the "Indexes" Tab is still empty.

gerdwagner commented 1 year ago

The index is shown in the tree, but the "Deatils" and the "Source" Tab are still empty.

This concerns the H2 Plugin. In H2 version 2.* the information schema tables were restructured. I think I was able to fix the Plugins access to these tables.

Also when selecting the Table in the tree, the "Indexes" Tab is still empty.

Sorry for the inconvenience. Please give the next snapshot a try.

A snapshot with the fixes is here https://github.com/squirrel-sql-client/squirrel-sql-snapshot-releases/releases/tag/snapshot-20230322_2145

keinhaar commented 1 year ago

Just tried the snapshot from your last comment. Works well now. Thanks for your work!