On Wed, Aug 6, 2014 at 11:29 AM, Martin Engelschalk < [email protected]> wrote:
> 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. > I am unable to reproduce the problem. Everything works as expected when I try it. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
