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