Date: 2012-10-13 14:38:28 +0200
From: Anthony Damico <>
To: clients devs <>
Version: 11.13.3 (Oct2012)
CC: ajdamico, @mlkersten, @drstmane

Last updated: 2012-11-21 14:49:41 +0100

Comment 17797

Date: 2012-10-13 14:38:28 +0200
From: Anthony Damico <>

User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20100101 Firefox/16.0
Build Identifier:

When the command SELECT * FROM TABLENAME LIMIT 5 ; gets run on a table with a large number of columns (or SELECT COL1, COL2..., COL100, COL101, .. COL150 FROM TABLENAME LIMIT 5) -- mclient responds:

invalid tuple received from server, got columns, expected , ignoring

Reproducible: Always

Steps to Reproduce:

1. I am using the alaska household file from the 2010 american community survey. This file can be downloaded from: http://www2.census.gov/acs2010_1yr/pums/csv_hak.zip

2. Run these simple commands:

drop table household;

create table household ( RT VARCHAR(255), SERIALNO INT, DIVISION INT, PUMA INT, REGION INT, ST INT, ADJHSG INT, ADJINC INT, WGTP INT, NP INT, ZZZZ INT, ACR INT, AGS INT, BATH INT, BDSP INT, BLD INT, BUS INT, CONP INT, ELEP INT, FS INT, FULP INT, GASP INT, HFL INT, INSP INT, MHP INT, MRGI INT, MRGP INT, MRGT INT, MRGX INT, REFR INT, RMSP INT, RNTM INT, RNTP INT, RWAT INT, SINK INT, SMP INT, STOV INT, TEL INT, TEN INT, TOIL INT, VACS INT, VALP INT, VEH INT, WATP INT, YBL INT, FES INT, FINCP INT, FPARC INT, GRNTP INT, GRPIP INT, HHL INT, HHT INT, HINCP INT, HUGCL INT, HUPAC INT, HUPAOC INT, HUPARC INT, KIT INT, LNGI INT, MULTG INT, MV INT, NOC INT, NPF INT, NPP INT, NR INT, NRC INT, OCPIP INT, PARTNER INT, PLM INT, PSF INT, R18 INT, R60 INT, R65 INT, RESMODE INT, SMOCP INT, SMX INT, SRNT INT, SVAL INT, TAXP INT, WIF INT, WKEXREL INT, WORKSTAT INT, FACRP INT, FAGSP INT, FBATHP INT, FBDSP INT, FBLDP INT, FBUSP INT, FCONP INT, FELEP INT, FFSP INT, FFULP INT, FGASP INT, FHFLP INT, FINSP INT, FKITP INT, FMHP INT, FMRGIP INT, FMRGP INT, FMRGTP INT, FMRGXP INT, FMVP INT, FPLMP INT, FREFRP INT, FRMSP INT, FRNTMP INT, FRNTP INT, FRWATP INT, FSINKP INT, FSMP INT, FSMXHP INT, FSMXSP INT, FSTOVP INT, FTAXP INT, FTELP INT, FTENP INT, FTOILP INT, FVACSP INT, FVALP INT, FVEHP INT, FWATP INT, FYBLP INT, wgtp1 INT, wgtp2 INT, wgtp3 INT, wgtp4 INT, wgtp5 INT, wgtp6 INT, wgtp7 INT, wgtp8 INT, wgtp9 INT, wgtp10 INT, wgtp11 INT, wgtp12 INT, wgtp13 INT, wgtp14 INT, wgtp15 INT, wgtp16 INT, wgtp17 INT, wgtp18 INT, wgtp19 INT, wgtp20 INT, wgtp21 INT, wgtp22 INT, wgtp23 INT, wgtp24 INT, wgtp25 INT, wgtp26 INT, wgtp27 INT, wgtp28 INT, wgtp29 INT, wgtp30 INT, wgtp31 INT, wgtp32 INT, wgtp33 INT, wgtp34 INT, wgtp35 INT, wgtp36 INT, wgtp37 INT, wgtp38 INT, wgtp39 INT, wgtp40 INT, wgtp41 INT, wgtp42 INT, wgtp43 INT, wgtp44 INT, wgtp45 INT, wgtp46 INT, wgtp47 INT, wgtp48 INT, wgtp49 INT, wgtp50 INT, wgtp51 INT, wgtp52 INT, wgtp53 INT, wgtp54 INT, wgtp55 INT, wgtp56 INT, wgtp57 INT, wgtp58 INT, wgtp59 INT, wgtp60 INT, wgtp61 INT, wgtp62 INT, wgtp63 INT, wgtp64 INT, wgtp65 INT, wgtp66 INT, wgtp67 INT, wgtp68 INT, wgtp69 INT, wgtp70 INT, wgtp71 INT, wgtp72 INT, wgtp73 INT, wgtp74 INT, wgtp75 INT, wgtp76 INT, wgtp77 INT, wgtp78 INT, wgtp79 INT, wgtp80 INT );

copy 5000 offset 2 records into household from 'C:\My Directory\ss10hak.csv' using delimiters ',','\n','"' NULL as '' ;

\w-1

select count(*) from household;
select * from household limit 5 ;
PLAN select * from household limit 5 ;
EXPLAIN select * from household limit 5 ;

Actual Results:

invalid tuple received from server, got 138 columns, expected 476, ignoring
+------+------+------+------+-------+------+---------+---------+------+------+
1 tuple (417.984ms) !466 columns dropped!
note: to disable dropping columns and/or truncating fields use \w-1

Expected Results:

The first five records of this data table

I am confident the problem is not limited to mclient. When using a JAVA connection instead of mclient (with http://sqlsurvey.r-forge.r-project.org/) I get the exact same error.

Comment 17798

Date: 2012-10-13 15:21:35 +0200
From: @drstmane

(1)
In the genuine MonetDB code base, the reported error message is only generated in the SQLrenderer() of mclient.c .

(2)
Could you please shared with us, which exact version/release of MonetDB you are using?
The output of mserver5 --version would be just fine ...

(3)
Could you please try other than the default SQL renderer in you setting, i.e., on you mclient console ("sql>" prompt) type

\f
select * from household limit 1 ;

\fraw
select * from household limit 1 ;

\fcsv
select * from household limit 1 ;

\ftab
select * from household limit 1 ;

\ftest
select * from household limit 1 ;

\fsql
select * from household limit 1 ;

(assuming that the reported error also occurs with "limit 1"),
and share the entire output with us?

Thanks!

Comment 17799

Date: 2012-10-13 15:29:13 +0200
From: Anthony Damico <>

Thanks Stephan! Here you go:

(1)

I don't understand this.. is there something I can or should do? Sorry, I'm new to MonetDB..

(2)

C:\Program Files\MonetDB\MonetDB5>M5server --version
MonetDB 5 server v11.11.11 "Jul2012-SP2" (64-bit, 64-bit oids)
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2012 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Found 15.9GiB available memory, 2 available cpu cores
Libraries:
libpcre: 8.13 2011-08-16
openssl: OpenSSL 1.0.1b 26 Apr 2012
libxml2: 2.7.8
Compiled by: monet@LAB03 (x86_64-pc-winnt)
Compilation: cl -GF -W3 -wd4273 -wd4102 -MD -nologo -Ox
Linking : cl -GF -W3 -wd4273 -wd4102 -MD -nologo -Ox

C:\Program Files\MonetDB\MonetDB5>

(3)

sql>\f
Current formatter: sql
sql>select * from household limit 1 ;
+------+------+------+------+-------+------+---------+---------+------+------+
| rt | seri | divi | puma | regio | st | adjhsg | adjinc | wgtp | np |>
: : alno : sion : : n : : : : : :>
+======+======+======+======+=======+======+=========+=========+======+======+
invalid tuple received from server, got 138 columns, expected 202, ignoring
+------+------+------+------+-------+------+---------+---------+------+------+
1 tuple (2.0s) !192 columns dropped!
note: to disable dropping columns and/or truncating fields use \w-1
sql>
sql>\fraw
sql>select * from household limit 1 ;
% sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household table_name
% rt, serialno, division, puma, region, st, adjhsg, adjinc,
wgtp, np, zzzz, acr, ags, bath, bdsp, bld, bus, conp,
elep, fs, fulp, gasp, hfl, insp, mhp, mrgi, mrgp, mrgt,
mrgx, refr, rmsp, rntm, rntp, rwat, sink, smp, stov, tel,
ten, toil, vacs, valp, veh, watp, ybl, fes, fincp, fparc,
grntp, grpip, hhl, hht, hincp, hugcl, hupac, hupaoc, huparc, kit,
lngi, multg, mv, noc, npf, npp, nr, nrc, ocpip, partner,
plm, psf, r18, r60, r65, resmode, smocp, smx,
srnt, sval, taxp, wif, wkexrel, workstat, facrp, fagsp,
fbathp, fbdsp, fbldp, fbusp, fconp, felep, ffsp, ffulp, fgasp, fhflp,
finsp, fkitp, fmhp, fmrgip, fmrgp, fmrgtp, fmrgxp, fmvp, fplmp, frefrp,
frmsp, frntmp, frntp, frwatp, fsinkp, fsmp, fsmxhp, fsmxsp, fstovp, ftaxp,
ftelp, ftenp, ftoilp, fvacsp, fvalp, fvehp, fwatp, fyblp, wgtp1, wgtp2,
wgtp3, wgtp4, wgtp5, wgtp6, wgtp7, wgtp8, wgtp9, wgtp10, wgtp11, wgtp12,
wgtp13, wgtp14, wgtp15, wgtp16, wgtp17, wgtp18, wgtp19, wgtp20, wgtp21, wgtp22,
wgtp23, wgtp24, wgtp25, wgtp26, wgtp27, wgtp28, wgtp29, wgtp30, wgtp31, wgtp32,
wgtp33, wgtp34, wgtp35, wgtp36, wgtp37, wgtp38, wgtp39, wgtp40, wgtp41, wgtp42,
wgtp43, wgtp44, wgtp45, wgtp46, wgtp47, wgtp48, wgtp49, wgtp50, wgtp51, wgtp52,
wgtp53, wgtp54, wgtp55, wgtp56, wgtp57, wgtp58, wgtp59, wgtp60, wgtp61, wgtp62,
wgtp63, wgtp64, wgtp65, wgtp66, wgtp67, wgtp68, wgtp69, wgtp70, wgtp71, wgtp72,
wgtp73, wgtp74, wgtp75, wgtp76, wgtp77, wgtp78, wgtp79, wgtp80 name
% varchar, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int type
% 1, 3, 1, 3, 1, 1, 7, 7, 2, 1,
1, 1, 1, 1, 1, 1, 1, 1, 3, 1,
4, 1, 1, 3, 1, 1, 4, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 6, 1, 4, 1, 1, 5, 1, 1, 1,
1, 1, 5, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, 2, 1, 1, 1,
1, 1, 1, 1, 4, 1, 1, 1, 2, 1,
2, 2, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 2, 2, 2, 2, 2, 2, 2, 2,
2, 3, 2, 2, 2, 2, 2, 2, 2, 2,
2, 2, 2, 2, 3, 2, 3, 3, 2, 2,
2, 2, 2, 2, 2, 2, 2, 2, 2, 2,
2, 2, 2, 2, 2, 2, 2, 2, 2, 2,
2, 2, 2, 2, 2, 2, 2, 2, 2, 2,
2, 2, 2, 2, 2, 2, 2, 2, 2, 2,
2, 2, 2, 2, 2, 2, 3, 3, 2, 2,
2, 2 length
[ "H", 168, 9, 300, 4, 2, 1000000, 1007624,
56, 3, 1, 1, NULL, 1, 3, 2, 2, NULL,
200, 2, 3500, 3, 4, 760, NULL, 1, 1800, 1,
1, 1, 7, NULL, NULL, 1, 1, NULL, 1, 1,
1, 1, NULL, 235000, 2, 1600, 5, 7, 89500, 4,
NULL, NULL, 1, 3, 89500, 0, 4, 4, 4, 1,
1, 1, 6, 0, 3, 0, 0, 0, 33, 0,
1, 0, 0, 0, 0, 1, 2425, 3, 0, 1,
43, 3, 14, 13, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 74, 14, 62, 94, 47, 55,
45, 72, 60, 120, 18, 58, 31, 61, 54, 52,
sql>
sql>\fcsv
sql>select * from household limit 1 ;
H,168,9,300,4,2,1000000,1007624,56,3,1,1,,1,3,2,2,,200,2,3500,3,4,760,,1,1800,1,
1,1,7,,,1,1,,1,1,1,1,,235000,2,1600,5,7,89500,4,,,1,3,89500,0,4,4,4,1,1,1,6,0,3,
0,0,0,33,0,1,0,0,0,0,1,2425,3,0,1,43,3,14,13,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,74,14,62,94,47,55,45,72,60,120,18,5
8,31,61,54,52
sql>
sql>\ftab
sql>select * from household limit 1 ;
H 168 9 300 4 2 1000000 1007624 56 3
1 1 1 3 2 2 200 2
3500 3 4 760 1 1800 1 1 1
7 1 1 1 1 1 1
235000 2 1600 5 7 89500 4
1 3 89500 0 4 4 4 1 1 1
6 0 3 0 0 0 33 0 1 0
0 0 0 1 2425 3 0 1 43 3
14 13 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 74 14 62 94 47 55 45 72
60 120 18 58 31 61 54 52
sql>
sql>\ftest
sql>select * from household limit 1 ;
% sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household, sys.household, sys.household, sys.hous
ehold, sys.household, sys.household table_name
% rt, serialno, division, puma, region, st, adjhsg, adjinc,
wgtp, np, zzzz, acr, ags, bath, bdsp, bld, bus, conp,
elep, fs, fulp, gasp, hfl, insp, mhp, mrgi, mrgp, mrgt,
mrgx, refr, rmsp, rntm, rntp, rwat, sink, smp, stov, tel,
ten, toil, vacs, valp, veh, watp, ybl, fes, fincp, fparc,
grntp, grpip, hhl, hht, hincp, hugcl, hupac, hupaoc, huparc, kit,
lngi, multg, mv, noc, npf, npp, nr, nrc, ocpip, partner,
plm, psf, r18, r60, r65, resmode, smocp, smx,
srnt, sval, taxp, wif, wkexrel, workstat, facrp, fagsp,
fbathp, fbdsp, fbldp, fbusp, fconp, felep, ffsp, ffulp, fgasp, fhflp,
finsp, fkitp, fmhp, fmrgip, fmrgp, fmrgtp, fmrgxp, fmvp, fplmp, frefrp,
frmsp, frntmp, frntp, frwatp, fsinkp, fsmp, fsmxhp, fsmxsp, fstovp, ftaxp,
ftelp, ftenp, ftoilp, fvacsp, fvalp, fvehp, fwatp, fyblp, wgtp1, wgtp2,
wgtp3, wgtp4, wgtp5, wgtp6, wgtp7, wgtp8, wgtp9, wgtp10, wgtp11, wgtp12,
wgtp13, wgtp14, wgtp15, wgtp16, wgtp17, wgtp18, wgtp19, wgtp20, wgtp21, wgtp22,
wgtp23, wgtp24, wgtp25, wgtp26, wgtp27, wgtp28, wgtp29, wgtp30, wgtp31, wgtp32,
wgtp33, wgtp34, wgtp35, wgtp36, wgtp37, wgtp38, wgtp39, wgtp40, wgtp41, wgtp42,
wgtp43, wgtp44, wgtp45, wgtp46, wgtp47, wgtp48, wgtp49, wgtp50, wgtp51, wgtp52,
wgtp53, wgtp54, wgtp55, wgtp56, wgtp57, wgtp58, wgtp59, wgtp60, wgtp61, wgtp62,
wgtp63, wgtp64, wgtp65, wgtp66, wgtp67, wgtp68, wgtp69, wgtp70, wgtp71, wgtp72,
wgtp73, wgtp74, wgtp75, wgtp76, wgtp77, wgtp78, wgtp79, wgtp80 name
% varchar, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int, int, int, int, int, int, int, int,
int, int, int type
% 1, 3, 1, 3, 1, 1, 7, 7, 2, 1,
1, 1, 1, 1, 1, 1, 1, 1, 3, 1,
4, 1, 1, 3, 1, 1, 4, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 6, 1, 4, 1, 1, 5, 1, 1, 1,
1, 1, 5, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, 2, 1, 1, 1,
1, 1, 1, 1, 4, 1, 1, 1, 2, 1,
2, 2, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 2, 2, 2, 2, 2, 2, 2, 2,
2, 3, 2, 2, 2, 2, 2, 2, 2, 2,
2, 2, 2, 2, 3, 2, 3, 3, 2, 2,
2, 2, 2, 2, 2, 2, 2, 2, 2, 2,
2, 2, 2, 2, 2, 2, 2, 2, 2, 2,
2, 2, 2, 2, 2, 2, 2, 2, 2, 2,
2, 2, 2, 2, 2, 2, 2, 2, 2, 2,
2, 2, 2, 2, 2, 2, 3, 3, 2, 2,
2, 2 length
[ "H", 168, 9, 300, 4, 2, 1000000, 1007624,
56, 3, 1, 1, NULL, 1, 3, 2, 2, NULL,
200, 2, 3500, 3, 4, 760, NULL, 1, 1800, 1,
1, 1, 7, NULL, NULL, 1, 1, NULL, 1, 1,
1, 1, NULL, 235000, 2, 1600, 5, 7, 89500, 4,
NULL, NULL, 1, 3, 89500, 0, 4, 4, 4, 1,
1, 1, 6, 0, 3, 0, 0, 0, 33, 0,
1, 0, 0, 0, 0, 1, 2425, 3, 0, 1,
43, 3, 14, 13, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 74, 14, 62, 94, 47, 55,
45, 72, 60, 120, 18, 58, 31, 61, 54, 52
]
sql>
sql>\fsql
sql>select * from household limit 1 ;
+------+------+------+------+-------+------+---------+---------+------+------+
| rt | seri | divi | puma | regio | st | adjhsg | adjinc | wgtp | np |>
: : alno : sion : : n : : : : : :>
+======+======+======+======+=======+======+=========+=========+======+======+
invalid tuple received from server, got 138 columns, expected 202, ignoring
+------+------+------+------+-------+------+---------+---------+------+------+
1 tuple (106.778ms) !192 columns dropped!
sql>

Comment 17809

Date: 2012-10-13 19:08:06 +0200
From: @mlkersten

To rule out one area of possible problems, could you check if the result of the following instruction contains the 202 fields/row.

copy select * from household limit 1 into 'filename';

Comment 17810

Date: 2012-10-13 23:32:54 +0200
From: Anthony Damico <>

Yes, this appears to work properly. I get "1 affected row" and then the output file contains 202 separate values.

Comment 17858

Date: 2012-10-30 15:24:29 +0100
From: @sjoerdmullender

Changeset f694b42ec70e 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=f694b42ec70e

Changeset description:

Fix an off-by-one error.
This should fix bug #3161.
The problem was that the code checked whether the data would fit the
allocated space, and if it didn't, it would allocate more.  So far so
good.  But if the data fits exactly, the code would then copy one too
few characters.  We now extend the buffer if the data fits exactly.
Note that fitting exactly is here defined as fits without the usual
NUL byte at the end of the string, so we needed to extend for that
anyway.
This only showed up on Windows because BUFSIZ is significantly smaller
on Windows than on Linux.

Comment 17859

Date: 2012-10-30 16:12:22 +0100
From: @sjoerdmullender

Changeset b124e68caa5a 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=b124e68caa5a

Changeset description:

Added test for bug #3161.

Comment 17975

Date: 2012-11-21 14:49:41 +0100
From: @sjoerdmullender

Oct2012-SP1 has been released.