For text attributes, CQL allows escaping single quote using additional single quote. But applying the same syntax for a map<int,text> attribute does not work.
CREATE query:
CREATE TABLE university.test (id int, data map<int, text>, PRIMARY KEY (id));
INSERT query:
insert into university.test (id, data) values(1, {1:'I''m newb'});
On running the aforementioned INSERT query, Cassandra inserts and returns {1: 'I''m newb'} while the expected result is {1: 'I'm newb'}
Screenshot FR:
How to escape single quote ' while inserting in a map<int,text> attribute?