search

yajra / laravel-oci8

Oracle DB driver for Laravel via OCI8
https://yajrabox.com/docs/laravel-oci8
MIT License
834 stars 237 forks source link

[v11.6.1] Randomly Error: ORA-00907: missing right parenthesis #891

Closed nathanaelytj closed 1 month ago

nathanaelytj commented 1 month ago

Summary of problem or feature request

After upgrading to v11.6.1 the log suddenly reporting some strange issues:

Error Code : 907 Error Message : ORA-00907: missing right parenthesis Position : 158 Statement : select from (select "ORAFIN"."R_JOB"., row_number() over (order by "ID_JOB" asc) as rn from (select * from "ORAFIN"."R_JOB" order by "ID_JOB" asc) "ORAFIN"."R_JOB") "ORAFIN"."R_JOB" where rn between 1 and 1000 Bindings : []

This doesn't happen in v11.6.0 so downgrading solved the issue for now.

Code snippet of problem

This bug randomly happen to any Laravel Model. Attached is sinppet of the trace:

{ "class": "Illuminate\\Database\\QueryException", "message": "Error Code : 907\nError Message : ORA-00907: missing right parenthesis\nPosition : 158\nStatement : select * from (select \"ORAFIN\".\"R_JOB\".*, row_number() over (order by \"ID_JOB\" asc) as rn from (select * from \"ORAFIN\".\"R_JOB\" order by \"ID_JOB\" asc) \"ORAFIN\".\"R_JOB\") \"ORAFIN\".\"R_JOB\" where rn between 1 and 1000\nBindings : []\n (Connection: kettle, SQL: select * from (select \"ORAFIN\".\"R_JOB\".*, row_number() over (order by \"ID_JOB\" asc) as rn from (select * from \"ORAFIN\".\"R_JOB\" order by \"ID_JOB\" asc) \"ORAFIN\".\"R_JOB\") \"ORAFIN\".\"R_JOB\" where rn between 1 and 1000)", "code": 907, "file": "/var/www/vhosts/localhost/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825", "trace": [ "/var/www/vhosts/localhost/vendor/laravel/framework/src/Illuminate/Database/Connection.php:779", "/var/www/vhosts/localhost/vendor/laravel/framework/src/Illuminate/Database/Connection.php:398", "/var/www/vhosts/localhost/vendor/yajra/laravel-oci8/src/Oci8/Query/OracleBuilder.php:159", "/var/www/vhosts/localhost/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3073", "/var/www/vhosts/localhost/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3661", "/var/www/vhosts/localhost/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3072", "/var/www/vhosts/localhost/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:759", "/var/www/vhosts/localhost/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:741", "/var/www/vhosts/localhost/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php:172", "/var/www/vhosts/localhost/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php:124",

System details

yajra commented 1 month ago

Oh my bad, I think I tagged on the wrong branch. I will rebuild a new release.

yajra commented 1 month ago

Fixed via https://github.com/yajra/laravel-oci8/releases/tag/v11.6.2, thanks for reporting.