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

  • Bug 136106 II-5879

    From Roy Hann@21:1/5 to All on Sun Jan 10 11:52:23 2021
    I was just reading over the list of bugs fixed in 11.1 and encountered
    the following:

    [...]
    This can be caused by adding local predicates explicitly, or by the
    database generating them via transitive closure.
    [...]

    I have not seen the term "local predicate" before. Would I be right to
    guess it means a predicate local to a subquery?

    And am I also right to think that the transitive closure is generated
    by the DBMS (?OPF) not the "database"? I don't see how it could come
    from a database.

    Roy

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Karl Schendel@21:1/5 to Ingres and related product discussi on Mon Jan 11 18:01:52 2021
    On Jan 10, 2021, at 6:52 AM, Roy Hann <specially@processed.almost.meat> wrote:

    I was just reading over the list of bugs fixed in 11.1 and encountered
    the following:

    [...]
    This can be caused by adding local predicates explicitly, or by the
    database generating them via transitive closure.
    [...]

    I have not seen the term "local predicate" before. Would I be right to
    guess it means a predicate local to a subquery?

    And am I also right to think that the transitive closure is generated
    by the DBMS (?OPF) not the "database"? I don't see how it could come
    from a database.

    Yes, you would be right to think so.

    I guess we all have our windmills. My recent favorite is trying to teach people
    that DDR4 memory speeds, as in DDR4-3200, are in MT/s (million
    transfers per second), not MHz. MHz are for clocks and DDR4-3200 runs
    at 1600MHz - that's why it's Double Data Rate. Even the memory
    manufacturers mis-label their own product.

    I'll forward your complaint to, uh, the proper people. :-)

    Karl

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