func_misc.test 730 Bytes
Newer Older
1 2 3 4
#
# Testing of misc functions
#

serg@serg.mylan's avatar
serg@serg.mylan committed
5
select format(1.5555,0),format(123.5555,1),format(1234.5555,2),format(12345.55555,3),format(123456.5555,4),format(1234567.5555,5),format("12345.2399",2);
6 7 8 9

select inet_ntoa(inet_aton("255.255.255.255.255.255.255.255"));
select inet_aton("255.255.255.255.255"),inet_aton("255.255.1.255"),inet_aton("0.1.255");
select inet_ntoa(1099511627775),inet_ntoa(4294902271),inet_ntoa(511);
10

11 12 13 14
select hex(inet_aton('127'));
select hex(inet_aton('127.1'));
select hex(inet_aton('127.1.1'));

serg@serg.mylan's avatar
serg@serg.mylan committed
15 16
select length(uuid()), charset(uuid()), length(unhex(replace(uuid(),_utf8'-',_utf8'')));

17 18 19 20
#
# Test for core dump with nan
#
select length(format('nan', 2)) > 0;
hf@deer.(none)'s avatar
hf@deer.(none) committed
21 22 23 24 25

#
# Test for bug #628
#
select concat("$",format(2500,2));