[opt](like) opt LIKE and REGEXP clause with concat(col, pattern_str)

[opt](like) opt LIKE and REGEXP clause with concat(col, pattern_str) #9678