[IOTDB-4792] export-csv.bat uses like syntax exception

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: master branch
• Component/s: csv
• Assignee: Unassigned
• Reporter: 任宇华
• Created: 28/Oct/22 09:50
• Updated: 31/Oct/22 03:49

Description

./tools/export-csv.bat -h 127.0.0.1 -p 6667 -u root -pw root -td ./ -q "SELECT * FROM root.ws.ln where t_txt like '%cd%';"

 

在使用like语法时，会将  %cd%  转换为当前系统路径传递给iotdb，sql就会被转换为

 

SELECT * FROM root.ws.ln where t_txt like 'H:\environment\\iotdb
apache-iotdb-0.14.0-SNAPSHOT-all-bin'; 

 

导致失败，同时在bat的语法中，还有很多环境变量也是这样