Dear Peter, The problem mentioned could be reproduced. It is clearly a bug and registered as such in test copy-count.SF-2485215.sql. It seems a bug in the code generator of SQL. The progress can be followed in the sourceforge bugtracker. Thanks for using the MonetDB package and helping to improve its quality. regards, Martin Peter Farkash wrote:
Hi,
When I use COPY INTO with a count query, monetDB crashes. For example:
copy select count (*) into 'C:\\copyinto.txt' using delimiters ',';
Gives me the following result and kills the server:
MAPI = monetdb@localhost:50000 ACTION= read_line QUERY = copy select count (*) into 'C:\\copyinto.txt' using delimiters ','; ERROR = Connection terminated
The same happens if I use sum, average, etc. On normal queries the copy into works just fine. I am using v5.8.2, and am getting the crash both when using mclient and the MAPI programming interface.
Any ideas?