Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-26730

SQL Error (1296): Got error 122 'Field 22 too long for my_column line 1292 of my_file.csv' from CONNECT

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.5.9
    • Fix Version/s: None
    • Labels:
      None
    • Environment:
      Windows 10

      Description

      When I load a CSV with a lot of large text columns, a CONNECT table is created and I can query the table. Some rows however, are returning the following error:

      SQL Error (1296): Got error 122 'Field 22 too long for my_column line 1292 of my_file.csv' from CONNECT
      

      HeidiSQL, SQL command line and PDO are all giving the same error. The error log shows:

      rnd_next CONNECT: Field 22 too long for my_column line 1292 of my_file.csv
      

      This is my create table statement:

      create or replace table my_table
      engine=connect
      table_type=csv
      file_name='C:\\my_folder\\my_file.csv'
      header=1
      sep_char=','
      quoted=1
      

      Column my_column is auto created as varchar(3329). But when I scan the CSV file, the row on line 1292 contains a text string with a length of 6632.
      Adding the column length explicitly solves the issue. I prefer however to let MariaDB create the column definitions as this simplyfies the upload process.

      What can I do? Are there any parameters that I can change? Could this be Windows related? Any help is appreciated.

      Thanks,
      Peter

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            PeterSchulzNL Peter Schulz
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration