Sql server old bug on update with the same colum

• andrea.dimaio

  Mr or Mrs. 500

  Points: 543

  More actions

  January 31, 2017 at 8:05 am

  #334743

  Hello

  Don't think i'm crazy 🙂 but i remember there was a known bug on sql server update that as been fixed a long time ago but now i cannot remember the name has given to that bug 🙁

  It happens when u had something like this:

  update table_name set A = A + B from table_name

  Someone can remeber?

  Thanks

• Luis Cazares

  SSC Guru

  Points: 183698

  More actions

  January 31, 2017 at 9:47 am

  #1925905

  andrea.dimaio - Tuesday, January 31, 2017 8:05 AM

  Hello

  Don't think i'm crazy 🙂 but i remember there was a known bug on sql server update that as been fixed a long time ago but now i cannot remember the name has given to that bug 🙁

  It happens when u had something like this:

  update table_name set A = A + B from table_name

  Someone can remeber?

  Thanks

  It's the Halloween Problem

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• andrea.dimaio

  Mr or Mrs. 500

  Points: 543

  More actions

  January 31, 2017 at 10:14 am

  #1925912

  Luis Cazares - Tuesday, January 31, 2017 9:47 AM

  andrea.dimaio - Tuesday, January 31, 2017 8:05 AM

  Hello

  Don't think i'm crazy 🙂 but i remember there was a known bug on sql server update that as been fixed a long time ago but now i cannot remember the name has given to that bug 🙁

  It happens when u had something like this:

  update table_name set A = A + B from table_name

  Someone can remeber?

  Thanks

  It's the Halloween Problem

  Great!!!!

  I was not sleeping to remeber that!!

  Thanks a lot 🙂