Bug #69167 Using regexp crashes mysql workbench every time
Submitted: 7 May 2013 18:06 Modified: 10 Jun 2013 0:51
Reporter: D F Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S1 (Critical)
Version:5.2.47 CE OS:Windows (Win 7, 64-bit, service pack 1)
Assigned to: CPU Architecture:Any

[7 May 2013 18:06] D F
Anytime I try to use the regexp keyword in a query in the query editor, the entire MySQL Workbench crashes almost immediately.

How to repeat:
1. Open MySQL Workbench
2. Open a connection to start querying
3. Create a new sql tab for executing queries
4. Type in the following:
select * from whatever where somecolumn regexp [84753]

You won't be able to do it. It will crash before you can.

Suggested fix:
Make it not crash.
[7 May 2013 18:31] MySQL Verification Team
Mac Back Trace

Attachment: regexp_crash.txt (text/plain), 70.71 KiB.

[7 May 2013 18:32] MySQL Verification Team
Thank you for the bug report.
[7 May 2013 18:35] D F
Thank you for the quick response :)
[10 Jun 2013 0:50] Philip Olson
Posted by developer:
Fixed as of the upcoming Workbench 6.0.x, and here's the changelog entry:

Executing a query that contained a regular expression would cause
MySQL Workbench to crash.

Thank you for the bug report.