When doors are placed into automatic I have understood this to mean that should the door be opened the slide will automatically deploy.

It stands to reason that the passenger operated over-wing exits will always cause a slide deployment if opened while the exit signs are illuminated and the door is not locked. I believe that on modern aircraft types the extinguishing of the illuminated exit sign means the door is locked and cannot be opened in flight (putting aside the impossibility of opening due to pressure blah blah).

Is my understanding correct?