USE commands breaking laravel functionality

[mar777121]

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]

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]

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]

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