search

ybr-nx / laravel-mariadb

Add MariaDB JSON select support to Laravel
95 stars 7 forks source link

Problems with unquoting #19

Closed buddhaCode closed 3 months ago

buddhaCode commented 4 years ago

Thanks four your great grammar!

I have some problems with the unquoting. I have the following JSON doc in a column:

{ "displayName": "App\\Jobs\\rotateClip" }

When querying this property I will get the quoted return: "App\\Jobs\\rotateClip" I could use ->> to unquote it. But then my code wouldn't be database agnostic anymore. On a MySQL Database this would fail. And MySQL is unquoting it by default. Shouldn't this behavior be the same on MariaDB?

ybr-nx commented 4 years ago

What's the version of MariaDB server?

ybr-nx commented 4 years ago

Can it be related to the last section of this one? https://github.com/ybr-nx/laravel-mariadb/blob/master/README.md

buddhaCode commented 4 years ago

It's version 10.3.15. So the bug should be fixed in my version.