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:~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) |
Revision history for this message
| Andrew Hutchings (linuxjedi) wrote | #1 |
To post a comment you must log in.
this is because regex.cc is using "123" for the pattern and the match.