Bugs item #2871572, was opened at 2009-10-02 00:53 Message generated for change (Settings changed) made by stmane 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 "stable" Status: Open Resolution: None 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: Stefan Manegold (stmane) Date: 2009-10-02 11:10 Message: The double (first, only) error message also occurs with the Aug2009 release branch. As said, I'm not sure, whether it is a SQL, MAPI, or mclient problem ... ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-10-02 10:15 Message: Like others, I could not get this from the original posting of this bug report --- nor can I tell, whether this was the problem that the original poster intended to report ---, but there is indeed an error/bug involved: The correct/expected first error message (DROP TABLE: no such table 'stations') is issued a second time, as soon as the first query result is returned/printed. Looks like some error/output buffer is not initialized or cleared correctly. Might be a bug in SQL, but might also be a bug in MAPI or mclient. ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2009-10-02 08:23 Message: You are probably using the candidate release (Nov2009) or current, and are piping the output into mclient, or making mclient read from file. Our server doesn't report its state, so we can't do more in that case than we do right now. If you want mclient to process line by line, use the -i flag. It is a feature request to have (any) client to report exactly what went wrong where, based on a state inside the server. ---------------------------------------------------------------------- Comment By: Martin Kersten (mlkersten) Date: 2009-10-02 02:21 Message: mclient -lsql -i KNMI.sql Welcome to mclient, the MonetDB/SQL interactive terminal Database: MonetDB v5.15.0, 'demo' Type \q to quit, \? for a list of available commands auto commit mode: on DROP TABLE: no such table 'stations' DROP TABLE: no such table 'stations' 36 affected rows DROP TABLE: no such table 'knmi_tmp' 544054 affected rows DROP TABLE: no such table 'knmi' 544054 affected rows sql> ---------------------------------------------------------------------- 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
