• Sergei Golubchik's avatar
    SQL: derived, hiding, error messages · e6a74576
    Sergei Golubchik authored
    Many related changes.
    
    Note that AS OF condition must always be pushed down to physical tables,
    it cannot be applied to a derived or a view. Thus:
    
    * no versioning for internal temporary tables, they can never store
      historical data.
    * remove special versioning code from mysql_derived_prepare and
      remove ER_VERS_DERIVED_PROHIBITED - derived can have no historical
      data and cannot be prohibited for system versioning related reasons.
    * do not expand select list for derived/views with sys vers fields,
      derived/views can never have historical data.
    * remove special invisiblity rules for sys vers fields, they are no
      longer needed after the previous change
    * remove system_versioning_hide, it lost the meaning after the
      previous change.
    * remove ER_VERS_SYSTEM_TIME_CLASH, it's no "clash", the inner
      AS OF clause always wins.
    * non-versioned fields in a historical query
    
    reword the warning text, downgrade to note, don't
    replace values with NULLs
    e6a74576
partition.opt 39 Bytes