Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.23
-
None
-
5.4.19-200.fc31.x86_64
Description
DROP TEMPORARY TABLE IF EXISTS `test_set`; |
CREATE TEMPORARY TABLE `test_set` |
(
|
`id` INT NOT NULL auto_increment PRIMARY KEY, |
`tag` VARCHAR(255), |
`tag2` VARCHAR(255) |
);
|
|
INSERT INTO test_set (tag, tag2) |
VALUES ('hello', 'a'), |
('hello', 'b'), |
('world', 'c'); |
|
SELECT COUNT(*), tag2 as tag |
FROM test_set |
GROUP BY tag; |
Not Equal to
SELECT COUNT(*), tag2 as tag3 |
FROM test_set |
GROUP BY tag3; |