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> 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
https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list