You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Igor (Jira)" <ji...@apache.org> on 2023/10/11 15:04:00 UTC

[jira] [Resolved] (IGNITE-20615) SQL queries by ODBC throws exceptions

     [ https://issues.apache.org/jira/browse/IGNITE-20615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Igor resolved IGNITE-20615.
---------------------------
    Resolution: Not A Problem

Pyodbc tries to get metadata about non executed query - this feature is not yet implemented

> SQL queries by ODBC throws exceptions
> -------------------------------------
>
>                 Key: IGNITE-20615
>                 URL: https://issues.apache.org/jira/browse/IGNITE-20615
>             Project: Ignite
>          Issue Type: Bug
>          Components: odbc
>    Affects Versions: 3.0.0-beta2
>            Reporter: Igor
>            Priority: Major
>              Labels: ignite-3
>
> h3. Steps to reproduce:
>  # Connect to Ignite using ODBC driver (Python).
>  # Execute `CREATE TABLE CAR(ID INT, PARKINGID INT NOT NULL, NAME VARCHAR(255), CITY VARCHAR(20), PRIMARY KEY (ID, PARKINGID))`
> h3. Expected result:
> Query executed successfully.
> h3. Actual result:
> Exception is thrown.
> {code:java}
> CmdResult{exitCode=-1, result=, error=error executing CREATE TABLE CAR(ID INT, PARKINGID INT NOT NULL, NAME VARCHAR(255), CITY VARCHAR(20), PRIMARY KEY (ID, PARKINGID)) got error ('HYC00', '[HYC00] Metadata for non-executed queries is not supported (0) (SQLNumResultCols)'){code}
> No errors in server log.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)