Hello,
I came across this thread in your documentation Database Object Case-Sensitivity (singlestore.com) discussing case sensitivity in SingleStore.
I wonder when the table_name_case_sensitivity is set to OFF, what objects in SingleStore remain case sensitive? Will it be columns, indexes, external functions, and pipes?
Thank you for any hint.
Table name case sensitivity applies only to “objects” and columns are not considered objects. Columns remain case-insensitive by default. The same is true for indexes.
External functions are functions, which are objects. So table_name_case_sensitivity applies to them.
I don’t have an answer right now regarding pipelines. I think they are “objects” so the setting will apply to them. I’ll have someone double-check.
Pipeline names are always case-sensitive.