[sqlite] SQLDIFF problem

2015-12-01 Thread Richard Hipp
On 12/1/15, jungle Boogie wrote: > On 30 November 2015 at 06:27, Richard Hipp wrote: >>> Just curious. Why does SQLite allow those? Legacy (i.e. >>> backward-compatibility)? Valid in ANSI SQL? --DD >> >> I don't know if it is valid ANSI SQL or not. But SQLite has always >> allowed it, so we

[sqlite] SQLDIFF problem

2015-12-01 Thread jungle Boogie
On 30 November 2015 at 06:27, Richard Hipp wrote: >> Just curious. Why does SQLite allow those? Legacy (i.e. >> backward-compatibility)? Valid in ANSI SQL? --DD > > I don't know if it is valid ANSI SQL or not. But SQLite has always > allowed it, so we have to support it now for legacy. How

[sqlite] sqldiff ---primarykey bug

2015-12-01 Thread Stuffer Oskar
On 11/30/2015 06:54 PM, Richard Hipp wrote: > On 11/30/15, Stuffer Oskar wrote: >> Hallo, >> >> I'm using the sqldiff tool with the --primarykey option to generate a diff >> between two databases >> with the "WITHOUT ROWID" optimization. >> sqldiff from sqlite 3.9.1 and 3.9.2 produces SQL

[sqlite] sqldiff ---primarykey bug

2015-12-01 Thread Stuffer Oskar
> This mailing list strips attachments. But I wonder your suggested > patch has not already been implemented at > https://www.sqlite.org/src/info/e0ed4c3e376248df - can you check and > see please. You are right, the patch I suggested is already implemented at

[sqlite] [Sqlite3] segfault in sqlite3_step()

2015-12-01 Thread 김수민
hi. My program received signal SIGSEGV during performed to sqlite_step(). It was occurs only one time still.. but I should know cause. so I need help you. please. *Code:* *// Already prepared statement using sqlite3_prepare_v2(db, QUERY, -1, , NULL).* *{* *sqlite3 *db;* *sqlite3_stmt

[sqlite] SQLite3 API

2015-12-01 Thread Cousin Stanley
>> Any plans for distribution of your cobol/sqlite interface ? > > The SQLite3 Interface for GnuCOBOL [sql3i4gc] > will soon be available from the Contribution area > of the GnuCOBOL Project > > > > It is being released under the GNU

[sqlite] SQLite - Support for VSS writer

2015-12-01 Thread Murdare, Vijaykumar S (GE Oil & Gas)
Hi, We are planning to use windows VSS ((Volume Shadow Copy) feature for backup & restore SQLite databases. I would like to know, does SQLite support VSS (Volume Shadow Copy Service) writer supported by the Windows Operating system to create point in time consistent shadow copies (snapshots)

[sqlite] SQLite - Support for VSS writer

2015-12-01 Thread Keith Medcalf
It will support the same power-fail consistency as any other non-VSS aware application. That is, VSS will function as designed -- it will "look" like you "turned off the power" and then did an "offline" backup -- the resulting backup will be crash consistent. Like any product that uses

[sqlite] How hard is it to add the constraint name to the 'FOREIGN KEY constraint failed' message?

2015-12-01 Thread Simon Slavin
On 1 Dec 2015, at 12:55am, Yuri wrote: > On 11/23/2015 07:55, James K. Lowden wrote: >> As a matter of fact, violation of UNIQUE & PK constraints is enforced >> rather too strictly in SQLite. Any UPDATE statement that modifie more >> than one row of a UNIQUE column can fail because two rows