maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

Same to TEXT

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

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


MariaDB [test]> *INSERT INTO table_without_compression2 VALUES
(1,0,repeat('a',65535));*
*Query OK, 1 row affected (0.061 sec)*

MariaDB [test]> *INSERT INTO table_without_compression2 VALUES
(1,0,repeat('a',65536));*
*ERROR 1406 (22001): Data too long for column 'data' at row 1   <- JUST TO
CHECK IF WE GOT MAX SIZE OF BLOB COLUMN*

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