Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Catalog is not populated for non MYSQL databases #1461

Open
Lgueg28 opened this issue Jan 21, 2022 · 2 comments
Open

Catalog is not populated for non MYSQL databases #1461

Lgueg28 opened this issue Jan 21, 2022 · 2 comments
Labels

Comments

@Lgueg28
Copy link

Lgueg28 commented Jan 21, 2022

We are trying to connect to Snowflake and the driver expects a catalog to limit the "show /* JDBC:DatabaseMetaData.getColumns() */ columns" command. Since the getColumns command here https://github.com/scalikejdbc/scalikejdbc/blob/master/scalikejdbc-core/src/main/scala/scalikejdbc/DBConnection.scala#L464 doesn't get a catalog here that results in the command running against the entire database. Is there a reason that catalog is not pulled for non MYSQL databases?

@xuwei-k xuwei-k added the core label Jan 26, 2022
@seratch
Copy link
Member

seratch commented Mar 6, 2022

@Lgueg28 The MySQL-specific change was added by #926 . The reason why we don't do the same for other databases is that we haven't received any feedback on the necessity for others.

@pvgoran
Copy link

pvgoran commented Dec 19, 2023

I just run into an issue with PostgreSQL, which is supposedly related to this. Long story short: I have the sequences table, and ScalikeJDBC's generated "select" query for this table includes sequence_catalog, sequence_schema and other columns from the INFORMATION_SCHEMA.sequences table/view.

(Of course, this needs a separate issue, and I'll create it if I can.)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Development

No branches or pull requests

4 participants