Refine the column types for synthetic tables added by the database-polling strategy

Description

Let’s review the type of all columns added by the database-polling coordination strategy.

In particular, I see that the payload column of the outbox table has type binary, where varbinary seems more appropriate. Also, it has a length of 8192 , but 8000 would be better for SQL server in particular, because it avoids switching from the varbinary type to the image type. I’m not sure which size would be best, however; maybe that should be configurable.

Other columns might have similar problems.

Activity

Show:
Fixed

Details

Assignee

Reporter

Sprint

Fix versions

Priority

Created August 9, 2021 at 11:25 AM
Updated July 22, 2022 at 6:32 AM
Resolved November 2, 2021 at 10:55 AM