Drop and recreate TEXT indexes after ESD upgrade or rollback [CR #620317]

In Sybase IQ version 15.2 ESD #1 or later, operations that access a Sybase IQ TEXT index created in 15.2 GA report the error “Incorrect TEXT Index Version (1): Index must be dropped and recreated.” Also, sp_iqcheckdb reports errors and inconsistent indexes related to these TEXT indexes.

Workaround: Use Sybase IQ 15.2 ESD #1 or later to drop and recreate all TEXT indexes created in 15.2 GA.

After a rollback of Sybase IQ to version 15.2 GA, an operation that accesses a TEXT index created with 15.2 ESD #1 or higher reports an error like “Non-Fatal IQ Internal Error Detected at s_postingTbl.cxx:1503 on thread 4113.”

Workaround: Use Sybase IQ 15.2 GA to drop and recreate all IQ TEXT indexes.