select * from test INNER JOIN( VALUES ('1'), ('2'), ('3'), ('4'), ('5') ) vals(v) ON(test.ID = v)这类的sql在跑的时候，会抛出java.sql.SQLException: sql injection violation, syntax error:的异常
select * from test INNER JOIN( VALUES ('1'), ('2'), ('3'), ('4'), ('5') ) vals(v) ON(test.ID = v)
1.1.10版本
e7arh2l61#
SELECT * FROM test WHERE ID = ANY( VALUES ('1'), ('2'), ('3'), ('4'), ('5') )这样写也有问题
SELECT * FROM test WHERE ID = ANY( VALUES ('1'), ('2'), ('3'), ('4'), ('5') )
1条答案
按热度按时间e7arh2l61#
SELECT * FROM test WHERE ID = ANY( VALUES ('1'), ('2'), ('3'), ('4'), ('5') )这样写也有问题