Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
Reviewed
-
HIVE-236. RLIKE/REGEXP allowing matching of partial strings. (Paul Yang via zshao)
Description
The current behavior is that the regexp needs to match the whole string.
But from mysql: ( http://dev.mysql.com/doc/refman/5.0/en/regexp.html#operator_regexp )
mysql> SELECT 'fofo' REGEXP '^fo'; -> 1
We need to make it work the same way as MySQL.