MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT @@version;


@@version


8.0.30


CREATE TABLE tbl_test_bug (
  id int UNSIGNED NOT NULL AUTO_INCREMENT,
  col_1 TINYINT UNSIGNED NOT NULL,
  col_2 TINYINT UNSIGNED NOT NULL,
  PRIMARY KEY (id DESC),
  KEY col_1_idx (col_1),
  KEY col_2_idx (col_2)
) ENGINE=InnoDB;
CREATE PROCEDURE gen_rows_test()
BEGIN
  DECLARE idx INT DEFAULT 800;
  WHILE idx > 0 DO
    INSERT INTO tbl_test_bug (col_1, col_2) VALUES (FLOOR(1 + (RAND() * 2)), FLOOR(1 + (RAND() * 10)));
    SET idx = idx - 1;
  END WHILE;
END
CALL gen_rows_test()
SELECT * FROM tbl_test_bug ORDER BY col_1, col_2 LIMIT 3;
SELECT * FROM tbl_test_bug ORDER BY col_2, col_1 LIMIT 3;


id
col_1
col_2


777
1
1

770
1
1

760
1
1




id
col_1
col_2


777
1
1

770
1
1

760
1
1


SELECT id
FROM tbl_test_bug
WHERE col_1 = 1 AND col_2 = 1


id


SELECT id
FROM tbl_test_bug
WHERE (col_1, col_2) = (1, 1)


id