USE commands breaking laravel functionality

mar777121 commented 3 months ago

Hello,

[ ] A clear description of the issue php artisan migrate (in laravel) failing with:

SQLSTATE[42000]: Syntax error or access violation: 1148 Unable to parse: use database_name; (SQL: select * from information_schema.tables where table_schema = database_name and table_name = migrations and table_type = 'BASE TABLE')
[ ] ProxySQL version latest 2.6.4 dockerized version
[ ] The steps to reproduce the issue use stock laravel, run a php artisan migrate command
[ ] The full ProxySQL error log (default location: /var/lib/proxysql/proxysql.log) no error logs in ProxySQL log

2.6.3 dockerized version works fine

Best

renecannao commented 3 months ago

Hi @mar777121 . I am sorry to read about this issue.

Indeed in 2.6.4 we improved the way USE commands are parsed, and perhaps we didn't consider any edge case. Can you please provide the steps to reproduce it? Thanks!

mar777121 commented 2 months ago

Hi @mar777121 . I am sorry to read about this issue.

Indeed in 2.6.4 we improved the way USE commands are parsed, and perhaps we didn't consider any edge case. Can you please provide the steps to reproduce it? Thanks!

laravel installed, using proxysql in front
run php artisan migrate command from command line

renecannao commented 2 months ago

It seems @JavierJF identified the issue. We are already working on a fix

sysown / proxysql

USE commands breaking laravel functionality #4628