Project

Profile

Help

HostedRedmine.com has moved to the Planio platform. All logins and passwords remained the same. All users will be able to login and use Redmine just as before. "Read more...":https://support.plan.io/news/187
Actions
Send by e-mail Copy link

Bug #937695

open

Некорректный перевод текста СУБД в мета вариант

Added by Сергей Старых over 1 year ago. Updated over 1 year ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Анализ техножурнала
Sprint/Milestone:
Разработка
Start date:
Due date:
% Done:

0%

Estimated time:

Description

UPDATE
    InfoRgSL5521
SET
    Period = RES.Period,
    Recorder = RES.Recorder,
        ...
FROM
(

SELECT InfoRg5488.Period,InfoRg5488.Recorder,InfoRg5488.Fld5489,InfoRg5488.Fld5490,InfoRg5488.Fld5491,InfoRg5488.Fld5492,InfoRg5488.Fld5506,InfoRg5488.Fld12794,InfoRg5488.Fld5498,InfoRg5488.Fld5499,InfoRg5488.Fld5501,InfoRg5488.Fld5497,InfoRg5488.Fld5507,InfoRg5488.Fld5500,InfoRg5488.Fld5517,InfoRg5488.Fld5514,InfoRg5488.Fld12795,InfoRg5488.Fld5496,InfoRg5488.Fld5494,InfoRg5488.Fld11694,InfoRg5488.Fld5503,InfoRg5488.Fld5504,InfoRg5488.Fld5510,InfoRg5488.Fld5512,InfoRg5488.Fld5513,InfoRg5488.Fld5495,InfoRg5488.Fld10367,InfoRg5488.Fld5493,InfoRg5488.Fld5502,InfoRg5488.Fld5511,InfoRg5488.Fld5505,InfoRg5488.Fld5508,InfoRg5488.Fld5518,InfoRg5488.Fld5515,InfoRg5488.Fld5516,InfoRg5488.Fld5509,InfoRg5488.Fld12796, InfoRg5488.Fld563
FROM
    (
        SELECT InfoRg5488.Fld5489, InfoRg5488.Fld5490, InfoRg5488.Fld5491, InfoRg5488.Fld5492,  MAX(InfoRg5488.Period) MINMAX_PERIOD
, InfoRg5488.Fld563
        FROM InfoRg5488
         INNER JOIN #TmpRecordSet ON
     InfoRg5488.Fld5489 = #TmpRecordSet.Fld5489
     AND  InfoRg5488.Fld5490 = #TmpRecordSet.Fld5490
     AND  InfoRg5488.Fld5491 = #TmpRecordSet.Fld5491
     AND  InfoRg5488.Fld5492 = #TmpRecordSet.Fld5492 AND  InfoRg5488.Fld563 = #TmpRecordSet.Fld563

        WHERE
InfoRg5488.Active=TRUE
        GROUP BY InfoRg5488.Fld5489, InfoRg5488.Fld5490, InfoRg5488.Fld5491, InfoRg5488.Fld5492, InfoRg5488.Fld563
    ) RES1 INNER JOIN InfoRg5488 ON 

            InfoRg5488.Fld5489=RES1.Fld5489
             AND InfoRg5488.Fld5490=RES1.Fld5490
             AND InfoRg5488.Fld5491=RES1.Fld5491
             AND InfoRg5488.Fld5492=RES1.Fld5492
             AND InfoRg5488.Fld563=RES1.Fld563
             AND InfoRg5488.Period=MINMAX_PERIOD
) RES
LEFT JOIN
InfoRgSL5521 ON
     InfoRgSL5521.Fld5489 = RES.Fld5489
     AND  InfoRgSL5521.Fld5490 = RES.Fld5490
     AND  InfoRgSL5521.Fld5491 = RES.Fld5491
     AND  InfoRgSL5521.Fld5492 = RES.Fld5492
     AND  InfoRgSL5521.Fld563 = RES.Fld563
WHERE
     InfoRgSL5521.Period < RES.Period

дает
...
        FROM РегистрСведений.упРаботыПоРейсу
         INNER JOIN #TmpRecordSet упРаботыПоРейсу_ИтогиСрезПоследних_ON
...
Actions
Copy link
 #1

Updated by Сергей Старых over 1 year ago

  • Description updated (diff)
Actions
Copy link
 #2

Updated by Сергей Старых over 1 year ago

  • Subject changed from Некорректный перевод текста СУБД в в мета to Некорректный перевод текста СУБД в мета варианте
Actions
Copy link
 #3

Updated by Сергей Старых over 1 year ago

  • Subject changed from Некорректный перевод текста СУБД в мета варианте to Некорректный перевод текста СУБД в мета вариант
Actions
Send by e-mail Copy link

Also available in: Atom PDF