ClickHouse / ClickHouse/ClickHouse
ODBC engine does not support non-default MSSQL database schema (dbo)
Open
comp-foreign-db
external
unfinished code
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 21h 32m
- Merged PRs (30d)
- 515
Description
### Company or project name
_No response_
### Describe the unexpected behaviour
I have a tables in different schemas in a MSSQL DB. Tables which reside in the default "dbo" schema work ok, but anything in another schema does not.
### How to reproduce
```
SELECT *
FROM odbc(
'DSN=SQLDB',
'DB1',
'test.Table1'
)
```
### Expected behavior
Table data is output
### Error message and/or stacktrace
`Error getting columns from ODBC 'Code: 36. DB::Exception: Table test.Table1 not found. (BAD_ARGUMENTS) (version 25.1.5.31 (official build))`
### Additional context
_No response_
Contributor guide
Assessment
This issue has not been assessed yet.