Stars in a year

[Pavel Karady]

Hello dreamteam,

it appears that during one day, for one user, stars appeared to be updated
on a DATE type column, instead of a regular year. This is a section from the
transaction log:

--BEGIN TRANSACTION
--UPDATE-1104-0070106663
--UPDATE DBA.table
-- SET col1='9999-12-31 00:00',
-- col2='****-01-07 00:00',
-- col3='9999-12-30 00:00'
-- WHERE primarykey=1652033

...

--COMMIT-1104-0070107381
--COMMIT WORK

This transaction failed then when it was replicated to the other database,
where of course, **** as a year in DATE value is a wrong way to go. If not
the replication, we would probably never found this out.

Has anyone experienced this before as we are not able to reproduce it

Thanks in advance
Pavel

[Unknown]

Already fixed I believe

From a recent 9.0.2 ebf

================(Build #3389 - Engineering Case
#443642)================

If an application sent a timestamp structure host parameter which contained
an invalid year, the server would not have generated an error if the
database
option Conversion_error was On. Timestamp structures are used for example,
with the embedded
SQL type DT_TIMESTAMP_STRUCT, and the ODBC type SQL_TIMESTAMP. If a stored
timestamp value with an invalid year was converted to a string, the year
component of the string would have contained asterisks (e.g. ****-02-28 ).
This has now been fixed so that the server correctly generates the error
SQLE_CONVERSION_ERROR (-157) for invalis timestamp structures, even when
the option Conversion_error is On.

"Pavel Karady" <pavel_ns.ns_karady@ns_kogerusa.com> wrote in message
news:462cca28@forums-1-dub...

[Pavel Karady]

That's probably it. Thanks Nick

Pavel

"Nick Elson" <@n@o@.@s@p@a@m@.@n@i@c@k@.@e@l@s@o@n@s@y@b@a@s@e@.@c@o@m@>
wrote in message news:462cff53$1@forums-1-dub...

[Pavel Karady]

After reading what help says about Conversion_error, Nick, you are saying
that

"If an application sent a timestamp structure host parameter which contained
an invalid year, the server would not have generated an error if the
database option Conversion_error was On"

according to the help, I believe this sentence should have ended with the
word "Off"..?

Thanks,
Pavel

"Nick Elson" <@n@o@.@s@p@a@m@.@n@i@c@k@.@e@l@s@o@n@s@y@b@a@s@e@.@c@o@m@>
wrote in message news:462cff53$1@forums-1-dub...