Hi! The version Im using is: v11.35.19 (Nov2019-SP3) Thks Ariel On Tue, May 19, 2020 at 10:57 AM 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 listusers-list@monetdb.orghttps://www.monetdb.org/mailman/listinfo/users-list

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

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

Created! https://www.monetdb.org/bugzilla/show_bug.cgi?id=6865 On Tue, May 19, 2020 at 12:24 PM Sjoerd Mullender wrote:

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