Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.12, 10.1.0
-
debian6 x86_64
-
10.0.30
Description
in the case where no text columns
> show create table seller_counters;
|
| seller_counters | CREATE TABLE `seller_counters` (
|
`seller_id` int(11) NOT NULL,
|
`category_id` int(11) NOT NULL,
|
`counter` int(11) NOT NULL DEFAULT '0',
|
PRIMARY KEY (`seller_id`,`category_id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
|
> select count(*) from seller_counters;
|
| count(*) |
|
| 1859 |
|
|
> alter table seller_counters CONVERT TO CHARACTER SET utf8;
|
Query OK, 0 rows affected (0.00 sec)
|
Records: 0 Duplicates: 0 Warnings: 0
|
|
> show create table seller_counters;
|
| Table | Create Table |
|
| seller_counters | CREATE TABLE `seller_counters` (
|
`seller_id` int(11) NOT NULL,
|
`category_id` int(11) NOT NULL,
|
`counter` int(11) NOT NULL DEFAULT '0',
|
PRIMARY KEY (`seller_id`,`category_id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
Attachments
Issue Links
- is duplicated by
-
MDEV-9982 "CONVERT TO CHARACTER SET" has no effect if table has no text columns
- Closed
- links to