We are facing a show stopper for fast insert and restitution using Dynamic Columns compression.

Objective is to provide a view of the original table hiding dynamic column compression not to be forced to change all the software relying on original table design

We have 2 paths

• Activating InnoDB Compression on the table
• Using compress uncompress functions on the dyncamic column of the table

With compress uncompress functions, creating the view failed on MDEV-3944

Using InnoDB compression we can now create a view but facing heavy negative scalability when running concurrent LOAD DATA INFILE

Fixing one or the other issue would put MariaDB as the solution of choice proposed from this editor to clients regarding big data sizing