Blog Post

Another AI Faux Pax

,

I was experimenting with a local model (article) and as a part of this, I pulled down a web interface for my model in a container. I ran it and had it in the background. I’ve randomly been asking questions as I need to look up things. I’m mostly curious how well it works.

This week I asked about CDC and got and interesting response.

This is part of a series of experiments with AI systems.

Updating a CDC Schema

I asked this question of my local mistral model: How do I alter a table in SQL SErver that is being tracked by CDC to add a new column?

That might not be the best way to phrase things, but I was on a call with a customer who was going to enable CDC and wanted to discuss how to manage this with schema changes. I’m not a CDC expert, so I was checking some documentation while chatting and decided to put this query in.

I got these results,

2025-01_0153

I thought I’d missed something, as I had never heard of sp_cdc_refresh_schema. Sure enough, I didn’t see it on MS Docs.

2025-01_0155

If I were trying to do this (pretend I’m a copy/paste DBA), I would see this:

2025-01_0156

So, the next step is to call the AI on this. It finds that it hallucinated and give me other ideas.

2025-01_0158

It gets worse. Now I create a proc and insert into the system tables, which isn’t recommended.

2025-01_0160

This won’t work either, but I can see people trying this.

First, if you get advice from the Internet, please always, always use a sandbox to test (what I also recommended to the customer), and second, treat any AI response like it came from a teenager.

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

5 (2)

You rated this post out of 5. Change rating

Share

Share

Rate

5 (2)

You rated this post out of 5. Change rating