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)}}
Thanks! I repeated on 10.3-10.11:
MariaDB [test]> select rpad('zzz',seq,'*'),seq from seq_1_to_5 ;+---------------------+-----+| rpad('zzz',seq,'*') | seq |+---------------------+-----+| z | 1 || z* | 2 || z** | 3 || z*** | 4 || z**** | 5 |+---------------------+-----+5 rows in set (0,000 sec)MariaDB [test]> select rpad('zzz',5,'*') ;+-------------------+| rpad('zzz',5,'*') |+-------------------+| zzz** |+-------------------+1 row in set (0,000 sec)MariaDB [test]> select lpad('zzz',seq,'*'),seq from seq_1_to_5 ;+---------------------+-----+| lpad('zzz',seq,'*') | seq |+---------------------+-----+| z | 1 || *z | 2 || **z | 3 || ***z | 4 || ****z | 5 |+---------------------+-----+5 rows in set (0,000 sec)