On Jan 6, 2010, at 7:47 PM, Wilson, Ronald wrote:
> Does check-in [077a6bee2d] resolve the issue below?
>
> http://www.sqlite.org/src/vinfo/077a6bee2d
>
Yes. I didn't realize the issue had a ticket. I'll close it.
D. Richard Hipp
d.
tep() to loop, but you have to
run sqlite3_reset() in between each sqlite3_step() attempt.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
, please let us know if you encounter any difficulties with
the new release.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ply adds the capability to optionally encrypt/decrypt
the database as it is written/read. So replacing the PHP SQLite DLL
with an SEE DLL will not break legacy code - it simply gives you a few
extra pragmas that allow you to turn encryptio
See http://www.sqlite.org/src/info/f74beaabde
> _______
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Begin forwarded message:
> From: "Dr. Robert N. Cleaves" <b...@wildcon.org>
> Date: December 24, 2009 6:26:23 PM EST
> To: "'D. Richard Hipp'" <d...@hwaci.com>
> Subject: RE: sqlite3_prepare_v2
>
> Thank you very much for your help. The pro
PAMfighter.
> We are a community of 6 million users fighting spam.
> SPAMfighter has removed 37 of my spam emails to date.
> The Professional version does not have this message.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-user
else{
A->name = B;
}
}
>
> --
> Regards,
> Benjamin
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
d...@hwaci.com
__
this is not
> an
> option.
>
> Thanks,
> Chris
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
d...@hwaci.com
___
sqli
On Dec 19, 2009, at 3:12 PM, Igor Tandetnik wrote:
>
> To find all strings beginning with 'a', consider using something
> like this:
>
> SELECT * FROM mytable WHERE mycolumn2 >= 'a' and mycolumn2 < 'b';
Or: SELECT * FROM mytable WHERE mycolumn2 GLOB 'a*';
D. Richar
elements in sorted order to begin with and no
sorting will occur.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
eing used? Get a copy from the Download
page on the SQLite website.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ng;");
sqlite3_complete("CREATE TRIGGER unfinished_trigger");
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Dec 16, 2009, at 11:15 AM, D. Richard Hipp wrote:
>
> On Dec 16, 2009, at 11:12 AM, Nick Hodapp wrote:
>
>> I wrote a custom tokenizer for fts3, and I intend it to be used
>> when I
>> populate my database.
>>
>> I'd rather not ship the tokenizer in my
name in my read-only
> application, would that work?
The tokenizer is needed for both reading and writing. It is needing
to parse the LHS of the MATCH operator when reading.
You *must* register exactly the same tokenizer when reading as you
used for writing or your queries w
the value, no ? AH, GOT IT. values do NOT have affinity. so I would
> either need to cast the expression OR the value.
Yes.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
n can be found at http://www.sqlite.org/
privatebranch.html and there is an updated version of that document
at http://www.sqlite.org/draft/privatebranch.html that I prepared in
response to this very issue and which will be in the next official
release of SQLite.
D. Richa
id=t1.id)
> as integer)= '2';
> 2
>
Because string '2' is not the same thing as integer 2.
sqlite3> select 2='2';
0
sqlite3>
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Dec 8, 2009, at 9:51 AM, Andreas Schwab wrote:
> "D. Richard Hipp" <d...@hwaci.com> writes:
>
>> On Dec 7, 2009, at 8:41 PM, Andreas Schwab wrote:
>>
>>> D. Richard Hipp writes:
>>>
>>>> As always, please let us know if you enco
On Dec 7, 2009, at 8:41 PM, Andreas Schwab wrote:
> D. Richard Hipp writes:
>
>> As always, please let us know if you encounter any difficulties with
>> this or any other SQLite release.
>
> It's still crashing due to undefined behaviour.
>
> $ ./sqlite3 :memo
3.6.21, as all versions of SQLite since 3.6.17, has
been tested to 100% MC/DC and branch coverage using multiple
independently developed test harnesses.
As always, please let us know if you encounter any difficulties with
this or any other SQLite release.
D. Richard Hipp
d...@hwaci.com
savepoint.html
"When a SAVEPOINT is the outer-most savepoint and it is not within a
BEGIN...COMMIT then the behavior is the same as BEGIN DEFERRED
TRANSACTION."
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
Last minute comments on the pending release of SQLite 3.6.21 are
welcomed. Visit
http://www.sqlite.org/draft/index.html
http://www.sqlite.org/draft/releaselog/3_6_21.html
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
gt;
That diagram is the syntax for a single constraint. You can have
multiple constraints per column. (See
http://www.sqlite.org/syntaxdiagrams.html#column-def)
The PRIMARY KEY is one constraint and NOT NULL is another
constraint. The two can occur together and in any order.
D. Richard H
sting and maintaining
SQLITE_OMIT_SUBQUERY is pretty low on our list of priorities. I'm
sorry to disappoint, but the fact is that we do have to prioritize
things. The SQLite developers do not have any idle cycles at the
moment.
D. Richard Hipp
d...@hwaci.com
___
fixed for 3.6.21.
>
> Ralf
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@s
e data
> is not reflected in the table after the update statement is
> complete. I
> didn't look at the vdbe.
> anyone seen this behavior?
>
> thanks
> ___
> sqlite-users mailing list
> sqlite-
roduce this with 3.6.20 or 3.6.18 (see below). Do you
>>> have a C program you can post that demonstrates the problem?
>>>
>>> Dan.
>>>
>>>
>>>
>>> ~/sqlite/tipbld$ ./sqlite3
>>> SQLite version 3.6.20
>>> Enter ".help" for instructions
&
questions on how to compile and use CEROD,
please use the same email address that you used to enter into the NDA
in the first place. Thank you.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
n see that they behave differently with 3.6.7 doing the right
> thing.
> I did not find any mentioning of that here
> http://www.sqlite.org/changes.html
> If that is a bug, it *is* a major one!
>
> --
> Dmitri Priimak
>
> ___________
>
LLOW, not for this reason, but to prevent an attack
using symbolic links that could allow an unprivileged user to trick
SQLite into deleting a file that the unprivileged user does not have
access rights for.
D. Richard Hipp
d...@hwaci.com
___
sqli
On Nov 17, 2009, at 9:49 PM, D. Richard Hipp wrote:
>
> On Nov 17, 2009, at 9:45 PM, Vasu Nori wrote:
>>
>> sqlite> SELECT _id, typeof(_id) FROM feeds;
>> 1|integer
>> 2|integer
>> 3|integer
>> 4|integer
>> 5|integer
>> 6|integer
>>
On Nov 17, 2009, at 8:09 PM, Vasu Nori wrote:
>
> but can't select the row _id = 0
What does the following query show:
SELECT _id, typeof(_id) FROM feeds;
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqli
'ynVar' to
> 'int', possible loss of data
> .\sqlite3.c(87841) : warning C4244: '=' : conversion from 'ynVar' to
> 'int', possible loss of data
>
>
> ___________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8
the other hand, do
store the original SQL text and can re-prepare and so they can
optimize for parameters on the RHS of a LIKE.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ng LIKE it should always continue using LIKE.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
www.sqlite.org/docsrc/vinfo/a802dbe3fbf6d0979de534d400910211b854b978
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Database <sqlite-users@sqlite.org>
> Subject: Re: [sqlite] Fwd: failing attempts at sending "Feature
> request: PRAGMA maximum_file_format"
>
>
> On Thu, 2009-11-12 at 13:37 -0500, D. Richard Hipp wrote:
>> On Nov 12, 2009, at 1:30 PM, D. Richard Hipp wrote:
>
On Nov 12, 2009, at 1:30 PM, D. Richard Hipp wrote:
>>
>> To write more future-proof code I would like to have something like
>> PRAGMA default_file_format or PRAGMA maximum_file_format that lets me
>> explicitly specify the highest file format version SQLite will use
en the
> requested default_file_format is higher than the highest supported
> version. It may be reasonable to handle this as equivalent to PRAGMA
> legacy_file_format=0 instead of treating it as an error.)
>
> Does this sound like something worth adding? If it does I could try
On Nov 11, 2009, at 11:24 AM, Jens Miltner wrote:
>
> Is sqlite3_analyzer supposed to work in 3.6.19?
>
No. sqlite3_analyzer has been busted for a long time. But the 3.6.0
version of sqlite3_analyzer works just fine, even on databases created
using 3.6.19.
D. Richard Hipp
d...@
source SQLite tree is TCL script.
We're comfortable having mixed Tcl/SQLite questions here.
http://www.sqlite.org/docsrc/artifact/07b4fa3fd6
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bi
h
> stack space, bad things happen and it's usually very difficult to
> debug.
Have you actually measured how much stack space SQLite is using (even
with
SQLITE_USE_ALLOCA)? Is excess stack space usage really a problem?
D. Richard Hipp
d...@hwaci.com
_
gt; database, seems to have no effect. If I run "sqlite3 -batch
> existing.db < create_tables.sql", no tables are actually created.
>
> This seems to be a major change. Does -batch serve any purpose any
> longer?
D. Richard Hipp
d...@hwaci.com
___
SELECT sqlite_version();
SELECT sqlite_source_id();
Thanks!
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
from test1 natural join test1;
> 100
Try that again using 3.6.20.
That problem was fixed by http://www.sqlite.org/src/vinfo/
6fe63711754on 2009-10-19.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http:
eed to go? If it is absolutely critical that you find your
answer in nanoseconds, then by all means use C code. But if you are
operating on human timescales (tens or hundreds of milliseconds) then
SQLite will be fast enough and, depending on what you are trying to
accomplish, might be less error
e happy to look into it for you. But we
have no capability of helping you with your ARM problems.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
n ?
> separaring the blogs into another table and let small columns on
> main table ?
Separating the mail body BLOBs into a separate table would help too.
But the index above will help the most, I suspect.
D. Richard Hipp
d...@hwaci.com
___
/books.html
Version 3.6.20 is considered stable and ready for production use.
As always, please let us know if you encounter any problems.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi
> Customing it.
>
> thank you very much .
>
>
> yours
> : kanghui
>
>
>
> 09年新晋3D主流网游《天下贰》,网易六年亿资打造
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
, especially
with GCC. There are some options to GCC (which escape my memory right
now) that can force it to use strict IEEE 754 floating point rather
than its preferred, speedier but non-standard alternative.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Nov 3, 2009, at 9:34 AM, Edward Diener wrote:
> Is it possible to retrieve an older version of sqlite from the web
> site
> rather than the latest version ?
http://www.sqlite.org/download.html#cvs
D. Richard Hipp
d...@hwaci.com
_
IGNORE" in the insert statements, either.
>
> Cheers,
>
> Mick O'Neill
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
d...@hwaci.com
__
rong here. That said I'd much
> rather
> the behaviour of sqlite changed to match the docs rather than vice-
> versa
> because I really want to write neat queries like:
>
> select col1 is col2 from table
>
See the second bullet on http://www.sqlite.org/releaselog/3_6_19.html
rt a row, having the value "STATUS" on
> that TEXT column; Then try to select the row by using WHERE myColumn
> = "STATUS". It does not work for me.
>
> Could you please tell me whether this is a bug or I am just using it
On Oct 26, 2009, at 6:16 PM, D. Richard Hipp wrote:
>
> The memory management has undergone multiple rewrites in the previous
> two years, but as far as we know, sqlite3_release_memory() still works
> as advertised. Please let us know if you find otherwise.
FWIW, with the latest ch
On Oct 26, 2009, at 5:53 PM, Peter Kasting wrote:
> On Mon, Oct 26, 2009 at 2:48 PM, D. Richard Hipp <d...@hwaci.com>
> wrote:
>
>> On Oct 26, 2009, at 5:00 PM, Peter Kasting wrote:
>>> as
>>> far as
>>> I can tell the current code sho
her than
> SQLITE_ENABLE_COLUMN_METADATA?
>
> Is there anything I might have overlooked??
>
> Any ideas??
>
> Thanks in advance,
> Rob Sciuk
> ___
> sqlite-users mailing list
&
gt; Thanks,
> PK
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Oct 24, 2009, at 11:40 AM, D. Richard Hipp wrote:
>
>
> Begin forwarded message:
>
>> From: John Mason <fasteddi...@sbcglobal.net>
>> Date: October 24, 2009 11:12:26 AM EDT
>> To: d...@hwaci.com
>> Subject: error message
>>
>> I have
On Oct 24, 2009, at 11:40 AM, D. Richard Hipp wrote:
>
>
> Begin forwarded message:
>
>> From: John Mason <fasteddi...@sbcglobal.net>
>> Date: October 24, 2009 11:12:26 AM EDT
>> To: d...@hwaci.com
>> Subject: error message
>>
>> I have
tting the following message:
>
> The proceedure entry point sqlite3_prepare_v2 could not be located
> in the dynamic link library SQLite3.dll
>
> How can I fix and what do I need to do?
>
> I am about to upgrade to Windows 7
>
> Thank you.
> John
y on being able to access that value in my TRIGGER as
> NEW.columnName ?
AFTER triggers only. With BEFORE triggers, the NEW.columnName value
might not have been generated yet.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-use
KEY, never a raw ROWID, for anything that you want
to persist for longer than the current transaction.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
until I get around to approving them
before they can send emails to this list.
Are there other suggestions on how to limit or curtail the kind of
mailing list abuse practiced by Talend?
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
allow/deny acces?
I believe Adobe AIR has built-in support for SQLite database
encryption. Check your documentation.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
and thousands of test cases to verify that
partial writes do not corrupt the database file.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
rocess(), is it the case that the write might not actually occur?
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
erage). We consider this release to be production ready.
Nevertheless, testing can only prove the presence of bugs, not their
absence. So if you encounter problems, please let us know.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sql
> done boolean default 'f'
> );
> INSERT INTO todo (title) VALUES ('Learn web.py');
> I tried this under both 3.6.6.2 on Linux, and 3.6.10 on Mac OS X.
http://www.sqlite.org/src/info/2d401a
Fixed in 3.6.18
D. Richard Hipp
d...@hwaci.com
___
On Oct 13, 2009, at 3:17 PM, Keith Roberts wrote:
> On Tue, 13 Oct 2009, D. Richard Hipp wrote:
>
>> To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
>> From: D. Richard Hipp <d...@hwaci.com>
>> Subject: Re: [sqlite] Bug in date() function ?
> has 31 days added to it. Which is correct.
>
> When I subtract '-1 month' the date only gets 28 days
> subtracted from it.
>
> Surely adding or subtracting a month modifier to a date
> should be the same number of days in each direction?
>
D. Richard Hipp
d...@hwaci.
c, windows, on x86
and x86_64) then we may well take you up on your offer to debug on
HPUX/pa-risc. But at this time, that would not be useful. Thanks.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
cceptable.
>
> Please let me know if we can have some hope that this feature will
> be added in a future update.
This is very unlikely to be added.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http:
FROM parent;
> SELECT * FROM child;
>
> Actual result:
> 0
> 7
>
> Expected result:
> SQL error near line 6: constraint failed
> SQL error near line 7: constraint failed
> 1
> 1
>
> I suggest the fix attached to this mail.
>
> Regards,
> Thomas.
> _
used
> Page 439 is never used
> Page 458 is never used
> Page 469 is never used
> Page 483 is never used
> Page 500 is never used
> Page 502 is never used
> Page 505 is never used
> Page 508 is never used
> Page 510 is never used
> Page 512 is never used
> Page 535
ou should not need to modify the source code. See:
http://www.sqlite.org/compile.html#default_cache_size
http://www.sqlite.org/compile.html#default_page_size
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ing hundreds or thousands of updates without
BEGIN...COMMIT and you haven't already complained about the speed,
this suggests that your database is running asynchronously (i.e. with
PRAGMA synchronous=OFF or on a system that does not support fsync() or
the equiva
ually remove the duplication entries, then
reconstruct the database file from the dump, you should recover all
information.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
he only documentation is comments in the code.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
. That seems to be what happened here.
If you see a redundant message, simply ignore it.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ch needs the
> ITunes to work. And as this belongs to Apple, I think this might be
> the affected program, not withstanding it works. Besides I have a
> Nokia Cell, which I don't know if for connecting it to the CP might
> need the missing element.
D. Richard Hipp
d...@hwaci.com
QfAu
> nXkAnRqqCi4MNIllFSuoW0F9FwIz/8Hi
> =gmns
> -END PGP SIGNATURE-
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
d...@hwaci.com
_
lt;"
Complains about this constant: (((sqlite3_int64)1)<<63) Harmless
All warnings are harmless and will remain unaddressed for now. Thanks
for the reports, though!
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
even evaluate the warnings to
determine whether or not they are bugs because you haven't told us
what version of SQLite you are attempting to compile so the line
numbers are meaningless. (In a 100,000-line source file, line numbers
shift drastically from day to day.) We want to know the v
(for all countries that
> recognize that concept).
>
> Rich
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
d...@hwaci.com
e.com/SQLite-Suitability-for-Shopping-Cart-tp25530589p25615724.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlit
But even if you don't
do this, the cache size should be 2000 pages which is only about 64MB
for each attached database.
What does sqlite3_mem_used() and sqlite3_mem_highwater() tell you
about SQLite's memory usage? Are you sure that it is SQLite and not
your perl script that is u
the
database is not too badly fragmented, it will usually succeed.
When autovacuum=OFF, then pointer map pages are not availble and
SQLite is compelled to read all prior pages when seeking to the end of
an overflow chain.
D. Richard Hipp
d...@hwaci.com
__
of later pages without having to read earlier pages. SQLite
never reads pages that follow what is needed.
Once the necessary pages are in memory, SQLite only looks at the
specific parts of a row that are requested. Unrequested columns are
never extracted or decoded from the raw row data.
D
SQLite version 3.x.x series
in January 2006. Version 2.8.17 is from December 2005. Development
on the 2.x.x series ended at that point. There will be no further
enhancements to 2.8.17.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
ON UPDATE SET
NULL? Has anybody ever actually seen ON UPDATE SET NULL used in
practice?
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
" - you are comparing strings or floating-point numbers and the
answer you are getting is correct for strings and/or numbers.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
e2.dateitem2:
SELECT ... FROM table1 AS t1 LEFT JOIN table2 AS t2
WHERE t2.dateitem2 BETWEEN datetime(t1.dateitem1, '-10 minutes') AND
datetime(t1.dateitem1,'+10 minutes');
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-user
held belief that since OSes provide byte-level locking of files
it should be a simple matter to provide row-level locking in a
serverless database engine. The proposed paper will explain why that
belief is incorrect.
D. Richard Hipp
d...@hwaci.com
___
t; or
>
> SELECT date((select date from reports where reportid='123456') ,
> 'start of month','+1 month','-1 day')
>
>
Is the content of the "date" field either a julian day number or an
ISO-8601 format date string?
D. Richard Hipp
d...@hwaci.com
___
is strictly prohibited.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ntil 2.0 seconds have elapsed, then it should give up and report an
error. My first guess would be that usleep() is not working quite
right on your system.
What OS are you running? What compiler?
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ind out what platforms are tested. In particular do you
> test on
> · Solaris with the Sum compiler?
> · SCO OpenServer with its native compiler?
>
We test on linux (x86, amd64), mac (x86), win32, win64, and wince.
D. Richard Hipp
d...@hwaci.com
101 - 200 of 1539 matches
Mail list logo