Re: ILIKE Operator. Bad function?

19 May 2020

      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
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