• [Info-ingres] E_US16D5 Table specified no longer exists

    From Roy Hann@21:1/5 to you on Tue Dec 15 12:27:59 2020
    I didn't stir up any responses to this post just over a year ago. The
    issue has resurfaced at a customer site so I am still curious about
    it. The following reproduces in Ingres 11.0 and as far back as Ingres
    10.1 (which is as far as I could go).
    ---------------------- 8<--------------------------------------------
    create table foo_tbl (keycol char(9) not null, good_stuff i1 not null)
    \g
    create table bar_tbl (keycol char(9) not null, other_stuff i1 not null)
    \g
    commit
    \g
    create view nice_view as select f.keycol
    from foo_tbl f left join (select * from bar_tbl b ) x using (keycol)
    \g
    commit;
    \g
    -- this will fail with E_US16D5
    alter table foo_tbl drop column good_stuff cascade;
    \g
    drop view nice_view;
    \g
    -- this will work
    alter table foo_tbl drop column good_stuff cascade;
    \g
    ---------------------- 8<--------------------------------------------

    Thursday, September 26, 2019, 11:02:40 AM, you wrote:

    This re Ingres SPARC SOLARIS Version II 11.0.0 (su9.us5/100)

    * alter table medical drop column m_length cascade \g
    Executing . . .

    E_US16D5 Table specified no longer exists.
    (Thu Sep 26 10:34:53 2019)

    A bit of googling tells me this error has cropped up once or twice in
    the past but none of the past cases seem relevant, e.g. there are no constraints involved.

    Obviously I am wondering how to get past it, but my question here is why
    I would ever get an error message that something "no longer" exists?
    Surely to the DBMS a thing exists or it doesn't. Why the reference
    to a past state of which it should be (or at least should seem to be) oblivious?

    --Roy


    _______________________________________________
    Info-ingres mailing list
    Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres



    Roy Hann
    Rational Commerce Ltd.
    T +44 20 8691 2089
    "Ingres development, tuning, and training experts"

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Karl Schendel@21:1/5 to Roy Hann on Tue Dec 15 17:26:16 2020
    To: info-ingres@lists.planetingres.org (Ingres and related product discussion forum)

    On Dec 15, 2020, at 7:27 AM, Roy Hann <roy.hann@rationalcommerce.com> wrote:

    I didn't stir up any responses to this post just over a year ago. The
    issue has resurfaced at a customer site so I am still curious about
    it. The following reproduces in Ingres 11.0 and as far back as Ingres
    10.1 (which is as far as I could go).
    [snip]
    * alter table medical drop column m_length cascade \g
    Executing . . .

    E_US16D5 Table specified no longer exists.
    (Thu Sep 26 10:34:53 2019)

    Obviously I am wondering how to get past it, but my question here is why
    I would ever get an error message that something "no longer" exists?

    This one turns out to be interesting. The dependency checker in QEF is mis-handling
    the derived table in the view definition, as near as I can tell. Please open an
    issue on this one.

    The error message is a generic QEF translation from E_DM0054 "Nonexistent table".
    Apparently QEF is assuming that an operation shouldn't make it into execution if it involves a table that truly exists, so it's assuming that something happened
    between parse and execution to lose the table.

    At least it's better than my least favorite error message ever:
    "That table is in use. Close that table and try again."

    (which is still there, but at least tells you the table name now!)

    Karl

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Roy Hann@21:1/5 to Karl Schendel on Wed Dec 16 10:05:55 2020
    Karl Schendel wrote:

    This one turns out to be interesting. The dependency checker in QEF is mis-handling
    the derived table in the view definition, as near as I can tell. Please open an
    issue on this one.

    I'll see what I can do to get one opened.

    Thank you for the response.

    Roy

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)