exp.test025.ksh

来自「b树实现源码,linux和unix下运行,速度快,极好用」· KSH 代码 · 共 72 行

echo float data type testing;
Statement Executed
Statement Executed: Rows Affected = 1
Statement Executed: Rows Affected = 1
Statement Executed: Rows Affected = 1
Statement Executed: Rows Affected = 1
Statement Executed: Rows Affected = 1
Statement Executed: Rows Affected = 1
Statement Executed: Rows Affected = 1
Statement Executed: Rows Affected = 1
echo select * from t1;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	0.104857	10.234000	
	-0.104857	11.234000	
	12.234000	11.456000	
	13.123000	11.987000	
	14.467000	12.123000	
	50.345001	10.234000	
	123456.000000	10.234000	
	123.456001	10.234000	
	
echo select * from t1 where f1 BETWEEN 0.104856 AND 0.104858
select * from t1 where  f1 BETWEEN 0.104856 AND 0.104858;
echo select * from t1 where f1 >122 AND f1 <124;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	123.456001	10.234000	
	
echo select * from t1 where f1 BETWEEN -0.104859 AND -0.104856
select * from t1 where  f1 BETWEEN -0.104859 AND -0.104856;
echo select * from t1 where f1 BETWEEN -124 AND -122
select * from t1 where  f1 BETWEEN  -124 AND -122;
echo select * from t1 where f2 < f1;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	12.234000	11.456000	
	13.123000	11.987000	
	14.467000	12.123000	
	50.345001	10.234000	
	123456.000000	10.234000	
	123.456001	10.234000	
	
echo update t1 set f2 = 3.4345 where f2 >11;
Statement Executed: Rows Affected = 4
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	0.104857	10.234000	
	-0.104857	3.433500	
	12.234000	3.433500	
	13.123000	3.433500	
	14.467000	3.433500	
	50.345001	10.234000	
	123456.000000	10.234000	
	123.456001	10.234000	
	
echo delete from t1 where f1 > 14.234;
Statement Executed: Rows Affected = 4
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	0.104857	10.234000	
	-0.104857	3.433500	
	12.234000	3.433500	
	13.123000	3.433500	
	
Statement Executed