Why selectRaw() execution result is different?

[majumawm]

$ php artisan -V
Laravel Framework 9.45.1

$ php artisan tinker
Psy Shell v0.11.9 (PHP 8.1.12 — cli) by Justin Hileman
----------------------------------------------------------------------MYSQL 8.0

> DB::query()->selectRaw('round(0.1234567890, 3) as test')->get();
= Illuminate\Support\Collection {#4020
    all: [
      {#4019
        +"test": "0.123",
      },
    ],
  }

> DB::query()->selectRaw('round(0.1234567890, ?) as test', [3])->get();
= Illuminate\Support\Collection {#4036
    all: [
      {#4034
        +"test": "0.1230000000",
      },
    ],
  }

----------------------------------------------------------------------MYSQL 5.7

> DB::query()->selectRaw('round(0.1234567890, 3) as test')->get();
= Illuminate\Support\Collection {#4032
    all: [
      {#4020
        +"test": "0.123",
      },
    ],
  }

> DB::query()->selectRaw('round(0.1234567890, ?) as test', [3])->get();
= Illuminate\Support\Collection {#4040
    all: [
      {#4033
        +"test": "0.123",
      },
    ],
  }

[henzeb]

have you runned the same query directly in the mysql cli of both instances?

[majumawm]

Got it. thank you.

mysql> select round(0.1234567890, 3);
+------------------------+
| round(0.1234567890, 3) |
+------------------------+
|                  0.123 |
+------------------------+
1 row in set (0.01 sec)

mysql> set @p1=3
    -> ;
Query OK, 0 rows affected (0.02 sec)

mysql> select round(0.1234567890, @p1);
+--------------------------+
| round(0.1234567890, @p1) |
+--------------------------+
|             0.1230000000 |
+--------------------------+
1 row in set (0.01 sec)