Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.0.9
-
None
-
any
Description
Apparently it is not possibly to create a MYSQL table with a blob column?
mysql 10.0.9-MariaDB (root) [test] db1> show create table t1\G
|
*************************** 1. row ***************************
|
Table: t1
|
Create Table: CREATE TABLE `t1` (
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
`b` blob,
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
|
1 row in set (0.00 sec)
|
 |
mysql 10.0.9-MariaDB (root) [test] db1> create table xt1 (id int unsigned, b blob) engine=connect table_type=mysql tabname=t1;
|
ERROR 1105 (HY000): Unsupported type for column b
|
I didn't see any documentation about this.
And creating a PROXY table causes it to try using the wrong datatype
and fail:
mysql 10.0.9-MariaDB (root) [test] db1> create table xt1 engine=connect table_type=proxy tabname=t1;
|
ERROR 1939 (HY000): Engine CONNECT failed to discover table `test`.`xt1` with 'CREATE TABLE whatever (`id` INT(10) UNSIGNED NOT NULL,`b` VARCHAR(65535)) TABLE_TYPE='proxy' TABNAME='t1''
|
Should this be supported? If not, obviously, it must be clearly documented at https://mariadb.com/kb/en/connect-data-types/
Currently, that page seems to suggest that blob might be supported when it says TYPE_STRING should be used for "char, varchar, text, blob".