Our debug build works with CC compiler, while release build does not.
Eventually we found out that it was "-fast" (specifically,
"-xalias_level=basic" in "-fast") CC compiler option, that causes problems.
We are wondering what GCC 4.3.3 compiler options were used for testing on
Solaris 5.10 SPARC architecture. Thanks a lot,pam
> From: d...@sqlite.org
> Date: Fri, 29 Jun 2012 16:26:10 -0400
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] sqlite3_bind_int64() on Solaris 10?
>
> 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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
