Given:
./testfixture
% sqlite3 -has_codec
Error: wrong # args: should be sqlite3 HANDLE FILENAME ?-vfs VFSNAME?
?-readonly BOOLEAN? ?-create BOOLEAN? ?-nomutex BOOLEAN? ?-fullmutex
BOOLEAN?
% sqlite3 -has-codec
0
and:
src/tclsqlite.c:if( strcmp(zArg,-has-codec)==0 ){
are the instances of
Hi,
I sent a patch which fixes a fairly large number of typos in
the 3.7.0 HTML documentation to the list on the 25th July.
It was sent from an unsubscribed address and apart from a
message saying it would need to be moderated, it appears
to have vanished without trace.
Is this the sort of
present and future rights to
this code under copyright law.
Regards,
Martin Jenkins
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Mike Owens wrote:
Mike Owens wrote:
I've been lobbying Apress to release the book in electronic form for
free.
That seems a bit extreme
I wasn't referring to releasing the book as an exclusive solution to
the index problem, but rather for the community and SQLite in general.
metro wrote:
is this what everybody is looking for??
http://booksforpeople.blogspot.com/2008/03/definitive-guide-to-sqlite-free-book.html
there are other sources for free ebooks
Laurie
It did the rounds on alt.binaries.e-book.technical last year. The
buyer's email address had been
Mike Owens wrote:
I've been lobbying Apress to release the book in electronic form for
free. It's currently under consideration, but I've not heard anything
back yet.
That seems a bit extreme - how about a user generated/funded index on
the web somewhere?
Download and print a PDF, stick it
litenoob wrote:
Hi, I'm wondering how to write a BASH script that will capture my SQLite
output.
I can do it for a single line with something like this:
somevar=`sqlite3 dbfilename SELECT name FROM tablename WHERE name='smith'
LIMIT 1;`
However, if I want to do anything with multiple lines, I
Joe Wilson wrote:
A non-volatile RAM drive is the way to go if you got the bucks.
16 Processor machine
~40Gb ram
EMC storage
suggests he does. ;)
I worked on a project where the end client had Sun kit of this spec, and
they claimed the systems cost 7 figures GBP back in 2005.
Martin
wcmadness wrote:
Hey, Folks:
I'm writing a financial application and MUST have exact math decimals (no
floats). So, I'm using Python's decimal module.
My database is Sqlite (and my language is Python with Pysqlite); Sqlite
doesn't offer a non-floating point decimal type. But, it does have
B V, Phanisekhar wrote:
What exactly happens when I change the cache_size (both increase and
decrease size)?
A variable is set.
It seems this term is a misnomer. What are we achieving by setting this
variable?
[...]
Will there be any memory that will be freed up when I reduce the size
B V, Phanisekhar wrote:
Kennedy,
You are using Join that's going to take time. I need the most
efficient query.
Dan's one of the SQLite developers, so presumably has a rough idea of
what his suggested query will be doing... ;)
Martin
Jonas Sandman wrote:
I am using LIKE to make a simple query for filename '%path%' and it
works well as long as I am only using ANSI characters, LIKE thinks
'a' and 'A' are the same. When coming up on Greek characters (i.e.)
it doesn't work that well anymore. Suddenly LIKE is case-sensitive
Vivien Malerba wrote:
Hi!
In a single process, I open two connections (C1 and C2) to the same
database (this is actually a corner case which could happen) and the
following sequence of operations fail:
1- on C1 execute CREATE table actor (...) = Ok
2- on C1 execute SELECT * FROM actor = Ok
3-
Bennett, Patrick wrote:
No comment at all? That's three users asking for this now. :(
Dr Hipp usually responds pretty quickly, but sometimes he's away on
business. You know, supporting the paying customers... ;)
Martin
Bennett, Patrick wrote:
I wasn't sure who maintained the binary distribution and based on the
recent list activity, I assumed someone who was responsible would've
already replied.
As fas as I know, the dev team is Dr Hipp and Dan Kennedy (apologies if
there's someone else and I missed you)
[EMAIL PROTECTED] wrote:
Martin Jenkins [EMAIL PROTECTED] wrote:
I agree, it is slightly odd for neither of them to reply.
Why is it odd?
Because you normally reply to these things, if only to say something lie
the pre-processed source for Windows is provided as a courtesy. ;)
We have
Gilles Ganault wrote:
At 14:40 23/04/2007 +0200, Stef Mientki wrote:
I've no experience whatsover, but if I see the list, the top one is
the best choice, because it'll be integrated in the standard Python.
Thanks. I didn't know SQLite was part of Python 2.5.
pysqlite implements Python's
Marco Bambini wrote:
This query on a small database sometimes takes more than 40 seconds:
select _rowid, public_id, vote_count, status, summary, component,
date(date_modified), quickfix from reports where public = 1 AND _rowid
IN (select distinct r._rowid from reports r, segments s where
Huian Li wrote:
I have a package which uses functions like
sqlite3_get_database_file_fd() and
sqlite3_get_journal_file_fd(). Supposedly
sqlite3_fds.h has these two functions and fds.c
defines them, but I searched both sqlite-3.3.4 and
sqlite-3.3.15, and could not find anything. Does
anyone know
Lloyd wrote:
Hi,
I don't know whether this is an irrelevant question in SQLite list, but
I don't see a better place to ask.
Which data structure is best to store and retrieve data very fastly?
There is a 95% chance that the searched data to be present in the data
structure. There will be 1000s
Lloyd wrote:
hi Puneet and Martin,
On Wed, 2007-04-11 at 14:27 +0100, Martin Jenkins wrote:
File system cache and plenty of RAM?
It is meant to run on an end user system (eg. Pentium 4 1GB RAM). If you
mean Swap space as file system cache, it is also limited, may be 2GB.
I was just
[EMAIL PROTECTED] wrote:
www.wipro.com
Would this be Wipro, the outsourcing company?
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
P Kishor wrote:
In any case, unless DRH establishes a semi-official policy, let the
pronounciation be in public domain as well... to each her own.
Well there is that Google video. You could look at that to get Dr Hipp's
definitive pronunciation, but ISTR even he wasn't 100% consistent. ;)
Dennis Cote wrote:
P Kishor wrote:
Anyway a little digging on wikipedia found this:
/SQL/ is commonly spoken either as the names of the letters /ess-cue-el/
I pronounce XQP as ex queue pee so I reckon SQL should be ess queue ell,
even if it was around twenty years before I was. Anyone who
Pavan wrote:
Does SQLite handle multiple request handling ?
Yes.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
John Stanton wrote:
Perl would not do a good job. You need to use the Sqlite page
structures and they are defined in C terms.
But Tcl might. The test suite pokes about with SQLite internals.
Martin
-
To unsubscribe,
Arora, Ajay wrote:
Can anyone please look into my query,
I've tables
Master ( id integer primary key,
field1 text)
And
Child (id integer, name text)
Might be worth looking for Celko's Hierarchies in SQL. I've not read
it but I've seen good reviews and Celko seems well
[EMAIL PROTECTED] wrote:
Martin Jenkins [EMAIL PROTECTED] wrote:
Very true. Furthermore, the B-Tree interface layer is not a part
of the published API and as such it is subject to change without
notice and between point releases.
I nearly said that the B-Tree interface was unpublished
fangles wrote:
When I have text pasted into an sqlite string field, it is stored okay but
when I retrieve a string, it is truncated at the first CR (0D).
Hi fangles,
Did you get this sorted?
Martin
-
To unsubscribe,
Dennis Volodomanov wrote:
[...]
The reason that such a huge amount of statements needs to be executed so
many times very quickly is that we have a tree built up based on those
statements and that tree needs to be pruned if the results of statements
are empty in real-time as the user is typing a
Dan Kennedy wrote:
Even using the prepare_v2() interface, the database handle error-code
and error-message (the stuff returned by sqlite3_errcode() and
sqlite3_errmsg() respectively) are not populated by sqlite3_step().
After sqlite3_step() reports an error you need to call either
Stephen Toney wrote:
Meta-question: this is the second time I've asked this question. The
first was about a month ago and got not a single reply. Is there
something wrong with my postings? Or is this just not an interesting
topic?
I think it just boils down to how much time people have.
fangles wrote:
SQLite doesn't truncate anything. Whatever you put in you get out. If
you see a truncation, it is either done by whatever wrapper you use
on top of SQLite, or simply an artifact of the way you inspect the
data (e.g. you look at the string in a debugger, and the debugger
just
Vivien Malerba wrote:
Hi!
I've got an error reporting problem when trying to insert a row which
breaks a UNIQUE constraint in a table in a C program, I get the
following error with sqlite3_errmsg():
SQL logic error or missing database
If I fire the sqlite3 program and run the same SQL query, I
Vivien Malerba wrote:
Here is a sample test case, just uncompress, run make and ./test.
Here is what I get using SQLite 3.3.13 (On Linux):
SQL error (step): SQL logic error or missing database
SQL error (step): column name is not unique
It shows that calling sqlite3_reset() seems to be required
Chris Jones wrote:
realized that the unix sort
If I'd known you were on 'nix I'd have suggested using 'sort' and/or
'md5sum' about 12 hours ago. ;)
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
P Kishor wrote:
Mac/Unix person meself, but the Windows XP sort is pretty darn good as
well.
I'll take a look. Last time I used it it was useless. Win9x days? these
days (especially for a one off) I'd probably go straight to doing it in
Python to avoid x-platform syntax issues.
Martin
Dimitris P. Servis wrote:
I have to provide evidence that such an anorthodox solution is also
feasible
If it was me I'd investigate the problem by doing the right thing in
the first place, by which time I'd know enough to knock up the wrong
solution for the doubters before presenting the
Vivien Malerba wrote:
I've already sent a proposal along with a patch some time ago about
that, but nobody seemed to care, see
http://www.mail-archive.com/sqlite-users@sqlite.org/msg21285.html
Vivien, I can't see any patch attached to that post. Perhaps you should
resubmit it? And I'll guess
Stef Mientki wrote:
so it was indeed a stupid question !
No, it was a well phrased question with a simple answer.
A stupid question is when the message is I CANT OPEN A DATABSE!!! WHY
[EMAIL PROTECTED] IT WORK? IS IT A BUG!!! and nothing else. ;)
mj
Mitchell Vincent wrote:
So is a 60%ish reduction in DB size from 2.8.16 to 3.3.13 normal?
Don't know about normal but ISTR version 3 did bring some fairly major
improvements in file size. Given that you have your data in both SQLite
formats would it not be fairly easy to dump both databases
Jakub Ladman wrote:
Problem is, that this is pretty obscure system. Renesas SuperH SH4
CPU Heavily patched 2.4.18 kernel. (patches will be presented on
internet, but not at this time) Gentoo-embedded linux, based on
uclibc 0.9.28 and busybox . Main storage is SD flash card.
I must confess,
Jakub Ladman wrote:
Now i have discovered, that this appears only if the database file is stored
on the nfs filesystem (posibly too slow, or something similar)
There have been many threads on this list about NFS locking being
broken, but few reports of it actually happening. Could you post a
Jakub Ladman wrote:
Thank you i will try my possibilities buying from amazon, while i am based in
the Czech republic.
Unfortunately it is little bit expensive for me, to buy it without looking
into it before.
I don't know if would help, but Apress sell an e-book (PDF) version for
about half
RohitPatel wrote:
/* SQLite 3.3.8 (Windows) used */
/* table t1 */
/* only two columns are given because other columns are irrelevant here */
create table t1 (id INTEGER PRIMARY KEY, name TEXT);
/* few sample records from csv file data.csv */
1,'name_text_1'
2,'name_text_2'
3,'name_text_3'
Cesar Rodas wrote:
The URL is ok, I opened here...
Works fine in .uk too
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Samuel R. Neff wrote:
Eric,
Sorry if this is obvious to everyone else but not to me.. what exactly is
cursor()? I don't see it anywhere in the C API and the wrapper I'm using
(SQLite .NET) doesn't have any corresponding method.
A cursor is the thing that you use to run your queries. Eg in
Jakub Ladman wrote:
But there is not tcl library at the time and when I tried to build sqlite
without -DNO_TCL it failed.
I think you will have fewer problems building Tcl than you did building
SQLite because the automake code will be more up to date. You'v ebuilt
SQLite so you're an expert
Samuel R. Neff wrote:
One last set of performance numbers for opening a connection. :-)
All points on the curve. ;)
So the impact of open/closing connections on a real-world db really is huge.
You're right, that's a huge difference. Good bit of benchmarking there.
These tests with
Jakub Ladman wrote:
And what should i do with this?
SQLite version 3.3.13
Enter .help for instructions
sqlite create table tbl1(one varchar(10), two smallint);
SQL error: database is locked
sqlite
What was the command line? Can you get Tcl running on your machine? As
you've effectively
Jakub Ladman wrote:
Problem is, that i do not know tcl. I know only that it exist.
Jakub
That's OK, it's just another target (make test) in the Makefile. You
don't need to know any Tcl, you just have to install the source code and
know where you've installed it.
make test builds a program
Kirrthana M wrote:
Im developing an application using sqlite3 in MAC OS,I just wanted to
know wheather sqlite3 can be used in MAC OS.
I don't use Mac, but I *think* SQLite is bundled with later versions.
If so can the same sqlite3 library and the executable used in windows
can be used in MAC
Stef Mientki wrote:
I just read it's not possible to delete a column in an existing table.
Now what would be the best way to remove the column indirect
(from Delphi code),
I've never needed to do this so the following are just hints.
The special table sqlite_master contains the SQL that was
Peter van Dijk wrote:
every time you open an sqlite database file, the sqlite library has to
parse all table structures. It is much better to keep your
connection/handle open for longer periods of time.
On my XP box it takes about 220us to connect to an SQLite database from
Python, whether
Martin Jenkins wrote:
So the difference in connect times between a database with 1 table and
10 tables is ...
It appears that adding indexes (and triggers?) increases the time at
about the same rate as adding tables. That is a connect/first select to
a database with 1 table and 3 indexes
Samuel R. Neff wrote:
Thank you for the testing and information.
;)
When I have time to run some tests using our actual schema (120+ tables,
several hundred indexes) I'll post back here in case others are interested
in our results. From your tests it looks like more complex schemas probably
Jakub Ladman wrote:
but after correction of this i get:
libsqlite3.a -lpthread
libsqlite3.a(os_unix.o): In function `sqlite3UnixDlopen':
os_unix.c:(.text+0x848): undefined reference to `dlopen'
libsqlite3.a(os_unix.o): In function `sqlite3UnixDlsym':
os_unix.c:(.text+0x85c):
RB Smissaert wrote:
OK, I understand better now. This though doesn't seem quite right to
me:
0, //sqlite3_libversion,
It looks sqlite3_libversion should be a string.
No, this is a list of function pointers. C has no notion of the *name*
of the function, only its address. Functions are
Alex Cheng wrote:
Hi,
I want to know how many time is spent when create a sqlite connection.
Is it effeciency? My application creates a connection and close it
when access DB everytime, is it OK?
Going by your sig, here are the times for Python 2.5 running under XP
SP2 on a 1.6GHZ dual
Jakub Ladman wrote:
You want make -f Makefile.linux-gcc
This
make Makefile.linux-gcc
Will try to build Makefile.linux-gcc from a file called Makefile
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
Thomas Dybdahl Ahle wrote:
Hi, I'm running a project using pysqlite for database support. It's
awsome.
Now I have a user who produces this warning: Warning: You can only
execute one statement at a time.
Hard to say without knowing the value of sql in
cur.execute(sql)
pysqlite's execute
RB Smissaert wrote:
Could anybody pass me step by step instructions to compile the source with
MS VC++ ? I don't code or compile in C at all and only code in VB/VBA.
There a some instructions at:
http://www.sqlite.org/cvstrac/wiki?p=HowToCompile
and a zip file - sqlite-source-3_3_13.zip -
RB Smissaert wrote:
Thanks, will have a look at that.
Do you know from experience that it will compile OK with VC6++?
I'm pretty sure I've compiled it with VC6++. I've been compiling on
Debian and Solaris machines recently and have sort of lost track of
building stuff on Windows. I tried
RB Smissaert wrote:
Now what do I do make it compile a dll called SQLite3VB.dll?
I think it defaults to the project name, but have a look at the Link tab
in the Project|Settings dialog (Alt-F7) - there's an edit box titled
Output file name which might do what you want.
Martin
RB Smissaert wrote:
When compiling this source code I get 265 warning, which doesn't really
worry me that much as it all seems to be working fine, but in general what
kind of warning should be taken seriously?
This has come up the list before. Dr Hipp assigns a lot more weight to
his tests
Jakub Ladman wrote:
Hi Friends
Please help me
I need crosscompile sqlite for my sh4 cpu based linux system, but configure
script (any version of sqlite i have tryed, even the actual one from sqlite
homepage) fails if crosscompilation is selected.
Crosscompiler works good in other cases.
Thank
mxs wrote:
I had to google around to find out what is wxWidgets
...
I decided I'd like to try Python and SQLite
Check out wxPython too.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
RB Smissaert wrote:
Did you make the alterations to make the dll VB compatible?
I don't think Dennis was building the VB version. The lines that Todd
says you have to comment out - did you comment them out or replace them
with a 0?
I haven't analysed the code fully but I'm a bit suspicious
RB Smissaert wrote:
Thanks, that is very helpful and reassuring as well.
Will see if I can figure out then what is causing this one:
warning C4028, as you say that could be a typo.
I've just built 3.3.12 source with VC6 and didn't see that error. I
changed the warning level to 4 and got 500
RB Smissaert wrote:
Microsoft Visual C++ 6 Enterprise edition.
Hmm. I'm using VC6++ Pro. I wonder if it's safe to assume the compilers
are the same and the difference is that I don't have the Enterprisey
middleware gubbins.
I think it is the latest before .net came in.
Dunno. I kind of
RB Smissaert wrote:
How would I do this:
compile with -DSQLITE_OMIT_LOAD_EXTENSION=1 to leave it out.
Remember that link tab I said about earlier?
There's a C/C++ tab next to it with a Preprocessor definitions edit
box. I think what you want is to put ,SQLITE_OMIT_LOAD_EXTENSION=1 at
the
RB Smissaert wrote:
Will give that a try and see if it gives any less warnings.
OK, but as Dennis suggested and Dr Hipp has confirmed this isn't the way
to go. I was assuming the VB thing was a bit of a hack and didn't really
read enough of the C code.
Martin
RB Smissaert wrote:
Due to me not knowing C I hadn't realized that this structure had to be left
intact.
It's not a C thing as such, it's the way Dr Hipp has designed it. It's
an interface - the third entry in the list always does the same thing
but the function that actually runs to do
Cesar Rodas wrote:
#define uchar unsigned char *
suggests it's a char but is in fact a pointer to a char so the signature
of LoadFileContent is actually
int LoadFileContent(unsigned char **path, unsigned char ***value, ...
and that triggers my three levels of indirection is usually an
Joe Wilson wrote:
I can never remember the umask number's effect without
experimentation
DESCRIPTION
umask sets the umask to mask 0777.
The umask is used by open(2) to set initial file permissions on a
newly-created file. Specifically, permissions in the umask are turned
off from
Cesar Rodas wrote:
while ( (n=fread(buff,Buffsize,1,file)) 0)
{
if (i0)
*value = realloc(*value, (i+1) * Buffsize);
memcpy(*value + (i * Buffsize), buff, Buffsize);
*len += n;
i++;
}
An afterthought, why don't you just stat the file and malloc
Matt Froncek wrote:
Martin,
Thank you for looking into this. The SQLite3.exe I tested with was 3.1.3.
And yes the SQL statement works fine as it. If you add one more nested OR to
the SQL statement then it stops working. I don't get a stack overflow like I
do in the ODBC driver I was testing
[EMAIL PROTECTED] wrote:
Guess you can't please everybody :-) Right now we have some
documentation in the source tree and some on the wiki, which
I suppose is guaranteed to please nobody.
So make the wiki available for download. ;)
Martin
Christian Smith wrote:
SQLite has been known to be problematic using NFS drives, mainly due
to flaky NFS locking implementations.
I'm not sure it's fair to say SQLite is problematic. It's susceptible
to NFS locking problems in certain situations, but so is any other app
which assumes that
fangles wrote:
PK? I'm sorry but I am not familiar with that term..
Sorry, in this example a Primary Key is a column (eg an integer) which
uniquely specifies a row in a table.
In the example above you:
select all columns from the rows which have a PK in the set
(
select the PK from
RB Smissaert wrote:
Is it possible with the date-time functions to get the month as a string, so
January etc. from the date in the format -mm-dd?
Doesn't look like it. Nothing in the wiki and I couldn't see anything in
the source either. I suppose you could use a big case statement if you
RB Smissaert wrote:
Yes, it looks it isn't there.
I guess it isn't really SQLite's place to know how to spell this month's
name in your locale. It's a presentation issue at the end of the day and
a lookup table is a nice easy solution.
to update the table and 25000 records takes about a
RB Smissaert wrote:
Analyzing the lookup table knocks the time down from 0.36 to 0.31 secs,
something I didn't expect.
That shows the importance of testing. I ported the SQLite benchmarks to
Python and was surprised to see some of the tests taking minutes to run
versus a few (or a few tens
fangles wrote:
I'm currently searching through all columns in a table to see if any match
the search text and the query is rather cumbersome. Is there a way to use a
loop to go through all available columns by some means? Maybe a loop by
querying the schema?
SELECT * FROM addresses WHERE title
fangles wrote:
I'm currently searching through all columns in a table to see if any match
the search text and the query is rather cumbersome. Is there a way to use a
loop to go through all available columns by some means? Maybe a loop by
querying the schema?
If you had a PK on that table and
Pavan wrote:
Should i create different tables for each user, so hat at any point
of time only one users data will be accessed ? Should i store all the
information in one table and then acess it ?
The word you want is normalisation and you could have a look at, say,
Pavan wrote:
The idea is that at any point of time user1 should not access user2
details and vice-versa.
SQLite doesn't have a concept of access control so if you want to stop
user1 from seeing user2's data then you'll either have to use a database
that does provide access control or , as
Dan Kennedy wrote:
On Thu, 2007-02-15 at 11:49 +0100, Pavan wrote:
Can anyone tell me what is the difference between sqlite and sqlite3.
Also:
SQLite - an embedded database library
sqlite3 - a shell to allow command line access to SQLite
Martin
Raised as ticket http://www.sqlite.org/cvstrac/tktview?tn=2232
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
[EMAIL PROTECTED] wrote:
Martin Jenkins [EMAIL PROTECTED] wrote:
Raised as ticket http://www.sqlite.org/cvstrac/tktview?tn=2232
Thanks. Bug reports are always welcomed.
But this problem was fixed yesterday. When you see problems in
SQLite, especially problems that have been discussed
[EMAIL PROTECTED] wrote:
I get the same problem on OS-X. But it appears to be a bug
in the older version of TCL you have installed, not in SQLite
itself. Nothing to worry about. Thanks for reporting it, though.
I was trying to make a test case to report the Tcl bug and noticed that
(in
Martin Jenkins wrote:
I haven't tested the other versions of Tcl yet.
I have now. s/a/RDRW/ makes corrupt2.test work with Tcl 8.4.9, 8.4.12,
8.4.14 and 8.5a5 on recent versions of Debian/Ubuntu on sparc64 and x86.
Martin
Build fails on Solaris 9/Ultra5/csw tools
Can't find 'ar' so substitutes and attempts to fun 'false'
TMP FIX: AR=gar ../configure...
corrupt2 tests fail on Solaris 9/Ultra5/csw tools
Test file is not actually corrupted (ie altered at all AFAICS)
Not sure how many people (outside of
Martin Jenkins wrote:
Build fails on Solaris 9/Ultra5/csw tools
Can't find 'ar' so substitutes and attempts to fun 'false'
TMP FIX: AR=gar ../configure...
Forgot - fdatasync is in librt so most of the executables need $(TLIBS)
added to the end of their recipe.
Martin
Martin Jenkins wrote:
corrupt2 tests fail on Solaris 9/Ultra5/csw tools
Test file is not actually corrupted (ie altered at all AFAICS)
Exact same failure on a fresh Debian 3.1r4 install too. All other tests
passed OK.
[EMAIL PROTECTED]:~/dev/sqlite/bld$ uname -a
Linux ultra5b 2.4.27-3
[EMAIL PROTECTED] wrote:
I get the same problem on OS-X. But it appears to be a bug
in the older version of TCL you have installed, not in SQLite
It's definitely a bug in Tcl. I'll post the log for posterity and get a
newer version.
[EMAIL PROTECTED]:~/dev/sqlite/bld$ echo Hello SQLite
[EMAIL PROTECTED] wrote:
in the older version of TCL you have installed, not in SQLite
Hmm. It's definitely a Tcl bug, but I'm not convinced about it being in
the older Tcl that I have - the SPARC machine that fails corrupt2.test
has a newer version than the PC that passes.
[later]
I
Jeffrey Rennie wrote:
Debugging the code:
winWrite returns SQLITE_FULL, which propagates back up the stack to
vdbeaux.c, line 1270, in function sqlite3VdbeHalt(Vdbe *p):
}else if( rc!=SQLITE_OK ){
p-rc = rc;
sqlite3RollbackAll(db);
Which is good, it's putting the
I've seen some longish SQL queries posted to this list but I was
wondering, how often do 1000+ line queries (as in the SQLite benchmark)
occur in the real world? Do queries of this sort of size exist outside
of initialising tables with a long lists of inserts?
Martin
[EMAIL PROTECTED] wrote:
In my (commercial) app I regularly have queries with over 1000 characters.
Not over 1000 lines though.
As VBA (not sure now about VB6) has a problem with
array elements having over 1823 characters I had
to truncate my SQL logging routine.
Under 2k? That seems a bit
1 - 100 of 210 matches
Mail list logo
