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 "'" +
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
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
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
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
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,
Hi folks,
I have a problem with version 3.9.1 of sqlite. I have migrated a DB from ms
access to sqlite using the tool at http://mdb2sq3.codeplex.com.
Some columns are empty either using sqlite3.exe or sqlite3.dll at the
current version. Using version 3.8.10.2 (I compiled it by myself), the
column
8 matches
Mail list logo