[ https://issues.apache.org/jira/browse/CASSANDRA-12423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15430784#comment-15430784 ]
Aleksey Yeschenko commented on CASSANDRA-12423: ----------------------------------------------- Looked into it more, together with Stefania. To sum it up, in no particular order: 1. {{DESCRIBE}} output is broken. Sparse compact tables (with regular columns defined) that have non-text comparators should be filtered out from {{DESCRIBE}} output, as they cannot currently be represented via CQL {{CREATE TABLE}}. [~aholmber] I've raised this issue privately, do you remember if there is a python-driver JIRA open for it already? (also for filtering out supers). [~ifesdjeen] same goes for a follow-up JIRA to CASSANDRA-7190 2. The column names for {{Keyspace1.Standard3}} in schema tables in 2.1 and 3.0 are both correct. Should be using {{BytesType}} for regulars in 2.1 (statics in 3.0) given the {{BytesType}} comparator. 3. Yup, you are pretty much right about {{ColumnIdentifier.getInterned()}} being relied on incorrectly. We should fix this in 2.1 and upwards. I'll open a separate JIRA (assign to you, if you don't mind it), and link to this one, to either make the type part of the key in the interned map, or just limit its use. > Cells missing from compact storage table after upgrading from 2.1.9 to 3.7 > -------------------------------------------------------------------------- > > Key: CASSANDRA-12423 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12423 > Project: Cassandra > Issue Type: Bug > Reporter: Tomasz Grabiec > Assignee: Stefania > Attachments: 12423.tar.gz > > > Schema: > {code} > create table ks1.test ( id int, c1 text, c2 text, v int, primary key (id, c1, > c2)) with compact storage and compression = {'sstable_compression': ''}; > {code} > sstable2json before upgrading: > {code} > [ > {"key": "1", > "cells": [["","0",1470761440040513], > ["a","asd",2470761440040513,"t",1470764842], > ["asd:","0",1470761451368658], > ["asd:asd","0",1470761449416613]]} > ] > {code} > Query result with 2.1.9: > {code} > cqlsh> select * from ks1.test; > id | c1 | c2 | v > ----+-----+------+--- > 1 | | null | 0 > 1 | asd | | 0 > 1 | asd | asd | 0 > (3 rows) > {code} > Query result with 3.7: > {code} > cqlsh> select * from ks1.test; > id | 6331 | 6332 | v > ----+------+------+--- > 1 | | null | 0 > (1 rows) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)