On Thu, Sep 14, 2017 at 10:02 PM, iostream <[email protected]> wrote:
> I have used Informix DB before. In Informix string comparisons such as - > > SELECT * from Person where fName = "ABC"; > > return rows even if the column value has trailing spaces. The Informix > engine internally trims strings before comparison. It would be great if a > similar feature could be added to Ignite because performing TRIM() in every > create or update scenario will be expensive from an application point of > view. TRIM() on insert or update is a much better approach in my view, because the trimmed string can be properly indexed, and then the comparisons will use the direct index lookup and perform much better. If the comparison has to trim on the fly, then it will likely be a full scan, not a direct index lookup. However, to consider this feature for Ignite, I would like to read some documentation from other databases that describes this behavior. Would be great if you could provide a link. > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
