summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_misc.test
blob: d48b17e87affbcd85cfb89baad6d757e1b261754 (plain)
1
2
3
4
5
6
7
8
9
#
# Testing of misc functions
#

select format(1.5555,0),format(123.5555,1),format(1234.5555,2),format(12345.5555,3),format(123456.5555,4),format(1234567.5555,5),format("12345.2399",2);

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);