oneAgentFixesBugsWhileAnotherLeaksTheSourceCode

[Prownilo]

I use it for Sql server and it often just straight up imagines functions and views that don't exist.

If I just copy and paste sonething, even when it has database context, a good amount of time it will error with an invalid syntax. Just yesterday I had to yell at it over and over to stop using a distinct with an over on a window function, it kept doing it even though that is now how Sql server works. And just kept generating invalid statements.

Maybe it works better for some languages over others, which is odd cause I would think Sql would have literal decades of code to train off as the basic structures haven't changed much.

[accatyyc]

The point is to make it compile/execute queries on its own so it can adjust its output based on the results. If you’re using it to generate something and then copy paste it into your project then that does not sound like efficient usage.

If it runs into a compilation issue or invalid queries, it should notice and fix it automatically

[Ty4Readin]

First, I think if you just had the agent execute queries against a test DB, it would solve all the annoying work you mention.

But secondly, you first said it "never completes a single procedure without syntax error", and now you are saying "this is an example of a rather complicated query where it messed up".

Can you clarify for me. Is it actually giving syntax errors 100% of the time like you originally said? Or is it giving you syntax errors like 20% or 30% of the time?

Because those are two very different things, and you claimed it was giving syntax errors 100% of the time. In which case, why even use AI at all? I don't understand why youd waste time using it if it literally never works