I have a fix, but please, submit a bug report so that I can refer to that.

And it has nothing to do with dashes.  That would be weird.  A dash is
just another character.  Nothing special about it.

On 19/05/2020 16.23, Sjoerd Mullender wrote:
> I can reproduce this.
>
> Please submit a bug report at https://bugs.monetdb.org (aka
> https://www.monetdb.org/bugzilla).
>
> On 19/05/2020 16.02, Roberto Cornacchia wrote:
>> Hi Panos,
>>
>> I was also curios so I tried on my Nov2019. I have the impression it
>> misses strings with a dash:
>>
>> sql>select * from t where s ilike '%u%e%s%';
>> +----------------------+
>> | s                    |
>> +======================+
>> | Guinea-Bissau        |
>> | Turkmenistan         |
>> | United Arab Emirates |
>> | United States        |
>> | Uzbekistan           |
>> +----------------------+
>> 5 tuples
>>
>> -- This should return (also) 'Guinea-Bissau'
>> sql>select * from t where s ilike '%u%e%b%s%';
>> +----------------------+
>> | s                    |
>> +======================+
>> | United Arab Emirates |
>> +----------------------+
>> 1 tuple
>>
>> On Tue, 19 May 2020 at 15:57, Panagiotis Koutsourakis
>> <panagiotis.koutsourakis@monetdbsolutions.com
>> <mailto:panagiotis.koutsourakis@monetdbsolutions.com>> wrote:
>>
>>     Hi Ariel,
>>
>>     What version of MonetDB are you using?
>>
>>     Best regards,
>>
>>     Panos
>>
>>     On 5/19/20 3:17 PM, Ariel Abadi wrote:
>>>     Hi!
>>>     May be some can help me. We are using the ILIKE operator to filter
>>>     data. When we use a couple of "%" at a certain point the db stops
>>>     filtering correctly.
>>>
>>>     We started with *ILIKE '%guate%' *it found 7 records, then we
>>>     changed to  *ILIKE '%guate%**com% *it found 1 record (which is
>>>     ok)... finally we changed to *ILIKE '%guate%mo%**com%**' *and now
>>>     it didn't find anything :'(
>>>
>>>     Please see the attached examples...
>>>
>>>     *A*) sql>SELECT DISTINCT nts_area_name 
>>>     FROM sb_rmsv.nts_nt_sum_report 
>>>     WHERE nts_area_name *ILIKE '%guate%'*;
>>>     +---------------------------+
>>>     | nts_area_name             |
>>>     +===========================+
>>>     | Guatemala                 |
>>>     | Guatemala-Mobile          |
>>>     | Guatemala-Mobile Comcel   |
>>>     | Guatemala-Mobile Movistar |
>>>     | Guatemala-Mobile PCS      |
>>>     | Guatemala-Telgua          |
>>>     | Guatemala-Telefonica      |
>>>     +---------------------------+
>>>
>>>     *B*) sql>SELECT DISTINCT nts_area_name 
>>>     FROM sb_rmsv.nts_nt_sum_report 
>>>     WHERE nts_area_name *ILIKE '%guate%**com%;*
>>>     +-------------------------+
>>>     | nts_area_name           |
>>>     +=========================+
>>>     | Guatemala-Mobile Comcel |
>>>     +-------------------------+
>>>
>>>     *C*) sql>SELECT DISTINCT nts_area_name 
>>>     FROM sb_rmsv.nts_nt_sum_report 
>>>     WHERE nts_area_name *ILIKE '%guate%mo%**com%**'*;
>>>     +---------------+
>>>     | nts_area_name |
>>>     +===============+
>>>     +---------------+
>>>     0 tuples
>>>
>>>     _______________________________________________
>>>     users-list mailing list
>>>     users-list@monetdb.org <mailto:users-list@monetdb.org>
>>>     https://www.monetdb.org/mailman/listinfo/users-list
>>     _______________________________________________
>>     users-list mailing list
>>     users-list@monetdb.org <mailto:users-list@monetdb.org>
>>     https://www.monetdb.org/mailman/listinfo/users-list
>>
>>
>> _______________________________________________
>> users-list mailing list
>> users-list@monetdb.org
>> https://www.monetdb.org/mailman/listinfo/users-list
>>
>

--
Sjoerd Mullender
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list