WITH RECURSIVE uTree AS ( SELECT id, real_name, puid FROM users WHERE id = 200011 UNION ALL SELECT t.id, t.real_name, t.puid FROM users t INNER JOIN uTree ON t.puid = uTree.id ) SELECT * FROM uTree
像这种语句,如果不加参数,运行起来会报错:
在webconfig.java中增加以下语句就好了:wallConfig.setStrictSyntaxCheck(false);
WallConfig wallConfig = new WallConfig(); wallConfig.setStrictSyntaxCheck(false); wallFilter = new WallFilter(); wallFilter.setConfig(wallConfig);