exp.test027.ksh

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

echo bigint 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
echo select * from t1;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	1	
	11	1	
	12	1	
	13	1	
	-999999999998	1	
	999999999998	1	
	
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	
	-999999999998	1	
	999999999998	1	
	
echo select * from t1 where f1 = 12 AND f2 >= 22;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	
echo select * from t1 where f1 = 12 OR  f1 > 13;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	12	1	
	999999999998	1	
	
echo select * from t1 where f1 = 12 OR f2 < 13;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	1	
	11	1	
	12	1	
	13	1	
	-999999999998	1	
	999999999998	1	
	
echo select * from t1 where f1 = 12 OR f2 <> 22;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	1	
	11	1	
	12	1	
	13	1	
	-999999999998	1	
	999999999998	1	
	
echo select * from t1 where NOT f1 = 12;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	1	
	11	1	
	13	1	
	-999999999998	1	
	999999999998	1	
	
echo select * from t1 where f1 != 12;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	1	
	11	1	
	13	1	
	-999999999998	1	
	999999999998	1	
	
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 999999999997 and 999999999999;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	999999999998	1	
	
echo select * from t1 where f1 between -999999999999 and -999999999997;
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	-999999999998	1	
	
echo update t1 set f2 = 2 where f1 != f2;
Statement Executed: Rows Affected = 6
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	2	
	11	2	
	12	2	
	13	2	
	-999999999998	2	
	999999999998	2	
	
echo update t1 set f2 = 3 where f1 = 50;
Statement Executed: Rows Affected = 0
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	2	
	11	2	
	12	2	
	13	2	
	-999999999998	2	
	999999999998	2	
	
Statement Executed: Rows Affected = 0
---------------------------------------------------------
	f1	f2	
---------------------------------------------------------
	10	2	
	11	2	
	12	2	
	13	2	
	-999999999998	2	
	999999999998	2	
	
Statement Executed