Re:A ChatGPT mistake cost us $10k
by randomdata on Tuesday June 11, 2024 @12:14PM
(#40648064)
Fair enough, although it wouldn't matter if it did. Nothing would change other than some unnecessary computation would occur. SQL supports it just fine. Anyone who learned SQL first would know that quite well.
[ Parent
| on HN ]
Fair as well. It's just sending a command which you know will fail, and even relying on the fact it fails, feels wrong, whether it sends a request over network or not.
BTW I checked and it's not an error in Postgres, only a warning. Still not something I would want in my database logs for the happy path.
Re:A ChatGPT mistake cost us $10k
by randomdata on Tuesday June 11, 2024 @01:42PM
(#40649252)
You know it will fail if you didn't screw up anything else.
But it's a good sanity check/safety measure to call it anyway incase you made a mistake elsewhere. An errant rollback is more likely to be caught in testing than a dangling transaction.