zhouzb

### What happened? 1. Set a field in the message to `null` in JSON, the output in SQL Test is also `null` in JSON, and use SQL in rule engine...

Characters starting with backslash cannot be used in SQL

1

My actual problems are as follows: ### Replenish Expect: ``` rtrim('\t hello \r\n') = '\t hello' tokens('a\rb\nc\r\nd', ';', 'nocrlf') = ['a', 'b', 'c', 'd'] ``` Actual: ``` rtrim('\t hello \r\n')...

Please support writing map type directly in SQL

2

### What would you like to be added or enhanced? Write directly in SQL to construct the map type, such as this: ``` SELECT {'a': {'b': 1}} as t1, map_put('b',...

### What happened? The following SQL will report an error: ``` SELECT contains('a', [sin(1), cos(1)]) as t1 FROM "t/#" ``` Unless changed to the following form: ``` SELECT sin(1) as...

### What happened? If I have the following payload: ``` [ {"name": "John"}, {"name": "David"} ] ``` I will not get any results using the following SQL: ``` FOREACH payload...

### What happened? SQL: ``` SELECT map_put('data.name', 'HELLO', payload) as payload FROM "t/#" ``` Data: ```json { "data": { "name": "John", "id": 1 } } ``` Expected Output: ```json {...

Health Check Interval repeats in configuration of the action and the connector

2

### What happened? Click Create Connector in the Azure Event Hubs event and when I expand the advanced settings, I see the Health Check Interval option. When I go back...

SQL Test cannot run when a field's value is null

4

### What happened? Payload: ``` { "msg": null } ``` SQL: ``` SELECT payload.msg as msg FROM "t/#" ``` Nothing happens when I click `Run Test` ### What did you...

If username is not set in SQL Test, the default value of username is an empty string

1

### What happened? If `username` is not set in SQL Test, the default value of `username` is an empty string: `""`. If I use MQTTX and `username` is not set...

File: [/zh_CN/rule/rule-engine_buildin_function.md](https://www.emqx.io/docs/zh/v4.4/rule/rule-engine_buildin_function.html)