On Tue, Oct 13, 2009 at 11:07 PM, Fred Williams wrote:
> The best way I have found to manage decimal (Business math) with most all
> the databases is to use integers and multiply and divide by the decimal
> offset (i.e. 10, 100, 1000) for presentation purposes, doing my own
> "bankers rounding"
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Simon Slavin wrote:
> What I will say is this: I see no reason why there
> should be more bugs in the AFP locking code than there are in the
> locking code that comes into play if you're accessing a file on your
> own hard disk.
In which case yo
Simon Slavin wrote:
> On 14 Oct 2009, at 1:21am, priimak wrote:
>
>
>> I am heaving small problem with sqlite. I have a webapp which connects
>> to the database using sqlite-jdbc and performs SELECTs to response to
>> different GET requests, while this happens if I try to write to a
>> database
On Oct 14, 2009, at 12:42 AM, McClellen, Chris wrote:
> But it does happen and we can reproduce it. Hard killing a thread is
> essentially equivalent to turning off the power.
We have always assumed that it is different. When you write data to
a file, the write is buffered in volatile memory by
D. Richard Hipp wrote:
> On Oct 12, 2009, at 8:55 AM, Dr. David Kirkby wrote:
>>> /var/tmp//ccv990We.s:587: Warning: .stabs: description field
>>> '1161d' too
>>> big, try a different debug format
>
>>> if a developer wants to take a look, and does not have access to an
>>> HP-UX machine, I can
On 14 Oct 2009, at 3:37am, Roger Binns wrote:
> Are you willing to stake your reputation and whatever else on there
> being
> bug free implementations of AFP and SMB. (BTW in a past life I
> coded an SMB
> server - the other clients and servers out there are definitely not
> bug free :-)
>
Oh yeah, I forgot to tell you that I'm using Visual C++ 2008 professional
and it always crashes at this:
C:\Program Files\Microsoft Visual Studio 9.0\VC\crt\src\dbgheap.c -
function "_free_dbg_nolock", line 1317:
/*
* If this ASSERT fails, a bad pointer has been passed in. It may
Well, I'm pretty sure I haven't. FYI, I wrapped the sqlite3_stmt into a
class and only call its sqlite3_finalize on its destructor. So there's no
way that it would be called twice. Or so I think.
Pavel Ivanov wrote:
>> The pPrior or p pointer isn't null so it should've been
>> freed without error
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Simon Slavin wrote:
> Perhaps this passage could be rephrased to warn explicitly about NFS
> rather than about the more general "files on a network filesystem".
As a general rule network filesystems are buggy. Local filesystems get to
make all the
´¯¯¯
>So if a SELECT is in progress, other SELECT commands can be allowed to
>proceed without problems. But no INSERT or UPDATE can be allowed until
>the SELECT is finished. Hence you will sometimes get a lock on the
>write.
>
>How you deal with this, I don't know. Random wait-and-try-again ?
`
On 14 Oct 2009, at 1:21am, priimak wrote:
> http://www.sqlite.org/lockingv3.html
By the way, I just read some of that page and a bit of it, while
possibly technically correct, may be putting some people off from
using SQLite.
"One should note that POSIX advisory locking is known to be buggy
On 14 Oct 2009, at 1:21am, priimak wrote:
> I am heaving small problem with sqlite. I have a webapp which connects
> to the database using sqlite-jdbc and performs SELECTs to response to
> different GET requests, while this happens if I try to write to a
> database ( UPDATE or INSERT ) from comma
Hi Pavel,
>I believe you need to show us your sql query. Maybe something in it
>forces SQLite to use UTF-16 version of the function.
On the contrary, I believe this is due to a serious design bug, where
it is impossible to perform anything like:
select load_extension('whatever.dll');
Hi.
I am heaving small problem with sqlite. I have a webapp which connects
to the database using sqlite-jdbc and performs SELECTs to response to
different GET requests, while this happens if I try to write to a
database ( UPDATE or INSERT ) from command line, that (i.e. update
process) would o
The 3.6.18 sqlite3.exe CLI produces the same problem: the internal
functions below can't be overloaded and trying to do so returns 5.
System is XP Pro x86 SP3.
What can I try next ?
>I see that sqlite3.dll is returning 5 == SQLITE_BUSY for the following
>functions:
>
>upper UTF-8
>low
It looks pretty interesting that no matter if date() function works as
is now or with some heuristics applied the following equations are not
always true:
date(some_date, '-1 month', '+1 month') = some_date
date(some_date, '-1 month') = date(some_date, '-1 day', '-1 month', '+1 day')
Looks like a
On Tue, Oct 13, 2009 at 03:30:44PM -0400, D. Richard Hipp wrote:
> Begin with 2001-03-31
> Add 1 to 03, yielding 2001-04-31
> 04-31 means the 31st day from the beginning of april: 2001-05-01
>
> Begin with 2001-03-31
> Subtract 1 from 03 yielding 2001-02-31.
> 02-31 means the 31st day from the beg
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
>> From: D. Richard Hipp
>> Subject: Re: [sqlite] Bug in date() function ??
>>
>>
>> On Oct 13, 2009, at 12:57 PM, Keith Roberts wrote:
>>
>>> Just been
On Tue, 13 Oct 2009, D. Richard Hipp wrote:
> To: General Discussion of SQLite Database
> From: D. Richard Hipp
> Subject: Re: [sqlite] Bug in date() function ??
>
>
> On Oct 13, 2009, at 12:57 PM, Keith Roberts wrote:
>
>> Just been messing about with the date functions, and there
>> appears t
On 13 Oct 2009, at 2:07pm, Fred Williams wrote:
> The best way I have found to manage decimal (Business math) with
> most all
> the databases is to use integers and multiply and divide by the
> decimal
> offset (i.e. 10, 100, 1000) for presentation purposes, doing my own
> "bankers rounding"
If I set a breakpoint on this:
rc = sqlite3_create_function(db, p->zName, p->nArg, p->enc,
p->pContext, p->xFunc, 0, 0);
I see that sqlite3.dll is returning 5 == SQLITE_BUSY for the following
functions:
upper UTF-8
lower UTF-8
like 2-arg UTF-8
like 3-arg UTF-8
g
Cariotoglou Mike wrote:
> Great. thanks for the info. however, this means that at least part of the
> runtime library actually comes from the VCL, and not the BCC32 libraries, is
> that not so ?
>
There are some OBJ files needed, we picked them up from somewhere, but I
don't recall exactly w
Update: the problem is in the function registration.
I tried to comment out the UTF-16 registration and the really weird
thing is that using the following code, only GLOB with 3 arguments gets
actually registered (along with all 1-arg string functions and the two
collations).
There must be so
But it does happen and we can reproduce it. Hard killing a thread is
essentially equivalent to turning off the power.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dan Kennedy
Sent: Tuesday, October 13, 2009 12:35 AM
To: Gen
Hi Pavel,
>I believe you need to show us your sql query. Maybe something in it
>forces SQLite to use UTF-16 version of the function.
Ummm, I don't kno where the problem is, but _any_ simple select will do
(for me), e.g.:
An UTF-8 base...
CREATE TABLE "PaysISO" (
"Nom_Iso" CHAR(43),
"Cod
With the next version of SQLite (which will be released this week) you
will be able to write a trigger on deletion of dependent rows where
you will just call your function.
Pavel
On Tue, Oct 13, 2009 at 1:19 PM, Igor Tandetnik wrote:
> mwnn wrote:
>> i am using triggers to delete dependent rows
mwnn wrote:
> i am using triggers to delete dependent rows of a table when a
> referred row is deleted. Is there a way for me to let SQLite call a
> user-defined function for every row deleted in a trigger?
Well, you could write your trigger like this:
create trigger ... on delete ...
begin
Keith Roberts wrote:
> From: http://www.sqlite.org/lang_datefunc.html
>
> "Thus, for example, the data 2001-03-31 modified by '+1
> month' initially yields 2001-04-31, but April only has 30
> days so the date is normalized to 2001-05-01."
>
> When I add '+1 month' to the example data, the exampl
On Oct 13, 2009, at 12:57 PM, Keith Roberts wrote:
> Just been messing about with the date functions, and there
> appears to be an inconsistency when adding a month
> modifier. I'm running Fedora 10.
>
> From: http://www.sqlite.org/lang_datefunc.html
>
> "Thus, for example, the data 2001-03-31 mo
Just been messing about with the date functions, and there
appears to be an inconsistency when adding a month
modifier. I'm running Fedora 10.
[root ~]# sqlite3
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> SELECT date('2001-03-31');
2001-03-31
sqlite> SELECT date('2001-03-31', '+
Hi all,
i am using triggers to delete dependent rows of a table when a
referred row is deleted. Is there a way for me to let SQLite call a
user-defined function for every row deleted in a trigger?
Regards,
mwnn
___
sqlite-users mailing
Hello,
On several machines running Suse10.2 (gcc 4.1.2) we get the following
assertion
prog: sqlite3.c:15173: pthreadMutexEnter: Assertion `p->id==1 ||
pthreadMutexNotheld(p)' failed.
Aborted
The problem does not seem to occur on Suse11 (gcc 4.3.2), our Ubuntu, nor
on our Windows platforms.
We
Hi Everyone,
I'm using sqlite on a JFFS2 file system (writing to NAND flash) so I'm
wondering what the best file system characteristics to report via the
xSectorSize and xDeviceCharacteristics methods are ?
http://www.sqlite.org/c3ref/io_methods.html
(JFFS2 is in summary a rotating log journalin
> The pPrior or p pointer isn't null so it should've been
> freed without error IMHO. Can anybody tell me what's wrong with it? Thanks
> a lot in advance.
If "pPrior or p pointer" isn't null but was already freed then double
free can cause segmentation fault. In other words most probably you're
ca
Thanks!
Cheers!
#>-Original Message-
#>From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
#>boun...@sqlite.org] On Behalf Of sub sk79
#>Sent: Monday, October 12, 2009 9:35 PM
#>To: General Discussion of SQLite Database
#>Subject: Re: [sqlite] Need Help SQL
#>
#>Hi!,
#>
#>Here
> I'm using the 3.6.18 Windows dll downloaded direct from the site.
>
> I just re-checked that.
I believe you need to show us your sql query. Maybe something in it
forces SQLite to use UTF-16 version of the function.
Pavel
On Mon, Oct 12, 2009 at 11:44 PM, Jean-Christophe Deschamps
wrote:
> Tha
- Original Message -
From: "Dan Phillips"
To: "General Discussion of SQLite Database"
Sent: Tuesday, October 13, 2009 2:40 AM
Subject: Re: [sqlite] low-level view of data values?
> On Tue, Oct 13, 2009 at 2:01 AM, Robert Simpson
> wrote:
>> I'm pretty sure I do store them as strings
Hi there, I'm a new member of the mailing list. Nice to meet you all.
BTW, I've got one problem that's been bugging me for weeks.
Occasionally (not always), I got a seg fault at "static void
sqlite3MemFree(void *pPrior)". It happened when I do sqlite3_reset or
sqlite3_finalize. The pPrior or p po
Hi,
We have used Sqlite-3.6.16 on both
HP-UX PA-RISC( Compiler gcc 4.1.1 and aCC A.03.95)
and newer HP-UX IA64 machines ( aCC A06.23).
Compilation of amalgamation file sqlite3.c is usually problematic.
libsqlite.sl is compiled without using amalgamation.
All functionality works fine.
While debug
On Tue, Oct 13, 2009 at 2:01 AM, Robert Simpson wrote:
> I'm pretty sure I do store them as strings -- SQLite doesn't have a
> "decimal" datatype, and "double" doesn't cut the precision mustard for
> emulating "decimal".
Yes, but I believe the Decimals-as-text will only work if the column
is decl
40 matches
Mail list logo