How to reproduce: Using the following query, it generates a VARCHAR | NULL result
- module: sql
metricsets:
- query
period: 10s
# hosts: ["dbname=ps user=root pass=root host=172.18.0.2"]
hosts: ["root:root@tcp(172.18.0.2:3306)/ps"]
driver: "mysql"
sql_query: "SELECT 'key', NULL"
sql_response_format: variables
- module: sql
metricsets:
- query
period: 10s
# hosts: ["dbname=ps user=root pass=root host=172.18.0.2"]
hosts: ["root:root@tcp(172.18.0.2:3306)/ps"]
driver: "mysql"
sql_query: "SELECT 'key', NULL"
sql_response_format: tableExpected output:
{
"sql": {
"query": "SELECT 'key', NULL",
"metrics": {
"numeric": {},
"string": {
"key": "NULL"
}
},
"driver": "mysql"
}
}
{
"sql": {
"query": "SELECT 'null', NULL",
"metrics": {
"numeric": {},
"string": {
"key": "NULL"
}
},
"driver": "mysql"
}
}Expected output:
{
"sql": {
"query": "SELECT 'key', NULL",
"metrics": {
"numeric": {},
"string": {
"key": null
}
},
"driver": "mysql"
},
"event": {
"dataset": "sql.query",
"module": "sql",
"duration": 603087
}
}
{
"sql": {
"query": "SELECT 'key', NULL",
"metrics": {
"numeric": {},
"string": {
"key": null
}
},
"driver": "mysql"
},
}
How to reproduce: Using the following query, it generates a
VARCHAR| NULL resultExpected output:
{ "sql": { "query": "SELECT 'key', NULL", "metrics": { "numeric": {}, "string": { "key": "NULL" } }, "driver": "mysql" } } { "sql": { "query": "SELECT 'null', NULL", "metrics": { "numeric": {}, "string": { "key": "NULL" } }, "driver": "mysql" } }Expected output:
{ "sql": { "query": "SELECT 'key', NULL", "metrics": { "numeric": {}, "string": { "key": null } }, "driver": "mysql" }, "event": { "dataset": "sql.query", "module": "sql", "duration": 603087 } } { "sql": { "query": "SELECT 'key', NULL", "metrics": { "numeric": {}, "string": { "key": null } }, "driver": "mysql" }, }