Affects Version/s: 7.0.X, 7.1.X, Master
Component/s: ~[Archived] WCM
Steps to reproduce:
1) Set up Liferay bundle 6.1 GA3 with database Oracle 12.1
2) Start the portal
3) Create 1 structure of JournalArticle, add an article with this structure (check the db for classTypeId of the asset)
4) Performed the upgrade to Liferay DXP fix-pack-de-50-7010
5) Check the classTypeId of the Asset again.
expected result: the classTypeId should be changed
actual result: the classTypeId is still the same
Root cause: SQL queries that have "<column> != '' " comparisons should use the SQLTransformer, as on Oracle DBs the result of the comparison is "unknown" (https://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements005.htm"