Wildcard '*' doesn't work correctly
Original Reporter info from Mantis: krzynio8
-
Reporter name: Krzysztof
Original Reporter info from Mantis: krzynio8
- Reporter name: Krzysztof
Description:
TDataSet.Filter with wildcard '*' works not correct when using two wildcards or when wildcard is on beginning of filter string ie. '11' or '*11'.
Steps to reproduce:
I tested on firebird db and sqlite db. Lets create any db and a table TABLE with one column COLUMN and fill it with values (1,2,1150,4311). Lets connect to db using a query 'select COLUMN from TABLE'. I tested using Zeoslib 7.1.2 TZConnection and TZQuery. Let's put TDataSource and TDBGrid components on a form and fill the Filter property using: grid.DataSource.Dataset.Filter = '11*'. The result will be correct: 1150. But when you put two wildcards '11' or put wildcard on the beginning of the string the result will be wrong: (1,2,1150,1143) instead of (1150, 1143).
Additional information:
I worked with Lazarus 0.9.3, 1.0, 1.1.99-pre, 1.2RC1 and 1.3.
With Zeos lib 6x, 7x
With SQL lite, MSSQL and Firebird
And in all cases I had the same problem with using wildcards, so I think that problem must be somewhere in TDataSet component.
Mantis conversion info:
- Mantis ID: 25669
- OS: Linux
- OS Build: Debian all versi
- Platform: x64
- Version: 1.2.0RC2