MySQL error with /*blazer,run_id:4a78f4dd-5271-4361-8a7e-0c9a7ab95c1e*/ #109

Closed
hovancik opened this Issue Dec 16, 2016 · 1 comment

Projects

None yet

2 participants

@hovancik
Contributor

screen shot 2016-12-16 at 13 56 27

ruby 2.3.1
rails 4.2.7.1
mysql 5.7.16/5.5.53

default blazer config

console:

Started POST "/blazer/queries/run" for ::1 at 2016-12-16 13:50:13 +0100
Processing by Blazer::QueriesController#run as HTML
  Parameters: {"statement"=>"SELECT * FROM \"uploads\"", "data_source"=>"main", "run_id"=>"4a78f4dd-5271-4361-8a7e-0c9a7ab95c1e"}
   (0.2ms)  BEGIN
   (1.6ms)  SELECT * FROM "uploads" /*blazer,run_id:4a78f4dd-5271-4361-8a7e-0c9a7ab95c1e*/
   (0.2ms)  ROLLBACK
  Rendered /Users/janhovancik/.rvm/gems/ruby-2.3.1/gems/blazer-1.7.6/app/views/blazer/queries/run.html.erb (3.8ms)
Completed 200 OK in 49ms (Views: 33.3ms | ActiveRecord: 2.0ms)

error:

Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"uploads" /*blazer,run_id:4a78f4dd-5271-4361-8a7e-
@ankane ankane closed this in 1f9e2ae Dec 16, 2016
@ankane
Owner
ankane commented Dec 16, 2016

Hey @hovancik, thanks for reporting. Should be fixed on master.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment