[
https://issues.apache.org/jira/browse/CASSANDRA-8421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14237054#comment-14237054
]
madheswaran commented on CASSANDRA-8421:
----------------------------------------
It is typo error. I used frozen keyword for UDT .
CREATE TYPE galaxy_dev.fieldmap (
key text,
value text
);
CREATE TABLE galaxy_dev.entity (
entity_id uuid PRIMARY KEY,
begining int,
domain text,
domain_type text,
entity_template_name text,
field_values list<frozen<fieldmap>>,
global_entity_type text,
revision_time timeuuid,
status_key int,
status_name text,
uuid timeuuid
)
Even I tried with latest release Cassandra 2.1.2 and the issue is reproduced. :(
Total Records inserted was 20
>>cqlsh:galaxy_dev> SELECT count(*) from entity;
count
-------
20
>>SELECT * from entity where status_key = 3 allow filtering ;
it returns 17 records
>>SELECT * from entity where field_values CONTAINS {key: 'state', value:
>>'Dubai'}
it returns 19 records
>> SELECT * from entity where field_values CONTAINS {key: 'state', value:
>> 'Dubai'} and status_key = 3 allow filtering;
returns only 1 record. ( but expected is 17 records ).
Sample Data which inserted:
------------------------------------
>>cqlsh:master_db> SELECT * FROM entity limit 1;
entity_id | begining | domain | domain_type |
entity_template_name | field_values
| global_entity_type |
revision_time | status_key | status_name | uuid
--------------------------------------+----------+--------+-------------+----------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------+--------------------------------------+------------+-------------+------
53212bc3-d9a3-4fb0-9a11-b08b63201d2b | 1 | com | null |
DefaultOrgTemplate | [{key: 'country', value: 'UAE'}, {key: 'faxNo', value:
'0097148869001'}, {key: 'landlineNo', value: '0097148869000'}, {key:
'orgAddress', value: 'Technopark'}, {key: 'orgCode', value: null}, {key:
'orgFullName', value: 'pacificcontrols'}, {key: 'orgName', value: 'PCS'}, {key:
'state', value: 'Dubai'}, {key: 'status', value: null}, {key: 'superTenant',
value: null}, {key: 'webUrl', value: 'http://www.pacificcontrols.net'}, {key:
'domain', value: 'pcs.com'}, {key: 'menu', value: '[{"menuName":"Manage Entity
Template","menuDesc":"Manage Entity Template
description","categoryName":"Configuration"},{"menuName":"Manage
Roles","menuDesc":"Manage Roles description","categoryName":"User
Management"},{"menuName":"Manage Entities","menuDesc":"Manage Entities
description","categoryName":"Configuration"},{"menuName":"Manage
Hierarchy","menuDesc":"Manage Hierarchy
description","categoryName":"Configuration"},{"menuName":"Live
Tracking","menuDesc":"Live Tracking
description","categoryName":"Applications"},{"menuName":"Manage
Users","menuDesc":"Manage Users description","categoryName":"User
Management"},{"menuName":"UI Designer","menuDesc":"UI Designer
description","categoryName":"Configuration"},{"menuName":"Prospect
Notifications","menuDesc":"Prospect Notifications
description","categoryName":"Administration"},{"menuName":"Manage Communication
Channel","menuDesc":"Manage Communication Channel
description","categoryName":"Configuration"}]'}, {key: 'featureGroups', value:
'[{"name":"LiveTracking","description":"Live
Tracking","features":[{"name":"Map","description":"Map
Description","statusFlag":0,"privileges":[{"name":"Edit","description":"Edit
Privilege","statusKey":0},{"name":"View","description":"View
Privilege","statusKey":0},{"name":"Delete","description":"Delete
Privilege","statusKey":0},{"name":"Create","description":"Create
Privilege","statusKey":0}]},{"name":"Grid","description":"Grid
Description","statusFlag":0,"privileges":[{"name":"Edit","description":"Edit
Privilege","statusKey":0},{"name":"View","description":"View
Privilege","statusKey":0},{"name":"Delete","description":"Delete
Privilege","statusKey":0},{"name":"Create","description":"Create
Privilege","statusKey":0}]},{"name":"Widget","description":"Widget
Description","statusFlag":0,"privileges":[{"name":"Edit","description":"Edit
Privilege","statusKey":0},{"name":"View","description":"View
Privilege","statusKey":0},{"name":"Delete","description":"Delete
Privilege","statusKey":0},{"name":"Create","description":"Create
Privilege","statusKey":0}]}]},{"name":"HistoryTracking","description":"History
Tracking","features":[{"name":"Map","description":"Map
Description","statusFlag":0,"privileges":[{"name":"Edit","description":"Edit
Privilege","statusKey":0},{"name":"View","description":"View
Privilege","statusKey":0},{"name":"Delete","description":"Delete
Privilege","statusKey":0},{"name":"Create","description":"Create
Privilege","statusKey":0}]},{"name":"Grid","description":"Grid
Description","statusFlag":0,"privileges":[{"name":"Edit","description":"Edit
Privilege","statusKey":0},{"name":"View","description":"View
Privilege","statusKey":0},{"name":"Delete","description":"Delete
Privilege","statusKey":0},{"name":"Create","description":"Create
Privilege","statusKey":0}]},{"name":"Widget","description":"Widget
Description","statusFlag":0,"privileges":[{"name":"Edit","description":"Edit
Privilege","statusKey":0},{"name":"View","description":"View
Privilege","statusKey":0},{"name":"Delete","description":"Delete
Privilege","statusKey":0},{"name":"Create","description":"Create
Privilege","statusKey":0}]}]},{"name":"GeoFencing","description":"Geo
Fencing","features":[{"name":"Map","description":"Map
Description","statusFlag":0,"privileges":[{"name":"Edit","description":"Edit
Privilege","statusKey":0},{"name":"View","description":"View
Privilege","statusKey":0},{"name":"Delete","description":"Delete
Privilege","statusKey":0},{"name":"Create","description":"Create
Privilege","statusKey":0}]},{"name":"Grid","description":"Grid
Description","statusFlag":0,"privileges":[{"name":"Edit","description":"Edit
Privilege","statusKey":0},{"name":"View","description":"View
Privilege","statusKey":0},{"name":"Delete","description":"Delete
Privilege","statusKey":0},{"name":"Create","description":"Create
Privilege","statusKey":0}]},{"name":"Widget","description":"Widget
Description","statusFlag":0,"privileges":[{"name":"Edit","description":"Edit
Privilege","statusKey":0},{"name":"View","description":"View
Privilege","statusKey":0},{"name":"Delete","description":"Delete
Privilege","statusKey":0},{"name":"Create","description":"Create
Privilege","statusKey":0}]}]},{"name":"UserManagement","description":"User
Management","features":[{"name":"ManageUser","description":"Manage User
Description","statusFlag":0,"privileges":[{"name":"Edit","description":"Edit
Privilege","statusKey":0},{"name":"View","description":"View
Privilege","statusKey":0},{"name":"Delete","description":"Delete
Privilege","statusKey":0},{"name":"Create","description":"Create
Privilege","statusKey":0}]},{"name":"CreateUser","description":"Create User
Description","statusFlag":0,"privileges":[{"name":"Edit","description":"Edit
Privilege","statusKey":0},{"name":"View","description":"View
Privilege","statusKey":0},{"name":"Delete","description":"Delete
Privilege","statusKey":0},{"name":"Create","description":"Create
Privilege","statusKey":0}]}]},{"name":"RoleManagement","description":"User
Management","features":[{"name":"ManageRole","description":"Manage Role
Description","statusFlag":0,"privileges":[{"name":"Edit","description":"Edit
Privilege","statusKey":0},{"name":"View","description":"View
Privilege","statusKey":0},{"name":"Delete","description":"Delete
Privilege","statusKey":0},{"name":"Create","description":"Create
Privilege","statusKey":0}]},{"name":"CreateRole","description":"Create Role
Description","statusFlag":0,"privileges":[{"name":"Edit","description":"Edit
Privilege","statusKey":0},{"name":"View","description":"View
Privilege","statusKey":0},{"name":"Delete","description":"Delete
Privilege","statusKey":0},{"name":"Create","description":"Create
Privilege","statusKey":0}]}]}]'}] | ORGANIZATION |
204bb850-7d4b-11e4-869a-8d9a1002f406 | 3 | DELETED | null
(1 rows)
> Cassandra 2.1.1 UDT not returning value for LIST type as UDT
> ------------------------------------------------------------
>
> Key: CASSANDRA-8421
> URL: https://issues.apache.org/jira/browse/CASSANDRA-8421
> Project: Cassandra
> Issue Type: Bug
> Components: API
> Environment: single node cassandra
> Reporter: madheswaran
> Assignee: Philip Thompson
> Fix For: 3.0, 2.1.3
>
>
> I using List and its data type is UDT.
> UDT:
> {code}
> CREATE TYPE
> fieldmap (
> key text,
> value text
> );
> {code}
> TABLE:
> {code}
> CREATE TABLE entity (
> entity_id uuid PRIMARY KEY,
> begining int,
> domain text,
> domain_type text,
> entity_template_name text,
> field_values list<fieldmap>,
> global_entity_type text,
> revision_time timeuuid,
> status_key int,
> status_name text,
> uuid timeuuid
> ) {code}
> INDEX:
> {code}
> CREATE INDEX entity_domain_idx_1 ON galaxy_dev.entity (domain);
> CREATE INDEX entity_field_values_idx_1 ON galaxy_dev.entity (field_values);
> CREATE INDEX entity_global_entity_type_idx_1 ON galaxy_dev.entity (gen_type );
> {code}
> QUERY
> {code}
> SELECT * FROM entity WHERE status_key < 3 and field_values contains {key:
> 'userName', value: 'Sprint5_200002'} and gen_type = 'USER' and domain =
> 'S4_1017.abc.com' allow filtering;
> {code}
> The above query return value for some row and not for many rows but those
> rows and data's are exist.
> Observation:
> If I execute query with other than field_maps, then it returns value. I
> suspect the problem with LIST with UDT.
> I have single node cassadra DB. Please let me know why this strange behavior
> from cassandra.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
