[Bug] [Module Name] Bug title datax reads SqlServer metadata information and generates metadata field errors #14941
Description
Search before asking
- I had searched in the issues and found no similar issues.
What happened
读取元数据字段，生成“`”,针对SqlServer 读取的元数据应该为“[column_name]”
{
"content":[
{
"reader":{
"name":"mysqlreader",
"parameter":{
"username":"",
"password":"",
"connection":[
{
"querySql":[
"select ID ,\r\n PID ,\r\n SKU ,\r\n Qty ,\r\n Status ,\r\n Operator ,\r\n OperateTime ,\r\n Approver ,\r\n ApprovalResult ,\r\n PackingQty ,\r\n NID \r\n from oc_warehouse_packinglist_data\r\n "
],
"jdbcUrl":[
"jdbc:mysql://"
]
}
]
}
},
"writer":{
"name":"sqlserverwriter",
"parameter":{
"username":"",
"password":"",
"column":[
"ID",
"PID",
"SKU",
"Qty",
"Status",
"Operator",
"OperateTime",
"Approver",
"ApprovalResult",
"PackingQty",
"NID"
],
"connection":[
{
"table":[
""
],
"jdbcUrl":"jdbc:sqlserver:"
}
],
"preSql":[
"truncate table "
]
}
}
}
],
"setting":{
"speed":{
"channel":1,
"record":1000
},
"errorLimit":{
"record":0,
"percentage":0
}
}
}
What you expected to happen
针对SQLServer的读取元数据匹配可以调整相关匹配信息
How to reproduce
配置一下
Anything else
No response
Version
3.1.x
Are you willing to submit PR?
- Yes I am willing to submit a PR!
Code of Conduct
- I agree to follow this project's Code of Conduct