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

CONNECT storage engine should be more verbose

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.10
    • Fix Version/s: 10.0.12
    • Component/s: None
    • Labels:
    • Environment:
      CentOS 6.4 x86_64

      Description

      When adding a connect table from multiple files, it prints an error that it could be improved:

      create table test (
      	Filename VARCHAR(100) NOT NULL default '' special=FILEID,
      	a varchar(25) not null default '',
      	b varchar(80) not null default '',
      	c varchar(10) not null default '',
      	d varchar(10) not null default '',
      	e varchar(10) not null default '',
      	f varchar(10) not null default '',
      	g varchar(10) not null default '',
      	h varchar(10) not null default '',
      	i varchar(10) not null default ''
      )
      engine=CONNECT
      table_type=CSV
      file_name='/tmp/FOLDER/PREC_*.txt'
      multiple=1,
      sep_char='|';

      As soon I try to get some data, it prints an error with no clue to what relates to:

      SELECT * FROM `test` LIMIT 1000;
      /* SQL Error (1296): Got error 3 'Invalid null offset value for a CSV table' from CONNECT */

      If I try do add the table with just one file, it works OK.

      I suspect there's some file without data in proper format..

      Could you add some more verbosity in ha_connect::GetTDB as to which filename relates to?

      Best regards,
      António Fernandes

        Attachments

          Activity

            People

            Assignee:
            bertrandop Olivier Bertrand
            Reporter:
            ampf Antonio Fernandes
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: