Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.23, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
Debian 8.0 (Jessie)
Description
I have created the following table with MYISAM engine:
CREATE DATABASE IF NOT EXISTS test_db; |
|
CREATE TABLE IF NOT EXISTS test_db.test ( |
id INT, |
flag BIT, |
parent_id INT, |
PRIMARY KEY (id) |
) ENGINE=MYISAM;
|
|
INSERT INTO test_db.test |
(id, flag, parent_id)
|
VALUE
|
(1, 1, NULL), |
(2, 0, 1),
|
(3, 0, NULL) |
ON DUPLICATE KEY UPDATE |
flag = VALUES(flag); |
|
SELECT
|
pt.id,
|
pt.flag,
|
GROUP_CONCAT(ct.id) child_ids
|
FROM test_db.test pt |
LEFT JOIN test_db.test ct ON ct.parent_id = pt.id |
WHERE
|
pt.parent_id IS NULL |
GROUP BY |
pt.id
|
Please see the attached image for the result. But when I run this sql with the INNODB table, I get difference value of flag column. I think the sql with INNODB returned correct records.
Attachments
Issue Links
- relates to
-
MDEV-31959 GROUP BY with GROUP_CONCAT breaks BIT field in MyISAM
- Confirmed