use test; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9,t10; create table t1 (pk int key ,a1 BIT(1), a2 BIT(5), a3 BIT(33), a4 BIT(63), a5 BIT(64) ,b1 TINYINT, b2 TINYINT UNSIGNED ,c1 SMALLINT, c2 SMALLINT UNSIGNED ,d1 INT, d2 INT UNSIGNED ,e1 BIGINT, e2 BIGINT UNSIGNED ,f1 CHAR(1) BINARY, f2 CHAR(32) BINARY, f3 CHAR(255) BINARY ,g1 VARCHAR(32) BINARY, g2 VARCHAR(255) BINARY, g3 VARCHAR(1000) BINARY ,h1 BINARY(1), h2 BINARY(8), h3 BINARY(255) ,i1 VARBINARY(32), i2 VARBINARY(255), i3 VARBINARY(1000) ) engine myisam; insert into t1 values (1 ,0x1, 0x17, 0x789a, 0x789abcde, 0xfedc0001 ,127, 255 ,32767, 65535 ,2147483647, 4294967295 ,9223372036854775807, 18446744073709551615 ,'1','12345678901234567890123456789012','123456789' ,'1','12345678901234567890123456789012','123456789' ,0x12,0x123456789abcdef0, 0x012345 ,0x12,0x123456789abcdef0, 0x00123450 ); insert into t1 values (2 ,0, 0, 0, 0, 0 ,-128, 0 ,-32768, 0 ,-2147483648, 0 ,-9223372036854775808, 0 ,'','','' ,'','','' ,0x0,0x0,0x0 ,0x0,0x0,0x0 ); insert into t1 values (3 ,NULL,NULL,NULL,NULL,NULL ,NULL,NULL ,NULL,NULL ,NULL,NULL ,NULL,NULL ,NULL,NULL,NULL ,NULL,NULL,NULL ,NULL,NULL,NULL ,NULL,NULL,NULL ); select pk ,hex(a1), hex(a2), hex(a3), hex(a4), hex(a5) ,b1, b2 ,c1 , c2 ,d1 , d2 ,e1 , e2 ,f1 , f2, f3 ,g1 , g2, g3 ,hex(h1), hex(h2), hex(h3) ,hex(i1), hex(i2), hex(i3) from t1 order by pk; pk 1 hex(a1) 1 hex(a2) 17 hex(a3) 789A hex(a4) 789ABCDE hex(a5) FEDC0001 b1 127 b2 255 c1 32767 c2 65535 d1 2147483647 d2 4294967295 e1 9223372036854775807 e2 18446744073709551615 f1 1 f2 12345678901234567890123456789012 f3 123456789 g1 1 g2 12345678901234567890123456789012 g3 123456789 hex(h1) 12 hex(h2) 123456789ABCDEF0 hex(h3) 012345000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 hex(i1) 12 hex(i2) 123456789ABCDEF0 hex(i3) 00123450 pk 2 hex(a1) 0 hex(a2) 0 hex(a3) 0 hex(a4) 0 hex(a5) 0 b1 -128 b2 0 c1 -32768 c2 0 d1 -2147483648 d2 0 e1 -9223372036854775808 e2 0 f1 f2 f3 g1 g2 g3 hex(h1) 00 hex(h2) 0000000000000000 hex(h3) 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 hex(i1) 00 hex(i2) 00 hex(i3) 00 pk 3 hex(a1) NULL hex(a2) NULL hex(a3) NULL hex(a4) NULL hex(a5) NULL b1 NULL b2 NULL c1 NULL c2 NULL d1 NULL d2 NULL e1 NULL e2 NULL f1 NULL f2 NULL f3 NULL g1 NULL g2 NULL g3 NULL hex(h1) NULL hex(h2) NULL hex(h3) NULL hex(i1) NULL hex(i2) NULL hex(i3) NULL alter table t1 engine ndb; select pk ,hex(a1), hex(a2), hex(a3), hex(a4), hex(a5) ,b1, b2 ,c1 , c2 ,d1 , d2 ,e1 , e2 ,f1 , f2, f3 ,g1 , g2, g3 ,hex(h1), hex(h2), hex(h3) ,hex(i1), hex(i2), hex(i3) from t1 order by pk; pk 1 hex(a1) 1 hex(a2) 17 hex(a3) 789A hex(a4) 789ABCDE hex(a5) FEDC0001 b1 127 b2 255 c1 32767 c2 65535 d1 2147483647 d2 4294967295 e1 9223372036854775807 e2 18446744073709551615 f1 1 f2 12345678901234567890123456789012 f3 123456789 g1 1 g2 12345678901234567890123456789012 g3 123456789 hex(h1) 12 hex(h2) 123456789ABCDEF0 hex(h3) 012345000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 hex(i1) 12 hex(i2) 123456789ABCDEF0 hex(i3) 00123450 pk 2 hex(a1) 0 hex(a2) 0 hex(a3) 0 hex(a4) 0 hex(a5) 0 b1 -128 b2 0 c1 -32768 c2 0 d1 -2147483648 d2 0 e1 -9223372036854775808 e2 0 f1 f2 f3 g1 g2 g3 hex(h1) 00 hex(h2) 0000000000000000 hex(h3) 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 hex(i1) 00 hex(i2) 00 hex(i3) 00 pk 3 hex(a1) NULL hex(a2) NULL hex(a3) NULL hex(a4) NULL hex(a5) NULL b1 NULL b2 NULL c1 NULL c2 NULL d1 NULL d2 NULL e1 NULL e2 NULL f1 NULL f2 NULL f3 NULL g1 NULL g2 NULL g3 NULL hex(h1) NULL hex(h2) NULL hex(h3) NULL hex(i1) NULL hex(i2) NULL hex(i3) NULL 1;0x1;0x17;0x789A;0x789ABCDE;0xFEDC0001;127;255;32767;65535;2147483647;4294967295;9223372036854775807;18446744073709551615;1;12345678901234567890123456789012;123456789;1;12345678901234567890123456789012;123456789;0x12;0x123456789ABCDEF0;0x012345;0x12;0x123456789ABCDEF0;0x00123450 2;0x0;0x0;0x0;0x0;0x0;-128;0;-32768;0;-2147483648;0;-9223372036854775808;0;;;;;;;0x0;0x0;0x0;0x0;0x0;0x0 3;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N 1,0x1,0x17,0x789A,0x789ABCDE,0xFEDC0001,127,255,32767,65535,2147483647,4294967295,9223372036854775807,18446744073709551615,'1','12345678901234567890123456789012','123456789','1','12345678901234567890123456789012','123456789',0x12,0x123456789ABCDEF0,0x012345,0x12,0x123456789ABCDEF0,0x00123450 2,0x0,0x0,0x0,0x0,0x0,-128,0,-32768,0,-2147483648,0,-9223372036854775808,0,'','','','','','',0x0,0x0,0x0,0x0,0x0,0x0 3,,,,,,,,,,,,,,,,,,,,,,,,, drop table t1; create table t1 (pk int key ,f1 CHAR(1) BINARY, f2 CHAR(32) BINARY, f3 CHAR(255) BINARY ,g1 VARCHAR(32) BINARY, g2 VARCHAR(255) BINARY, g3 VARCHAR(1000) BINARY ,h1 BINARY(1), h2 BINARY(9), h3 BINARY(255) ,i1 VARBINARY(32), i2 VARBINARY(255), i3 VARBINARY(1000) ) engine ndb; insert into t1 values (1 ,'1','12345678901234567890123456789012','123456789 ' ,'1 ','12345678901234567890123456789012 ','123456789 ' ,0x20,0x123456789abcdef020, 0x012345000020 ,0x1200000020,0x123456789abcdef000000020, 0x00123450000020 ); create table t2 (pk int key, a int) engine ndb; create table t3 (pk int key, a int) engine ndb; create table t4 (pk int key, a int) engine ndb; insert into t2 values (1,11),(2,12),(3,13),(4,14),(5,15); insert into t3 values (1,21),(2,22),(3,23),(4,24),(5,25); insert into t4 values (1,31),(2,32),(3,33),(4,34),(5,35); '1' '1' '12345678901234567890123456789012' '123456789' '1' '12345678901234567890123456789012' '123456789' '0x20' '0x123456789ABCDEF020' '0x012345000020' '0x1200000020' '0x123456789ABCDEF000000020' '0x00123450000020' t1 -- 1 1 12345678901234567890123456789012 123456789 1 12345678901234567890123456789012 123456789 0x20 0x123456789ABCDEF020 0x012345000020 0x1200000020 0x123456789ABCDEF000000020 0x00123450000020 t2 -- 1 11 2 12 3 13 4 14 5 15 t3 -- 1 21 2 22 3 23 4 24 5 25 t4 -- 1 31 2 32 3 33 4 34 5 35 drop table t1; create table t1 (pk int key ,a1 MEDIUMINT, a2 MEDIUMINT UNSIGNED ) engine ndb; insert into t1 values(1, 8388607, 16777215); insert into t1 values(2, -8388608, 0); insert into t1 values(3, -1, 1); 1;8388607;16777215 2;-8388608;0 3;-1;1 drop table t1; drop table t2; drop table t3; drop table t4; create table t1 (a int primary key, normal decimal (20,10), unormal decimal (20, 10) unsigned, biggest decimal (65,30), ubiggest decimal (65,30) unsigned, small1 decimal (1,0), usmall1 decimal (1,0) unsigned, small2 decimal (1,1), usmall2 decimal (1,1) unsigned) engine=ndb; insert into t1 values (1, -9999999999.9999999999, 9999999999.9999999999, -99999999999999999999999999999999999.999999999999999999999999999999, 99999999999999999999999999999999999.999999999999999999999999999999, -9, 9, -0.9, 0.9); insert into t1 values (2, -1000000000.0000000001, 1000000000.0000000001, -10000000000000000000000000000000000.000000000000000000000000000001, 10000000000000000000000000000000000.000000000000000000000000000001, -1, 1, -0.1, 0.1); insert into t1 values (3, -0099.0099, 0099.0099, -0.1, 0.1, -5, 5, -0.5, 0.5); select * from t1 order by a; a 1 normal -9999999999.9999999999 unormal 9999999999.9999999999 biggest -99999999999999999999999999999999999.999999999999999999999999999999 ubiggest 99999999999999999999999999999999999.999999999999999999999999999999 small1 -9 usmall1 9 small2 -0.9 usmall2 0.9 a 2 normal -1000000000.0000000001 unormal 1000000000.0000000001 biggest -10000000000000000000000000000000000.000000000000000000000000000001 ubiggest 10000000000000000000000000000000000.000000000000000000000000000001 small1 -1 usmall1 1 small2 -0.1 usmall2 0.1 a 3 normal -99.0099000000 unormal 99.0099000000 biggest -0.100000000000000000000000000000 ubiggest 0.100000000000000000000000000000 small1 -5 usmall1 5 small2 -0.5 usmall2 0.5 1;-9999999999.9999999999;9999999999.9999999999;-99999999999999999999999999999999999.999999999999999999999999999999;99999999999999999999999999999999999.999999999999999999999999999999;-9;9;-0.9;0.9 2;-1000000000.0000000001;1000000000.0000000001;-10000000000000000000000000000000000.000000000000000000000000000001;10000000000000000000000000000000000.000000000000000000000000000001;-1;1;-0.1;0.1 3;-99.0099000000;99.0099000000;-0.100000000000000000000000000000;0.100000000000000000000000000000;-5;5;-0.5;0.5 drop table t1;