Help with stringliterals

[makssent]

Hello everyone,

I have request:

CREATE TABLE T141 (ROW_NUM NUMERIC(3) NOT NULL, ROW_NAME VARCHAR(25) NOT NULL, ROW_PHONE VARCHAR(14) 
CHECK (ROW_PHONE SIMILAR TO '\\([0-9]{3}\\) [0-9]{3}\\-[0-9]{4}' escape '\\'))

Grammar:

checkClause
    : CHECK LP_ predicate RP_
    ;

predicate
    : bitExpr comparisonOperator bitExpr
    ...
    | bitExpr NOT? SIMILAR TO bitExpr (ESCAPE bitExpr)?
    | bitExpr
    ;
    
bitExpr
    : bitExpr VERTICAL_BAR_ bitExpr
    ...
    | simpleExpr
    ;
    
simpleExpr
    : functionCall
    | parameterMarker
    | literals
    ...
    ;
    
    literals
    : stringLiterals
    ...
    ;
    
    stringLiterals
    : characterSetName? STRING_ collateClause?
    ;
    
    STRING_ 
    : (SQ_ ('\\'. | '\'\'' | ~('\'' | '\\'))* SQ_)
    ;

    SQ_ :  '\'';

The problem lies in the part after ESCAPE, where the '\' is not processed correctly. How can I solve this?

Error message:

You have an error in your SQL syntax: no viable alternative at input '''

Log Trace:

org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse(ShardingSphereSQLParserEngine.java:60) 
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSphereStatement.createQueryContext(ShardingSphereStatement.java:533) 
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSphereStatement.execute0(ShardingSphereStatement.java:461) 
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSphereStatement.execute(ShardingSphereStatement.java:408) 
Tester.testcheck(Tester.java:43) Connections.dbconnection(Connections.java:409) Main.main(Main.java:35)

Request Tree:

line 1:170 mismatched input ''' expecting {'!', '~', '+', '-', '.', '(', '{', '?', '@', POSITION, CASE, CAST, TRIM, SUBSTRING, IF, NULL, TRUE, FALSE, EXISTS, INTERVAL, DATE, TIME, TIMESTAMP, LOCALTIME, LOCALTIMESTAMP, MAX, MIN, SUM, COUNT, AVG, LOCAL, NAME, TYPE, ADA, C92, CATALOG_NAME, CHARACTER_SET_CATALOG, CHARACTER_SET_NAME, CHARACTER_SET_SCHEMA, CLASS_ORIGIN, COBOL, COLLATION_CATALOG, COLLATION_NAME, COLLATION_SCHEMA, COLUMN_NAME, COMMAND_FUNCTION, COMMITTED, CONDITION_NUMBER, CONNECTION_NAME, CONSTRAINT_CATALOG, CONSTRAINT_NAME, CONSTRAINT_SCHEMA, CURSOR_NAME, DATA, DATETIME_INTERVAL_CODE, DATETIME_INTERVAL_PRECISION, DYNAMIC_FUNCTION, FORTRAN, LENGTH, MESSAGE_LENGTH, MESSAGE_OCTET_LENGTH, MESSAGE_TEXT, MORE92, MUMPS, NULLABLE, NUMBER, PASCAL, PLI, REPEATABLE, RETURNED_LENGTH, RETURNED_OCTET_LENGTH, RETURNED_SQLSTATE, ROW_COUNT, SCALE, SCHEMA_NAME, SERIALIZABLE, SERVER_NAME, SUBCLASS_ORIGIN, TABLE_NAME, UNCOMMITTED, UNNAMED, BIT_LENGTH, CHAR_LENGTH, CHARACTER_LENGTH, COALESCE, CONVERT, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, EXTRACT, GLOBAL, LOWER, NULLIF, OCTET_LENGTH, UPPER, VALUE,ROW_NUMBER, RANK, DENSE_RANK, LEAD, LAG, FIRST_VALUE, LAST_VALUE, NTH_VALUE, FIRSTNAME, MIDDLENAME, LASTNAME, IDENTIFIER_, STRING_, NUMBER_, HEX_DIGIT_, BIT_NUM_}


(createTable CREATE TABLE (tableName (name (identifier T141))) (createDefinitionClause ( (createDefinition (columnDefinition (columnName (name (identifier ROW_NUM))) (dataType (dataTypeName NUMERIC) (dataTypeLength ( 3 ))) (dataTypeOption NOT NULL))) , (createDefinition (columnDefinition (columnName (name (identifier ROW_NAME))) (dataType (dataTypeName VARCHAR) (dataTypeLength ( 25 ))) (dataTypeOption NOT NULL))) , (createDefinition (columnDefinition (columnName (name (identifier ROW_PHONE))) (dataType (dataTypeName VARCHAR) (dataTypeLength ( 14 ))) (dataTypeOption (checkConstraintDefinition (checkClause CHECK ( (predicate (bitExpr (simpleExpr (columnName (name (identifier ROW_PHONE))))) SIMILAR TO (bitExpr (simpleExpr (literals (stringLiterals '\([0-9]{3}\) [0-9]{3}\-[0-9]{4}')))) escape (bitExpr (simpleExpr ' \ '))) )))))) )))

project-link: https://github.com/makssent/shardingsphere/tree/shardingsphere-rdb