Feature #303
SQL查询语句中“rownum”在MySQL数据库中不支持,导致查询不到结果
Start date:
10/23/2019
Due date:
% Done:
100%
Estimated time:
Defect version:
Description
Oracle数据库的sql语句支持“rownum”限定查询结果数量,而MySQL数据库不支持带有“rownum”的sql语句;
如:PA插件广播区域查询语句:"select F1002_BAYAREACODE,F1002_BAYAREADESC,F1002_ASSIGNMENT from SEMODEL.TB1002_BAYAREA where F1002_BAYAREA = 1 and rownum < 9 order by F1002_ASSIGNMENT"查询失败导致PA界面不显示区域复选框;
其它还带有“rownum”的sql语句的工程有:历史插件、ehmmc等。
History
Updated by xiangyang li about 5 years ago
应用方需要根据se_dcedef.h 中的数据库类型定义(SEDB_SERVER_TYPE),分别提供不同的SQL语句
Updated by jiwei shi about 5 years ago
- Status changed from New to In Progress
- % Done changed from 0 to 90
测试
Updated by jiwei shi almost 5 years ago
- Status changed from In Progress to Resolved
- % Done changed from 90 to 100