Fix upgrade python dtest test_static_columns_with_2i - upgrade_tests.cql_tests.TestCQLNodes

patch by Adam Holmberg; reviewed by Caleb Rackliffe, David Capwell for CASSANDRA-16332
diff --git a/upgrade_tests/cql_tests.py b/upgrade_tests/cql_tests.py
index 1ce95ba..5c9ec78 100644
--- a/upgrade_tests/cql_tests.py
+++ b/upgrade_tests/cql_tests.py
@@ -4109,6 +4109,7 @@
 
     def test_static_columns_with_2i(self):
         cursor = self.prepare()
+        initial_version = self.cluster.version()
 
         cursor.execute("""
             CREATE TABLE test (
@@ -4133,8 +4134,8 @@
             assert_all(cursor, "SELECT * FROM test WHERE v = 1", [[0, 0, 42, 1], [0, 1, 42, 1]])
             assert_all(cursor, "SELECT p, s FROM test WHERE v = 1", [[0, 42], [1, 42]])
             assert_all(cursor, "SELECT p FROM test WHERE v = 1", [[0], [1]])
-            # We don't support that
-            assert_invalid(cursor, "SELECT s FROM test WHERE v = 1")
+            if initial_version >= LooseVersion('3.11.7'):  # See CASSANDRA-16332. This fails with a known limitation on versions before 3.11.7 (CASSANDRA-14242)
+                assert_all(cursor, "SELECT s FROM test WHERE v = 1", [[42], [42]])
 
     @since('2.1')
     def test_static_columns_with_distinct(self):