1. Forum
  2. USENET
  3. comp.databases.ingres

  • Upgrading to a newer Ingres version breaks SQL query

    From nikosv@nikos.vaggalis@gmail.com to comp.databases.ingres on Tue Feb 9 13:16:22 2021
    From Newsgroup: comp.databases.ingres

    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?
    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From Roy Hann@specially@processed.almost.meat to comp.databases.ingres on Wed Feb 10 09:22:04 2021
    From Newsgroup: comp.databases.ingres

    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

    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From nksvg@nksvg1@gmail.com to comp.databases.ingres on Wed Feb 10 01:28:00 2021
    From Newsgroup: comp.databases.ingres

    typo when fiddling with the text for the article
    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From nikosv@nikos.vaggalis@gmail.com to comp.databases.ingres on Wed Feb 10 01:33:06 2021
    From Newsgroup: comp.databases.ingres

    On Wednesday, February 10, 2021 at 11:28:01 AM UTC+2, nksvg wrote:
    typo when fiddling with the text for the article
    fixed
    --- Synchronet 3.21b-Linux NewsLink 1.2