/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/r/ |
H A D | lpad.result | 2 SELECT LPAD(NULL, 5, 'x') AS result; 37 SELECT LPAD('a', -1, 'x'); 38 LPAD('a', -1, 'x') 87 SELECT LPAD('12345', 5, 'x'); 88 LPAD('12345', 5, 'x') 93 LPAD('123456787890', 1, 'x') 96 LPAD('123456787890', 5, 'x') 100 SELECT LPAD('123', 5, 'x'); 101 LPAD('123', 5, 'x') 104 SELECT LPAD('a', 5, 'xy'); [all …]
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/t/ |
H A D | lpad.test | 1 # Test of function LPAD(str, len, padstr) 4 SELECT LPAD(NULL, 5, 'x') AS result; 9 SELECT LPAD('a', 5, NULL) AS result; 13 SELECT LPAD('a', 0, 'x') AS result; 14 SELECT LPAD('a', 0, '') AS result; 15 SELECT LPAD('', 0, 'x') AS result; 16 SELECT LPAD('', 0, '') AS result; 19 SELECT LPAD('a', -1, 'x'); 41 SELECT LPAD('12345', 5, 'x'); 50 SELECT LPAD('123', 5, 'x'); [all …]
|
/dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/jp/r/ |
H A D | jp_lpad_ucs2.result | 31 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 32 �ã� LPAD(`�ã�`,5,'��') 39 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 40 �ã� LPAD(`�ã�`,5,'��') 48 �ã� LPAD(`�ã�`,5,'���') 56 �ã� LPAD(`�ã�`,5,'��') 64 �ã� LPAD(`�ã�`,5,'��') 72 �ã� LPAD(`�ã�`,5,'���' ) 80 �ã� LPAD(`�ã�`,5,'��') 88 �ã� LPAD(`�ã�`,5,'��') [all …]
|
H A D | jp_lpad_ujis.result | 30 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 31 �ã� LPAD(`�ã�`,5,'��') 38 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 39 �ã� LPAD(`�ã�`,5,'��') 47 �ã� LPAD(`�ã�`,5,'���') 55 �ã� LPAD(`�ã�`,5,'��') 63 �ã� LPAD(`�ã�`,5,'��') 71 �ã� LPAD(`�ã�`,5,'���' ) 79 �ã� LPAD(`�ã�`,5,'��') 87 �ã� LPAD(`�ã�`,5,'��') [all …]
|
H A D | jp_lpad_utf8.result | 30 SELECT `C1`, LPAD(`C1`,5,'。') FROM `T1`; 31 C1 LPAD(`C1`,5,'。') 38 SELECT `C1`, LPAD(`C1`,5,'X') FROM `T2`; 39 C1 LPAD(`C1`,5,'X') 47 C1 LPAD(`C1`,5,'丄') 55 C1 LPAD(`C1`,5,'。') 63 C1 LPAD(`C1`,5,'X') 71 C1 LPAD(`C1`,5,'丄' ) 79 C1 LPAD(`C1`,5,'。') 87 C1 LPAD(`C1`,5,'X') [all …]
|
/dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/jp/r/ |
H A D | jp_lpad_ucs2.result | 31 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 32 �ã� LPAD(`�ã�`,5,'��') 39 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 40 �ã� LPAD(`�ã�`,5,'��') 48 �ã� LPAD(`�ã�`,5,'���') 56 �ã� LPAD(`�ã�`,5,'��') 64 �ã� LPAD(`�ã�`,5,'��') 72 �ã� LPAD(`�ã�`,5,'���' ) 80 �ã� LPAD(`�ã�`,5,'��') 88 �ã� LPAD(`�ã�`,5,'��') [all …]
|
H A D | jp_lpad_ujis.result | 30 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 31 �ã� LPAD(`�ã�`,5,'��') 38 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 39 �ã� LPAD(`�ã�`,5,'��') 47 �ã� LPAD(`�ã�`,5,'���') 55 �ã� LPAD(`�ã�`,5,'��') 63 �ã� LPAD(`�ã�`,5,'��') 71 �ã� LPAD(`�ã�`,5,'���' ) 79 �ã� LPAD(`�ã�`,5,'��') 87 �ã� LPAD(`�ã�`,5,'��') [all …]
|
H A D | jp_lpad_utf8.result | 30 SELECT `C1`, LPAD(`C1`,5,'。') FROM `T1`; 31 C1 LPAD(`C1`,5,'。') 38 SELECT `C1`, LPAD(`C1`,5,'X') FROM `T2`; 39 C1 LPAD(`C1`,5,'X') 47 C1 LPAD(`C1`,5,'丄') 55 C1 LPAD(`C1`,5,'。') 63 C1 LPAD(`C1`,5,'X') 71 C1 LPAD(`C1`,5,'丄' ) 79 C1 LPAD(`C1`,5,'。') 87 C1 LPAD(`C1`,5,'X') [all …]
|
/dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/jp/r/ |
H A D | jp_lpad_ucs2.result | 31 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 32 �ã� LPAD(`�ã�`,5,'��') 39 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 40 �ã� LPAD(`�ã�`,5,'��') 48 �ã� LPAD(`�ã�`,5,'���') 56 �ã� LPAD(`�ã�`,5,'��') 64 �ã� LPAD(`�ã�`,5,'��') 72 �ã� LPAD(`�ã�`,5,'���' ) 80 �ã� LPAD(`�ã�`,5,'��') 88 �ã� LPAD(`�ã�`,5,'��') [all …]
|
H A D | jp_lpad_ujis.result | 30 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 31 �ã� LPAD(`�ã�`,5,'��') 38 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 39 �ã� LPAD(`�ã�`,5,'��') 47 �ã� LPAD(`�ã�`,5,'���') 55 �ã� LPAD(`�ã�`,5,'��') 63 �ã� LPAD(`�ã�`,5,'��') 71 �ã� LPAD(`�ã�`,5,'���' ) 79 �ã� LPAD(`�ã�`,5,'��') 87 �ã� LPAD(`�ã�`,5,'��') [all …]
|
H A D | jp_lpad_utf8.result | 30 SELECT `C1`, LPAD(`C1`,5,'。') FROM `T1`; 31 C1 LPAD(`C1`,5,'。') 38 SELECT `C1`, LPAD(`C1`,5,'X') FROM `T2`; 39 C1 LPAD(`C1`,5,'X') 47 C1 LPAD(`C1`,5,'丄') 55 C1 LPAD(`C1`,5,'。') 63 C1 LPAD(`C1`,5,'X') 71 C1 LPAD(`C1`,5,'丄' ) 79 C1 LPAD(`C1`,5,'。') 87 C1 LPAD(`C1`,5,'X') [all …]
|
/dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/suite/jp/r/ |
H A D | jp_lpad_ucs2.result | 31 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 32 �ã� LPAD(`�ã�`,5,'��') 39 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 40 �ã� LPAD(`�ã�`,5,'��') 48 �ã� LPAD(`�ã�`,5,'���') 56 �ã� LPAD(`�ã�`,5,'��') 64 �ã� LPAD(`�ã�`,5,'��') 72 �ã� LPAD(`�ã�`,5,'���' ) 80 �ã� LPAD(`�ã�`,5,'��') 88 �ã� LPAD(`�ã�`,5,'��') [all …]
|
H A D | jp_lpad_ujis.result | 30 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 31 �ã� LPAD(`�ã�`,5,'��') 38 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 39 �ã� LPAD(`�ã�`,5,'��') 47 �ã� LPAD(`�ã�`,5,'���') 55 �ã� LPAD(`�ã�`,5,'��') 63 �ã� LPAD(`�ã�`,5,'��') 71 �ã� LPAD(`�ã�`,5,'���' ) 79 �ã� LPAD(`�ã�`,5,'��') 87 �ã� LPAD(`�ã�`,5,'��') [all …]
|
H A D | jp_lpad_utf8.result | 30 SELECT `C1`, LPAD(`C1`,5,'。') FROM `T1`; 31 C1 LPAD(`C1`,5,'。') 38 SELECT `C1`, LPAD(`C1`,5,'X') FROM `T2`; 39 C1 LPAD(`C1`,5,'X') 47 C1 LPAD(`C1`,5,'丄') 55 C1 LPAD(`C1`,5,'。') 63 C1 LPAD(`C1`,5,'X') 71 C1 LPAD(`C1`,5,'丄' ) 79 C1 LPAD(`C1`,5,'。') 87 C1 LPAD(`C1`,5,'X') [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/jp/r/ |
H A D | jp_lpad_ujis.result | 30 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 31 �ã� LPAD(`�ã�`,5,'��') 38 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 39 �ã� LPAD(`�ã�`,5,'��') 47 �ã� LPAD(`�ã�`,5,'���') 55 �ã� LPAD(`�ã�`,5,'��') 63 �ã� LPAD(`�ã�`,5,'��') 71 �ã� LPAD(`�ã�`,5,'���' ) 79 �ã� LPAD(`�ã�`,5,'��') 87 �ã� LPAD(`�ã�`,5,'��') [all …]
|
H A D | jp_lpad_ucs2.result | 31 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 32 �ã� LPAD(`�ã�`,5,'��') 39 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 40 �ã� LPAD(`�ã�`,5,'��') 48 �ã� LPAD(`�ã�`,5,'���') 56 �ã� LPAD(`�ã�`,5,'��') 64 �ã� LPAD(`�ã�`,5,'��') 72 �ã� LPAD(`�ã�`,5,'���' ) 80 �ã� LPAD(`�ã�`,5,'��') 88 �ã� LPAD(`�ã�`,5,'��') [all …]
|
H A D | jp_lpad_utf8.result | 30 SELECT `C1`, LPAD(`C1`,5,'。') FROM `T1`; 31 C1 LPAD(`C1`,5,'。') 38 SELECT `C1`, LPAD(`C1`,5,'X') FROM `T2`; 39 C1 LPAD(`C1`,5,'X') 47 C1 LPAD(`C1`,5,'丄') 55 C1 LPAD(`C1`,5,'。') 63 C1 LPAD(`C1`,5,'X') 71 C1 LPAD(`C1`,5,'丄' ) 79 C1 LPAD(`C1`,5,'。') 87 C1 LPAD(`C1`,5,'X') [all …]
|
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/jp/r/ |
H A D | jp_lpad_ucs2.result | 31 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 32 �ã� LPAD(`�ã�`,5,'��') 39 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 40 �ã� LPAD(`�ã�`,5,'��') 48 �ã� LPAD(`�ã�`,5,'���') 56 �ã� LPAD(`�ã�`,5,'��') 64 �ã� LPAD(`�ã�`,5,'��') 72 �ã� LPAD(`�ã�`,5,'���' ) 80 �ã� LPAD(`�ã�`,5,'��') 88 �ã� LPAD(`�ã�`,5,'��') [all …]
|
H A D | jp_lpad_ujis.result | 30 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 31 �ã� LPAD(`�ã�`,5,'��') 38 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 39 �ã� LPAD(`�ã�`,5,'��') 47 �ã� LPAD(`�ã�`,5,'���') 55 �ã� LPAD(`�ã�`,5,'��') 63 �ã� LPAD(`�ã�`,5,'��') 71 �ã� LPAD(`�ã�`,5,'���' ) 79 �ã� LPAD(`�ã�`,5,'��') 87 �ã� LPAD(`�ã�`,5,'��') [all …]
|
H A D | jp_lpad_utf8.result | 30 SELECT `C1`, LPAD(`C1`,5,'。') FROM `T1`; 31 C1 LPAD(`C1`,5,'。') 38 SELECT `C1`, LPAD(`C1`,5,'X') FROM `T2`; 39 C1 LPAD(`C1`,5,'X') 47 C1 LPAD(`C1`,5,'丄') 55 C1 LPAD(`C1`,5,'。') 63 C1 LPAD(`C1`,5,'X') 71 C1 LPAD(`C1`,5,'丄' ) 79 C1 LPAD(`C1`,5,'。') 87 C1 LPAD(`C1`,5,'X') [all …]
|
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/jp/r/ |
H A D | jp_lpad_utf8.result | 30 SELECT `C1`, LPAD(`C1`,5,'。') FROM `T1`; 31 C1 LPAD(`C1`,5,'。') 38 SELECT `C1`, LPAD(`C1`,5,'X') FROM `T2`; 39 C1 LPAD(`C1`,5,'X') 47 C1 LPAD(`C1`,5,'丄') 55 C1 LPAD(`C1`,5,'。') 63 C1 LPAD(`C1`,5,'X') 71 C1 LPAD(`C1`,5,'丄' ) 79 C1 LPAD(`C1`,5,'。') 87 C1 LPAD(`C1`,5,'X') [all …]
|
H A D | jp_lpad_ucs2.result | 31 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 32 �ã� LPAD(`�ã�`,5,'��') 39 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 40 �ã� LPAD(`�ã�`,5,'��') 48 �ã� LPAD(`�ã�`,5,'���') 56 �ã� LPAD(`�ã�`,5,'��') 64 �ã� LPAD(`�ã�`,5,'��') 72 �ã� LPAD(`�ã�`,5,'���' ) 80 �ã� LPAD(`�ã�`,5,'��') 88 �ã� LPAD(`�ã�`,5,'��') [all …]
|
H A D | jp_lpad_ujis.result | 30 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 31 �ã� LPAD(`�ã�`,5,'��') 38 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 39 �ã� LPAD(`�ã�`,5,'��') 47 �ã� LPAD(`�ã�`,5,'���') 55 �ã� LPAD(`�ã�`,5,'��') 63 �ã� LPAD(`�ã�`,5,'��') 71 �ã� LPAD(`�ã�`,5,'���' ) 79 �ã� LPAD(`�ã�`,5,'��') 87 �ã� LPAD(`�ã�`,5,'��') [all …]
|
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/jp/r/ |
H A D | jp_lpad_ucs2.result | 31 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 32 �ã� LPAD(`�ã�`,5,'��') 39 SELECT `�ã�`, LPAD(`�ã�`,5,'��') FROM `�ԣ�`; 40 �ã� LPAD(`�ã�`,5,'��') 48 �ã� LPAD(`�ã�`,5,'���') 56 �ã� LPAD(`�ã�`,5,'��') 64 �ã� LPAD(`�ã�`,5,'��') 72 �ã� LPAD(`�ã�`,5,'���' ) 80 �ã� LPAD(`�ã�`,5,'��') 88 �ã� LPAD(`�ã�`,5,'��') [all …]
|
H A D | jp_lpad_utf8.result | 30 SELECT `C1`, LPAD(`C1`,5,'。') FROM `T1`; 31 C1 LPAD(`C1`,5,'。') 38 SELECT `C1`, LPAD(`C1`,5,'X') FROM `T2`; 39 C1 LPAD(`C1`,5,'X') 47 C1 LPAD(`C1`,5,'丄') 55 C1 LPAD(`C1`,5,'。') 63 C1 LPAD(`C1`,5,'X') 71 C1 LPAD(`C1`,5,'丄' ) 79 C1 LPAD(`C1`,5,'。') 87 C1 LPAD(`C1`,5,'X') [all …]
|