On Fri, Jun 29, 2012 at 4:22 PM, Pam Li <pam...@hotmail.com> wrote: > > Thanks for the qucik answer. Looks like our compilers are different. We > use CC. Which version of GCC do you use? Thanks again,pam >
Tested with GCC 4.3.3. > > From: d...@sqlite.org > > Date: Fri, 29 Jun 2012 15:51:35 -0400 > > To: sqlite-users@sqlite.org > > Subject: Re: [sqlite] sqlite3_bind_int64() on Solaris 10? > > > > FWIW, every recent release of SQLite has been tested on SunOS 5.10 > (Sparc) > > using GCC. That doesn't really answer your question (I don't know the > real > > answer) but it does at least demonstrate that SQLite has been made to > work > > correctly on Sparc and on SunOS. > > > > On Fri, Jun 29, 2012 at 3:17 PM, Pam Li <pam...@hotmail.com> wrote: > > > > > > > > > > > > > > > > > > > > > > > > > > Hello, We are using SQLITE 3.7.10 C/C++ interface API in our product. > > > This is the very first time we use it. Our product runs on Windows, > > > Linux and Solaris. We ran into a problem that a query on a 64 bit > integer > > > key is successful on both Windows and Linux, but not on Solaris 10. > The > > > code, database, and input data for the query are the same fro all > > > platforms. Query: select * from <table> where MAC_ADDR in (?1, ?2. > ?3); On > > > Solaris, if the MAC_ADDRESS value is 4 byte or less, a query is > successful. > > > If its value is 5-8 bytes, the query fails. API sequence we use for > the > > > query: ===========================sqlite3_prepare_v2() > sqlite3_bind_int64() > > > sqlite3_step() ... =========================== Has anyone else had > this > > > issue? Any clue is appreciated. Best regards,pam > > > > > > _______________________________________________ > > > sqlite-users mailing list > > > sqlite-users@sqlite.org > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > > > > > > -- > > D. Richard Hipp > > d...@sqlite.org > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
