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!

That's a good book.

Aaand why did you do that?

@nickhh Accidents happen

@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.

A) ouch!
B) dummy.
C) yay backups
D) do not repeat

I 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 !

Never ever do anything that could break anything (even if completely unrelated) on friday (ever). :)

@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...

That's a bummer...

Congratulations on ranting about it before he could 👍

That tells you that he thinks you need to read more.

that book is worth its money.

THE 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?

@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... :/

The 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...

How can you do that accitendally? 😀