Displaying 1 result from an estimated 1 matches for "jfsm".
Did you mean:
jfs
2009 Mar 27
0
consistent segfaults in ROracle with one of the databases
...you cannot run it, but maybe someone spots a certain
pattern in it:
SELECT TIMESTAMP, VALUE, VM FROM
(WITH ev AS
(SELECT audit_key_new key, audit_date dt, audit_batch_nbr,
audit_date
FROM dots_audit.audit_event
WHERE table_name='VALUE_PROPERTY_MAP'),
jfsm AS
(SELECT audit_key, fund_id, fund_mult
FROM dots_audit.value_property_map WHERE property_id='%s'
UNION SELECT audit_key, value_id, value_mult
FROM dots.value_property_map WHERE property_id='%s')
SELECT DISTINCT
ev.dt - to_date(&...