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

Igor updated IGNITE-20625:
--------------------------
    Description: 
h3. Steps to reproduce:
 # Connect to Ignite using ODBC driver (Python).
 # Execute separate queries one by oneĀ 
{code:java}
DROP TABLE IF EXISTS PUBLIC.PARKING;
CREATE TABLE PUBLIC.PARKING(ID INT, NAME VARCHAR(255), CAPACITY INT NOT NULL, b 
decimal,c date, CITY VARCHAR(20), PRIMARY KEY (ID, CITY));
INSERT INTO PUBLIC.PARKING(ID, NAME, CAPACITY, CITY) VALUES(1, 'parking_1', 1, 
'New York');
SELECT MIN(CAPACITY), MAX(CAPACITY) FROM PUBLIC.PARKING; {code}

h3. Expected result:

Query executed successfully.
h3. Actual result:

The last query throws exception.
{code:java}
The value in stream is not a Binary data : 5{code}
No errors in server log.

  was:
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.


> SELECT MIN(column), MAX(column) by ODBC throws exceptions
> ---------------------------------------------------------
>
>                 Key: IGNITE-20625
>                 URL: https://issues.apache.org/jira/browse/IGNITE-20625
>             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 separate queries one by oneĀ 
> {code:java}
> DROP TABLE IF EXISTS PUBLIC.PARKING;
> CREATE TABLE PUBLIC.PARKING(ID INT, NAME VARCHAR(255), CAPACITY INT NOT NULL, 
> b decimal,c date, CITY VARCHAR(20), PRIMARY KEY (ID, CITY));
> INSERT INTO PUBLIC.PARKING(ID, NAME, CAPACITY, CITY) VALUES(1, 'parking_1', 
> 1, 'New York');
> SELECT MIN(CAPACITY), MAX(CAPACITY) FROM PUBLIC.PARKING; {code}
> h3. Expected result:
> Query executed successfully.
> h3. Actual result:
> The last query throws exception.
> {code:java}
> The value in stream is not a Binary data : 5{code}
> No errors in server log.



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

Reply via email to