[Flight SQL ODBC] HY010 Function sequence error during schema discovery using ExecuteReader(CommandBehavior.SchemaOnly)

[srinivasan-30]

Describe the bug, including details regarding any error messages, version, and platform.

When using Apache Arrow Flight SQL ODBC Driver against InfluxDB 3, dataset preview succeeds. However schema discovery fails because Bold Reports invokes:

command.ExecuteReader(CommandBehavior.SchemaOnly)

which results in:

HY010 [Apache Arrow][Flight SQL] (100) Function sequence error

Normal ExecuteReader() works successfully.
Does the Metadata retrieval fully supported?
Windows
64 bit driver
Language code: C#
Net core platform

Component(s)

Other, C#

[github-actions]

Thanks for your report! The C# implementation has moved to https://github.com/apache/arrow-dotnet.

This issue has been closed automatically - please open a new issue there.

[amoeba]

Hi @srinivasan-30, the bot automatically closed your issue because you marked C# as the component but this issue looks like a possible bug in the ODBC FlightSQL driver and not with arrow-dotnet. If that's the case, could you fill in more detail in your issue?

• Version of the ODBC FlightSQL driver
• Your dotnet version
• A reproducible code example

cc @alinaliBQ @justing-bq

[srinivasan-30]

Hi @amoeba ,

Please find the details below.

1. Version of the Arrow Flight SQL ODBC driver : 0.9.7.1195
2. Your dotnet version : 10.0
3. Inflex db version : influxdb3-core-3.10.0-windows_amd64

Reproducible Code Example :

We have attached the core sample below. Please modify the connection string for the Arrow Flight SQL ODBC Driver and the corresponding InfluxDB query in the sample and execute.

ConsoleApp.zip

[srinivasan-30]

Hi @amoeba ,

Kindly can you reopen this issue.

[amoeba]

Hi @srinivasan-30, can you put the code here in the issue, in a gist, or in a repo so maintainers don't have to download a zip?

[srinivasan-30]

Hi @amoeba ,

Please find the gist link: https://gist.github.com/srinivasan-30/4b3ee7d6e4bfcece199092009d29fbcc .

Kindly replace the :

1. Update the connection string to use the Apache Arrow Flight SQL ODBC Driver configured in your environment.
2. Replace the sample query with a valid InfluxDB query.
3. Build and run the console application.

Please find the environment details below.

1. Version of the Arrow Flight SQL ODBC driver : 0.9.7.1195
2. Your dotnet version : 10.0
3. Inflex db version : influxdb3-core-3.10.0-windows_amd64

[amoeba]

Hi @srinivasan-30, based on your driver version, it looks like you're using the Dremio version of the driver and not the one developed in the Arrow project. Can you try with https://github.com/apache/arrow/releases/download/apache-arrow-25.0.0/Apache-Arrow-Flight-SQL-ODBC-25.0.0-win64.msi? (You may have to work around Windows Defender to get the driver to load).

[amoeba]

I seem to be able to reproduce the issue on Windows but not on macOS with the Apache driver so that must be a place where the driver managers differ between platforms.

[srinivasan-30]

Hi @amoeba ,

We have installed the provided driver, but we are still facing the same error: HY010 [Apache Arrow][Flight SQL] (100) Function sequence error.

[alinaliBQ]

Does the Metadata retrieval fully supported?

hi @srinivasan-30 the Apache driver hasn't been tested with metadata retrieval from C#, so there is a possibility that it is not fully supported. I agree with @amoeba that this might be caused by a driver manager difference between platforms, as macOS (iODBC) and Windows ODBC driver managers may have different sequence of ODBC API calls to the Apache driver.

In case it might help, there are 2 possible places where the HY010 error could have been thrown:

1. SQLMoreResults is a no-op and errors on HY010 if there is no open cursor.
   

   arrow/cpp/src/arrow/flight/sql/odbc/odbc_impl/odbc_statement.cc

   Line 790 in deed9c0

   throw DriverException("Function sequence error", "HY010");

2. SQLExecute errors on HY010 if SQLPrepare hasn't been called first. The chance of driver manager not calling SQLPrepare first is small.
   

   arrow/cpp/src/arrow/flight/sql/odbc/odbc_impl/odbc_statement.cc

   Line 302 in deed9c0

   throw DriverException("Function sequence error", "HY010");

[amoeba]

I reproduced this on my Windows machine and, with ODBC tracing turned on, I get,

...snip...
OdbcRepro       599c-368	ENTER SQLMoreResults 
		HSTMT               0x00000279C6A8E8E0

OdbcRepro       599c-368	EXIT  SQLMoreResults  with return code -1 (SQL_ERROR)
		HSTMT               0x00000279C6A8E8E0

		DIAG [HY010] [Apache Arrow][Flight SQL] (100) Function sequence error (100) 

So it looks like the call triggering the exception is SQLMoreResults.

I'm new to this stuff so I had an LLM take a look and it pulled up https://learn.microsoft.com/en-us/sql/odbc/reference/appendixes/statement-transitions?view=sql-server-ver17#sqlmoreresults as a reference. From my reading of that, the Statement in this case is probably in the prepared state and so should always return SQL_NO_DATA. Should the implementation just always return SQL_NO_DATA since the driver doesn't support it?