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

regression on sqlline

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.7
    • Fix Version/s: 2.7
    • Component/s: sql
    • Labels:
      None

      Description

      I've tried to execute our example using sqlline and got the following error:

      2787/5325    INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (2769,'Sokoto','NGA','Sokoto & Kebbi & Zam',204900);
      Error: Value for a column 'DISTRICT' is too long. Maximum length: 20, actual length: 21 (state=23000,code=4008)
      Aborting command set because "force" is false and command failed: "INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (2769,'Sokoto','NGA','Sokoto & Kebbi & Zam',204900);"
      0: jdbc:ignite:thin://127.0.0.1:10800>
      

      To reproduce:

      1. start one ignite node (version 2.7)
      2. start sqlline (sqlline.bat -u jdbc:ignite:thin://127.0.0.1:10800)
      3. execute in sqlline the command: !run ../examples/sql/world.sql

      The same on 2.6 or 2.5 worked w\o error.

        Attachments

          Activity

            People

            • Assignee:
              vozerov Vladimir Ozerov
              Reporter:
              pkonstantinov Pavel Konstantinov
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: