Re: [sqlite] Bug in trigger: when comparing a value of an int column to a quoted value

2011-12-26 Thread Alexey Pechnikov
Of cource you may report your bug! But I'm not sure about possibility of the bugfix in upstream and so I speak about patch to SQLite binding for your language. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list

Re: [sqlite] Bug in trigger: when comparing a value of an int column to a quoted value

2011-12-25 Thread romtek
Alexey, I am not clear about whether you reported my bug or yours. Do you mind giving me a link to it so that I could see if I need to report mine and let it go? On Sun, Dec 25, 2011 at 11:16 AM, Alexey Pechnikov wrote: > I think there are some problems with dynamic

Re: [sqlite] Bug in trigger: when comparing a value of an int column to a quoted value

2011-12-25 Thread Alexey Pechnikov
I think there are some problems with dynamic datatypes in sqlite. This may be redesigned in SQLite4 but not in SQLite3. P.S. Datatypes recognized differently after Shift-Insert SQLite3 commands into Tcl shell. This is similar to problem with datatypes in triggers. I did report bug but for

Re: [sqlite] Bug in trigger: when comparing a value of an int column to a quoted value

2011-12-24 Thread romtek
So, you also think this is a bug? I will submit it to the SQLite bug database. On Wed, Dec 21, 2011 at 7:42 AM, Alexey Pechnikov wrote: > The problem can be fixed by variables bindings patch: > http://sqlite.mobigroup.ru/wiki?name=tclsqlite > I think, you can do same for

Re: [sqlite] Bug in trigger: when comparing a value of an int column to a quoted value

2011-12-21 Thread Alexey Pechnikov
The problem can be fixed by variables bindings patch: http://sqlite.mobigroup.ru/wiki?name=tclsqlite I think, you can do same for you lang. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Bug in trigger: when comparing a value of an int column to a quoted value

2011-12-19 Thread romtek
On Mon, Dec 19, 2011 at 11:23 PM, Roger Binns wrote: > > > On 19/12/11 20:31, romtek wrote: > > As you can see, isActive is declared as an integer in table2, > > > This type of thing worked for years with an older version of SQLite > > library > > Are you sure? Absolutely.

Re: [sqlite] Bug in trigger: when comparing a value of an int column to a quoted value

2011-12-19 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 19/12/11 20:31, romtek wrote: > As you can see, isActive is declared as an integer in table2, That declaration only does type coercion on the value stored in the database (if appropriate). > ... when I expect it to be activated ... Why would you

Re: [sqlite] Bug in trigger: when comparing a value of an int column to a quoted value

2011-12-19 Thread Nico Williams
On Mon, Dec 19, 2011 at 10:31 PM, romtek wrote: > I've always thought that because SQLite didn't enforce data types, I could > do what I have in the example, and this has worked! So, is this a bug in > more recent versions of SQLite or an intended change that I am unaware of?

[sqlite] Bug in trigger: when comparing a value of an int column to a quoted value

2011-12-19 Thread romtek
Hi, I would like to know if I am dealing with a bug or a backward incompatible change that I am not aware of. Consider this example: CREATE TABLE [table2] ( [id] INTEGER NOT NULL ON CONFLICT FAIL PRIMARY KEY ON CONFLICT FAIL AUTOINCREMENT, [isActive] INTEGER NOT NULL ON CONFLICT FAIL