[hibernate-issues] [JIRA] (HHH-16304) unquotedCaseStrategy defaults to UPPER with Sybase

Martin Simka ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZTMzYTFmMGY5... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16304?atlOrigin=eyJpIjoiZTMzYT... ) HHH-16304 ( https://hibernate.atlassian.net/browse/HHH-16304?atlOrigin=eyJpIjoiZTMzYT... ) unquotedCaseStrategy defaults to UPPER with Sybase ( https://hibernate.atlassian.net/browse/HHH-16304?atlOrigin=eyJpIjoiZTMzYT... ) Issue Type: Bug Affects Versions: 6.2.0.CR3 Assignee: Unassigned Components: hibernate-core Created: 14/Mar/2023 07:51 AM Environment: Hibernate ORM 6.2.0.CR3 + Sybase 16.0 + Sybase JDBC driver (jConnect (TM) for JDBC(TM)/16.0 SP04 PL03 (Build 27544) + extra connection parameters: `SQLINITSTRING=set quoted_identifier on&SQLINITSTRING=set ansinull on` Priority: Critical Reporter: Martin Simka ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) unquotedCaseStrategy defaults to UPPER and it is causing test failures in schema validation tests, an example from EnumValidationTest : org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing table [TestEntity] at app//org.hibernate.tool.schema.internal.AbstractSchemaValidator.validateTable(AbstractSchemaValidator.java:134) at app//org.hibernate.tool.schema.internal.GroupedSchemaValidatorImpl.validateTables(GroupedSchemaValidatorImpl.java:46) at app//org.hibernate.tool.schema.internal.AbstractSchemaValidator.performValidation(AbstractSchemaValidator.java:97) at app//org.hibernate.tool.schema.internal.AbstractSchemaValidator.doValidation(AbstractSchemaValidator.java:75) at app//org.hibernate.orm.test.schemavalidation.EnumValidationTest.doValidation(EnumValidationTest.java:116) at app//org.hibernate.orm.test.schemavalidation.EnumValidationTest.testValidation(EnumValidationTest.java:111) 09:46:25,413 DEBUG IdentifierHelperBuilder:89 - JDBC driver metadata reported database stores unquoted identifiers in neither upper, lower nor mixed case 09:46:25,414 DEBUG IdentifierHelperBuilder:116 - JDBC driver metadata reported database stores quoted identifiers in neither upper, lower nor mixed case it then defaults to https://github.com/hibernate/hibernate-orm/blob/main/hibernate-core/src/m... ( https://github.com/hibernate/hibernate-orm/blob/main/hibernate-core/src/m... ) private IdentifierCaseStrategy unquotedCaseStrategy = IdentifierCaseStrategy.UPPER; private IdentifierCaseStrategy quotedCaseStrategy = IdentifierCaseStrategy.MIXED; and then it fails to find a table in [ https://github.com/hibernate/hibernate-orm/blob/main/hibernate-core/src/m... ( https://github.com/hibernate/hibernate-orm/blob/main/hibernate-core/src/m... ) because "TestEntity != "TESTENTITY". List of affected tests: org.hibernate.orm.test.tool.schema.SchemaToolTransactionHandlingTest.testValidateInExistingJtaTransaction org.hibernate.orm.test.schemaupdate.ColumnNamesTest.testSchemaUpdateWithQuotedColumnNames org.hibernate.orm.test.schemavalidation.EnumValidationTest.testValidation org.hibernate.orm.test.schemavalidation.InstantValidationTest.testValidation org.hibernate.orm.test.schemavalidation.LongVarcharValidationTest.testValidation org.hibernate.orm.test.schemavalidation.NumericValidationTest.testValidation org.hibernate.orm.test.version.db.DbVersionTest.testCollectionNoVersion ( https://hibernate.atlassian.net/browse/HHH-16304#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16304#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100217- sha1:7167dc8 )