Wrong field type if extra info is included in field's type name by MariaDB

[dcoun]

I am using Mormot with ZEOS 8.0 and in a table the database definition as returned by Mariadb is

Code: Select all

longblob /*!100301 compressed*/

the above defination causes problem to ZEOS and from

Code: Select all

function TZRowAccessor.GetInt(ColumnIndex: Integer; out IsNull: Boolean): Integer;

in ZDBCcache it returns that this field is int64 and not a blob field as it should be.
Is it possible to ignore such extra info when defining and reporting field's type?

[marsupilami]

Hello dcoun,

could you please supply a table definition that causes this problem? Maybe also a working exampl application that shows the problem?

Currently I am not sure what the exact problem is and how to reproduce it.

Best regards,

Jan

[dcoun]

I apologize for the delay in my answer as zeos's was bypassed by mormot's code as you can see in this thread:
https://synopse.info/forum/viewtopic.php?id=6353

To have a compressed field in any mariadb's db table please check the following page:
https://mariadb.com/kb/en/create-table/#compressed

[dcoun]

I apologize for the delay in my answer as zeos's was bypassed by mormot's code as you can see in this thread:
https://synopse.info/forum/viewtopic.php?id=6353

To have a compressed field in any mariadb's db table please check the following page:
https://mariadb.com/kb/en/create-table/#compressed

CREATE TABLE cmp (i TEXT COMPRESSED);