any database inconsistencies that
might have been introduced by this bug.
If you encounter any problems with this release, please send email to
sqlite-users@mailinglists.sqlite.org or directly to me. Thanks.
--
D. Richard Hipp
d...@sqlite.org
email to the SQLite users mailing list, or directly to me, if you
encounter any problems with this release.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite
details.
All users of SQLite versions 3.7.15 and 3.7.16 are encouraged to upgrade.
As always, please let me know if you encounter any problems with this or any
other release of SQLite.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing
SQLite Users mailing list (sqlite-users@sqlite.org) or
directly to me if you encounter any problems with this new release. Thanks.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi
the unusual SQL construct necessary to tickle this bug (and most
applications don't) then you are perfectly safe staying with whatever prior
version of SQLite you are currently using. Nevertheless, upgrading to 3.7.15.1
is recommended.
D. Richard Hipp
d...@
you encounter any 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
problems with this release.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
versions is recommended.
Additional information about this release can be found at:
http://www.sqlite.org/releaselog/3_7_9.html
http://www.sqlite.org/news.html
As always, please let me know if you encounter any difficulty with this release.
D. Richard Hipp
d...@sqlite.org
mailing list (sqlite-users@sqlite.org) if you
encounter any problems with this 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
ling list (sqlite-users@sqlite.org) or
directly to me if you encounter any problems. 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
On Apr 12, 2011, at 8:49 AM, D. Richard Hipp wrote:
> SQLite version 3.7.6 is not available from the website:
> http://www.sqlite.org/
The "not" in the sentence above should be "now", of course. Sorry for the typo.
>
> Version 3.7.6 is a regularly schedule
can be seen at
http://www.sqlite.org/releaselog/3_7_6.html
Please send email to the sqlite-users@sqlite.org mailing list, or directly to
me, if you encounter any problems. Thanks.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
the
possibility of database corruption, upgrading to version 3.7.0.1 is highly
recommended.
If you encounter any problems, please report them directly to me or to the
sqlite-users@sqlite.org mailing list.
D. Richard Hipp
d...@sqlite.org
___
sqlite
e let me know at once.
Thanks!
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
slip the release
again if necessary. Your beta testing is *very* important. 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
. 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
beta-testing SQLite 3.7.0 in your application!
Report any problems found on this mailing list.
You can download daily snapshots from http://www.sqlite.org/draft/download.html
and view updated documentation at http://www.sqlite.org/draft/index.html
Thanks.
D. Richard Hipp
d...@hwac
are currently aiming to release 3.7.0 sometime during July. Thank
you in advance for your help in testing this important new release.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
. 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
ble" I have checked under M$ debugger (not coverable
errors in my PHP/PDO-Sqlite script with parameters binding), but
possible other cases in massive switch statement, I think ...
greetings from Poland,
JureKL.
--- End forwarded message -
D. Richard Hipp
d...@hwaci.com
, code generator, and virtual machine from
SQLite in its Berkeley DB product. Additional information about
Berkeley DB's SQL API is available at
http://www.oracle.com/technology/products/berkeley-db/sql.html
D. Richard Hipp
d...@hwac
;%s,",argv[i]);
> strcat(DataBuffer,tstr);
> }
> strcat(DataBuffer,"\n");
>
> gettimeofday(&tpend,NULL);
> timeuse=100*(tpend.tv_sec-tpstart.tv_sec)+
> tpend.tv_usec-tpstart.tv_usec;
> timeuse/=100;
> printf("SQLCallBack Used Time:%f\n",
s 20th and 30th birthdays!
Thanks, everybody, for helping to make SQLite the most widely deployed
SQL database engine in the world. And Happy 10th Birthday to SQLite!
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@
in window’s eclipse environment
> with Sqlite-3.6.23.1.tar.gz file
> Thank you for giving many information. 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
On May 19, 2010, at 6:35 PM, Mike Frysinger wrote:
> On Wednesday 12 May 2010 11:43:13 D. Richard Hipp wrote:
>> If we drop support for (the non-standard, non-compliant) LinuxThreads
>> threading library and instead support only standard Posix threads
>> implemented using
If we drop support for (the non-standard, non-compliant) LinuxThreads
threading library and instead support only standard Posix threads
implemented using NPTL, beginning with SQLite release 3.7.0, what
disruptions might this cause?
Is anybody still using LinuxThreads?
D. Richard Hipp
d
breakage of older applications.
Question 1: Are there any objections to this approach?
Question 2: Are there other foibles that we could correct using
sqlite3_open_v3?
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users
gt;> __
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
> ___
> sqlite-use
e string size and 5 for the
string itself). A one-billion byte string requires one-billion-and-
five bytes of disk (5 bytes for the string size and one billion bytes
to hold the string itself.)
D. Richard Hipp
d...@hwaci.com
___
sqlite-users ma
_
> 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
for the report!
It is reassuring to know that the recent changes actually did some good!
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
---
> Assertions are politics; backing up assertions with evidence is
> science
> =
> ==
> ___
> 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
http://www.sqlite.org/src/info/f538d759be
Or, you can get a prebuilt amalgamation at
http://www.sqlite.org/sqlite3-20100415132938.zip
We are looking forward to your feedback, both positive and negative.
D. Richard Hipp
d...@hwaci.com
___
s
start my pc I have this error
> message as I am not a programmer I did not put SQL Lite on my
> machine for programming.
>
> Thanks in advance
>
> Femi Omomo
> Email: f...@planet4networks.com
> Website: www.planet4networks.com
> Tel: 01293 510051 UK
>
>
>
tion? Is there a
> way to
> recover the database?
>
> Alas, we had a misunderstanding w/ our web host on backup policy; he
> turns out to keep multiple versions of the current files, but no
> rollback...
>
> Thanks,
>
> Rutger Hofman
> VU Amsterdam
> http://www.rf
nce to do that. However I do have a channel to the
>> android db
>> developers, so I will forward this onto them, and hopefully they
>> can do
>> something with it.
>>
>> Thanks again for your help.
>>
>>
>>
>> D. Richard Hipp wrote:
>>
e of one database
and the second half of a different database.
The backup API is safer.
> Thanks,
> Josh
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
d...@hwaci.com
_
seem to be a bug? Is there other info that is needed?
>>
>> -- Kevin
>>
>>
>>
>> ___
>> 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
>
>
>
>
> ___
> 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
e to
> the new buffer.
http://www.sqlite.org/src/ci/937b931a7c
>
> Or, this problem is occurs by the line 741, it calculate the wrong
> number?
>
> On Fri, Apr 2, 2010 at 19:52, D. Richard Hipp wrote:
>
> On Apr 2, 2010, at 6:15 AM, Daniel Lin wrote:
>
> I've read
e is correct is stands.
To see why your change will cause a malfunction, all you have to do is
run the test suite.
Further discussion to sqlite-users@sqlite.org, please.
>
>
> On Fri, Apr 2, 2010 at 11:34, D. Richard Hipp wrote:
>
> On Apr 1, 2010, at 9:34 PM, Daniel Lin wrote
evelopers have searched and searched and yet we have no idea where in
the code that URL is generated.
>
> --
> mMerlin
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mail
gt; received this message in error, please advise the sender immediately
> by reply e-mail and delete this message. Thank you for your
> cooperation.
>
>
> ___________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sql
, please let me know.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
vide a means to determine the number of bytes of
underlying storage used for a value.
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 Mar 29, 2010, at 1:56 PM, Alexey Pechnikov wrote:
> Hello!
>
> On Monday 29 March 2010 20:22:36 D. Richard Hipp wrote:
>> SQLite version 1 used gdbm for storage. There were many problems
>> with
>> that approach: (1) gdbm is a hash-based system so it could not d
Neal Stephenson
> _______
> 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
which will allow you to position the database
engine on the server so that it can talk to the disk directly and
without a network hop.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi
lly created for the
specific purpose of rebuilding indices when the definition of a
collating function changed. That's why REINDEX will accept the name
of a collating function as its argument and only rebuild those indices
that use the named collating function.
D. Richard Hipp
d...@hwac
ble with BDB, even if you are using the SQLite front end on BDB.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
what Shane said, the corruption is probably just in the
page cache, not in the database file itself. So if you are able to
close and reopen the database connection when you run into problems,
that might provide a work-around (assuming we are guessing correctly
at the root cause of you
lite3_open16() interface is considered a mistake. It is
maintained for historical compatibility.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
atabase is stored on)?
>
> Thanks.
>
>
>
>
> ___
> 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
1 = tdbhandle.sqlite3_step(stmtHandle);
>
>return 0;
> }
>
>
> This step int err1 = tdbhandle.sqlite3_step(stmtHandle);
> in the code returns 5 (sqlite_busy) every time I run the program.
> (I don't have any multi threads in my program which can lock the db. )
>
> Any help on this is appreciated.
>
>
> Regards
> sudha
>
> ___
> 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
entations to suite the preferences
of individual readers.. And so the syntax diagrams will be all that
is available for the foreseeable future. I apologize for whatever
inconvenience this may cause you.
D. Richard Hipp
d...@hwaci.com
___
sqlite-u
e sqlite3.c
on Linux. Then move the files sqlite3.c and sqlite3.h over to windows
and compile them there together with -DSQLITE_ENABLE_RTREE.
>
> How can I use sqlite3 in windows eclipse environment..?
> I have to use eclipse in windows.
> I really thank for you it you teach me How to u
(unsigned char*)&pKeyInfo-
> >aColl[nField];
> memcpy(pKeyInfo->aSortOrder, aSortOrder, nField);
> }
> pOp->p4type = P4_KEYINFO;
>
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: Alexis Colon
> Date: March 21, 2010 1:00:18 AM EDT
> To: d...@hwaci.com
> Subject: Sqlite User
>
> Hello.
>
> please help
> how many user at the same time ken use sqlite
>
> thanks the any help
e
sqlite3_bind_x() and sqlite3_bind_parameter_index() calls.
If we've learned one thing over the history of computing it is that
programmers are notoriously bad at counting parameters and that
symbolic names tend to be much better at avoiding bugs.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
though once the VACUUM succeeds the resulting DB is only 50 MB.
>
> Any tips are appreciated. Thanks!
PRAGMA journal_mode=OFF;
Be warned, though, that if you session crashes or you lose power, your
database will go corrupt if there is no jou
currently sorted, but that might change in
a subsequent release.
>
> Thanks.
>
> - Nasron
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-user
lumns in the database?
http://www.sqlite.org/lockingv3.html#how_to_corrupt
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 Mar 11, 2010, at 11:42 AM, Skand wrote:
>
>
> D. Richard Hipp wrote:
>>
>>
>> On Mar 11, 2010, at 11:13 AM, Skand wrote:
>>
>>
>>>
>>> sqlite> select count(*) from ip_domain_table where ttl <
>>> 99 ;
>>
oes-not-delete-everything--tp27865654p27865654.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> ___
> 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
st to the SQLite mailing list.
My suggested solution is simple: Get a Mac.
>
> Regards
> Mona
> --Original Message--
> From: D. Richard Hipp
> To: Mona Alshaikh
> Cc: General Discussion of SQLite Database
> Subject: Re: SQLITE
> Sent: Mar 11, 2010 4:39 PM
>
>
r th
e problem.
>
> regards
>
> --
> Mona Ahmed Al Shaikh, MBA
>
> Assistant Vice President - Asset Management
>
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
full configure and make output as an attachment.
>
> Your help would be appreciated.
>
> Mel
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hip
problem until recently when we were adding some
tests that make use of SQLITE_OMIT_DATETIME_FUNCS.
>
>
> Regards ,
>
> Israel Lins Albuquerque
> Developer
> Polibrás Brasil Software Ltda.
>
>
> ____________
content of the original table into
the new table, and (4) drop the original table.
> Best regards,
> Roberto Luca
> -- http://www.dbschema.com
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqli
r "java sqlite" or "jdbc sqlite" to get a list.
>
> Many thanks.
>
> //F.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ult is not
> right.
>Further more, when i debug fts3 with sql --
> 1."select * from virtual_table where a = ''1' and b ='2'"
> 2."select * from virtual_table where a = ''1' or b ='2'"
> i can not
e, Firefox, Chrome, and Mcafee Antivirus, as well as countless
others.
One or more of these other programs is leaving the SQLite files on
your computer.
SQLite is not a program or application. It is not a virus.
D. Richard Hipp
d...@hwaci.com
___
sq
On Mar 9, 2010, at 5:07 PM, Roger Binns wrote:
> D. Richard Hipp wrote:
>> SQLite version 3.6.23 is now available from the SQLite website:
>> http://www.sqlite.org/
>
> The download page no longer mentions any version of SQLite:
>
> http://www.sqlite.org/download
On Mar 9, 2010, at 4:40 PM, Terence Martin wrote:
> On Tue, 9 Mar 2010 16:00:27 -0500
> "D. Richard Hipp" wrote:
>
>> SQLite version 3.6.23 is now available from the SQLite website:
>> http://www.sqlite.org/
>>
>>
>> As always, please let me kn
cycle of SQLite, in order to
mitigate the perception of excessive "code churn".
As always, please let me know if you find any problems in the new
release.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlit
On Mar 4, 2010, at 4:30 PM, Brian Dantes wrote:
> D. Richard Hipp wrote:
>
>> It is OK for different processes to use different
>> temp_store_directory
>
>> settings. The temp_store_directory is only used for TEMP tables. It
>
>> does not play a roll in
lite.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
ble access to the CVSTrac wiki at
http://www.sqlite.org/cvstrac/wiki
D. Richard Hipp
d...@hwaci.com
___
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...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
epending on how many prepared
statements you are holding at once and how complex your schema is.
>
>
> Robert Read
>
> Lead Software Engineer
>
> Saltillo Corporation
>
>
>
>
>
> ___
> sqlite-users mailing list
>
On Feb 24, 2010, at 5:45 PM, Igor Tandetnik wrote:
> D. Richard Hipp wrote:
>> This problem has existed in SQLite forever and has never been seen
>> before. So it is obscure. The simple fix is to put the ON clause on
>> the CROSS JOIN where it belongs.
>
> Does CR
is
>>> example.
>>>
>>> Tom
>>
>> They do affect the EXPLAIN QUERY PLAN results:
>>
>> "="
>> order from detail
>> 0 0 TABLE currency AS c1
>> 1 1 TABLE currency AS c2 WITH INDEX sqlite_autoindex_currency_1
>> 2 2 TABLE e
cate the code in order to work around bugs in LLVM.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
7;ve fixed both of those errors in the patch below:
>>
>> /* Step 1c */
>> - if( z[0]=='y' && hasVowel(z+1) ){
>> + if( z[0]=='y' && isConsonant(z+1) && z[2] ){
>>z[0] = 'i';
>> }
>>
>> ___
>> 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...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
t; Your help in this matter is very much appreciated.
>
> Kind regards,
>
> Mark Asken
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
The error message text "unable to resolve operation" occurs nowhere in
the SQLite source code. And nobody else is able to reproduce this
problem. So it seems likely to us that you are using adulterate
source code. Please try again with fresh, unaltered SQLite source
fil
ine when I try it. Are you using the sqlite3.exe from the
SQLite website or another third-party shell? Might your third-party
shell be playing games with the string somehow?
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-us
org/src/info/a39007d5b1
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
0.0
> 41264890346700test20.0-120.00.045.00.0
>
> ---
> I have tried lon= varchar(45) and also as a FLOAT, and both don't seem
> to handle negative numbers correctly.
FLOAT should work. Are you sure you tried it correctly?
> Any help
uld be useful, but they are the exception
rather than the rule.) On the other hand, SQLite still has to
maintain the index on INSERT, UPDATE, and DELETE operations which will
slow those operations down.
D. Richard Hipp
d...@hwaci.com
___
sqlite-us
On Jan 29, 2010, at 6:15 AM, Max Vlasov wrote:
> To be sure that there's no
> full or almost-full table scan I use VFS monitoring in such cases.
The sqlite3_stmt_status() interface was designed for this purpose.
http://www.sqlite.org/c3ref/stmt_status.html
D. Richard Hipp
d..
> but none of my attempts to investigate this have been fruitful.
SQLite doesn't really do a parse tree so much. It does a little.
Sometimes. But its style of operation is closer to "syntax directed
translation", especially for the CREATE TABLE statement.
D. Richard Hipp
d...
t; mapped
> it to the default nocase collation.
> ___
> 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
bug appears to be harmless
(correct code is generated in spite of the warning). So you should
simply ignore it.
>
> Thanks,
> Daniel.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:80
re only available on the primary server. But
hopefully Linode will have the problem resolved soon.
A second backup server is provided by a different hosting service
(Hurricane Electric) but hopefully that 2nd backup will not be
necessary
D. Richard Hi
aq.html#q25 and
http://www.sqlite.org/search?q=syntax+diagrams
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 Jan 14, 2010, at 7:44 AM, D. Richard Hipp wrote:
>
> On Jan 14, 2010, at 12:06 AM, Jamie Hardt wrote:
>>
>> So, has anyone else run into SQLITE_CANTOPEN in a situation where
>> it wasn't a permissions issue?
>>
>
>
> My guess would be tha
ts inside a single big 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
the A03, A06 at the end of the list?
SELECT * FROM mytable
ORDER BY CASE WHEN point_number GLOB '*[^0-9.]*' THEN point_number
ELSE cast(point_number AS real) END;
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sq
roblem was indeed that I reached the maximum number of fds.
>> Thanks
>> for the help!
>
> If SQLite had reported the errno value from the failed system call,
> the cause would have been obvious and this entire investigation would
> have been unnecessary.
sqlite3
On Jan 11, 2010, at 9:28 PM, ve3meo wrote:
> Oddly enough, by revising the query to explicitly
> use an index, the two later releases are much faster...
Did you run ANALYZE before you tried using explicit indices?
D. Richard Hipp
d...@hwa
1 - 100 of 1805 matches
Mail list logo