 | | | SET MAXERRORCOUNT problem with loadercli input file | SET MAXERRORCOUNT problem with loadercli input file 2007-01-15 - By Jo?l Reungoat
Back
Hello,
"SET MAXERRORCOUNT xx" seems to have no effect in loadercli input file
(Used Maxdb version : 7.5)
Could somebody tell me if this is a known bug or if I incorrectly use an
option ?
Here is the sample script that I call with loadercli (without the option
-E) :
//Folowing command should be to allow to drop myProc without stopping on
error (but it has no effect !)
SET MAXERRORCOUNT 100
//
DROP DBPROC mySample
//Folowing command is then to force to stop at first error
SET MAXERRORCOUNT 1
//
CREATE DBPROC mySample AS
BEGIN
SELECT * FROM domain.dbprocedures;
END;
//
CALL mySample
//
The script produces following report that mentions the SET MAXERRORCOUNT
100 is successfull but it has no effect because it stops at the first
encountered error. It does not when I use the option -E 100 with loadercli.
SET MAXERRORCOUNT 100
Successfully executed
DROP DBPROC mySample
Error during execution
-->-25010
SQL error -4016 = Unknown procedure name:MYSAMPLE (error position:
13[line: 1, col: 13])
Defined maximum number of errors (1) reached
Thank you for your help.
Joel
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=mysql@(protected)
|
|
|