maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

mixing data types:

MariaDB [test]> INSERT INTO table_compressed SELECT * FROM
table_without_compression2;
ERROR 1406 (22001): Data too long for column 'data' at row 1
MariaDB [test]> INSERT INTO table_compressed2 SELECT * FROM
table_without_compression;
ERROR 1406 (22001): Data too long for column 'data' at row 1


----
creating now a LONGBLOB  / LONGTEXT


MariaDB [test]> *CREATE TABLE table_compressed_long_blob (*
*    -> `id` int(11) NOT NULL DEFAULT 0,*
*    -> `gmtime` decimal(22,7) NOT NULL DEFAULT 0.0000000,*
*    -> `data` LONGBLOB COMPRESSED NOT NULL,*
*    -> PRIMARY KEY (`id`,`gmtime`)*
*    -> )  ENGINE=InnoDB DEFAULT CHARSET=latin1;*
*Query OK, 0 rows affected (0.141 sec)*

MariaDB [test]>
*CREATE TABLE table_compressed_long_text (*
*    -> `id` int(11) NOT NULL DEFAULT 0,*
*    -> `gmtime` decimal(22,7) NOT NULL DEFAULT 0.0000000,*
*    -> `data` LONGTEXT COMPRESSED NOT NULL,*
*    -> PRIMARY KEY (`id`,`gmtime`)*
*    -> )  ENGINE=InnoDB DEFAULT CHARSET=latin1;*
*Query OK, 0 rows affected (0.161 sec)*

MariaDB [test]>
*INSERT INTO table_compressed_long_blob SELECT * FROM
table_without_compression2;*
*Query OK, 1 row affected (0.045 sec)   <- NICE! *
*Records: 1  Duplicates: 0  Warnings: 0*

MariaDB [test]> *INSERT INTO table_compressed_long_text SELECT * FROM
table_without_compression2;*
*Query OK, 1 row affected (0.009 sec)  <- NICE!*
*Records: 1  Duplicates: 0  Warnings: 0*