1. Forum
  2. Usenet
  3. COMP.DATABASES.INGRES

  • E_OP068C A bad select (or subselect) target list has been found

    From nikosv@21:1/5 to All on Tue Mar 2 02:18:06 2021
    Anyone seen this error ?
    v10.2.0

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Paul White@21:1/5 to nikosv on Wed Mar 3 07:11:48 2021
    To: info-ingres@lists.planetingres.org

    This is a multi-part message in MIME format.
    Hi Nikos,

    Can you give us a bit more info? I've not seen it on any of my servers.
    Found this:

    Patch P14944 07Jan2016

    Bug 122604 (GENERIC)

    Star server reports E_OP068C and E_OP068A error when running a query
    that contains a sub-select statement against a remote non-ingres database.


    On 2/03/2021 8:18 pm, nikosv wrote:
    Anyone seen this error ?
    v10.2.0
    _______________________________________________
    Info-ingres mailing list
    Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    </head>
    <body>
    <p style="color: rgb(0, 0, 0); font-family: &quot;Times New
    Roman&quot;; font-size: medium; font-style: normal;
    font-variant-ligatures: normal; font-variant-caps: normal;
    font-weight: 400; letter-spacing: normal; orphans: 2; text-align:
    start; text-indent: 0px; text-transform: none; white-space:
    normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width:
    0px; text-decoration-thickness: initial; text-decoration-style:
    initial; text-decoration-color: initial;">Hi Nikos,</p>
    <p style="color: rgb(0, 0, 0); font-family: &quot;Times New
    Roman&quot;; font-size: medium; font-style: normal;
    font-variant-ligatures: normal; font-variant-caps: normal;
    font-weight: 400; letter-spacing: normal; orphans: 2; text-align:
    start; text-indent: 0px; text-transform: none; white-space:
    normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width:
    0px; text-decoration-thickness: initial; text-decoration-style:
    initial; text-decoration-color: initial;">Can you give us a bit
    more info? I've not seen it on any of my servers. Found this:<br>
    </p>
    <p style="color: rgb(0, 0, 0); font-family: &quot;Times New
    Roman&quot;; font-size: medium; font-style: normal;
    font-variant-ligatures: normal; font-variant-caps: normal;
    font-weight: 400; letter-spacing: normal; orphans: 2; text-align:
    start; text-indent: 0px; text-transform: none; white-space:
    normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width:
    0px; text-decoration-thickness: initial; text-decoration-style:
    initial; text-decoration-color: initial;">Patch P14944 07Jan2016</p>
    Bug 122604 (GENERIC)
    <p style="color: rgb(0, 0, 0); font-family: &quot;Times New
    Roman&quot;; font-size: medium; font-style: normal;
    font-variant-ligatures: normal; font-variant-caps: normal;
    font-weight: 400; letter-spacing: normal; orphans: 2; text-align:
    start; text-indent: 0px; text-transform: none; white-space:
    normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width:
    0px; text-decoration-thickness: initial; text-decoration-style:
    initial; text-decoration-color: initial;">Star server reports
    E_OP068C and E_OP068A error when running a query that contains a
    sub-select statement against a remote non-ingres database.</p>
    <p style="color: rgb(0, 0, 0); font-family: &quot;Times New
    Roman&quot;; font-size: medium; font-style: normal;
    font-variant-ligatures: normal; font-variant-caps: normal;
    font-weight: 400; letter-spacing: normal; orphans: 2; text-align:
    start; text-indent: 0px; text-transform: none; white-space:
    normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width:
    0px; text-decoration-thickness: initial; text-decoration-style:
    initial; text-decoration-color: initial;"><br>
    </p>
    <div class="moz-cite-prefix">On 2/03/2021 8:18 pm, nikosv wrote:<br>
    </div>
    <blockquote type="cite"
    cite="mid:4c85b01a-e25c-41ac-8c3e-b43f4699c20an@googlegroups.com">
    <pre class="moz-quote-pre" wrap="">Anyone seen this error ?
    v10.2.0
    _______________________________________________
    Info-ingres mailing list
    <a class="moz-txt-link-abbreviated" href="mailto:Info-ingres@lists.planetingres.org">Info-ingres@lists.planetingres.org</a>
    <a class="moz-txt-link-freetext" href="https://lists.planetingres.org/mailman/listinfo/info-ingres">https://lists.planetingres.org/mailman/listinfo/info-ingres</a>
    </pre>
    </blockquote>
    </body>
    </html>

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From nksvg@21:1/5 to All on Tue Mar 2 13:21:36 2021
    It's when a subselect is happening inside the select clause.

    select c_amka_asqenh=m.c_amka,
    d_episkep=a.d_episkep,
    d_egrafhs=a.d_egrafhs,
    eid_epis=0,
    c_grnoe_bi_id =
    (select squeeze(bi_id) from grnoe
    where grnoe.c_grnoe = a.c_grnoe),
    c_amka_doctor=p.c_amka,
    kat_prog=0,
    kleidi=concat(a.c_grnoe, squeeze(varchar(replace(varchar(a.d_episkep),' ',''))))
    from epexa a inner join masqe m on
    a.am_asqenh = m.am_asqenh
    left join mypal p on
    a.am_ypal = p.am_ypal
    where a.c_grnoe = ? and
    a.d_episkep = ? and
    a.iatreio = ? and
    a.end_yper = ?

    The curious thing is that the query runs fine from isql but when run through a Perl program it throws.
    The same program and sql query were running fine before the update to 10.2.0.After the update it broke.
    the installation is unpatched so I asked for it to be patched in hope that this was an Ingres bug.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Paul White@21:1/5 to nksvg on Wed Mar 3 08:17:18 2021
    To: info-ingres@lists.planetingres.org

    For sure, make sure the installation is patched up. (just like you would
    advise to keep Microsoft patches up to date).  Confirm the Ingres client
    side is running recent release.

    For your info:

    Version 10.2.0: released Feb 2015.
    Patch P15014: released Jun 2016 has 345 bug fixes, 30 of them mention
    subquery or subselect.



    On 3/03/2021 7:21 am, nksvg wrote:
    It's when a subselect is happening inside the select clause.

    select c_amka_asqenh=m.c_amka,
    d_episkep=a.d_episkep,
    d_egrafhs=a.d_egrafhs,
    eid_epis=0,
    c_grnoe_bi_id =
    (select squeeze(bi_id) from grnoe
    where grnoe.c_grnoe = a.c_grnoe),
    c_amka_doctor=p.c_amka,
    kat_prog=0,
    kleidi=concat(a.c_grnoe, squeeze(varchar(replace(varchar(a.d_episkep),' ',''))))
    from epexa a inner join masqe m on
    a.am_asqenh = m.am_asqenh
    left join mypal p on
    a.am_ypal = p.am_ypal
    where a.c_grnoe = ? and
    a.d_episkep = ? and
    a.iatreio = ? and
    a.end_yper = ?

    The curious thing is that the query runs fine from isql but when run through a Perl program it throws.
    The same program and sql query were running fine before the update to 10.2.0.After the update it broke.
    the installation is unpatched so I asked for it to be patched in hope that this was an Ingres bug.
    _______________________________________________
    Info-ingres mailing list
    Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From nksvg@21:1/5 to All on Tue Mar 2 14:26:38 2021
    Thanks Paul,
    this info will come handy!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Roy Hann@21:1/5 to nksvg on Wed Mar 3 18:01:19 2021
    nksvg wrote:


    It's when a subselect is happening inside the select clause.

    select c_amka_asqenh=m.c_amka,
    d_episkep=a.d_episkep,
    d_egrafhs=a.d_egrafhs,
    eid_epis=0,
    c_grnoe_bi_id =
    (select squeeze(bi_id) from grnoe
    where grnoe.c_grnoe = a.c_grnoe),
    c_amka_doctor=p.c_amka,
    kat_prog=0,
    kleidi=concat(a.c_grnoe, squeeze(varchar(replace(varchar(a.d_episkep),' ',''))))
    from epexa a inner join masqe m on
    a.am_asqenh = m.am_asqenh
    left join mypal p on
    a.am_ypal = p.am_ypal
    where a.c_grnoe = ? and
    a.d_episkep = ? and
    a.iatreio = ? and
    a.end_yper = ?

    The curious thing is that the query runs fine from isql but when
    run through a Perl program it throws. The same program and sql query
    were running fine before the update to 10.2.0.After the update it
    broke. the installation is unpatched so I asked for it to be patched in
    hope that this was an Ingres bug.

    That subquery needs to be a scalar subquery for the whole thing to be
    certain to work. As far as I know Ingres has no way to know
    whether it is or it isn't scalar without actually executing it. By
    inspection of the syntax it _could_ be scalar so I can't see OPF
    ever grumbling about it. If it does turn out not to be scalar you get a different error (E_US1196).

    That it works when run in isql makes me think the Perl driver (some kind
    of ODBC? or DBD::Ingres?) is garbling something.

    (Of course you could just get rid of that subquery, but I'm sure you
    know that.)

    Roy

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