Project

General

Profile

Feature #303

SQL查询语句中“rownum”在MySQL数据库中不支持,导致查询不到结果

Added by jiwei shi about 5 years ago. Updated about 5 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Target version:
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

#1

Updated by xiangyang li about 5 years ago

应用方需要根据se_dcedef.h 中的数据库类型定义(SEDB_SERVER_TYPE),分别提供不同的SQL语句

#2

Updated by xiangyang li about 5 years ago

  • Assignee set to jiwei shi
#3

Updated by xiangyang li about 5 years ago

  • Tracker changed from Bug to Feature
#4

Updated by jiwei shi about 5 years ago

  • Status changed from New to In Progress
  • % Done changed from 0 to 90

测试

#5

Updated by jiwei shi about 5 years ago

  • Status changed from In Progress to Resolved
  • % Done changed from 90 to 100

Also available in: Atom PDF