[MDEV-6187] CONNECT storage engine should be more verbose - Jira

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

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server