We're updating the issue view to help you get more done. 

Fix test issues in SQL Server

Description

There are several test cases that fail in SQL Server:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 org.hibernate.test.cid.CompositeIdTest > testDistinctCountOfEntityWithCompositeId FAILED javax.persistence.PersistenceException at CompositeIdTest.java:106 Caused by: org.hibernate.exception.SQLGrammarException at CompositeIdTest.java:106 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at CompositeIdTest.java:106 org.hibernate.test.filter.DynamicFilterTest > testSqlSyntaxOfFiltersWithUnions FAILED javax.persistence.PersistenceException at DynamicFilterTest.java:88 Caused by: org.hibernate.exception.SQLGrammarException at DynamicFilterTest.java:88 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at DynamicFilterTest.java:88 org.hibernate.test.hql.ASTParserLoadingTest > testJPAPositionalParameterList FAILED javax.persistence.PersistenceException at ASTParserLoadingTest.java:1440 Caused by: org.hibernate.exception.SQLGrammarException at ASTParserLoadingTest.java:1440 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at ASTParserLoadingTest.java:1440 org.hibernate.test.hql.ASTParserLoadingTest > testOrderedWithCustomColumnReadAndWrite FAILED javax.persistence.PersistenceException at ASTParserLoadingTest.java:2237 Caused by: org.hibernate.exception.SQLGrammarException at ASTParserLoadingTest.java:2237 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at ASTParserLoadingTest.java:2237 org.hibernate.test.hql.BulkManipulationTest > testDeleteWithMetadataWhereFragments FAILED org.hibernate.exception.SQLGrammarException at BulkManipulationTest.java:1333 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at BulkManipulationTest.java:1333 org.hibernate.test.hql.CriteriaHQLAlignmentTest > testCountReturnValues FAILED javax.persistence.PersistenceException at CriteriaHQLAlignmentTest.java:267 Caused by: org.hibernate.exception.SQLGrammarException at CriteriaHQLAlignmentTest.java:267 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at CriteriaHQLAlignmentTest.java:267 org.hibernate.test.hql.WithClauseTest > testWithClauseAsSubqueryWithKeyAndOtherJoinReference FAILED javax.persistence.PersistenceException at WithClauseTest.java:255 Caused by: org.hibernate.exception.SQLGrammarException at WithClauseTest.java:255 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at WithClauseTest.java:255 org.hibernate.test.legacy.FooBarTest > testCollectionsInSelect FAILED javax.persistence.PersistenceException at FooBarTest.java:2297 Caused by: org.hibernate.exception.SQLGrammarException at FooBarTest.java:2297 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at FooBarTest.java:2297 org.hibernate.test.lob.LobStringTest > testSelectClobPropertyInHqlQuery FAILED javax.persistence.PersistenceException at LobStringTest.java:151 Caused by: org.hibernate.exception.DataException at LobStringTest.java:151 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at LobStringTest.java:151 org.hibernate.test.lob.LobStringTest > testSelectStringLobAnnotatedInHqlQuery FAILED javax.persistence.PersistenceException at LobStringTest.java:121 Caused by: org.hibernate.exception.DataException at LobStringTest.java:121 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at LobStringTest.java:121 org.hibernate.test.lob.LobStringTest > testUsingLobPropertyInHqlQuery FAILED javax.persistence.PersistenceException at LobStringTest.java:136 Caused by: org.hibernate.exception.DataException at LobStringTest.java:136 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at LobStringTest.java:136 org.hibernate.test.lob.LobStringTest > testUsingStringLobAnnotatedPropertyInHqlQuery FAILED javax.persistence.PersistenceException at LobStringTest.java:97 Caused by: org.hibernate.exception.DataException at LobStringTest.java:97 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at LobStringTest.java:97 org.hibernate.test.querycache.QueryCacheTest > testCaseInsensitiveComparison FAILED java.lang.AssertionError at QueryCacheTest.java:276 org.hibernate.test.reattachment.CollectionReattachmentTest > testUpdateOwnerAfterClear FAILED javax.persistence.PersistenceException at CollectionReattachmentTest.java:47 Caused by: org.hibernate.exception.SQLGrammarException at CollectionReattachmentTest.java:47 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at CollectionReattachmentTest.java:47 org.hibernate.test.reattachment.CollectionReattachmentTest > testUpdateOwnerAfterEvict FAILED javax.persistence.PersistenceException at CollectionReattachmentTest.java:74 Caused by: org.hibernate.exception.SQLGrammarException at CollectionReattachmentTest.java:74 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at CollectionReattachmentTest.java:74 org.hibernate.test.reattachment.ProxyReattachmentTest > testIterateWithClearBottomOfLoop FAILED org.hibernate.exception.SQLGrammarException at ProxyReattachmentTest.java:145 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at ProxyReattachmentTest.java:145 org.hibernate.test.reattachment.ProxyReattachmentTest > testIterateWithClearTopOfLoop FAILED org.hibernate.exception.SQLGrammarException at ProxyReattachmentTest.java:109 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at ProxyReattachmentTest.java:109 org.hibernate.test.reattachment.ProxyReattachmentTest > testIterateWithEvictBottomOfLoop FAILED org.hibernate.exception.SQLGrammarException at ProxyReattachmentTest.java:222 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at ProxyReattachmentTest.java:222 org.hibernate.test.reattachment.ProxyReattachmentTest > testIterateWithEvictTopOfLoop FAILED org.hibernate.exception.SQLGrammarException at ProxyReattachmentTest.java:187 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at ProxyReattachmentTest.java:187 org.hibernate.test.reattachment.ProxyReattachmentTest > testRemoveAndReattachProxyEntity FAILED javax.persistence.PersistenceException at ProxyReattachmentTest.java:250 Caused by: org.hibernate.exception.SQLGrammarException at ProxyReattachmentTest.java:250 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at ProxyReattachmentTest.java:250 org.hibernate.test.reattachment.ProxyReattachmentTest > testUpdateAfterClear FAILED javax.persistence.PersistenceException at ProxyReattachmentTest.java:77 Caused by: org.hibernate.exception.SQLGrammarException at ProxyReattachmentTest.java:77 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at ProxyReattachmentTest.java:77 org.hibernate.test.reattachment.ProxyReattachmentTest > testUpdateAfterEvict FAILED javax.persistence.PersistenceException at ProxyReattachmentTest.java:51 Caused by: org.hibernate.exception.SQLGrammarException at ProxyReattachmentTest.java:51 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at ProxyReattachmentTest.java:51 org.hibernate.test.schemaupdate.foreignkeys.crossschema.CrossSchemaForeignKeyGenerationTest > testSchemaMigrationForeignKeysAreGeneratedAfterAllTheTablesAreCreated FAILED org.hibernate.exception.SQLGrammarException at CrossSchemaForeignKeyGenerationTest.java:160 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at CrossSchemaForeignKeyGenerationTest.java:160 org.hibernate.test.sql.autodiscovery.AutoDiscoveryTest > testDialectGetColumnAliasExtractor FAILED org.hibernate.exception.SQLGrammarException at AutoDiscoveryTest.java:127 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at AutoDiscoveryTest.java:127 org.hibernate.test.sql.autodiscovery.AutoDiscoveryTest > testSqlQueryAutoDiscovery FAILED javax.persistence.PersistenceException at AutoDiscoveryTest.java:111 Caused by: org.hibernate.exception.SQLGrammarException at AutoDiscoveryTest.java:111 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at AutoDiscoveryTest.java:111 org.hibernate.test.sql.hand.custom.sqlserver.SQLServerCustomSQLTest > testImageProperty FAILED javax.persistence.PersistenceException Caused by: org.hibernate.exception.SQLGrammarException Caused by: com.microsoft.sqlserver.jdbc.SQLServerException org.hibernate.test.sql.hand.custom.sqlserver.SQLServerCustomSQLTest > testTextProperty FAILED javax.persistence.PersistenceException Caused by: org.hibernate.exception.SQLGrammarException Caused by: com.microsoft.sqlserver.jdbc.SQLServerException org.hibernate.test.sql.hand.query.NativeSQLQueriesTest > testAutoDetectAliasing FAILED javax.persistence.PersistenceException at NativeSQLQueriesTest.java:577 Caused by: org.hibernate.exception.SQLGrammarException at NativeSQLQueriesTest.java:577 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at NativeSQLQueriesTest.java:577 org.hibernate.test.sql.hand.query.NativeSQLQueriesTest > testImageTypeInSQLQuery FAILED javax.persistence.PersistenceException at NativeSQLQueriesTest.java:870 Caused by: org.hibernate.exception.SQLGrammarException at NativeSQLQueriesTest.java:870 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at NativeSQLQueriesTest.java:870 org.hibernate.test.sql.hand.query.NativeSQLQueriesTest > testTextTypeInSQLQuery FAILED javax.persistence.PersistenceException at NativeSQLQueriesTest.java:849 Caused by: org.hibernate.exception.SQLGrammarException at NativeSQLQueriesTest.java:849 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at NativeSQLQueriesTest.java:849 org.hibernate.test.temporal.TimePropertyTest > testTimeAsDate FAILED javax.persistence.PersistenceException at TimePropertyTest.java:59 Caused by: org.hibernate.exception.SQLGrammarException at TimePropertyTest.java:59 Caused by: com.microsoft.sqlserver.jdbc.SQLServerException at TimePropertyTest.java:59

Environment

None

Status

Assignee

Vlad Mihalcea

Reporter

Vlad Mihalcea

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

5.2.9

Priority

Major