[jira] [Created] (CALCITE-6791) Search pattern during matching in REPLACE function should be case insensitive in MSSQL

[ZheHu (Jira)]

ZheHu created CALCITE-6791:
------------------------------

             Summary: Search pattern during matching in REPLACE function should 
be case insensitive in MSSQL
                 Key: CALCITE-6791
                 URL: https://issues.apache.org/jira/browse/CALCITE-6791
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.38.0
            Reporter: ZheHu
            Assignee: ZheHu


REPLACE function in Microsoft SQL Server is case insensitive when matching the 
search pattern.
Result for the following query is "ciciaociaoo"
{code:java}
replace('ciAao', 'a', 'ciao')
{code}
Same query in Oracle or PostgreSQL results in "ciAciaoo".

For this case, we should add a function(call it REPLACE_MSSQL) and enable it 
when fun=mssql.

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)