"sparkerman" wrote:
When I was publishing an update to my private channel, i was setting the minimum firmware version to a lower version than my published channel. Apparently any already published channels with a higher version number will cause the updated channel with the lower version not to update on my Roku player. This was something I didn't take into account or now about.
Wait, what? I thought min.firmware requirement was defined to only "increase monotonically", i.e. not letting you go back.
Seems more like a bug in the implementation rather than faulty design. I.e. the DB query is wrong, it should be something like (simplifying, in reality it should be at least a join to handle all channels on account):
SELECT TOP 1 bundle# FROM bundle_bag
WHERE channel# = :ID
AND min_firmware# <= :PLAYER_FW#
AND version# > :INSTALLED_VER
ORDER BY version# DESC
... and what they are doing is sorting by min_firmware or unsorted. It's tricky but not hard if you think about the case.