Package org.apache.flink.table.functions

Class SqlLikeUtils

java.lang.Object

org.apache.flink.table.functions.SqlLikeUtils

@Internal
public class SqlLikeUtils
extends Object

Utilities for converting SQL LIKE and SIMILAR operators to regular expressions.

Note: THIS IS COPIED FROM CALCITE to EXPOSE SOME PRIVATE METHOD

Method Summary

Modifier and Type	Method	Description
static boolean	ilike(String s, String patternStr)	SQL ILIKE function.
static boolean	ilike(String s, String patternStr, String escape)	SQL ILIKE function with escape.
static RuntimeException	invalidEscapeCharacter(String s)
static RuntimeException	invalidEscapeSequence(String s, int i)
static boolean	like(String s, String pattern)	SQL LIKE function.
static boolean	like(String s, String pattern, String escape)	SQL LIKE function with escape.
static boolean	similar(String s, String pattern)	SQL SIMILAR function.
static boolean	similar(String s, String pattern, String escape)	SQL SIMILAR function with escape.
static String	sqlToRegexLike(String sqlPattern, CharSequence escapeStr)	Translates a SQL LIKE pattern to Java regex pattern, with optional escape string.
static String	sqlToRegexSimilar(String sqlPattern, char escapeChar)	Translates SQL SIMILAR pattern to Java regex pattern.
static String	sqlToRegexSimilar(String sqlPattern, CharSequence escapeStr)	Translates a SQL SIMILAR pattern to Java regex pattern, with optional escape string.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

like

public static boolean like(String s,
                           String pattern)

SQL LIKE function.

like

public static boolean like(String s,
                           String pattern,
                           String escape)

SQL LIKE function with escape.

ilike

public static boolean ilike(String s,
                            String patternStr)

SQL ILIKE function.

ilike

public static boolean ilike(String s,
                            String patternStr,
                            String escape)

SQL ILIKE function with escape.

similar

public static boolean similar(String s,
                              String pattern)

SQL SIMILAR function.

similar

public static boolean similar(String s,
                              String pattern,
                              String escape)

SQL SIMILAR function with escape.

sqlToRegexLike

public static String sqlToRegexLike(String sqlPattern,
                                    CharSequence escapeStr)

Translates a SQL LIKE pattern to Java regex pattern, with optional escape string.

invalidEscapeCharacter

public static RuntimeException invalidEscapeCharacter(String s)

invalidEscapeSequence

public static RuntimeException invalidEscapeSequence(String s,
                                                     int i)

sqlToRegexSimilar

public static String sqlToRegexSimilar(String sqlPattern,
                                       CharSequence escapeStr)

Translates a SQL SIMILAR pattern to Java regex pattern, with optional escape string.

sqlToRegexSimilar

public static String sqlToRegexSimilar(String sqlPattern,
                                       char escapeChar)

Translates SQL SIMILAR pattern to Java regex pattern.