The Heap™ – Consultancy ©®

« first day (5167 days earlier) ← previous day

Hannah Vernon

03:14

3 hours later…

Paul White

06:06

Article now available on my website for those allergic to 𝕏: MERGE Bug with Updates Though a View

Now featuring execution plans

1 hour later…

Paul White

07:12

I had Grok 3 proof-read it and suggest (very helpful, actually) improvements.

Paul White

07:32

Wordle 1,348 5/6*

⬛⬛⬛🟨⬛
🟨🟨🟩⬛⬛
⬛⬛🟩🟩🟩
⬛⬛🟩🟩🟩
🟩🟩🟩🟩🟩

2 hours later…

John K. N.

09:18

Wordle 1,348 5/6*

⬛⬛⬛🟨⬛
⬛⬛🟩⬛🟨
⬛⬛🟩🟩⬛
⬛⬛🟩🟩🟩
🟩🟩🟩🟩🟩

2 hours later…

Charlieface

11:12

> It takes the fact that the WHERE MATCHED clause

Should be "It takes the fact that the WHEN MATCHED clause"

You didn't mention that THEN DELETE also fails

Great article otherwise

Charlieface

11:29

Also not sure what the *** is going on with this, but it's a different error to the one you got dbfiddle.uk/iAfZ672J

Paul White

@Charlieface Well, as you know, I regard that as something that should be disallowed in general. It was a bit too much of a detour to work into this article. I wanted it to be quite short and focussed. Perhaps I will revisit it at some stage.

@Charlieface Yes, that's another possible error. Better than an assert. You might remember that error message from sql.kiwi/2024/09/a-small-sample-of-sql-server-chaos

It's just all broken anyway

2 hours later…