How can all_weather be different from 1 if race_type_id is 15?

Question

For race_type_id = 15 (all weather flat) some of the entries in historic_races have all_weather =0 and others have all_weather = 1.  How can all_weather be different from 1 if race_type_is is 15.  Thank you.

Answer 1

Ok, I see what you mean - the all_weather field is not completely reliable compared to the race_type_id or race_type description.  Note that generally the race_type_id is best for these sort of queries (ie. race_type queries).

Comments

In the version of the SmartForm database that I have (probably a year old and I haven't [yet!] subscribed to the monthly updates) there is a field all_weather that takes values 0, 1, or NULL.  I'm just wondering if it is best to ignore it and use race_type_id = 15 instead to select races on all_weather tracks.

---

Yes - as above. In fact, since I generally don't use the all_weather field hadn't noticed it had some erroneous entries.  We'll correct this in a future version, but sticking with race_type or race_type_id is best; race_type is also replicated in the daily_races table, whereas all_weather is not.

---

Have the erroneous entries been updated? If not, is there an intention to do so?