[CASSANDRA-12423] Cells missing from compact storage table after upgrading from 2.1.9 to 3.7

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.0.9, 3.10
• Component/s: Legacy/Local Write-Read Paths
• Severity: Normal
• Assignee: Stefania Alborghetti
• Reporter: Tomasz Grabiec

Authors

Stefania Alborghetti

Reviewers

Tom Hobbs

• Created: 10/Aug/16 08:27
• Updated: 16/Apr/19 09:30
• Resolved: 12/Sep/16 09:03

Description

Schema:

create table ks1.test ( id int, c1 text, c2 text, v int, primary key (id, c1, c2)) with compact storage and compression = {'sstable_compression': ''};

sstable2json before upgrading:

[
{"key": "1",
 "cells": [["","0",1470761440040513],
           ["a","asd",2470761440040513,"t",1470764842],
           ["asd:","0",1470761451368658],
           ["asd:asd","0",1470761449416613]]}
]

Query result with 2.1.9:

cqlsh> select * from ks1.test;

 id | c1  | c2   | v
----+-----+------+---
  1 |     | null | 0
  1 | asd |      | 0
  1 | asd |  asd | 0

(3 rows)

Query result with 3.7:

cqlsh> select * from ks1.test;

 id | 6331 | 6332 | v
----+------+------+---
  1 |      | null | 0

(1 rows)

Issue Links

• relates to: CASSANDRA-12516 Interned column identifiers can be overridden incorrectly