search

mikelucas-dynes / dummy

0 stars 0 forks source link

RATE_CODEs can break #8

Open mikelucas-dynes opened 6 years ago

mikelucas-dynes commented 6 years ago
  1. it is a varchar(10) but is a concatenation of RATE_PROD_CODE (varchar 10) and RATE_ROUTE_CODE (varchar 10) so will very likely overflow (and has, for Symonds)
  2. no collision detection is done for new RATE_CODES
  3. using non-opaque PKs is a bad idea
  4. you can use a composite PK instead
mikelucas-dynes commented 6 years ago

[[Issue: 63, Repo: Milk-Dispatch, OriginallyCreated: 2017-10-29T19:58:19Z, CreatedBy: leonardguy-dynes]]