Bug #6996
ferméProblème de script SQL sur migration 5.14 vers 5.15
100%
Description
ERROR RETURNED BY THE RDBMS : La diffÚrence entre deux colonnes datetime a pr
ovoquÚ un dÚpassement de capacitÚ au moment de l'exÚcution.
*STATEMENT ON ERROR IS : /
Copying the media data.
*/
INSERT INTO SC_Gallery_Media (mediaId, mediaType, instanceId,
title, description, author, keyWord,
beginVisibilityDate, endVisibilityDate,
createDate, createdBy, lastUpdateDate, lastUpdated
By)
SELECT
cast(photoId as varchar),
'Photo',
instanceId,
title,
description,
author,
keyword,
case
when beginDate = '0000/00/00' THEN -2208992400000
else cast(DATEDIFF(s, '1970-01-01 00:00:00', convert(datetime, beginDate
, 111)) as bigint) * 1000
END,
case
when endDate = '9999/99/99' THEN 32503590000000
else cast(DATEDIFF(s, '1970-01-01 00:00:00', convert(datetime, endDate,
111)) as bigint) * 1000
END,
convert(datetime, creationDate, 111),
creatorId,
CASE WHEN updateDate IS NOT NULL THEN convert(datetime, updateDate, 111)
ELSE convert(datetime, creationDate, 111) END,
CASE WHEN updateDate IS NOT NULL THEN updateId
ELSE creatorId END
FROM
SC_Gallery_Photo_up005 d:\Silverpeas\dbRepository\mssql\gallery\up005\create
_table.sql.
ERROR - Database build FAILED (19/10/15 10:56).*********************************