[CASSANDRA-15641] No error if consistency_level = SERIAL and unqualified select

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Invalid
• Fix Version/s: 4.0-alpha4, 4.0
• Component/s: CQL/Semantics
• Bug Category: Correctness - Consistency
• Severity: Normal
• Complexity: Low Hanging Fruit
• Discovered By: User Report
• Platform: All
• Assignee: Massimiliano Tomassi
• Reporter: Konstantin

Authors

Massimiliano Tomassi

• Created: 13/Mar/20 17:19
• Updated: 15/May/20 08:54
• Resolved: 02/Apr/20 09:02

Description

The attached test program produces no errors, while doesn't provide serial consistency. There is no exception that the consistency level is incorrect. It's simply silently downgraded. The issue is not documented either.

kostja@atlas ~ % python test.py
Row(a=1, b=1)
Row(a=0, b=0)
Row(a=2, b=2)
Row(a=3, b=3)
Row(a=1, b=1)
Row(a=2, b=2)

The behavior is contrary to the original intent by LWT author, since the code has the following check:

if (group.queries.size() > 1)
throw new InvalidRequestException("SERIAL/LOCAL_SERIAL consistency may only be requested for one partition at a time");
https://github.com/apache/cassandra/blob/cassandra-3.11/src/java/org/apache/cassandra/service/StorageProxy.java#L1593