On 06/24/2011 12:26 PM, logan...@gmail.com wrote:
Hello,
My understanding is that an index is automatically created on any column
that is used in the primary key (or a composite index is created if the key
is composed of different columns). If this is correct then why don't I see
indexes for
Yes, that's exactly what it is. Here is the definition of one of the table:
CREATE TABLE [Attributes] (
[Id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
[Name] VARCHAR(50) NOT NULL
)
Will creating explicit index on Id fix this issue?
Thanks.
On Thu, Jun 23, 2011 at 11:07 PM, Dan Kennedy
SQLite version 3.7.7 is now available on the SQLite website:
http://www.sqlite.org/
A list of changes is available at
http://www.sqlite.org/releaselog/3_7_7.html
Further information about this release can be seen at
http://www.sqlite.org/news.html
Please post on the SQLite
I've run into a phenomenon I don't understand where view nesting affects
types.
Seen in sqlite 3.7.6.3
sqlite-3.6.23 does NOT show this behavior.
After further reflection, I am going to go out on a limb and suggest
that the behavior described in the OP is a regression. The behavior
started
logan...@gmail.com wrote:
Yes, that's exactly what it is. Here is the definition of one of the table:
CREATE TABLE [Attributes] (
[Id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
[Name] VARCHAR(50) NOT NULL
)
Will creating explicit index on Id fix this issue?
What issue? Why is having
Rense,
As for the ranges of n1 and n1: they are both roughly between 6
and 1200 .
Here are the results of EXPLAIN QUERY PLAN SELECT n1, n2 FROM table1
Where n1 n2 INTERSECT SELECT n2, n1 FROM table1 Where n2 n1;
1|0|0|SCAN TABLE table1 (~437976176 rows)
2|0|0|SCAN TABLE table1
On 24 Jun 2011, at 12:04pm, D. Richard Hipp wrote:
SQLite version 3.7.7 is now available on the SQLite website:
http://www.sqlite.org/
A list of changes is available at
http://www.sqlite.org/releaselog/3_7_7.html
In section 3.3 of
http://www.sqlite.org/uri.html
could you add
Just thought I should add that the problem seems to be gone with the
just released version 3.7.7, but it's not mentioned in the release notes.
It's not in release notes but it's in the timeline. See
http://www.sqlite.org/src/info/91e2e8ba6f and
http://www.sqlite.org/src/info/0b3174e0b1.
Pavel
I've had numerous issues with the wrong version of SQLite being installed
in the GAC.
eg I make my app x86 and use the x86 SQLite dll and have that in my app
directory.
but the .net framework _always_ prefers to load from the GAC so the the x64
system.data.sqlite is installed my app loads it and
Reading the release notes and documentation for SQLite 3.7.7, I noticed what
I believe may be an oversight / minor problem with the URI filename support
when using SQLite on a Windows platform.
The documentation clearly states that using an authority other than
localhost is not permitted.
Jean-Christophe,
Thanks for this idea. In fact, the purpose of my original query is
exactly to reduce the database. The 800 mln rows were exported from
another source, and I was hoping to be able to use sqlite to manage
this massive amount of data (e.g., removing redundant information)
before I
Hi Rense,
Thanks for this idea. In fact, the purpose of my original query is
exactly to reduce the database. The 800 mln rows were exported from
another source, and I was hoping to be able to use sqlite to manage
this massive amount of data (e.g., removing redundant information)
before I proceed
Sorry, but seems like I'm missing something here.
From my understanding it looks like for Integer ID columns that are PK
SQLite doesn't generate any indexes. Is this true?
If the above is true then I want to create an index to improve the perf of
my queries that are run against it.
Thanks,
On Jun 24, 2011, at 1:58 PM, logan...@gmail.com wrote:
Sorry, but seems like I'm missing something here.
From my understanding it looks like for Integer ID columns that are PK
SQLite doesn't generate any indexes. Is this true?
No, what you think is not true. SQLite does generate an index
On 24 Jun 2011, at 6:58pm, logan...@gmail.com wrote:
From my understanding it looks like for Integer ID columns that are PK
SQLite doesn't generate any indexes. Is this true?
If the above is true then I want to create an index to improve the perf of
my queries that are run against it.
The
On 6/24/2011 1:58 PM, logan...@gmail.com
wrote:
Sorry, but seems like I'm missing something here.
From my understanding it looks like for Integer ID columns that are PK
SQLite doesn't generate any indexes. Is this true?
It's true in a narrow technical sense, but it doesn't matter in
Hi all,
While using sqlite to test a dynamic type tracking tool for LLVM that we are
developing, we found the following bug in sqlite.
I have sqlite version 3.7.6.3, and in the following call to sqlite3MPrintf
zStmt = sqlite3MPrintf(db, CREATE%s INDEX %.*s,
onError==OE_None ? :
C#-SQLite has been updated to release 3.7.6.3 and is now ready for use.
The 6/24/2011 release features:
* Updated to SQLite version 3.7.6.3
* Silverlight support
* Windows 7 Phone
It now runs 58,100 of the tcl testharness tests without errors.
The project is located at
Shane,
Thank you very much for your email.
I've unistalled the old .NET4 libraries and installed the new ones.
I've updated project references and DLLs distributed with the app.
Can you help me as when I try the new app I get this error:
See the end of this message for details on
Second problem I've discovered is that with previous library I was able to
create an Entity Data model while with the latest is not possible the server
explorer does not work.
From: Massimo Savazzi [mailto:massimo.sava...@gmail.com]
Sent: Friday, 24 June, 2011 21:29
To: 'sh...@sqlite.org';
On Fri, Jun 24, 2011 at 2:17 PM, Arushi Aggarwal arushi...@gmail.comwrote:
Hi all,
While using sqlite to test a dynamic type tracking tool for LLVM that we
are
developing, we found the following bug in sqlite.
I have sqlite version 3.7.6.3, and in the following call to sqlite3MPrintf
Ahh..ok, thanks for the response everyone. I really appreciate the help here
:).
On Fri, Jun 24, 2011 at 11:10 AM, Igor Tandetnik itandet...@mvps.orgwrote:
On 6/24/2011 1:58 PM, logan...@gmail.com
wrote:
Sorry, but seems like I'm missing something here.
From my understanding it looks
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/24/2011 08:28 AM, Cheetah wrote:
The documentation clearly states that using an authority other than
localhost is not permitted.
This was a deliberate decision when the feature was originally proposed.
The original spec was that the hostname
Hi,
I don't use transactions in my app, is the data safe from failure if I turn off
the journal?
The insert isn't concurrent and I'm using System.Data.SQLite (.net)
Thanks
___
sqlite-users mailing list
sqlite-users@sqlite.org
I need to select a substring of a column that starts 1 character after a
colon in the column and continues to the end of the column. For example, if
the column contained abc:xyz I want the select statement to return only
xyz (the characters after the colon). The substr function requires
specific
25 matches
Mail list logo