[sqlite] Intel compiler warnings with 3.3.2

Since these are nots a bug I will post them here my findings with 3.3.2 with Intel compiler (one of the best and fast compiled code I've seen) under Windows: attach.c .\Sqlite\v3\attach.c(36): remark #1418: external definition with no prior declaration int resolveAttachExpr(NameContext

Re: [sqlite] Same error is flagged in 3.2.8 for sqlite3GenerateConstraintChecks() [was [sqlite] Known issue in 3.2.7 in vaccum?

Russell Leighton <[EMAIL PROTECTED]> wrote: > Thx. > > I'll re-test with 3.3.1. > > That said, isn't 3.2.8 supposed to be the stable release? > That depends on what you mean by "stable". If you mean "unchanging", then yes, 3.2.8 is stable. The 3.2.x series is closed and will never again

Re: [sqlite] Same error is flagged in 3.2.8 for sqlite3GenerateConstraintChecks() [was [sqlite] Known issue in 3.2.7 in vaccum?

Thx. I'll re-test with 3.3.1. That said, isn't 3.2.8 supposed to be the stable release? [EMAIL PROTECTED] wrote: Russell Leighton <[EMAIL PROTECTED]> wrote: Recompiled using 3.2.8 of sqlite, same issue is flagged by valgrind. 3.2.8 is a single-line change to 3.2.7. That they

[sqlite] 3.2.8 'make test' fails tests under linux

I get the following failures under 2 linux environments which might be related to the below valgrind issue: Failures on these tests: conflict-6.2 conflict-6.3 conflict-6.7 conflict-6.8 conflict-6.9 conflict-6.10 conflict-6.11 conflict-6.12 conflict-6.13 ..when doing a 'make test'

Re: [sqlite] Same error is flagged in 3.2.8 for sqlite3GenerateConstraintChecks() [was [sqlite] Known issue in 3.2.7 in vaccum?

Russell Leighton <[EMAIL PROTECTED]> wrote: > Recompiled using 3.2.8 of sqlite, same issue is flagged by valgrind. > 3.2.8 is a single-line change to 3.2.7. That they show the same bug is not surprising. There have been a bazillion minor tweaks to SQLite since 3.2.7/8. If you see the same

[sqlite] Same error is flagged in 3.2.8 for sqlite3GenerateConstraintChecks() [was Re: [sqlite] Known issue in 3.2.7 in vaccum?

Recompiled using 3.2.8 of sqlite, same issue is flagged by valgrind. Russell Leighton wrote: Also, this happens under any constrained insert...from the stack trace below you would that that would be true. This is confirmed during another test scenario doing an insert statement into a

Re: [sqlite] PRAGMA table_info oddness

Well, it's not the prettiest thing in the world, but it definitely works. Brilliant! Many thanks for your help, -Mike Ashmore On Jan 23, 2006, at 1:01 PM, Kurt Welgehausen wrote: Sorry, I didn't read your code carefully enough the first time. Your approach won't work because origin has no

Re: [sqlite] PRAGMA table_info oddness

On Jan 22, 2006, at 7:43 PM, Kurt Welgehausen wrote: There's no string type in SQL. Go to and read section 2.1. Regards Okay, my previous message related to SQL syntax, so I suppose it's fair to point out that "string" isn't a SQL type. In fact, I

Re: [sqlite] PRAGMA table_info oddness

Mike Ashmore wrote: Hi folks, I'm trying to create a composite view from multiple database files, with an extra field for the origin of a particular record. A sample scenario: There's a table, "foo," which exists in two database files, 'a.db3' and 'b.db3'. Let's define it as: CREATE

Re: [sqlite] Stale master journal files

Doug Nebeker <[EMAIL PROTECTED]> wrote: > I'm currently seeing something that has never happened--about 90 master > journal files (the -mjX type) that are popping up in my > database directory. I'm using 3.2.7 or 3.2.8 (have to double check) on > Windows. > > The scenario: > I have two

RE: [sqlite] Decimal conversion

Thanks Dennis, I will give that a shot. -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 11:20 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Decimal conversion nbiggs wrote: >I was using version 3.2.1. I downloaded 3.3.1 and your

[sqlite] Read Uncommitted

Hi I searched the mail archive and documentation but could not find any 'answer' to the new "READ UNCOMMITTED" ability. Is it a pragma? If it is; is it set when database is opened, or each time you start a write transaction, or maybe something else? Any assistance would be appreciated, thanks

Re: [sqlite] Decimal conversion

nbiggs wrote: I was using version 3.2.1. I downloaded 3.3.1 and your suggestion worked, but it is very slow compared to 3.2.1. I use the original query to test the speed. 3.2.1 returned the data in a little over 10 seconds while 3.3.1 took a minute. Why is that? I don't know. There

[sqlite] Known issue in 3.2.7 in vaccum?

During valgrind ( www.valgrind.org ) testing under linux I was executing "vaccum" and got: ==17449== Conditional jump or move depends on uninitialised value(s) ==17449==at 0x1CF2200C: sqlite3GenerateConstraintChecks (insert.c:980) ==17449==by 0x1CF233F6: sqlite3Insert (insert.c:629)

Re: [sqlite] Two problems

- Original Message - From: "Paul Tomblin" <[EMAIL PROTECTED]> Quoting Dan Kennedy ([EMAIL PROTECTED]): > - The second problem appears to be a problem with self-locking. I'm > inserting a "mapping" into a table. I have a query active to find > ids > that require mapping, and

Re: [sqlite] Two problems

Paul Tomblin <[EMAIL PROTECTED]> wrote: > Quoting Dan Kennedy ([EMAIL PROTECTED]): > > > - The second problem appears to be a problem with self-locking. I'm > > > inserting a "mapping" into a table. I have a query active to find ids > > > that require mapping, and then I try to find the

Re: [sqlite] Slow query after reboot

Thanks to everyone for all the help on this problem. I am going to try creating a new thread to touch the tables at startup. Chris Schirlinger wrote: We have the same issue, to get around it we fire a thread when the program starts, intelligently "touching" every table that the user is

Re: [sqlite] Two problems

Quoting Dan Kennedy ([EMAIL PROTECTED]): > > - The second problem appears to be a problem with self-locking. I'm > > inserting a "mapping" into a table. I have a query active to find ids > > that require mapping, and then I try to find the current lowest > > unused "mapping" value, and

Re: [sqlite] Version 3.3.0 (alpha)

"Roger Binns" <[EMAIL PROTECTED]> wrote: > >> ... But new databases created by > >> version 3.3.0 will not be readable by older versions > >> of SQLite. If this is a problem for your application, > >> compile SQLite using > >> > >> -DSQLITE_DEFAULT_FILE_FORMAT=1 > >> >

[sqlite] Problem with opening

hai, is it possible for two threads to open same database file simultabiously and perform an insert stmt?, if not is ther is any way to implement it? Send instant messages to your online friends http://in.messenger.yahoo.com