Materialised Queries
- Fix – When ‘Use Temporary Table during update’ is enabled a SQL error ALTER TABLE COLUMN would occur if the data size exceeded the existing initial varchar size and Sharperlight was trying to adjust it.
- Fix – Sometime SQL Index error during refreshing due to the Index being created outside of Sharperlight and containing special character in the name like ‘-‘. For example SQL Optimiser may create an Index and this would cause a SQL error during Index rebuilding because the name was not being protected by [ ].
Foundry
- Fix – SQL text would lose its line formatting on reopening