-
Notifications
You must be signed in to change notification settings - Fork 558
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
Not all data sources are found #1000
Comments
See also: #998 |
We should enumerate since other database adapters support this.
I think data_sources should return names with schema, so that it will be possible to differentiate same table names with different schemas. |
Is there an SQL Server equivalent to PostgreSQL's |
Something like this should work ANY(SELECT DISTINCT TABLE_SCHEMA from INFORMATION_SCHEMA.TABLES) |
Hi @DCrow assign this task to me. |
Issue
When using a database with multiple schemas, not all tables are found for method
It seems to stem from this line.
When
ActiveRecord::Base.connection.data_source_sql
is called, it's called without any parameters and because of thatquoted_scope
(inside that method) always returnsdbo
.Maybe this adapter should search all schemas like postgres adapter not just
dbo
?Expected behavior
I'm expecting that all tables with different schemas are found.
Actual behavior
Tables with schemas other than
dbo
are not found.How to reproduce
See example
Details
6.0.4.4
6.0.4.4
2.1.5
The text was updated successfully, but these errors were encountered: