func_misc.test 1.33 KB
Newer Older
1 2 3 4
#
# Testing of misc functions
#

unknown's avatar
unknown 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'));

unknown's avatar
unknown 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;
unknown's avatar
unknown committed
21 22 23 24 25

#
# Test for bug #628
#
select concat("$",format(2500,2));
26 27 28 29 30 31 32 33 34 35 36 37 38 39 40

# Test for BUG#7716
create table t1 ( a timestamp );
insert into t1 values ( '2004-01-06 12:34' );
select a from t1 where left(a+0,6) in ( left(20040106,6) );
select a from t1 where left(a+0,6) = ( left(20040106,6) );

select a from t1 where right(a+0,6) in ( right(20040106123400,6) );
select a from t1 where right(a+0,6) = ( right(20040106123400,6) );

select a from t1 where mid(a+0,6,3) in ( mid(20040106123400,6,3) );
select a from t1 where mid(a+0,6,3) = ( mid(20040106123400,6,3) );

drop table t1;

41 42 43 44 45
# Test for BUG#9535
create table t1 as select uuid(), length(uuid());
show create table t1;
drop table t1;

46
# End of 4.1 tests