MySQL Bugs: #73465: Result Grid "Filter Rows" box: no longer filters on partial matches

Bug #73465	Result Grid "Filter Rows" box: no longer filters on partial matches
Submitted:	4 Aug 2014 15:36	Modified:	4 Aug 2014 17:56
Reporter:	Sam Abboushi	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	6.1.7.11091 build 1788 Community	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	Filter Rows

Description:
Result Grid "Filter Rows" box: no longer filters on partial matches (I upgraded from 6.0 where Filter Rows did partial matches).

How to repeat:
Do a select query on any table with data.

In the Result Grid, enter part of a column's data into the "Filter Rows" box.

e.g.: if a column in the Result Grid contains "abcd", enter "bc" into the "Filter Rows" box.

In version 6.0 and earlier, the resulting filtered rows would MATCH AND INCLUDE rows containing "bc".

Now, only columns that contain "bc" as the column value will be displayed.

I actually like having this as a new feature, but very much need "Filter Rows" to also work the way it did before.

I could not find any documentation regarding how "Filter Rows" is supposed to work, nor did I find anything in bugs db regarding this (other than it now displays ALL rows that don't match with NULL values... owtch); so someone needs to decide which of the two behaviors is a bug and which is a new feature request.

Personally, since the behavior changed as a result of an update, I would consider that a bug...

Suggested fix:
Restore the "Filter Rows" functionality to do partial matches as it did before;
Add a checkbox to match column value (i.e. same as "where" clause).

Even better would be to leave "Filter Rows" as it is now (the new behavior) and add a checkbox for "REGEX" where now we can enter regexp expression in "Filter Rows" as an option.

Between this bug (Bug #73465) and
2) that NULLS are returned for filtered non-matching rows (Bug #72214), and
3) the new autofit bugs for the result grid columns (Bug #72332),

I am uninstalling the new version and reinstalling 6.0.6

Filtering

Attachment: Screen Shot 2014-08-04 at 2.00.34 PM.png (image/png, text), 92.19 KiB.

Please see prior attached screenshot it shows filter 'bc'and filtered 'abc' and 'abcd'. Thanks.

Thanks Godofredo-

I reinstalled 6.1.7 again and the Filter Rows is no longer "misbehaving".  Hmmm...

I will change status to "closed".