ClickHouse / ClickHouse/clickhouse-odbc
API sqlcancel is not supported
- Dominant language
- C
- Stars
- 285
- Forks
- 105
- Avg merge
- 3h 56m
- Merged PRs (30d)
- 3
Description
To kill a slow query through the ODBC interface, we can normally use "sqlcancel". However, "clickhouse-odbc" does not implement this function, and there will be no response after calling this interface. Therefore, the only way to kill the slow query is through "kill query" in "clickhouse-server". the mysql odbc and oracle odbc all works.
````
SQLRETURN SQL_API EXPORTED_FUNCTION(SQLCancel)(
SQLHSTMT StatementHandle
) {
auto func = [&] (Statement & statement) {
statement.closeCursor();
return SQL_SUCCESS;
};
return CALL_WITH_TYPED_HANDLE(SQL_HANDLE_STMT, StatementHandle, func);
}
````
from odbc.cpp,we find the sqlcancel API,it only works when cursor happend.
Contributor guide
Assessment
This issue has not been assessed yet.