[
https://issues.apache.org/jira/browse/CALCITE-7454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18069694#comment-18069694
]
Julian Hyde commented on CALCITE-7454:
--------------------------------------
I see. You're calling the method
[RelDataTypeSystem.isCaseSensitive(SqlTypeName)|https://calcite.apache.org/javadocAggregate/org/apache/calcite/rel/type/RelDataTypeSystem.html#isCaseSensitive(org.apache.calcite.sql.type.SqlTypeName)].
The default implementation of that method returns TRUE for CHAR and VARCHAR,
false for all other types.
The only current use of that method is to populate the data set returned by
JDBC's
[DatabaseMetaData.getTypeInfo()|https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html#getTypeInfo--].
We did not plan for that method to be overridden, and or for it to have an
effect on behavior of queries at runtime.
> CSV adapter does not respect case sensitive setting
> ---------------------------------------------------
>
> Key: CALCITE-7454
> URL: https://issues.apache.org/jira/browse/CALCITE-7454
> Project: Calcite
> Issue Type: Bug
> Components: csv-adapter
> Affects Versions: 1.41.0
> Reporter: Magnus Mogren
> Assignee: krooswu
> Priority: Major
>
> The CSV adapter does not respect the case sensitive setting.
> I have tried to use a RelDataTypeSystem class that returns false for the
> method isCaseSensitive.
> I have tried both flavor FILTERABLE and SCANNABLE.
>
> I looked att the code for org.apache.calcite.adapter.file.CsvEnumerator and
> the method moveNext() always compares to the filterValue using equals.
> Guess it should do equalsIgnoreCase if case sensitivity is turned off.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
