Wrong results with regular expressions
Bug #690083 reported by
Marcus Eriksson
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
Medium
|
Andrew Hutchings | ||
7.0 |
Fix Released
|
Medium
|
Andrew Hutchings |
Bug Description
The following result is wrong, should return 0 (it does in mysql)
drizzle> SELECT "123" REGEXP "[a-z]+";
+------
| "123" REGEXP "[a-z]+" |
+------
| 1 |
+------
1 row in set (0 sec)
drizzle> select version();
+--------------+
| version() |
+--------------+
| 2010.12.1993 |
+--------------+
1 row in set (0 sec)
Related branches
lp://staging/~linuxjedi/drizzle/trunk-bug-690083
- Drizzle Developers: Pending requested
-
Diff: 88 lines (+11/-19)2 files modifiedplugin/string_functions/regex.cc (+2/-2)
plugin/string_functions/tests/r/regex.result (+9/-17)
Changed in drizzle: | |
assignee: | nobody → Andrew Hutchings (linuxjedi) |
To post a comment you must log in.
this is because regex.cc is using "123" for the pattern and the match.