[CASSANDRA-12749] Update a specific property of a UDT in list<udt>, from a table.

• Type: Improvement
• Status: Resolved
• Priority: Urgent
• Resolution: Duplicate
• Component/s: Legacy/CQL

Environment

Development

• Assignee: Unassigned
• Reporter: Rajashekhar Sheela
• Created: 05/Oct/16 07:13
• Updated: 08/Jul/19 15:43
• Resolved: 12/Dec/17 04:17

Description

I have a table with set<udt> as following...

CREATE TABLE IF NOT EXISTS CustomTemplate (
name text,
templateId uuid,
serviceId uuid,
tenants set<uuid>,
templateXml text,
xpath text,
parameters list<frozen<TemplateParameter>>,
PRIMARY KEY (templateId)
);

CREATE TYPE IF NOT EXISTS TemplateParameter (
name text,
label text,
type text,
displayType text,
allowedValues list<text>
);

Sample Data:

cqlsh:skyfall_customtemplate> select * from customtemplate ;

templateid | name | parameters | serviceid | templatexml | tenants | xpath
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
afd01de6-bba9-4417-ab79-6851077f2f84 | testMyTemplate2 | [

{name: 'X_PARAM', label: null, type: 'String', displaytype: null, allowedvalues: null}

] | 82d565cb-d286-4523-a377-add72af9b23f | xml | null | /xpath

Requirement is:
--------------------
Update "displayType:" of the TemplateParameter whose name='X_PARAM' and templateId=afd01de6-bba9-4417-ab79-6851077f2f84.

Not able to do this, please let know, how it can be done, if it is already possible.

Thanks.

Issue Links

• duplicates: CASSANDRA-7826 support non-frozen, nested collections