No the bug was mine I think!
I used the tool found at http://mdb2sq3.codeplex.com/.
(wrote it in the first mail of thread)
If you see the escape char was single quote (method EscapeIdentifier
in TableMetaData.cs
line 55), which was used for example in
CreateTableDML (SsLiteBackend.cs line 169)
Thank you Richard!!!
First of all thank you for sqlite, and then for the response on this bug.
@Donald Griggs: I had to substitute only one line in the tool kindly
provided by MfHernandez:
public static String EscapeIdentifier(String identifier)
{
return "'" + identifier.Repla
Still trying to figure out why I get an application crash when I use 2 UDF
if the same
SQLite statement, eg:
select SumTwoLongs(F1, F2) as a, SumTwoLongs(F2, F1) as b from UDF_TEST
limit 1
The callback function gets called twice and all seems to be fine with that,
looking at the logging data:
Su
Hi Donald,
many thanks for your response.
I used the command:
"pragma integrity_check" with db opened with version 3.9.1.
The result is:
Error: database disk image is malformed
Am I missing something or this error is more silent that the original fault?
I am planning to make a patch of the conv
On 31 Oct 2015, at 7:42pm, Andi Palo wrote:
> I used the command:
> "pragma integrity_check" with db opened with version 3.9.1.
>
> The result is:
>
> Error: database disk image is malformed
>
> Am I missing something or this error is more silent that the original fault?
As later and later v
On 10/31/15, Andi Palo wrote:
> thank you ... for the response on this bug.
>
I've been working on this. Now I'm not so sure it is a bug in SQLite
at all as I'm unable to reproduce the problem (so far).
Can you explain to me more about how the khirapumpsshaft.db database
was generated? Maybe I
On Fri, 30 Oct 2015 12:01:15 -0700
Roger Binns wrote:
> https://sqlite.org/mmap.html
>
> SQLite supports memory mapping databases, but only does so for the
> first 2GB of the file. My databases are around 4 to 20GB, and
> completely fit within RAM on my 64 bit systems. The 2GB mmap limit
> mea
On 10/30/15, aa wrote:
> Hello,
>I am a sqlite user from asia. I use sqlite for more than a year , now
> the version i am using is 3.8.11.1.
>But recently I meet a problem about inserting data into table.It is
> too slow whit index.
>The first I create a table like this:
>
On 30 Oct 2015, at 1:42pm, aa wrote:
>CREATE TABLE mac_tb (mac BIGINT PRIMARY KEY?
SQLite doesn't have a BIGINT type. It will interpret those as integers.
>If I insert into mac_tb with mac ordey by num desc or asc , then the
> speed is fast.
>If I insert the mac rand
On 10/31/15, Donald Griggs wrote:
>
> I imagine this doesn't fully solve your problem, but I noted that:
>
> 1. Your example database does NOTt pass
>PRAGMA INTEGRITY_CHECK;
> When using 3.9.1 command line utility.
>
> 2. Using 3.8.10.2, it DOES pass.
>
Very interesting.
The schema syntax
On 10/29/15, Jaromir Capik wrote:
>
> This is not about being difficult. It just goes against the trend
> of striping unnecessary dependencies from the first stages.
We make two different source distributions of SQLite available. There
is the "canonical" source distribution, containing the actua
On 10/30/15, sanhua.zh wrote:
> Hi, all
> I use SQLite in iOS. I found that SQLite will take lower performancein
> multi-thread SELECTing.
> Here is my test result,
> It costs 0.11s to select 100, elements,in 1-thread SELECTing:
> But the sameIn 4-thread SELECTing, it costs 0.2s avg.
>
>
> Thi
Hi, Andi,
I imagine this doesn't fully solve your problem, but I noted that:
1. Your example database does NOTt pass
PRAGMA INTEGRITY_CHECK;
When using 3.9.1 command line utility.
2. Using 3.8.10.2, it DOES pass.
3. I can use ".dump" under 3.8.10.2, to produce a text sql file, then,
under
13 matches
Mail list logo