View Issue Details

IDProjectCategoryView StatusLast Update
0001757Database Comparer utilityGeneralpublic2023-02-19 09:56 Assigned Tobarry  
Status resolvedResolutionfixed 
Fixed in Version8.0.0.2459 
Summary0001757: 22.02.2022. v. fails in compare SP with PLAN clausule in SELECT
DescriptionFB4 - all SP containing code like this will fail
FOR SELECT id, idPeople, tDateUTC, Demand, LoLo, Lo, Hi, HiHi, tVersion --Select zbyvajici casti historie
      FROM DevMeasurandLimitsHist
      WHERE id = :V_idDevMeasurandLimit AND tDateUTC >= :bDateUTC AND tDateUTC< :eDateUTC
      PLAN SORT ((DevMeasurandLimitsHist INDEX (DevMeasurandLimitsHisttDateDesc)))
      ORDER BY id asc, tdateutc asc
      INTO :idDevMeasurandLimit, :idPeople, :tDateUTC, :Demand, :LoLo, :Lo, :Hi, :HiHi, :tVersion
Steps To ReproduceCreate s simple SP with SELECT ... PLAN
TagsNo tags attached.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2022-11-26 23:17 New Issue
2023-02-19 09:35 barry Assigned To => barry
2023-02-19 09:35 barry Status new => acknowledged
2023-02-19 09:37 barry File Deleted: wf2850_epson.png
2023-02-19 09:56 barry Status acknowledged => resolved
2023-02-19 09:56 barry Resolution open => fixed
2023-02-19 09:56 barry Fixed in Version =>