首先我使用Navicat查询,语句可以执行成功,且可以取出数据
SELECT DECODE( DEFECT_LEVEL, 'important','重要缺陷', 'greatDefect','重大缺陷', 'normal','一般缺陷' ) AS 缺陷等级, SUM ( DECODE( DEFECT_TYPE, 'EXECUTE_DEFECT',1, 0 ) ) 执行缺陷, SUM ( DECODE( DEFECT_TYPE, 'DESIGN_DEFECT',1, 0 ) ) 设计缺陷, SUM ( DECODE( DEFECT_TYPE, 'DESIGN_EXECUTE_DEFECT',1, 0 ) ) 设计及执行缺陷, SUM ( DECODE( DEFECT_TYPE, 'DEFAULT_DEFECT',1, 0 ) ) 其他无法整改缺陷 FROM ERM_IC_DEFECT_LIBRARY GROUP BY DEFECT_LEVEL;
然后我把语句放到帆软设计器上执行,就报错com.fr.general.data.TableDataException:错误代码:113000
各位大神们,怎么回事啊?
|