← Back to team overview

maria-discuss team mailing list archive

Re: columns compression


Hi Roberto,

Could you share test case? Simplified if possible: we should only need
2 tables with compressed columns definition and first row from old table.

Also please share session column_compression% settings.


On Fri, Mar 16, 2018 at 06:05:37PM -0300, Roberto Spadim wrote:
> hi guys!
> anyone testing column compression and have problems when changing form one
> table format to other?
> i created a new table with blob compressed column, and i'm trying to insert
> select from old table, but i got a problem:
> MariaDB [test]> insert into new_table select * from old_table;
> ERROR 1406 (22001): Data too long for column 'data' at row 1
> using aria or innodb engine give the same error, it's a BLOB columns
> tahnks
> -- 
> Roberto Spadim

> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp

Follow ups