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

NOW() is calculated several times for SYS tables

    Details

    • Steps to Reproduce:
      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.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                elfuego El Fuego
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: