If you set your wallet to pay zero transaction fee what happens? Is there more than one possibility.

It makes sense that no transaction fee means that you get no priority, but will the transaction always be processed eventually? If yes, what is the maximum time frame? If no, is there a maximum time limit before it bounces back? Could it be stuck in limbo for months?