[PHOENIX-3341] Schema update is not visible to following statements of the same connection due to CalciteSchema caching.

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Labels: calcite
• Assignee: Wei Xue
• Reporter: Wei Xue
• Created: 30/Sep/16 19:43
• Updated: 03/Aug/17 19:17
• Resolved: 03/Aug/17 19:17

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.

Issue Links

• depends upon: CALCITE-1742 Create a read-consistent view of CalciteSchema for each statement compilation