Bugs item #2871572, was opened at 2009-10-02 00:53 Message generated for change (Settings changed) made by mlkersten You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2871572&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: Closed >Resolution: Invalid Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Niels Nes (nielsnes) Summary: SQL: loader gives wrong errors, works though Initial Comment: While loading: http://mirror.openstreetmap.nl/knmi/KNMI.sql I see: MAPI = mone...@localhost:50001 QUERY = # DEZE GEGEVENS MOGEN VRIJ WORDEN GEBRUIKT MITS DE VOLGENDE BRONVERMELDING WORDT GEGEVEN: # KONINKLIJK NEDERLANDS METEOROLOGISCH INSTITUUT (KNMI) # # THESE DATA CAN BE USED FREELY PROVIDED THAT THE FOLLOWING SOURCE IS ACKNOWLEDGED: # ROYAL NETHERLANDS METEOROLOGICAL INSTITUTE # DROP TABLE stations; CREATE TABLE stations (stationid integer, long decimal(5,2), lat decimal(5,2), altitude smallint, name varchar(128), primary key(stationid)); COPY 36 RECORDS INTO stations from stdin USING DELIMITERS '\t', '\n' ERROR = !DROP TABLE: no such table 'stations' Obviously the right query is not selected. ---------------------------------------------------------------------- >Comment By: Martin Kersten (mlkersten) Date: 2009-10-02 01:25 Message: The conclusion that there is here a MonetDB bug can not be deciphered from this report. Of course it works when you have auto-commit enabled. Moreover, mapi client throws the complete sql script to the server when you pass it as an argument to mclient. If you need line-based errors, then use either <inputfile or the -i option. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2871572&group_id=56967 ------------------------------------------------------------------------------ Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
