MariaDB has different internal representation of Timestamp - Githubissues

seznam / SuperiorMySqlpp

SuperiorMySQL++

GNU Lesser General Public License v3.0

31 stars 20 forks source link

MariaDB has different internal representation of Timestamp #37

Closed smradCZ closed 5 years ago

smradCZ commented 6 years ago

MariaDB has Timestamp defined as UNSIGNED BINARY, but MySQL has it as BINARY without UNSINGED flag. This is the reason why PreparedStatementTypeError is thrown out from prepared statement validations.

I'd introduced 2 custom compiler parameters:

TIMESTAMP_IGNORE_SIGN_VALIDATION - turn-off sign validation for Timestamp type
TIMESTAMP_UNSIGNED_BINARY_TYPE - change Timestamp type to UNSIGNED

Moreover all tests are performed on MariaDB host too from now.

smradCZ commented 5 years ago

Closing, signed/unsigned mark on Timestamp type is already ignored.