Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

PG执行SQL语句出错 #1727

Closed
kissss opened this issue May 10, 2017 · 2 comments
Closed

PG执行SQL语句出错 #1727

kissss opened this issue May 10, 2017 · 2 comments
Labels
Milestone

Comments

@kissss
Copy link

kissss commented May 10, 2017

sql:

WITH sel AS (SELECT
       unnest(ARRAY [4275]) AS gdid,
       unnest(ARRAY [1])    AS gdnumber)
UPDATE goods_detail
SET gd_number = gd_number - gdnumber FROM sel
WHERE gd_id = gdid;

错误信息


org.springframework.jdbc.UncategorizedSQLException: 
### Error updating database.  Cause: java.sql.SQLException: sql injection violation, syntax error: TODO : WITH sel AS (SELECT
               unnest(ARRAY [4275]) AS gdid,
               unnest(ARRAY [1])    AS gdnumber)
UPDATE goods_detail
SET gd_number = gd_number - gdnumber FROM sel
WHERE gd_id = gdid;
### SQL: WITH sel AS (SELECT                unnest(ARRAY [4275]) AS gdid,                unnest(ARRAY [1])    AS gdnumber) UPDATE goods_detail SET gd_number = gd_number - gdnumber FROM sel WHERE gd_id = gdid;
### Cause: java.sql.SQLException: sql injection violation, syntax error: TODO : WITH sel AS (SELECT
               unnest(ARRAY [4275]) AS gdid,
               unnest(ARRAY [1])    AS gdnumber)
UPDATE goods_detail
SET gd_number = gd_number - gdnumber FROM sel
WHERE gd_id = gdid;
; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; sql injection violation, syntax error: TODO : WITH sel AS (SELECT
               unnest(ARRAY [4275]) AS gdid,
               unnest(ARRAY [1])    AS gdnumber)
UPDATE goods_detail
SET gd_number = gd_number - gdnumber FROM sel
WHERE gd_id = gdid;; nested exception is java.sql.SQLException: sql injection violation, syntax error: TODO : WITH sel AS (SELECT
               unnest(ARRAY [4275]) AS gdid,
               unnest(ARRAY [1])    AS gdnumber)
UPDATE goods_detail
SET gd_number = gd_number - gdnumber FROM sel
WHERE gd_id = gdid;

在 语法解析上面有问题

wenshao added a commit to wenshao/druid that referenced this issue May 10, 2017
@wenshao wenshao added this to the 1.0.30 milestone May 10, 2017
@wenshao wenshao added the Bug label May 10, 2017
@wenshao
Copy link
Member

wenshao commented May 10, 2017

已经修复,预计在这个周末发布新版本

@wenshao
Copy link
Member

wenshao commented May 14, 2017

已经支持,请使用新版本 https://github.com/alibaba/druid/releases/tag/1.0.30

@wenshao wenshao closed this as completed May 14, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants