Details
-
Sub-Task
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
None
-
None
-
2020-7
Description
This is a continuation of MCOL-4769 and covers the following items not addressed in that ticket:
1. columnstore_cache_use_import cannot be made default because cpimport bloats the database by wasting space in HWM blocks. This needs a resolution.
2. If a select statement is sent to a secondary (slave) node - there should be a cache flush caused on the primary (needs design)
3. any START TRANSACTION should flush cache. Cache should not be used if there are any multi-statement transactions present in the system (needs design)