Created attachment 65898 [details]
reproduction DB

1. Register attached file as a data source
2. Launch Calc.
3. Hit F4 to open the Data Sources panel.
4. Select a table from your data source.
5. Click on the "Standard Filter" icon on the Data Sources toolbar.
6. Enter search criteria: comments = *
7. Hit OK.

Expected result: the line AssetID=0, where Comments='*', is displayed.

Actual result: the line AssetID=1, where Comments='%', is displayed.

That's because the * gets replaced by a %, as if it were the clause in a LIKE. SHOULD NOT HAPPEN. Culprit: Replace_OS_PlaceHolder in dbaccess/source/ui/dlg/queryfilter.cxx


Queries (in Base, new query) do not have this bug. Even queries like:

 SELECT * FROM "Assets" WHERE "Comments" LIKE 'e*' ESCAPE 'e'
 SELECT * FROM "Assets" WHERE "Comments" LIKE 'e%' ESCAPE 'e'

are handled correctly, while

 SELECT * FROM "Assets" WHERE "Comments" LIKE '*'

is sent to the database as

 SELECT * FROM "Assets" WHERE "Comments" LIKE '%'

correctly implementing the "* is a pattern".

However, doubling the escape character is not handled correctly:

 SELECT * FROM "Assets" WHERE "Comments" LIKE 'ee*' ESCAPE 'e'

is not handled correctly. Note that

 SELECT * FROM "Assets" WHERE "Comments" LIKE 'ee%' ESCAPE 'e'

works as expected.