Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5204

NOW() is calculated several times for SYS tables

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 10.1, 10.0.2, 9.3.7
    • None
    • Query Engine
    • None
    • Hide
      select now(), a.* from sys.columns a
      Show
      select now(), a .* from sys. columns a

    Description

      When applied to an internally processed schema (like SYS, SYSADMIN), command deterministic functions like NOW() are calculated separately for each row and thus give different results.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            e1fueg0 111 111
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: