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

  • Re: [Info-ingres] Upgrading to a newer Ingres version breaks SQL query

    From nikosv@nikos.vaggalis@gmail.com to comp.databases.ingres on Wed Feb 10 06:39:31 2021
    From Newsgroup: comp.databases.ingres

    Hi Paul and thanks for replying.
    I've tried WITH NOOJFLATTEN but it didn't work.
    It's missing a patch most probably.How do I check the installation for applied patches?
    thanks
    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From nikosv@nikos.vaggalis@gmail.com to comp.databases.ingres on Wed Feb 10 07:59:35 2021
    From Newsgroup: comp.databases.ingres


    It's missing a patch most probably.How do I check the installation for applied patches?
    Is that the way?
    ls -l --full-time ${II_SYSTEM}/ingres/lib/iimerge.a | awk '{print $6}'
    gives:
    2014-08-13

    while

    cat ${II_SYSTEM}/ingres/version.rel
    gives
    II 10.2.0 (a64.lnx/100)

    What does this mean? That it has no patches applied ? And what does this iimerge.a trickery mean?
    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From Karl Schendel@schendel@kbcomputer.com to nikosv on Wed Feb 10 11:10:46 2021
    From Newsgroup: comp.databases.ingres


    On Feb 10, 2021, at 10:59 AM, nikosv <nikos.vaggalis@gmail.com> wrote:


    It's missing a patch most probably.How do I check the installation for applied patches?
    cat $II_SYSTEM/ingres/version.rel
    is the proper way. it looks like you are running an unpatched 10.2. There were
    a *lot* of fixes between the initial 10.2 release and the final patches, so it's quite
    possible that your particular bug is fixed by a patch.
    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From nikosv@nikos.vaggalis@gmail.com to comp.databases.ingres on Wed Feb 10 08:16:28 2021
    From Newsgroup: comp.databases.ingres

    Hi Karl,
    if there had been patches applied , what would be the output of this command be? (as an example to know what I should be looking for)
    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From Karl Schendel@schendel@kbcomputer.com to nikosv on Wed Feb 10 11:25:14 2021
    From Newsgroup: comp.databases.ingres


    On Feb 10, 2021, at 11:16 AM, nikosv <nikos.vaggalis@gmail.com> wrote:

    Hi Karl,
    if there had been patches applied , what would be the output of this command be? (as an example to know what I should be looking for)
    I'd expect to see a bunch of numbers listed.
    II 10.2.0 (a64.lnx/100)
    10234
    11754
    etc
    etc
    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From nikosv@nikos.vaggalis@gmail.com to comp.databases.ingres on Wed Feb 10 08:47:30 2021
    From Newsgroup: comp.databases.ingres

    Thanks. Somewhere I saw that there's also a version.dat file but can't find it. Is there any other way except the version.rel file?
    --- Synchronet 3.21b-Linux NewsLink 1.2