Re: [sqlite] UPDATE SET using column-name-list Syntax error

2017-12-10 Thread javaj1...@elxala.com
Richard Hipp wrote: On 12/10/17, javaj1...@elxala.com wrote: According to the documentation UPDATE SET admits column-name-list as argument but I cannot get it working. Here some tries DROP TABLE IF EXISTS test; CREATE TABLE test(a,b,c); -- ok UPDATE test SET a = "vala", b = "

[sqlite] UPDATE SET using column-name-list Syntax error

2017-12-10 Thread javaj1...@elxala.com
Hi, According to the documentation UPDATE SET admits column-name-list as argument but I cannot get it working. Here some tries DROP TABLE IF EXISTS test; CREATE TABLE test(a,b,c); -- ok UPDATE test SET a = "vala", b = "valb" ; UPDATE test SET a = (SELECT "vala"), b = (SELECT "valb") ; -- not

[sqlite] comparing a blob with a file (samefilecontent function proposal)

2016-05-31 Thread javaj1...@elxala.com
Hi, In one application I am using sqlite database as file container I found very convenient to have a new function that permits comparing the contents of a blob and a file directly. I've coded that function and it is tested successfully So this is my proposal for adding this new function in sq

[sqlite] Question about BerkeleyDB "SQLited"

2016-02-22 Thread javaj1...@elxala.com
yes, you are right, I actually have the same version, two years old anyway The feature I was missing is "savefile and writefile" functions for blob fields which comes I think in 2014-06 (http://www.sqlite.org/src/finfo?name=ext/misc/fileio.c) So for that problem, probably it is enough adding filei

[sqlite] Question about BerkeleyDB "SQLited"

2016-02-21 Thread javaj1...@elxala.com
Hi, Oracle is distributing its BerkeleyDB including an interesting fusion with SQLite where they take all from SQLite except the final storage engine b-tree and pager included. As a product it is possible to obtain a dbsql binary that is a clone of sqlite3 command line but working with BDB data

[sqlite] BUG in 3.8.8.3 and pre-release: Wrong ERROR_DISK_FULL writing a blob on Windows

2015-03-16 Thread javaj1...@elxala.com
R.Smith wrote: > > > On 2015-03-16 12:49 AM, javaj1811 at elxala.com wrote: >> Hi Joe, >> >> good point, I've tested the fail scenario having the database located >> in a NTFS disk with the result of NO FAIL!!! >> so the insertion was done without sqlite error. >> now the problem seems to be reduc

[sqlite] BUG in 3.8.8.3 and pre-release: Wrong ERROR_DISK_FULL writing a blob on Windows

2015-03-15 Thread javaj1...@elxala.com
javaj1811 at elxala.com wrote: > Joe Mistachkin wrote: >> What file system is being used on the drive in question (e.g. FAT, >> FAT32, >> NTFS, etc)? >> >> -- >> Joe Mistachkin >> >> ___ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlit

[sqlite] BUG in 3.8.8.3 and pre-release: Wrong ERROR_DISK_FULL writing a blob on Windows

2015-03-15 Thread javaj1...@elxala.com
Joe Mistachkin wrote: > What file system is being used on the drive in question (e.g. FAT, FAT32, > NTFS, etc)? > > -- > Joe Mistachkin > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/

[sqlite] BUG in 3.8.8.3 and pre-release: Wrong ERROR_DISK_FULL writing a blob on Windows

2015-03-15 Thread javaj1...@elxala.com
javaj1811 at elxala.com wrote: > ales at elxala.de wrote: >> Hi, this is actually a Ticket, the good new is that is already >> pre-analyzed >> and probably also the cause has been found. >> I hope this is the right place to put this >> >> TITLE: Wrong ERROR_DISK_FULL writing a blob on Windows >> >

[sqlite] BUG in 3.8.8.3 and pre-release: Wrong ERROR_DISK_FULL writing a blob on Windows

2015-03-15 Thread javaj1...@elxala.com
ales at elxala.de wrote: > Hi, this is actually a Ticket, the good new is that is already > pre-analyzed > and probably also the cause has been found. > I hope this is the right place to put this > > TITLE: Wrong ERROR_DISK_FULL writing a blob on Windows > > DESCRIPTION: > >Having a sqlite dat

[sqlite] BUG Report on sqlite 3.6.20 "Error in SQL parser between sqlite3.3.4 and sqlite3.6.20"

2009-12-29 Thread javaj1...@elxala.com
Hello, I detect this problem because a program using sqlite command line works on sqlite.3.3.4 but it does not anymore using sqlite3.6.20 PROBLEM TITLE: Unjustified Error joining tables in sqlite3.6.20 (in previous version sqlite3.3.4 OK) OR Error in SQL parser b