[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-7006) keyword "top" causes test fail on ms sql server

keyword "top" causes test fail on ms sql server ----------------------------------------------- Key: HHH-7006 URL: https://hibernate.onjira.com/browse/HHH-7006 Project: Hibernate ORM Issue Type: Bug Components: testsuite Reporter: Strong Liu Assignee: Strong Liu Priority: Minor Fix For: 4.1.0 org.hibernate.ejb.test.cascade.multilevel.MultiLevelCascadeTest.test {quote} Error Message javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Incorrect syntax near the keyword 'TOP'. Stacktrace javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Incorrect syntax near the keyword 'TOP'. at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1361) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1289) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1295) at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:976) at org.hibernate.ejb.test.cascade.multilevel.MultiLevelCascadeTest.test(MultiLevelCascadeTest.java:47) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41) at org.hibernate.testing.junit4.ExtendedFrameworkMethod.invokeExplosively(ExtendedFrameworkMethod.java:63) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20) at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31) {quote}