Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5.17, 10.3, 10.4, 11.0.1, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11, 11.0
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)}}