Last December I went to pick up my new CX5 only to find they had ordered manual instead of automatic. Very apologetic, they reordered my car and gave me a loan car until it arrived.
Normally with Mazda, delivery is not as long as they receive regular shipments of various permutations of cars and you just normally have to wait for next shipment. In my case, about 7 weeks.