[sqlite] Fixes to the transliteration table in ext/misc/spellfix.c

*/ { 0x0446, 0x74, 0x63, 0x00, 0x00 }, /* ц to tc */ This Cyrillic letter is usually transliterated as Ts. Unless "Tc" is a hack meant to cover both "Ts" and the rarer transliteration "C", it looks like a typo: https://en.wikipedia.org/wiki/Tse_(Cyrilli

Re: [sqlite] Infinite loop in sqlite3VdbeSorterWrite when sorting big data

> Thanks for reporting this. I think it should be fixed here: > > http://www.sqlite.org/src/info/623827192532f08b Thanks for the fix! I confirm it fixes the issue I saw. Marcin ___ sqlite-users mailing list sqlite-users@sqlite.org http://s

Re: [sqlite] Infinite loop in sqlite3VdbeSorterWrite when sorting big data

> Do you have a large cache-size configured? Yes: PRAGMA cache_size = 10 PRAGMA page_size = 16384 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Problem with SQLiteCommand.Parameters and CurrentCulture

AddWithValue("@doubleProp", 1.2.ToString(CultureInfo.InvariantCulture)) all work fine. In my opinion command parameters should use InvariantCulture when converting types to string. Best Regards Marcin Szotka - InstalSoft ___ sqli

Re: [sqlite] Malformed database recovery

Of course, I understand that I haven't recovered everything, but as I said before, I don't find any big ammount of data lost ;) Sent: Tuesday, May 14, 2013 5:59 PM Subject: Re: [sqlite] Malformed database recovery On 14 May 2013, at 4:54pm, "Marcin" <ign...@op.pl> wrote: O

Re: [sqlite] Malformed database recovery

the input to fix the old one. Naturally, you desire a commit rather than a rollback when your .read can execute with no errors. Others on the list are far better at explaining the output of the integrity check than I am. Adam On Tue, May 14, 2013 at 11:40 AM, Marcin <ign...@op.pl> wr

Re: [sqlite] Malformed database recovery

on .read dump_all.sql ? was PRAGMA integrity_check; on the new file or the old one? On Tue, May 14, 2013 at 10:29 AM, Marcin <ign...@op.pl> wrote: Hi everybody. Somehow my database got malformed, and journal file is unfortunately nowhere to found. Suprisingly, I'm able to open it in

[sqlite] Malformed database recovery

Hi everybody. Somehow my database got malformed, and journal file is unfortunately nowhere to found. Suprisingly, I'm able to open it in Sqlite Database Browser, and read stored values. There is only minor data loss, as I can't really see what got missing. I've also managed to figure which

[sqlite] BUG? sqlite not reporting error like "more than one row returned by a subquery used as an expression"

t values (1),(2),(3); INSERT 0 3 mail=> select * from t where v = (select v from t); ERROR: more than one row returned by a subquery used as an expression mail=> select * from t where v in (select v from t); v --- 1 2 3 (3 rows) Is this a bug, or a feature? Marcin

Re: [sqlite] AUTOINCREMENT documentation.

> > Not exactly, > in monotonically increasing sequence next element is always smaller than > current. > I mean larger :-) Sorry, KoD ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] AUTOINCREMENT documentation.

Troeger, Thomas (ext) wrote: > Hello, > > Sorry if this has been asked before, I couldn't find any reference to it > in the list archives. I've found a small bug in the documentation, I > wanted to mention it since I think it should be changed accordingly. > > In

Re: [sqlite] OLE DB provider for SQLite

-Original Message- Date: Mon, 17 Nov 2008 08:53:44 -0500 From: "Brad Stiles" <[EMAIL PROTECTED]> Subject: Re: [sqlite] OLE DB provider for SQLite To: "General Discussion of SQLite Database" Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain;

[sqlite] OLE DB provider for SQLite

Is there any OLE DB provider for SQLite other than provider from Cherry City Software: http://cherrycitysoftware.com/ccs/Providers/ProvSQLite.aspx Unfortunately this provider does not work well with one of my company's project (it must with Analysis Services and OLAP). Could You tell me, are