Bugs item #2808353, was opened at 2009-06-18 14:48 Message generated for change (Tracker Item Submitted) made by skinkie You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2808353&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/Core Group: SQL CVS Head Status: Open Resolution: None Priority: 5 Private: Yes Submitted By: Stefan de Konink (skinkie) Assigned to: Niels Nes (nielsnes) Summary: not (...) goes far out of hand Initial Comment: To create the table; /export refers to loki. create table kvk (kvk bigint, bedrijfsnaam varchar(255), adres varchar(64), postcode varchar(6), plaats varchar(32), type varchar(16)); create table anbikvk (naam varchar(256), vestigingsplaats varchar(32), besch ikking date, intrekking date, kvk bigint); create table anbi (naam varchar(256), vestigingsplaats varchar(32), beschikk ing timestamp, intrekking timestamp); COPY 27598 RECORDS INTO anbi FROM '/export/scratch1/konink/anbi.csv' USING DELIMITERS ',', '\n', '""'; COPY 1621594 RECORDS INTO kvk FROM '/export/scratch1/konink/allesn' USING DELIMITERS ',', '\n', '""'; insert into anbikvk select naam, vestigingsplaats, beschikking, intrekking, kvk from kvk,anbi where lower(naam) = lower(bedrijfsnaam) and lower(plaats) = lo wer(vestigingsplaats); select count(*) from kvk,anbi where not (lower(naam) = lower(bedrijfsnaam) and lower(plaats) = lowers(vestigingsplaats)); Known errors are: - Segmentation fault (64/32) - BUN error - !ERROR: GDKsave: error on: name=54/5412, ext=head, mode=1 !OS: No space left on device !ERROR: GDKload: failed name=54/5412, ext=head The database is by far smaller than main memory. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2808353&group_id=56967 ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
