Hello,
I did a grid and I added the Refined Search on left side.
I got some problems when activate filters so I did run the application on debug mode.
1st QUESTION
Looking on SQL related to Refined Search, it seems a bit strange that after WHERE conditions are doubled .
The SELECT is absolutly normal:
SELECT sc_concat(CustomerID, CompanyName)
FROM customers
WHERE CustomerID = ‘{CustomerID01}’
ORDER BY CustomerID, CompanyName
On debug I find
(pdo-mysql): select CustomerID, CompanyName from customers where CustomerID = ‘agcg’ and CustomerID = ‘agcg’ order by CompanyName
Please have a look to image
2nd QUESTION
Did anybody have problems using Maria DB ?
The same application under Maria DB do not work , under mySQL yes .
Is there a possible meaning ?