duckdb: ODBC-client: "Select 42" is not working
When I’m testing an ODBC-client with SQL-command “SELECT 42” It isn’t working. Prepare, Execute and Describe are working but Fetch isn’t. I will get the following error message:
[ODBC][20419][1626450456.653113][SQLSetStmtAttr.c][265]
Entry:
Statement = 0x556143962660
Attribute = SQL_ATTR_ROW_BIND_TYPE
Value = (nil)
StrLen = 0
[ODBC][20419][1626450456.653130][SQLSetStmtAttr.c][928]
Exit:[SQL_ERROR]
And the same is happening if I try to create a table. An execution is working and table is created, but Fetching fails.
And my setup is working with Clickhouse. I’m using unixODBC-2.3.9 with Kubuntu 21.04.
Describe for Clickhouse for Select 42 gives
s1 3 3 0 1 Select 42 50 ¯314238752 Select 42 42 4 0 0 ¯6 0 ¯6 3 0 0
And the same for DuckDB is
s1 3 3 0 1 Select 42 50 ¯314068800 Select 42 42 4 0 0 4 0 4 0 0 0
About this issue
- Original URL
- State: closed
- Created 3 years ago
- Comments: 26 (26 by maintainers)
@kimmolinna I reproduced that issue and tried to fix, but it worked partially only on select statements. I am finishing another feature, and then I will return to the SQLRowCount.