ClickHouse / ClickHouse/ClickHouse

ODBC engine does not support non-default MSSQL database schema (dbo)

Open
#97,216 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.