top | item 42190704

(no title)

qidentity | 1 year ago

This is pretty interesting!

I tried to ask: "Recommend me great sci-fi movies from 2010 to 2024". It generated a SQL script for me to execute which unfortunately doesn't work.

discuss

order

attilakun|1 year ago

It's probably because it's trying to guess what the filter condition should be and uses the wrong casing for the genre (should be "Sci-Fi", not "sci-fi"). At least that's what happened when I tried your prompt a couple of times.

Sometimes it gets the casing correct by accident straight away, other times it struggles. When it does struggle, I just keep typing "fix" in the chat, and eventually it figures it out. Sometimes it asks me to run a query to determine the distinct set of genres, sometimes it just decides to lowercase the genre column in the filter condition.