'Same record has different values depending on WHERE statement in OPENQUERY

The query is

select * from openquery ([CRM_PROD], '
select
r.SR_NUM Request_num
, r.DESC_TEXT Description
,r.CREATED
,r.ROW_ID
from SIEBEL.S_SRV_REQ r 
where
r.TEMPLATE_FLG <> 'Y'
and
(r.CREATED between to_date('16.03.2022 09:20:00', 'dd.mm.yyyy  hh24:mi:ss') and to_date('16.03.2022 11:30:00', 'dd.mm.yyyy  hh24:mi:ss'))
order by r.SR_NUM')

and the second one is pretty the same, but the only difference is that the last datetime equals 10:30:00 instead of 11:30:00

And they returns the same record with the same id, but description column values are different(column type is CLOB). Not null and a normal description, but 2 different description. And I don't understand how is it even possible.

The database is Oracle and they access it with MS SQL

sqldatabaseoracleopenquery


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions