[CASSANDRA-14567] CQL query returns different results in 2.2.5 and 3.0.15

• Type: Bug
• Status: Open
• Priority: Normal
• Resolution: Unresolved
• Component/s: Legacy/CQL
• Severity: Normal
• Assignee: Unassigned
• Reporter: Dikang Gu
• Created: 13/Jul/18 21:42
• Updated: 16/Apr/19 09:29

Description

During our 2.2.5 to 3.0.15 upgrade, we find the a cql query returns different results in 2.2.5 and 3.0.15, here is a unit test to reproduce it, https://gist.github.com/DikangGu/e538ed2de22b74e49b8dd43f7093a996

 

In C* 2.2.5, it returns all 4 rows: [Row[1, 10, 0, 1], Row[1, 10, 10, 2], Row[1, 1, 0, 3], Row[1, 1, 10, 4]]

While in C* 3.0.15, it only returns 2 rows to client: [Row[1, 10, 0, 1], Row[1, 1, 10, 4]]