brianchandotcom/liferay-portal — pull request #8259 by shuyangzhou (2012-12-27 10:09:46+00:00)
Title: LPS-31977 Create unit test to show SQL NULL comparison difference across...

... different databases

@sophia6497

Hey Brian,

After your review, please assign the ticket to sophia. She has been helping me to set up all the databases for testing in the last couple days. She has the env to run through the test against all the dbs.

Base on the test results, now we have a solid ground to refactor the finder sqls to avoid a lot of annoying where condition. For example, XXX LIKE null OR null IS NULL, because now we know for sure (null IS NULL) = TRUE on all dbs.

Thanks!