Should we have dynamic like optimization with TERRITORY_BASED collation

The test below fails in DynamicLikeOptimizationTest.I wonder is this optimization expected for TERRITORY_BASED collation or is ok that it is not done. Kathey /** * Test that dynamic like optimization is performed. That is, the LIKE * predicate is rewritten to gt;=, lt; and LIKE.

Re: Should we have dynamic like optimization with TERRITORY_BASED collation

Kathey, this is another behavior we picked up from national character types. LikeEscapeOperatorNode has following comment /* If we are comparing a char with a national char then * we generate a cast above the receiver to force preprocess to * not attempt any of the =

Re: Should we have dynamic like optimization with TERRITORY_BASED collation

Mamta Satoor wrote: Kathey, this is another behavior we picked up from national character types. LikeEscapeOperatorNode has following comment /* If we are comparing a char with a national char then * we generate a cast above the receiver to force preprocess to * not