Re: [sqlite] 64 bit libsqlite for AIX and Solaris

On 06/24/10 09:07 AM, Sushil wrote: > Hi, > > I am looking for 64 bit libsqlite for AIX and Solaris. Is there a place from > where I can > get them pre-built ? > > I have downloaded sqlite-amalgamation-3.6.23.1.tar and building it. But I > don't see any > option in configure to build it for 64

[sqlite] Why is there no test suite for ''make check' ?

I know the SQlite developers take testing quite seriously http://www.sqlite.org/testing.html with 679 times as much test code as actual code in the database. In fact, I've often pointed to the above page when trying to get the developers of the Sage maths software to pay a bit more attention

Re: [sqlite] Why is there no test suite for ''make check' ?

On 06/24/10 02:55 PM, Richard Hipp wrote: > On Thu, Jun 24, 2010 at 9:33 AM, Dr. David Kirkby > <david.kir...@onetel.net>wrote: > >> I know the SQlite developers take testing quite seriously >> >> http://www.sqlite.org/testing.html >> >> wi

Re: [sqlite] Why is there no test suite for ''make check' ?

ile, but that Makefile has no test/check/fulltest targets. Dave > Michael D. Black > Senior Scientist > Northrop Grumman Mission Systems > > > > > From: sqlite-users-boun...@sqlite.org on behalf of Dr. David Kirkby > Sent: Thu 6/24/2010 10:

Re: [sqlite] Why is there no test suite for ''make check' ?

On 06/24/10 05:13 PM, Richard Hipp wrote: > On Thu, Jun 24, 2010 at 12:03 PM, Dr. David Kirkby > <david.kir...@onetel.net>wrote: > >> On 06/24/10 04:20 PM, Black, Michael (IS) wrote: >>> Try one directory up. It's not in the src directory Makefile. >&g

Re: [sqlite] Why is there no test suite for ''make check' ?

On 06/24/10 05:13 PM, Richard Hipp wrote: > I see. You are building from the amalgamation. And you should be too. But > you are right - we do not ship test suites with the amalgamation. To use > the free test suite for SQLite, you have to build from canonical source > code. We have a

[sqlite] warning message when compiling on 64-bit SPARC

I get the following warning from sqlite3.c:109910:20: warning: cast from pointer to integer of different size when building on a Sun Blade 1000 with dual 900 MHz UltraSPARC III+ processors. I'm sorry to say this was with version sqlite-3.6.22, so you may have corrected it now. Since by

Re: [sqlite] Building On AIX 6.1 Upgraded From 5.3

On 09/13/10 09:44 PM, Joshua Gatcomb wrote: > I am trying to install the perl module DBD::SQLite. Since it didn't > work, I figured I would start with SQLite (amalgamation tar ball > 3.7.2). > > I am on AIX 6.1 (upgraded from 5.3) using gcc 4.2.0 which is compiled for 5.3 > > I have two theories

[sqlite] Ratio of test code to database code

Sorry if this is a bit off topic, but I read from http://www.sqlite.org/testing.html that your test code is 647 time bigger than the database code. I've often pointed developers of the Sage maths software to your link. I feel more attention should be paid to testing Sage, and less to adding

Re: [sqlite] Ratio of test code to database code

On 11/10/10 04:28 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 11/10/2010 05:53 AM, Dr. David Kirkby wrote: >> Someone recently said he felt that a test:code ratio of 1:1 is about optimal, > > That of course is bunk. That was my fee

Re: [sqlite] Ratio of test code to database code

On 11/10/10 08:58 PM, Samuel Adam wrote: > On Wed, 10 Nov 2010 08:53:40 -0500, Dr. David Kirkby > <david.kir...@onetel.net> wrote: > >> Someone recently said he felt that a test:code ratio of 1:1 is about >> optimal, so > > Where do people get notions like this

Re: [sqlite] Ratio of test code to database code

On 11/11/10 02:32 PM, Simon Slavin wrote: > > On 11 Nov 2010, at 1:41pm, Dr. David Kirkby wrote: > >> On 11/10/10 04:28 PM, Roger Binns wrote: >> >>> The SQLite developers decided their library will always be reliable and >>> greatly care about data integri

[sqlite] Build problem of sqlite-3.6.14.2 on Solaris 10 with gcc 4.4.0

I'm sending this to sqlite-users@sqlite.org in the hope someone can help, but are copying it to sage-de...@googlegroups.com so there is a record there. I'll post a summary to the latter list later. I'm helping out on the GPL'ed open-source mathematics program Sage http://www.sagemath.org/ to

Re: [sqlite] Build problem of sqlite-3.6.14.2 on Solaris 10 with gcc 4.4.0

i thought I'd copy the output of the config.log too. The message size limit of 40 KB was exceeded when I tried it in a previous attempt to submit this, so hopefully this will be ok. kir...@t2:~/sqlite-3.6.14.2$ more config.log This file contains any messages produced by compilers while

Re: [sqlite] Build problem of sqlite-3.6.14.2 on Solaris 10 with gcc 4.4.0

Dr. David Kirkby wrote: > Dr. David Kirkby wrote: > > I just tried to build libtool 1.5.24 (the version of libtool used in the > latest sqlite release, and noticed that: > > 4 of 107 tests failed > (5 tests were not run) > Please report to bug-libt...@gnu.org > Yes

Re: [sqlite] Build problem of sqlite-3.6.14.2 on Solaris 10 with gcc 4.4.0

Dr. David Kirkby wrote: > Dr. David Kirkby wrote: >> Dr. David Kirkby wrote: > > >> >> I just tried to build libtool 1.5.24 (the version of libtool used in >> the latest sqlite release, and noticed that: >> >> 4 of 107 tests failed >> (5 te

Re: [sqlite] Build problem of sqlite-3.6.14.2 on Solaris 10 with gcc 4.4.0

Nicolas Williams wrote: > On Fri, Jun 12, 2009 at 10:06:31PM +0100, Dr. David Kirkby wrote: >> [...] >> -lpthread -lc -Wl,-soname -Wl,libsqlite3.so.0 -o .libs/libsqlite3.so.0.8.6 >> >> If the order of libpthread and libc are exchanged, the library can be >>

Re: [sqlite] Build problem of sqlite-3.6.14.2 on Solaris 10 with gcc 4.4.0

Nicolas Williams wrote: > On Fri, Jun 12, 2009 at 04:34:50PM -0500, Nicolas Williams wrote: >> On Fri, Jun 12, 2009 at 10:06:31PM +0100, Dr. David Kirkby wrote: >>> [...] >>> -lpthread -lc -Wl,-soname -Wl,libsqlite3.so.0 -o .libs/libsqlite3.so.0.8.6 >>> >

Re: [sqlite] Build problem of sqlite-3.6.14.2 on Solaris 10 with gcc 4.4.0

Nicolas Williams wrote: > On Fri, Jun 12, 2009 at 04:34:50PM -0500, Nicolas Williams wrote: >> On Fri, Jun 12, 2009 at 10:06:31PM +0100, Dr. David Kirkby wrote: >>> [...] >>> -lpthread -lc -Wl,-soname -Wl,libsqlite3.so.0 -o .libs/libsqlite3.so.0.8.6 >>> >

Re: [sqlite] Build problem of sqlite-3.6.14.2 on Solaris 10 with gcc 4.4.0

Nicolas Williams wrote: > On Sat, Jun 13, 2009 at 01:43:15AM +0100, Dr. David Kirkby wrote: >> Thank you for your help. The fact you told me I did not need to link >> libpthread was crucial to solving this. >> >> I've found that just removing the libpthread from the ge

Re: [sqlite] Build problem of sqlite-3.6.14.2 on Solaris 10 with gcc 4.4.0

Tim Bradshaw wrote: > On 12 Jun 2009, at 23:46, Dr. David Kirkby wrote: > >> I don't know if you work for Sun, but if you do, it would be really >> good >> if Sun made some open-access Suns available for developers to test >> their >> code, like HP do

Re: [sqlite] Build problem of sqlite-3.6.14.2 on Solaris 10 with gcc 4.4.0

Tim Bradshaw wrote: > On 13 Jun 2009, at 12:29, Dr. David Kirkby wrote: > >> I believe if Sun make some public access machines available, there >> would >> be a benefit to Sun, and would hopefully avoid a lot of the GNUisms >> one >> sees in softw

Re: [sqlite] "Bad CPU type in executable"?

J. King wrote: > On Wed, 05 Aug 2009 12:50:15 -0400, Jean-Denis Muys > wrote: > >> You're top-posting, it's evil, the thread is becoming messy. That said... > > My impression has long been that top-posting is common and largely > unavoidable here, and no matter the

[sqlite] 3.6.17 not checking for readline.h in configure script.

This is with a Sun Ultra 80, running Solaris 10 update 7 with Sun Studio 12 update 1. drkir...@smudge:[~/sqlite-3.6.17] $ echo $CC /opt/sunstudio12.1/bin/cc drkir...@smudge:[~/sqlite-3.6.17] $ echo $CXX /opt/sunstudio12.1/bin/CC There is an issue where the configure script checks for readline

[sqlite] Compiler warnings with Sun Studio 12.1 on Solaris 10

"sqlite3.c", line 18731: warning: integer overflow detected: op "<<" "sqlite3.c", line 18748: warning: integer overflow detected: op "<<" "sqlite3.c", line 32546: warning: statement not reached "sqlite3.c", line 69160: warning: integer overflow detected: op "<<"

Re: [sqlite] Compiler warnings with Sun Studio 12.1 on Solaris 10

Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Dr. David Kirkby wrote: >> "sqlite3.c", line 18731: warning: integer overflow detected: op "<<" >> "sqlite3.c", line 18748: warning: integer overflow dete

[sqlite] How do you check if the linker is the GNU linker?

I notice when configuring sqlite that you check if the GNU linker is the GNU linker. I'd like to pinch that bit of code from you, but I don't see anything in configure.ac for this. Is this something you have hard-crafted into the configure script? Dave

Re: [sqlite] Compiler warnings with Sun Studio 12.1 on Solaris 10

D. Richard Hipp wrote: >> Thank you. >> >> I understand you can't fix these warnings since you don't have >> access to >> such machines. Would you like access? If so, I can give you access >> to a >> 16-core Sun T5240 at the university of Washington, with runs Solaris >> 10 >> update 7

Re: [sqlite] How do you check if the linker is the GNU linker?

Mihai Limbasan wrote: > Hi, Dave! > > That piece of code comes from the macros inserted by the libtool > support. Normally, you should find the macro in > /usr/share/aclocal/lib-ld.m4 (at least on Fedora, Debian, and Gentoo.) > In case it's not there, I've reproduced the M4 macro below. Please

Re: [sqlite] sqlite build issues on IBM's HP-UX 11i

Rich Shepard wrote: > On Sat, 10 Oct 2009, Dr. David Kirkby wrote: > >> I work on the Sage maths project which aims to create a viable free open >> source alternative to Magma, Maple, Mathematica and Matlab. > > Dave, > > I've use Octave which is supposed to b

Re: [sqlite] sqlite build issues on IBM's HP-UX 11i

The title is a bit silly. HP-UX is distributed by HP, not IBM of course. Sorry for any confusion. dave ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite build issues on IBM's HP-UX 11i

Dr. David Kirkby wrote: > Hi, > > I work on the Sage maths project > > http://www.sagemath.org/ > > which aims to create a viable free open source alternative to Magma, > Maple, Mathematica and Matlab. > > Sage uses sqlite. Whilst there are no official plans t

Re: [sqlite] SUM(tripSeconds) and format output as days.hours:minutes:seconds.hundredths?

Alex Mandel wrote: > DaleEMoore wrote: >> I'd like to SUM(tripSeconds) and format output as >> days.hours:minutes:seconds.hundredths, but have not been able to figure out >> how to do that with sqlite. This didn't seem to come close: >> >> SELECT >> STRFTIME('%d', SUM(tripSeconds)) + '.' + >>

Re: [sqlite] SQLite bug ticket - build fails on sun4-solaris-64int 2.10

Darren Duncan wrote: > I would like to bring an apparent SQLite bug to the attention of the SQLite > core > developers as a ticket, where build fails on sun4-solaris-64int 2.10. > > This problem was reported to the DBD::SQLite (Perl binding) developers as an > automatically generated smoke