Steps to Reproduce:
update dbo.t1 set content='line
break' where id=1
Expected behavior: The line break stays as part of the value since it wasn't part of what was changed
Actual behavior: The line break disappears
SSMS's edit data has the correct behavior here
+1.
This bug is more sinister than the repro steps above make it appear. On the edit view, just using the down cursor over a cell that contains line breaks is enough to trigger a save and strip all line breaks. We've had completely unrelated rows corrupted due to someone editing one row, and using the down cursor over a few more rows.
@MaddyDev have you had a chance to look at this bug yet? It would be great to fix in May.
@kburtram Yes, I'm looking into this. I was able to find the issue but there doesn't seem to be a graceful way to handle this. Still working on it.
Glad it is being looked into, just found out this isn't happening.
Regards.
@MaddyDev do you have any updated on this issue? This would be a great task to pickup during committer time.