Stored procedure import bug on stored procedures w
Posted in 2010
Hello everyone,
I don't think I have seen mention of it here, but I wanted to pass the
information: We have run into a rather nasty bug with stored procedures. We
regularly have comments in our stored procedures, and have been experiencing a
bug when exporting and re-importing those stored procedures. It seems dbimport
has problems dealing with the comments, and will sometimes not "notice" the
end of line of the commented line and comment out more of the stored procedure
than needed. This results in 2 possible outcomes: the import errors out, easy
fix: remove the comment and you're good, but it will sometimes also happily
import everything without throwing an error, but that import will have a
skewed stored procedure that might not do what you think it does anymore.
Anyway, if any one of you has similar problems, contact the informix support:
we've been sent a patch (which we haven't been able to test yet though), so
there seems to be a solution available.
Regards,
Felix