Well, it looks like the ACS3.2.x is pretty clean. In my ACS3.2.x installation I found the following files with problems:
tcl/ad-user-contributions-summary.tcl
tcl/ticket-defs.tcl-old
tcl/ticket-todo-plugin.tcl
tcl/rf-randompix.tcl
www/photodb/search.tcl
www/admin/news/index.tcl: case when ng.group_id=NULL then 0 else ng.group_id end as group_id,
www/admin/categories/add-link-to-parent.tcl: where category_hierarchy_level($category_id, h.child_category_id, 0) != null"]
The command I used for finding them was:
find . -regex '.*(sql|adp|tcl)' | xargs egrep -ri '[^:]= ?null'
This doesn't filter out the UPDATEs but its a managable list.
Cheers,
Carl C-M
