Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
arantr22128y@wolt Yeah luckily we had backups and old enough to get the correct prices back with after a few hours of figuring out the correct sql queries.
-
pyCNe318yI did the same on a mysql database in production , wanted to change float to double using a db management tool and no more comma , whoops !
-
zankar20758yNever ever do anything that could break anything (even if completely unrelated) on friday (ever). :)
-
arantr22128y@cankarales I did it about two weeks ago but we found out about it now.
Customer was wondering why he could not set price in cents.
Kinda stupid that inserting a float with decimals after comma does not throw an error but converts it to an integer silently... -
sadjad10938yTHE QUESTION IS WHY YOU DIDN'T DEPLOY IT IN TEST/QAT FIRST SO THE CUSTOMER COULD TEST IT THEN ACCEPT IT BEFORE YOU DEPLOYED IT IN PROD?
-
arantr22128y@sadjad I know. We did, but we don't have automated tests, and nor the customer or we tested enough. The feature I was deploying was not about product prices... :/
-
arantr22128yThe good thing about this accident is that now we know that our backups are actually backups.
And also the errors in product prices are only below 1 € so the company probably did not loose/gain huge amounts of money...
Related Rants
Wonder why my colleague threw this book on my desk?
I accidentally changed all product prices from decimal(10,4) to decimal(10,0) on two live web shops with several thousands of products.
And it's friday 4 pm.
Have a nice weekend!
undefined
tgif