You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by me...@apache.org on 2026/07/01 10:34:05 UTC
(shardingsphere) branch master updated: Rename AUTO to DATABASE for MetadataIdentifierCaseSensitivity (#38975)
This is an automated email from the ASF dual-hosted git repository.
menghaoranss pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new c543c89bd99 Rename AUTO to DATABASE for MetadataIdentifierCaseSensitivity (#38975)
c543c89bd99 is described below
commit c543c89bd99d93d283356daaa89ab31bc5b49413
Author: Haoran Meng <me...@gmail.com>
AuthorDate: Wed Jul 1 18:33:58 2026 +0800
Rename AUTO to DATABASE for MetadataIdentifierCaseSensitivity (#38975)
* Rename AUTO to DATABASE for MetadataIdentifierCaseSensitivity
* Fix RALE2EIT
---
.../config/props/ConfigurationPropertyKey.java | 2 +-
.../props/MetadataIdentifierCaseSensitivity.java | 4 +-
.../identifier/IdentifierCaseRuleResolver.java | 3 --
.../config/props/ConfigurationPropertiesTest.java | 2 +-
.../ShardingSphereMetaDataIdentifierTest.java | 11 ------
...hardingSphereDatabaseFactoryIdentifierTest.java | 11 ------
.../ShardingSphereDatabaseIdentifierTest.java | 15 ++------
.../database/ShardingSphereDatabaseTest.java | 12 +-----
.../DatabaseIdentifierContextFactoryTest.java | 44 +---------------------
.../identifier/IdentifierCaseRuleResolverTest.java | 8 ----
.../AlterSchemaPushDownMetaDataRefresherTest.java | 13 -------
.../CreateSchemaPushDownMetaDataRefresherTest.java | 11 ------
.../DropSchemaPushDownMetaDataRefresherTest.java | 13 -------
.../DropTablePushDownMetaDataRefresherTest.java | 14 -------
.../RenameTablePushDownMetaDataRefresherTest.java | 16 --------
.../DropViewPushDownMetaDataRefresherTest.java | 16 --------
.../refresher/util/SchemaRefreshUtilsTest.java | 18 ---------
.../util/TableRefreshUtilsIdentifierTest.java | 25 ------------
.../refresher/util/TableRefreshUtilsTest.java | 9 -----
.../dataset/empty_rules/show_dist_variables.xml | 2 +-
20 files changed, 11 insertions(+), 238 deletions(-)
diff --git a/infra/common/src/main/java/org/apache/shardingsphere/infra/config/props/ConfigurationPropertyKey.java b/infra/common/src/main/java/org/apache/shardingsphere/infra/config/props/ConfigurationPropertyKey.java
index 57a17eb24cb..9d48fede377 100644
--- a/infra/common/src/main/java/org/apache/shardingsphere/infra/config/props/ConfigurationPropertyKey.java
+++ b/infra/common/src/main/java/org/apache/shardingsphere/infra/config/props/ConfigurationPropertyKey.java
@@ -138,7 +138,7 @@ public enum ConfigurationPropertyKey implements TypedPropertyKey {
/**
* Metadata identifier case sensitivity.
*/
- METADATA_IDENTIFIER_CASE_SENSITIVITY("metadata-identifier-case-sensitivity", MetadataIdentifierCaseSensitivity.AUTO.name(), MetadataIdentifierCaseSensitivity.class, true),
+ METADATA_IDENTIFIER_CASE_SENSITIVITY("metadata-identifier-case-sensitivity", MetadataIdentifierCaseSensitivity.DATABASE.name(), MetadataIdentifierCaseSensitivity.class, true),
/**
* Maximum size of Groovy inline expression parsing cache.
diff --git a/infra/common/src/main/java/org/apache/shardingsphere/infra/config/props/MetadataIdentifierCaseSensitivity.java b/infra/common/src/main/java/org/apache/shardingsphere/infra/config/props/MetadataIdentifierCaseSensitivity.java
index 25ddffc3e21..4c5eaf3ccde 100644
--- a/infra/common/src/main/java/org/apache/shardingsphere/infra/config/props/MetadataIdentifierCaseSensitivity.java
+++ b/infra/common/src/main/java/org/apache/shardingsphere/infra/config/props/MetadataIdentifierCaseSensitivity.java
@@ -22,9 +22,7 @@ package org.apache.shardingsphere.infra.config.props;
*/
public enum MetadataIdentifierCaseSensitivity {
- AUTO,
-
- SENSITIVE,
+ DATABASE,
INSENSITIVE
}
diff --git a/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/identifier/IdentifierCaseRuleResolver.java b/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/identifier/IdentifierCaseRuleResolver.java
index b8d6178b655..6433a6d1d2a 100644
--- a/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/identifier/IdentifierCaseRuleResolver.java
+++ b/infra/common/src/main/java/org/apache/shardingsphere/infra/metadata/identifier/IdentifierCaseRuleResolver.java
@@ -47,9 +47,6 @@ public final class IdentifierCaseRuleResolver {
return IdentifierCaseRuleSets.newInsensitiveRuleSet();
}
MetadataIdentifierCaseSensitivity configuredCaseSensitivity = props.getValue(ConfigurationPropertyKey.METADATA_IDENTIFIER_CASE_SENSITIVITY);
- if (MetadataIdentifierCaseSensitivity.SENSITIVE == configuredCaseSensitivity) {
- return IdentifierCaseRuleSets.newSensitiveRuleSet();
- }
if (MetadataIdentifierCaseSensitivity.INSENSITIVE == configuredCaseSensitivity) {
return IdentifierCaseRuleSets.newInsensitiveRuleSet();
}
diff --git a/infra/common/src/test/java/org/apache/shardingsphere/infra/config/props/ConfigurationPropertiesTest.java b/infra/common/src/test/java/org/apache/shardingsphere/infra/config/props/ConfigurationPropertiesTest.java
index 92667f64c95..0fb01dfcc30 100644
--- a/infra/common/src/test/java/org/apache/shardingsphere/infra/config/props/ConfigurationPropertiesTest.java
+++ b/infra/common/src/test/java/org/apache/shardingsphere/infra/config/props/ConfigurationPropertiesTest.java
@@ -104,6 +104,6 @@ class ConfigurationPropertiesTest {
assertThat(actual.getValue(ConfigurationPropertyKey.PROXY_FRONTEND_SSL_VERSION), is("TLSv1.2,TLSv1.3"));
assertThat(actual.getValue(ConfigurationPropertyKey.PROXY_FRONTEND_SSL_CIPHER), is(""));
assertTrue((Boolean) actual.getValue(ConfigurationPropertyKey.AGENT_PLUGINS_ENABLED));
- assertThat(actual.getValue(ConfigurationPropertyKey.METADATA_IDENTIFIER_CASE_SENSITIVITY), is(MetadataIdentifierCaseSensitivity.AUTO));
+ assertThat(actual.getValue(ConfigurationPropertyKey.METADATA_IDENTIFIER_CASE_SENSITIVITY), is(MetadataIdentifierCaseSensitivity.DATABASE));
}
}
diff --git a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/ShardingSphereMetaDataIdentifierTest.java b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/ShardingSphereMetaDataIdentifierTest.java
index 336ad020576..7af85ea33ee 100644
--- a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/ShardingSphereMetaDataIdentifierTest.java
+++ b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/ShardingSphereMetaDataIdentifierTest.java
@@ -19,8 +19,6 @@ package org.apache.shardingsphere.infra.metadata;
import org.apache.shardingsphere.database.connector.core.type.DatabaseType;
import org.apache.shardingsphere.infra.config.props.ConfigurationProperties;
-import org.apache.shardingsphere.infra.config.props.ConfigurationPropertyKey;
-import org.apache.shardingsphere.infra.config.props.MetadataIdentifierCaseSensitivity;
import org.apache.shardingsphere.infra.metadata.database.ShardingSphereDatabase;
import org.apache.shardingsphere.infra.metadata.database.ShardingSphereDatabaseFactory;
import org.apache.shardingsphere.infra.metadata.database.resource.ResourceMetaData;
@@ -97,15 +95,6 @@ class ShardingSphereMetaDataIdentifierTest {
assertFalse(metaData.containsDatabase("foo_db"));
}
- @Test
- void assertContainsDatabaseWithSensitiveProps() {
- Properties props = new Properties();
- props.setProperty(ConfigurationPropertyKey.METADATA_IDENTIFIER_CASE_SENSITIVITY.getKey(), MetadataIdentifierCaseSensitivity.SENSITIVE.name());
- ShardingSphereMetaData metaData =
- createMetaData(postgreSQLDatabaseType, new ConfigurationProperties(props), createDatabase("foo_db", postgreSQLDatabaseType));
- assertTrue(metaData.containsDatabase("FOO_DB"));
- }
-
@Test
void assertLegacyConstructorUsesInsensitiveLookup() {
ShardingSphereMetaData metaData = new ShardingSphereMetaData(Collections.singleton(createDatabase("foo_db", postgreSQLDatabaseType)),
diff --git a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/ShardingSphereDatabaseFactoryIdentifierTest.java b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/ShardingSphereDatabaseFactoryIdentifierTest.java
index 26ee4e039d5..5792533d1b3 100644
--- a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/ShardingSphereDatabaseFactoryIdentifierTest.java
+++ b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/ShardingSphereDatabaseFactoryIdentifierTest.java
@@ -19,14 +19,11 @@ package org.apache.shardingsphere.infra.metadata.database;
import org.apache.shardingsphere.database.connector.core.type.DatabaseType;
import org.apache.shardingsphere.infra.config.props.ConfigurationProperties;
-import org.apache.shardingsphere.infra.config.props.ConfigurationPropertyKey;
-import org.apache.shardingsphere.infra.config.props.MetadataIdentifierCaseSensitivity;
import org.apache.shardingsphere.infra.spi.type.typed.TypedSPILoader;
import org.junit.jupiter.api.Test;
import java.util.Properties;
-import static org.junit.jupiter.api.Assertions.assertFalse;
import static org.junit.jupiter.api.Assertions.assertTrue;
class ShardingSphereDatabaseFactoryIdentifierTest {
@@ -38,12 +35,4 @@ class ShardingSphereDatabaseFactoryIdentifierTest {
ShardingSphereDatabase database = ShardingSphereDatabaseFactory.create("foo_db", postgreSQLDatabaseType, new ConfigurationProperties(new Properties()));
assertTrue(database.containsSchema("PUBLIC"));
}
-
- @Test
- void assertCreateSystemDatabaseUsesConfiguredSensitivity() {
- Properties props = new Properties();
- props.setProperty(ConfigurationPropertyKey.METADATA_IDENTIFIER_CASE_SENSITIVITY.getKey(), MetadataIdentifierCaseSensitivity.SENSITIVE.name());
- ShardingSphereDatabase database = ShardingSphereDatabaseFactory.create("foo_db", postgreSQLDatabaseType, new ConfigurationProperties(props));
- assertFalse(database.containsSchema("PUBLIC"));
- }
}
diff --git a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/ShardingSphereDatabaseIdentifierTest.java b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/ShardingSphereDatabaseIdentifierTest.java
index bc0cbaed47c..161af16f5b8 100644
--- a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/ShardingSphereDatabaseIdentifierTest.java
+++ b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/ShardingSphereDatabaseIdentifierTest.java
@@ -105,15 +105,6 @@ class ShardingSphereDatabaseIdentifierTest {
assertFalse(database.getSchema("foo_schema").containsTable("FOO_TBL"));
}
- @Test
- void assertContainsSchemaWithSensitiveProps() {
- Properties props = new Properties();
- props.setProperty(ConfigurationPropertyKey.METADATA_IDENTIFIER_CASE_SENSITIVITY.getKey(), MetadataIdentifierCaseSensitivity.SENSITIVE.name());
- ShardingSphereDatabase database =
- createDatabase(postgreSQLDatabaseType, new ConfigurationProperties(props), createSchema("foo_schema", postgreSQLDatabaseType));
- assertFalse(database.containsSchema("FOO_SCHEMA"));
- }
-
@Test
void assertDefaultPropsUseInsensitiveLookup() {
ShardingSphereDatabase database = new ShardingSphereDatabase("foo_db", postgreSQLDatabaseType, createResourceMetaData(),
@@ -128,10 +119,10 @@ class ShardingSphereDatabaseIdentifierTest {
ShardingSphereSchema schema = new ShardingSphereSchema("foo_schema", postgreSQLDatabaseType, Collections.singleton(table), Collections.emptyList());
ShardingSphereDatabase database = createDatabase(postgreSQLDatabaseType, schema);
Properties props = new Properties();
- props.setProperty(ConfigurationPropertyKey.METADATA_IDENTIFIER_CASE_SENSITIVITY.getKey(), MetadataIdentifierCaseSensitivity.SENSITIVE.name());
+ props.setProperty(ConfigurationPropertyKey.METADATA_IDENTIFIER_CASE_SENSITIVITY.getKey(), MetadataIdentifierCaseSensitivity.INSENSITIVE.name());
database.refreshIdentifierContext(new ConfigurationProperties(props));
- assertFalse(database.containsSchema("FOO_SCHEMA"));
- assertFalse(database.getSchema("foo_schema").containsTable("FOO_TBL"));
+ assertTrue(database.containsSchema("FOO_SCHEMA"));
+ assertTrue(database.getSchema("foo_schema").containsTable("FOO_TBL"));
assertTrue(database.getSchema("foo_schema").getTable("foo_tbl").containsColumn("FOO_COL"));
}
diff --git a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/ShardingSphereDatabaseTest.java b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/ShardingSphereDatabaseTest.java
index 2c41fd39cc9..2bd2185dfa7 100644
--- a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/ShardingSphereDatabaseTest.java
+++ b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/database/ShardingSphereDatabaseTest.java
@@ -206,14 +206,6 @@ class ShardingSphereDatabaseTest {
assertThat(ex.getMessage(), is("Storage units 'missing_ds' do not exist in database 'foo_db'."));
}
- @Test
- void assertConstructWithProps() {
- ShardingSphereDatabase database = new ShardingSphereDatabase("foo_db", databaseType, new ResourceMetaData(Collections.emptyMap(), Collections.emptyMap()),
- new RuleMetaData(Collections.emptyList()), Collections.singleton(new ShardingSphereSchema("foo_schema", databaseType)), new ConfigurationProperties(
- PropertiesBuilder.build(new Property(ConfigurationPropertyKey.METADATA_IDENTIFIER_CASE_SENSITIVITY.getKey(), MetadataIdentifierCaseSensitivity.SENSITIVE.name()))));
- assertThat(getIdentifierContext(database).getRule(IdentifierScope.SCHEMA).getLookupMode(QuoteCharacter.NONE), is(LookupMode.EXACT));
- }
-
@Test
void assertRefreshIdentifierContext() {
ShardingSphereSchema schema = new ShardingSphereSchema("foo_schema", databaseType);
@@ -221,9 +213,9 @@ class ShardingSphereDatabaseTest {
"foo_db", databaseType, new ResourceMetaData(Collections.emptyMap(), Collections.emptyMap()), new RuleMetaData(Collections.emptyList()), Collections.singleton(schema),
new ConfigurationProperties(new Properties()));
database.refreshIdentifierContext(new ConfigurationProperties(
- PropertiesBuilder.build(new Property(ConfigurationPropertyKey.METADATA_IDENTIFIER_CASE_SENSITIVITY.getKey(), MetadataIdentifierCaseSensitivity.SENSITIVE.name()))));
+ PropertiesBuilder.build(new Property(ConfigurationPropertyKey.METADATA_IDENTIFIER_CASE_SENSITIVITY.getKey(), MetadataIdentifierCaseSensitivity.INSENSITIVE.name()))));
DatabaseIdentifierContext actualIdentifierContext = getIdentifierContext(database);
- assertThat(actualIdentifierContext.getRule(IdentifierScope.SCHEMA).getLookupMode(QuoteCharacter.NONE), is(LookupMode.EXACT));
+ assertThat(actualIdentifierContext.getRule(IdentifierScope.SCHEMA).getLookupMode(QuoteCharacter.NONE), is(LookupMode.NORMALIZED));
assertThat(getIdentifierContext(schema), is(actualIdentifierContext));
}
diff --git a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/identifier/DatabaseIdentifierContextFactoryTest.java b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/identifier/DatabaseIdentifierContextFactoryTest.java
index 9213c33e98e..f37cee07af6 100644
--- a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/identifier/DatabaseIdentifierContextFactoryTest.java
+++ b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/identifier/DatabaseIdentifierContextFactoryTest.java
@@ -248,24 +248,6 @@ class DatabaseIdentifierContextFactoryTest {
assertTrue(oracleFirstActual.isHeterogeneousTableLookupEnabled());
}
- @Test
- void assertCreateUsesInsensitiveRuleForDatabaseScope() {
- DatabaseIdentifierContext actual = DatabaseIdentifierContextFactory.create(ORACLE_DATABASE_TYPE,
- createConfigurationProperties(MetadataIdentifierCaseSensitivity.SENSITIVE));
- IdentifierCaseRule actualRule = actual.getRule(IdentifierScope.DATABASE);
- assertThat(actualRule.getLookupMode(QuoteCharacter.NONE), is(LookupMode.NORMALIZED));
- assertTrue(actualRule.matches("foo_db", "FOO_DB", QuoteCharacter.NONE));
- }
-
- @Test
- void assertRefreshUsesInsensitiveRuleForDatabaseScope() {
- DatabaseIdentifierContext actual = DatabaseIdentifierContextFactory.createDefault();
- DatabaseIdentifierContextFactory.refresh(actual, ORACLE_DATABASE_TYPE, createConfigurationProperties(MetadataIdentifierCaseSensitivity.SENSITIVE));
- IdentifierCaseRule actualRule = actual.getRule(IdentifierScope.DATABASE);
- assertThat(actualRule.getLookupMode(QuoteCharacter.NONE), is(LookupMode.NORMALIZED));
- assertTrue(actualRule.matches("foo_db", "FOO_DB", QuoteCharacter.NONE));
- }
-
@ParameterizedTest(name = "{0}")
@MethodSource("storageObjectScopes")
void assertCreateUsesInsensitiveRuleForStorageObjectScope(final String name, final IdentifierScope identifierScope) {
@@ -406,8 +388,6 @@ class DatabaseIdentifierContextFactoryTest {
private static Stream<Arguments> createWithProtocolTypeAndPropsArguments() {
return Stream.of(
Arguments.of("null protocol type and null props use insensitive rules", null, null, LookupMode.NORMALIZED, "Foo", "foo", true),
- Arguments.of("sensitive props override protocol rules", DATABASE_TYPE,
- createConfigurationProperties(MetadataIdentifierCaseSensitivity.SENSITIVE), LookupMode.EXACT, "Foo", "foo", false),
Arguments.of("insensitive props normalize identifiers", DATABASE_TYPE,
createConfigurationProperties(MetadataIdentifierCaseSensitivity.INSENSITIVE), LookupMode.NORMALIZED, "Foo", "foo", true));
}
@@ -415,24 +395,13 @@ class DatabaseIdentifierContextFactoryTest {
private static Stream<Arguments> createWithResourceMetaDataAndPropsArguments() {
return Stream.of(
Arguments.of("null resource metadata and null props use insensitive rules", null, null, null, LookupMode.NORMALIZED, "Foo", "foo", true),
- Arguments.of("null storage units keep explicit sensitive rules", DATABASE_TYPE, new ResourceMetaData(Collections.emptyMap(), null),
- createConfigurationProperties(MetadataIdentifierCaseSensitivity.SENSITIVE), LookupMode.EXACT, "Foo", "foo", false),
- Arguments.of("empty storage units keep explicit sensitive rules", DATABASE_TYPE, new ResourceMetaData(Collections.emptyMap(), Collections.emptyMap()),
- createConfigurationProperties(MetadataIdentifierCaseSensitivity.SENSITIVE), LookupMode.EXACT, "Foo", "foo", false),
- Arguments.of("first data source path keeps explicit sensitive rules", DATABASE_TYPE, createResourceMetaDataWithFirstDataSource(),
- createConfigurationProperties(MetadataIdentifierCaseSensitivity.SENSITIVE), LookupMode.EXACT, "Foo", "foo", false),
Arguments.of("storage type overrides protocol type for oracle backend", MYSQL_DATABASE_TYPE, createResourceMetaDataWithStorageUrls("jdbc:oracle:thin:@localhost:1521:xe"),
- new ConfigurationProperties(new Properties()), LookupMode.NORMALIZED, "T_ORDER", "t_order", true),
- Arguments.of("mixed storage trunk types use first data source rules", MYSQL_DATABASE_TYPE,
- createResourceMetaDataWithStorageUrls("jdbc:mysql://localhost:3306/foo_db", "jdbc:oracle:thin:@localhost:1521:xe"),
- createConfigurationProperties(MetadataIdentifierCaseSensitivity.SENSITIVE), LookupMode.EXACT, "Foo", "foo", false));
+ new ConfigurationProperties(new Properties()), LookupMode.NORMALIZED, "T_ORDER", "t_order", true));
}
private static Stream<Arguments> refreshWithProtocolTypeAndPropsArguments() {
return Stream.of(
Arguments.of("null protocol type and null props refresh to insensitive rules", null, null, LookupMode.NORMALIZED, "Foo", "foo", true),
- Arguments.of("sensitive props refresh to exact lookup", DATABASE_TYPE,
- createConfigurationProperties(MetadataIdentifierCaseSensitivity.SENSITIVE), LookupMode.EXACT, "Foo", "foo", false),
Arguments.of("insensitive props refresh to normalized lookup", DATABASE_TYPE,
createConfigurationProperties(MetadataIdentifierCaseSensitivity.INSENSITIVE), LookupMode.NORMALIZED, "Foo", "foo", true));
}
@@ -469,17 +438,8 @@ class DatabaseIdentifierContextFactoryTest {
private static Stream<Arguments> refreshWithResourceMetaDataAndPropsArguments() {
return Stream.of(
Arguments.of("null resource metadata and null props refresh to insensitive rules", null, null, null, LookupMode.NORMALIZED, "Foo", "foo", true),
- Arguments.of("null storage units refresh to exact lookup", DATABASE_TYPE, new ResourceMetaData(Collections.emptyMap(), null),
- createConfigurationProperties(MetadataIdentifierCaseSensitivity.SENSITIVE), LookupMode.EXACT, "Foo", "foo", false),
- Arguments.of("empty storage units refresh to exact lookup", DATABASE_TYPE, new ResourceMetaData(Collections.emptyMap(), Collections.emptyMap()),
- createConfigurationProperties(MetadataIdentifierCaseSensitivity.SENSITIVE), LookupMode.EXACT, "Foo", "foo", false),
- Arguments.of("first data source path refreshes to exact lookup", DATABASE_TYPE, createResourceMetaDataWithFirstDataSource(),
- createConfigurationProperties(MetadataIdentifierCaseSensitivity.SENSITIVE), LookupMode.EXACT, "Foo", "foo", false),
Arguments.of("refresh uses oracle storage type when protocol type is mysql", MYSQL_DATABASE_TYPE, createResourceMetaDataWithStorageUrls("jdbc:oracle:thin:@localhost:1521:xe"),
- new ConfigurationProperties(new Properties()), LookupMode.NORMALIZED, "T_ORDER", "t_order", true),
- Arguments.of("refresh uses first data source rules for mixed storage types", MYSQL_DATABASE_TYPE,
- createResourceMetaDataWithStorageUrls("jdbc:mysql://localhost:3306/foo_db", "jdbc:oracle:thin:@localhost:1521:xe"),
- createConfigurationProperties(MetadataIdentifierCaseSensitivity.SENSITIVE), LookupMode.EXACT, "Foo", "foo", false));
+ new ConfigurationProperties(new Properties()), LookupMode.NORMALIZED, "T_ORDER", "t_order", true));
}
private static Stream<Arguments> refreshWithSupportedDatabaseSchemaLookupArguments() {
diff --git a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/identifier/IdentifierCaseRuleResolverTest.java b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/identifier/IdentifierCaseRuleResolverTest.java
index a30184d4ef8..bb7cf7bc03c 100644
--- a/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/identifier/IdentifierCaseRuleResolverTest.java
+++ b/infra/common/src/test/java/org/apache/shardingsphere/infra/metadata/identifier/IdentifierCaseRuleResolverTest.java
@@ -40,14 +40,6 @@ class IdentifierCaseRuleResolverTest {
private final IdentifierCaseRuleResolver resolver = new IdentifierCaseRuleResolver();
- @Test
- void assertResolveWithSensitiveConfiguration() {
- IdentifierCaseRule actual =
- resolver.resolve(TypedSPILoader.getService(DatabaseType.class, "PostgreSQL"), new ConfigurationProperties(createProperties("sensitive")), null)
- .getRule(IdentifierScope.TABLE);
- assertThat(actual.getLookupMode(QuoteCharacter.NONE), is(LookupMode.EXACT));
- }
-
@Test
void assertResolveWithInsensitiveConfiguration() {
IdentifierCaseRule actual =
diff --git a/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/schema/AlterSchemaPushDownMetaDataRefresherTest.java b/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/schema/AlterSchemaPushDownMetaDataRefresherTest.java
index 3eba1888662..cee6b604458 100644
--- a/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/schema/AlterSchemaPushDownMetaDataRefresherTest.java
+++ b/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/schema/AlterSchemaPushDownMetaDataRefresherTest.java
@@ -52,19 +52,6 @@ class AlterSchemaPushDownMetaDataRefresherTest {
assertThat(persistService.getRenamedSchemaName(), is("bar_schema"));
}
- @Test
- void assertRefreshRenamesSchemaWithSensitiveProps() {
- AlterSchemaStatement sqlStatement = new AlterSchemaStatement(databaseType);
- sqlStatement.setSchemaName(new IdentifierValue("FOO_SCHEMA"));
- sqlStatement.setRenameSchema(new IdentifierValue("BAR_SCHEMA"));
- Properties props = new Properties();
- props.setProperty("metadata-identifier-case-sensitivity", "SENSITIVE");
- SchemaMetaDataManagerPersistServiceFixture persistService = new SchemaMetaDataManagerPersistServiceFixture();
- refresher.refresh(persistService, createDatabase(), "logic_ds", "foo_schema", databaseType, sqlStatement, new ConfigurationProperties(props));
- assertThat(persistService.getSourceSchemaName(), is("FOO_SCHEMA"));
- assertThat(persistService.getRenamedSchemaName(), is("bar_schema"));
- }
-
@Test
void assertRefreshDoesNothingWithoutRename() {
SchemaMetaDataManagerPersistServiceFixture persistService = new SchemaMetaDataManagerPersistServiceFixture();
diff --git a/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/schema/CreateSchemaPushDownMetaDataRefresherTest.java b/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/schema/CreateSchemaPushDownMetaDataRefresherTest.java
index 49784352c87..6714b4653c3 100644
--- a/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/schema/CreateSchemaPushDownMetaDataRefresherTest.java
+++ b/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/schema/CreateSchemaPushDownMetaDataRefresherTest.java
@@ -49,17 +49,6 @@ class CreateSchemaPushDownMetaDataRefresherTest {
assertThat(persistService.getCreatedSchemaName(), is("foo_schema"));
}
- @Test
- void assertRefreshCreateSchemaWithSensitiveProps() {
- SchemaMetaDataManagerPersistServiceFixture persistService = new SchemaMetaDataManagerPersistServiceFixture();
- CreateSchemaStatement sqlStatement = new CreateSchemaStatement(databaseType);
- sqlStatement.setSchemaName(new IdentifierValue("FOO_SCHEMA"));
- Properties props = new Properties();
- props.setProperty("metadata-identifier-case-sensitivity", "SENSITIVE");
- refresher.refresh(persistService, createDatabase(), "logic_ds", "foo_schema", databaseType, sqlStatement, new ConfigurationProperties(props));
- assertThat(persistService.getCreatedSchemaName(), is("foo_schema"));
- }
-
@Test
void assertRefreshNoSchemaOrUserDoesNothing() {
SchemaMetaDataManagerPersistServiceFixture persistService = new SchemaMetaDataManagerPersistServiceFixture();
diff --git a/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/schema/DropSchemaPushDownMetaDataRefresherTest.java b/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/schema/DropSchemaPushDownMetaDataRefresherTest.java
index 626697c5c58..27adc7d3c28 100644
--- a/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/schema/DropSchemaPushDownMetaDataRefresherTest.java
+++ b/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/schema/DropSchemaPushDownMetaDataRefresherTest.java
@@ -52,17 +52,4 @@ class DropSchemaPushDownMetaDataRefresherTest {
refresher.refresh(persistService, database, "logic_ds", "foo_schema", databaseType, sqlStatement, new ConfigurationProperties(new Properties()));
assertThat(persistService.getDroppedSchemaNames(), contains("foo_schema", "bar_schema"));
}
-
- @Test
- void assertRefreshWithSensitiveProps() {
- SchemaMetaDataManagerPersistServiceFixture persistService = new SchemaMetaDataManagerPersistServiceFixture();
- DropSchemaStatement sqlStatement = new DropSchemaStatement(databaseType);
- sqlStatement.getSchemaNames().addAll(Arrays.asList(new IdentifierValue("Foo_Schema"), new IdentifierValue("Bar_Schema")));
- ShardingSphereDatabase database = new ShardingSphereDatabase("foo_db", databaseType, new ResourceMetaData(Collections.emptyMap()), new RuleMetaData(Collections.emptyList()),
- Arrays.asList(new ShardingSphereSchema("Foo_Schema", databaseType), new ShardingSphereSchema("Bar_Schema", databaseType)), new ConfigurationProperties(new Properties()));
- Properties props = new Properties();
- props.setProperty("metadata-identifier-case-sensitivity", "SENSITIVE");
- refresher.refresh(persistService, database, "logic_ds", "foo_schema", databaseType, sqlStatement, new ConfigurationProperties(props));
- assertThat(persistService.getDroppedSchemaNames(), contains("Foo_Schema", "Bar_Schema"));
- }
}
diff --git a/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/table/DropTablePushDownMetaDataRefresherTest.java b/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/table/DropTablePushDownMetaDataRefresherTest.java
index 8d44e9b9a95..81d486a36fa 100644
--- a/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/table/DropTablePushDownMetaDataRefresherTest.java
+++ b/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/table/DropTablePushDownMetaDataRefresherTest.java
@@ -17,7 +17,6 @@
package org.apache.shardingsphere.mode.metadata.refresher.pushdown.type.table;
-import org.apache.shardingsphere.database.connector.core.metadata.database.enums.QuoteCharacter;
import org.apache.shardingsphere.database.connector.core.type.DatabaseType;
import org.apache.shardingsphere.infra.config.props.ConfigurationProperties;
import org.apache.shardingsphere.infra.metadata.database.ShardingSphereDatabase;
@@ -59,19 +58,6 @@ class DropTablePushDownMetaDataRefresherTest {
assertThat(persistService.getDroppedTableNames(), contains("Foo_Tbl", "Bar_Tbl"));
}
- @Test
- void assertRefreshUsesActualQuotedTableNamesWithSensitiveProps() {
- PushDownMetaDataManagerPersistServiceFixture persistService = new PushDownMetaDataManagerPersistServiceFixture();
- DropTableStatement sqlStatement = new DropTableStatement(databaseType, Arrays.asList(
- new SimpleTableSegment(new TableNameSegment(0, 0, new IdentifierValue("Foo_Tbl", QuoteCharacter.QUOTE))),
- new SimpleTableSegment(new TableNameSegment(0, 0, new IdentifierValue("Bar_Tbl", QuoteCharacter.QUOTE)))), false, false);
- Properties props = new Properties();
- props.setProperty("metadata-identifier-case-sensitivity", "SENSITIVE");
- refresher.refresh(persistService, createDatabase(), "logic_ds", "Foo_Schema", databaseType, sqlStatement, new ConfigurationProperties(props));
- assertThat(persistService.getDroppedTableSchemaName(), is("Foo_Schema"));
- assertThat(persistService.getDroppedTableNames(), contains("Foo_Tbl", "Bar_Tbl"));
- }
-
private ShardingSphereDatabase createDatabase() {
ShardingSphereSchema schema = new ShardingSphereSchema("Foo_Schema", databaseType,
Arrays.asList(new ShardingSphereTable("Foo_Tbl", Collections.emptyList(), Collections.emptyList(), Collections.emptyList()),
diff --git a/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/table/RenameTablePushDownMetaDataRefresherTest.java b/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/table/RenameTablePushDownMetaDataRefresherTest.java
index 0854f9031de..a58a34e0eef 100644
--- a/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/table/RenameTablePushDownMetaDataRefresherTest.java
+++ b/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/table/RenameTablePushDownMetaDataRefresherTest.java
@@ -17,7 +17,6 @@
package org.apache.shardingsphere.mode.metadata.refresher.pushdown.type.table;
-import org.apache.shardingsphere.database.connector.core.metadata.database.enums.QuoteCharacter;
import org.apache.shardingsphere.database.connector.core.type.DatabaseType;
import org.apache.shardingsphere.infra.config.props.ConfigurationProperties;
import org.apache.shardingsphere.infra.metadata.database.ShardingSphereDatabase;
@@ -61,21 +60,6 @@ class RenameTablePushDownMetaDataRefresherTest {
assertThat(persistService.getDroppedTableNames().iterator().next(), is("Foo_Tbl"));
}
- @Test
- void assertRefreshRenamesQuotedTablesWithSensitiveProps() {
- PushDownMetaDataManagerPersistServiceFixture persistService = new PushDownMetaDataManagerPersistServiceFixture();
- RenameTableStatement sqlStatement = new RenameTableStatement(databaseType, Collections.singleton(createRenameDefinition(
- new IdentifierValue("Foo_Tbl", QuoteCharacter.QUOTE), new IdentifierValue("Bar_Tbl", QuoteCharacter.QUOTE))));
- Properties props = new Properties();
- props.setProperty("metadata-identifier-case-sensitivity", "SENSITIVE");
- refresher.refresh(persistService, createDatabase(), "logic_ds", "Foo_Schema", databaseType, sqlStatement, new ConfigurationProperties(props));
- assertThat(persistService.getAlteredTableSchemaName(), is("Foo_Schema"));
- assertThat(persistService.getAlteredTables(), hasSize(1));
- assertThat(persistService.getAlteredTables().iterator().next().getName(), is("Bar_Tbl"));
- assertThat(persistService.getDroppedTableSchemaName(), is("Foo_Schema"));
- assertThat(persistService.getDroppedTableNames().iterator().next(), is("Foo_Tbl"));
- }
-
private RenameTableDefinitionSegment createRenameDefinition(final IdentifierValue sourceTableName, final IdentifierValue targetTableName) {
RenameTableDefinitionSegment result = new RenameTableDefinitionSegment(0, 0);
result.setTable(new SimpleTableSegment(new TableNameSegment(0, 0, sourceTableName)));
diff --git a/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/view/DropViewPushDownMetaDataRefresherTest.java b/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/view/DropViewPushDownMetaDataRefresherTest.java
index f62e93611ae..3638aa02706 100644
--- a/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/view/DropViewPushDownMetaDataRefresherTest.java
+++ b/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/pushdown/type/view/DropViewPushDownMetaDataRefresherTest.java
@@ -17,7 +17,6 @@
package org.apache.shardingsphere.mode.metadata.refresher.pushdown.type.view;
-import org.apache.shardingsphere.database.connector.core.metadata.database.enums.QuoteCharacter;
import org.apache.shardingsphere.database.connector.core.type.DatabaseType;
import org.apache.shardingsphere.infra.config.props.ConfigurationProperties;
import org.apache.shardingsphere.infra.metadata.database.ShardingSphereDatabase;
@@ -61,21 +60,6 @@ class DropViewPushDownMetaDataRefresherTest {
assertThat(persistService.getDroppedViewNames(), contains("Foo_View", "Bar_View"));
}
- @Test
- void assertRefreshUsesActualQuotedViewNamesWithSensitiveProps() {
- PushDownMetaDataManagerPersistServiceFixture persistService = new PushDownMetaDataManagerPersistServiceFixture();
- DropViewStatement sqlStatement = new DropViewStatement(databaseType, Arrays.asList(
- new SimpleTableSegment(new TableNameSegment(0, 0, new IdentifierValue("Foo_View", QuoteCharacter.QUOTE))),
- new SimpleTableSegment(new TableNameSegment(0, 0, new IdentifierValue("Bar_View", QuoteCharacter.QUOTE)))), false);
- Properties props = new Properties();
- props.setProperty("metadata-identifier-case-sensitivity", "SENSITIVE");
- refresher.refresh(persistService, createDatabase(), "logic_ds", "Foo_Schema", databaseType, sqlStatement, new ConfigurationProperties(props));
- assertThat(persistService.getDroppedTableSchemaName(), is("Foo_Schema"));
- assertThat(persistService.getDroppedTableNames(), contains("Foo_View", "Bar_View"));
- assertThat(persistService.getDroppedViewSchemaName(), is("Foo_Schema"));
- assertThat(persistService.getDroppedViewNames(), contains("Foo_View", "Bar_View"));
- }
-
private ShardingSphereDatabase createDatabase() {
ShardingSphereSchema schema = new ShardingSphereSchema("Foo_Schema", databaseType, Collections.emptyList(),
Arrays.asList(new ShardingSphereView("Foo_View", "SELECT 1"), new ShardingSphereView("Bar_View", "SELECT 1")));
diff --git a/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/util/SchemaRefreshUtilsTest.java b/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/util/SchemaRefreshUtilsTest.java
index b156550cad1..2431343d60b 100644
--- a/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/util/SchemaRefreshUtilsTest.java
+++ b/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/util/SchemaRefreshUtilsTest.java
@@ -17,7 +17,6 @@
package org.apache.shardingsphere.mode.metadata.refresher.util;
-import org.apache.shardingsphere.database.connector.core.metadata.database.enums.QuoteCharacter;
import org.apache.shardingsphere.database.connector.core.type.DatabaseType;
import org.apache.shardingsphere.infra.binder.context.segment.table.TablesContext;
import org.apache.shardingsphere.infra.binder.context.statement.SQLStatementContext;
@@ -58,28 +57,11 @@ class SchemaRefreshUtilsTest {
assertThat(SchemaRefreshUtils.getSchemaName(createDatabase(), createSQLStatementContextWithoutSchema()), is("foo_db"));
}
- @Test
- void assertGetActualSchemaNameWithSensitiveProps() {
- ShardingSphereDatabase database = new ShardingSphereDatabase("foo_db", databaseType, new ResourceMetaData(Collections.emptyMap()),
- new RuleMetaData(Collections.emptyList()), Collections.singletonList(new ShardingSphereSchema("Foo_Schema", databaseType)), new ConfigurationProperties(new Properties()));
- Properties props = new Properties();
- props.setProperty("metadata-identifier-case-sensitivity", "SENSITIVE");
- assertThat(SchemaRefreshUtils.getActualSchemaName(database, new IdentifierValue("Foo_Schema", QuoteCharacter.QUOTE), new ConfigurationProperties(props)), is("Foo_Schema"));
- }
-
@Test
void assertGetActualSchemaNameWithInsensitiveProps() {
assertThat(SchemaRefreshUtils.getActualSchemaName(createDatabase(), new IdentifierValue("Foo_Schema"), new ConfigurationProperties(new Properties())), is("foo_schema"));
}
- @Test
- void assertGetActualSchemaNameWithQuotedSchemaFromContext() {
- Properties props = new Properties();
- props.setProperty("metadata-identifier-case-sensitivity", "SENSITIVE");
- assertThat(SchemaRefreshUtils.getActualSchemaName(createDatabaseWithSchema("Foo_Schema"), createSQLStatementContextWithSchema(new IdentifierValue("Foo_Schema", QuoteCharacter.QUOTE)),
- new ConfigurationProperties(props)), is("Foo_Schema"));
- }
-
@Test
void assertGetActualSchemaNames() {
List<IdentifierValue> schemaIdentifiers = Arrays.asList(new IdentifierValue("Foo_Schema"), new IdentifierValue("bar_schema"), new IdentifierValue("new_schema"));
diff --git a/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/util/TableRefreshUtilsIdentifierTest.java b/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/util/TableRefreshUtilsIdentifierTest.java
index 9666a164d3d..214df413c43 100644
--- a/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/util/TableRefreshUtilsIdentifierTest.java
+++ b/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/util/TableRefreshUtilsIdentifierTest.java
@@ -17,7 +17,6 @@
package org.apache.shardingsphere.mode.metadata.refresher.util;
-import org.apache.shardingsphere.database.connector.core.metadata.database.enums.QuoteCharacter;
import org.apache.shardingsphere.database.connector.core.type.DatabaseType;
import org.apache.shardingsphere.infra.config.props.ConfigurationProperties;
import org.apache.shardingsphere.infra.metadata.database.ShardingSphereDatabase;
@@ -86,42 +85,18 @@ class TableRefreshUtilsIdentifierTest {
new ConfigurationProperties(new Properties())).get(), is("Foo_Tbl"));
}
- @Test
- void assertGetActualTableNameWithSensitiveProps() {
- Properties props = new Properties();
- props.setProperty("metadata-identifier-case-sensitivity", "SENSITIVE");
- assertThat(TableRefreshUtils.getActualTableName(createDatabase(), "Foo_Schema", new IdentifierValue("Foo_Tbl", QuoteCharacter.QUOTE),
- new ConfigurationProperties(props)), is("Foo_Tbl"));
- }
-
@Test
void assertGetTableLoadCandidateNameUsesNormalizedRule() {
assertThat(TableRefreshUtils.getTableLoadCandidateName(createDatabase(), new IdentifierValue("Foo_Tbl"),
new ConfigurationProperties(new Properties())), is("foo_tbl"));
}
- @Test
- void assertGetTableLoadCandidateNameUsesSensitiveRule() {
- Properties props = new Properties();
- props.setProperty("metadata-identifier-case-sensitivity", "SENSITIVE");
- assertThat(TableRefreshUtils.getTableLoadCandidateName(createDatabase(), new IdentifierValue("Foo_Tbl"),
- new ConfigurationProperties(props)), is("foo_tbl"));
- }
-
@Test
void assertGetViewLoadCandidateNameUsesNormalizedRule() {
assertThat(TableRefreshUtils.getViewLoadCandidateName(createDatabase(), new IdentifierValue("Foo_View"),
new ConfigurationProperties(new Properties())), is("foo_view"));
}
- @Test
- void assertGetViewLoadCandidateNameUsesSensitiveRule() {
- Properties props = new Properties();
- props.setProperty("metadata-identifier-case-sensitivity", "SENSITIVE");
- assertThat(TableRefreshUtils.getViewLoadCandidateName(createDatabase(), new IdentifierValue("Foo_View"),
- new ConfigurationProperties(props)), is("foo_view"));
- }
-
private ShardingSphereDatabase createDatabase() {
return createDatabase(databaseType);
}
diff --git a/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/util/TableRefreshUtilsTest.java b/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/util/TableRefreshUtilsTest.java
index c8e62e9795c..fd6af005d08 100644
--- a/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/util/TableRefreshUtilsTest.java
+++ b/mode/core/src/test/java/org/apache/shardingsphere/mode/metadata/refresher/util/TableRefreshUtilsTest.java
@@ -101,15 +101,6 @@ class TableRefreshUtilsTest {
new ConfigurationProperties(new Properties())), is("Foo_Tbl"));
}
- @Test
- void assertGetActualTableNameWithSensitiveProps() {
- ShardingSphereDatabase database = createDatabase();
- Properties props = new Properties();
- props.setProperty("metadata-identifier-case-sensitivity", "SENSITIVE");
- assertThat(TableRefreshUtils.getActualTableName(database, "Foo_Schema", new IdentifierValue("Foo_Tbl", QuoteCharacter.QUOTE),
- new ConfigurationProperties(props)), is("Foo_Tbl"));
- }
-
@Test
void assertGetActualTableNamesUsesExistingTableNames() {
ShardingSphereDatabase database = createDatabase();
diff --git a/test/e2e/sql/src/test/resources/cases/ral/dataset/empty_rules/show_dist_variables.xml b/test/e2e/sql/src/test/resources/cases/ral/dataset/empty_rules/show_dist_variables.xml
index 9b87ed9a2b2..58e2acfd24e 100644
--- a/test/e2e/sql/src/test/resources/cases/ral/dataset/empty_rules/show_dist_variables.xml
+++ b/test/e2e/sql/src/test/resources/cases/ral/dataset/empty_rules/show_dist_variables.xml
@@ -29,7 +29,7 @@
<row values="load_table_metadata_batch_size| 1000" />
<row values="max_connections_size_per_query| 1" />
<row values="max_union_size_per_datasource| 2147483647" />
- <row values="metadata_identifier_case_sensitivity| AUTO" />
+ <row values="metadata_identifier_case_sensitivity| DATABASE" />
<row values="proxy_backend_query_fetch_size| -1" />
<row values="proxy_default_port| 3307" />
<row values="proxy_frontend_connection_idle_timeout| 28800" />