Sorry for a bug like me bothering giants
There's no need for such a disclaimer, at least in my topics.
How did you go from "I'm Erumo - Master of the Universe" to being humble?Nope. Worst case scenario is that it won't get picked up and processed by a miner. It will return to your wallet, not that it ever left. I can't quite remember but I think that'll take 10-14 days to play out.
It depends on the wallet. Bitcoin Core keeps broadcasting the transaction, so it will never expire and never "return" to the wallet (unless you manually intervene). Years ago, I had to double spend a transaction that was "stuck" for 2 weeks with 0 fee (zero fee transactions were still possible at the time).
If the wallet doesn't keep broadcasting, I think it varies a bit per service/miner/mempool/block explorer. Take
this transaction for example: I made it from Electrum, but instantly closed the wallet so it can't broadcast it again.
Blockchair.com still remembers it was broadcasted 5 days ago,
Blockchain.com says it was received yesterday, and
BlockCypher.com doesn't know the transaction at all. I manually keep
broadcasting it until it confirms.
On Mycelium (Android mobile) I've had a low-fee (consolidation) transaction "stuck" for a few weeks, and I couldn't easily stop it from broadcasting to spend the funds elsewhere. I could have taken drastic measures like uninstalling the app, but it wasn't worth it at the time. Eventually, it confirmed.
Even with fees as they are it's quite possible someone will process it during that time. There would be many peaks and troughs during a couple of weeks. I've had some lengthy waits whilst skimping but I've never had one fail to get there eventually.
It will get interesting when mempool grows to several GB in size. I expect transactions with the lowest fees to be dropped first.
Update:
nc50lc beat me to it