XiaoMi / soar

SQL Optimizer And Rewriter
Apache License 2.0
8.67k stars 1.32k forks source link

index advisor give wrong database name, `optimizer_xx` is temporary database #89

Closed eagle2016 closed 5 years ago

eagle2016 commented 5 years ago

Please answer these questions before submitting your issue. Thanks!

  1. What did you do? If possible, provide a recipe for reproducing the error. Environment: I have installed mysql server using glibc binary file.. and I execute command:

echo "update test set col1=2 where col1=1" | /usr/local/bin/soardebug -online-dsn="root:test1234@10.64.140.31:3307/online" -test-dsn="root:test1234@10.64.140.31:3307/test"

result as follows:

image

now I think `optimizer_181108155319_f5gh7cxdl26tcsyw\ is not correct, the correct string is "online"

  1. What version of are you using (soar -version)?

[root@bak-autodb ~]# /usr/local/bin/soardebug --version Version: 2018-11-05 14:02:42 +0800 @d070981 Branch: master Compile: 2018-11-07 15:37:27 +0800 by go version go1.10.4 darwin/amd64 GitDirty: 104