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

  • Bug 136106 II-5879

    From Roy Hann@specially@processed.almost.meat to comp.databases.ingres on Sun Jan 10 11:52:23 2021
    From Newsgroup: comp.databases.ingres

    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


    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From Karl Schendel@schendel@kbcomputer.com to Ingres and related product discussion forum on Mon Jan 11 18:01:52 2021
    From Newsgroup: comp.databases.ingres


    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
    --- Synchronet 3.21b-Linux NewsLink 1.2