[sqlite] Improper error message

Hi, Some other DBMS such as Postgres and SQL-Server implement the functions "left" and "right". SQLite does not. But why do I get confusing error messages when I (mistakenly) attempt to use them? To illustrate my point: select foo('abc', 2) Error: no such function: foo select left('abc', 2)

[sqlite] User-defined types

then communicate with any database since all databases recognize SQL. Nothing needs to change on SQLite's side. My 2 cents. Etienne

[sqlite] LINQ to SQLite Cannot Update: "Store update, insert, or delete statement affected an unexpected number of rows"

LINQ Select queries and converting parameters into values, GUID fields will be converted into String no matter if BinaryGUID is True or False. For now I can work with Text values and BinaryGUID=False. Fixing the issue with long queries failing is a higher priority. Etienne

[sqlite] LINQ to SQLite Cannot Update: "Store update, insert, or delete statement affected an unexpected number of rows"

I did some more tests. The way it handles GUID between text and binary is screwed up. When updating data, it will update as binary even if BinaryGUID is false. When selecting data, however, it tries to select it as plain text so nothing matches the query. Etienne From: mystery

[sqlite] LINQ to SQLite Cannot Update: "Store update, insert, or delete statement affected an unexpected number of rows"

', and adding data into it. It shows up as binary data. I also tried adding "binary guid=False" to the connection string, but this parameter doesn't have any effect. It still treats the column as binary. Etienne

[sqlite] LINQ to SQLite Cannot Update: "Store update, insert, or delete statement affected an unexpected number of rows"

The point I'm trying to make is not about whether GUID gets stored as binary or text... but rather that currently it's not working at all. There's no reason why GUIDs shouldn't be supported and should crash when trying to do an update. Etienne > From: sqlite at mistachkin.com > To:

[sqlite] LINQ to SQLite Cannot Update: "Store update, insert, or delete statement affected an unexpected number of rows"

acing Guid with String everywhere in the code, but there's no reason why it shouldn't be working in the first place. Etienne From: mystery...@hotmail.com To: sqlite-users at mailinglists.sqlite.org Subject: RE: [sqlite] LINQ to SQLite Cannot Update: "Store update, insert, or delete sta

[sqlite] String.Substring Generates Error

> From: sqlite at mistachkin.com > To: sqlite-users at mailinglists.sqlite.org > Date: Sat, 30 May 2015 14:40:52 -0700 > Subject: Re: [sqlite] String.Substring Generates Error > > > Etienne Charland wrote: > > > > SQLite error (1): no such function: Substring

[sqlite] Query returns "stack overflow error"

://www.spiritualselftransformation.com/misc/LinqSQLiteError.txt I'm running against SQLite that comes with NuGet package: System.Data.SQLite (x86/x64) v1.0.97.0 Etienne

[sqlite] Query returns "stack overflow error"

have to run it all at once. Etienne

[sqlite] Query returns "stack overflow error"

ound could be to first load the main data of my grid and afterwards load the extra columns asynchronously... which would allow me to cache the calculated data and improve performance. But that would require considerable coding. Any better solution? Thanks, Etienne

[sqlite] LINQ to SQLite Cannot Update: "Store update, insert, or delete statement affected an unexpected number of rows"

, leaving the data type as BIT does get mapped as Boolean and it still works even though it shouldn't. Any side-effect that could result from this? If it works it works... Then Single data types have to be replaced by Double, which is no big deal. Etienne

[sqlite] LINQ to SQLite Cannot Update: "Store update, insert, or delete statement affected an unexpected number of rows"

the key isn't auto-generated by the database, but can't find where I read that. So... what needs to be done to get this to work? Etienne > From: mysteryx93 at hotmail.com > To: sqlite-users at mailinglists.sqlite.org > Date: Fri, 29 May 2015 20:12:54 -0600 > Subject: Re: [sqlite] LI

[sqlite] Query returns "stack overflow error"

Depth, settings.RatingRatio)).FirstOrDefault(), IsInDatabase = true }); return Result; } Etienne

[sqlite] String.Substring Generates Error

How about this line of code var Obj = context.MediaCategories.Select(c => "ABC".Substring(1) != null).ToList(); It produces SELECT CASE WHEN (Substring('ABC', 1 + 1, (LENGTH('ABC')) - 1) IS NOT NULL) THEN 1 WHEN (Substring('ABC', 1 + 1, (LENGTH('ABC')) - 1) IS NULL) THEN 0 END AS [C1] FROM

[sqlite] LINQ to SQLite Cannot Update: "Store update, insert, or delete statement affected an unexpected number of rows"

Completed in 0 ms with result: 0 If I run this query manually, it works. Etienne

[sqlite] Query returns "stack overflow error"

I can get the query to run if I remove enough columns. This query fails with 1 column (subquery) beyond what is allowed to run. https://www.spiritualselftransformation.com/misc/LinqSQLiteError.txt Etienne

[sqlite] Query returns "stack overflow error"

ite] Query returns "stack overflow error" > > > On 30 May 2015, at 1:26am, Etienne Charland wrote: > > > there are requests that are very long because they return a grid where each > > column must be calculated individually, and this crashes with "stack &g

[sqlite] String.Substring Generates Error

STR function instead of SUBSTRING! It's like mapping a User Defined Function, except that we map to an existing standard function. This should be fixed in the source code. Etienne

[sqlite] Query returns "stack overflow error"

t on a SQL Server database -- and not at all with SQLite. How can I get these queries to run? Etienne

Re: [sqlite] to encrypt sqlite db

On Sun, Sep 1, 2013, at 19:59, Ulrich Telle wrote: > Am 01.09.2013 18:40, schrieb Etienne: > > wxSQLite is free, while SEE is definitively not. > > The original poster searched for a free encryption extension, of which > there exist several: System.Data.SQLite (RC4), wxSQLite3

Re: [sqlite] to encrypt sqlite db

wxSQLite (relevant part) and SEE are extensions to SQLite. wxSQLite is free, while SEE is definitively not. wxSQLite means "pseudo" encryption (as formerly discussed), while SEE is real encryption. What is weird??? Regards, Etienne - Original message - From: Pao

Re: [sqlite] to encrypt sqlite db

On Sun, Sep 1, 2013, at 17:50, Clemens Ladisch wrote: > Ulrich Telle wrote: > > Am 31.08.2013 22:01, schrieb Etienne: > >> I simply wanted to warn the OP that wxSQLite, while free, does NOT use > >> salts: > > > > Well, that's not completely true. The encrypt

Re: [sqlite] to encrypt sqlite db

> > On Sat, 31 Aug 2013 17:17:23 +0200 > > Etienne <etienne.sql...@mailnull.com> wrote: > > > > > > On the other hand removing patterns definitely cannot hurt. > > > > > > Precisely. > > > > > > The very first

Re: [sqlite] to encrypt sqlite db

ile BW works with large blocks of data. > SEE uses a random IV or nonce on each page. Exactly the reason why I would recommend SEE over wxSQLite for paranoiac usage. I did mention WXSQLite because the OP is looking for a free solution. Regards, Etienne _

Re: [sqlite] to encrypt sqlite db

t;encryption-only" practice might be enough to discourage an average user, it would probably not resist to a determined hacker... just my $0.02. Regards, Etienne ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/m

Re: [sqlite] to encrypt sqlite db

forge.net/components/wxsqlite3> might help you. It does supply free AES128/256 encryption (look in /sqlite3/secure/src/). However, be aware that there is no compression involved here, making (any) encryption significantly weaker. Regards, Etienne

Re: [sqlite] Faster query result

Hello José, #1: no hash/bsearch required. Regards, Etienne - Original message - From: jose isaias cabrera <cabr...@wrc.xerox.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: [sqlite] Faster query result Date: Fri, 22 Feb 2013 10:56:08 -0500

Re: [sqlite] Javascript API for SQLite?

, Mac, Linux, and SunOS. JSDB works with databases, XML, the web, and email. It is free and open-source. Use it as a JavaScript shell, to run CGI programs, or as a web server". (home page) Regards, Etienne ___ sqlite-users mailing list sqlite-users@s

Re: [sqlite] SQLite Encryption Extension Performance?

this helps. Regards, Etienne - Original message - From: Paul Vercellotti <pverce...@yahoo.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: [sqlite] SQLite Encryption Extension Performance? Date: Wed, 27 Jun 2012 11:55:21 -0700 (PDT) H

Re: [sqlite] sqlite time is 2 hours to late

Fully agree with you, Jay. -> SQLite NUL "select datetime('now','localtime');" E. On Wed, Jun 27, 2012, at 10:55, Jay A. Kreibich wrote: > On Wed, Jun 27, 2012 at 05:45:41PM +0200, deltagam...@gmx.net scratched on > the wall: > > Am 27.06.2012 17:40, schrieb Jay A. Kreibich: > > >On Wed, Jun

Re: [sqlite] HTML5 database commands as a JavaScript-SQLite bridge

so far) included in this all-in-one executable (no installation required), freely available for most popular OS at www.jsdb.org. Etienne P.S. I am not linked to JSDB's author, Shanti Rao. - Original message - From: Simon Slavin <slav...@bigfraud.org> To: General Discussion of SQLi

[sqlite] VERY weird rounding error

amp;& exp<=350 ){ realvalue *= 1e-4; exp+=4; } if( realvalue>=1e2 && exp<=350 ){ realvalue *= 1e-2; exp+=2; } if( realvalue>=10.0 && exp<=350 ){ realvalue *= 0.1; exp++; } I trust you guys, for fixing SQLite smoothly. A big thank you for your patch Keith. Keep up the very good work Etienne ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] VERY weird rounding error

-loleaut32 -lmapi32 -lcomdlg32 -luuid -lwinmm -static -lstdc++ while I simply build the SQLite exec with "gcc -o SQLite.exe sqlite3.o shell.o". Is there a trick (in the sys. libraries mentioned above, or through the win32 C API) for changing the way the FPU han

[sqlite] VERY weird rounding error

to different shells. Etienne - Original message - From: Simon Slavin <slav...@bigfraud.org> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: Re: [sqlite] VERY weird rounding error: details Date: Sat, 16 Jun 2012 18:13:29 +0100 On 16 Jun 2012, at 5:4

[sqlite] VERY weird rounding error: details

art diverging (29468/18099 = +/-60%) from the second pass! This divergence leads to a rounding error in the second case (JSDB), while SQLite(shell) properly displays the ("faked") result. So same input, same byte code... and different results! Who the heck said IT is determinist? Does anybody

[sqlite] (shell dependent) library rounding error

using SQLite. The other time you are writing the result using a > 'writeln()' command. There is no 'writeln()' command in SQLite. THE PROBLEM OCCURS AT SQLITE LEVEL! The caller does not matter. Behaviors diverge from sqlite3(071300).c: line 19911 (var "realvalue") very precisely. Regards, Etienne ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] (shell dependent) library rounding error

" (e.g. SQLite library - same compiler options etc.), I am just waiting for the same (fake) result. IT was determinist... so far. Why is SQLite able to "hide" the error in one case and not in the other case? Because they are slightly DIFFERENT! How is it possible? Regards, Eti

[sqlite] (shell dependent) library rounding error

xp--; } --- Adding intermediate exp power(s) of 2 (between 8 and 1) in the lines above does fix the problem, e.g.: (...) if( realvalue>=1e4 && exp<=350 ){ realvalue *= 1e-4; exp+=4; } (...) However I still do not know why the same