2 echo bigint data
type testing
;
4 Statement Executed
: Rows Affected
= 1
5 Statement Executed
: Rows Affected
= 1
6 Statement Executed
: Rows Affected
= 1
7 Statement Executed
: Rows Affected
= 1
8 Statement Executed
: Rows Affected
= 1
9 Statement Executed
: Rows Affected
= 1
10 echo select * from t1
;
11 ---------------------------------------------------------
13 ---------------------------------------------------------
18 -9223372036854775808 1
21 echo select * from t1 where f1
= 10;
22 ---------------------------------------------------------
24 ---------------------------------------------------------
27 echo select * from t1 where f1
!= 12 AND f2
<= 13;
28 ---------------------------------------------------------
30 ---------------------------------------------------------
34 -9223372036854775808 1
37 echo select * from t1 where f1
= 12 AND f2
>= 22;
38 ---------------------------------------------------------
40 ---------------------------------------------------------
42 echo select * from t1 where f1
= 12 OR f1
> 13;
43 ---------------------------------------------------------
45 ---------------------------------------------------------
49 echo select * from t1 where f1
= 12 OR f2
< 13;
50 ---------------------------------------------------------
52 ---------------------------------------------------------
57 -9223372036854775808 1
60 echo select * from t1 where f1
= 12 OR f2
<> 22;
61 ---------------------------------------------------------
63 ---------------------------------------------------------
68 -9223372036854775808 1
71 echo select * from t1 where NOT f1
= 12;
72 ---------------------------------------------------------
74 ---------------------------------------------------------
78 -9223372036854775808 1
81 echo select * from t1 where f1
!= 12;
82 ---------------------------------------------------------
84 ---------------------------------------------------------
88 -9223372036854775808 1
91 echo select * from t1 where NOT f1
!= 12;
92 ---------------------------------------------------------
94 ---------------------------------------------------------
97 echo select * from t1 where f1
= f2
;
98 ---------------------------------------------------------
100 ---------------------------------------------------------
102 echo select * from t1 where f1 between
999999999997 and
999999999999;
103 ---------------------------------------------------------
105 ---------------------------------------------------------
107 echo select * from t1 where f1 between
-999999999999 and
-999999999997;
108 ---------------------------------------------------------
110 ---------------------------------------------------------
112 echo update t1
set f2
= 2 where f1
!= f2
;
113 Statement Executed
: Rows Affected
= 6
114 ---------------------------------------------------------
116 ---------------------------------------------------------
121 -9223372036854775808 2
122 9223372036854775807 2
124 echo update t1
set f2
= 3 where f1
= 50;
125 Statement Executed
: Rows Affected
= 0
126 ---------------------------------------------------------
128 ---------------------------------------------------------
133 -9223372036854775808 2
134 9223372036854775807 2
136 Statement Executed
: Rows Affected
= 0
137 ---------------------------------------------------------
139 ---------------------------------------------------------
144 -9223372036854775808 2
145 9223372036854775807 2