TeslaCN opened a new issue #10248:
URL: https://github.com/apache/shardingsphere/issues/10248
## Feature Request
### Is your feature request related to a problem?
### Describe the feature you would like.
#### PostgreSQL
When I use `psql` connect PostgreSQL directly
```
elasticjob=# prepare select_by_ip as select * from job_execution_log where
ip = $1 limit 3;
PREPARE
elasticjob=# execute select_by_ip ('192.168.3.233');
id | job_name |
task_id | hostname | ip |
shard
ing_item | execution_source | failure_cause | is_success | start_time
| complete_time
--------------------------------------+------------+--------------------------------------------------------------------+---------------+---------------+------
---------+------------------+---------------+------------+-------------------------+-------------------------
3a13b73a-1287-4011-814f-06e72e5e4631 | my-dag-job |
my-dag-job@-@0,1,2,3,4,5,6,7,8,9@-@READY@-@192.168.3.233@-@1951901 |
local-wwj-icu | 192.168.3.233 |
1 | NORMAL_TRIGGER | | t | 2020-09-14
20:18:20.097 | 2020-09-14 20:18:20.098
8448933a-545d-4508-b446-d0a0d565f5ca | simple |
simple@-@0,1,2@-@READY@-@192.168.3.233@-@3501515 |
local-wwj-icu | 192.168.3.233 |
1 | NORMAL_TRIGGER | | t | 2020-09-04
23:17:35.162 | 2020-09-04 23:17:35.174
7150464c-674e-4e81-a43b-b11a7b1099df | simple |
simple@-@0,1,2@-@READY@-@192.168.3.233@-@3501515 |
local-wwj-icu | 192.168.3.233 |
2 | NORMAL_TRIGGER | | t | 2020-09-04
23:17:35.162 | 2020-09-04 23:17:35.174
(3 rows)
```
#### Proxy PostgreSQL
```
hello_ss=> prepare select_by_user as select * from t_order where user_id =
$1;
ERROR: You have an error in your SQL syntax
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
