Hello List,
I have a strange problem with a statement like
select id from some_table where coalesce(some_col, 1) = :1
where :1 is a bind variable which i bind in my program using
sqlite3_bind_text.
I get no records, even if there are no null values anywhere in some_col.
I get the expected records if i replace "coalesce(some_col, 1)" with
"some_col", and also if i replace the bind variable with a constant.
It does not seem to matter how the column was defined in the "create
table" statement, and changing "coalesce(some_col, 1)" to
"coalesce(some_col, '1')" did not help.
My version is 3.8.5, the database was created with this version.
I also tried with version 3.7.4, the result was the same.
I am quite sure that i use sqlite3_bind_text correctly, because i use my
own C++ layer which is tested very well and has been working for several
years.
Have I missed something?
Thank you
Martin
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
