Hi Luis, Those are parameters.
This is the query after replacing with ?1 and ?2. delete from emp where key = '123' and (case when name = 'abc' is null THEN 1 else name = 'abc' end); It covered "delete from emp where key = '123' and name = 'abc';" but not other query. I tried with "select (case when name = 'abc' is null THEN 1 else name = 'abc' end) from emp;" query. It's always going to else portion when 'abc' doesn't exist in table. Any suggestions? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
