maria-discuss team mailing list archive

[Paul J Stevens <paul@xxxxxx>]

On 09/02/2013 01:02 AM, Reindl Harald wrote:

> so something goes wrong in combination with libzdb
> IMHO this *must not* happen if MariaDB claims to be a drop-in-replacemnet

I've done some additional investigation, and indeed MariaDB appears to
mess up the server cursor when a blob is in the result.

I'm attaching a test-case and with a schema and data for you to use.

10.0.4-MariaDB-1~precise-log
libzdb-2.11.2

libzdb uses mysql_stmt_fetch to move the server cursor forward. This has
worked flawlessly until now for MySQL, SQLite, PostgreSQL and Oracle.
With MariaDB we seem to hit a problem as soon as a blob column is in the
columns.

https://github.com/tildeslash/libzdb/blob/master/src/db/mysql/MysqlResultSet.c#L175

Just try the test program with and without the 'p.data' column, and run
it. Since part_order is the primary ordering key, I use that to test for
result integrity.


-- 
________________________________________________________________
Paul J Stevens        pjstevns @ gmail, twitter, skype, linkedin

  * Premium Hosting Services and Web Application Consultancy *

           www.nfg.nl/info@xxxxxx/+31.85.877.99.97
________________________________________________________________

Attachment: maria-mysql_stmt_fetch-bug.tar.gz
Description: GNU Zip compressed data