taobao / sqlautoreview Goto Github PK

There are two elements in the sqlmap.xml, but I didn't now what the format of D:\danchen\sql\test.xm. I'm new in database, so could you upload the test.xml to the github. Otherwise I didn't know what the format of sql map file. thanks

<file_id>100</file_id>
<file_name>D:\danchen\sql\test.xml</file_name>

For example:

match is a mysql function, if some table include match as its column, then start_createindex.sh will throw a exception that tells synctax error around
select count(distinct(match)) from table_name.

In fact, the correct syntax should be select count(distinct(match)) from table_name.

Solution may be:

1. setup a rule that column name can't be any function name
2. add necessary quote for this kind of column

I just corrected some typo.

sqlautoreview project:
Automatically review database dml sql(select,insert,update,delete),build create index script for every SQL statement, and merge all create index script with existing indexes on these tables.

author: [email protected]

If you want to know more about sqlautoreview project, please download sqlautorevew.ppt and sqlautoreview.docx

Contribution

The source code is under the terms of the GPL version 2. We are actively looking for contributors so if you have any ideas, bug reports, or patches you would like to contribute please do not hesitate to do so.

"patchs " should be "patches" ?