Add "WHERE key='local'" to accelerate queries against system.local - #434

What other keys can be in this table? For a 3-node cluster I get:

SELECT key FROM system.local;

 key
-------
 local

so I don't see what this WHERE clause is changing.

What other keys can be in this table? For a 3-node cluster I get:

SELECT key FROM system.local;

 key
-------
 local

so I don't see what this WHERE clause is changing.

I think what it does is convert it from a full scan to a regular partition query (see #23 (comment) ).
Other drivers had it too, this is aligning with them.

It's unclear to me why zero token tests are running against 2024.2. What's the expected results here?

It's unclear to me why zero token tests are running against 2024.2. What's the expected results here?

I don't remember if it's in 2024.2 or not, but if not this should be changes:

public void checkScyllaVersion() {
    // minOSS = "6.2.0",
    // minEnterprise = "2024.2.3",
    // Zero-token nodes introduced in scylladb/scylladb#19684
    assumeTrue(CcmBridge.SCYLLA_ENABLEMENT);
    if (CcmBridge.SCYLLA_ENTERPRISE) {
      assumeTrue(
          CcmBridge.VERSION.compareTo(Objects.requireNonNull(Version.parse("2024.2.3"))) >= 0);

When creating this test there was no official Scylla release with zero-token related changes in. I've set the requirement to the next numbered version I expected to appear, so I wouldn't forget to adjust this. I did not want to overshoot the version requirement.
This just needs to be updated to the higher number

It's unclear to me why zero token tests are running against 2024.2. What's the expected results here?

#413 is merged, but I'm still failing on it.

When creating this test there was no official Scylla release with zero-token related changes in. I've set the requirement to the next numbered version I expected to appear, so I wouldn't forget to adjust this. I did not want to overshoot the version requirement. This just needs to be updated to the higher number

I think it's an 2025.1.0 feature.

Created #435 to quickly take care of this

Created #435 to quickly take care of this

@mykaul could you please rebase it