- users-list - monetdb.org

--enable-sql option at the time of compilation
by Medha Atre 21 Oct '12

21 Oct '12

Hi, Is it necessary to give --enable-sql option at the time of compilation if one wants to use SQL as the query language or does it have some other connotation? The reason for asking is, if I give --enable-sql option, the configure script compels me to give --enable-monetdb5 option too. I am not sure how these options make difference internally to the MonetDB server, since as per the MonetDB website SQL is the de facto language for querying DBs and that is what is used by MonetDB as well. Can someone please enlighten? Thanks. Medha _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

3 3

Re: Improving performance of "select * from table" ?
by Stefan Manegold 17 Oct '12

17 Oct '12

Hi Gordon, indeed, your experiments confirm that most of the time is spent in serializing, sending, and re-parsing your queries huge result. I am wondering what kind of application needs to see the entire database table? No user can seriously handle millions of result tuples with tens (or more) of columns? What is the purpose of using a DBMS if all it needs to do is select * from table ? In my/our opinion, as much as possible of the application logic should be expressed in SQL (plus domain-/application specific extension, if required) and (thus) performed in the DBMS, resulting in only small results that need to be sent back to the client/application. Then the efficiency and performance of the DBMS (server) itself is dominating and more important than the server-client communication. Best, Stefan Assaf Gordon <gordon(a)cshl.edu> wrote: Hello Stefan, > Stefan de Konink wrote, On 10/16/2012 06:49 PM: >> [...] >> What about: the time taken to serialise the results? For MonetDB this is done in a very 'plain text' wire-format. >> [...] >> Are you aware of the PostgreSQL \timing command? In that way you can see outputs similar to that of MonetDB with respect of time taken for a query. > I re-run one test using psql's and mclient's internal timing. === ## Postgres: Select all columns from table $ psql test test=# \o /dev/null test=# \timing Timing is on. test=# select * from bc251; Time: 5506.768 ms test=# select * from bc251; Time: 5446.689 ms test=# ## MonetDB: Select all columns from table $ mclient -d voc sql>\>/dev/null sql>\w-1 sql>select * from bc251; 1657032 tuples (3.8s) sql>select * from bc251; 1657032 tuples (3.8s) sql> === As you said, the reported durations are much shorter than in my previous timings (monetDb: 3.8s vs 2m16s, postgres 5.5s vs 21s). However, those numbers don't reveal the entire story: mclient reports 3.8 seconds, but it took more than 2 minutes (of wall time) for the result message to be printed. I understand that this quite possibly indicates a serialization/transfer bottle-neck, and it could be of lesser interest to the developers, but as an application developer I worry about the end-to-end timing of the query - the time it takes for my application to get the data back. If there are any recommendation on improving those queries, it would be much appreciated. Thanks, -gordon _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

3 4

RE: problem with monetdb functionality
by Stefan Manegold 17 Oct '12

17 Oct '12

Shajon, 1. Do you have any evidence in terms of experiments that shows that MonetDB is slow(er) due to not allowing to set multiple variables in a select clause? Can you give example queries and their performance? 2. >From you rather short description, we cannot say much about this. Beware that your systems state may have a significant influence on performance, e.g., - for point (single value select) predicates, the first query builds a has table, while subsequent queries benefit from this hash table; - the first query needs to load the data from disk, while subsequent queries might benefit from (parts of) the data already/still being in memory; in MonetDB itself while the server is running, or in the OS's filesystem cache even after a server restart; - etc. Best, Stefan Shajon <alam(a)finEngine.com> wrote: From: Shajon [mailto:alam@finEngine.com] Sent: Tuesday, October 09, 2012 1:47 PM To: 'users-list(a)monetdb.org' Subject: FW: problem with monetdb functionality From: Shajon [mailto:alam@finEngine.com] Sent: Tuesday, October 09, 2012 12:49 PM To: 'info(a)monetdb.com' Subject: problem with monetdb functionality Hi, I am using monetdb to process millions of records. now I am getting two problem 1. I could not set multiple variable in select query in a function or procedure. For example: select @var1=col1, @var2=col2 from table_name. as like sql server or Sybase database. If I could do ,it would reduce considerable amount of time for some function execution. So do I need to write MAL or any other way? 2. Sometimes same query takes different time in different moment. For example a query at the starting time of server takes 2ms and 10 hours later it takes 14s. if I close & restart server & client its ok. Can anyone suggest me what can I do? Thanks Shajon _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

3 2

Improving performance of "select * from table" ?
by Assaf Gordon 17 Oct '12

17 Oct '12

Hello, I'm getting phenomenal performance with MonetDB with almost all of my query types, except one: The most basic "SELECT * FROM mytable WHERE (SOMETHING)" query takes much longer than other RDBMs (mysql, postgresql). Even "SELECT * FROM mytable LIMIT 10;" takes significantly more time than with other databases (and the more columns the table has, the more time it takes). I understand this is not the scenario that MonetDB was designed to address, but perhaps there's a way to improve it? (It's a requirement for my project to be able to export some/all of the data in a table.) Thanks, -gordon _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

3 5

Re: Improving performance of "select * from table" ?
by Stefan Manegold 17 Oct '12

17 Oct '12

Assaf, do you have a specific reason to use an arbitrary snapshot of the instable development branch of MonetDB? If not, I'd strongly recommend to use the latest Jun2012-SP2 release, respectively the Jun2012 release branch. We'd be curious to learn whether the latest release work better for your data & queries than the development branch. Best, Stefan Assaf Gordon <gordon(a)cshl.edu> wrote: Hello Jennie, Ying Zhang wrote, On 10/16/2012 04:46 PM: > > How many columns and rows does you table have? How many rows does the first query return? what are the execution times of this query on mysql, postgresql and monetdb, respectively? > Below are some test results. Both servers (postgres and mserver) and clients (psql and mclient) are running on the same machine, with 8 cores and 16GB of RAM. The machine was not overloaded during the tests. The databases are stored on the same disk. I've run each test (except 5) couple of times, and listed most common result (so it's not about caching). Using PostgreSQL 9.2.1 (compiled from source) and MonetDB v11.14.0/unreleased (compiled from source). I can provide more technical details if needed. Assuming the "user" time is the time "wasted" by the client program (psql/mclient), and assuming "sys" time is negligible, then subtracting the "user" time from the "real" time gives an indication of how much time the server took to complete the query and transfer the results. It seems in most of those queries, the MonetDB server takes longer than PostgreSQL to complete. One striking difference is test #6 that needs to return just one line: the execution time for MonetDB is 9 seconds - I guess accessing 138 columns takes its toll... ## ## First table (bc251): 1,657,032 rows, 13 columns ## ## MonetDB Table size sql>select "schema", "table", sum("size") as size from storage() group by "schema","table" having "table" = 'bc251' ; +--------+-------+-----------+ | schema | table | size | +========+=======+===========+ | sys | bc251 | 132775936 | +--------+-------+-----------+ ## PostgreSQL Table Sql test=# SELECT pg_size_pretty(pg_relation_size('bc251')); pg_size_pretty ---------------- 212 MB (1 row) ## Test 1: select ONE column ## MonethDB $ time mclient -d voc -s "select seq from bc251;" > /dev/null real 0m15.981s user 0m5.653s sys 0m0.106s ## PostgreSQL $ time echo "select seq from bc251" | psql test > /dev/null real 0m3.565s user 0m2.698s sys 0m0.154s ## Test 2: select ALL columns ## MonetDB $ time mclient -d voc -s "select * from bc251;" > /dev/null real 2m16.388s user 0m38.468s sys 0m0.448s ## PostgreSQL $ time echo "select * from bc251" | psql test > /dev/null real 0m21.771s user 0m17.045s sys 0m0.843s ## Test 3: Select ONE row ## MonetDB $ time mclient -d voc -s "select * from bc251 limit 1" > /dev/null real 0m0.053s user 0m0.003s sys 0m0.004s ## PostgreSQL $ time echo "select * from bc251 limit 1" | psql test > /dev/null real 0m0.072s user 0m0.013s sys 0m0.009s ## ## Second table (NR102): 3,042,983 rows, 138 columns ## ## MonetDB Table Size sql>select "schema", "table", sum("size") as size from storage() group by "schema","table" having "table" = 'nr102' ; +--------+-------+------------+ | schema | table | size | +========+=======+============+ | sys | nr102 | 1408630784 | +--------+-------+------------+ 1 tuple (5.567ms) ## PostgreSQL Table Size test=# SELECT pg_size_pretty(pg_relation_size('NR102')); pg_size_pretty ---------------- 1850 MB (1 row) ## Test 4: Select ONE column ## MonetDB $ time mclient -d voc -s "select seq from NR102;" > /dev/null real 0m29.882s user 0m7.574s sys 0m0.107s ## PostgreSQL $ time echo "select seq from NR102" | psql test > /dev/null real 0m6.925s user 0m4.906s sys 0m0.268s ## Test 5: Select ALL columns ## MonetDB $ time mclient -d voc -s "select * from NR102;" > /dev/null real 39m58.618s user 10m9.066s sys 0m4.468s ## PostgreSQL $ time echo "select * from NR102" | psql test > /dev/null real 4m0.840s user 3m20.866s sys 0m12.592s ## Test 6: Select ONE row ## MonetDB $ time mclient -d voc -s "select * from NR102 limit 1" > /dev/null real 0m9.055s user 0m0.004s sys 0m0.008s ## PostgreSQL $ time echo "select * from NR102 limit 1" | psql test > /dev/null real 0m0.160s user 0m0.016s sys 0m0.006s _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

2 1

How to enable Datacell?
by Chang Ge 16 Oct '12

16 Oct '12

Hi, I am using MonetDB 11.11.11, and I am very interested in the data cell externsion. I followed the doc (http://www.monetdb.org/Documentation/Extensions/Streams) but at the first step when I tried to set datacell optimizer, it said sql>set optimizer='datacell_pipe'; SyntaxException:parseError: ';' expected Syntax error detected.See documentation for details Does anyone know how to use datacell? Thanks very much! Best regards, Chang _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

2 1

Confusion about concurrency with regards to DDL and Insert Into / Select From
by Percy Wegmann 14 Oct '12

14 Oct '12

I'm very new to MonetDB and am just starting to play around with it. One of the things I'm trying to get my head around is the concurrency model. I've observed some things that make sense and others that I don't understand. 1. Concurrent COPY commands into the same table will cause one or the other to roll back. This makes sense as MonetDB seems to lock at the table level. 2. SELECTing data from a table that concurrently has a COPY command running against it doesn't seem to produce any concurrency errors 3. However, if I INSERT INTO table_B (SELECT ... FROM table_A) while a COPY command is running against table_A, I do get concurrency conflicts 4. Also, if I have a COPY command running into table_A and concurrently issue DDL creating a new table_B, I get a concurrency conflict as well Observations 3+4 seem to indicate that DDL operations and INSERT ... SELECT FROM ... use some sort of database-wide lock. This begs the following questions: a) Is there in fact database-wide locking going on here? b) Is there a workaround that would allow me to issue DDL and make also internal copies of tables while concurrently loading data into other tables? c) Is there something fundamental about the architecture of the database that requires database-wide locking for these ops or is this just a detail of the current implementation that could potentially be ironed out? Thanks! Percy _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

2 2

invalid tuple received from server, got 138 columns, expected 476, ignoring
by Anthony Damico 13 Oct '12

13 Oct '12

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(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

3 5

Insufficient priveleges while calling vaccum
by Ashish Kumar Singh 12 Oct '12

12 Oct '12

HI List, I have created a schema test user user testuser. While calling vacuum on one of its tables I am getting error : call vacuum(test,'testtable'); insufficient privileges Any examples on how to elevate priveleges for test user will be helpful! Regards, Ashish _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

1 0

Lock monetdb funnel behaviour
by Tapomay Dey 10 Oct '12

10 Oct '12

Hi, I have created two databases db1 and db2 and created a user "tapomay" on both with dedicated schema as given in the Getting Started page - http://www.monetdb.org/Downloads/Tutorial I have created a monetdb multiplex-funnel "testfunnel" pointing to them. When I do monetdb lock db1, I can access db1 using user "monetdb"(as expected) but not through user tapomay(as expected). But when I do monetdb lock testfunnel, I can still access it using user tapomay. I need it to stay unavailable. Also when I follow it by monetdb stop testfunnel and then try to access it using user tapomay, then it says that it's under maintenance. FYI, Regards, Tapomay _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

2 2

Question: How well does Monetdb support incremental updates?
by David Sisk 05 Oct '12

05 Oct '12

Question for you kind folks. I've tested another open source column-store database (Infinidb)...the query performance was very good, the bulk load performance was good, but where it fell down was on refreshing the data by updating a small percentage of the existing values. Bulk loads processed about 1000 rows/second...updating existing rows processed only about 1 row/second. We have growing 60-70Gb data warehouse, and we don't want to drop and re-load it every night, we want to just apply incremental updates at very short intervals throughout the day (say, every 5 mins). So, how well will Monetdb handle updates to existing rows in this scenario? One additional question: Are there any sources of commercial support for Monetdb? Thanks and best regards, -- Dave Sisk | Senior DBA dsisk(a)lulu.com | www.lulu.com [m] 919-744-1885 _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

1 0

Is there a MonetDB wiki ?
by Assaf Gordon 03 Oct '12

03 Oct '12

Hello, I'm new to MonetDB, and I find the documentation very terse. Is there a wiki for MonetDB ? Or perhaps a possibility to add comments on each of the manual-pages (like the PHP manual website, where users can elaborate and add examples on each function) ? Even a search on the mailing list archive would be helpful (but not the SourceForge search, it's very unfriendly). Thanks, -gordon _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

2 1

How to repair a database?
by Assaf Gordon 03 Oct '12

03 Oct '12

Hello, While loading a large file into a MonetDB database, my server crashed (the physical machine, not the MonetDB server process). After rebooting the machine and restarting MonetDB, almost every query crashes the MonetDB server: == $ mclient -d voc Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased) Database: MonetDB v11.14.0 (unreleased), 'mapi:monetdb://chachacha.cshl.edu:50000/voc' Type \q to quit, \? for a list of available commands auto commit mode: on sql>select * from bc251 limit 10 ; Connection terminated $ tail merovingian.log <snip> 2012-10-03 15:53:51 MSG merovingian[4001]: proxying client (local) for database 'voc' to mapi:monetdb:///localdata/gordon/monetdb/testdb4/voc/.mapi.sock?database=voc 2012-10-03 15:53:51 MSG merovingian[4001]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying 2012-10-03 15:53:58 MSG merovingian[4001]: database 'voc' (4043) was killed by signal SIGSEGV == The database contains several tables, and queries on all of them result in monetdb server crash. How do I fix the database ? I tried "monetdbd stop + start", and also "monetdb lock + release", but to no avail. Thanks, -gordon BTW, It is likely that some of the database files are corrupted (due to the physical server crash). _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

2 1

Need name of columns in unique key of a table
by Tapomay Dey 03 Oct '12

03 Oct '12

I have following table: CREATE TABLE "sys"."tapomay3" ( "id" INTEGER, "val" VARCHAR(20), "valnum" INTEGER NOT NULL, CONSTRAINT "pk3" PRIMARY KEY ("valnum"), CONSTRAINT "tapomay3_id_val_unique" UNIQUE ("id", "val") ); I need to get the list of column names that are part of any unique key. sql>select o.name from keys k, objects o where k.id in (select id from keys where table_id = (select id from tables where name='tapomay3') and name like '%unique') and o.id = k.id; +---------+ | name | +=========+ | id | | val | +---------+ select o.name from keys k, objects o where k.id in (select id from keys where table_id = (select id from tables where name='tapomay3') and name like '%unique') and o.id = k.id Is this the right approach? Thanks and Regards, Tapomay. _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

1 0

Question about temporary tables - empty data?
by Assaf Gordon 01 Oct '12

01 Oct '12

Hello, I need to create temporary tables, but using the statement "create temporary table AS select XXX WITH DATA" results in an empty table; ==== sql>CREATE TABLE table1 (a INTEGER); operation successful (1.320ms) sql>INSERT INTO table1 VALUES(1); 1 affected row (0.693ms) sql>INSERT INTO table1 VALUES(2); 1 affected row (0.511ms) sql> sql>CREATE TEMPORARY TABLE temp1 AS SELECT * FROM table1 WITH DATA ; operation successful (0.735ms) sql>SELECT * FROM temp1; +---+ | a | +===+ +---+ 0 tuples (1.032ms) === Whereas if I don't use "temporary" for the table creation, it works fine: === sql>CREATE TABLE temp2 AS SELECT * FROM table1 WITH DATA ; operation successful (1.842ms) sql>SELECT * FROM temp2; +------+ | a | +======+ | 1 | | 2 | +------+ 2 tuples (1.898ms) === The example above is contrived, but I need to create two temporary tables to facilitate a join. Does the "temporary" keyword have different meaning than in other databases ? I couldn't find a good explanation in the on-line documentation... I'm using MonetDB v11.14.0, compiled from source with revision 45564:14983b3e103e . Thanks, -gordon _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

2 2

users-list post from ajdamico@gmail.com requires approval
by users-list-owner＠monetdb.org 28 Sep '12

28 Sep '12

As list administrator, your authorization is requested for the following mailing list posting: List: users-list(a)monetdb.org From: ajdamico(a)gmail.com Subject: invalid tuple received from server, got 138 columns, expected 476, ignoring Reason: Post by non-member to a members-only list At your convenience, visit: http://mail.monetdb.org/mailman/admindb/users-list to approve or deny the request.

1 0

problem starting database
by Peter 28 Sep '12

28 Sep '12

Hello, I'm seeing this error when starting a database. Not sure if anyone has had the same issue and whether anyone had a fix? The following is what I did % monetdbd start ~/dbfarm % monetdbd start ~/dbfarm % monetdb create voc % monetdb start voc starting database 'voc'... FAILED start: starting 'voc' failed: database 'voc' appears to shut itself down after starting, check monetdbd's logfile for possible hints The log says the following 2012-09-27 16:56:04 MSG merovingian[14761]: database 'voc' (14801) has exited with exit status 1 2012-09-27 16:56:04 ERR control[14761]: (local): failed to fork mserver: database 'voc' appears to shut itself down after starting, check monetdbd's logfile for possible hints Any comments / suggestions? Thank you, Peter _______________________________________________ users-list mailing list users-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

3 7

[MonetDB-users] Array database for large matrix
by Joshua Shuai Yuan 27 Sep '12

27 Sep '12

Hi All, I just tried monetdb with large tables (600,000 rows by 50,000 columns). There are two issues: 1. performance was low, it took about 4 seconds to insert a row of record when the number of columns was large (50,000). However it was pretty fast (about 100 rows per second) when the column number was small (for example, 10). 2. serious errors occurred very often. For example, after inserting random number of records (50, for example), monetdb started to report errors, like: monetdbd: internal error while starting mserver, please refer to the logs So I opened the log file, and the error was: 2012-09-14 08:26:36 ERR merovingian[13730]: client error: unknown or impossible state: 4 The Makefile (it is also contained in the attachments) listed below will start database server, create a database farm, create a database, create a big table and then insert records to the big table. Here it is: #=====start of Makefile===================== ROW_NUM=600000 COLUMN_NUM=50000 COLUMN_NUM_MINUS_ONE=$(shell echo $(COLUMN_NUM)-1 | bc) all: clean monetdbd create ./mydbfarm monetdbd start ./mydbfarm monetdb create test_big_db monetdb release test_big_db make create_table_sql -s > create_big_table.sql make insert_data_sql -s > insert_data.sql mclient -d test_big_db create_big_table.sql for i in $$(seq 1 $(ROW_NUM)); do \ mclient -d test_big_db insert_data.sql ;\ echo 'done inserting ' $$i ' rows'; \ done; mclient -d test_big_db -s "select * from test_big_table" > test_big_table.txt create_table_sql: @echo 'START TRANSACTION;' @echo 'CREATE TABLE "test_big_table" (' @for i in $$(seq 1 $(COLUMN_NUM_MINUS_ONE)); do \ echo ' "gen'$$i'" DOUBLE,'; \ done @echo ' "gen$(COLUMN_NUM)" DOUBLE' @echo ');' @echo 'COMMIT;' insert_data_sql: @echo -n 'INSERT INTO "test_big_table" VALUES (' ; @for j in $$(seq 1 $(COLUMN_NUM_MINUS_ONE)) ; do \ echo -n '0.323, '; \ done; @echo '0.324);'; insert_all_data_sql: @echo 'START TRANSACTION;' @for i in $$(seq 1 $(ROW_NUM)); do\ echo -n 'INSERT INTO "test_big_table" VALUES (' ;\ for j in $$(seq 1 $(COLUMN_NUM_MINUS_ONE)) ; do \ echo -n '0.323, '; \ done; \ echo '0.324);'; \ done @echo 'COMMIT;' clean: -killall mserver5 -killall monetdbd rm -rf ./mydbfarm rm -rf create_big_table.sql test_big_table.txt insert_data.sql #=====end of Makefile====================== Thank you very much ! Best wishes, Joshua Shuai Yuan On Thu, Sep 13, 2012 at 12:43 PM, Joshua Shuai Yuan < shuaiyuan.emory(a)gmail.com> wrote: > Sure, I will see what I can do. > > Best wishes, > Joshua Shuai Yuan > > > On Wed, Sep 12, 2012 at 11:40 PM, Wang, Fusheng <fusheng.wang(a)emory.edu>wrote: > >> Hi Joshua,**** >> >> ** ** >> >> The table we are managing is in the scale of 30K x 5K: 150M cells. If >> each table cell (double type) needs 8 bytes to represent (ideally), the >> space needed will be a couple of GB, or at most, in the scale of tens of >> GB. If that is the case, distributed setup may not be needed, as the data >> can be mostly cached by the database. MonetDB does support multi-cores >> and multi-disks, but setup across multiple machines is not supported based >> on my knowledge. **** >> >> ** ** >> >> Even though MonetDB claims unlimited number of columns, we should still >> be cautious on what performance we can achieve for the queries we want to >> provide. A pilot study on this could provide us some guideline. Do you >> think you can setup MonetDB, and create a benchmark table we can do some >> performance study?**** >> >> ** ** >> >> Interestingly, the large column issue is also discussed in a famous >> database blog:**** >> >> >> http://www.dbms2.com/2011/03/13/so-how-many-columns-can-a-single-table-have… >> **** >> >> ** ** >> >> One guy commented:**** >> >> ** ** >> >> “Genomics models were the primary driver. these folks typically have >> short but wide datasets of the order of 300,000 columns.”**** >> >> ** ** >> >> So we are not alone. And we have only a subset of the columns (30K >> versus 300K)? Then we are lucky!**** >> >> ** ** >> >> ** ** >> >> Fusheng**** >> >> ** ** >> >> ** ** >> >> ** ** >> >> ** ** >> >> *From:* Joshua Shuai Yuan [mailto:shuaiyuan.emory@gmail.com] >> *Sent:* Wednesday, September 12, 2012 11:14 PM >> *To:* Wang, Fusheng >> *Cc:* Qin, Zhaohui >> *Subject:* Re: Array database for large matrix**** >> >> ** ** >> >> Hi Dr. Wang,**** >> >> That's really a good news. Does it support distributed database? Or do >> we need distributed one?**** >> >> ** ** >> >> >> Best wishes, >> Joshua Shuai Yuan >> >> **** >> >> On Wed, Sep 12, 2012 at 3:54 PM, Wang, Fusheng <fusheng.wang(a)emory.edu> >> wrote:**** >> >> Hi guys,**** >> >> **** >> >> It looks like the matrix structure can be nicely supported by array >> databases, like MonetDB. It supports unlimited number of columns for a >> table. It’s also open source. **** >> >> http://www.monetdb.org/Home/Features**** >> >> **** >> >> I know the group quite well, and I will chat with them on the use case to >> see if it’s a good fit. **** >> >> **** >> >> Thanks,**** >> >> **** >> >> Fusheng**** >> >> **** >> >> **** >> >> ** ** >> ------------------------------ >> >> >> This e-mail message (including any attachments) is for the sole use of >> the intended recipient(s) and may contain confidential and privileged >> information. If the reader of this message is not the intended >> recipient, you are hereby notified that any dissemination, distribution >> or copying of this message (including any attachments) is strictly >> prohibited. >> >> If you have received this message in error, please contact >> the sender by reply e-mail message and destroy all copies of the >> original message (including attachments).**** >> >> ** ** >> > >

2 2

[MonetDB-users] MonetDB project will move to monetdb.org
by Fabian Groffen 26 Sep '12

26 Sep '12

We would like to inform you that as of Januari 2013, the monetdb project on SourceForge will be removed. All services that SourceForge has kindly provided us with in the past will be migrated to our monetdb.org infrastructure. Currently, the only remaining services hosted on SourceForge are the three mailing lists monetdb-announce, monetdb-users and monetdb-developers. As of this message, these lists are migrated to their equivalents on monetdb.org. The new lists are as follows: monetdb-announce(a)lists.sourceforge.net -> announce-list(a)monetdb.org monetdb-users(a)lists.sourceforge.net -> users-list(a)monetdb.org monetdb-developers(a)lists.sourceforge.net -> developers-list(a)monetdb.org We invite you to subscribe to the new lists on monetdb.org at your earliest convenience. Any posts to the old lists are rejected from now on. Posts to the new lists at monetdb.org are forwarded in batches to the old lists until the end of this year. The MonetDB team would like to take this opportunity to thank SourceForge for the services provided over the past years. We hope to welcome all current subscribers on our new lists at monetdb.org, see: http://mail.monetdb.org/mailman/listinfo The MonetDB team

1 0

[MonetDB-users] invalid tuple received from server, got 138 columns, expected 476, ignoring
by Anthony Damico 26 Sep '12

26 Sep '12

Hello, I'm pretty new to MonetDB and I'm trying to perform what seems like it should be a relatively straightforward inner join between two tables. I would like to merge the two Alaska files from the American Community Survey -- http://www2.census.gov/acs2010_1yr/pums/csv_hak.zip contains a CSV file with one record per household http://www2.census.gov/acs2010_1yr/pums/csv_pak.zip contains a CSV file with one record per personThese two files should be merged on the field "serialno" I am working on Windows 7 x64. Here's the contents of my mserver5.exe window: # MonetDB 5 server v11.11.11 "Jul2012-SP2" # Serving database 'demo', using 2 threads # Compiled for x86_64-pc-winnt/64bit with 64bit OIDs dynamically linked # Found 3.905 GiB available main-memory. # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2012 MonetDB B.V., all rights reserved # Visit http://www.monetdb.org/ for further information # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ # MonetDB/SQL module loaded > The following commands.. 1) create a person-level table 2) create a household-level table 3) read the person-level CSV into the person table 4) read the household-level CSV into the household table 5) attempt to print the first five records with "select * from tablename limit 5" -- sometimes these work, sometimes they don't. 6) merge the two tables together 7) attempt to print the first five records of the merged table Unfortunately, I'm getting an error that I can't find with web searches.. The only place I can even find this error is http://bugs.monetdb.org/show_bug.cgi?id=2963 -- and that seems both time-related and fixed long ago.. I doubt it's a bug, I'm probably just making a beginner's mistake. invalid tuple received from server, got 138 columns, expected 476, ignoring +------+------+------+------+-------+------+---------+---------+------+------+ 1 tuple (417.984ms) !466 columns dropped! note: to disable dropping columns and/or truncating fields use \w-1 Even after setting \w to -1, the number of columns returned gets limited, crashing my program. I am ultimately trying to work with the new R/MonetDB package (which uses Java and is available from http://sqlsurvey.r-forge.r-project.org/) but none of the table interactivity will work until I'm able to return all of the columns properly. Any advice would be appreciated! Thanks!!! Anthony Damico Kaiser Family Foundation Here are the SQL commands: CREATE TABLE person (RT VARCHAR(255), SERIALNO INT, SPORDER INT, PUMA INT, ST INT, ADJINC INT, PWGTP INT, AGEP INT, CIT INT, CITWP INT, COW INT, DDRS INT, DEAR INT, DEYE INT, DOUT INT, DPHY INT, DRAT INT, DRATX INT, DREM INT, ENG INT, FER INT, GCL INT, GCM INT, GCR INT, HINS1 INT, HINS2 INT, HINS3 INT, HINS4 INT, HINS5 INT, HINS6 INT, HINS7 INT, INTP INT, JWMNP INT, JWRIP INT, JWTR INT, LANX INT, MAR INT, MARHD INT, MARHM INT, MARHT INT, MARHW INT, MARHYP INT, MIG INT, MIL INT, MLPA INT, MLPB INT, MLPC INT, MLPD INT, MLPE INT, MLPF INT, MLPG INT, MLPH INT, MLPI INT, MLPJ INT, MLPK INT, NWAB INT, NWAV INT, NWLA INT, NWLK INT, NWRE INT, OIP INT, PAP INT, RELP INT, RETP INT, SCH INT, SCHG INT, SCHL INT, SEMP INT, SEX INT, SSIP INT, SSP INT, WAGP INT, WKHP INT, WKL INT, WKW INT, WRK INT, YOEP INT, ANC INT, ANC1P INT, ANC2P INT, DECADE INT, DIS INT, DRIVESP INT, ESP INT, ESR INT, FOD1P INT, FOD2P INT, HICOV INT, HISP INT, INDP INT, JWAP INT, JWDP INT, LANP INT, MIGPUMA INT, MIGSP INT, MSP INT, NAICSP VARCHAR(255), NATIVITY INT, NOP INT, OC INT, OCCP INT, PAOC INT, PERNP INT, PINCP INT, POBP INT, POVPIP INT, POWPUMA INT, POWSP INT, PRIVCOV INT, PUBCOV INT, QTRBIR INT, RAC1P INT, RAC2P INT, RAC3P INT, RACAIAN INT, RACASN INT, RACBLK INT, RACNHPI INT, RACNUM INT, RACSOR INT, RACWHT INT, RC INT, SCIENGP INT, SCIENGRLP INT, SFN INT, SFR INT, SOCP VARCHAR(255), VPS INT, WAOB INT, FAGEP INT, FANCP INT, FCITP INT, FCITWP INT, FCOWP INT, FDDRSP INT, FDEARP INT, FDEYEP INT, FDOUTP INT, FDPHYP INT, FDRATP INT, FDRATXP INT, FDREMP INT, FENGP INT, FESRP INT, FFERP INT, FFODP INT, FGCLP INT, FGCMP INT, FGCRP INT, FHINS1P INT, FHINS2P INT, FHINS3C INT, FHINS3P INT, FHINS4C INT, FHINS4P INT, FHINS5C INT, FHINS5P INT, FHINS6P INT, FHINS7P INT, FHISP INT, FINDP INT, FINTP INT, FJWDP INT, FJWMNP INT, FJWRIP INT, FJWTRP INT, FLANP INT, FLANXP INT, FMARHDP INT, FMARHMP INT, FMARHTP INT, FMARHWP INT, FMARHYP INT, FMARP INT, FMIGP INT, FMIGSP INT, FMILPP INT, FMILSP INT, FOCCP INT, FOIP INT, FPAP INT, FPOBP INT, FPOWSP INT, FRACP INT, FRELP INT, FRETP INT, FSCHGP INT, FSCHLP INT, FSCHP INT, FSEMP INT, FSEXP INT, FSSIP INT, FSSP INT, FWAGP INT, FWKHP INT, FWKLP INT, FWKWP INT, FWRKP INT, FYOEP INT, pwgtp1 INT, pwgtp2 INT, pwgtp3 INT, pwgtp4 INT, pwgtp5 INT, pwgtp6 INT, pwgtp7 INT, pwgtp8 INT, pwgtp9 INT, pwgtp10 INT, pwgtp11 INT, pwgtp12 INT, pwgtp13 INT, pwgtp14 INT, pwgtp15 INT, pwgtp16 INT, pwgtp17 INT, pwgtp18 INT, pwgtp19 INT, pwgtp20 INT, pwgtp21 INT, pwgtp22 INT, pwgtp23 INT, pwgtp24 INT, pwgtp25 INT, pwgtp26 INT, pwgtp27 INT, pwgtp28 INT, pwgtp29 INT, pwgtp30 INT, pwgtp31 INT, pwgtp32 INT, pwgtp33 INT, pwgtp34 INT, pwgtp35 INT, pwgtp36 INT, pwgtp37 INT, pwgtp38 INT, pwgtp39 INT, pwgtp40 INT, pwgtp41 INT, pwgtp42 INT, pwgtp43 INT, pwgtp44 INT, pwgtp45 INT, pwgtp46 INT, pwgtp47 INT, pwgtp48 INT, pwgtp49 INT, pwgtp50 INT, pwgtp51 INT, pwgtp52 INT, pwgtp53 INT, pwgtp54 INT, pwgtp55 INT, pwgtp56 INT, pwgtp57 INT, pwgtp58 INT, pwgtp59 INT, pwgtp60 INT, pwgtp61 INT, pwgtp62 INT, pwgtp63 INT, pwgtp64 INT, pwgtp65 INT, pwgtp66 INT, pwgtp67 INT, pwgtp68 INT, pwgtp69 INT, pwgtp70 INT, pwgtp71 INT, pwgtp72 INT, pwgtp73 INT, pwgtp74 INT, pwgtp75 INT, pwgtp76 INT, pwgtp77 INT, pwgtp78 INT, pwgtp79 INT, pwgtp80 INT); CREATE TABLE household (RT VARCHAR(255), SERIALNO INT, DIVISION INT, PUMA INT, REGION INT, ST INT, ADJHSG INT, ADJINC INT, WGTP INT, NP INT, TYPE 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 50000 offset 2 records into person from 'C:\Users\user\desktop\ss10pak.csv' using delimiters ',','\n','"' NULL as '' ; copy 25000 offset 2 records into household from 'C:\Users\user\desktop\ss10hak.csv' using delimiters ',','\n','"' NULL as '' ; select * from person limit 5; select * from household limit 5; create table merged as select 'M' as rt, a.serialno, a.division, a.puma, a.region, a.st, a.adjhsg, a.adjinc, a.wgtp, a.np, a.type, a.acr, a.ags, a.bath, a.bdsp, a.bld, a.bus, a.conp, a.elep, a.fs, a.fulp, a.gasp, a.hfl, a.insp, a.mhp, a.mrgi, a.mrgp, a.mrgt, a.mrgx, a.refr, a.rmsp, a.rntm, a.rntp, a.rwat, a.sink, a.smp, a.stov, a.tel, a.ten, a.toil, a.vacs, a.valp, a.veh, a.watp, a.ybl, a.fes, a.fincp, a.fparc, a.grntp, a.grpip, a.hhl, a.hht, a.hincp, a.hugcl, a.hupac, a.hupaoc, a.huparc, a.kit, a.lngi, a.multg, a.mv, a.noc, a.npf, a.npp, a.nr, a.nrc, a.ocpip, a.partner, a.plm, a.psf, a.r18, a.r60, a.r65, a.resmode, a.smocp, a.smx, a.srnt, a.sval, a.taxp, a.wif, a.wkexrel, a.workstat, a.facrp, a.fagsp, a.fbathp, a.fbdsp, a.fbldp, a.fbusp, a.fconp, a.felep, a.ffsp, a.ffulp, a.fgasp, a.fhflp, a.finsp, a.fkitp, a.fmhp, a.fmrgip, a.fmrgp, a.fmrgtp, a.fmrgxp, a.fmvp, a.fplmp, a.frefrp, a.frmsp, a.frntmp, a.frntp, a.frwatp, a.fsinkp, a.fsmp, a.fsmxhp, a.fsmxsp, a.fstovp, a.ftaxp, a.ftelp, a.ftenp, a.ftoilp, a.fvacsp, a.fvalp, a.fvehp, a.fwatp, a.fyblp, a.wgtp1, a.wgtp2, a.wgtp3, a.wgtp4, a.wgtp5, a.wgtp6, a.wgtp7, a.wgtp8, a.wgtp9, a.wgtp10, a.wgtp11, a.wgtp12, a.wgtp13, a.wgtp14, a.wgtp15, a.wgtp16, a.wgtp17, a.wgtp18, a.wgtp19, a.wgtp20, a.wgtp21, a.wgtp22, a.wgtp23, a.wgtp24, a.wgtp25, a.wgtp26, a.wgtp27, a.wgtp28, a.wgtp29, a.wgtp30, a.wgtp31, a.wgtp32, a.wgtp33, a.wgtp34, a.wgtp35, a.wgtp36, a.wgtp37, a.wgtp38, a.wgtp39, a.wgtp40, a.wgtp41, a.wgtp42, a.wgtp43, a.wgtp44, a.wgtp45, a.wgtp46, a.wgtp47, a.wgtp48, a.wgtp49, a.wgtp50, a.wgtp51, a.wgtp52, a.wgtp53, a.wgtp54, a.wgtp55, a.wgtp56, a.wgtp57, a.wgtp58, a.wgtp59, a.wgtp60, a.wgtp61, a.wgtp62, a.wgtp63, a.wgtp64, a.wgtp65, a.wgtp66, a.wgtp67, a.wgtp68, a.wgtp69, a.wgtp70, a.wgtp71, a.wgtp72, a.wgtp73, a.wgtp74, a.wgtp75, a.wgtp76, a.wgtp77, a.wgtp78, a.wgtp79, a.wgtp80, sporder, pwgtp, agep, cit, citwp, cow, ddrs, dear, deye, dout, dphy, drat, dratx, drem, eng, fer, gcl, gcm, gcr, hins1, hins2, hins3, hins4, hins5, hins6, hins7, intp, jwmnp, jwrip, jwtr, lanx, mar, marhd, marhm, marht, marhw, marhyp, mig, mil, mlpa, mlpb, mlpc, mlpd, mlpe, mlpf, mlpg, mlph, mlpi, mlpj, mlpk, nwab, nwav, nwla, nwlk, nwre, oip, pap, relp, retp, sch, schg, schl, semp, sex, ssip, ssp, wagp, wkhp, wkl, wkw, wrk, yoep, anc, anc1p, anc2p, decade, dis, drivesp, esp, esr, fod1p, fod2p, hicov, hisp, indp, jwap, jwdp, lanp, migpuma, migsp, msp, naicsp, nativity, nop, oc, occp, paoc, pernp, pincp, pobp, povpip, powpuma, powsp, privcov, pubcov, qtrbir, rac1p, rac2p, rac3p, racaian, racasn, racblk, racnhpi, racnum, racsor, racwht, rc, sciengp, sciengrlp, sfn, sfr, socp, vps, waob, fagep, fancp, fcitp, fcitwp, fcowp, fddrsp, fdearp, fdeyep, fdoutp, fdphyp, fdratp, fdratxp, fdremp, fengp, fesrp, fferp, ffodp, fgclp, fgcmp, fgcrp, fhins1p, fhins2p, fhins3c, fhins3p, fhins4c, fhins4p, fhins5c, fhins5p, fhins6p, fhins7p, fhisp, findp, fintp, fjwdp, fjwmnp, fjwrip, fjwtrp, flanp, flanxp, fmarhdp, fmarhmp, fmarhtp, fmarhwp, fmarhyp, fmarp, fmigp, fmigsp, fmilpp, fmilsp, foccp, foip, fpap, fpobp, fpowsp, fracp, frelp, fretp, fschgp, fschlp, fschp, fsemp, fsexp, fssip, fssp, fwagp, fwkhp, fwklp, fwkwp, fwrkp, fyoep, pwgtp1, pwgtp2, pwgtp3, pwgtp4, pwgtp5, pwgtp6, pwgtp7, pwgtp8, pwgtp9, pwgtp10, pwgtp11, pwgtp12, pwgtp13, pwgtp14, pwgtp15, pwgtp16, pwgtp17, pwgtp18, pwgtp19, pwgtp20, pwgtp21, pwgtp22, pwgtp23, pwgtp24, pwgtp25, pwgtp26, pwgtp27, pwgtp28, pwgtp29, pwgtp30, pwgtp31, pwgtp32, pwgtp33, pwgtp34, pwgtp35, pwgtp36, pwgtp37, pwgtp38, pwgtp39, pwgtp40, pwgtp41, pwgtp42, pwgtp43, pwgtp44, pwgtp45, pwgtp46, pwgtp47, pwgtp48, pwgtp49, pwgtp50, pwgtp51, pwgtp52, pwgtp53, pwgtp54, pwgtp55, pwgtp56, pwgtp57, pwgtp58, pwgtp59, pwgtp60, pwgtp61, pwgtp62, pwgtp63, pwgtp64, pwgtp65, pwgtp66, pwgtp67, pwgtp68, pwgtp69, pwgtp70, pwgtp71, pwgtp72, pwgtp73, pwgtp74, pwgtp75, pwgtp76, pwgtp77, pwgtp78, pwgtp79, pwgtp80 from household as a inner join person as b on a.serialno = b.serialno with data; select * from merged limit 5; invalid tuple received from server, got 138 columns, expected 476, ignoring

2 1

[MonetDB-users] Debug sqoop-monetdb
by Jeremy O'Sullivan 25 Sep '12

25 Sep '12

Hi, I am trying to insert data into monetdb using sqoop, via the monet jdbc interface. It keeps crashing 20 odd rows into the import, with a monetdb ROLLBACK. The debug info from Sqoop is poor. Does anyone know if the monetdb ROLLBACK can be disabled, so that I can see the last row imported. Has anyone tried Sqoop to Monetdb, are there any debugging tips that you can give ? Regards, Jeremy sqoop export --connect jdbc:monetdb://cluster-03/ngpm -driver nl.cwi.monetdb.jdbc.MonetDriver --num-mappers 1 --password monetdb --username monetdb --table query_start --export-dir /test/dash_test/QueryStart.Log --fields-terminated-by ',' 12/09/24 17:27:49 INFO mapreduce.Job: Task Id : attempt_1347971665109_0247_m_000000_1, Status : FAILED Error: java.io.IOException: java.sql.SQLException: EXEC: wrong number of arguments for prepared statement: 100, expected 102 at org.apache.sqoop.mapreduce.AsyncSqlRecordWriter.close(AsyncSqlRecordWriter.j ava:192) at org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.close(MapTask.java :610) at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:730) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:332) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:152) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:396) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.ja va:1232) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:147) Caused by: java.sql.SQLException: EXEC: wrong number of arguments for prepared statement: 100, expected 102 at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetConnectio n.java:2524) at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetConnectio n.java:2274) at nl.cwi.monetdb.jdbc.MonetStatement.internalExecute(MonetStatement.java:508) at nl.cwi.monetdb.jdbc.MonetStatement.execute(MonetStatement.java:349) at nl.cwi.monetdb.jdbc.MonetPreparedStatement.execute(MonetPreparedStatement.ja va:247) at org.apache.sqoop.mapreduce.AsyncSqlOutputFormat$AsyncSqlExecThread.run(Async SqlOutputFormat.java:230)

1 0

[MonetDB-users] Announcement: New Jul2012-SP2 Bugfix release of MonetDB suite
by Sjoerd Mullender 21 Sep '12

21 Sep '12

The MonetDB team at CWI/MonetDB BV is pleased to announce the Jul2012-SP2 bugfix release of the MonetDB suite of programs. More information about MonetDB can be found on our website at <http://www.monetdb.org/>. For details on this release, please see the release notes at <http://www.monetdb.org/Downloads/ReleaseNotes>. As usual, the download location is <http://dev.monetdb.org/downloads/>. Jul 2012-SP2 bugfix release Java Module * Fixed a bug where DatabaseMetaData.getURL() did return null:0 for hostname:port. MonetDB5 Server * Changed the way nclients maximum was calculated to avoid 'out of client slots' errors way before the maximum was reached. Merovingian * Resolved a problem where monetdb could fail to start a database with the message "database 'X' started up, but failed to open up a communication channel". Bug #3134, comment #7. MonetDB Common * Fixed a bug in BATantijoin when either side is a singleton BAT. This fixes bug 3139. Bug Fixes * 3117: test sql/test/BugTracker-2011/Tests/history.Bug-2909.sql produces extra profiling output since changeset 817328b74e2f * 3134: Database gets killed by timeout during startup * 3139: Not equal evaluation does not work * 3144: Memleak when connecting to a database (mclient and mapi) * 3145: mclient error when enabling history * 3150: Multiple string equality tests fail to match (Test_JdbcClient)

1 0

[MonetDB-users] time for ssbm
by guangliang peng 18 Sep '12

18 Sep '12

hi, my query schema is SSBM.My database size is 65G.There are five tables : lineorder 600038145 rows part 1400000 date 2556 supplier 1000000 customer 3000000 and my host have enough memory space up to 500G when i run query select sum(lo_extendedprice*lo_discount) as revenue from voc.lineorder, voc.dates where lo_orderdate = d_datekey and d_weeknuminyear = 6 and d_year = 1994 and lo_discount between 5 and 7 and lo_quantity between 26 and 35; the result is below | revenue | +===============+ | 2605756481323 | +---------------+ 1 tuple (6.2s) but if i delete the condition of " lo_discount between 5 and 7" the run result is more faster than the original one. query select sum(lo_extendedprice*lo_discount) as revenue from voc.lineorder, voc.dates where lo_orderdate = d_datekey and d_weeknuminyear = 6 and d_year = 1994 and lo_quantity between 26 and 35; +---------------+ | revenue | +===============+ | 7990711777299 | +---------------+ 1 tuple (410.451ms) at the same time ,if i delete the condition of "lo_quantity between 26 and 35" the run result is more faster than the original one too. query select sum(lo_extendedprice*lo_discount) as revenue from voc.lineorder, voc.dates where lo_orderdate = d_datekey and d_weeknuminyear = 6 and d_year = 1994 and lo_quantity between 26 and 35; +---------------+ | revenue | +===============+ | 7990711777299 | +---------------+ 1 tuple (463.617ms) i am confused and if the semijoin costs a lot of execution time ? Thank you for your help. best reguards, guangliang peng

1 0

[MonetDB-users] Disk space cleanup policy
by Jukka 17 Sep '12

17 Sep '12

Hi, What is the disk space cleanup policy of MonetDb? If I remove all rows of table with delete command, the disk utilization of dbfarm is still the same. The storage() function is still reporting the same size for the table as before the delete command only count of rows was decreased to zero. Also executing drop table sql statement does not seem to release the disk space. -- Jukka

1 0

[MonetDB-users] MonetDb and too many open files
by Jukka 17 Sep '12

17 Sep '12

Hi, How many files MonetDb is keeping open during runtime? I have running some test on MonetDb on RedHat 6 environment and faced the problem with the too many open files error during the loading phase after having several tables created to the database. I managed to avoid the current error with increasing the file handle limit: vi /etc/security/limits.conf #add for file handle #see lsof -p pid monetdb soft nofile 65536 monetdb hard nofile 65536 Now the system is running, but after 500 tables in MonetDb, I see about 17000 file handle listed with lsof -p command. The most of those are pointing to files in dbfarm folder. Is the files of all columns of all tables kept all the time? Is there formula to estimate the number file handles needed? Is there any limit how many tables or columns we can have in one MonetDb instance? The version used is "MonetDB Database Server v1.6 (Jul2012-SP1)" compiled from sources for RedHat 6. -- Jukka jukkakar(a)iki.fi

1 0