Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

COPY INTO FROM 'file.xz' does not work #6713

monetdb-team opened this issue Nov 30, 2020 · 0 comments

COPY INTO FROM 'file.xz' does not work #6713

monetdb-team opened this issue Nov 30, 2020 · 0 comments


Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

Date: 2019-06-11 15:29:40 +0200
From: @joerivanruth
To: SQL devs <>
Version: 11.33.3 (Apr2019)

Last updated: 2019-09-02 16:05:28 +0200

Comment 27049

Date: 2019-06-11 15:29:40 +0200
From: @joerivanruth

There is no error message but it simply doesn't load any rows.

Attached a script to reproduce.

Comment 27050

Date: 2019-06-11 15:33:26 +0200
From: MonetDB Mercurial Repository <>

Changeset 8d2869a2203b made by Joeri van Ruth in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=8d2869a2203b

Changeset description:

Fix Bug #6713 COPY INTO FROM 'file.xz' does not work

This happened when reading in ascii mode, for example
a csv file. The problem was that after checking for
a Byte Order Marker it tried to rewind the stream
but failed to reset one field of the xz_stream struct.

Comment 27051

Date: 2019-06-11 15:35:08 +0200
From: @joerivanruth

Created attachment 618
scripts to reproduce

File script.sql contains a hardcoded absolute path.
Update it before running.

Attached file: 6713.tar.gz (application/x-gzip, 2220 bytes)
Description: scripts to reproduce

Comment 27052

Date: 2019-06-11 15:35:47 +0200
From: @joerivanruth

Fixed in commit 8d2869a2203b

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant