Re: [sqlite] Difference between 3.7.11 and 3.7.13

2012-06-22 Thread Marco Bambini
I am sorry, but it was sent twice for a mistake. -- Marco Bambini http://www.sqlabs.com On Jun 21, 2012, at 2:41 PM, Marco Bambini wrote: > Consider the following example: > > CREATE TABLE t1(x); > CREATE TABLE t2(y); > SELECT max((SELECT avg(x) FROM t2)) FROM t1; > > With sqlite 3.7.11 NULL i

[sqlite] Difference between 3.7.11 and 3.7.13

2012-06-22 Thread Marco Bambini
Consider the following example: CREATE TABLE t1(x); CREATE TABLE t2(y); SELECT max((SELECT avg(x) FROM t2)) FROM t1; With sqlite 3.7.11 NULL is returned, while with sqlite 3.7.13 an error "Misuse of aggregate: avg()" is returned. Any thought? -- Marco Bambini http://www.sqlabs.com http://twitter

Re: [sqlite] Difference between 3.7.11 and 3.7.13

2012-06-21 Thread Keith Medcalf
ww.asciiribbon.org > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Igor Tandetnik > Sent: Thursday, 21 June, 2012 14:10 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Difference between 3.7.11 and 3.7

Re: [sqlite] Difference between 3.7.11 and 3.7.13

2012-06-21 Thread Igor Tandetnik
On 6/21/2012 3:52 PM, Pavel Ivanov wrote: CREATE TABLE t1(x); CREATE TABLE t2(y); SELECT max((SELECT avg(x) FROM t2)) FROM t1; So you are saying that behavior of such query should be equivalent to "SELECT max(x) FROM t1"? Not quite, but you get the idea. I think "select avg(SomeConstExpr) fro

Re: [sqlite] Difference between 3.7.11 and 3.7.13

2012-06-21 Thread Pavel Ivanov
On Thu, Jun 21, 2012 at 3:41 PM, Igor Tandetnik wrote: > On 6/21/2012 12:17 PM, Pavel Ivanov wrote: >> >> On Thu, Jun 21, 2012 at 11:47 AM, Marco Bambini wrote: >>> >>> Consider the following example: >>> >>> CREATE TABLE t1(x); >>> CREATE TABLE t2(y); >>> SELECT max((SELECT avg(x) FROM t2)) FROM

Re: [sqlite] Difference between 3.7.11 and 3.7.13

2012-06-21 Thread Igor Tandetnik
On 6/21/2012 12:17 PM, Pavel Ivanov wrote: On Thu, Jun 21, 2012 at 11:47 AM, Marco Bambini wrote: Consider the following example: CREATE TABLE t1(x); CREATE TABLE t2(y); SELECT max((SELECT avg(x) FROM t2)) FROM t1; With sqlite 3.7.11 NULL is returned, while with sqlite 3.7.13 an error "Misuse

Re: [sqlite] Difference between 3.7.11 and 3.7.13

2012-06-21 Thread Pavel Ivanov
On Thu, Jun 21, 2012 at 11:47 AM, Marco Bambini wrote: > Consider the following example: > > CREATE TABLE t1(x); > CREATE TABLE t2(y); > SELECT max((SELECT avg(x) FROM t2)) FROM t1; > > With sqlite 3.7.11 NULL is returned, while with sqlite 3.7.13 an error > "Misuse of aggregate: avg()" is return

[sqlite] Difference between 3.7.11 and 3.7.13

2012-06-21 Thread Marco Bambini
Consider the following example: CREATE TABLE t1(x); CREATE TABLE t2(y); SELECT max((SELECT avg(x) FROM t2)) FROM t1; With sqlite 3.7.11 NULL is returned, while with sqlite 3.7.13 an error "Misuse of aggregate: avg()" is returned. Any thought? -- Marco Bambini http://www.sqlabs.com http://twitter