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] sqlite3_column_text() returning partial results

2011-12-25 Thread Igor Tandetnik
Matt Young wrote: > I used the strcpy_s function from Microsoft, the so called safe version > that includes a char count. I used it under the Studio debugger. Set a > buffer of 200 chars to zero, set the char count to 20 in strcpy_s, and the > debugger wrote in the top

Re: [sqlite] sqlite3_column_text() returning partial results

2011-12-25 Thread Matt Young
I used the strcpy_s function from Microsoft, the so called safe version that includes a char count. I used it under the Studio debugger. Set a buffer of 200 chars to zero, set the char count to 20 in strcpy_s, and the debugger wrote in the top 180!! I freaked, didn't see that as safe at all! On

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