On Mon, 2005-08-22 at 16:54 -0600, Dennis Cote wrote:
> select *
> from MyTable
> join (select random(*) as number) as rand
> where start_col >= rand.number
> and end_col < rand.number;
>
Very nice. Dennis Cote wins todays prize for
cleverest use (abuse?) of a join!
--
to write,
easier to maintain, has fewer bugs, and just works better.
--
D. Richard Hipp <[EMAIL PROTECTED]>
e that caused the assert if posssible.
Or better, provide a short SQL script that causes the assert to fail
when run from the command-line client.
We'll try to get to it...
--
D. Richard Hipp <[EMAIL PROTECTED]>
prevent data loss after a power failure. So this
is not a real high priority.
--
D. Richard Hipp <[EMAIL PROTECTED]>
ittle slower to commit, but it is also safer in
the face of power failures. In spite of this handicap,
SQLite version 3 still manages to be faster than version 2
in many tests.
--
D. Richard Hipp <[EMAIL PROTECTED]>
I just ran a speed comparison between version 2.8.16 and 3.2.3.
Version 3.2.3 is faster in almost every case. See
http://www.sqlite.org/speed-2816-v-323.html
--
D. Richard Hipp <[EMAIL PROTECTED]>
supports variable-length records with automatic
compaction and defragmentation. Records are subject to
being moved about on the disk after any change to nearby
records.
--
D. Richard Hipp <[EMAIL PROTECTED]>
Version 3.2.3 contained a memory allocation bug which could cause
a segfault when complex WHERE clauses are parsed. The problem is
fixed in version 3.2.4 which is now available on the website.
--
D. Richard Hipp <[EMAIL PROTECTED]>
);
>
It works fine when I try it. Please send me your database
if you can. Use ".dump" to convert to text, then compress
the text and send private email to [EMAIL PROTECTED]
--
D. Richard Hipp <[EMAIL PROTECTED]>
I see the problem. I'm working on the fix now. This will
result in 3.2.5, eventually.
The bug has been in the code for 2 months. Apparently nobody
tests out of CVS. :-(
--
D. Richard Hipp <[EMAIL PROTECTED]>
3.2.5 will be forthcoming.
But I'm going to wait a few days for other bugs to emerge
before I do the next release. I would very much appreciate
it if as many people as possible will try out version 3.2.4
over the next few days and report any problems you run
across.
--
D. Richard Hipp <[EM
o imagine what might have broken...
--
D. Richard Hipp <[EMAIL PROTECTED]>
iew?cn=2366
--
D. Richard Hipp <[EMAIL PROTECTED]>
u find a specific problem with the 3.2.4 Makefiles, I'll be
happy to look at it. But from what I've seen so far, this looks
like a problem in your environment, not in SQLite.
--
D. Richard Hipp <[EMAIL PROTECTED]>
SD make.
>
OK. The line above was in a patch someone sent in for ticket
#1292: http://www.sqlite.org/cvstrac/tktview?tn=1292.
Can someone who understands make and configure perhaps suggest a
fix for this so that it will work on OpenBSD and Mac OS-X at the
same time?
--
D. Richard Hipp <[EMAIL PROTECTED]>
interface does not take advantage of the new features of sqlite
> version 3 with the integers and doubles, as it convert everything to one
> string. Are there any plans to change it?
>
What version are you looking at? The latest Tcl bindings already
do this.
--
D. Richard Hipp <[EMAIL PROTECTED]>
ct
the key.
The usual defense against this attack (and the one used by SQLite)
is to discard the first 1000 bytes or so of information coming out
of the PRNG. No key information leaks into later bytes of the
PRNG stream (at least as far as we know) so this secures the cypher
from attack.
--
D. Richard Hipp <[EMAIL PROTECTED]>
s just do a better job of it.
--
D. Richard Hipp <[EMAIL PROTECTED]>
own.
So I'm not overly worried when I see round(9.95,1) come out
with 9.9. But I am concerned about the people who are seeing
results like ":.0". I wish I could reproduce that problem.
--
D. Richard Hipp <[EMAIL PROTECTED]>
0 && exp<=350 ){ realvalue *= 0.1; exp++; }
>
Thanks. This is the problem and it is being fixed now.
--
D. Richard Hipp <[EMAIL PROTECTED]>
sqlite.org/cvstrac/tktview?tn=1272
http://www.sqlite.org/cvstrac/chngview?cn=2521
--
D. Richard Hipp <[EMAIL PROTECTED]>
1|1|zzz
> 1|2|xxx
> 1|3|yyy
>
Fix is at http://www.sqlite.org/cvstrac/chngview/cn=2655.
--
D. Richard Hipp <[EMAIL PROTECTED]>
INTO t1 SELECT * FROM t1;
SELECT a, b, sum(c) FROM t1 GROUP BY a, b ORDER BY 3;
Thanks.
--
D. Richard Hipp <[EMAIL PROTECTED]>
Thanks everybody!
All the results so far seem to be in agreement with each
other and with the current behavior of SQLite. So I think
everything is good. Thx for the help.
--
D. Richard Hipp <[EMAIL PROTECTED]>
On Fri, 2005-09-02 at 11:59 +0200, Michael Schoen wrote:
> (1) Multiple Insert Statements
> We need to insert around 300-500 datasets/sec constantly (24/7) with 8
> till 16 fields indexed. So far we are using mysql, not only due to the
> general dbms speed, but mainly because it has a csv
arate handle for
each thread.
--
D. Richard Hipp <[EMAIL PROTECTED]>
the lastest version of SQLite and if circumstances
are just right, LIKE will use an index.
See http://www.sqlite.org/optoverview.html#like_opt
--
D. Richard Hipp <[EMAIL PROTECTED]>
d are now
detected sooner rather than later.
--
D. Richard Hipp <[EMAIL PROTECTED]>
uires the locks immediately and would thus cause the
EBUSY error when thread2 did its BEGIN. This simplifies
recovery at the price of some concurrency.
--
D. Richard Hipp <[EMAIL PROTECTED]>
/cvstrac/tktview?tn=1272 and
http://www.sqlite.org/cvstrac/tktview?tn=1285.
--
D. Richard Hipp <[EMAIL PROTECTED]>
ing DB handles in multiple threads is
a problem.
--
D. Richard Hipp <[EMAIL PROTECTED]>
Can somebody with access to Win95/98/ME please test
check-in [2656] for me to make sure it didn't break
anything?
http://www.sqlite.org/cvstrac/chngview?cn=2656
--
D. Richard Hipp <[EMAIL PROTECTED]>
l
end up doing unless somebody can suggest a good reason not
to.
--
D. Richard Hipp <[EMAIL PROTECTED]>
in step 2 will acquire a read-lock on the
database file which will insure that no other process modifies the file
during step 3. But it is also only a read-lock so other processes can
continue to read the database while you are copying it. Step 4 releases
the file lock.
--
D. Richard Hipp <[EMAIL PROTECTED]>
ve assumes that ROWIDs are consecutive, which may or may
not be the case. (Probably it is not the case.) To get the last 10
rows, I would suggest this:
SELECT * FROM mytable ORDER BY rowid DESC limit 10;
That will work as long as the optimizer doesn't try to use an index
to satisfy terms of your WHERE clause.
--
D. Richard Hipp <[EMAIL PROTECTED]>
SQLite uses 64-bit signed integers (8 bytes).
--
D. Richard Hipp <[EMAIL PROTECTED]>
b) FROM TEST;
>
AVG is implemented as SUM/COUNT. But the count is zero. So
you get a NULL.
--
D. Richard Hipp <[EMAIL PROTECTED]>
files. They are used to make
sure that commits to multiple databases occurs atomically.
They should be deleted automatically. I do not know why they
are not being removed for you. I will look into it.
--
D. Richard Hipp <[EMAIL PROTECTED]>
are
NULL, then the answer is the sum of the non-NULL entries.
But if the number of entries is greater than zero and
they are all NULL, then the answer is NULL.
Logical, right
The more I learn about NULLs in SQL the less sense they
make...
--
D. Richard Hipp <[EMAIL PROTECTED]>
hen it has no
input.
--
D. Richard Hipp <[EMAIL PROTECTED]>
, which is what I am proposing to do
in SQLite in defiance of the SQL standard.
--
D. Richard Hipp <[EMAIL PROTECTED]>
tand Martin's point of view. The SQL standard
point of view makes no sense to me at all.
--
D. Richard Hipp <[EMAIL PROTECTED]>
mperature FROM antartica WHERE temperature < -150 LIMIT 1
Which gives the result you seek.
Thank you for the suggestion, though...
--
D. Richard Hipp <[EMAIL PROTECTED]>
send me both a query and a database to
run it on, I will look into the matter and hopefully get a fix
out right away.
--
D. Richard Hipp <[EMAIL PROTECTED]>
= 0
sum() == NULL
sum() == the correct sum
--
D. Richard Hipp <[EMAIL PROTECTED]>
On Fri, 2005-09-09 at 15:43 -0400, D. Richard Hipp wrote:
> There may be something wrong with version 3.2.5. See, for example,
> ticket #1414: http://www.sqlite.org/cvstrac/tktview?tn=1414
If you read the comments on the ticket above, you'll see that
the problem was solved by r
the optimizer without
creating any incompatibilities.
--
D. Richard Hipp <[EMAIL PROTECTED]>
load version 3 of the TCL bindings
first, then version 2.
--
D. Richard Hipp <[EMAIL PROTECTED]>
On Tue, 2005-09-13 at 09:08 +0200, Laurent wrote:
> I get the error :
>
>Assertion failed: xHash!=0, file hash.c, line 299
>Abnormal program termination
>
I tried the same sequence of commands and it worked
fine for me.
--
D. Richard Hipp <[EMAIL PROTECTED]>
default release. In the meantime,
you can find the patches at:
http://www.sqlite.org/cvstrac/tktview?tn=1240
--
D. Richard Hipp <[EMAIL PROTECTED]>
parse.c and no hand editing
is required.
--
D. Richard Hipp <[EMAIL PROTECTED]>
On Thu, 2005-09-15 at 13:59 +0100, Da Martian wrote:
> Hi
>
> I have 3 million rows in a table which takes up about 3.1GB on disk. The
> count(*) is slow.
>
> I have run the analyze, but apart from creating the stats table it does
> nothing.
>
> Any reason why this is? Can it be improved ?
.
--
D. Richard Hipp <[EMAIL PROTECTED]>
, I'm
obliged to support it forever. So I want to ponder the
issue a bit more first.
--
D. Richard Hipp <[EMAIL PROTECTED]>
ns of
windows.
So to answer your question, COMMIT is much faster on Win98 because of
a bug in the operating system that can cause data loss or data
corruption
after a power failure or operating system crash.
--
D. Richard Hipp <[EMAIL PROTECTED]>
rewritten.
COUNT(DISTINCT) is now supported.
The LIKE operator might use indices to speed its
search if the column being searched uses COLLATE NOCASE.
Lots of smaller bug fixes and miscellaneous
enhancements.
--
D. Richard Hipp <[EMAIL PROTECTED]>
On Sun, 2005-09-18 at 01:03 +0400, Alexander J. Kozlovsky wrote:
> Hence, SQLite deferred transactions is not serializable ones.
>
Your understanding is incorrect. SQLite does *not* release
locks in the middle of a transaction - ever. It is always
serializable.
--
D. Richard Hipp &
Do you have
> any suggestions on how I can use a variable in my ORDER BY clause?
> Thanks,
> Nicole Hinderman
>
>
Changes to the ORDER BY modify the choice of algorithms used
to process the query. This requires that you rerun
sqlite3_prepare() in order to generate new code for th
oesn't exist...)
>
> The second seems to be a limitation of VS6 - it certainly isn't a
> problem in VS7. Can't really think of any neat solution around it
> either...
>
http://www.sqlite.org/cvstrac/chngview?cn=2720
--
D. Richard Hipp <[EMAIL PROTECTED]>
nnot debug this problem unless you provide more
information. What were you setting DEFAULT_PAGE_SIZE to,
for example. Are you sure the original database is
readable by a stock copy of 3.2.5? Can you provide
a copy of the database that does not work?
--
D. Richard Hipp <[EMAIL PROTECTED]>
t the same database handle, they
will not be isolated. I do not understand why you would expect
that they would be.
--
D. Richard Hipp <[EMAIL PROTECTED]>
On Mon, 2005-09-19 at 13:42 -0400, D. Richard Hipp wrote:
> On Mon, 2005-09-19 at 19:04 +0200, Guillaume Fougnies wrote:
> > Hello,
> >
> > During the upgrade from 3.2.5 to 3.2.6, i removed my
> > compile time option SQLITE_DEFAULT_PAGE_SIZE.
> >
> &
os.refid=pots.id
In this second join, the photos.kind=2 condition can never be met
because every row in the result of the previous join has photos.kind==1.
Hence, the result set contains no rows. A COUNT() of a empty result
set gives NULL.
--
D. Richard Hipp <[EMAIL PROTECTED]>
imeline and see if
you spot anything similar.
--
D. Richard Hipp <[EMAIL PROTECTED]>
On Mon, 2005-09-19 at 16:06 -0400, Kervin L. Pierre wrote:
> D. Richard Hipp wrote:
> > Hence, the result set contains no rows. A COUNT() of a empty result
> > set gives NULL.
>
> I thought per the last discussion on "Sum and NULL"
> that the count of an empty
On Mon, 2005-09-19 at 15:19 -0400, D. Richard Hipp wrote:
> On Mon, 2005-09-19 at 19:36 +0200, Alain Bertrand wrote:
> > hi all,
> >
> > I am porting a program from mysql to sqlite.
> > The following statement doesn't work correctly with sqlite though it does
>
. Or you can get the patches
directly from http://www.sqlite.org/cvstrac/chngview?cn=2725.
--
D. Richard Hipp <[EMAIL PROTECTED]>
ithout this workaround.
>
> > -Original Message-
> > From: Jolan Luff [mailto:[EMAIL PROTECTED]
> > Sent: Saturday, September 17, 2005 4:14 PM
> > To: sqlite-users@sqlite.org
> > Subject: Re: [sqlite] Version 3.2.6
> >
> > On Sat, Sep 17, 2005 at 03:
On Fri, 2005-09-23 at 13:00 -0400, Richard Nagle wrote:
> is there a easier way of typing in data to Sqlite.
>
> sqlite> insert into car (md_num, md_name, style, year)
> ...> values (1, 'Honda', 'Coupe', 1983)
> ...> ;
>
> Man, just 806 more listing
> just looking for some short
SQLite version 3.2.7 is now available on the website.
This release fixes several obscure problems that were
discovered over the past week. There is no rush to
upgrade unless you are having problems.
--
D. Richard Hipp <[EMAIL PROTECTED]>
t;
You should not call sqlite3_result_* from within the step
function of an aggregate. Those routines may be called from
within the finalizer function only.
--
D. Richard Hipp <[EMAIL PROTECTED]>
On Tue, 2005-09-27 at 13:40 +0200, Joxean Koret wrote:
> Why not use mmap, munmap, mprotect, mlock, etc... system calls?
>
You ever tried to mmap a 10GiB database file into the memory
of processor with a 4GiB address space?
--
D. Richard Hipp <[EMAIL PROTECTED]>
(such as gcc) that will emulate floating point.
(2) Modify the code to use integers rather than doubles to score
indices in the optimizer.
--
D. Richard Hipp <[EMAIL PROTECTED]>
qlite3_result_error
at that point if it is appropriate to do so.
--
D. Richard Hipp <[EMAIL PROTECTED]>
BTree layer directly. For these reasons, calls directly
into the BTree layer are strongly discouraged.
--
D. Richard Hipp <[EMAIL PROTECTED]>
and ready for production use.
Please let me 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-bin/mailman/listinfo/sqlite-users
't solve the problem.
It means the index is corrupt. Try running "REINDEX".
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
r...@macscripter.net
>
>
>
> ___
> 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
about the BETWEEN operator. How about this:
WHERE birth BETWEEN date('now','-24 years') AND date('now','-12
years')
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
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
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
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
___
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
___
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
" - 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
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
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
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
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
__
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
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
(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
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
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
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
_
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
. 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
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
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
701 - 800 of 1539 matches
Mail list logo