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)

Most upvoted comments

@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.