SQLAdvisor

SQLAdvisor copied to clipboard

索然选择度为1，但是加上索引之后明显效果很好，但是sqladvisor却没有检测出来！很失望

wangweilica

docker里安装完后，执行SQL，报错New state of 'nil' is invalid.

5

[root@044d01672267 sqladvisor]# sqladvisor -h 192.168.13.17 -u root -p root -P 3 306 -d hb -q "SELECT loanterm,ApproveTerm,inputorgid,businesstype FROM business_ apply WHERE serialno='B00501003011610130001';" -v 1 New state of 'nil' is invalid....

washi4

能否离线使用

1

不连接数据库，单纯的解析SQL

bolycooper

优化建议能否增加表或者视图判断，视图无法添加索引

raymondchen-byte

Invalid parameter number

1

bolycooper

有a/b/c三张表 create table a (id int auto_increment,seller_id bigint,seller_name varchar(100) collate utf8_bin ,gmt_create varchar(30),primary key(id)); create table b (id int auto_increment,seller_name varchar(100),user_id varchar(50),user_name varchar(100),sales bigint,gmt_create varchar(30),primary key(id)); create table c (id...

sekift

caimaoy

insert语句在结果上是最终没有插入数据的，但是在执行过程中是否是“先插入数据到数据库，测试后删除”呢？

hanlonbi

An0nymous0

` /usr/local/sqlparser/include/sql/item_timefunc.h: In member function ‘virtual longlong Item_time_func::val_int()’: /usr/local/sqlparser/include/sql/item_timefunc.h:533:12: warning: converting to non-pointer type ‘longlong {aka long long int}’ from NULL [-Wconversion-null] return NULL; ` 版本： g++ (GCC) 4.8.5 20150623...

chaubeau