I just want to confirm that $null does not cause subqueries to be dropped. For example, if my where clause reads "where id in (select id from tbl where col = $col)" and $null = '' and $col = '', then the subquery does not get dropped in the same way that a part of the where clause would get dropped. I am on Texis version 3.01.959738425.
Right, the entire subquery does not go away, only the part of the where clause with the null variable. The query with $null set would be equivalent to:
