shuyangzhou/liferay-portal — pull request #368 by sammso (2013-08-13 18:38:18+00:00)
Title: LPS-38956

Hi Shuyang,

This is fix for DB2Dialect

LPS-38956 is sub task of LPS-37841. I did divide the LPS-37841 subtask since there where 3 different issues causing the problem and they are top of each other on call hierarchy, I decided to fix all of them and handle them on separate issues. Other two sub tasks are LPS-38959 and LPS-38960.

1. commit 9af4e79ad39fc0f20037ea83d330b5d3df80dee1 is just to add integration test to verify the problem with DB2Dialect.

The real fix is at dc8a871470f99fbdee73acee3ac21b2f27ede8d7 where we just want to fetch 0 rows (so that's why odd looking 1=2 at where statement).

Last commit 859dc284305fbef04445c56d98ddd56448f778db is as I was doing test for the LPS-38959, I got trouble since the since original solution was forcing ROW NUMBER to be first column of result set. I thought it would be better to be last column as I could not find a way to take it totally away from resultset.

I have tested this issue and it is also resolving the LPS-37841.