Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.6, 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
Description
create table t1 (a int unsigned zerofill); |
insert into t1 values (1),(2); |
select min(a) from t1; |
select * from (select min(a) from t1) sq; |
 |
# Cleanup
|
drop table t1; |
|
10.5 a16e3c32 |
select min(a) from t1; |
min(a) |
1
|
select * from (select min(a) from t1) sq; |
min(a) |
0000000001
|
Whichever result is correct, the other one must be wrong.
Reproducible on all MariaDB 10.x with at least InnoDB, MyISAM, Aria.
Also reproducible on MySQL 5.6, 8.0.