invalid tuple received from server, got 138 columns, expected 476, ignoring
Hi everyone, I just wanted to follow-up on a previous post (available at http://mail.monetdb.org/pipermail/users-list/2012-September/005773.html) about an odd 'invalid tuple received' problem with a bit more detail and a simplified way to replicate everything. I've attached the results of PLAN and EXPLAIN in case that's of any value. The behavior of MonetDB seems strange, since I am able to select count(*) from table; and select every individual column from the table, but not select * from table;
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
Out of all of the commands posted below, only
sql>select * from household limit 5 ;
gives an error. It says:
invalid tuple received from server, got 138 columns, expected 202, ignoring
I assume this is a windows-related problem? I am using this in windows 7, x64.
Any help would be appreciated! Thanks!!!
Here are my SQL commands verbatim:
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:\Users\AnthonyD\Desktop\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 ;
select 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 from household limit 5;
select 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 from household limit 5;
select 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 from household limit 5;
Here's the output of PLAN and EXPLAIN:
operation successful (62.733ms) operation successful (88.682ms) 3335 affected rows (21.1s) +------+ | L1 | +======+ | 3335 | +------+ +------+----------+----------+------+--------+------+---------+---------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+------+------+-------+-------+-------+-------+------+------+-------+-------+-------+--------+--------+------+------+-------+------+------+------+------+------+------+-------+---------+------+------+------+------+------+---------+-------+------+------+------+------+------+---------+----------+-------+-------+--------+-------+-------+-------+-------+-------+------+-------+-------+-------+-------+-------+------+--------+-------+--------+--------+------+-------+--------+-------+--------+-------+--------+--------+------+--------+--------+--------+-------+-------+-------+--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+ | 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 | +======+==========+==========+======+========+======+=========+=========+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+========+======+======+======+======+=======+=======+=======+=======+======+======+=======+=======+=======+========+========+======+======+=======+======+======+======+======+======+======+=======+=========+======+======+======+======+======+=========+=======+======+======+======+======+======+=========+==========+=======+=======+========+=======+=======+=======+=======+=======+======+=======+=======+=======+=======+=======+======+========+=======+========+========+======+=======+========+=======+========+=======+========+========+======+========+========+========+=======+=======+=======+========+========+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+ | H | 1890 | 9 | 400 | 4 | 2 | 1000000 | 1007624 | 46 | 2 | 1 | null | null | 1 | 1 | 6 | null | null | 1 | 2 | 1 | 3 | 4 | null | null | null | null | null | null | 1 | 2 | 2 | 600 | 1 | 1 | null | 1 | 1 | 3 | 1 | null | null | 1 | 1 | 3 | null | null | null | 600 | 21 | 1 | 7 | 34700 | 0 | 4 | 4 | 4 | 1 | 1 | 1 | 3 | 0 | null | 0 | 1 | 0 | null | 0 | 1 | 0 | 0 | 0 | 0 | 2 | null | null | 1 | 0 | null | null | null | null | 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 | 1 | 10 | 16 | 10 | 42 | 61 | 44 | 54 | 45 | 71 | 67 | 112 | 50 | 15 | 41 | 111 | 79 | 37 | 67 | 38 | 40 | 81 | 95 | 70 | 81 | 51 | 40 | 38 | 47 | 15 | 22 | 18 | 34 | 95 | 55 | 14 | 51 | 48 | 18 | 43 | 12 | 7 | 13 | 15 | 57 | 72 | 55 | 48 | 50 | 75 | 80 | 116 | 51 | 14 | 38 | 126 | 57 | 30 | 93 | 29 | 53 | 80 | 55 | 71 | 46 | 38 | 57 | 39 | 47 | 16 | 16 | 20 | 50 | 91 | 58 | 20 | 72 | 43 | 11 | 48 | 9 | | H | 2029 | 9 | 101 | 4 | 2 | 1000000 | 1007624 | 269 | 4 | 1 | 1 | null | 1 | 4 | 2 | 2 | null | 80 | 2 | 2 | 80 | 1 | 1500 | null | 1 | 920 | 1 | 1 | 1 | 7 | null | null | 1 | 1 | null | 1 | 1 | 1 | 1 | null | 200000 | 1 | 200 | 4 | 8 | 47100 | 2 | null | null | 1 | 3 | 47100 | 1 | 2 | 4 | 2 | 1 | 1 | 2 | 7 | 0 | 4 | 0 | 0 | 2 | 28 | 0 | 1 | 1 | 1 | 1 | 1 | 2 | 1097 | 3 | 0 | 1 | 34 | 1 | 15 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 252 | 470 | 264 | 430 | 228 | 243 | 192 | 107 | 265 | 79 | 266 | 268 | 68 | 335 | 503 | 116 | 95 | 389 | 228 | 114 | 254 | 71 | 225 | 116 | 289 | 291 | 233 | 539 | 310 | 423 | 262 | 346 | 511 | 235 | 79 | 407 | 420 | 121 | 223 | 90 | 250 | 70 | 240 | 101 | 259 | 326 | 245 | 461 | 241 | 480 | 315 | 275 | 286 | 338 | 118 | 363 | 409 | 87 | 238 | 418 | 278 | 322 | 297 | 486 | 376 | 262 | 198 | 95 | 259 | 104 | 238 | 309 | 135 | 230 | 408 | 117 | 83 | 497 | 244 | 418 | +------+----------+----------+------+--------+------+---------+---------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+------+------+-------+-------+-------+-------+------+------+-------+-------+-------+--------+--------+------+------+-------+------+------+------+------+------+------+-------+---------+------+------+------+------+------+---------+-------+------+------+------+------+------+---------+----------+-------+-------+--------+-------+-------+-------+-------+-------+------+-------+-------+-------+-------+-------+------+--------+-------+--------+--------+------+-------+--------+-------+--------+-------+--------+--------+------+--------+--------+--------+-------+-------+-------+--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+ +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | rel | +=========================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================+ | top N ( | | | project ( | | | | table(sys.household) [ household.rt, household.serialno, household.division, household.puma, household.region, household.st, household.adjhsg, household.adjinc, household.wgtp, household.np, household.zzzz, household.acr, household.ags, household.bath, household.bdsp, household.bld, household.bus, household.conp, household.elep, household.fs, household.fulp, household.gasp, household.hfl, household.insp, household.mhp, household.mrgi, household.mrgp, household.mrgt, household.mrgx, household.refr, household.rmsp, household.rntm, household.rntp, household.rwat, household.sink, household.smp, household.stov, household.tel, household.ten, household.toil, household.vacs, household.valp, household.veh, household.watp, household.ybl, household.fes, household.fincp, household.fparc, household.grntp, household.grpip, household.hhl, household.hht, household.hincp, household.hugcl, household.hupac, household.hupaoc, household.huparc, household.kit, household.lngi, household.multg, household.mv, household.noc, household.npf, household.npp, household.nr, household.nrc, household.ocpip, household.partner, household.plm, household.psf, household.r18, household.r60, household.r65, household.resmode, household.smocp, household.smx, household.srnt, household.sval, household.taxp, household.wif, household.wkexrel, household.workstat, household.facrp, household.fagsp, household.fbathp, household.fbdsp, household.fbldp, household.fbusp, household.fconp, household.felep, household.ffsp, household.ffulp, household.fgasp, household.fhflp, household.finsp, household.fkitp, household.fmhp, household.fmrgip, household.fmrgp, household.fmrgtp, household.fmrgxp, household.fmvp, household.fplmp, household.frefrp, household.frmsp, household.frntmp, household.frntp, household.frwatp, household.fsinkp, household.fsmp, household.fsmxhp, household.fsmxsp, household.fstovp, household.ftaxp, household.ftelp, household.ftenp, household.ftoilp, household.fvacsp, household.fvalp, household.fvehp, household.fwatp, household.fyblp, household.wgtp1, household.wgtp2, household.wgtp3, household.wgtp4, household.wgtp5, household.wgtp6, household.wgtp7, household.wgtp8, household.wgtp9, household.wgtp10, household.wgtp11, household.wgtp12, household.wgtp13, household.wgtp14, household.wgtp15, household.wgtp16, household.wgtp17, household.wgtp18, household.wgtp19, household.wgtp20, household.wgtp21, household.wgtp22, household.wgtp23, household.wgtp24, household.wgtp25, household.wgtp26, household.wgtp27, household.wgtp28, household.wgtp29, household.wgtp30, household.wgtp31, household.wgtp32, household.wgtp33, household.wgtp34, household.wgtp35, household.wgtp36, household.wgtp37, household.wgtp38, household.wgtp39, household.wgtp40, household.wgtp41, household.wgtp42, household.wgtp43, household.wgtp44, household.wgtp45, household.wgtp46, household.wgtp47, household.wgtp48, household.wgtp49, household.wgtp50, household.wgtp51, household.wgtp52, household.wgtp53, household.wgtp54, household.wgtp55, household.wgtp56, household.wgtp57, household.wgtp58, household.wgtp59, household.wgtp60, household.wgtp61, household.wgtp62, household.wgtp63, household.wgtp64, household.wgtp65, household.wgtp66, household.wgtp67, household.wgtp68, household.wgtp69, household.wgtp70, household.wgtp71, household.wgtp72, household.wgtp73, household.wgtp74, household.wgtp75, household.wgtp76, household.wgtp77, household.wgtp78, household.wgtp79, household.wgtp80, household.%TID% NOT NULL ] COUNT | | | ) [ household.rt, household.serialno, household.division, household.puma, household.region, household.st, household.adjhsg, household.adjinc, household.wgtp, household.np, household.zzzz, household.acr, household.ags, household.bath, household.bdsp, household.bld, household.bus, household.conp, household.elep, household.fs, household.fulp, household.gasp, household.hfl, household.insp, household.mhp, household.mrgi, household.mrgp, household.mrgt, household.mrgx, household.refr, household.rmsp, household.rntm, household.rntp, household.rwat, household.sink, household.smp, household.stov, household.tel, household.ten, household.toil, household.vacs, household.valp, household.veh, household.watp, household.ybl, household.fes, household.fincp, household.fparc, household.grntp, household.grpip, household.hhl, household.hht, household.hincp, household.hugcl, household.hupac, household.hupaoc, household.huparc, household.kit, household.lngi, household.multg, household.mv, household.noc, household.npf, household.npp, household.nr, household.nrc, household.ocpip, household.partner, household.plm, household.psf, household.r18, household.r60, household.r65, household.resmode, household.smocp, household.smx, household.srnt, household.sval, household.taxp, household.wif, household.wkexrel, household.workstat, household.facrp, household.fagsp, household.fbathp, household.fbdsp, household.fbldp, household.fbusp, household.fconp, household.felep, household.ffsp, household.ffulp, household.fgasp, household.fhflp, household.finsp, household.fkitp, household.fmhp, household.fmrgip, household.fmrgp, household.fmrgtp, household.fmrgxp, household.fmvp, household.fplmp, household.frefrp, household.frmsp, household.frntmp, household.frntp, household.frwatp, household.fsinkp, household.fsmp, household.fsmxhp, household.fsmxsp, household.fstovp, household.ftaxp, household.ftelp, household.ftenp, household.ftoilp, household.fvacsp, household.fvalp, household.fvehp, household.fwatp, household.fyblp, household.wgtp1, household.wgtp2, household.wgtp3, household.wgtp4, household.wgtp5, household.wgtp6, household.wgtp7, household.wgtp8, household.wgtp9, household.wgtp10, household.wgtp11, household.wgtp12, household.wgtp13, household.wgtp14, household.wgtp15, household.wgtp16, household.wgtp17, household.wgtp18, household.wgtp19, household.wgtp20, household.wgtp21, household.wgtp22, household.wgtp23, household.wgtp24, household.wgtp25, household.wgtp26, household.wgtp27, household.wgtp28, household.wgtp29, household.wgtp30, household.wgtp31, household.wgtp32, household.wgtp33, household.wgtp34, household.wgtp35, household.wgtp36, household.wgtp37, household.wgtp38, household.wgtp39, household.wgtp40, household.wgtp41, household.wgtp42, household.wgtp43, household.wgtp44, household.wgtp45, household.wgtp46, household.wgtp47, household.wgtp48, household.wgtp49, household.wgtp50, household.wgtp51, household.wgtp52, household.wgtp53, household.wgtp54, household.wgtp55, household.wgtp56, household.wgtp57, household.wgtp58, household.wgtp59, household.wgtp60, household.wgtp61, household.wgtp62, household.wgtp63, household.wgtp64, household.wgtp65, household.wgtp66, household.wgtp67, household.wgtp68, household.wgtp69, household.wgtp70, household.wgtp71, household.wgtp72, household.wgtp73, household.wgtp74, household.wgtp75, household.wgtp76, household.wgtp77, household.wgtp78, household.wgtp79, household.wgtp80 ] | | ) [ wrd "5" ] | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ +----------------------------------------------------------------------------+ | mal | +============================================================================+ | function user.s4_1{autoCommit=true}():void; | | X_16 := nil:bat[:oid,:oid]; | | X_19 := nil:bat[:oid,:oid]; | | X_20 := nil:bat[:oid,:str]; | | barrier X_3105 := language.dataflow(); | | X_2 := sql.mvc(); | | X_3:bat[:oid,:str] := sql.bind(X_2,"sys","household","rt",0); | | X_8:bat[:oid,:str] := sql.bind(X_2,"sys","household","rt",2); | | X_10 := algebra.kdifference(X_3,X_8); | | X_11 := algebra.kunion(X_10,X_8); | | X_12:bat[:oid,:str] := sql.bind(X_2,"sys","household","rt",1); | | X_14 := algebra.kunion(X_11,X_12); | | X_15:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_16 := bat.reverse(X_15); | | X_17 := algebra.kdifference(X_14,X_16); | | X_18 := algebra.slice(X_17,0:wrd,4:wrd); | | X_19 := bat.mirror(X_18); | | X_20 := algebra.leftjoin(X_19,X_17); | | exit X_3105; | | X_2396 := sql.resultSet(202,1,X_20); | | X_31 := nil:bat[:oid,:int]; | | X_43 := nil:bat[:oid,:int]; | | X_54 := nil:bat[:oid,:int]; | | X_67 := nil:bat[:oid,:int]; | | X_77 := nil:bat[:oid,:int]; | | X_90 := nil:bat[:oid,:int]; | | X_100 := nil:bat[:oid,:int]; | | X_115 := nil:bat[:oid,:int]; | | X_125 := nil:bat[:oid,:int]; | | X_138 := nil:bat[:oid,:int]; | | X_149 := nil:bat[:oid,:int]; | | X_161 := nil:bat[:oid,:int]; | | X_172 := nil:bat[:oid,:int]; | | X_184 := nil:bat[:oid,:int]; | | X_195 := nil:bat[:oid,:int]; | | X_210 := nil:bat[:oid,:int]; | | X_220 := nil:bat[:oid,:int]; | | X_233 := nil:bat[:oid,:int]; | | X_243 := nil:bat[:oid,:int]; | | X_256 := nil:bat[:oid,:int]; | | X_266 := nil:bat[:oid,:int]; | | X_279 := nil:bat[:oid,:int]; | | X_289 := nil:bat[:oid,:int]; | | X_304 := nil:bat[:oid,:int]; | | X_315 := nil:bat[:oid,:int]; | | X_327 := nil:bat[:oid,:int]; | | X_338 := nil:bat[:oid,:int]; | | X_350 := nil:bat[:oid,:int]; | | X_361 := nil:bat[:oid,:int]; | | X_374 := nil:bat[:oid,:int]; | | X_384 := nil:bat[:oid,:int]; | | X_399 := nil:bat[:oid,:int]; | | X_409 := nil:bat[:oid,:int]; | | X_422 := nil:bat[:oid,:int]; | | X_432 := nil:bat[:oid,:int]; | | X_445 := nil:bat[:oid,:int]; | | X_455 := nil:bat[:oid,:int]; | | X_468 := nil:bat[:oid,:int]; | | X_479 := nil:bat[:oid,:int]; | | X_493 := nil:bat[:oid,:int]; | | X_504 := nil:bat[:oid,:int]; | | X_516 := nil:bat[:oid,:int]; | | X_527 := nil:bat[:oid,:int]; | | X_540 := nil:bat[:oid,:int]; | | X_550 := nil:bat[:oid,:int]; | | X_563 := nil:bat[:oid,:int]; | | X_573 := nil:bat[:oid,:int]; | | X_588 := nil:bat[:oid,:int]; | | X_598 := nil:bat[:oid,:int]; | | X_611 := nil:bat[:oid,:int]; | | X_621 := nil:bat[:oid,:int]; | | X_634 := nil:bat[:oid,:int]; | | X_645 := nil:bat[:oid,:int]; | | X_657 := nil:bat[:oid,:int]; | | X_668 := nil:bat[:oid,:int]; | | X_682 := nil:bat[:oid,:int]; | | X_693 := nil:bat[:oid,:int]; | | X_706 := nil:bat[:oid,:int]; | | X_716 := nil:bat[:oid,:int]; | | X_729 := nil:bat[:oid,:int]; | | X_739 := nil:bat[:oid,:int]; | | X_752 := nil:bat[:oid,:int]; | | X_762 := nil:bat[:oid,:int]; | | X_777 := nil:bat[:oid,:int]; | | X_787 := nil:bat[:oid,:int]; | | X_800 := nil:bat[:oid,:int]; | | X_811 := nil:bat[:oid,:int]; | | X_823 := nil:bat[:oid,:int]; | | X_834 := nil:bat[:oid,:int]; | | X_846 := nil:bat[:oid,:int]; | | X_857 := nil:bat[:oid,:int]; | | X_872 := nil:bat[:oid,:int]; | | X_882 := nil:bat[:oid,:int]; | | X_895 := nil:bat[:oid,:int]; | | X_905 := nil:bat[:oid,:int]; | | X_918 := nil:bat[:oid,:int]; | | X_928 := nil:bat[:oid,:int]; | | X_941 := nil:bat[:oid,:int]; | | X_951 := nil:bat[:oid,:int]; | | X_966 := nil:bat[:oid,:int]; | | X_977 := nil:bat[:oid,:int]; | | X_989 := nil:bat[:oid,:int]; | | X_1000 := nil:bat[:oid,:int]; | | X_1012 := nil:bat[:oid,:int]; | | X_1023 := nil:bat[:oid,:int]; | | X_1036 := nil:bat[:oid,:int]; | | X_1046 := nil:bat[:oid,:int]; | | X_1061 := nil:bat[:oid,:int]; | | X_1071 := nil:bat[:oid,:int]; | | X_1084 := nil:bat[:oid,:int]; | | X_1094 := nil:bat[:oid,:int]; | | X_1107 := nil:bat[:oid,:int]; | | X_1117 := nil:bat[:oid,:int]; | | X_1130 := nil:bat[:oid,:int]; | | X_1141 := nil:bat[:oid,:int]; | | X_1155 := nil:bat[:oid,:int]; | | X_1166 := nil:bat[:oid,:int]; | | X_1178 := nil:bat[:oid,:int]; | | X_1189 := nil:bat[:oid,:int]; | | X_1202 := nil:bat[:oid,:int]; | | X_1212 := nil:bat[:oid,:int]; | | X_1225 := nil:bat[:oid,:int]; | | X_1235 := nil:bat[:oid,:int]; | | X_1250 := nil:bat[:oid,:int]; | | X_1260 := nil:bat[:oid,:int]; | | X_1273 := nil:bat[:oid,:int]; | | X_1283 := nil:bat[:oid,:int]; | | X_1296 := nil:bat[:oid,:int]; | | X_1307 := nil:bat[:oid,:int]; | | X_1319 := nil:bat[:oid,:int]; | | X_1330 := nil:bat[:oid,:int]; | | X_1344 := nil:bat[:oid,:int]; | | X_1355 := nil:bat[:oid,:int]; | | X_1368 := nil:bat[:oid,:int]; | | X_1378 := nil:bat[:oid,:int]; | | X_1391 := nil:bat[:oid,:int]; | | X_1401 := nil:bat[:oid,:int]; | | X_1414 := nil:bat[:oid,:int]; | | X_1424 := nil:bat[:oid,:int]; | | X_1439 := nil:bat[:oid,:int]; | | X_1449 := nil:bat[:oid,:int]; | | X_1462 := nil:bat[:oid,:int]; | | X_1473 := nil:bat[:oid,:int]; | | X_1485 := nil:bat[:oid,:int]; | | X_1496 := nil:bat[:oid,:int]; | | X_1508 := nil:bat[:oid,:int]; | | X_1519 := nil:bat[:oid,:int]; | | X_1534 := nil:bat[:oid,:int]; | | X_1544 := nil:bat[:oid,:int]; | | X_1557 := nil:bat[:oid,:int]; | | X_1567 := nil:bat[:oid,:int]; | | X_1580 := nil:bat[:oid,:int]; | | X_1590 := nil:bat[:oid,:int]; | | X_1603 := nil:bat[:oid,:int]; | | X_1613 := nil:bat[:oid,:int]; | | X_1628 := nil:bat[:oid,:int]; | | X_1639 := nil:bat[:oid,:int]; | | X_1651 := nil:bat[:oid,:int]; | | X_1662 := nil:bat[:oid,:int]; | | X_1674 := nil:bat[:oid,:int]; | | X_1685 := nil:bat[:oid,:int]; | | X_1698 := nil:bat[:oid,:int]; | | X_1708 := nil:bat[:oid,:int]; | | X_1723 := nil:bat[:oid,:int]; | | X_1733 := nil:bat[:oid,:int]; | | X_1746 := nil:bat[:oid,:int]; | | X_1756 := nil:bat[:oid,:int]; | | X_1769 := nil:bat[:oid,:int]; | | X_1779 := nil:bat[:oid,:int]; | | X_1792 := nil:bat[:oid,:int]; | | X_1803 := nil:bat[:oid,:int]; | | X_1817 := nil:bat[:oid,:int]; | | X_1828 := nil:bat[:oid,:int]; | | X_1840 := nil:bat[:oid,:int]; | | X_1851 := nil:bat[:oid,:int]; | | X_1864 := nil:bat[:oid,:int]; | | X_1874 := nil:bat[:oid,:int]; | | X_1887 := nil:bat[:oid,:int]; | | X_1897 := nil:bat[:oid,:int]; | | X_1912 := nil:bat[:oid,:int]; | | X_1922 := nil:bat[:oid,:int]; | | X_1935 := nil:bat[:oid,:int]; | | X_1945 := nil:bat[:oid,:int]; | | X_1958 := nil:bat[:oid,:int]; | | X_1969 := nil:bat[:oid,:int]; | | X_1981 := nil:bat[:oid,:int]; | | X_1992 := nil:bat[:oid,:int]; | | X_2006 := nil:bat[:oid,:int]; | | X_2017 := nil:bat[:oid,:int]; | | X_2030 := nil:bat[:oid,:int]; | | X_2040 := nil:bat[:oid,:int]; | | X_2053 := nil:bat[:oid,:int]; | | X_2063 := nil:bat[:oid,:int]; | | X_2076 := nil:bat[:oid,:int]; | | X_2086 := nil:bat[:oid,:int]; | | X_2101 := nil:bat[:oid,:int]; | | X_2111 := nil:bat[:oid,:int]; | | X_2124 := nil:bat[:oid,:int]; | | X_2135 := nil:bat[:oid,:int]; | | X_2147 := nil:bat[:oid,:int]; | | X_2158 := nil:bat[:oid,:int]; | | X_2170 := nil:bat[:oid,:int]; | | X_2181 := nil:bat[:oid,:int]; | | X_2196 := nil:bat[:oid,:int]; | | X_2206 := nil:bat[:oid,:int]; | | X_2219 := nil:bat[:oid,:int]; | | X_2229 := nil:bat[:oid,:int]; | | X_2242 := nil:bat[:oid,:int]; | | X_2252 := nil:bat[:oid,:int]; | | X_2265 := nil:bat[:oid,:int]; | | X_2275 := nil:bat[:oid,:int]; | | X_2290 := nil:bat[:oid,:int]; | | X_2301 := nil:bat[:oid,:int]; | | X_2313 := nil:bat[:oid,:int]; | | X_2324 := nil:bat[:oid,:int]; | | X_2336 := nil:bat[:oid,:int]; | | X_2347 := nil:bat[:oid,:int]; | | X_2360 := nil:bat[:oid,:int]; | | X_2370 := nil:bat[:oid,:int]; | | X_2385 := nil:bat[:oid,:int]; | | X_2395 := nil:bat[:oid,:int]; | | barrier X_3114 := language.dataflow(); | | X_21:bat[:oid,:int] := sql.bind(X_2,"sys","household","serialno",0); | | X_23:bat[:oid,:int] := sql.bind(X_2,"sys","household","serialno",2); | | X_26 := algebra.kdifference(X_21,X_23); | | X_27 := algebra.kunion(X_26,X_23); | | X_28:bat[:oid,:int] := sql.bind(X_2,"sys","household","serialno",1); | | X_29 := algebra.kunion(X_27,X_28); | | X_30 := algebra.kdifference(X_29,X_16); | | X_31 := algebra.leftjoin(X_19,X_30); | | X_32:bat[:oid,:int] := sql.bind(X_2,"sys","household","division",0); | | X_35:bat[:oid,:int] := sql.bind(X_2,"sys","household","division",2); | | X_37 := algebra.kdifference(X_32,X_35); | | X_38 := algebra.kunion(X_37,X_35); | | X_39:bat[:oid,:int] := sql.bind(X_2,"sys","household","division",1); | | X_41 := algebra.kunion(X_38,X_39); | | X_42 := algebra.kdifference(X_41,X_16); | | X_43 := algebra.leftjoin(X_19,X_42); | | X_45:bat[:oid,:int] := sql.bind(X_2,"sys","household","puma",0); | | X_48:bat[:oid,:int] := sql.bind(X_2,"sys","household","puma",2); | | X_49 := algebra.kdifference(X_45,X_48); | | X_50 := algebra.kunion(X_49,X_48); | | X_51:bat[:oid,:int] := sql.bind(X_2,"sys","household","puma",1); | | X_52 := algebra.kunion(X_50,X_51); | | X_53 := algebra.kdifference(X_52,X_16); | | X_54 := algebra.leftjoin(X_19,X_53); | | X_55:bat[:oid,:int] := sql.bind(X_2,"sys","household","region",0); | | X_58:bat[:oid,:int] := sql.bind(X_2,"sys","household","region",2); | | X_60 := algebra.kdifference(X_55,X_58); | | X_61 := algebra.kunion(X_60,X_58); | | X_62:bat[:oid,:int] := sql.bind(X_2,"sys","household","region",1); | | X_64 := algebra.kunion(X_61,X_62); | | X_65 := algebra.kdifference(X_64,X_16); | | X_67 := algebra.leftjoin(X_19,X_65); | | X_68:bat[:oid,:int] := sql.bind(X_2,"sys","household","st",0); | | X_71:bat[:oid,:int] := sql.bind(X_2,"sys","household","st",2); | | X_72 := algebra.kdifference(X_68,X_71); | | X_73 := algebra.kunion(X_72,X_71); | | X_74:bat[:oid,:int] := sql.bind(X_2,"sys","household","st",1); | | X_75 := algebra.kunion(X_73,X_74); | | X_76 := algebra.kdifference(X_75,X_16); | | X_77 := algebra.leftjoin(X_19,X_76); | | X_78:bat[:oid,:int] := sql.bind(X_2,"sys","household","adjhsg",0); | | X_81:bat[:oid,:int] := sql.bind(X_2,"sys","household","adjhsg",2); | | X_83 := algebra.kdifference(X_78,X_81); | | X_84 := algebra.kunion(X_83,X_81); | | X_85:bat[:oid,:int] := sql.bind(X_2,"sys","household","adjhsg",1); | | X_88 := algebra.kunion(X_84,X_85); | | X_89 := algebra.kdifference(X_88,X_16); | | X_90 := algebra.leftjoin(X_19,X_89); | | X_91:bat[:oid,:int] := sql.bind(X_2,"sys","household","adjinc",0); | | X_94:bat[:oid,:int] := sql.bind(X_2,"sys","household","adjinc",2); | | X_95 := algebra.kdifference(X_91,X_94); | | X_96 := algebra.kunion(X_95,X_94); | | X_97:bat[:oid,:int] := sql.bind(X_2,"sys","household","adjinc",1); | | X_98 := algebra.kunion(X_96,X_97); | | X_99 := algebra.kdifference(X_98,X_16); | | X_100 := algebra.leftjoin(X_19,X_99); | | X_101:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp",0); | | X_104:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp",2); | | X_107 := algebra.kdifference(X_101,X_104); | | X_108 := algebra.kunion(X_107,X_104); | | X_109:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp",1); | | X_111 := algebra.kunion(X_108,X_109); | | X_112:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_113 := bat.reverse(X_112); | | X_114 := algebra.kdifference(X_111,X_113); | | X_115 := algebra.leftjoin(X_19,X_114); | | X_116:bat[:oid,:int] := sql.bind(X_2,"sys","household","np",0); | | X_119:bat[:oid,:int] := sql.bind(X_2,"sys","household","np",2); | | X_120 := algebra.kdifference(X_116,X_119); | | X_121 := algebra.kunion(X_120,X_119); | | X_122:bat[:oid,:int] := sql.bind(X_2,"sys","household","np",1); | | X_123 := algebra.kunion(X_121,X_122); | | X_124 := algebra.kdifference(X_123,X_113); | | X_125 := algebra.leftjoin(X_19,X_124); | | X_127:bat[:oid,:int] := sql.bind(X_2,"sys","household","zzzz",0); | | X_130:bat[:oid,:int] := sql.bind(X_2,"sys","household","zzzz",2); | | X_132 := algebra.kdifference(X_127,X_130); | | X_133 := algebra.kunion(X_132,X_130); | | X_134:bat[:oid,:int] := sql.bind(X_2,"sys","household","zzzz",1); | | X_136 := algebra.kunion(X_133,X_134); | | X_137 := algebra.kdifference(X_136,X_113); | | X_138 := algebra.leftjoin(X_19,X_137); | | X_139:bat[:oid,:int] := sql.bind(X_2,"sys","household","acr",0); | | X_142:bat[:oid,:int] := sql.bind(X_2,"sys","household","acr",2); | | X_143 := algebra.kdifference(X_139,X_142); | | X_144 := algebra.kunion(X_143,X_142); | | X_145:bat[:oid,:int] := sql.bind(X_2,"sys","household","acr",1); | | X_146 := algebra.kunion(X_144,X_145); | | X_147 := algebra.kdifference(X_146,X_113); | | X_149 := algebra.leftjoin(X_19,X_147); | | X_150:bat[:oid,:int] := sql.bind(X_2,"sys","household","ags",0); | | X_153:bat[:oid,:int] := sql.bind(X_2,"sys","household","ags",2); | | X_155 := algebra.kdifference(X_150,X_153); | | X_156 := algebra.kunion(X_155,X_153); | | X_157:bat[:oid,:int] := sql.bind(X_2,"sys","household","ags",1); | | X_159 := algebra.kunion(X_156,X_157); | | X_160 := algebra.kdifference(X_159,X_113); | | X_161 := algebra.leftjoin(X_19,X_160); | | X_162:bat[:oid,:int] := sql.bind(X_2,"sys","household","bath",0); | | X_165:bat[:oid,:int] := sql.bind(X_2,"sys","household","bath",2); | | X_166 := algebra.kdifference(X_162,X_165); | | X_167 := algebra.kunion(X_166,X_165); | | X_168:bat[:oid,:int] := sql.bind(X_2,"sys","household","bath",1); | | X_170 := algebra.kunion(X_167,X_168); | | X_171 := algebra.kdifference(X_170,X_113); | | X_172 := algebra.leftjoin(X_19,X_171); | | X_173:bat[:oid,:int] := sql.bind(X_2,"sys","household","bdsp",0); | | X_176:bat[:oid,:int] := sql.bind(X_2,"sys","household","bdsp",2); | | X_178 := algebra.kdifference(X_173,X_176); | | X_179 := algebra.kunion(X_178,X_176); | | X_180:bat[:oid,:int] := sql.bind(X_2,"sys","household","bdsp",1); | | X_182 := algebra.kunion(X_179,X_180); | | X_183 := algebra.kdifference(X_182,X_113); | | X_184 := algebra.leftjoin(X_19,X_183); | | X_185:bat[:oid,:int] := sql.bind(X_2,"sys","household","bld",0); | | X_189:bat[:oid,:int] := sql.bind(X_2,"sys","household","bld",2); | | X_190 := algebra.kdifference(X_185,X_189); | | X_191 := algebra.kunion(X_190,X_189); | | X_192:bat[:oid,:int] := sql.bind(X_2,"sys","household","bld",1); | | X_193 := algebra.kunion(X_191,X_192); | | X_194 := algebra.kdifference(X_193,X_113); | | X_195 := algebra.leftjoin(X_19,X_194); | | X_196:bat[:oid,:int] := sql.bind(X_2,"sys","household","bus",0); | | X_199:bat[:oid,:int] := sql.bind(X_2,"sys","household","bus",2); | | X_201 := algebra.kdifference(X_196,X_199); | | X_202 := algebra.kunion(X_201,X_199); | | X_203:bat[:oid,:int] := sql.bind(X_2,"sys","household","bus",1); | | X_205 := algebra.kunion(X_202,X_203); | | X_206:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_207 := bat.reverse(X_206); | | X_208 := algebra.kdifference(X_205,X_207); | | X_210 := algebra.leftjoin(X_19,X_208); | | X_211:bat[:oid,:int] := sql.bind(X_2,"sys","household","conp",0); | | X_214:bat[:oid,:int] := sql.bind(X_2,"sys","household","conp",2); | | X_215 := algebra.kdifference(X_211,X_214); | | X_216 := algebra.kunion(X_215,X_214); | | X_217:bat[:oid,:int] := sql.bind(X_2,"sys","household","conp",1); | | X_218 := algebra.kunion(X_216,X_217); | | X_219 := algebra.kdifference(X_218,X_207); | | X_220 := algebra.leftjoin(X_19,X_219); | | X_221:bat[:oid,:int] := sql.bind(X_2,"sys","household","elep",0); | | X_224:bat[:oid,:int] := sql.bind(X_2,"sys","household","elep",2); | | X_226 := algebra.kdifference(X_221,X_224); | | X_227 := algebra.kunion(X_226,X_224); | | X_228:bat[:oid,:int] := sql.bind(X_2,"sys","household","elep",1); | | X_230 := algebra.kunion(X_227,X_228); | | X_232 := algebra.kdifference(X_230,X_207); | | X_233 := algebra.leftjoin(X_19,X_232); | | X_234:bat[:oid,:int] := sql.bind(X_2,"sys","household","fs",0); | | X_237:bat[:oid,:int] := sql.bind(X_2,"sys","household","fs",2); | | X_238 := algebra.kdifference(X_234,X_237); | | X_239 := algebra.kunion(X_238,X_237); | | X_240:bat[:oid,:int] := sql.bind(X_2,"sys","household","fs",1); | | X_241 := algebra.kunion(X_239,X_240); | | X_242 := algebra.kdifference(X_241,X_207); | | X_243 := algebra.leftjoin(X_19,X_242); | | X_244:bat[:oid,:int] := sql.bind(X_2,"sys","household","fulp",0); | | X_247:bat[:oid,:int] := sql.bind(X_2,"sys","household","fulp",2); | | X_249 := algebra.kdifference(X_244,X_247); | | X_250 := algebra.kunion(X_249,X_247); | | X_251:bat[:oid,:int] := sql.bind(X_2,"sys","household","fulp",1); | | X_254 := algebra.kunion(X_250,X_251); | | X_255 := algebra.kdifference(X_254,X_207); | | X_256 := algebra.leftjoin(X_19,X_255); | | X_257:bat[:oid,:int] := sql.bind(X_2,"sys","household","gasp",0); | | X_260:bat[:oid,:int] := sql.bind(X_2,"sys","household","gasp",2); | | X_261 := algebra.kdifference(X_257,X_260); | | X_262 := algebra.kunion(X_261,X_260); | | X_263:bat[:oid,:int] := sql.bind(X_2,"sys","household","gasp",1); | | X_264 := algebra.kunion(X_262,X_263); | | X_265 := algebra.kdifference(X_264,X_207); | | X_266 := algebra.leftjoin(X_19,X_265); | | X_267:bat[:oid,:int] := sql.bind(X_2,"sys","household","hfl",0); | | X_270:bat[:oid,:int] := sql.bind(X_2,"sys","household","hfl",2); | | X_273 := algebra.kdifference(X_267,X_270); | | X_274 := algebra.kunion(X_273,X_270); | | X_275:bat[:oid,:int] := sql.bind(X_2,"sys","household","hfl",1); | | X_277 := algebra.kunion(X_274,X_275); | | X_278 := algebra.kdifference(X_277,X_207); | | X_279 := algebra.leftjoin(X_19,X_278); | | X_280:bat[:oid,:int] := sql.bind(X_2,"sys","household","insp",0); | | X_283:bat[:oid,:int] := sql.bind(X_2,"sys","household","insp",2); | | X_284 := algebra.kdifference(X_280,X_283); | | X_285 := algebra.kunion(X_284,X_283); | | X_286:bat[:oid,:int] := sql.bind(X_2,"sys","household","insp",1); | | X_287 := algebra.kunion(X_285,X_286); | | X_288 := algebra.kdifference(X_287,X_207); | | X_289 := algebra.leftjoin(X_19,X_288); | | X_291:bat[:oid,:int] := sql.bind(X_2,"sys","household","mhp",0); | | X_294:bat[:oid,:int] := sql.bind(X_2,"sys","household","mhp",2); | | X_296 := algebra.kdifference(X_291,X_294); | | X_297 := algebra.kunion(X_296,X_294); | | X_298:bat[:oid,:int] := sql.bind(X_2,"sys","household","mhp",1); | | X_300 := algebra.kunion(X_297,X_298); | | X_301:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_302 := bat.reverse(X_301); | | X_303 := algebra.kdifference(X_300,X_302); | | X_304 := algebra.leftjoin(X_19,X_303); | | X_305:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgi",0); | | X_308:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgi",2); | | X_309 := algebra.kdifference(X_305,X_308); | | X_310 := algebra.kunion(X_309,X_308); | | X_311:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgi",1); | | X_312 := algebra.kunion(X_310,X_311); | | X_313 := algebra.kdifference(X_312,X_302); | | X_315 := algebra.leftjoin(X_19,X_313); | | X_316:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgp",0); | | X_319:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgp",2); | | X_321 := algebra.kdifference(X_316,X_319); | | X_322 := algebra.kunion(X_321,X_319); | | X_323:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgp",1); | | X_325 := algebra.kunion(X_322,X_323); | | X_326 := algebra.kdifference(X_325,X_302); | | X_327 := algebra.leftjoin(X_19,X_326); | | X_328:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgt",0); | | X_331:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgt",2); | | X_332 := algebra.kdifference(X_328,X_331); | | X_333 := algebra.kunion(X_332,X_331); | | X_334:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgt",1); | | X_336 := algebra.kunion(X_333,X_334); | | X_337 := algebra.kdifference(X_336,X_302); | | X_338 := algebra.leftjoin(X_19,X_337); | | X_339:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgx",0); | | X_342:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgx",2); | | X_344 := algebra.kdifference(X_339,X_342); | | X_345 := algebra.kunion(X_344,X_342); | | X_346:bat[:oid,:int] := sql.bind(X_2,"sys","household","mrgx",1); | | X_348 := algebra.kunion(X_345,X_346); | | X_349 := algebra.kdifference(X_348,X_302); | | X_350 := algebra.leftjoin(X_19,X_349); | | X_351:bat[:oid,:int] := sql.bind(X_2,"sys","household","refr",0); | | X_355:bat[:oid,:int] := sql.bind(X_2,"sys","household","refr",2); | | X_356 := algebra.kdifference(X_351,X_355); | | X_357 := algebra.kunion(X_356,X_355); | | X_358:bat[:oid,:int] := sql.bind(X_2,"sys","household","refr",1); | | X_359 := algebra.kunion(X_357,X_358); | | X_360 := algebra.kdifference(X_359,X_302); | | X_361 := algebra.leftjoin(X_19,X_360); | | X_362:bat[:oid,:int] := sql.bind(X_2,"sys","household","rmsp",0); | | X_365:bat[:oid,:int] := sql.bind(X_2,"sys","household","rmsp",2); | | X_367 := algebra.kdifference(X_362,X_365); | | X_368 := algebra.kunion(X_367,X_365); | | X_369:bat[:oid,:int] := sql.bind(X_2,"sys","household","rmsp",1); | | X_371 := algebra.kunion(X_368,X_369); | | X_372 := algebra.kdifference(X_371,X_302); | | X_374 := algebra.leftjoin(X_19,X_372); | | X_375:bat[:oid,:int] := sql.bind(X_2,"sys","household","rntm",0); | | X_378:bat[:oid,:int] := sql.bind(X_2,"sys","household","rntm",2); | | X_379 := algebra.kdifference(X_375,X_378); | | X_380 := algebra.kunion(X_379,X_378); | | X_381:bat[:oid,:int] := sql.bind(X_2,"sys","household","rntm",1); | | X_382 := algebra.kunion(X_380,X_381); | | X_383 := algebra.kdifference(X_382,X_302); | | X_384 := algebra.leftjoin(X_19,X_383); | | X_385:bat[:oid,:int] := sql.bind(X_2,"sys","household","rntp",0); | | X_388:bat[:oid,:int] := sql.bind(X_2,"sys","household","rntp",2); | | X_390 := algebra.kdifference(X_385,X_388); | | X_391 := algebra.kunion(X_390,X_388); | | X_392:bat[:oid,:int] := sql.bind(X_2,"sys","household","rntp",1); | | X_394 := algebra.kunion(X_391,X_392); | | X_395:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_397 := bat.reverse(X_395); | | X_398 := algebra.kdifference(X_394,X_397); | | X_399 := algebra.leftjoin(X_19,X_398); | | X_400:bat[:oid,:int] := sql.bind(X_2,"sys","household","rwat",0); | | X_403:bat[:oid,:int] := sql.bind(X_2,"sys","household","rwat",2); | | X_404 := algebra.kdifference(X_400,X_403); | | X_405 := algebra.kunion(X_404,X_403); | | X_406:bat[:oid,:int] := sql.bind(X_2,"sys","household","rwat",1); | | X_407 := algebra.kunion(X_405,X_406); | | X_408 := algebra.kdifference(X_407,X_397); | | X_409 := algebra.leftjoin(X_19,X_408); | | X_410:bat[:oid,:int] := sql.bind(X_2,"sys","household","sink",0); | | X_413:bat[:oid,:int] := sql.bind(X_2,"sys","household","sink",2); | | X_415 := algebra.kdifference(X_410,X_413); | | X_416 := algebra.kunion(X_415,X_413); | | X_417:bat[:oid,:int] := sql.bind(X_2,"sys","household","sink",1); | | X_420 := algebra.kunion(X_416,X_417); | | X_421 := algebra.kdifference(X_420,X_397); | | X_422 := algebra.leftjoin(X_19,X_421); | | X_423:bat[:oid,:int] := sql.bind(X_2,"sys","household","smp",0); | | X_426:bat[:oid,:int] := sql.bind(X_2,"sys","household","smp",2); | | X_427 := algebra.kdifference(X_423,X_426); | | X_428 := algebra.kunion(X_427,X_426); | | X_429:bat[:oid,:int] := sql.bind(X_2,"sys","household","smp",1); | | X_430 := algebra.kunion(X_428,X_429); | | X_431 := algebra.kdifference(X_430,X_397); | | X_432 := algebra.leftjoin(X_19,X_431); | | X_433:bat[:oid,:int] := sql.bind(X_2,"sys","household","stov",0); | | X_436:bat[:oid,:int] := sql.bind(X_2,"sys","household","stov",2); | | X_439 := algebra.kdifference(X_433,X_436); | | X_440 := algebra.kunion(X_439,X_436); | | X_441:bat[:oid,:int] := sql.bind(X_2,"sys","household","stov",1); | | X_443 := algebra.kunion(X_440,X_441); | | X_444 := algebra.kdifference(X_443,X_397); | | X_445 := algebra.leftjoin(X_19,X_444); | | X_446:bat[:oid,:int] := sql.bind(X_2,"sys","household","tel",0); | | X_449:bat[:oid,:int] := sql.bind(X_2,"sys","household","tel",2); | | X_450 := algebra.kdifference(X_446,X_449); | | X_451 := algebra.kunion(X_450,X_449); | | X_452:bat[:oid,:int] := sql.bind(X_2,"sys","household","tel",1); | | X_453 := algebra.kunion(X_451,X_452); | | X_454 := algebra.kdifference(X_453,X_397); | | X_455 := algebra.leftjoin(X_19,X_454); | | X_457:bat[:oid,:int] := sql.bind(X_2,"sys","household","ten",0); | | X_460:bat[:oid,:int] := sql.bind(X_2,"sys","household","ten",2); | | X_462 := algebra.kdifference(X_457,X_460); | | X_463 := algebra.kunion(X_462,X_460); | | X_464:bat[:oid,:int] := sql.bind(X_2,"sys","household","ten",1); | | X_466 := algebra.kunion(X_463,X_464); | | X_467 := algebra.kdifference(X_466,X_397); | | X_468 := algebra.leftjoin(X_19,X_467); | | X_469:bat[:oid,:int] := sql.bind(X_2,"sys","household","toil",0); | | X_472:bat[:oid,:int] := sql.bind(X_2,"sys","household","toil",2); | | X_473 := algebra.kdifference(X_469,X_472); | | X_474 := algebra.kunion(X_473,X_472); | | X_475:bat[:oid,:int] := sql.bind(X_2,"sys","household","toil",1); | | X_476 := algebra.kunion(X_474,X_475); | | X_477 := algebra.kdifference(X_476,X_397); | | X_479 := algebra.leftjoin(X_19,X_477); | | X_480:bat[:oid,:int] := sql.bind(X_2,"sys","household","vacs",0); | | X_483:bat[:oid,:int] := sql.bind(X_2,"sys","household","vacs",2); | | X_485 := algebra.kdifference(X_480,X_483); | | X_486 := algebra.kunion(X_485,X_483); | | X_487:bat[:oid,:int] := sql.bind(X_2,"sys","household","vacs",1); | | X_489 := algebra.kunion(X_486,X_487); | | X_490:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_491 := bat.reverse(X_490); | | X_492 := algebra.kdifference(X_489,X_491); | | X_493 := algebra.leftjoin(X_19,X_492); | | X_494:bat[:oid,:int] := sql.bind(X_2,"sys","household","valp",0); | | X_497:bat[:oid,:int] := sql.bind(X_2,"sys","household","valp",2); | | X_498 := algebra.kdifference(X_494,X_497); | | X_499 := algebra.kunion(X_498,X_497); | | X_500:bat[:oid,:int] := sql.bind(X_2,"sys","household","valp",1); | | X_502 := algebra.kunion(X_499,X_500); | | X_503 := algebra.kdifference(X_502,X_491); | | X_504 := algebra.leftjoin(X_19,X_503); | | X_505:bat[:oid,:int] := sql.bind(X_2,"sys","household","veh",0); | | X_508:bat[:oid,:int] := sql.bind(X_2,"sys","household","veh",2); | | X_510 := algebra.kdifference(X_505,X_508); | | X_511 := algebra.kunion(X_510,X_508); | | X_512:bat[:oid,:int] := sql.bind(X_2,"sys","household","veh",1); | | X_514 := algebra.kunion(X_511,X_512); | | X_515 := algebra.kdifference(X_514,X_491); | | X_516 := algebra.leftjoin(X_19,X_515); | | X_517:bat[:oid,:int] := sql.bind(X_2,"sys","household","watp",0); | | X_521:bat[:oid,:int] := sql.bind(X_2,"sys","household","watp",2); | | X_522 := algebra.kdifference(X_517,X_521); | | X_523 := algebra.kunion(X_522,X_521); | | X_524:bat[:oid,:int] := sql.bind(X_2,"sys","household","watp",1); | | X_525 := algebra.kunion(X_523,X_524); | | X_526 := algebra.kdifference(X_525,X_491); | | X_527 := algebra.leftjoin(X_19,X_526); | | X_528:bat[:oid,:int] := sql.bind(X_2,"sys","household","ybl",0); | | X_531:bat[:oid,:int] := sql.bind(X_2,"sys","household","ybl",2); | | X_533 := algebra.kdifference(X_528,X_531); | | X_534 := algebra.kunion(X_533,X_531); | | X_535:bat[:oid,:int] := sql.bind(X_2,"sys","household","ybl",1); | | X_537 := algebra.kunion(X_534,X_535); | | X_538 := algebra.kdifference(X_537,X_491); | | X_540 := algebra.leftjoin(X_19,X_538); | | X_541:bat[:oid,:int] := sql.bind(X_2,"sys","household","fes",0); | | X_544:bat[:oid,:int] := sql.bind(X_2,"sys","household","fes",2); | | X_545 := algebra.kdifference(X_541,X_544); | | X_546 := algebra.kunion(X_545,X_544); | | X_547:bat[:oid,:int] := sql.bind(X_2,"sys","household","fes",1); | | X_548 := algebra.kunion(X_546,X_547); | | X_549 := algebra.kdifference(X_548,X_491); | | X_550 := algebra.leftjoin(X_19,X_549); | | X_551:bat[:oid,:int] := sql.bind(X_2,"sys","household","fincp",0); | | X_554:bat[:oid,:int] := sql.bind(X_2,"sys","household","fincp",2); | | X_556 := algebra.kdifference(X_551,X_554); | | X_557 := algebra.kunion(X_556,X_554); | | X_558:bat[:oid,:int] := sql.bind(X_2,"sys","household","fincp",1); | | X_560 := algebra.kunion(X_557,X_558); | | X_562 := algebra.kdifference(X_560,X_491); | | X_563 := algebra.leftjoin(X_19,X_562); | | X_564:bat[:oid,:int] := sql.bind(X_2,"sys","household","fparc",0); | | X_567:bat[:oid,:int] := sql.bind(X_2,"sys","household","fparc",2); | | X_568 := algebra.kdifference(X_564,X_567); | | X_569 := algebra.kunion(X_568,X_567); | | X_570:bat[:oid,:int] := sql.bind(X_2,"sys","household","fparc",1); | | X_571 := algebra.kunion(X_569,X_570); | | X_572 := algebra.kdifference(X_571,X_491); | | X_573 := algebra.leftjoin(X_19,X_572); | | X_574:bat[:oid,:int] := sql.bind(X_2,"sys","household","grntp",0); | | X_577:bat[:oid,:int] := sql.bind(X_2,"sys","household","grntp",2); | | X_579 := algebra.kdifference(X_574,X_577); | | X_580 := algebra.kunion(X_579,X_577); | | X_581:bat[:oid,:int] := sql.bind(X_2,"sys","household","grntp",1); | | X_584 := algebra.kunion(X_580,X_581); | | X_585:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_586 := bat.reverse(X_585); | | X_587 := algebra.kdifference(X_584,X_586); | | X_588 := algebra.leftjoin(X_19,X_587); | | X_589:bat[:oid,:int] := sql.bind(X_2,"sys","household","grpip",0); | | X_592:bat[:oid,:int] := sql.bind(X_2,"sys","household","grpip",2); | | X_593 := algebra.kdifference(X_589,X_592); | | X_594 := algebra.kunion(X_593,X_592); | | X_595:bat[:oid,:int] := sql.bind(X_2,"sys","household","grpip",1); | | X_596 := algebra.kunion(X_594,X_595); | | X_597 := algebra.kdifference(X_596,X_586); | | X_598 := algebra.leftjoin(X_19,X_597); | | X_599:bat[:oid,:int] := sql.bind(X_2,"sys","household","hhl",0); | | X_602:bat[:oid,:int] := sql.bind(X_2,"sys","household","hhl",2); | | X_605 := algebra.kdifference(X_599,X_602); | | X_606 := algebra.kunion(X_605,X_602); | | X_607:bat[:oid,:int] := sql.bind(X_2,"sys","household","hhl",1); | | X_609 := algebra.kunion(X_606,X_607); | | X_610 := algebra.kdifference(X_609,X_586); | | X_611 := algebra.leftjoin(X_19,X_610); | | X_612:bat[:oid,:int] := sql.bind(X_2,"sys","household","hht",0); | | X_615:bat[:oid,:int] := sql.bind(X_2,"sys","household","hht",2); | | X_616 := algebra.kdifference(X_612,X_615); | | X_617 := algebra.kunion(X_616,X_615); | | X_618:bat[:oid,:int] := sql.bind(X_2,"sys","household","hht",1); | | X_619 := algebra.kunion(X_617,X_618); | | X_620 := algebra.kdifference(X_619,X_586); | | X_621 := algebra.leftjoin(X_19,X_620); | | X_623:bat[:oid,:int] := sql.bind(X_2,"sys","household","hincp",0); | | X_626:bat[:oid,:int] := sql.bind(X_2,"sys","household","hincp",2); | | X_628 := algebra.kdifference(X_623,X_626); | | X_629 := algebra.kunion(X_628,X_626); | | X_630:bat[:oid,:int] := sql.bind(X_2,"sys","household","hincp",1); | | X_632 := algebra.kunion(X_629,X_630); | | X_633 := algebra.kdifference(X_632,X_586); | | X_634 := algebra.leftjoin(X_19,X_633); | | X_635:bat[:oid,:int] := sql.bind(X_2,"sys","household","hugcl",0); | | X_638:bat[:oid,:int] := sql.bind(X_2,"sys","household","hugcl",2); | | X_639 := algebra.kdifference(X_635,X_638); | | X_640 := algebra.kunion(X_639,X_638); | | X_641:bat[:oid,:int] := sql.bind(X_2,"sys","household","hugcl",1); | | X_642 := algebra.kunion(X_640,X_641); | | X_643 := algebra.kdifference(X_642,X_586); | | X_645 := algebra.leftjoin(X_19,X_643); | | X_646:bat[:oid,:int] := sql.bind(X_2,"sys","household","hupac",0); | | X_649:bat[:oid,:int] := sql.bind(X_2,"sys","household","hupac",2); | | X_651 := algebra.kdifference(X_646,X_649); | | X_652 := algebra.kunion(X_651,X_649); | | X_653:bat[:oid,:int] := sql.bind(X_2,"sys","household","hupac",1); | | X_655 := algebra.kunion(X_652,X_653); | | X_656 := algebra.kdifference(X_655,X_586); | | X_657 := algebra.leftjoin(X_19,X_656); | | X_658:bat[:oid,:int] := sql.bind(X_2,"sys","household","hupaoc",0); | | X_661:bat[:oid,:int] := sql.bind(X_2,"sys","household","hupaoc",2); | | X_662 := algebra.kdifference(X_658,X_661); | | X_663 := algebra.kunion(X_662,X_661); | | X_664:bat[:oid,:int] := sql.bind(X_2,"sys","household","hupaoc",1); | | X_666 := algebra.kunion(X_663,X_664); | | X_667 := algebra.kdifference(X_666,X_586); | | X_668 := algebra.leftjoin(X_19,X_667); | | X_669:bat[:oid,:int] := sql.bind(X_2,"sys","household","huparc",0); | | X_672:bat[:oid,:int] := sql.bind(X_2,"sys","household","huparc",2); | | X_674 := algebra.kdifference(X_669,X_672); | | X_675 := algebra.kunion(X_674,X_672); | | X_676:bat[:oid,:int] := sql.bind(X_2,"sys","household","huparc",1); | | X_678 := algebra.kunion(X_675,X_676); | | X_679:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_680 := bat.reverse(X_679); | | X_681 := algebra.kdifference(X_678,X_680); | | X_682 := algebra.leftjoin(X_19,X_681); | | X_683:bat[:oid,:int] := sql.bind(X_2,"sys","household","kit",0); | | X_687:bat[:oid,:int] := sql.bind(X_2,"sys","household","kit",2); | | X_688 := algebra.kdifference(X_683,X_687); | | X_689 := algebra.kunion(X_688,X_687); | | X_690:bat[:oid,:int] := sql.bind(X_2,"sys","household","kit",1); | | X_691 := algebra.kunion(X_689,X_690); | | X_692 := algebra.kdifference(X_691,X_680); | | X_693 := algebra.leftjoin(X_19,X_692); | | X_694:bat[:oid,:int] := sql.bind(X_2,"sys","household","lngi",0); | | X_697:bat[:oid,:int] := sql.bind(X_2,"sys","household","lngi",2); | | X_699 := algebra.kdifference(X_694,X_697); | | X_700 := algebra.kunion(X_699,X_697); | | X_701:bat[:oid,:int] := sql.bind(X_2,"sys","household","lngi",1); | | X_703 := algebra.kunion(X_700,X_701); | | X_704 := algebra.kdifference(X_703,X_680); | | X_706 := algebra.leftjoin(X_19,X_704); | | X_707:bat[:oid,:int] := sql.bind(X_2,"sys","household","multg",0); | | X_710:bat[:oid,:int] := sql.bind(X_2,"sys","household","multg",2); | | X_711 := algebra.kdifference(X_707,X_710); | | X_712 := algebra.kunion(X_711,X_710); | | X_713:bat[:oid,:int] := sql.bind(X_2,"sys","household","multg",1); | | X_714 := algebra.kunion(X_712,X_713); | | X_715 := algebra.kdifference(X_714,X_680); | | X_716 := algebra.leftjoin(X_19,X_715); | | X_717:bat[:oid,:int] := sql.bind(X_2,"sys","household","mv",0); | | X_720:bat[:oid,:int] := sql.bind(X_2,"sys","household","mv",2); | | X_722 := algebra.kdifference(X_717,X_720); | | X_723 := algebra.kunion(X_722,X_720); | | X_724:bat[:oid,:int] := sql.bind(X_2,"sys","household","mv",1); | | X_726 := algebra.kunion(X_723,X_724); | | X_728 := algebra.kdifference(X_726,X_680); | | X_729 := algebra.leftjoin(X_19,X_728); | | X_730:bat[:oid,:int] := sql.bind(X_2,"sys","household","noc",0); | | X_733:bat[:oid,:int] := sql.bind(X_2,"sys","household","noc",2); | | X_734 := algebra.kdifference(X_730,X_733); | | X_735 := algebra.kunion(X_734,X_733); | | X_736:bat[:oid,:int] := sql.bind(X_2,"sys","household","noc",1); | | X_737 := algebra.kunion(X_735,X_736); | | X_738 := algebra.kdifference(X_737,X_680); | | X_739 := algebra.leftjoin(X_19,X_738); | | X_740:bat[:oid,:int] := sql.bind(X_2,"sys","household","npf",0); | | X_743:bat[:oid,:int] := sql.bind(X_2,"sys","household","npf",2); | | X_745 := algebra.kdifference(X_740,X_743); | | X_746 := algebra.kunion(X_745,X_743); | | X_747:bat[:oid,:int] := sql.bind(X_2,"sys","household","npf",1); | | X_750 := algebra.kunion(X_746,X_747); | | X_751 := algebra.kdifference(X_750,X_680); | | X_752 := algebra.leftjoin(X_19,X_751); | | X_753:bat[:oid,:int] := sql.bind(X_2,"sys","household","npp",0); | | X_756:bat[:oid,:int] := sql.bind(X_2,"sys","household","npp",2); | | X_757 := algebra.kdifference(X_753,X_756); | | X_758 := algebra.kunion(X_757,X_756); | | X_759:bat[:oid,:int] := sql.bind(X_2,"sys","household","npp",1); | | X_760 := algebra.kunion(X_758,X_759); | | X_761 := algebra.kdifference(X_760,X_680); | | X_762 := algebra.leftjoin(X_19,X_761); | | X_763:bat[:oid,:int] := sql.bind(X_2,"sys","household","nr",0); | | X_766:bat[:oid,:int] := sql.bind(X_2,"sys","household","nr",2); | | X_769 := algebra.kdifference(X_763,X_766); | | X_770 := algebra.kunion(X_769,X_766); | | X_771:bat[:oid,:int] := sql.bind(X_2,"sys","household","nr",1); | | X_773 := algebra.kunion(X_770,X_771); | | X_774:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_775 := bat.reverse(X_774); | | X_776 := algebra.kdifference(X_773,X_775); | | X_777 := algebra.leftjoin(X_19,X_776); | | X_778:bat[:oid,:int] := sql.bind(X_2,"sys","household","nrc",0); | | X_781:bat[:oid,:int] := sql.bind(X_2,"sys","household","nrc",2); | | X_782 := algebra.kdifference(X_778,X_781); | | X_783 := algebra.kunion(X_782,X_781); | | X_784:bat[:oid,:int] := sql.bind(X_2,"sys","household","nrc",1); | | X_785 := algebra.kunion(X_783,X_784); | | X_786 := algebra.kdifference(X_785,X_775); | | X_787 := algebra.leftjoin(X_19,X_786); | | X_789:bat[:oid,:int] := sql.bind(X_2,"sys","household","ocpip",0); | | X_792:bat[:oid,:int] := sql.bind(X_2,"sys","household","ocpip",2); | | X_794 := algebra.kdifference(X_789,X_792); | | X_795 := algebra.kunion(X_794,X_792); | | X_796:bat[:oid,:int] := sql.bind(X_2,"sys","household","ocpip",1); | | X_798 := algebra.kunion(X_795,X_796); | | X_799 := algebra.kdifference(X_798,X_775); | | X_800 := algebra.leftjoin(X_19,X_799); | | X_801:bat[:oid,:int] := sql.bind(X_2,"sys","household","partner",0); | | X_804:bat[:oid,:int] := sql.bind(X_2,"sys","household","partner",2); | | X_805 := algebra.kdifference(X_801,X_804); | | X_806 := algebra.kunion(X_805,X_804); | | X_807:bat[:oid,:int] := sql.bind(X_2,"sys","household","partner",1); | | X_808 := algebra.kunion(X_806,X_807); | | X_809 := algebra.kdifference(X_808,X_775); | | X_811 := algebra.leftjoin(X_19,X_809); | | X_812:bat[:oid,:int] := sql.bind(X_2,"sys","household","plm",0); | | X_815:bat[:oid,:int] := sql.bind(X_2,"sys","household","plm",2); | | X_817 := algebra.kdifference(X_812,X_815); | | X_818 := algebra.kunion(X_817,X_815); | | X_819:bat[:oid,:int] := sql.bind(X_2,"sys","household","plm",1); | | X_821 := algebra.kunion(X_818,X_819); | | X_822 := algebra.kdifference(X_821,X_775); | | X_823 := algebra.leftjoin(X_19,X_822); | | X_824:bat[:oid,:int] := sql.bind(X_2,"sys","household","psf",0); | | X_827:bat[:oid,:int] := sql.bind(X_2,"sys","household","psf",2); | | X_828 := algebra.kdifference(X_824,X_827); | | X_829 := algebra.kunion(X_828,X_827); | | X_830:bat[:oid,:int] := sql.bind(X_2,"sys","household","psf",1); | | X_832 := algebra.kunion(X_829,X_830); | | X_833 := algebra.kdifference(X_832,X_775); | | X_834 := algebra.leftjoin(X_19,X_833); | | X_835:bat[:oid,:int] := sql.bind(X_2,"sys","household","r18",0); | | X_838:bat[:oid,:int] := sql.bind(X_2,"sys","household","r18",2); | | X_840 := algebra.kdifference(X_835,X_838); | | X_841 := algebra.kunion(X_840,X_838); | | X_842:bat[:oid,:int] := sql.bind(X_2,"sys","household","r18",1); | | X_844 := algebra.kunion(X_841,X_842); | | X_845 := algebra.kdifference(X_844,X_775); | | X_846 := algebra.leftjoin(X_19,X_845); | | X_847:bat[:oid,:int] := sql.bind(X_2,"sys","household","r60",0); | | X_851:bat[:oid,:int] := sql.bind(X_2,"sys","household","r60",2); | | X_852 := algebra.kdifference(X_847,X_851); | | X_853 := algebra.kunion(X_852,X_851); | | X_854:bat[:oid,:int] := sql.bind(X_2,"sys","household","r60",1); | | X_855 := algebra.kunion(X_853,X_854); | | X_856 := algebra.kdifference(X_855,X_775); | | X_857 := algebra.leftjoin(X_19,X_856); | | X_858:bat[:oid,:int] := sql.bind(X_2,"sys","household","r65",0); | | X_861:bat[:oid,:int] := sql.bind(X_2,"sys","household","r65",2); | | X_863 := algebra.kdifference(X_858,X_861); | | X_864 := algebra.kunion(X_863,X_861); | | X_865:bat[:oid,:int] := sql.bind(X_2,"sys","household","r65",1); | | X_867 := algebra.kunion(X_864,X_865); | | X_868:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_869 := bat.reverse(X_868); | | X_870 := algebra.kdifference(X_867,X_869); | | X_872 := algebra.leftjoin(X_19,X_870); | | X_873:bat[:oid,:int] := sql.bind(X_2,"sys","household","resmode",0); | | X_876:bat[:oid,:int] := sql.bind(X_2,"sys","household","resmode",2); | | X_877 := algebra.kdifference(X_873,X_876); | | X_878 := algebra.kunion(X_877,X_876); | | X_879:bat[:oid,:int] := sql.bind(X_2,"sys","household","resmode",1); | | X_880 := algebra.kunion(X_878,X_879); | | X_881 := algebra.kdifference(X_880,X_869); | | X_882 := algebra.leftjoin(X_19,X_881); | | X_883:bat[:oid,:int] := sql.bind(X_2,"sys","household","smocp",0); | | X_886:bat[:oid,:int] := sql.bind(X_2,"sys","household","smocp",2); | | X_888 := algebra.kdifference(X_883,X_886); | | X_889 := algebra.kunion(X_888,X_886); | | X_890:bat[:oid,:int] := sql.bind(X_2,"sys","household","smocp",1); | | X_892 := algebra.kunion(X_889,X_890); | | X_894 := algebra.kdifference(X_892,X_869); | | X_895 := algebra.leftjoin(X_19,X_894); | | X_896:bat[:oid,:int] := sql.bind(X_2,"sys","household","smx",0); | | X_899:bat[:oid,:int] := sql.bind(X_2,"sys","household","smx",2); | | X_900 := algebra.kdifference(X_896,X_899); | | X_901 := algebra.kunion(X_900,X_899); | | X_902:bat[:oid,:int] := sql.bind(X_2,"sys","household","smx",1); | | X_903 := algebra.kunion(X_901,X_902); | | X_904 := algebra.kdifference(X_903,X_869); | | X_905 := algebra.leftjoin(X_19,X_904); | | X_906:bat[:oid,:int] := sql.bind(X_2,"sys","household","srnt",0); | | X_909:bat[:oid,:int] := sql.bind(X_2,"sys","household","srnt",2); | | X_911 := algebra.kdifference(X_906,X_909); | | X_912 := algebra.kunion(X_911,X_909); | | X_913:bat[:oid,:int] := sql.bind(X_2,"sys","household","srnt",1); | | X_916 := algebra.kunion(X_912,X_913); | | X_917 := algebra.kdifference(X_916,X_869); | | X_918 := algebra.leftjoin(X_19,X_917); | | X_919:bat[:oid,:int] := sql.bind(X_2,"sys","household","sval",0); | | X_922:bat[:oid,:int] := sql.bind(X_2,"sys","household","sval",2); | | X_923 := algebra.kdifference(X_919,X_922); | | X_924 := algebra.kunion(X_923,X_922); | | X_925:bat[:oid,:int] := sql.bind(X_2,"sys","household","sval",1); | | X_926 := algebra.kunion(X_924,X_925); | | X_927 := algebra.kdifference(X_926,X_869); | | X_928 := algebra.leftjoin(X_19,X_927); | | X_929:bat[:oid,:int] := sql.bind(X_2,"sys","household","taxp",0); | | X_932:bat[:oid,:int] := sql.bind(X_2,"sys","household","taxp",2); | | X_935 := algebra.kdifference(X_929,X_932); | | X_936 := algebra.kunion(X_935,X_932); | | X_937:bat[:oid,:int] := sql.bind(X_2,"sys","household","taxp",1); | | X_939 := algebra.kunion(X_936,X_937); | | X_940 := algebra.kdifference(X_939,X_869); | | X_941 := algebra.leftjoin(X_19,X_940); | | X_942:bat[:oid,:int] := sql.bind(X_2,"sys","household","wif",0); | | X_945:bat[:oid,:int] := sql.bind(X_2,"sys","household","wif",2); | | X_946 := algebra.kdifference(X_942,X_945); | | X_947 := algebra.kunion(X_946,X_945); | | X_948:bat[:oid,:int] := sql.bind(X_2,"sys","household","wif",1); | | X_949 := algebra.kunion(X_947,X_948); | | X_950 := algebra.kdifference(X_949,X_869); | | X_951 := algebra.leftjoin(X_19,X_950); | | X_953:bat[:oid,:int] := sql.bind(X_2,"sys","household","wkexrel",0); | | X_956:bat[:oid,:int] := sql.bind(X_2,"sys","household","wkexrel",2); | | X_958 := algebra.kdifference(X_953,X_956); | | X_959 := algebra.kunion(X_958,X_956); | | X_960:bat[:oid,:int] := sql.bind(X_2,"sys","household","wkexrel",1); | | X_962 := algebra.kunion(X_959,X_960); | | X_963:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_964 := bat.reverse(X_963); | | X_965 := algebra.kdifference(X_962,X_964); | | X_966 := algebra.leftjoin(X_19,X_965); | | X_967:bat[:oid,:int] := sql.bind(X_2,"sys","household","workstat",0); | | X_970:bat[:oid,:int] := sql.bind(X_2,"sys","household","workstat",2); | | X_971 := algebra.kdifference(X_967,X_970); | | X_972 := algebra.kunion(X_971,X_970); | | X_973:bat[:oid,:int] := sql.bind(X_2,"sys","household","workstat",1); | | X_974 := algebra.kunion(X_972,X_973); | | X_975 := algebra.kdifference(X_974,X_964); | | X_977 := algebra.leftjoin(X_19,X_975); | | X_978:bat[:oid,:int] := sql.bind(X_2,"sys","household","facrp",0); | | X_981:bat[:oid,:int] := sql.bind(X_2,"sys","household","facrp",2); | | X_983 := algebra.kdifference(X_978,X_981); | | X_984 := algebra.kunion(X_983,X_981); | | X_985:bat[:oid,:int] := sql.bind(X_2,"sys","household","facrp",1); | | X_987 := algebra.kunion(X_984,X_985); | | X_988 := algebra.kdifference(X_987,X_964); | | X_989 := algebra.leftjoin(X_19,X_988); | | X_990:bat[:oid,:int] := sql.bind(X_2,"sys","household","fagsp",0); | | X_993:bat[:oid,:int] := sql.bind(X_2,"sys","household","fagsp",2); | | X_994 := algebra.kdifference(X_990,X_993); | | X_995 := algebra.kunion(X_994,X_993); | | X_996:bat[:oid,:int] := sql.bind(X_2,"sys","household","fagsp",1); | | X_998 := algebra.kunion(X_995,X_996); | | X_999 := algebra.kdifference(X_998,X_964); | | X_1000 := algebra.leftjoin(X_19,X_999); | | X_1001:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbathp",0); | | X_1004:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbathp",2); | | X_1006 := algebra.kdifference(X_1001,X_1004); | | X_1007 := algebra.kunion(X_1006,X_1004); | | X_1008:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbathp",1); | | X_1010 := algebra.kunion(X_1007,X_1008); | | X_1011 := algebra.kdifference(X_1010,X_964); | | X_1012 := algebra.leftjoin(X_19,X_1011); | | X_1013:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbdsp",0); | | X_1017:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbdsp",2); | | X_1018 := algebra.kdifference(X_1013,X_1017); | | X_1019 := algebra.kunion(X_1018,X_1017); | | X_1020:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbdsp",1); | | X_1021 := algebra.kunion(X_1019,X_1020); | | X_1022 := algebra.kdifference(X_1021,X_964); | | X_1023 := algebra.leftjoin(X_19,X_1022); | | X_1024:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbldp",0); | | X_1027:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbldp",2); | | X_1029 := algebra.kdifference(X_1024,X_1027); | | X_1030 := algebra.kunion(X_1029,X_1027); | | X_1031:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbldp",1); | | X_1033 := algebra.kunion(X_1030,X_1031); | | X_1034 := algebra.kdifference(X_1033,X_964); | | X_1036 := algebra.leftjoin(X_19,X_1034); | | X_1037:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbusp",0); | | X_1040:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbusp",2); | | X_1041 := algebra.kdifference(X_1037,X_1040); | | X_1042 := algebra.kunion(X_1041,X_1040); | | X_1043:bat[:oid,:int] := sql.bind(X_2,"sys","household","fbusp",1); | | X_1044 := algebra.kunion(X_1042,X_1043); | | X_1045 := algebra.kdifference(X_1044,X_964); | | X_1046 := algebra.leftjoin(X_19,X_1045); | | X_1047:bat[:oid,:int] := sql.bind(X_2,"sys","household","fconp",0); | | X_1050:bat[:oid,:int] := sql.bind(X_2,"sys","household","fconp",2); | | X_1052 := algebra.kdifference(X_1047,X_1050); | | X_1053 := algebra.kunion(X_1052,X_1050); | | X_1054:bat[:oid,:int] := sql.bind(X_2,"sys","household","fconp",1); | | X_1056 := algebra.kunion(X_1053,X_1054); | | X_1057:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1059 := bat.reverse(X_1057); | | X_1060 := algebra.kdifference(X_1056,X_1059); | | X_1061 := algebra.leftjoin(X_19,X_1060); | | X_1062:bat[:oid,:int] := sql.bind(X_2,"sys","household","felep",0); | | X_1065:bat[:oid,:int] := sql.bind(X_2,"sys","household","felep",2); | | X_1066 := algebra.kdifference(X_1062,X_1065); | | X_1067 := algebra.kunion(X_1066,X_1065); | | X_1068:bat[:oid,:int] := sql.bind(X_2,"sys","household","felep",1); | | X_1069 := algebra.kunion(X_1067,X_1068); | | X_1070 := algebra.kdifference(X_1069,X_1059); | | X_1071 := algebra.leftjoin(X_19,X_1070); | | X_1072:bat[:oid,:int] := sql.bind(X_2,"sys","household","ffsp",0); | | X_1075:bat[:oid,:int] := sql.bind(X_2,"sys","household","ffsp",2); | | X_1077 := algebra.kdifference(X_1072,X_1075); | | X_1078 := algebra.kunion(X_1077,X_1075); | | X_1079:bat[:oid,:int] := sql.bind(X_2,"sys","household","ffsp",1); | | X_1082 := algebra.kunion(X_1078,X_1079); | | X_1083 := algebra.kdifference(X_1082,X_1059); | | X_1084 := algebra.leftjoin(X_19,X_1083); | | X_1085:bat[:oid,:int] := sql.bind(X_2,"sys","household","ffulp",0); | | X_1088:bat[:oid,:int] := sql.bind(X_2,"sys","household","ffulp",2); | | X_1089 := algebra.kdifference(X_1085,X_1088); | | X_1090 := algebra.kunion(X_1089,X_1088); | | X_1091:bat[:oid,:int] := sql.bind(X_2,"sys","household","ffulp",1); | | X_1092 := algebra.kunion(X_1090,X_1091); | | X_1093 := algebra.kdifference(X_1092,X_1059); | | X_1094 := algebra.leftjoin(X_19,X_1093); | | X_1095:bat[:oid,:int] := sql.bind(X_2,"sys","household","fgasp",0); | | X_1098:bat[:oid,:int] := sql.bind(X_2,"sys","household","fgasp",2); | | X_1101 := algebra.kdifference(X_1095,X_1098); | | X_1102 := algebra.kunion(X_1101,X_1098); | | X_1103:bat[:oid,:int] := sql.bind(X_2,"sys","household","fgasp",1); | | X_1105 := algebra.kunion(X_1102,X_1103); | | X_1106 := algebra.kdifference(X_1105,X_1059); | | X_1107 := algebra.leftjoin(X_19,X_1106); | | X_1108:bat[:oid,:int] := sql.bind(X_2,"sys","household","fhflp",0); | | X_1111:bat[:oid,:int] := sql.bind(X_2,"sys","household","fhflp",2); | | X_1112 := algebra.kdifference(X_1108,X_1111); | | X_1113 := algebra.kunion(X_1112,X_1111); | | X_1114:bat[:oid,:int] := sql.bind(X_2,"sys","household","fhflp",1); | | X_1115 := algebra.kunion(X_1113,X_1114); | | X_1116 := algebra.kdifference(X_1115,X_1059); | | X_1117 := algebra.leftjoin(X_19,X_1116); | | X_1119:bat[:oid,:int] := sql.bind(X_2,"sys","household","finsp",0); | | X_1122:bat[:oid,:int] := sql.bind(X_2,"sys","household","finsp",2); | | X_1124 := algebra.kdifference(X_1119,X_1122); | | X_1125 := algebra.kunion(X_1124,X_1122); | | X_1126:bat[:oid,:int] := sql.bind(X_2,"sys","household","finsp",1); | | X_1128 := algebra.kunion(X_1125,X_1126); | | X_1129 := algebra.kdifference(X_1128,X_1059); | | X_1130 := algebra.leftjoin(X_19,X_1129); | | X_1131:bat[:oid,:int] := sql.bind(X_2,"sys","household","fkitp",0); | | X_1134:bat[:oid,:int] := sql.bind(X_2,"sys","household","fkitp",2); | | X_1135 := algebra.kdifference(X_1131,X_1134); | | X_1136 := algebra.kunion(X_1135,X_1134); | | X_1137:bat[:oid,:int] := sql.bind(X_2,"sys","household","fkitp",1); | | X_1138 := algebra.kunion(X_1136,X_1137); | | X_1139 := algebra.kdifference(X_1138,X_1059); | | X_1141 := algebra.leftjoin(X_19,X_1139); | | X_1142:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmhp",0); | | X_1145:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmhp",2); | | X_1147 := algebra.kdifference(X_1142,X_1145); | | X_1148 := algebra.kunion(X_1147,X_1145); | | X_1149:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmhp",1); | | X_1151 := algebra.kunion(X_1148,X_1149); | | X_1152:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1153 := bat.reverse(X_1152); | | X_1154 := algebra.kdifference(X_1151,X_1153); | | X_1155 := algebra.leftjoin(X_19,X_1154); | | X_1156:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgip",0); | | X_1159:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgip",2); | | X_1160 := algebra.kdifference(X_1156,X_1159); | | X_1161 := algebra.kunion(X_1160,X_1159); | | X_1162:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgip",1); | | X_1164 := algebra.kunion(X_1161,X_1162); | | X_1165 := algebra.kdifference(X_1164,X_1153); | | X_1166 := algebra.leftjoin(X_19,X_1165); | | X_1167:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgp",0); | | X_1170:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgp",2); | | X_1172 := algebra.kdifference(X_1167,X_1170); | | X_1173 := algebra.kunion(X_1172,X_1170); | | X_1174:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgp",1); | | X_1176 := algebra.kunion(X_1173,X_1174); | | X_1177 := algebra.kdifference(X_1176,X_1153); | | X_1178 := algebra.leftjoin(X_19,X_1177); | | X_1179:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgtp",0); | | X_1183:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgtp",2); | | X_1184 := algebra.kdifference(X_1179,X_1183); | | X_1185 := algebra.kunion(X_1184,X_1183); | | X_1186:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgtp",1); | | X_1187 := algebra.kunion(X_1185,X_1186); | | X_1188 := algebra.kdifference(X_1187,X_1153); | | X_1189 := algebra.leftjoin(X_19,X_1188); | | X_1190:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgxp",0); | | X_1193:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgxp",2); | | X_1195 := algebra.kdifference(X_1190,X_1193); | | X_1196 := algebra.kunion(X_1195,X_1193); | | X_1197:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmrgxp",1); | | X_1199 := algebra.kunion(X_1196,X_1197); | | X_1200 := algebra.kdifference(X_1199,X_1153); | | X_1202 := algebra.leftjoin(X_19,X_1200); | | X_1203:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmvp",0); | | X_1206:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmvp",2); | | X_1207 := algebra.kdifference(X_1203,X_1206); | | X_1208 := algebra.kunion(X_1207,X_1206); | | X_1209:bat[:oid,:int] := sql.bind(X_2,"sys","household","fmvp",1); | | X_1210 := algebra.kunion(X_1208,X_1209); | | X_1211 := algebra.kdifference(X_1210,X_1153); | | X_1212 := algebra.leftjoin(X_19,X_1211); | | X_1213:bat[:oid,:int] := sql.bind(X_2,"sys","household","fplmp",0); | | X_1216:bat[:oid,:int] := sql.bind(X_2,"sys","household","fplmp",2); | | X_1218 := algebra.kdifference(X_1213,X_1216); | | X_1219 := algebra.kunion(X_1218,X_1216); | | X_1220:bat[:oid,:int] := sql.bind(X_2,"sys","household","fplmp",1); | | X_1222 := algebra.kunion(X_1219,X_1220); | | X_1224 := algebra.kdifference(X_1222,X_1153); | | X_1225 := algebra.leftjoin(X_19,X_1224); | | X_1226:bat[:oid,:int] := sql.bind(X_2,"sys","household","frefrp",0); | | X_1229:bat[:oid,:int] := sql.bind(X_2,"sys","household","frefrp",2); | | X_1230 := algebra.kdifference(X_1226,X_1229); | | X_1231 := algebra.kunion(X_1230,X_1229); | | X_1232:bat[:oid,:int] := sql.bind(X_2,"sys","household","frefrp",1); | | X_1233 := algebra.kunion(X_1231,X_1232); | | X_1234 := algebra.kdifference(X_1233,X_1153); | | X_1235 := algebra.leftjoin(X_19,X_1234); | | X_1236:bat[:oid,:int] := sql.bind(X_2,"sys","household","frmsp",0); | | X_1239:bat[:oid,:int] := sql.bind(X_2,"sys","household","frmsp",2); | | X_1241 := algebra.kdifference(X_1236,X_1239); | | X_1242 := algebra.kunion(X_1241,X_1239); | | X_1243:bat[:oid,:int] := sql.bind(X_2,"sys","household","frmsp",1); | | X_1246 := algebra.kunion(X_1242,X_1243); | | X_1247:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1248 := bat.reverse(X_1247); | | X_1249 := algebra.kdifference(X_1246,X_1248); | | X_1250 := algebra.leftjoin(X_19,X_1249); | | X_1251:bat[:oid,:int] := sql.bind(X_2,"sys","household","frntmp",0); | | X_1254:bat[:oid,:int] := sql.bind(X_2,"sys","household","frntmp",2); | | X_1255 := algebra.kdifference(X_1251,X_1254); | | X_1256 := algebra.kunion(X_1255,X_1254); | | X_1257:bat[:oid,:int] := sql.bind(X_2,"sys","household","frntmp",1); | | X_1258 := algebra.kunion(X_1256,X_1257); | | X_1259 := algebra.kdifference(X_1258,X_1248); | | X_1260 := algebra.leftjoin(X_19,X_1259); | | X_1261:bat[:oid,:int] := sql.bind(X_2,"sys","household","frntp",0); | | X_1264:bat[:oid,:int] := sql.bind(X_2,"sys","household","frntp",2); | | X_1267 := algebra.kdifference(X_1261,X_1264); | | X_1268 := algebra.kunion(X_1267,X_1264); | | X_1269:bat[:oid,:int] := sql.bind(X_2,"sys","household","frntp",1); | | X_1271 := algebra.kunion(X_1268,X_1269); | | X_1272 := algebra.kdifference(X_1271,X_1248); | | X_1273 := algebra.leftjoin(X_19,X_1272); | | X_1274:bat[:oid,:int] := sql.bind(X_2,"sys","household","frwatp",0); | | X_1277:bat[:oid,:int] := sql.bind(X_2,"sys","household","frwatp",2); | | X_1278 := algebra.kdifference(X_1274,X_1277); | | X_1279 := algebra.kunion(X_1278,X_1277); | | X_1280:bat[:oid,:int] := sql.bind(X_2,"sys","household","frwatp",1); | | X_1281 := algebra.kunion(X_1279,X_1280); | | X_1282 := algebra.kdifference(X_1281,X_1248); | | X_1283 := algebra.leftjoin(X_19,X_1282); | | X_1285:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsinkp",0); | | X_1288:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsinkp",2); | | X_1290 := algebra.kdifference(X_1285,X_1288); | | X_1291 := algebra.kunion(X_1290,X_1288); | | X_1292:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsinkp",1); | | X_1294 := algebra.kunion(X_1291,X_1292); | | X_1295 := algebra.kdifference(X_1294,X_1248); | | X_1296 := algebra.leftjoin(X_19,X_1295); | | X_1297:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsmp",0); | | X_1300:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsmp",2); | | X_1301 := algebra.kdifference(X_1297,X_1300); | | X_1302 := algebra.kunion(X_1301,X_1300); | | X_1303:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsmp",1); | | X_1304 := algebra.kunion(X_1302,X_1303); | | X_1305 := algebra.kdifference(X_1304,X_1248); | | X_1307 := algebra.leftjoin(X_19,X_1305); | | X_1308:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsmxhp",0); | | X_1311:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsmxhp",2); | | X_1313 := algebra.kdifference(X_1308,X_1311); | | X_1314 := algebra.kunion(X_1313,X_1311); | | X_1315:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsmxhp",1); | | X_1317 := algebra.kunion(X_1314,X_1315); | | X_1318 := algebra.kdifference(X_1317,X_1248); | | X_1319 := algebra.leftjoin(X_19,X_1318); | | X_1320:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsmxsp",0); | | X_1323:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsmxsp",2); | | X_1324 := algebra.kdifference(X_1320,X_1323); | | X_1325 := algebra.kunion(X_1324,X_1323); | | X_1326:bat[:oid,:int] := sql.bind(X_2,"sys","household","fsmxsp",1); | | X_1328 := algebra.kunion(X_1325,X_1326); | | X_1329 := algebra.kdifference(X_1328,X_1248); | | X_1330 := algebra.leftjoin(X_19,X_1329); | | X_1331:bat[:oid,:int] := sql.bind(X_2,"sys","household","fstovp",0); | | X_1334:bat[:oid,:int] := sql.bind(X_2,"sys","household","fstovp",2); | | X_1336 := algebra.kdifference(X_1331,X_1334); | | X_1337 := algebra.kunion(X_1336,X_1334); | | X_1338:bat[:oid,:int] := sql.bind(X_2,"sys","household","fstovp",1); | | X_1340 := algebra.kunion(X_1337,X_1338); | | X_1341:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1342 := bat.reverse(X_1341); | | X_1343 := algebra.kdifference(X_1340,X_1342); | | X_1344 := algebra.leftjoin(X_19,X_1343); | | X_1345:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftaxp",0); | | X_1349:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftaxp",2); | | X_1350 := algebra.kdifference(X_1345,X_1349); | | X_1351 := algebra.kunion(X_1350,X_1349); | | X_1352:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftaxp",1); | | X_1353 := algebra.kunion(X_1351,X_1352); | | X_1354 := algebra.kdifference(X_1353,X_1342); | | X_1355 := algebra.leftjoin(X_19,X_1354); | | X_1356:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftelp",0); | | X_1359:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftelp",2); | | X_1361 := algebra.kdifference(X_1356,X_1359); | | X_1362 := algebra.kunion(X_1361,X_1359); | | X_1363:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftelp",1); | | X_1365 := algebra.kunion(X_1362,X_1363); | | X_1366 := algebra.kdifference(X_1365,X_1342); | | X_1368 := algebra.leftjoin(X_19,X_1366); | | X_1369:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftenp",0); | | X_1372:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftenp",2); | | X_1373 := algebra.kdifference(X_1369,X_1372); | | X_1374 := algebra.kunion(X_1373,X_1372); | | X_1375:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftenp",1); | | X_1376 := algebra.kunion(X_1374,X_1375); | | X_1377 := algebra.kdifference(X_1376,X_1342); | | X_1378 := algebra.leftjoin(X_19,X_1377); | | X_1379:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftoilp",0); | | X_1382:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftoilp",2); | | X_1384 := algebra.kdifference(X_1379,X_1382); | | X_1385 := algebra.kunion(X_1384,X_1382); | | X_1386:bat[:oid,:int] := sql.bind(X_2,"sys","household","ftoilp",1); | | X_1388 := algebra.kunion(X_1385,X_1386); | | X_1390 := algebra.kdifference(X_1388,X_1342); | | X_1391 := algebra.leftjoin(X_19,X_1390); | | X_1392:bat[:oid,:int] := sql.bind(X_2,"sys","household","fvacsp",0); | | X_1395:bat[:oid,:int] := sql.bind(X_2,"sys","household","fvacsp",2); | | X_1396 := algebra.kdifference(X_1392,X_1395); | | X_1397 := algebra.kunion(X_1396,X_1395); | | X_1398:bat[:oid,:int] := sql.bind(X_2,"sys","household","fvacsp",1); | | X_1399 := algebra.kunion(X_1397,X_1398); | | X_1400 := algebra.kdifference(X_1399,X_1342); | | X_1401 := algebra.leftjoin(X_19,X_1400); | | X_1402:bat[:oid,:int] := sql.bind(X_2,"sys","household","fvalp",0); | | X_1405:bat[:oid,:int] := sql.bind(X_2,"sys","household","fvalp",2); | | X_1407 := algebra.kdifference(X_1402,X_1405); | | X_1408 := algebra.kunion(X_1407,X_1405); | | X_1409:bat[:oid,:int] := sql.bind(X_2,"sys","household","fvalp",1); | | X_1412 := algebra.kunion(X_1408,X_1409); | | X_1413 := algebra.kdifference(X_1412,X_1342); | | X_1414 := algebra.leftjoin(X_19,X_1413); | | X_1415:bat[:oid,:int] := sql.bind(X_2,"sys","household","fvehp",0); | | X_1418:bat[:oid,:int] := sql.bind(X_2,"sys","household","fvehp",2); | | X_1419 := algebra.kdifference(X_1415,X_1418); | | X_1420 := algebra.kunion(X_1419,X_1418); | | X_1421:bat[:oid,:int] := sql.bind(X_2,"sys","household","fvehp",1); | | X_1422 := algebra.kunion(X_1420,X_1421); | | X_1423 := algebra.kdifference(X_1422,X_1342); | | X_1424 := algebra.leftjoin(X_19,X_1423); | | X_1425:bat[:oid,:int] := sql.bind(X_2,"sys","household","fwatp",0); | | X_1428:bat[:oid,:int] := sql.bind(X_2,"sys","household","fwatp",2); | | X_1431 := algebra.kdifference(X_1425,X_1428); | | X_1432 := algebra.kunion(X_1431,X_1428); | | X_1433:bat[:oid,:int] := sql.bind(X_2,"sys","household","fwatp",1); | | X_1435 := algebra.kunion(X_1432,X_1433); | | X_1436:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1437 := bat.reverse(X_1436); | | X_1438 := algebra.kdifference(X_1435,X_1437); | | X_1439 := algebra.leftjoin(X_19,X_1438); | | X_1440:bat[:oid,:int] := sql.bind(X_2,"sys","household","fyblp",0); | | X_1443:bat[:oid,:int] := sql.bind(X_2,"sys","household","fyblp",2); | | X_1444 := algebra.kdifference(X_1440,X_1443); | | X_1445 := algebra.kunion(X_1444,X_1443); | | X_1446:bat[:oid,:int] := sql.bind(X_2,"sys","household","fyblp",1); | | X_1447 := algebra.kunion(X_1445,X_1446); | | X_1448 := algebra.kdifference(X_1447,X_1437); | | X_1449 := algebra.leftjoin(X_19,X_1448); | | X_1451:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp1",0); | | X_1454:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp1",2); | | X_1456 := algebra.kdifference(X_1451,X_1454); | | X_1457 := algebra.kunion(X_1456,X_1454); | | X_1458:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp1",1); | | X_1460 := algebra.kunion(X_1457,X_1458); | | X_1461 := algebra.kdifference(X_1460,X_1437); | | X_1462 := algebra.leftjoin(X_19,X_1461); | | X_1463:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp2",0); | | X_1466:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp2",2); | | X_1467 := algebra.kdifference(X_1463,X_1466); | | X_1468 := algebra.kunion(X_1467,X_1466); | | X_1469:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp2",1); | | X_1470 := algebra.kunion(X_1468,X_1469); | | X_1471 := algebra.kdifference(X_1470,X_1437); | | X_1473 := algebra.leftjoin(X_19,X_1471); | | X_1474:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp3",0); | | X_1477:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp3",2); | | X_1479 := algebra.kdifference(X_1474,X_1477); | | X_1480 := algebra.kunion(X_1479,X_1477); | | X_1481:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp3",1); | | X_1483 := algebra.kunion(X_1480,X_1481); | | X_1484 := algebra.kdifference(X_1483,X_1437); | | X_1485 := algebra.leftjoin(X_19,X_1484); | | X_1486:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp4",0); | | X_1489:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp4",2); | | X_1490 := algebra.kdifference(X_1486,X_1489); | | X_1491 := algebra.kunion(X_1490,X_1489); | | X_1492:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp4",1); | | X_1494 := algebra.kunion(X_1491,X_1492); | | X_1495 := algebra.kdifference(X_1494,X_1437); | | X_1496 := algebra.leftjoin(X_19,X_1495); | | X_1497:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp5",0); | | X_1500:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp5",2); | | X_1502 := algebra.kdifference(X_1497,X_1500); | | X_1503 := algebra.kunion(X_1502,X_1500); | | X_1504:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp5",1); | | X_1506 := algebra.kunion(X_1503,X_1504); | | X_1507 := algebra.kdifference(X_1506,X_1437); | | X_1508 := algebra.leftjoin(X_19,X_1507); | | X_1509:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp6",0); | | X_1513:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp6",2); | | X_1514 := algebra.kdifference(X_1509,X_1513); | | X_1515 := algebra.kunion(X_1514,X_1513); | | X_1516:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp6",1); | | X_1517 := algebra.kunion(X_1515,X_1516); | | X_1518 := algebra.kdifference(X_1517,X_1437); | | X_1519 := algebra.leftjoin(X_19,X_1518); | | X_1520:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp7",0); | | X_1523:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp7",2); | | X_1525 := algebra.kdifference(X_1520,X_1523); | | X_1526 := algebra.kunion(X_1525,X_1523); | | X_1527:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp7",1); | | X_1529 := algebra.kunion(X_1526,X_1527); | | X_1530:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1531 := bat.reverse(X_1530); | | X_1532 := algebra.kdifference(X_1529,X_1531); | | X_1534 := algebra.leftjoin(X_19,X_1532); | | X_1535:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp8",0); | | X_1538:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp8",2); | | X_1539 := algebra.kdifference(X_1535,X_1538); | | X_1540 := algebra.kunion(X_1539,X_1538); | | X_1541:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp8",1); | | X_1542 := algebra.kunion(X_1540,X_1541); | | X_1543 := algebra.kdifference(X_1542,X_1531); | | X_1544 := algebra.leftjoin(X_19,X_1543); | | X_1545:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp9",0); | | X_1548:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp9",2); | | X_1550 := algebra.kdifference(X_1545,X_1548); | | X_1551 := algebra.kunion(X_1550,X_1548); | | X_1552:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp9",1); | | X_1554 := algebra.kunion(X_1551,X_1552); | | X_1556 := algebra.kdifference(X_1554,X_1531); | | X_1557 := algebra.leftjoin(X_19,X_1556); | | X_1558:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp10",0); | | X_1561:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp10",2); | | X_1562 := algebra.kdifference(X_1558,X_1561); | | X_1563 := algebra.kunion(X_1562,X_1561); | | X_1564:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp10",1); | | X_1565 := algebra.kunion(X_1563,X_1564); | | X_1566 := algebra.kdifference(X_1565,X_1531); | | X_1567 := algebra.leftjoin(X_19,X_1566); | | X_1568:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp11",0); | | X_1571:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp11",2); | | X_1573 := algebra.kdifference(X_1568,X_1571); | | X_1574 := algebra.kunion(X_1573,X_1571); | | X_1575:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp11",1); | | X_1578 := algebra.kunion(X_1574,X_1575); | | X_1579 := algebra.kdifference(X_1578,X_1531); | | X_1580 := algebra.leftjoin(X_19,X_1579); | | X_1581:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp12",0); | | X_1584:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp12",2); | | X_1585 := algebra.kdifference(X_1581,X_1584); | | X_1586 := algebra.kunion(X_1585,X_1584); | | X_1587:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp12",1); | | X_1588 := algebra.kunion(X_1586,X_1587); | | X_1589 := algebra.kdifference(X_1588,X_1531); | | X_1590 := algebra.leftjoin(X_19,X_1589); | | X_1591:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp13",0); | | X_1594:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp13",2); | | X_1597 := algebra.kdifference(X_1591,X_1594); | | X_1598 := algebra.kunion(X_1597,X_1594); | | X_1599:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp13",1); | | X_1601 := algebra.kunion(X_1598,X_1599); | | X_1602 := algebra.kdifference(X_1601,X_1531); | | X_1603 := algebra.leftjoin(X_19,X_1602); | | X_1604:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp14",0); | | X_1607:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp14",2); | | X_1608 := algebra.kdifference(X_1604,X_1607); | | X_1609 := algebra.kunion(X_1608,X_1607); | | X_1610:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp14",1); | | X_1611 := algebra.kunion(X_1609,X_1610); | | X_1612 := algebra.kdifference(X_1611,X_1531); | | X_1613 := algebra.leftjoin(X_19,X_1612); | | X_1615:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp15",0); | | X_1618:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp15",2); | | X_1620 := algebra.kdifference(X_1615,X_1618); | | X_1621 := algebra.kunion(X_1620,X_1618); | | X_1622:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp15",1); | | X_1624 := algebra.kunion(X_1621,X_1622); | | X_1625:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1626 := bat.reverse(X_1625); | | X_1627 := algebra.kdifference(X_1624,X_1626); | | X_1628 := algebra.leftjoin(X_19,X_1627); | | X_1629:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp16",0); | | X_1632:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp16",2); | | X_1633 := algebra.kdifference(X_1629,X_1632); | | X_1634 := algebra.kunion(X_1633,X_1632); | | X_1635:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp16",1); | | X_1636 := algebra.kunion(X_1634,X_1635); | | X_1637 := algebra.kdifference(X_1636,X_1626); | | X_1639 := algebra.leftjoin(X_19,X_1637); | | X_1640:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp17",0); | | X_1643:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp17",2); | | X_1645 := algebra.kdifference(X_1640,X_1643); | | X_1646 := algebra.kunion(X_1645,X_1643); | | X_1647:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp17",1); | | X_1649 := algebra.kunion(X_1646,X_1647); | | X_1650 := algebra.kdifference(X_1649,X_1626); | | X_1651 := algebra.leftjoin(X_19,X_1650); | | X_1652:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp18",0); | | X_1655:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp18",2); | | X_1656 := algebra.kdifference(X_1652,X_1655); | | X_1657 := algebra.kunion(X_1656,X_1655); | | X_1658:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp18",1); | | X_1660 := algebra.kunion(X_1657,X_1658); | | X_1661 := algebra.kdifference(X_1660,X_1626); | | X_1662 := algebra.leftjoin(X_19,X_1661); | | X_1663:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp19",0); | | X_1666:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp19",2); | | X_1668 := algebra.kdifference(X_1663,X_1666); | | X_1669 := algebra.kunion(X_1668,X_1666); | | X_1670:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp19",1); | | X_1672 := algebra.kunion(X_1669,X_1670); | | X_1673 := algebra.kdifference(X_1672,X_1626); | | X_1674 := algebra.leftjoin(X_19,X_1673); | | X_1675:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp20",0); | | X_1679:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp20",2); | | X_1680 := algebra.kdifference(X_1675,X_1679); | | X_1681 := algebra.kunion(X_1680,X_1679); | | X_1682:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp20",1); | | X_1683 := algebra.kunion(X_1681,X_1682); | | X_1684 := algebra.kdifference(X_1683,X_1626); | | X_1685 := algebra.leftjoin(X_19,X_1684); | | X_1686:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp21",0); | | X_1689:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp21",2); | | X_1691 := algebra.kdifference(X_1686,X_1689); | | X_1692 := algebra.kunion(X_1691,X_1689); | | X_1693:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp21",1); | | X_1695 := algebra.kunion(X_1692,X_1693); | | X_1696 := algebra.kdifference(X_1695,X_1626); | | X_1698 := algebra.leftjoin(X_19,X_1696); | | X_1699:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp22",0); | | X_1702:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp22",2); | | X_1703 := algebra.kdifference(X_1699,X_1702); | | X_1704 := algebra.kunion(X_1703,X_1702); | | X_1705:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp22",1); | | X_1706 := algebra.kunion(X_1704,X_1705); | | X_1707 := algebra.kdifference(X_1706,X_1626); | | X_1708 := algebra.leftjoin(X_19,X_1707); | | X_1709:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp23",0); | | X_1712:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp23",2); | | X_1714 := algebra.kdifference(X_1709,X_1712); | | X_1715 := algebra.kunion(X_1714,X_1712); | | X_1716:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp23",1); | | X_1718 := algebra.kunion(X_1715,X_1716); | | X_1719:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1721 := bat.reverse(X_1719); | | X_1722 := algebra.kdifference(X_1718,X_1721); | | X_1723 := algebra.leftjoin(X_19,X_1722); | | X_1724:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp24",0); | | X_1727:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp24",2); | | X_1728 := algebra.kdifference(X_1724,X_1727); | | X_1729 := algebra.kunion(X_1728,X_1727); | | X_1730:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp24",1); | | X_1731 := algebra.kunion(X_1729,X_1730); | | X_1732 := algebra.kdifference(X_1731,X_1721); | | X_1733 := algebra.leftjoin(X_19,X_1732); | | X_1734:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp25",0); | | X_1737:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp25",2); | | X_1739 := algebra.kdifference(X_1734,X_1737); | | X_1740 := algebra.kunion(X_1739,X_1737); | | X_1741:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp25",1); | | X_1744 := algebra.kunion(X_1740,X_1741); | | X_1745 := algebra.kdifference(X_1744,X_1721); | | X_1746 := algebra.leftjoin(X_19,X_1745); | | X_1747:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp26",0); | | X_1750:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp26",2); | | X_1751 := algebra.kdifference(X_1747,X_1750); | | X_1752 := algebra.kunion(X_1751,X_1750); | | X_1753:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp26",1); | | X_1754 := algebra.kunion(X_1752,X_1753); | | X_1755 := algebra.kdifference(X_1754,X_1721); | | X_1756 := algebra.leftjoin(X_19,X_1755); | | X_1757:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp27",0); | | X_1760:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp27",2); | | X_1763 := algebra.kdifference(X_1757,X_1760); | | X_1764 := algebra.kunion(X_1763,X_1760); | | X_1765:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp27",1); | | X_1767 := algebra.kunion(X_1764,X_1765); | | X_1768 := algebra.kdifference(X_1767,X_1721); | | X_1769 := algebra.leftjoin(X_19,X_1768); | | X_1770:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp28",0); | | X_1773:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp28",2); | | X_1774 := algebra.kdifference(X_1770,X_1773); | | X_1775 := algebra.kunion(X_1774,X_1773); | | X_1776:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp28",1); | | X_1777 := algebra.kunion(X_1775,X_1776); | | X_1778 := algebra.kdifference(X_1777,X_1721); | | X_1779 := algebra.leftjoin(X_19,X_1778); | | X_1781:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp29",0); | | X_1784:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp29",2); | | X_1786 := algebra.kdifference(X_1781,X_1784); | | X_1787 := algebra.kunion(X_1786,X_1784); | | X_1788:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp29",1); | | X_1790 := algebra.kunion(X_1787,X_1788); | | X_1791 := algebra.kdifference(X_1790,X_1721); | | X_1792 := algebra.leftjoin(X_19,X_1791); | | X_1793:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp30",0); | | X_1796:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp30",2); | | X_1797 := algebra.kdifference(X_1793,X_1796); | | X_1798 := algebra.kunion(X_1797,X_1796); | | X_1799:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp30",1); | | X_1800 := algebra.kunion(X_1798,X_1799); | | X_1801 := algebra.kdifference(X_1800,X_1721); | | X_1803 := algebra.leftjoin(X_19,X_1801); | | X_1804:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp31",0); | | X_1807:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp31",2); | | X_1809 := algebra.kdifference(X_1804,X_1807); | | X_1810 := algebra.kunion(X_1809,X_1807); | | X_1811:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp31",1); | | X_1813 := algebra.kunion(X_1810,X_1811); | | X_1814:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1815 := bat.reverse(X_1814); | | X_1816 := algebra.kdifference(X_1813,X_1815); | | X_1817 := algebra.leftjoin(X_19,X_1816); | | X_1818:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp32",0); | | X_1821:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp32",2); | | X_1822 := algebra.kdifference(X_1818,X_1821); | | X_1823 := algebra.kunion(X_1822,X_1821); | | X_1824:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp32",1); | | X_1826 := algebra.kunion(X_1823,X_1824); | | X_1827 := algebra.kdifference(X_1826,X_1815); | | X_1828 := algebra.leftjoin(X_19,X_1827); | | X_1829:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp33",0); | | X_1832:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp33",2); | | X_1834 := algebra.kdifference(X_1829,X_1832); | | X_1835 := algebra.kunion(X_1834,X_1832); | | X_1836:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp33",1); | | X_1838 := algebra.kunion(X_1835,X_1836); | | X_1839 := algebra.kdifference(X_1838,X_1815); | | X_1840 := algebra.leftjoin(X_19,X_1839); | | X_1841:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp34",0); | | X_1845:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp34",2); | | X_1846 := algebra.kdifference(X_1841,X_1845); | | X_1847 := algebra.kunion(X_1846,X_1845); | | X_1848:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp34",1); | | X_1849 := algebra.kunion(X_1847,X_1848); | | X_1850 := algebra.kdifference(X_1849,X_1815); | | X_1851 := algebra.leftjoin(X_19,X_1850); | | X_1852:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp35",0); | | X_1855:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp35",2); | | X_1857 := algebra.kdifference(X_1852,X_1855); | | X_1858 := algebra.kunion(X_1857,X_1855); | | X_1859:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp35",1); | | X_1861 := algebra.kunion(X_1858,X_1859); | | X_1862 := algebra.kdifference(X_1861,X_1815); | | X_1864 := algebra.leftjoin(X_19,X_1862); | | X_1865:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp36",0); | | X_1868:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp36",2); | | X_1869 := algebra.kdifference(X_1865,X_1868); | | X_1870 := algebra.kunion(X_1869,X_1868); | | X_1871:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp36",1); | | X_1872 := algebra.kunion(X_1870,X_1871); | | X_1873 := algebra.kdifference(X_1872,X_1815); | | X_1874 := algebra.leftjoin(X_19,X_1873); | | X_1875:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp37",0); | | X_1878:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp37",2); | | X_1880 := algebra.kdifference(X_1875,X_1878); | | X_1881 := algebra.kunion(X_1880,X_1878); | | X_1882:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp37",1); | | X_1884 := algebra.kunion(X_1881,X_1882); | | X_1886 := algebra.kdifference(X_1884,X_1815); | | X_1887 := algebra.leftjoin(X_19,X_1886); | | X_1888:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp38",0); | | X_1891:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp38",2); | | X_1892 := algebra.kdifference(X_1888,X_1891); | | X_1893 := algebra.kunion(X_1892,X_1891); | | X_1894:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp38",1); | | X_1895 := algebra.kunion(X_1893,X_1894); | | X_1896 := algebra.kdifference(X_1895,X_1815); | | X_1897 := algebra.leftjoin(X_19,X_1896); | | X_1898:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp39",0); | | X_1901:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp39",2); | | X_1903 := algebra.kdifference(X_1898,X_1901); | | X_1904 := algebra.kunion(X_1903,X_1901); | | X_1905:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp39",1); | | X_1908 := algebra.kunion(X_1904,X_1905); | | X_1909:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_1910 := bat.reverse(X_1909); | | X_1911 := algebra.kdifference(X_1908,X_1910); | | X_1912 := algebra.leftjoin(X_19,X_1911); | | X_1913:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp40",0); | | X_1916:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp40",2); | | X_1917 := algebra.kdifference(X_1913,X_1916); | | X_1918 := algebra.kunion(X_1917,X_1916); | | X_1919:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp40",1); | | X_1920 := algebra.kunion(X_1918,X_1919); | | X_1921 := algebra.kdifference(X_1920,X_1910); | | X_1922 := algebra.leftjoin(X_19,X_1921); | | X_1923:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp41",0); | | X_1926:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp41",2); | | X_1929 := algebra.kdifference(X_1923,X_1926); | | X_1930 := algebra.kunion(X_1929,X_1926); | | X_1931:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp41",1); | | X_1933 := algebra.kunion(X_1930,X_1931); | | X_1934 := algebra.kdifference(X_1933,X_1910); | | X_1935 := algebra.leftjoin(X_19,X_1934); | | X_1936:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp42",0); | | X_1939:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp42",2); | | X_1940 := algebra.kdifference(X_1936,X_1939); | | X_1941 := algebra.kunion(X_1940,X_1939); | | X_1942:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp42",1); | | X_1943 := algebra.kunion(X_1941,X_1942); | | X_1944 := algebra.kdifference(X_1943,X_1910); | | X_1945 := algebra.leftjoin(X_19,X_1944); | | X_1947:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp43",0); | | X_1950:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp43",2); | | X_1952 := algebra.kdifference(X_1947,X_1950); | | X_1953 := algebra.kunion(X_1952,X_1950); | | X_1954:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp43",1); | | X_1956 := algebra.kunion(X_1953,X_1954); | | X_1957 := algebra.kdifference(X_1956,X_1910); | | X_1958 := algebra.leftjoin(X_19,X_1957); | | X_1959:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp44",0); | | X_1962:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp44",2); | | X_1963 := algebra.kdifference(X_1959,X_1962); | | X_1964 := algebra.kunion(X_1963,X_1962); | | X_1965:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp44",1); | | X_1966 := algebra.kunion(X_1964,X_1965); | | X_1967 := algebra.kdifference(X_1966,X_1910); | | X_1969 := algebra.leftjoin(X_19,X_1967); | | X_1970:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp45",0); | | X_1973:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp45",2); | | X_1975 := algebra.kdifference(X_1970,X_1973); | | X_1976 := algebra.kunion(X_1975,X_1973); | | X_1977:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp45",1); | | X_1979 := algebra.kunion(X_1976,X_1977); | | X_1980 := algebra.kdifference(X_1979,X_1910); | | X_1981 := algebra.leftjoin(X_19,X_1980); | | X_1982:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp46",0); | | X_1985:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp46",2); | | X_1986 := algebra.kdifference(X_1982,X_1985); | | X_1987 := algebra.kunion(X_1986,X_1985); | | X_1988:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp46",1); | | X_1990 := algebra.kunion(X_1987,X_1988); | | X_1991 := algebra.kdifference(X_1990,X_1910); | | X_1992 := algebra.leftjoin(X_19,X_1991); | | X_1993:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp47",0); | | X_1996:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp47",2); | | X_1998 := algebra.kdifference(X_1993,X_1996); | | X_1999 := algebra.kunion(X_1998,X_1996); | | X_2000:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp47",1); | | X_2002 := algebra.kunion(X_1999,X_2000); | | X_2003:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_2004 := bat.reverse(X_2003); | | X_2005 := algebra.kdifference(X_2002,X_2004); | | X_2006 := algebra.leftjoin(X_19,X_2005); | | X_2007:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp48",0); | | X_2011:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp48",2); | | X_2012 := algebra.kdifference(X_2007,X_2011); | | X_2013 := algebra.kunion(X_2012,X_2011); | | X_2014:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp48",1); | | X_2015 := algebra.kunion(X_2013,X_2014); | | X_2016 := algebra.kdifference(X_2015,X_2004); | | X_2017 := algebra.leftjoin(X_19,X_2016); | | X_2018:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp49",0); | | X_2021:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp49",2); | | X_2023 := algebra.kdifference(X_2018,X_2021); | | X_2024 := algebra.kunion(X_2023,X_2021); | | X_2025:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp49",1); | | X_2027 := algebra.kunion(X_2024,X_2025); | | X_2028 := algebra.kdifference(X_2027,X_2004); | | X_2030 := algebra.leftjoin(X_19,X_2028); | | X_2031:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp50",0); | | X_2034:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp50",2); | | X_2035 := algebra.kdifference(X_2031,X_2034); | | X_2036 := algebra.kunion(X_2035,X_2034); | | X_2037:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp50",1); | | X_2038 := algebra.kunion(X_2036,X_2037); | | X_2039 := algebra.kdifference(X_2038,X_2004); | | X_2040 := algebra.leftjoin(X_19,X_2039); | | X_2041:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp51",0); | | X_2044:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp51",2); | | X_2046 := algebra.kdifference(X_2041,X_2044); | | X_2047 := algebra.kunion(X_2046,X_2044); | | X_2048:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp51",1); | | X_2050 := algebra.kunion(X_2047,X_2048); | | X_2052 := algebra.kdifference(X_2050,X_2004); | | X_2053 := algebra.leftjoin(X_19,X_2052); | | X_2054:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp52",0); | | X_2057:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp52",2); | | X_2058 := algebra.kdifference(X_2054,X_2057); | | X_2059 := algebra.kunion(X_2058,X_2057); | | X_2060:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp52",1); | | X_2061 := algebra.kunion(X_2059,X_2060); | | X_2062 := algebra.kdifference(X_2061,X_2004); | | X_2063 := algebra.leftjoin(X_19,X_2062); | | X_2064:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp53",0); | | X_2067:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp53",2); | | X_2069 := algebra.kdifference(X_2064,X_2067); | | X_2070 := algebra.kunion(X_2069,X_2067); | | X_2071:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp53",1); | | X_2074 := algebra.kunion(X_2070,X_2071); | | X_2075 := algebra.kdifference(X_2074,X_2004); | | X_2076 := algebra.leftjoin(X_19,X_2075); | | X_2077:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp54",0); | | X_2080:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp54",2); | | X_2081 := algebra.kdifference(X_2077,X_2080); | | X_2082 := algebra.kunion(X_2081,X_2080); | | X_2083:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp54",1); | | X_2084 := algebra.kunion(X_2082,X_2083); | | X_2085 := algebra.kdifference(X_2084,X_2004); | | X_2086 := algebra.leftjoin(X_19,X_2085); | | X_2087:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp55",0); | | X_2090:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp55",2); | | X_2093 := algebra.kdifference(X_2087,X_2090); | | X_2094 := algebra.kunion(X_2093,X_2090); | | X_2095:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp55",1); | | X_2097 := algebra.kunion(X_2094,X_2095); | | X_2098:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_2099 := bat.reverse(X_2098); | | X_2100 := algebra.kdifference(X_2097,X_2099); | | X_2101 := algebra.leftjoin(X_19,X_2100); | | X_2102:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp56",0); | | X_2105:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp56",2); | | X_2106 := algebra.kdifference(X_2102,X_2105); | | X_2107 := algebra.kunion(X_2106,X_2105); | | X_2108:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp56",1); | | X_2109 := algebra.kunion(X_2107,X_2108); | | X_2110 := algebra.kdifference(X_2109,X_2099); | | X_2111 := algebra.leftjoin(X_19,X_2110); | | X_2113:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp57",0); | | X_2116:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp57",2); | | X_2118 := algebra.kdifference(X_2113,X_2116); | | X_2119 := algebra.kunion(X_2118,X_2116); | | X_2120:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp57",1); | | X_2122 := algebra.kunion(X_2119,X_2120); | | X_2123 := algebra.kdifference(X_2122,X_2099); | | X_2124 := algebra.leftjoin(X_19,X_2123); | | X_2125:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp58",0); | | X_2128:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp58",2); | | X_2129 := algebra.kdifference(X_2125,X_2128); | | X_2130 := algebra.kunion(X_2129,X_2128); | | X_2131:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp58",1); | | X_2132 := algebra.kunion(X_2130,X_2131); | | X_2133 := algebra.kdifference(X_2132,X_2099); | | X_2135 := algebra.leftjoin(X_19,X_2133); | | X_2136:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp59",0); | | X_2139:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp59",2); | | X_2141 := algebra.kdifference(X_2136,X_2139); | | X_2142 := algebra.kunion(X_2141,X_2139); | | X_2143:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp59",1); | | X_2145 := algebra.kunion(X_2142,X_2143); | | X_2146 := algebra.kdifference(X_2145,X_2099); | | X_2147 := algebra.leftjoin(X_19,X_2146); | | X_2148:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp60",0); | | X_2151:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp60",2); | | X_2152 := algebra.kdifference(X_2148,X_2151); | | X_2153 := algebra.kunion(X_2152,X_2151); | | X_2154:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp60",1); | | X_2156 := algebra.kunion(X_2153,X_2154); | | X_2157 := algebra.kdifference(X_2156,X_2099); | | X_2158 := algebra.leftjoin(X_19,X_2157); | | X_2159:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp61",0); | | X_2162:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp61",2); | | X_2164 := algebra.kdifference(X_2159,X_2162); | | X_2165 := algebra.kunion(X_2164,X_2162); | | X_2166:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp61",1); | | X_2168 := algebra.kunion(X_2165,X_2166); | | X_2169 := algebra.kdifference(X_2168,X_2099); | | X_2170 := algebra.leftjoin(X_19,X_2169); | | X_2171:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp62",0); | | X_2175:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp62",2); | | X_2176 := algebra.kdifference(X_2171,X_2175); | | X_2177 := algebra.kunion(X_2176,X_2175); | | X_2178:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp62",1); | | X_2179 := algebra.kunion(X_2177,X_2178); | | X_2180 := algebra.kdifference(X_2179,X_2099); | | X_2181 := algebra.leftjoin(X_19,X_2180); | | X_2182:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp63",0); | | X_2185:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp63",2); | | X_2187 := algebra.kdifference(X_2182,X_2185); | | X_2188 := algebra.kunion(X_2187,X_2185); | | X_2189:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp63",1); | | X_2191 := algebra.kunion(X_2188,X_2189); | | X_2192:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_2193 := bat.reverse(X_2192); | | X_2194 := algebra.kdifference(X_2191,X_2193); | | X_2196 := algebra.leftjoin(X_19,X_2194); | | X_2197:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp64",0); | | X_2200:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp64",2); | | X_2201 := algebra.kdifference(X_2197,X_2200); | | X_2202 := algebra.kunion(X_2201,X_2200); | | X_2203:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp64",1); | | X_2204 := algebra.kunion(X_2202,X_2203); | | X_2205 := algebra.kdifference(X_2204,X_2193); | | X_2206 := algebra.leftjoin(X_19,X_2205); | | X_2207:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp65",0); | | X_2210:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp65",2); | | X_2212 := algebra.kdifference(X_2207,X_2210); | | X_2213 := algebra.kunion(X_2212,X_2210); | | X_2214:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp65",1); | | X_2216 := algebra.kunion(X_2213,X_2214); | | X_2218 := algebra.kdifference(X_2216,X_2193); | | X_2219 := algebra.leftjoin(X_19,X_2218); | | X_2220:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp66",0); | | X_2223:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp66",2); | | X_2224 := algebra.kdifference(X_2220,X_2223); | | X_2225 := algebra.kunion(X_2224,X_2223); | | X_2226:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp66",1); | | X_2227 := algebra.kunion(X_2225,X_2226); | | X_2228 := algebra.kdifference(X_2227,X_2193); | | X_2229 := algebra.leftjoin(X_19,X_2228); | | X_2230:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp67",0); | | X_2233:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp67",2); | | X_2235 := algebra.kdifference(X_2230,X_2233); | | X_2236 := algebra.kunion(X_2235,X_2233); | | X_2237:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp67",1); | | X_2240 := algebra.kunion(X_2236,X_2237); | | X_2241 := algebra.kdifference(X_2240,X_2193); | | X_2242 := algebra.leftjoin(X_19,X_2241); | | X_2243:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp68",0); | | X_2246:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp68",2); | | X_2247 := algebra.kdifference(X_2243,X_2246); | | X_2248 := algebra.kunion(X_2247,X_2246); | | X_2249:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp68",1); | | X_2250 := algebra.kunion(X_2248,X_2249); | | X_2251 := algebra.kdifference(X_2250,X_2193); | | X_2252 := algebra.leftjoin(X_19,X_2251); | | X_2253:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp69",0); | | X_2256:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp69",2); | | X_2259 := algebra.kdifference(X_2253,X_2256); | | X_2260 := algebra.kunion(X_2259,X_2256); | | X_2261:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp69",1); | | X_2263 := algebra.kunion(X_2260,X_2261); | | X_2264 := algebra.kdifference(X_2263,X_2193); | | X_2265 := algebra.leftjoin(X_19,X_2264); | | X_2266:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp70",0); | | X_2269:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp70",2); | | X_2270 := algebra.kdifference(X_2266,X_2269); | | X_2271 := algebra.kunion(X_2270,X_2269); | | X_2272:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp70",1); | | X_2273 := algebra.kunion(X_2271,X_2272); | | X_2274 := algebra.kdifference(X_2273,X_2193); | | X_2275 := algebra.leftjoin(X_19,X_2274); | | X_2277:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp71",0); | | X_2280:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp71",2); | | X_2282 := algebra.kdifference(X_2277,X_2280); | | X_2283 := algebra.kunion(X_2282,X_2280); | | X_2284:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp71",1); | | X_2286 := algebra.kunion(X_2283,X_2284); | | X_2287:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_2288 := bat.reverse(X_2287); | | X_2289 := algebra.kdifference(X_2286,X_2288); | | X_2290 := algebra.leftjoin(X_19,X_2289); | | X_2291:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp72",0); | | X_2294:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp72",2); | | X_2295 := algebra.kdifference(X_2291,X_2294); | | X_2296 := algebra.kunion(X_2295,X_2294); | | X_2297:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp72",1); | | X_2298 := algebra.kunion(X_2296,X_2297); | | X_2299 := algebra.kdifference(X_2298,X_2288); | | X_2301 := algebra.leftjoin(X_19,X_2299); | | X_2302:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp73",0); | | X_2305:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp73",2); | | X_2307 := algebra.kdifference(X_2302,X_2305); | | X_2308 := algebra.kunion(X_2307,X_2305); | | X_2309:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp73",1); | | X_2311 := algebra.kunion(X_2308,X_2309); | | X_2312 := algebra.kdifference(X_2311,X_2288); | | X_2313 := algebra.leftjoin(X_19,X_2312); | | X_2314:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp74",0); | | X_2317:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp74",2); | | X_2318 := algebra.kdifference(X_2314,X_2317); | | X_2319 := algebra.kunion(X_2318,X_2317); | | X_2320:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp74",1); | | X_2322 := algebra.kunion(X_2319,X_2320); | | X_2323 := algebra.kdifference(X_2322,X_2288); | | X_2324 := algebra.leftjoin(X_19,X_2323); | | X_2325:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp75",0); | | X_2328:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp75",2); | | X_2330 := algebra.kdifference(X_2325,X_2328); | | X_2331 := algebra.kunion(X_2330,X_2328); | | X_2332:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp75",1); | | X_2334 := algebra.kunion(X_2331,X_2332); | | X_2335 := algebra.kdifference(X_2334,X_2288); | | X_2336 := algebra.leftjoin(X_19,X_2335); | | X_2337:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp76",0); | | X_2341:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp76",2); | | X_2342 := algebra.kdifference(X_2337,X_2341); | | X_2343 := algebra.kunion(X_2342,X_2341); | | X_2344:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp76",1); | | X_2345 := algebra.kunion(X_2343,X_2344); | | X_2346 := algebra.kdifference(X_2345,X_2288); | | X_2347 := algebra.leftjoin(X_19,X_2346); | | X_2348:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp77",0); | | X_2351:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp77",2); | | X_2353 := algebra.kdifference(X_2348,X_2351); | | X_2354 := algebra.kunion(X_2353,X_2351); | | X_2355:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp77",1); | | X_2357 := algebra.kunion(X_2354,X_2355); | | X_2358 := algebra.kdifference(X_2357,X_2288); | | X_2360 := algebra.leftjoin(X_19,X_2358); | | X_2361:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp78",0); | | X_2364:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp78",2); | | X_2365 := algebra.kdifference(X_2361,X_2364); | | X_2366 := algebra.kunion(X_2365,X_2364); | | X_2367:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp78",1); | | X_2368 := algebra.kunion(X_2366,X_2367); | | X_2369 := algebra.kdifference(X_2368,X_2288); | | X_2370 := algebra.leftjoin(X_19,X_2369); | | X_2371:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp79",0); | | X_2374:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp79",2); | | X_2376 := algebra.kdifference(X_2371,X_2374); | | X_2377 := algebra.kunion(X_2376,X_2374); | | X_2378:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp79",1); | | X_2380 := algebra.kunion(X_2377,X_2378); | | X_2381:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","household",1); | | X_2383 := bat.reverse(X_2381); | | X_2384 := algebra.kdifference(X_2380,X_2383); | | X_2385 := algebra.leftjoin(X_19,X_2384); | | X_2386:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp80",0); | | X_2389:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp80",2); | | X_2390 := algebra.kdifference(X_2386,X_2389); | | X_2391 := algebra.kunion(X_2390,X_2389); | | X_2392:bat[:oid,:int] := sql.bind(X_2,"sys","household","wgtp80",1); | | X_2393 := algebra.kunion(X_2391,X_2392); | | X_2394 := algebra.kdifference(X_2393,X_2383); | | X_2395 := algebra.leftjoin(X_19,X_2394); | | exit X_3114; | | sql.rsColumn(X_2396,"sys.household","rt","varchar",255,0,X_20); | | sql.rsColumn(X_2396,"sys.household","serialno","int",32,0,X_31); | | sql.rsColumn(X_2396,"sys.household","division","int",32,0,X_43); | | sql.rsColumn(X_2396,"sys.household","puma","int",32,0,X_54); | | sql.rsColumn(X_2396,"sys.household","region","int",32,0,X_67); | | sql.rsColumn(X_2396,"sys.household","st","int",32,0,X_77); | | sql.rsColumn(X_2396,"sys.household","adjhsg","int",32,0,X_90); | | sql.rsColumn(X_2396,"sys.household","adjinc","int",32,0,X_100); | | sql.rsColumn(X_2396,"sys.household","wgtp","int",32,0,X_115); | | sql.rsColumn(X_2396,"sys.household","np","int",32,0,X_125); | | sql.rsColumn(X_2396,"sys.household","zzzz","int",32,0,X_138); | | sql.rsColumn(X_2396,"sys.household","acr","int",32,0,X_149); | | sql.rsColumn(X_2396,"sys.household","ags","int",32,0,X_161); | | sql.rsColumn(X_2396,"sys.household","bath","int",32,0,X_172); | | sql.rsColumn(X_2396,"sys.household","bdsp","int",32,0,X_184); | | sql.rsColumn(X_2396,"sys.household","bld","int",32,0,X_195); | | sql.rsColumn(X_2396,"sys.household","bus","int",32,0,X_210); | | sql.rsColumn(X_2396,"sys.household","conp","int",32,0,X_220); | | sql.rsColumn(X_2396,"sys.household","elep","int",32,0,X_233); | | sql.rsColumn(X_2396,"sys.household","fs","int",32,0,X_243); | | sql.rsColumn(X_2396,"sys.household","fulp","int",32,0,X_256); | | sql.rsColumn(X_2396,"sys.household","gasp","int",32,0,X_266); | | sql.rsColumn(X_2396,"sys.household","hfl","int",32,0,X_279); | | sql.rsColumn(X_2396,"sys.household","insp","int",32,0,X_289); | | sql.rsColumn(X_2396,"sys.household","mhp","int",32,0,X_304); | | sql.rsColumn(X_2396,"sys.household","mrgi","int",32,0,X_315); | | sql.rsColumn(X_2396,"sys.household","mrgp","int",32,0,X_327); | | sql.rsColumn(X_2396,"sys.household","mrgt","int",32,0,X_338); | | sql.rsColumn(X_2396,"sys.household","mrgx","int",32,0,X_350); | | sql.rsColumn(X_2396,"sys.household","refr","int",32,0,X_361); | | sql.rsColumn(X_2396,"sys.household","rmsp","int",32,0,X_374); | | sql.rsColumn(X_2396,"sys.household","rntm","int",32,0,X_384); | | sql.rsColumn(X_2396,"sys.household","rntp","int",32,0,X_399); | | sql.rsColumn(X_2396,"sys.household","rwat","int",32,0,X_409); | | sql.rsColumn(X_2396,"sys.household","sink","int",32,0,X_422); | | sql.rsColumn(X_2396,"sys.household","smp","int",32,0,X_432); | | sql.rsColumn(X_2396,"sys.household","stov","int",32,0,X_445); | | sql.rsColumn(X_2396,"sys.household","tel","int",32,0,X_455); | | sql.rsColumn(X_2396,"sys.household","ten","int",32,0,X_468); | | sql.rsColumn(X_2396,"sys.household","toil","int",32,0,X_479); | | sql.rsColumn(X_2396,"sys.household","vacs","int",32,0,X_493); | | sql.rsColumn(X_2396,"sys.household","valp","int",32,0,X_504); | | sql.rsColumn(X_2396,"sys.household","veh","int",32,0,X_516); | | sql.rsColumn(X_2396,"sys.household","watp","int",32,0,X_527); | | sql.rsColumn(X_2396,"sys.household","ybl","int",32,0,X_540); | | sql.rsColumn(X_2396,"sys.household","fes","int",32,0,X_550); | | sql.rsColumn(X_2396,"sys.household","fincp","int",32,0,X_563); | | sql.rsColumn(X_2396,"sys.household","fparc","int",32,0,X_573); | | sql.rsColumn(X_2396,"sys.household","grntp","int",32,0,X_588); | | sql.rsColumn(X_2396,"sys.household","grpip","int",32,0,X_598); | | sql.rsColumn(X_2396,"sys.household","hhl","int",32,0,X_611); | | sql.rsColumn(X_2396,"sys.household","hht","int",32,0,X_621); | | sql.rsColumn(X_2396,"sys.household","hincp","int",32,0,X_634); | | sql.rsColumn(X_2396,"sys.household","hugcl","int",32,0,X_645); | | sql.rsColumn(X_2396,"sys.household","hupac","int",32,0,X_657); | | sql.rsColumn(X_2396,"sys.household","hupaoc","int",32,0,X_668); | | sql.rsColumn(X_2396,"sys.household","huparc","int",32,0,X_682); | | sql.rsColumn(X_2396,"sys.household","kit","int",32,0,X_693); | | sql.rsColumn(X_2396,"sys.household","lngi","int",32,0,X_706); | | sql.rsColumn(X_2396,"sys.household","multg","int",32,0,X_716); | | sql.rsColumn(X_2396,"sys.household","mv","int",32,0,X_729); | | sql.rsColumn(X_2396,"sys.household","noc","int",32,0,X_739); | | sql.rsColumn(X_2396,"sys.household","npf","int",32,0,X_752); | | sql.rsColumn(X_2396,"sys.household","npp","int",32,0,X_762); | | sql.rsColumn(X_2396,"sys.household","nr","int",32,0,X_777); | | sql.rsColumn(X_2396,"sys.household","nrc","int",32,0,X_787); | | sql.rsColumn(X_2396,"sys.household","ocpip","int",32,0,X_800); | | sql.rsColumn(X_2396,"sys.household","partner","int",32,0,X_811); | | sql.rsColumn(X_2396,"sys.household","plm","int",32,0,X_823); | | sql.rsColumn(X_2396,"sys.household","psf","int",32,0,X_834); | | sql.rsColumn(X_2396,"sys.household","r18","int",32,0,X_846); | | sql.rsColumn(X_2396,"sys.household","r60","int",32,0,X_857); | | sql.rsColumn(X_2396,"sys.household","r65","int",32,0,X_872); | | sql.rsColumn(X_2396,"sys.household","resmode","int",32,0,X_882); | | sql.rsColumn(X_2396,"sys.household","smocp","int",32,0,X_895); | | sql.rsColumn(X_2396,"sys.household","smx","int",32,0,X_905); | | sql.rsColumn(X_2396,"sys.household","srnt","int",32,0,X_918); | | sql.rsColumn(X_2396,"sys.household","sval","int",32,0,X_928); | | sql.rsColumn(X_2396,"sys.household","taxp","int",32,0,X_941); | | sql.rsColumn(X_2396,"sys.household","wif","int",32,0,X_951); | | sql.rsColumn(X_2396,"sys.household","wkexrel","int",32,0,X_966); | | sql.rsColumn(X_2396,"sys.household","workstat","int",32,0,X_977); | | sql.rsColumn(X_2396,"sys.household","facrp","int",32,0,X_989); | | sql.rsColumn(X_2396,"sys.household","fagsp","int",32,0,X_1000); | | sql.rsColumn(X_2396,"sys.household","fbathp","int",32,0,X_1012); | | sql.rsColumn(X_2396,"sys.household","fbdsp","int",32,0,X_1023); | | sql.rsColumn(X_2396,"sys.household","fbldp","int",32,0,X_1036); | | sql.rsColumn(X_2396,"sys.household","fbusp","int",32,0,X_1046); | | sql.rsColumn(X_2396,"sys.household","fconp","int",32,0,X_1061); | | sql.rsColumn(X_2396,"sys.household","felep","int",32,0,X_1071); | | sql.rsColumn(X_2396,"sys.household","ffsp","int",32,0,X_1084); | | sql.rsColumn(X_2396,"sys.household","ffulp","int",32,0,X_1094); | | sql.rsColumn(X_2396,"sys.household","fgasp","int",32,0,X_1107); | | sql.rsColumn(X_2396,"sys.household","fhflp","int",32,0,X_1117); | | sql.rsColumn(X_2396,"sys.household","finsp","int",32,0,X_1130); | | sql.rsColumn(X_2396,"sys.household","fkitp","int",32,0,X_1141); | | sql.rsColumn(X_2396,"sys.household","fmhp","int",32,0,X_1155); | | sql.rsColumn(X_2396,"sys.household","fmrgip","int",32,0,X_1166); | | sql.rsColumn(X_2396,"sys.household","fmrgp","int",32,0,X_1178); | | sql.rsColumn(X_2396,"sys.household","fmrgtp","int",32,0,X_1189); | | sql.rsColumn(X_2396,"sys.household","fmrgxp","int",32,0,X_1202); | | sql.rsColumn(X_2396,"sys.household","fmvp","int",32,0,X_1212); | | sql.rsColumn(X_2396,"sys.household","fplmp","int",32,0,X_1225); | | sql.rsColumn(X_2396,"sys.household","frefrp","int",32,0,X_1235); | | sql.rsColumn(X_2396,"sys.household","frmsp","int",32,0,X_1250); | | sql.rsColumn(X_2396,"sys.household","frntmp","int",32,0,X_1260); | | sql.rsColumn(X_2396,"sys.household","frntp","int",32,0,X_1273); | | sql.rsColumn(X_2396,"sys.household","frwatp","int",32,0,X_1283); | | sql.rsColumn(X_2396,"sys.household","fsinkp","int",32,0,X_1296); | | sql.rsColumn(X_2396,"sys.household","fsmp","int",32,0,X_1307); | | sql.rsColumn(X_2396,"sys.household","fsmxhp","int",32,0,X_1319); | | sql.rsColumn(X_2396,"sys.household","fsmxsp","int",32,0,X_1330); | | sql.rsColumn(X_2396,"sys.household","fstovp","int",32,0,X_1344); | | sql.rsColumn(X_2396,"sys.household","ftaxp","int",32,0,X_1355); | | sql.rsColumn(X_2396,"sys.household","ftelp","int",32,0,X_1368); | | sql.rsColumn(X_2396,"sys.household","ftenp","int",32,0,X_1378); | | sql.rsColumn(X_2396,"sys.household","ftoilp","int",32,0,X_1391); | | sql.rsColumn(X_2396,"sys.household","fvacsp","int",32,0,X_1401); | | sql.rsColumn(X_2396,"sys.household","fvalp","int",32,0,X_1414); | | sql.rsColumn(X_2396,"sys.household","fvehp","int",32,0,X_1424); | | sql.rsColumn(X_2396,"sys.household","fwatp","int",32,0,X_1439); | | sql.rsColumn(X_2396,"sys.household","fyblp","int",32,0,X_1449); | | sql.rsColumn(X_2396,"sys.household","wgtp1","int",32,0,X_1462); | | sql.rsColumn(X_2396,"sys.household","wgtp2","int",32,0,X_1473); | | sql.rsColumn(X_2396,"sys.household","wgtp3","int",32,0,X_1485); | | sql.rsColumn(X_2396,"sys.household","wgtp4","int",32,0,X_1496); | | sql.rsColumn(X_2396,"sys.household","wgtp5","int",32,0,X_1508); | | sql.rsColumn(X_2396,"sys.household","wgtp6","int",32,0,X_1519); | | sql.rsColumn(X_2396,"sys.household","wgtp7","int",32,0,X_1534); | | sql.rsColumn(X_2396,"sys.household","wgtp8","int",32,0,X_1544); | | sql.rsColumn(X_2396,"sys.household","wgtp9","int",32,0,X_1557); | | sql.rsColumn(X_2396,"sys.household","wgtp10","int",32,0,X_1567); | | sql.rsColumn(X_2396,"sys.household","wgtp11","int",32,0,X_1580); | | sql.rsColumn(X_2396,"sys.household","wgtp12","int",32,0,X_1590); | | sql.rsColumn(X_2396,"sys.household","wgtp13","int",32,0,X_1603); | | sql.rsColumn(X_2396,"sys.household","wgtp14","int",32,0,X_1613); | | sql.rsColumn(X_2396,"sys.household","wgtp15","int",32,0,X_1628); | | sql.rsColumn(X_2396,"sys.household","wgtp16","int",32,0,X_1639); | | sql.rsColumn(X_2396,"sys.household","wgtp17","int",32,0,X_1651); | | sql.rsColumn(X_2396,"sys.household","wgtp18","int",32,0,X_1662); | | sql.rsColumn(X_2396,"sys.household","wgtp19","int",32,0,X_1674); | | sql.rsColumn(X_2396,"sys.household","wgtp20","int",32,0,X_1685); | | sql.rsColumn(X_2396,"sys.household","wgtp21","int",32,0,X_1698); | | sql.rsColumn(X_2396,"sys.household","wgtp22","int",32,0,X_1708); | | sql.rsColumn(X_2396,"sys.household","wgtp23","int",32,0,X_1723); | | sql.rsColumn(X_2396,"sys.household","wgtp24","int",32,0,X_1733); | | sql.rsColumn(X_2396,"sys.household","wgtp25","int",32,0,X_1746); | | sql.rsColumn(X_2396,"sys.household","wgtp26","int",32,0,X_1756); | | sql.rsColumn(X_2396,"sys.household","wgtp27","int",32,0,X_1769); | | sql.rsColumn(X_2396,"sys.household","wgtp28","int",32,0,X_1779); | | sql.rsColumn(X_2396,"sys.household","wgtp29","int",32,0,X_1792); | | sql.rsColumn(X_2396,"sys.household","wgtp30","int",32,0,X_1803); | | sql.rsColumn(X_2396,"sys.household","wgtp31","int",32,0,X_1817); | | sql.rsColumn(X_2396,"sys.household","wgtp32","int",32,0,X_1828); | | sql.rsColumn(X_2396,"sys.household","wgtp33","int",32,0,X_1840); | | sql.rsColumn(X_2396,"sys.household","wgtp34","int",32,0,X_1851); | | sql.rsColumn(X_2396,"sys.household","wgtp35","int",32,0,X_1864); | | sql.rsColumn(X_2396,"sys.household","wgtp36","int",32,0,X_1874); | | sql.rsColumn(X_2396,"sys.household","wgtp37","int",32,0,X_1887); | | sql.rsColumn(X_2396,"sys.household","wgtp38","int",32,0,X_1897); | | sql.rsColumn(X_2396,"sys.household","wgtp39","int",32,0,X_1912); | | sql.rsColumn(X_2396,"sys.household","wgtp40","int",32,0,X_1922); | | sql.rsColumn(X_2396,"sys.household","wgtp41","int",32,0,X_1935); | | sql.rsColumn(X_2396,"sys.household","wgtp42","int",32,0,X_1945); | | sql.rsColumn(X_2396,"sys.household","wgtp43","int",32,0,X_1958); | | sql.rsColumn(X_2396,"sys.household","wgtp44","int",32,0,X_1969); | | sql.rsColumn(X_2396,"sys.household","wgtp45","int",32,0,X_1981); | | sql.rsColumn(X_2396,"sys.household","wgtp46","int",32,0,X_1992); | | sql.rsColumn(X_2396,"sys.household","wgtp47","int",32,0,X_2006); | | sql.rsColumn(X_2396,"sys.household","wgtp48","int",32,0,X_2017); | | sql.rsColumn(X_2396,"sys.household","wgtp49","int",32,0,X_2030); | | sql.rsColumn(X_2396,"sys.household","wgtp50","int",32,0,X_2040); | | sql.rsColumn(X_2396,"sys.household","wgtp51","int",32,0,X_2053); | | sql.rsColumn(X_2396,"sys.household","wgtp52","int",32,0,X_2063); | | sql.rsColumn(X_2396,"sys.household","wgtp53","int",32,0,X_2076); | | sql.rsColumn(X_2396,"sys.household","wgtp54","int",32,0,X_2086); | | sql.rsColumn(X_2396,"sys.household","wgtp55","int",32,0,X_2101); | | sql.rsColumn(X_2396,"sys.household","wgtp56","int",32,0,X_2111); | | sql.rsColumn(X_2396,"sys.household","wgtp57","int",32,0,X_2124); | | sql.rsColumn(X_2396,"sys.household","wgtp58","int",32,0,X_2135); | | sql.rsColumn(X_2396,"sys.household","wgtp59","int",32,0,X_2147); | | sql.rsColumn(X_2396,"sys.household","wgtp60","int",32,0,X_2158); | | sql.rsColumn(X_2396,"sys.household","wgtp61","int",32,0,X_2170); | | sql.rsColumn(X_2396,"sys.household","wgtp62","int",32,0,X_2181); | | sql.rsColumn(X_2396,"sys.household","wgtp63","int",32,0,X_2196); | | sql.rsColumn(X_2396,"sys.household","wgtp64","int",32,0,X_2206); | | sql.rsColumn(X_2396,"sys.household","wgtp65","int",32,0,X_2219); | | sql.rsColumn(X_2396,"sys.household","wgtp66","int",32,0,X_2229); | | sql.rsColumn(X_2396,"sys.household","wgtp67","int",32,0,X_2242); | | sql.rsColumn(X_2396,"sys.household","wgtp68","int",32,0,X_2252); | | sql.rsColumn(X_2396,"sys.household","wgtp69","int",32,0,X_2265); | | sql.rsColumn(X_2396,"sys.household","wgtp70","int",32,0,X_2275); | | sql.rsColumn(X_2396,"sys.household","wgtp71","int",32,0,X_2290); | | sql.rsColumn(X_2396,"sys.household","wgtp72","int",32,0,X_2301); | | sql.rsColumn(X_2396,"sys.household","wgtp73","int",32,0,X_2313); | | sql.rsColumn(X_2396,"sys.household","wgtp74","int",32,0,X_2324); | | sql.rsColumn(X_2396,"sys.household","wgtp75","int",32,0,X_2336); | | sql.rsColumn(X_2396,"sys.household","wgtp76","int",32,0,X_2347); | | sql.rsColumn(X_2396,"sys.household","wgtp77","int",32,0,X_2360); | | sql.rsColumn(X_2396,"sys.household","wgtp78","int",32,0,X_2370); | | sql.rsColumn(X_2396,"sys.household","wgtp79","int",32,0,X_2385); | | sql.rsColumn(X_2396,"sys.household","wgtp80","int",32,0,X_2395); | | X_2861 := io.stdout(); | | sql.exportResult(X_2861,X_2396); | | end s4_1; | +----------------------------------------------------------------------------+ +------+----------+----------+------+--------+------+---------+---------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+------+------+-------+-------+-------+-------+------+------+-------+-------+-------+--------+--------+------+------+-------+------+------+------+------+------+------+-------+---------+------+------+------+------+------+---------+-------+------+------+------+------+------+---------+----------+-------+-------+--------+-------+-------+-------+-------+-------+------+-------+-------+-------+-------+-------+------+--------+-------+--------+--------+------+-------+--------+-------+--------+-------+--------+--------+------+--------+--------+--------+-------+-------+-------+--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+ | 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 | +======+==========+==========+======+========+======+=========+=========+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+========+======+======+======+======+=======+=======+=======+=======+======+======+=======+=======+=======+========+========+======+======+=======+======+======+======+======+======+======+=======+=========+======+======+======+======+======+=========+=======+======+======+======+======+======+=========+==========+=======+=======+========+=======+=======+=======+=======+=======+======+=======+=======+=======+=======+=======+======+========+=======+========+========+======+=======+========+=======+========+=======+========+========+======+========+========+========+=======+=======+=======+========+========+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+ | H | 1890 | 9 | 400 | 4 | 2 | 1000000 | 1007624 | 46 | 2 | 1 | null | null | 1 | 1 | 6 | null | null | 1 | 2 | 1 | 3 | 4 | null | null | null | null | null | null | 1 | 2 | 2 | 600 | 1 | 1 | null | 1 | 1 | 3 | 1 | null | null | 1 | 1 | 3 | null | null | null | 600 | 21 | 1 | 7 | 34700 | 0 | 4 | 4 | 4 | 1 | 1 | 1 | 3 | 0 | null | 0 | 1 | 0 | null | 0 | 1 | 0 | 0 | 0 | 0 | 2 | null | null | 1 | 0 | null | null | null | null | 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 | 1 | 10 | 16 | 10 | 42 | 61 | 44 | 54 | 45 | 71 | 67 | 112 | 50 | 15 | 41 | 111 | 79 | 37 | 67 | 38 | 40 | 81 | 95 | 70 | 81 | 51 | 40 | 38 | 47 | 15 | 22 | 18 | 34 | 95 | 55 | 14 | 51 | 48 | 18 | 43 | 12 | 7 | 13 | 15 | 57 | 72 | 55 | 48 | 50 | 75 | 80 | 116 | 51 | 14 | 38 | 126 | 57 | 30 | 93 | 29 | 53 | 80 | 55 | 71 | 46 | 38 | 57 | 39 | 47 | 16 | 16 | 20 | 50 | 91 | 58 | 20 | 72 | 43 | 11 | 48 | 9 | | H | 2029 | 9 | 101 | 4 | 2 | 1000000 | 1007624 | 269 | 4 | 1 | 1 | null | 1 | 4 | 2 | 2 | null | 80 | 2 | 2 | 80 | 1 | 1500 | null | 1 | 920 | 1 | 1 | 1 | 7 | null | null | 1 | 1 | null | 1 | 1 | 1 | 1 | null | 200000 | 1 | 200 | 4 | 8 | 47100 | 2 | null | null | 1 | 3 | 47100 | 1 | 2 | 4 | 2 | 1 | 1 | 2 | 7 | 0 | 4 | 0 | 0 | 2 | 28 | 0 | 1 | 1 | 1 | 1 | 1 | 2 | 1097 | 3 | 0 | 1 | 34 | 1 | 15 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 252 | 470 | 264 | 430 | 228 | 243 | 192 | 107 | 265 | 79 | 266 | 268 | 68 | 335 | 503 | 116 | 95 | 389 | 228 | 114 | 254 | 71 | 225 | 116 | 289 | 291 | 233 | 539 | 310 | 423 | 262 | 346 | 511 | 235 | 79 | 407 | 420 | 121 | 223 | 90 | 250 | 70 | 240 | 101 | 259 | 326 | 245 | 461 | 241 | 480 | 315 | 275 | 286 | 338 | 118 | 363 | 409 | 87 | 238 | 418 | 278 | 322 | 297 | 486 | 376 | 262 | 198 | 95 | 259 | 104 | 238 | 309 | 135 | 230 | 408 | 117 | 83 | 497 | 244 | 418 | +------+----------+----------+------+--------+------+---------+---------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+------+------+-------+-------+-------+-------+------+------+-------+-------+-------+--------+--------+------+------+-------+------+------+------+------+------+------+-------+---------+------+------+------+------+------+---------+-------+------+------+------+------+------+---------+----------+-------+-------+--------+-------+-------+-------+-------+-------+------+-------+-------+-------+-------+-------+------+--------+-------+--------+--------+------+-------+--------+-------+--------+-------+--------+--------+------+--------+--------+--------+-------+-------+-------+--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+ +------+----------+----------+------+--------+------+---------+---------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+------+------+-------+-------+-------+-------+------+------+-------+-------+-------+--------+--------+------+------+-------+------+------+------+------+------+------+-------+---------+------+------+------+------+------+---------+-------+------+------+------+------+------+---------+----------+-------+-------+--------+-------+-------+-------+-------+-------+------+-------+-------+-------+-------+-------+------+--------+-------+--------+--------+------+-------+--------+-------+--------+-------+--------+--------+------+--------+--------+--------+-------+-------+-------+--------+--------+-------+-------+-------+-------+ | 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 | +======+==========+==========+======+========+======+=========+=========+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+========+======+======+======+======+=======+=======+=======+=======+======+======+=======+=======+=======+========+========+======+======+=======+======+======+======+======+======+======+=======+=========+======+======+======+======+======+=========+=======+======+======+======+======+======+=========+==========+=======+=======+========+=======+=======+=======+=======+=======+======+=======+=======+=======+=======+=======+======+========+=======+========+========+======+=======+========+=======+========+=======+========+========+======+========+========+========+=======+=======+=======+========+========+=======+=======+=======+=======+ | 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 | | H | 433 | 9 | 200 | 4 | 2 | 1000000 | 1007624 | 0 | 1 | 2 | null | null | null | null | null | null | null | null | 2 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | 5 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | 0 | null | null | null | null | null | null | null | null | null | null | 0 | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | | H | 650 | 9 | 200 | 4 | 2 | 1000000 | 1007624 | 57 | 0 | 1 | 2 | null | 1 | 2 | 2 | 2 | null | null | null | null | null | null | null | null | null | null | null | null | 1 | 6 | null | null | 1 | 1 | null | 1 | null | null | 1 | 5 | null | null | null | 7 | null | null | null | null | null | null | null | null | null | null | null | null | 1 | null | null | null | null | null | null | null | null | null | null | 1 | null | null | null | null | 2 | null | null | 0 | 0 | null | null | null | null | 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 | | H | 1890 | 9 | 400 | 4 | 2 | 1000000 | 1007624 | 46 | 2 | 1 | null | null | 1 | 1 | 6 | null | null | 1 | 2 | 1 | 3 | 4 | null | null | null | null | null | null | 1 | 2 | 2 | 600 | 1 | 1 | null | 1 | 1 | 3 | 1 | null | null | 1 | 1 | 3 | null | null | null | 600 | 21 | 1 | 7 | 34700 | 0 | 4 | 4 | 4 | 1 | 1 | 1 | 3 | 0 | null | 0 | 1 | 0 | null | 0 | 1 | 0 | 0 | 0 | 0 | 2 | null | null | 1 | 0 | null | null | null | null | 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 | 1 | | H | 2029 | 9 | 101 | 4 | 2 | 1000000 | 1007624 | 269 | 4 | 1 | 1 | null | 1 | 4 | 2 | 2 | null | 80 | 2 | 2 | 80 | 1 | 1500 | null | 1 | 920 | 1 | 1 | 1 | 7 | null | null | 1 | 1 | null | 1 | 1 | 1 | 1 | null | 200000 | 1 | 200 | 4 | 8 | 47100 | 2 | null | null | 1 | 3 | 47100 | 1 | 2 | 4 | 2 | 1 | 1 | 2 | 7 | 0 | 4 | 0 | 0 | 2 | 28 | 0 | 1 | 1 | 1 | 1 | 1 | 2 | 1097 | 3 | 0 | 1 | 34 | 1 | 15 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | +------+----------+----------+------+--------+------+---------+---------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+------+------+-------+-------+-------+-------+------+------+-------+-------+-------+--------+--------+------+------+-------+------+------+------+------+------+------+-------+---------+------+------+------+------+------+---------+-------+------+------+------+------+------+---------+----------+-------+-------+--------+-------+-------+-------+-------+-------+------+-------+-------+-------+-------+-------+------+--------+-------+--------+--------+------+-------+--------+-------+--------+-------+--------+--------+------+--------+--------+--------+-------+-------+-------+--------+--------+-------+-------+-------+-------+ +-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+ | 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 | +=======+=======+=======+=======+=======+=======+=======+=======+=======+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+ | 74 | 14 | 62 | 94 | 47 | 55 | 45 | 72 | 60 | 120 | 18 | 58 | 31 | 61 | 54 | 52 | 15 | 20 | 88 | 58 | 20 | 60 | 107 | 57 | 110 | 115 | 16 | 47 | 17 | 72 | 55 | 18 | 63 | 19 | 89 | 70 | 47 | 43 | 56 | 86 | 81 | 20 | 70 | 94 | 68 | 47 | 57 | 94 | 80 | 78 | 39 | 61 | 12 | 51 | 63 | 47 | 21 | 14 | 95 | 72 | 16 | 50 | 79 | 73 | 82 | 79 | 16 | 53 | 24 | 35 | 54 | 16 | 39 | 12 | 118 | 135 | 66 | 47 | 50 | 76 | | 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 | 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 | | 60 | 17 | 57 | 16 | 93 | 106 | 59 | 58 | 58 | 17 | 56 | 101 | 54 | 116 | 96 | 18 | 72 | 15 | 61 | 55 | 54 | 18 | 54 | 15 | 96 | 97 | 57 | 65 | 55 | 17 | 49 | 94 | 59 | 113 | 88 | 18 | 59 | 13 | 56 | 50 | 60 | 17 | 59 | 17 | 96 | 98 | 52 | 50 | 50 | 17 | 60 | 93 | 57 | 102 | 101 | 17 | 68 | 20 | 53 | 54 | 66 | 18 | 63 | 19 | 91 | 106 | 56 | 56 | 57 | 20 | 57 | 90 | 54 | 98 | 101 | 16 | 51 | 17 | 61 | 61 | | 10 | 16 | 10 | 42 | 61 | 44 | 54 | 45 | 71 | 67 | 112 | 50 | 15 | 41 | 111 | 79 | 37 | 67 | 38 | 40 | 81 | 95 | 70 | 81 | 51 | 40 | 38 | 47 | 15 | 22 | 18 | 34 | 95 | 55 | 14 | 51 | 48 | 18 | 43 | 12 | 7 | 13 | 15 | 57 | 72 | 55 | 48 | 50 | 75 | 80 | 116 | 51 | 14 | 38 | 126 | 57 | 30 | 93 | 29 | 53 | 80 | 55 | 71 | 46 | 38 | 57 | 39 | 47 | 16 | 16 | 20 | 50 | 91 | 58 | 20 | 72 | 43 | 11 | 48 | 9 | | 252 | 470 | 264 | 430 | 228 | 243 | 192 | 107 | 265 | 79 | 266 | 268 | 68 | 335 | 503 | 116 | 95 | 389 | 228 | 114 | 254 | 71 | 225 | 116 | 289 | 291 | 233 | 539 | 310 | 423 | 262 | 346 | 511 | 235 | 79 | 407 | 420 | 121 | 223 | 90 | 250 | 70 | 240 | 101 | 259 | 326 | 245 | 461 | 241 | 480 | 315 | 275 | 286 | 338 | 118 | 363 | 409 | 87 | 238 | 418 | 278 | 322 | 297 | 486 | 376 | 262 | 198 | 95 | 259 | 104 | 238 | 309 | 135 | 230 | 408 | 117 | 83 | 497 | 244 | 418 | +-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
Hi, I am still struggling with this issue and have not received any response. I am either making a silly beginner's mistake or I have been snagged by a pretty large bug in the Windows version of MonetDB. I have specified the exact steps I've taken below - so you can reproduce my problem exactly. In the original post, I provided the output of the PLAN and EXPLAIN commands in the hopes they might illuminate what's causing the problem. Please help!
---------- Forwarded message ---------- From: Anthony Damico ajdamico@gmail.com Date: Fri, Sep 28, 2012 at 1:36 PM Subject: invalid tuple received from server, got 138 columns, expected 476, ignoring To: users-list@monetdb.org
Hi everyone, I just wanted to follow-up on a previous post (available at http://mail.monetdb.org/pipermail/users-list/2012-September/005773.html) about an odd 'invalid tuple received' problem with a bit more detail and a simplified way to replicate everything. I've attached the results of PLAN and EXPLAIN in case that's of any value. The behavior of MonetDB seems strange, since I am able to select count(*) from table; and select every individual column from the table, but not select * from table;
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
Out of all of the commands posted below, only
sql>select * from household limit 5 ;
gives an error. It says:
invalid tuple received from server, got 138 columns, expected 202, ignoring
I assume this is a windows-related problem? I am using this in windows 7, x64.
Any help would be appreciated! Thanks!!!
Here are my SQL commands verbatim:
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:\Users\AnthonyD\Desktop\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 ;
select 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 from household limit 5;
select 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 from household limit 5;
select 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 from household limit 5;
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
On Fri, Oct 12, 2012 at 10:21:37PM -0400, Anthony Damico wrote:
Hi, I am still struggling with this issue and have not received any response. I am either making a silly beginner's mistake or I have been snagged by a pretty large bug in the Windows version of MonetDB. I have specified the exact steps I've taken below - so you can reproduce my problem exactly. In the original post, I provided the output of the PLAN and EXPLAIN commands in the hopes they might illuminate what's causing the problem. Please help!
Anthony
On linux is works indeed without problems. Which version of MonetDB are you using? Could you create a bug on our bugzilla, see bugs.monetdb.org, and include these details ?
Niels
---------- Forwarded message ---------- From: Anthony Damico ajdamico@gmail.com Date: Fri, Sep 28, 2012 at 1:36 PM Subject: invalid tuple received from server, got 138 columns, expected 476, ignoring To: users-list@monetdb.org
Hi everyone, I just wanted to follow-up on a previous post (available at http://mail.monetdb.org/pipermail/users-list/2012-September/ 005773.html) about an odd 'invalid tuple received' problem with a bit more detail and a simplified way to replicate everything. I've attached the results of PLAN and EXPLAIN in case that's of any value. The behavior of MonetDB seems strange, since I am able to select count (*) from table; and select every individual column from the table, but not select * from table;
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
Out of all of the commands posted below, only
sql>select * from household limit 5 ;
gives an error. It says:
invalid tuple received from server, got 138 columns, expected 202, ignoring
I assume this is a windows-related problem? I am using this in windows 7, x64.
Any help would be appreciated! Thanks!!!
Here are my SQL commands verbatim:
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:\Users\AnthonyD\ Desktop\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 ;
select 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 from household limit 5;
select 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 from household limit 5;
select 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 from household limit 5;
users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
The error is reported by mclient, which may indicate a buffer management issue on Windows when tuples are transported from the server.
regards, Martin
On 10/13/12 8:41 AM, Niels Nes wrote:
On Fri, Oct 12, 2012 at 10:21:37PM -0400, Anthony Damico wrote:
Hi, I am still struggling with this issue and have not received any response. I am either making a silly beginner's mistake or I have been snagged by a pretty large bug in the Windows version of MonetDB. I have specified the exact steps I've taken below - so you can reproduce my problem exactly. In the original post, I provided the output of the PLAN and EXPLAIN commands in the hopes they might illuminate what's causing the problem. Please help!
Anthony
On linux is works indeed without problems. Which version of MonetDB are you using? Could you create a bug on our bugzilla, see bugs.monetdb.org, and include these details ?
Niels
---------- Forwarded message ---------- From: Anthony Damico ajdamico@gmail.com Date: Fri, Sep 28, 2012 at 1:36 PM Subject: invalid tuple received from server, got 138 columns, expected 476, ignoring To: users-list@monetdb.org
Hi everyone, I just wanted to follow-up on a previous post (available at http://mail.monetdb.org/pipermail/users-list/2012-September/ 005773.html) about an odd 'invalid tuple received' problem with a bit more detail and a simplified way to replicate everything. I've attached the results of PLAN and EXPLAIN in case that's of any value. The behavior of MonetDB seems strange, since I am able to select count (*) from table; and select every individual column from the table, but not select * from table;
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
Out of all of the commands posted below, only
sql>select * from household limit 5 ;
gives an error. It says:
invalid tuple received from server, got 138 columns, expected 202, ignoring
I assume this is a windows-related problem? I am using this in windows 7, x64.
Any help would be appreciated! Thanks!!!
Here are my SQL commands verbatim:
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:\Users\AnthonyD\ Desktop\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 ;
select 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 from household limit 5;
select 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 from household limit 5;
select 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 from household limit 5;
users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
Thanks to both of you!
Niels, I have just submitted a bug report - http://bugs.monetdb.org/show_bug.cgi?id=3161
Martin, is there something I am able to do to deal with this on my own, or should I wait for your team to take a closer look? Like I said, I'm still a beginner with MonetDB. :)
I am not sure it is solely an mclient problem: I hit the same error when connecting to the server using Java with http://sqlsurvey.r-forge.r-project.org/
I hope it's okay that I marked the bug report 'Critical' -- being unable to query about 100 columns at a time (sometimes more, sometimes less) has been a major hindrance to our work. The sqlsurvey sotware (from the link above) pulls in the American Community Survey's 80 replicate survey weights in addition to the actual survey questions, so almost every SELECT statement initiated by that software requires selecting more than 100 columns. Until it's fixed, the sqlsurvey software is unusable in Windows. I'm hoping whatever fix might be included in the October release.
Just so you know how helpful MonetDB will be: once this is resolved, I will be able to publish a combination of R and MonetDB code that will allow individuals to use the American Community Survey (America's largest annual survey) for free. I've published similar code for America's Current Population Survey here - http://usgsd.blogspot.com - but more people will be interested in analyzing ACS. I am terribly excited about this work, so thank you again!!
On Sat, Oct 13, 2012 at 4:33 AM, Martin Kersten Martin.Kersten@cwi.nlwrote:
The error is reported by mclient, which may indicate a buffer management issue on Windows when tuples are transported from the server.
regards, Martin
On 10/13/12 8:41 AM, Niels Nes wrote:
On Fri, Oct 12, 2012 at 10:21:37PM -0400, Anthony Damico wrote:
Hi, I am still struggling with this issue and have not received any response. I am either making a silly beginner's mistake or I have been snagged by a pretty large bug in the Windows version of MonetDB. I have specified the exact steps I've taken below - so you can reproduce my problem exactly. In the original post, I provided the output of the PLAN and EXPLAIN commands in the hopes they might illuminate what's causing the problem. Please help!
Anthony
On linux is works indeed without problems. Which version of MonetDB are you using? Could you create a bug on our bugzilla, see bugs.monetdb.org, and include these details ?
Niels
---------- Forwarded message ---------- From: Anthony Damico ajdamico@gmail.com Date: Fri, Sep 28, 2012 at 1:36 PM Subject: invalid tuple received from server, got 138 columns, expected 476, ignoring To: users-list@monetdb.org
Hi everyone, I just wanted to follow-up on a previous post (available at http://mail.monetdb.org/**pipermail/users-list/2012-**September/http://mail.monetdb.org/pipermail/users-list/2012-September/ 005773.html) about an odd 'invalid tuple received' problem with a bit more detail and a simplified way to replicate everything. I've attached the results of PLAN and EXPLAIN in case that's of any value. The behavior of MonetDB seems strange, since I am able to select count (*) from table; and select every individual column from the table, but not select * from table;
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.ziphttp://www2.census.gov/acs2010_1yr/pums/csv_hak.zip
Out of all of the commands posted below, only
sql>select * from household limit 5 ;
gives an error. It says:
invalid tuple received from server, got 138 columns, expected 202, ignoring
I assume this is a windows-related problem? I am using this in windows 7, x64.
Any help would be appreciated! Thanks!!!
Here are my SQL commands verbatim:
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:\Users\AnthonyD\ Desktop\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 ;
select 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 from household limit 5;
select 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 from household limit 5;
select 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 from household limit 5;
______________________________**_________________
users-list mailing list users-list@monetdb.org http://mail.monetdb.org/**mailman/listinfo/users-listhttp://mail.monetdb.org/mailman/listinfo/users-list
______________________________**_________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/**mailman/listinfo/users-listhttp://mail.monetdb.org/mailman/listinfo/users-list
______________________________**_________________
users-list mailing list users-list@monetdb.org http://mail.monetdb.org/**mailman/listinfo/users-listhttp://mail.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
Since it related to the Windows platform (not or primary development platform ;)) things are pretty hard (our Windows expert is on holiday;))
But we can perhaps reduce the problem space.
On 10/13/12 3:04 PM, Anthony Damico wrote:
Thanks to both of you!
Niels, I have just submitted a bug report - http://bugs.monetdb.org/show_bug.cgi?id=3161
Martin, is there something I am able to do to deal with this on my own, or should I wait for your team to take a closer look? Like I said, I'm still a beginner with MonetDB. :)
I am not sure it is solely an mclient problem: I hit the same error when connecting to the server using Java with http://sqlsurvey.r-forge.r-project.org/
I hope it's okay that I marked the bug report 'Critical' -- being unable to query about 100 columns at a time (sometimes more, sometimes less) has been a major hindrance to our work. The sqlsurvey sotware (from the link above) pulls in the American Community Survey's 80 replicate survey weights in addition to the actual survey questions, so almost every SELECT statement initiated by that software requires selecting more than 100 columns. Until it's fixed, the sqlsurvey software is unusable in Windows. I'm hoping whatever fix might be included in the October release.
Just so you know how helpful MonetDB will be: once this is resolved, I will be able to publish a combination of R and MonetDB code that will allow individuals to use the American Community Survey (America's largest annual survey) for free. I've published similar code for America's Current Population Survey here - http://usgsd.blogspot.com - but more people will be interested in analyzing ACS. I am terribly excited about this work, so thank you again!!
On Sat, Oct 13, 2012 at 4:33 AM, Martin Kersten <Martin.Kersten@cwi.nl mailto:Martin.Kersten@cwi.nl> wrote:
The error is reported by mclient, which may indicate a buffer management issue on Windows when tuples are transported from the server. regards, Martin On 10/13/12 8:41 AM, Niels Nes wrote: On Fri, Oct 12, 2012 at 10:21:37PM -0400, Anthony Damico wrote: Hi, I am still struggling with this issue and have not received any response. I am either making a silly beginner's mistake or I have been snagged by a pretty large bug in the Windows version of MonetDB. I have specified the exact steps I've taken below - so you can reproduce my problem exactly. In the original post, I provided the output of the PLAN and EXPLAIN commands in the hopes they might illuminate what's causing the problem. Please help! Anthony On linux is works indeed without problems. Which version of MonetDB are you using? Could you create a bug on our bugzilla, see bugs.monetdb.org <http://bugs.monetdb.org>, and include these details ? Niels ---------- Forwarded message ---------- From: Anthony Damico <ajdamico@gmail.com <mailto:ajdamico@gmail.com>> Date: Fri, Sep 28, 2012 at 1:36 PM Subject: invalid tuple received from server, got 138 columns, expected 476, ignoring To: users-list@monetdb.org <mailto:users-list@monetdb.org> Hi everyone, I just wanted to follow-up on a previous post (available at http://mail.monetdb.org/__pipermail/users-list/2012-__September/ <http://mail.monetdb.org/pipermail/users-list/2012-September/> 005773.html) about an odd 'invalid tuple received' problem with a bit more detail and a simplified way to replicate everything. I've attached the results of PLAN and EXPLAIN in case that's of any value. The behavior of MonetDB seems strange, since I am able to select count (*) from table; and select every individual column from the table, but not select * from table; 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 <http://www2.census.gov/acs2010_1yr/pums/csv_hak.zip> Out of all of the commands posted below, only sql>select * from household limit 5 ; gives an error. It says: invalid tuple received from server, got 138 columns, expected 202, ignoring I assume this is a windows-related problem? I am using this in windows 7, x64. Any help would be appreciated! Thanks!!! Here are my SQL commands verbatim: 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:\Users\AnthonyD\ Desktop\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 ; select 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 from household limit 5; select 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 from household limit 5; select 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 from household limit 5; _________________________________________________ users-list mailing list users-list@monetdb.org <mailto:users-list@monetdb.org> http://mail.monetdb.org/__mailman/listinfo/users-list <http://mail.monetdb.org/mailman/listinfo/users-list> _________________________________________________ users-list mailing list users-list@monetdb.org <mailto:users-list@monetdb.org> http://mail.monetdb.org/__mailman/listinfo/users-list <http://mail.monetdb.org/mailman/listinfo/users-list> _________________________________________________ users-list mailing list users-list@monetdb.org <mailto:users-list@monetdb.org> http://mail.monetdb.org/__mailman/listinfo/users-list <http://mail.monetdb.org/mailman/listinfo/users-list>
users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
participants (3)
-
Anthony Damico -
Martin Kersten -
Niels Nes