[sqlite] (BUG) sqlite cannot search for text, if inserted via sqlite3_bind_blob

2017-03-12 Thread sqlite
In my endless obsession with premature optimization, I've been using sqlite3_bind_blob, whenever I know the length of what I'm inserting, even if it's text or whatnot. It exhibits some very strange properties though, which I can't imagine is anything other than a bug. Here's my test case:

[sqlite] (BUG?) sqlite3_bind_blob oops, not exactly a bug

2017-03-12 Thread sqlite
Darn it! Sorry! I forgot to reset my prepared select statement. My whole example was screwed up. The actual behavior is at least sensible-ish, but still not quite right. If you use sqlite3_bind_blob on insert and select, it will successfully find the test row. Only mixing sqlite3_bind_blob, and

[sqlite] ntermittently crashes seen when sqlite3_prepare_v2 called with sqlite version 3.15.2

2017-03-12 Thread ROCHAK GUPTA
Hello, I am using sqlite as library in multi-threaded environment where multiple applications use sqlite queries to perform get/set operations on attributes available in sqlite db tables. Intermittently i am seeing applications crashing when get operation is performed which intern call

Re: [sqlite] (BUG?) sqlite3_bind_blob oops, not exactly a bug

2017-03-12 Thread Dominique Devienne
> > If you use sqlite3_bind_blob on insert and select, it will successfully > find the > test row. Only mixing sqlite3_bind_blob, and sqlite3_bind_text causes these > mysterious failures. Does sqlite3_bind_text... encode it to UTF-16 or > something? > > This is still a (moderately) huge problem

[sqlite] Result error in System.Data.SQlite COLLATE NOCASE

2017-03-12 Thread andrea-...@libero.it
Hello everybody, I've a simple select statement that have expected result in DB Browser for SQLite (82 rows).Same statement return an error in VB.NET using System.Data.SQLite (164 rows) Statement is: SELECT * FROM [tblDictionary] INNER JOIN [tblLanguage] ON [tblDictionary].[idLanguage] =

Re: [sqlite] Result error in System.Data.SQlite COLLATE NOCASE

2017-03-12 Thread Simon Slavin
On 12 Mar 2017, at 7:21pm, andrea-...@libero.it wrote: > I've a simple select statement that have expected result in DB Browser for > SQLite (82 rows).Same statement return an error in VB.NET using > System.Data.SQLite (164 rows) Please try the same SELECT command using the SQLite Command

[sqlite] R: Re: Result error in System.Data.SQlite COLLATE NOCASE

2017-03-12 Thread andrea-...@libero.it
Thanks for replay. I've tried now with SQLite Command Line Shell, 82 rows as expected (like DB Browser for SQLite). Same query in VB,net 124 rows (???) >Messaggio originale >Da: "Simon Slavin" >Data: 12/03/2017 20.36 >A: "SQLite mailing

Re: [sqlite] R: Re: Result error in System.Data.SQlite COLLATE NOCASE

2017-03-12 Thread Simon Slavin
On 13 Mar 2017, at 5:11am, Simon Slavin wrote: > The SQLite command line shell tool is written and maintained by the SQLite > developer team. If there’s a but in it they’ll fix it. However, DB Browser > for SQLite is not and faults in it should be reported to whoever

Re: [sqlite] ntermittently crashes seen when sqlite3_prepare_v2 called with sqlite version 3.15.2

2017-03-12 Thread Simon Slavin
On 12 Mar 2017, at 2:34am, ROCHAK GUPTA wrote: > I am using sqlite as library in multi-threaded environment where multiple > applications use sqlite queries to perform get/set operations on attributes > available in sqlite db tables. Intermittently i am seeing

Re: [sqlite] R: Re: Result error in System.Data.SQlite COLLATE NOCASE

2017-03-12 Thread Simon Slavin
On 13 Mar 2017, at 5:04am, andrea-...@libero.it wrote: > > I've tried now with SQLite Command Line Shell, 82 rows as expected (like DB > Browser for SQLite). > Same query in VB,net 124 rows (???) This throws strong suspicion on where the problem lies. The SQLite command line shell tool is