Having been AWOL from here for about a year, i don't know if anyone else has noticed anything like this, but I just noticed this playing one of my first games in a while on 2.42
While trying to maximize the bonus value on a gold caravan between 2 of my cities, i was moving around the workers in the destination city. When the destination city had resources available for production, it supplied beads, salt and dye and demanded hydes, wine and gold. However, when i started moving all the workers onto sea squares, production resources dropped to 0 and then deficit. When it hit 0, the trade commodities switched around to supplies beads, salt and wine, and demands copper, dyes and hydes. putting the workers back took it back to the original supply and demand.
Might be worth looking into in certain situations (ie certain OCC games when trying to maximize the caravan bonuses of early caravans - we buy them anyway, why not build some with resources set to 0)
Anyway, let me know if i'm behind the times now - off to work