Gillman, David wrote:
> Is this expected behavior? (The failure of my query to return a row.)
Your query does not have a well-defined meaning, so no particular behavior is
expected from it.
--
Igor Tandetnik
___
sqlite-users mailing list
sqlite-user
Is this expected behavior? (The failure of my query to return a row.)
David
-Original Message-
From: Kit [mailto:kit.sa...@gmail.com]
Sent: Saturday, December 03, 2011 5:24 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] union-having bug
2011/12/3 Gillman, David
2011/12/3 Gillman, David :
> Is this behavior known? The third query returns no rows even though bar = 1.
> sqlite> select ind, sum(foo) foo, sum(bar) bar from (select 1 ind, 0 foo, 1
> bar union select 1 ind, 1 foo, 0 bar) group by ind having bar > 0;
select ind, sum(foo) fooo, sum(bar) barr fr
Gillman, David wrote:
> Is this behavior known? The third query returns no rows even though bar = 1.
>
> sqlite> select ind, sum(foo) foo, sum(bar) bar from (select 1 ind, 0 foo, 1
> bar union select 1 ind, 1 foo, 0 bar) group by ind
> having foo > 0;
> ind|foo|bar
> 1|1|1
> sqlite> select ind
from (select 1
ind, 0 foo, 1 bar union select 1 ind, 1 foo, 0 bar) group by ind) where bar > 0;
ind|foo|bar
1|1|1
sqlite>
-Original Message-
From: Gillman, David [mailto:dgill...@akamai.com]
Sent: Friday, December 02, 2011 6:37 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] u
Hi,
Is this behavior known? The third query returns no rows even though bar = 1.
sqlite> select region, sum(edge) edge, sum(infra) infra from (select 1 region,
0 edge, 1 infra union select 1 region, 1 edge, 0 infra) group by
region;region|edge|infra
1|1|1
sqlite> select ind, sum(foo) foo, sum(
6 matches
Mail list logo