successfull execution of wrong query [rt.cpan.org #30868]

[mbeijen]

trafficstars

Migrated from rt.cpan.org#30868 (status was 'open')

Requestors:

• [email protected]

From [email protected] on 2007-11-20 17:22:59:

I am use mysql backend as DataBase server
DBI->connect("dbi:mysql:database=

There is next function In database:
CREATE DEFINER=`root`@`%` FUNCTION `update_task_status`(
  parTaskID INT(11),
  parStatus VarChar(32)
  ) RETURNS int(11)
BEGIN
.......
It have only two parameters to call.

If i call it with three parameters
"select update_task_status( 112141, 'FAILED', 3 )"

program does not die while I am executing such query:

$this->{sth}->execute( @_ ) or die "${DBI::err}: ${DBI::errstr} ($this->{Query})";
echo "${DBI::err}: ${DBI::errstr} ($this->{Query})";

I get on my console 
1318: Incorrect number of arguments for FUNCTION akh_test_results.update_task_status; expected 2, got 3

instead of dieing

From [email protected] on 2007-11-21 09:30:01:

Moved to DBD-mysql queue as it's almost certainly an issue with DBD::mysql not DBI.

(You may get a faster response by emailing details to [email protected])

From [email protected] on 2010-10-26 15:57:19:

Please send me a test (the code) that causes this to manifest. Thanks!