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

  • Upgrading to a newer Ingres version breaks SQL query

    From nikosv@21:1/5 to All on Tue Feb 9 13:16:22 2021
    upgrading from II 10.0.1 (a64.lnx/100)NPTL to II 10.2.0 (a64.lnx/100) seems to be breaking a SQL query by totally ignoring nulls.

    The description I wrote is too big to fit in the forum's format plus I also use screenshots.So can you please check my blog's item on the case to give me hints on what could be the issue with it?

    https://perlingresprogramming.blogspot.com/2021/02/upgrading-to-newer-ingres-version.html

    Is it a bug or am I just seeing ghosts?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From nikosv@21:1/5 to nksvg on Wed Feb 10 01:33:06 2021
    On Wednesday, February 10, 2021 at 11:28:01 AM UTC+2, nksvg wrote:
    typo when fiddling with the text for the article
    fixed

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From nksvg@21:1/5 to All on Wed Feb 10 01:28:00 2021
    typo when fiddling with the text for the article

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Roy Hann@21:1/5 to nikosv on Wed Feb 10 09:22:04 2021
    nikosv wrote:

    upgrading from II 10.0.1 (a64.lnx/100)NPTL to II 10.2.0 (a64.lnx/100) seems to be breaking a SQL query by totally ignoring nulls.

    The description I wrote is too big to fit in the forum's format plus I also use screenshots.So can you please check my blog's item on the case to give me hints on what could be the issue with it?

    https://perlingresprogramming.blogspot.com/2021/02/upgrading-to-newer-ingres-version.html

    Is it a bug or am I just seeing ghosts?

    I don't know if this is important but Q1 in your post does not parse.
    There is an unbalanced parenthesis.

    ...and ( (d1.last_aa is null) or...

    Roy

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