Eno Thereska <[EMAIL PROTECTED]> wrote: > Hi, > > I noticed the following strange problem when the expression to WHERE > contains clauses that refer to the same column. Here are three queries > and their output: > > > select count(*) from table1 > where ((timestamp >13448180261410868) and (timestamp <= 13448182164507680)); > > output: 100 > > > select count(*) from table1 > where (timestamp<=13448180261410868); > > output: 46 > > select count(*) from table1; > > output: 100 >
This problem is described by ticket #1188 http://www.sqlite.org/cvstrac/tktview?tn=1188 And was fixed for version 3.2.2 on 2005-March-31. -- D. Richard Hipp <[EMAIL PROTECTED]>
