Like operator doesn't work with number

[Kyshino]

• Laravel-mongodb Version: 6.3.1
• PHP Version: 7.4

Description:

When I try to use the LIKE operator with a number, it doesnt work,

Steps to reproduce

1. Use $query->where("column", "LIKE", "%29%");

Expected behaviour

Return all rows that contain the value 29 in column

Actual behaviour

Returns nothing

Possible solution

The problem is in the file mongodb/Query/Builder.php specifically in the function called compileWhereBasic.
In this code

       if (in_array($operator, ['like', 'not like'])) {
            if ($operator === 'not like') {
                $operator = 'not';
            } else {
                $operator = '=';
            }

$operator change from like to = and then in this other code, a few lines down

        if (!isset($operator) || $operator == '=') {
            if ($is_numeric) {
                $query = ['$where' => '/^'.$value->getPattern().'/.test(this.'.$column.')'];
            } else {
                $query = [$column => $value];
            }

That check if operator is '=' (what changed a few lanes before) and $is_numeric is true (this is true because our like is with 29) change the query to that and then it doesnt return nothing.

I tried to replace

            if ($is_numeric) {
                $query = ['$where' => '/^'.$value->getPattern().'/.test(this.'.$column.')'];
            } else {
                $query = [$column => $value];
            }

for

$query = [$column => $value];

and its working.

Logs:

SyntaxError: identifier starts immediately after numeric literal (1/1) CommandException SyntaxError: identifier starts immediately after numeric literal

in Count.php line 176

[Kyshino]

Any news about this?

[divine]

Hello,

This was fixed in #2020

Update to latest version of the library.

Thanks!

[JpuntoLpuntoApps]

Hi @divine ,

I'm a @Kyshino's teammate, we have update to lastest library version (3.6.6) and now we don't get an error but neither obtain results. When we filter a string datatype like this by value 38, for example, the library not return any data

I tried to replace

        if ($is_numeric) {
            $query = ['$where' => '/^'.$value->getPattern().'/.test(this.'.$column.')'];
        } else {
            $query = [$column => $value];
        }

for

$query = [$column => $value];

and its working. I attach an image with generated filters:

Thanks a lot!

[divine]

Hello,

Quite interesting so basically reverting back fixes that issue?

Thanks!

[JpuntoLpuntoApps]

Hello,

In our case, if we replace this condition

   if ($is_numeric) {
        $query = ['$where' => '/^'.$value->getPattern().'/.test(this.'.$column.')'];
    } else {
        $query = [$column => $value];
    }

by
$query = [$column => $value];

we retrieve expected results, but we don't know if you delete the if condition could generate other errors.

Thanks

[Kyshino]

Hello @divine,

Any news about this?

Thanks.

[divine]

Hello @divine,

Any news about this?

Thanks.

Hello,

Sorry for the delay but we need to discuss this with @Smolevich.

My personal view would be to revert it back. That PR created a lot of bugs here and there and it's a real pain with custom code detection of numeric values for like query.

Thanks!

[Smolevich]

I see on this bug today or tomorrow

[Kyshino]

Thank you very much for the reply @Smolevich,

I look forward to your answer.

[Kyshino]

Hello @Smolevich,

Any news about this?