I used the Numerical python package and its types don't always behave well with other python variables - I had to insert into sqlite by piecing togethera literal SQL statement rather than binding the variables. So no doubt you are right and the problem is related to the number of digits or the type of the python variable I was using. I'll try to repeat using more orthodox python types.
Many thanks, Tom Griggs, Donald-3 wrote: > > > Hi, Tom, > > > Regarding: "Adding values to att0 (one of the numeric columns) gives > this odd result:" > > I tried this on win xp 32 using the sqlite3.exe command-line interface > and for me it *does* behave as expected. > > I tried it under sqlite 3.5.5 and under 3.6.6.2. > > I wonder if PHP (or something) is having a problem with the larger > number of digits in the result when rowid=2? > > sqlite> select itemid, att0, (att0 + 0.95) dx from map; > 0|0.0290534291416|0.9790534291416 > 1|-0.0737001597881|0.8762998402119 > 2|-0.957751333714|-0.00775133371400005 > 3|-0.229464128613|0.720535871387 > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/Elementary-arithmetic-question-tp20737193p20737894.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
