CodePudding user response:

All other are all the same only the SQL of the two different data

Hibernate: select * from special_v where (code='10' or code='11') ORDER BY code DESC
[{CODE=11, NAME=Workers below 18 years old}, {CODE=10, NAME=Construction/temporary Workers}]


Hibernate: select * from special_v where (code='10' or code='11') ORDER BY code DESC
[{CODE=11, NAME=the party work department}, {} CODE=10, NAME=company office]

CodePudding user response:

Delete the two data, and see what is the correct query result,

CodePudding user response:

Elder brother, do you mean by hb deployed on the server and local debugging results is not the same, you call operations up sqlplus execution on the server, this machine you use PLSQL dev execution, if the same, that is pristine hb look have what file, if not the same, even the same user that you see clear

CodePudding user response:

If confirm on both sides of the SQL, so there must be other differences, such as login user name, or a database,
Take a closer look at, there must be some different place,

CodePudding user response:

May also be on the server has not committed transaction,

CodePudding user response:

If there are any uncommitted data commit try;