Thanks. Can you add the “regression” label to the bug report as asked by Zac_Spitzer?
Now, I’ve added. @Gunter, Did you saw? Please make sure of this
Yes, verifying it now with a test database/table/script
Yes, cfupdate seems to be ok. I run into problems with date fields (related to this https://luceeserver.atlassian.net/browse/LDEV-1344 ) and assumed that it was because of the problems I faced with cfinsert, but it isn’t. Thanks for sorting this out!
@Gunter, OK YWC
if you change the table name to a non existent table, i see the same error
logging with sql server profiler, the error we are seeing is caused by
i.e. the database name isn’t being passed in
Msg 1038, Level 15, State 4, Line 1 An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or  are not allowed. Change the alias to a valid name. Msg 911, Level 16, State 1, Line 1 Database '' does not exist. Make sure that the name is entered correctly.
(also posted in jira)
looks like perhaps this commit did it
again, database handling changes have been made for a specific database (in this case mysql),
but only test cases for that specific database are added
Like @Zackster stated before. It broke somewhere around 21 Sep 2018, so I downgraded Lucee to 220.127.116.11, and it works fine.
This, together with the webservice problem I experienced (CF / Lucee incompatibility for createObject() / SOAP request), it’s safe to say that I better stick with 18.104.22.168 for now.
Either this regression never got fixed, or it’s back … Can someone comment on this? Any ideas?
Lucee 22.214.171.124 Error (database)
Message An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or [ ] are not allowed. Change the alias to a valid name.
DatabaseName Microsoft SQL Server
DriverName Microsoft JDBC Driver 4.0 for SQL Server