You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Date: 2013-08-20 02:54:37 +0200
From: Tim H. <<monetdb.bug.reporter>>
To: SQL devs <>
Version: 11.15.7 (Feb2013-SP2)
CC: @mlkersten, @njnes, @drstmane
Last updated: 2013-09-27 13:47:16 +0200
Comment 19031
Date: 2013-08-20 02:54:37 +0200
From: Tim H. <<monetdb.bug.reporter>>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.95 Safari/537.36
Build Identifier:
Suppose a "copy binary into <table_name> from ..." command is called such that <table_name> is a valid table and the from clause contains one bat file for every column. If the bat files have mismatched BATcount values, then the import fails with the wrong error message: "table <table_name> not found"
Reproducible: Always
Steps to Reproduce:
Put the attached (to this bug) bat files in /path/to/bat/files/
could you please also checkin the (correct/expected) stable output of the test for this bug?
sql/test/BugTracker-2013/Tests/binary_copy_into.Bug-3345.SQL.py
Date: 2013-08-20 02:54:37 +0200
From: Tim H. <<monetdb.bug.reporter>>
To: SQL devs <>
Version: 11.15.7 (Feb2013-SP2)
CC: @mlkersten, @njnes, @drstmane
Last updated: 2013-09-27 13:47:16 +0200
Comment 19031
Date: 2013-08-20 02:54:37 +0200
From: Tim H. <<monetdb.bug.reporter>>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.95 Safari/537.36
Build Identifier:
Suppose a "copy binary into <table_name> from ..." command is called such that <table_name> is a valid table and the from clause contains one bat file for every column. If the bat files have mismatched BATcount values, then the import fails with the wrong error message: "table <table_name> not found"
Reproducible: Always
Steps to Reproduce:
create table bug (n_nationkey INTEGER,n_regionkey INTEGER);
copy binary into bug from '/path/to/bat/files/n_nationkey.sorted', '/path/to/bat/files/n_regionkey.sorted';
Actual Results:
table bug not found
Expected Results:
/path/to/bat/files/n_regionkey.sorted has an incompatible number of rows with the previously-processed file
The issue is in sql.c:mvc_bin_import_table_wrap
if (i!=(pci->retc + 2) && cnt != BATcount(c))
throw(SQL, "sql", "table %s not found", tname);
Comment 19032
Date: 2013-08-20 02:55:04 +0200
From: Tim H. <<monetdb.bug.reporter>>
Created attachment 221
Binary file referenced in the repro steps
Comment 19033
Date: 2013-08-20 02:55:13 +0200
From: Tim H. <<monetdb.bug.reporter>>
Created attachment 222
Binary file referenced in the repro steps
Comment 19034
Date: 2013-08-20 07:27:51 +0200
From: @mlkersten
This is a testcase and duplicate of bug #3325
Comment 19038
Date: 2013-08-20 22:50:39 +0200
From: Tim H. <<monetdb.bug.reporter>>
It's related, but not quite a duplicate of 3325. 3325 doesn't mention the incorrect error message, which is what this bug is about.
Comment 19057
Date: 2013-08-23 11:42:04 +0200
From: MonetDB Mercurial Repository <>
Changeset 7a5b6b8d583d made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=7a5b6b8d583d
Changeset description:
Comment 19058
Date: 2013-08-23 11:43:05 +0200
From: @njnes
proper error returned
Comment 19059
Date: 2013-08-23 12:42:07 +0200
From: @drstmane
Niels,
could you please also checkin the (correct/expected) stable output of the test for this bug?
sql/test/BugTracker-2013/Tests/binary_copy_into.Bug-3345.SQL.py
Thanks!
Stefan
Comment 19128
Date: 2013-09-04 23:30:55 +0200
From: MonetDB Mercurial Repository <>
Changeset 1609eae18f34 made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=1609eae18f34
Changeset description:
Comment 19134
Date: 2013-09-05 23:17:12 +0200
From: MonetDB Mercurial Repository <>
Changeset 02bf23417cee made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=02bf23417cee
Changeset description:
The text was updated successfully, but these errors were encountered: