Hello, We have a small sqlite3 database compiled into our handheld unit (system details below). Upgrading from 3.7.14.1 to 3.8.2 our previously sorted queries are no longer sorted. Testing this same database with the win7 binary 3.8.2 the query is correctly sorted.
I have tried: * adding specific indexes * reindex immediately before the query * removing all indexes * collating binary * collating nocase * debugging the sqlite engine, but nothing jumped out at me, and this is out of my knowledge base. Any ideas on why the amalgamation would behave differently compiled into our project? System details: - LPC2468 (ARM7) - uCOS-II (RTOS) - IAR C compiler Thank you, Ken ken labar | Embedded Firmware Engineer Hach Hydromet | www.hachhydromet.com<http://www.hachhydromet.com/> | [email protected]<mailto:[email protected]> Innovating technology behind better data Please be advised that this email may contain confidential information. If you are not the intended recipient, please notify us by email by replying to the sender and delete this message. The sender disclaims that the content of this email constitutes an offer to enter into, or the acceptance of, any agreement; provided that the foregoing does not invalidate the binding effect of any digital or other electronic reproduction of a manual signature that is included in any attachment. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
