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

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

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

monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
bug Something isn't working normal SQL

Comments

@monetdb-team
Copy link

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 joeri.van.ruth@monetdbsolutions.com 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

@monetdb-team monetdb-team added bug Something isn't working normal SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Feb 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working normal SQL
Projects
None yet
Development

No branches or pull requests

2 participants