search

dbcodeio / public

The Power of Databases, The Convenience of VS Code: All in One Place
28 stars 1 forks source link

mysql introspection error #100

Closed xenlata closed 1 week ago

xenlata commented 2 weeks ago

Error: Unknown column 'INDEX_NAME' in 'window order by'

VSCode Version: 1.95.1 Extension Version: 1.3.18 OS: win32 Arch: x64 Database Version: MySQL Community Server - GPL - 8.0.11

mikeburgh commented 2 weeks ago

Interesting, it looks like the introspection script must be hitting a bug in MySQL as the column it's complaining about is there, it's just not using the alias I set on the table.

I just pushed a pre release version with some new DB's and a potential fix for this issue, can you install it and give it a try ?

mikeburgh commented 2 weeks ago

This fix is now in the main version just released, version 1.4. Does it work for you if you update to that version

mikeburgh commented 1 week ago

I am going to close this, re open if you are still having the issue.