[Info-ingres] Error on drop view

[Martin Bowes]

Hi All,

On II 10.2.0 (a64.lnx/100) +p15268

* DROP VIEW IF EXISTS hesin_diag10_8009\g
E_RD0003 RDF function was called with bad parameters.
    (Wed Jun  6 10:30:26 2018)

E_SC0206 An internal error prevents further processing of this query.
    Associated error messages which provide more detailed information about
    the problem can be found in the error log, II_LOG:errlog.log
    (Wed Jun  6 10:30:26 2018)

The view is perfectly accessible and functional.
* help view hesin_diag10_8009\g
View:                 hesin_diag10_8009
Owner:                ace
Check option:         off

View Definition:
create view  hesin_diag10_8009 AS
SELECT r.eid, d.record_id, d.arr_index, d.diag_icd10
FROM "ace". regapp r, "ace". hesin_diag10_pure d
WHERE r.reg_id = d.reg_id
  AND r.app_id = 8009

select count(*) from hesin_diag10_8009\g
┌─────────────┐
│col1         │
├─────────────┤
│      4606470│
└─────────────┘
(1 row)

I've tried a trace point rd010 and the effect is the same.

Martin Bowes
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20180606/d1b50181/attachment.html>