@danthegoodman1 , have you tried Query.SerialConsistency ?
Also if you working with ScyllaDB, it is better to submit issues at https://github.com/scylladb/gocql

@dkropachev sorry I was inspecting this issue more at the package level, it seems like they support it https://github.com/scylladb/gocql/blob/master/frame.go#L187-L188 but this package does not (which is strange, considering cassandra supports it: https://docs.datastax.com/en/cql/hcd-1.0/reference/cqlsh-commands/consistency.html#setting-a-consistency-level)

@danthegoodman1 according to gocql documentation (for batch: https://pkg.go.dev/github.com/gocql/gocql#Batch.SerialConsistency, for query: https://pkg.go.dev/github.com/gocql/gocql#Query.SerialConsistency) the SerialConsistency supports only conditional update/insert operations. I will test if it works this way.

And if so, the problem is there becomes no way to use that Cassandra feature in this package then.

@danthegoodman1 I have tested it and compared behavior with the Python driver as well as cqlsh and ensured that everything works according to the documentation (https://github.com/apache/cassandra/blob/trunk/doc/native_protocol_v5.spec). To set SERIAL consistency you can do the following

	cluster := gocql.NewCluster("***.**.*.*:****")
	cluster.Keyspace = "test"
	cluster.SerialConsistency = gocql.Serial

or directly to query

session.Query("INSERT INTO test.test_table (id) VALUES (1) IF NOT EXISTS").SerialConsistency(Serial)

It will set the SERIAL consistency level for the serial phase of conditional updates.
After that, you can check the frame content and ensure that the serial_consistency is presented as SERIAL.

[execute id=52 FC 92 9D FB 65 5C 36 6E 37 68 E1 C6 15 87 8F params=[query_params consistency=QUORUM skip_meta=true page_size=5000 paging_state="" serial_consistency=SERIAL default_timestamp=true values=[] keyspace=]]

Not the SERIAL CONSISTENCY, CONSISTENCY SERIAL, which is used for paxos reads.

Subtle difference, but SERIAL CONSISTENCY is only used for LWTs. See how https://docs.datastax.com/en/cassandra-oss/2.2/cassandra/dml/dmlConfigConsistency.html#Readconsistencylevels is different than https://docs.datastax.com/en/cassandra-oss/2.2/cassandra/dml/dmlConfigSerialConsistency.html

@danthegoodman1 sorry for the misunderstanding, now I see the problem. Inspired by (https://github.com/scylladb/gocql/blob/master/frame.go#L187-L188) I added this feature, and now it should work properly.

Thank you!