Re: [sqlite] Strange Behavior in Memsys5 Allocator

On Tue, Aug 13, 2013 at 4:33 PM, Andrew Beal wrote: > Hi All, > > I have noticed a strange infinite loop in the memsys5 allocator functions. > I am trying to track it down and was wondering if anyone else has seen this > issue before. > Never seen before. Please let us know if

Re: [sqlite] System.Data.SQLite version 1.0.88.0 released

Jan Slodicka wrote: > > Why the value getters (sqlite3_column_int() etc., but also some other > functions such as sqlite3_column_name()) do not check for errors? SQLite > documentation mentions at least possible memory problems. Wouldn't it be > reasonable to check for those an throw an

[sqlite] Strange Behavior in Memsys5 Allocator

Hi All, I have noticed a strange infinite loop in the memsys5 allocator functions. I am trying to track it down and was wondering if anyone else has seen this issue before. In memsys5UnlinkFirst, I am watching the values of i and iFirst oscillate back and forth with no progress being made to

[sqlite] Hotel Room Rate Reminder - 20th Annual Tcl/Tk Conference (Tcl'2013)

20'th Annual Tcl/Tk Conference (Tcl'2013) http://www.tcl.tk/community/tcl2013/ September 23 - 27, 2013 Bourbon Orleans Hotel New Orleans, Louisiana, USA http://www.bourbonorleans.com/ Hello all. This is a general reminder that the offer of reduced rates for rooms at the conference hotel expires

Re: [sqlite] Number of Colum!!!

On Aug 13, 2013, at 4:11 PM, techi eth wrote: > Trigger Logic!!! > Default Constraint Behaviour!!! > sqlite3 error string size!!! > Number of Colum!!! > What's up with the triple exclamation marks since July 22nd? ___

Re: [sqlite] Number of Colum!!!

The limit of 64 columns for a covered index to work should really go on that page too. :( -David -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jay A. Kreibich Sent: Tuesday, August 13, 2013 7:19 AM To: General Discussion

[sqlite] (sqlite >=3.7.11) Rolling back a transaction doesn't release a lock caused by pending statements

Hi everyone, I'm trying to understand what's going on in sqlite starting from version 3.7.11 when a transaction rolls back and there are pending statements. The changelog for 3.7.11 states: Pending statements no longer block ROLLBACK. Instead, the pending statement > will return SQLITE_ABORT

Re: [sqlite] Number of Colum!!!

On Tue, Aug 13, 2013 at 07:41:25PM +0530, techi eth scratched on the wall: > Is their any limit on number of Colum in SQLite3 table? Yes. http://www.sqlite.org/limits.html#max_column -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important

Re: [sqlite] Number of Colum!!!

On 13 August 2013 15:11, techi eth wrote: > Is their any limit on number of Colum in SQLite3 table? > > Cheers - > > Techi ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Number of Colum!!!

Is their any limit on number of Colum in SQLite3 table? Cheers - Techi ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Submit patch?

Well, I just did a successful initial port to z/OS release 1.13 UNIX . I don't know how long I will have access to the system that I did this on. It likely depends on how long the person who rents it from IBM keeps it. But I would be willing to do testing as I have time from doing my regular job.

Re: [sqlite] Create DB in SDRAM FOLDER

Gianni Sassanelli wrote: > I need to create DB in a SDRAM Folder This has nothing to do with SQLite itself. > 2) I don't want delete db If I uninstall my main app So you think your app is more important than your users think? Whatever, the SD card can be erased easily ... > I solve this

Re: [sqlite] System.Data.SQLite version 1.0.88.0 released

Rather a question than a problem: Why the value getters (sqlite3_column_int() etc., but also some other functions such as sqlite3_column_name()) do not check for errors? SQLite documentation mentions at least possible memory problems. Wouldn't it be reasonable to check for those an throw an

Re: [sqlite] What can be deduced from integrity check

I am in process of checking everything possible and impossible and this point is on the list:) But in general the (system.data.sqlite) C# wrapper is constructed so that it throws an exception every time something goes wrong. However, I see some shortcomings in this layer such as for example

Re: [sqlite] What can be deduced from integrity check

On 13 Aug 2013, at 1:18pm, Jan Slodicka wrote: > The same NOCASE implementation is used for all database operations. > > I am aware of the consequences of an incorrect collation implementation. > However, I do not believe that they could explain index reference to records >

Re: [sqlite] What can be deduced from integrity check

The same NOCASE implementation is used for all database operations. I am aware of the consequences of an incorrect collation implementation. However, I do not believe that they could explain index reference to records that were deleted. Do you have any explanation for this problem? -- View

Re: [sqlite] SQLite Input with validation and lookup

On 13 Aug 2013, at 8:56am, Stephen Hughes wrote: > Thanks Stephen, Simon & Kees for your replies all of which indicate that > I am starting from the wrong place, in that it is the built-in > programming capabilities of Visual FoxPro that I was using rather than > its Database

Re: [sqlite] What can be deduced from integrity check

On Tue, Aug 13, 2013 at 7:19 AM, Jan Slodicka wrote: > > "Sync action"? What's that? > More details: > WAL mode > sqlite 3.7.15.2 > sqlite C# interface based on system.data.sqlite package > custom NOCASE collation, custom encryption > The application serves as mobile CRM client.

Re: [sqlite] What can be deduced from integrity check

> "Sync action"? What's that? Local database is synchronized with remote DB. Synchronization goes table by table (all table operations are grouped into a transaction) in several iterations. The algorithm is very complex, but in the final step all DB operations are linearized and executed on a

Re: [sqlite] How to detect full table scan?

On 08/13/2013 02:28 PM, Sqlite Dog wrote: We are using SQLite 3.7.17 Maybe you can use this stuff: http://www.sqlite.org/c3ref/stmt_status.html http://www.sqlite.org/c3ref/c_stmtstatus_counter.html In particular SQLITE_STMTSTATUS_FULLSCAN_STEP. Dan. 2013/8/13 Sqlite Dog

Re: [sqlite] SQLite Input with validation and lookup

Thanks Stephen, Simon & Kees for your replies all of which indicate that I am starting from the wrong place, in that it is the built-in programming capabilities of Visual FoxPro that I was using rather than its Database Engine. Without wishing to digress into which is the best programming language

[sqlite] Create DB in SDRAM FOLDER

Hi expert I need to create DB in a SDRAM Folder because i need to feature: 1) I need to get access to db from other different application 2) I don't want delete db If I uninstall my main app I solve this question whit sqllite plugin but it is not full supported with 2.3 and 3.0 api of

Re: [sqlite] How to detect full table scan?

We are using SQLite 3.7.17 2013/8/13 Sqlite Dog > What is a best way to detect that query does full table scan? Considering > this (from http://www.sqlite.org/eqp.html ): > > "Warning: The data returned by the EXPLAIN QUERY PLAN command is intended > for interactive

[sqlite] How to detect full table scan?

What is a best way to detect that query does full table scan? Considering this (from http://www.sqlite.org/eqp.html ): "Warning: The data returned by the EXPLAIN QUERY PLAN command is intended for interactive debugging only. It may change dramatically between SQLite releases. Applications should

[sqlite] SQLite bug: building/running SQLite on Cygwin64

For details, see below. Here is a new patch, which applies the MAX_PATH fix in os_win.c to Cygwin as well. Additional remark: This is not a bug in Cygwin64: calling win32 functions from Cygwin executables is unsupported even though it normally works fine (GetTempPath apparently is one of the