Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-3104 Enable Phoenix test cases with Calcite-Phoenix
  3. PHOENIX-3341

Schema update is not visible to following statements of the same connection due to CalciteSchema caching.

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:

      Description

      The TableRef object contains a timestamp which will be used for TableScan. The timestamp should be set at the time of the statement being compiled. Now that the table resolving goes from Calcite and CalciteSchema caches TableEntry through the whole connection, the table will not be re-resolved if any previous statement has already resolved it. If a previous statement did an update, the next statement cannot see the update since it's holding a TableRef object containing the old timestamp.
      The CalciteSchema caching would also be a problem if a table, a view, or a function is modified or dropped.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                maryannxue Wei Xue
                Reporter:
                maryannxue Wei Xue
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: