Jump to content

cokn

Members
  • Posts

    1
  • Joined

  • Last visited

Posts posted by cokn

  1. Добрый день!

    KSC 14.2
    Postgres 14

    Название задачи: Синхронизация обновлений Windows Update

    Текст ошибки:

    Цитата

    Generic db error: "[42804]`ОШИБКА:  в конструкции COALESCE типы bytea и integer не имеют общего at character 760
    `, Q=`WITH "tmp" AS (SELECT "wus_upd_decryption_key"."ctid" AS "wus_upd_decryption_key_ctid", "__ttmp_wus_upd_decryption_key"."imgKey" AS "column_alias_0", COALESCE( "__ttmp_wus_upd_decryption_key"."binMd5" , '\x00' ) AS "column_alias_1" FROM "__ttmp_tmp_wus_ids" INNER JOIN  "wus_upd_decryption_key" ON "wus_upd_decryption_key"."nRevisionID" = "__ttmp_tmp_wus_ids"."nRevisionID" LEFT OUTER JOIN  "__ttmp_wus_upd_decryption_key" ON "__ttmp_wus_upd_decryption_key"."strUpdateID" = "wus_upd_decryption_key"."strUpdateID" AND "__ttmp_wus_upd_decryption_key"."nRevisionNumber" = "wus_upd_decryption_key"."nRevisionNumber" AND "__ttmp_wus_upd_decryption_key"."binFileDigest" = "wus_upd_decryption_key"."binFileDigest" WHERE COALESCE( "wus_upd_decryption_key"."binMd5" , 0 ) <> COALESCE( "__ttmp_wus_upd_decryption_key"."binMd5" , '\x00' ) ) UPDATE "wus_upd_decryption_key" SET "imgKeyCan...

    Подскажите, пожалуйста, с чем может быть связана проблема?

×
×
  • Create New...