Data is truncated with MariaDB Connector/C 3.0.1+ about sqlpp11-connector-mysql HOT 11 CLOSED

That is a surprise! I will need a few days to look into that.

It would be great if you could provide a pull request with a test that demonstrates the current failure.

from sqlpp11-connector-mysql.

I forgot to add the response, I added 1 test with 3 cases (see #40), first 2 should pass and the last one should fail.

from sqlpp11-connector-mysql.

Thanks a lot!

from sqlpp11-connector-mysql.

No problem :)

from sqlpp11-connector-mysql.

Good news: I can reproduce the effect on my local machine.

from sqlpp11-connector-mysql.

Nice! <3

from sqlpp11-connector-mysql.

After playing around with this a bit, I tend to consider this a bug in the client library.

Using mysql, after calling mysql_stmt_fetch, if there is data, then stmt->state == MYSQL_STMT_FETCH_DONE regardless of whether data is truncated or not.

Using the mariadb connector, if there is

• non-truncated data, then stmt->state == MYSQL_STMT_USER_FETCHING
• truncated data then
  • if there was non-truncated data in the call before, then stmt->state == MYSQL_STMT_USER_FETCHING
  • if it is the first row, then stmt->state == MYSQL_STMT_USE_OR_STORE_CALLED

The latter is an invalid state for calling mysql_stmt_fetch_column (looking at the source code).

Maybe you can double check and file an issue for the connector library, in case you come to the same conclusion?

from sqlpp11-connector-mysql.

Sure, I will do that and let you know. I will need few days to do it, I am a little bit busy this week.

from sqlpp11-connector-mysql.

I played around with it too and it is as you said.

When I use MySQL _handle->mysql_stmt->state == MYSQL_STMT_FETCH_DONE even if data is truncated or not.

When using MariaDB

• if data is not truncated _handle->mysql_stmt->state == MYSQL_STMT_USER_FETCHING, also when there was non-truncated data before.
• if first row has truncated data _handle->mysql_stmt->state == MYSQL_STMT_USE_OR_STORE_CALLED.

I created a bug report on MariaDB Connector/C bug tracker (https://jira.mariadb.org/browse/CONC-354).

from sqlpp11-connector-mysql.

Thanks for testing and the bug report!

from sqlpp11-connector-mysql.

No problem :)

from sqlpp11-connector-mysql.