execute_array fails with "no metadata information while trying to describe result set". [rt.cpan.org #49412]

[mbeijen]

trafficstars

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

Requestors:

• [email protected]

Attachments:

• dbi-error-output.txt
• dbitest

From [email protected] on 2009-09-04 00:03:47:

I'm having trouble with execute_array, when binding to an array with
more than one element.  (binding to one element works fine).

I believe it is a problem in dbd-mysql, but I guess it could be a dbi
problem.  The issue is the driver is dying with this error:

ERROR: 19 'no metadata information while trying describe result set'

It dies when processing the 2nd bound array element.  The
dbd_sth->result field is free'ed after the first element, but
the dbd_describe method is called for each bound element.

(I am using prepared statements).

This was run against mysql 5.0.78 on a centos 5.3 box.

I've attached a small test program that demonstrates the problem,
and output from the program.

The dbd-mysql version was 4.012, but dbi was "stock" (1.52).

From [email protected] on 2010-10-26 16:49:06:

Thanks for this report and sorry it's taken so long to reply. I tested
this and indeed it does fail. It's difficult to ascertain if the cause
is the prepared statement API or DBD itself. The statement that is
executed is correct, but the result calls don't seem to provide a
complete data result. 

For now, don't use server-side prepared statements and I'll continue to
try to find a fix for this.