You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/05/03 07:27:03 UTC
[GitHub] [shardingsphere] TeslaCN opened a new issue #10248: Proxy PostgreSQL doesn't support PREPARE & EXECUTE
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:
users@infra.apache.org