SQL Server doesn't support table aliases in DELETE

pkulak · **Joined:** Tue Mar 01, 2005 2:35 pm **Posts:** 60

Hibernate version:
3.0rc1

Name and version of the database you are using:
SQL Server 2003

The generated SQL (show_sql=true):
delete from dbo.webUserRequest webuserreq0_ where (webuserreq0_.webUserID=?)

Is there a way that I can change this behavoir in the dialect, or does this need to be changed in the distribution?

Here's the BNF for DELETE:

Umm... my copy and paste seems to be broken somehow. I'm blaming Eclipse or Firefox. You'll just have to take my word for it. :D

max · **Posted:** Wed Mar 23, 2005 1:21 pm

known bug with mssql....being fixed in cvs.

pkulak · **Joined:** Tue Mar 01, 2005 2:35 pm **Posts:** 60

max wrote:

known bug with mssql....being fixed in cvs.

Ooo, great to hear. I'll just use JDBC until then. Thanks!

steve · **Posted:** Wed Mar 23, 2005 3:35 pm

fixed in CVS.