ge-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of ??
>Sent: Sunday, 19 August, 2018 00:58
>To: sqlite-users
>Subject: [sqlite] bug: compare number with empty string get different
>resut
>
>create table t1(c int);
>insert
Ok, thanks everyone, it's perfectly clear now.
Cheers,
Norm.
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listin
On 19 Aug 2018, at 7:56pm, Warren Young wrote:
> On Aug 19, 2018, at 10:03 AM, Norman Dunbar wrote:
>
>> Duck Typing? Never heard that before.
>
> It’s a pretty common term of art in the software development world:
>
> https://en.wikipedia.org/wiki/Duck_typing
That article was written 20 y
On Aug 19, 2018, at 10:03 AM, Norman Dunbar wrote:
>
> Duck Typing? Never heard that before.
It’s a pretty common term of art in the software development world:
https://en.wikipedia.org/wiki/Duck_typing
___
sqlite-users mailing list
sqlite-users@ma
Duck Typing? Never heard that before.
Cheers,
Norm.
--
Sent from my Android device with K-9 Mail. Please excuse my brevity and any
"auto corrections" that are just wrong!
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailing
On 2018/08/19 8:58 AM, 麦轲数据管家 wrote:
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>
It's documented behaviour.
https://www.sqlite.org/datatype3.html#comparisons
2018-08-19 8:58 GMT+02:00, 麦轲数据管家 :
> 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 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,
8 matches
Mail list logo
