Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-20625

SELECT MIN(column), MAX(column) by ODBC throws exception

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.0.0-beta2
    • 3.0.0-beta2
    • odbc
    • Docs Required, Release Notes Required

    Description

      Steps to reproduce:

      1. Connect to Ignite using ODBC driver (Python).
      2. Execute separate queries one by oneĀ 
        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; 

      Expected result:

      Query executed successfully.

      Actual result:

      The last query throws exception.

      The value in stream is not a Binary data : 5

      No errors in server log.

      Attachments

        Issue Links

          Activity

            People

              isapego Igor Sapego
              lunigorn Igor
              Pavel Tupitsyn Pavel Tupitsyn
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20m
                  20m