[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5356) Sybase 15 does not support cross join

[David Boden (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=44979#comment-44979 ] 

David Boden commented on HHH-5356:
----------------------------------

Also affects 4.0.0.Final. We've worked around it successfully by updating to SybaseASE15Dialect which fortunately works for us on Sybase 12.5 as well.

My view is that the basic SybaseASEDialect should definitely have the getCrossJoinSeparator() method overridden to return ", " like in SybaseASE15Dialect. I doubt whether we really need 2 dialects anyway; should the contents of SybaseASE15Dialect just be moved to SybaseASEDialect? (we'll have to keep SybaseASE15Dialect for backwards compatibility now I suppose)?

There's a comment on SybaseASE15Dialect that says:
TODO : verify if this also works with 12/12.5
As far as I can tell, it does! I'll post back if I see any issues with 12.5.


> Sybase 15 does not support cross join
> -------------------------------------
>
>                 Key: HHH-5356
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5356
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.5.3
>         Environment: Hibernate 3.5.3-Final, Sybase 15.0.3 ASE
>            Reporter: Alexis Kofman
>            Assignee: Strong Liu
>            Priority: Minor
>             Fix For: 3.6.0.CR1
>
>   Original Estimate: 10m
>  Remaining Estimate: 10m
>
> It seems cross join is not yet implemented in Sybase. However the implemented Sybase 15 ASE Dialect in Hibernate use this kind of join :
> SybaseASE15Dialect is a subsubclass of Dialect in which we can find :
>  
> public String getCrossJoinSeparator() {
>    return " cross join ";
> }
> A workaround is to override this method as it is done in Sybase11Dialect.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira