the hint '*HINT_PASS_DISTINCT_THROUGH*' does not take effect if the '*hibernate.use_sql_comments*' property is enabled. This happens because the '*org.hibernate.loader.Loader.processDistinctKeyword(...)*' method checks the condition '*sql.startsWith( SELECT_DISTINCT )*' in order to perform the ' * distinct * ' keyword removal. If the 'hibernate.use_sql_comments' is enabled the comments (/**...***/) precede the '*distinct*' keyword and aforementioned condition check fails. |
|