[
https://issues.apache.org/jira/browse/CASSANDRA-10623?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Robert Stupp resolved CASSANDRA-10623.
--------------------------------------
Resolution: Not A Problem
You cannot do it (_you just cannot apply *any* functions on primary key column
values_).
You can just apply a UDF on a _selected_ column - so {{SELECT upper(foo) FROM
table WHERE pk=?}} - but not {{SELECT ... FROM table WHERE upper(pk)=?}}.
But you can _store the data in lower/upper case and duplicate the original
value_.
Closing this as "not a problem" for now. We can of course continue the
discussion on the [email protected] mailing list. There are efforts to
be able to use so called "functional indexes", which *may* be implemented by
extending materialized views. But your specific use case can be solved by just
duplicating the column.
> Text Functions
> --------------
>
> Key: CASSANDRA-10623
> URL: https://issues.apache.org/jira/browse/CASSANDRA-10623
> Project: Cassandra
> Issue Type: New Feature
> Reporter: Markus Stephanides
>
> In SQL, there are functions that make comparing texts easier e.g UPPER() and
> LOWER()
> I need this to compare a text in a WHERE clause of a SELECT statement with
> case-insensitvity.
> Thank you in advance!
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
