SQL Operations Guide

Previous Topic

Next Topic

Allow Linking SQL Indexes with Rightmost Segment(s) on Hidden Field(s)

Prior to V11, the ctsqlimp logic did not allow importing indexes if at least one of the segments points to a field not exposed in SQL. This is encountered frequently in the c-treeRTG products.

In V11 and later, the ctsqlimp logic optionally (OFF by default) allows importing indexes having segments pointing to hidden fields if at least one segment is valid and all segments pointing to hidden fields are the rightmost with no intermixing of exposed and hidden fields.

This logic is controlled by a new sqlimport callback CTSQLCB_CONFIRM_INDEXTRUNC.