On 08/03/12 22:44, Alan Chandler wrote:
I have been running a financial management application application I
wrote for a number of years. My "production" version runs on Debian
stable system as a result is running sqlite v3.7.3. My personal
development machine is running Debian unstable and as a result has
sqlite 3.7.10.
Earlier this week I discovered a bug in a rarely used part of the
application, so took a copy of the production database and ran it on
my development machine. I quickly found that and fixed it, but another
major element of the application appeared to give some strange results.
I have spend some down tracking down what caused the problem, and it
seems to be a difference in how sqlite 3.7.3 and sqlite 3.7.10
processes the sql. It seems to me that the later release gets things
wrong - but it might be that the newer version has some sort of PRAGMA
that I am not using right. So I would like to ask here where I am
going wrong.
Things have now got stranger. I just saw the post on the e-mail list
for sqlitestudio and thought that looks interesting, so I have now
downloaded it. It seems to be using sqlite 3.7.8
It works correctly, and the very same sql using sqlite manager in
Mozilla goes wrong (this is linked to sqlite 3.7.10)
--
Alan Chandler
http://www.chandlerfamily.org.uk
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users