Home
last modified time | relevance | path

Searched refs:LPAD (Results 1 – 25 of 1510) sorted by relevance

12345678910>>...61

/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/r/
H A Dlpad.result2 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 Dlpad.test1 # 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 Djp_lpad_ucs2.result31 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 Djp_lpad_ujis.result30 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 Djp_lpad_utf8.result30 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 Djp_lpad_ucs2.result31 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 Djp_lpad_ujis.result30 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 Djp_lpad_utf8.result30 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 Djp_lpad_ucs2.result31 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 Djp_lpad_ujis.result30 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 Djp_lpad_utf8.result30 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 Djp_lpad_ucs2.result31 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 Djp_lpad_ujis.result30 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 Djp_lpad_utf8.result30 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 Djp_lpad_ujis.result30 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 Djp_lpad_ucs2.result31 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 Djp_lpad_utf8.result30 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 Djp_lpad_ucs2.result31 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 Djp_lpad_ujis.result30 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 Djp_lpad_utf8.result30 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 Djp_lpad_utf8.result30 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 Djp_lpad_ucs2.result31 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 Djp_lpad_ujis.result30 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 Djp_lpad_ucs2.result31 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 Djp_lpad_utf8.result30 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 …]

12345678910>>...61