exp.test023.ksh

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

echo smallint 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
echo select * from t1;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	1	
	11	1	
	12	1	
	13	1	
	-9998	1	
	9998	1	
	50	23	
	
echo select * from t1 where f1 = 10;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	1	
	
echo select * from t1 where f1 != 12 AND f2 <= 13;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	1	
	11	1	
	13	1	
	-9998	1	
	9998	1	
	
echo select * from t1 where f1 = 12 AND f2 >= 22;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	
echo select * from t1 where f1 = 12 OR f2 < 13;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	1	
	11	1	
	12	1	
	13	1	
	-9998	1	
	9998	1	
	
echo select * from t1 where f1 = 12 OR f2 <> 22;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	1	
	11	1	
	12	1	
	13	1	
	-9998	1	
	9998	1	
	50	23	
	
echo select * from t1 where NOT f1 = 12;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	1	
	11	1	
	13	1	
	-9998	1	
	9998	1	
	50	23	
	
echo select * from t1 where f1 != 12;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	1	
	11	1	
	13	1	
	-9998	1	
	9998	1	
	50	23	
	
echo select * from t1 where NOT f1 != 12;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	12	1	
	
echo select * from t1 where f1 = f2;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	
echo select * from t1 where f1 between 9997 and 9999;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	9998	1	
	
echo select * from t1 where f1 between -9999 and -9997;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	-9998	1	
	
echo update t1 set f2 = 2 where f1 != f2;
Statement Executed: Rows Affected = 7
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	2	
	11	2	
	12	2	
	13	2	
	-9998	2	
	9998	2	
	50	2	
	
echo update t1 set f2 = 3 where f1 = 50;
Statement Executed: Rows Affected = 1
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	2	
	11	2	
	12	2	
	13	2	
	-9998	2	
	9998	2	
	50	3	
	
Statement Executed: Rows Affected = 1
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	2	
	11	2	
	12	2	
	13	2	
	-9998	2	
	9998	2	
	
Statement Executed