Thanks. Can you add the “regression” label to the bug report as asked by Zac_Spitzer?
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!
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
use [];
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
https://luceeserver.atlassian.net/browse/LDEV-1980
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 5.2.9.31, 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 5.2.9.31 for now.
Either this regression never got fixed, or it’s back … Can someone comment on this? Any ideas?
Lucee 5.3.2.77 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
DatabaseVersion 14.00.3335
DriverName Microsoft JDBC Driver 4.0 for SQL Server
DriverVersion 4.0.2206.100