It's documented behaviour. https://www.sqlite.org/datatype3.html#comparisons
2018-08-19 8:58 GMT+02:00, 麦轲数据管家 <[email protected]>: > create table t1(c int); > insert into t1 values (1),(2),(3); > select * from t1 where c>'' ; --get nothing(empty result) > select * from t1 where c<''; --get result set:1,2,3 > > > create table t2(c char); > insert into t2 values (1),(2),(3); > select * from t2 where c>''; --get correct result set: 1,2,3 > > the only difference of t1 and t2 is the column data type: int vs char > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
