Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5.17, 11.0.1, 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
Description
RPAD result incorrect on following first example. Desired result on the second run wher result order different.
{{Server version: 11.0.1-MariaDB-1:11.0.1+maria~ubu2204 mariadb.org binary distribution
MariaDB [beta]> select rpad('zzz',length(a),'*'),a
-> from (
-> select 'a' a union select 'bb' union select 'cccc'
-> ) as a
-> order by a
-> ;
-------------------------------+
| rpad('zzz',length(a),'*') | a |
-------------------------------+
| z | a |
| z* | bb |
| z*** | cccc |
-------------------------------+
3 rows in set (0.001 sec)
MariaDB [beta]> select rpad('zzz',length(a),'*'),a
-> from (
-> select 'a' a union select 'bb' union select 'cccc'
; -> ) as a
-> order by a desc
-> ;
-------------------------------+
| rpad('zzz',length(a),'*') | a |
-------------------------------+
| zzz* | cccc |
| zz | bb |
| z | a |
-------------------------------+
3 rows in set (0.001 sec)}}