Jan 21 2019 new release

New Features:

• add mysql environment verbose info
• add JSONFind function, which support JSON iterate
• add new test database world_x
• SplitStatement support optimizer hint /*+xxx */
• include bats bash auto test framework
• replace mysql database driver mymysql with go-sql-driver
• add new -report-type [ast-json, tiast-json]
• command line dsn args support '@', '/', ':' in password
• add new heuristic rule RES.009, "SELECT * FROM tbl WHERE col = col = 'abc'"
• add new heuristic rule RuleColumnNotAllowType COL.018
• add string escape function for security

Fixed BUGs:

• fix #173 with JSONFind WHERE col = col = '' and col1 = 'xx'
• fix #184 table status field datatype overflow
• fix explain result with multi rows error
• fix #178 JSON datatype only support utf8mb4
• fix #122 single table select * don't auto-complete table name
• fix #171 support socket access type
• fix #58 sampling not deal with NULL able string
• fix #172 compatible with mysql 5.1, which explain has no Index_Comment column
• fix #163 column.Tp may be nil, which may raise panic
• fix #151 bit type not config as int, when two columns compare will give ARG.003 suggestion.

Dec 05 2018 new release

2018-11 change log

• add all third-party lib into vendor
• support -report-type chardet
• add more heuristic rules: TBL.008, KEY.010, ARG.012, KWR.004
• add -cleanup-test-database command-line arg
• add -check-config parameter
• fix #146 pretty cause syntax error
• fix #140 COL.012, COL.015 NULL type about TEXT/BLOB
• fix #141 empty output when query execute failed on mysql
• fix #89 index advisor give wrong database name, optimizer_xx
• fix #121 RemoveSQLComment trim space
• fix #120 trimspace before check single line comment
• fix mac os stdout print buffer truncate
• fix -config arg load file error
• fix #116 SplitStatement check if single comment line is in multi-line sql.
• fix #112 multi-line comment will cause line counter error, when -report-type=lint
• fix #110 remove bom before auditing
• fix #104 case insensitive regex @ CLA.009
• fix #87 RuleImplicitConversion value type mistach check bug
• fix #38 always true where condition check
• abandon stdin terminal interactive mod, which may seems like hangup

Nov 11 2018 new release

• add -cleanup-test-database command-line arg
• fix -config arg load file error
• fix #87 RuleImplicitConversion value type mistach check bug
• fix #38 always true where condition check
• abandon stdin terminal interactive mod, which may seems like hangup

make windows command-line more compatible

1. fix most windows user's problem
2. fix spell error

v0.8.0

CHANGELOG

• first release