|
In-Portal Issue Tracker - In-Portal CMS
|
|
Viewing Issue Advanced Details |
|
|
ID:
|
Category:
|
Type:
|
Reproducibility:
|
Date Submitted:
|
Last Update:
|
|
97 |
[In-Portal CMS] Database |
bug report |
always |
2009-06-19 14:55 |
2010-01-11 22:05 |
|
|
Reporter:
|
Dmitry |
Platform:
|
|
|
|
Assigned To:
|
alex |
OS:
|
|
|
|
Priority:
|
normal |
OS Version:
|
|
|
|
Status:
|
closed |
Product Version:
|
5.0.0 |
|
|
Product Build:
|
|
Resolution:
|
fixed |
|
| |
|
ETA:
|
none |
Fixed in Version:
|
5.0.2-B1 |
|
|
Reference:
|
|
|
Change Log Message:
|
|
|
Estimate Points:
|
0 |
|
|
Summary:
|
0000097: Issues with "Like" type Grid Filters in Admin |
|
Description:
|
Currently LIKE type Admin Grid Filters won't properly work when we use " _ " or " % " in the search query. Both will be treated as "wildcards" by MySQL since not properly escaped. |
|
Steps To Reproduce:
|
Below is example of SQL used when we put " % " in Filter Search:
SELECT COUNT(*) AS count
FROM News
LEFT JOIN CategoryItems ON CategoryItems.ItemResourceId = News.ResourceId
LEFT JOIN Category ON Category.CategoryId = CategoryItems.CategoryId
LEFT JOIN Images img ON img.ResourceId = News.ResourceId AND img.DefaultImg = 1
LEFT JOIN PermCache perm ON perm.CategoryId = CategoryItems.CategoryId
LEFT JOIN PortalUser u ON News.CreatedById = u.PortalUserId
LEFT JOIN NewsCustomData cust ON News.ResourceId = cust.ResourceId
WHERE ((PrimaryCat = 1) AND (perm.PermId = 1)) AND (((`News`.`Title` LIKE "%%%")))
LIMIT 0,1 |
|
Additional Information:
|
|
| Relationships | | related to | 0000412 | closed (5.0.2) | alex | SQL Fatal when using Double-quotes in Text Filters in Grids |
|
|
Attached Files:
|
 widcard_search_problems.patch (3,616) 2009-11-10 05:13
http://tracker.in-portal.org/file_download.php?file_id=138&type=bug |
|
|
Issue History |
|
Date Modified |
Username |
Field |
Change |
|
2010-01-11 22:05 |
Dmitry |
Note Added: 0001329 |
|
|
2010-01-11 22:05 |
Dmitry |
Status |
resolved => closed |
|
2009-11-13 13:07 |
Dmitry |
Note Added: 0001127 |
|
|
2009-11-13 13:07 |
Dmitry |
Target Version |
Icebox => 5.0.2 |
|
2009-11-10 11:40 |
alex |
Note Added: 0001076 |
|
|
2009-11-10 11:40 |
alex |
Status |
reviewed and tested => resolved |
|
2009-11-10 11:40 |
alex |
Fixed in Version |
=> 5.0.2-B1 |
|
2009-11-10 11:40 |
alex |
Resolution |
open => fixed |
|
2009-11-10 11:40 |
alex |
Assigned To |
!COMMUNITY => alex |
|
2009-11-10 11:40 |
alex |
Changeset attached |
5.0.x r12896 |
|
2009-11-10 11:35 |
Dmitry |
Note Added: 0001075 |
|
|
2009-11-10 11:35 |
Dmitry |
Status |
needs testing => reviewed and tested |
|
2009-11-10 05:14 |
alex |
Note Added: 0001067 |
|
|
2009-11-10 05:14 |
alex |
Assigned To |
=> !COMMUNITY |
|
2009-11-10 05:14 |
alex |
Status |
active => needs testing |
|
2009-11-10 05:13 |
alex |
File Added: widcard_search_problems.patch |
|
|
2009-11-10 04:31 |
alex |
Relationship added |
related to 0000412 |
|
2009-06-19 14:55 |
Dmitry |
New Issue |
|
|
Notes |
|
|
(0001067)
|
|
alex
|
|
2009-11-10 05:14
|
|
|
With this patch you will be able to search for "_" and "%" symbols in fields, and "?" and "*" will only work as wildcards. Tested on front-end simple search and in admin column filter. |
|
|
|
(0001075)
|
|
Dmitry
|
|
2009-11-10 11:35
|
|
|
|
|
(0001076)
|
|
alex
|
|
2009-11-10 11:40
|
|
Fix committed to 5.0.x branch. Commit Message:
Fixes 0000097: Issues with "Like" type Grid Filters in Admin |
|
|
|
(0001127)
|
|
Dmitry
|
|
2009-11-13 13:07
|
|
Was fixed along with other task in 5.0.2-B1 development.
Moving Target version to 5.0.2 |
|
|
|
(0001329)
|
|
Dmitry
|
|
2010-01-11 22:05
|
|
|