Debian Codegraph @

mysql-test/suite/compat/oracle/t/func_length.test

raw
1 SET sql_mode=ORACLE;
2
3 --echo #
4 --echo # MDEV-12783 sql_mode=ORACLE: Functions LENGTH() and LENGTHB()
5 --echo #
6 #
7 # Testing LENGTH / LENGTHB
8 #
9 # LENGTH : return the length of char
10 # LENGTHB : return the length of byte
11
12
13 SELECT LENGTH(null), LENGTH('a'), LENGTH(123);
14 SELECT LENGTHB(null), LENGTHB('a'), LENGTHB(123);
15
16 SELECT LENGTH(_utf8 0xC39F), LENGTH(CHAR(14844588 USING utf8));
17 SELECT LENGTHB(_utf8 0xC39F), LENGTHB(CHAR(14844588 USING utf8));
18 EXPLAIN EXTENDED SELECT LENGTH('a'), LENGTHB('a');