Date: 2017-02-28 16:59:21 +0100
From: @swingbit
To: SQL devs <>
Version: 11.25.5 (Dec2016-SP1)

Last updated: 2017-03-31 13:28:40 +0200

Comment 25065

Date: 2017-02-28 16:59:21 +0100
From: @swingbit

User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36
Build Identifier:

ANALYZE fails with

!42000!syntax error, unexpected $end, expecting ')' or ',': end of input stream in "insert into sys.statistics (column_id,type,width,stamp,"sample",count,"unique",n"

on the given example in attachment

Reproducible: Always

Comment 25066

Date: 2017-02-28 17:00:04 +0100
From: @swingbit

Created attachment 538
failing sql script with copy into and analyze

Attached file: 6230_syntaxerror.sql (application/sql, 64209 bytes)
Description: failing sql script with copy into and analyze

Comment 25068

Date: 2017-02-28 19:42:01 +0100
From: MonetDB Mercurial Repository <>

Changeset e960625b33da made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=e960625b33da

Changeset description:

Allocate enough memory for query.
This fixes bugs 6229 and 6230.