Add more random tests (#471)

DarkWanderer · web-flow · commit 8d7085c4166d · 2024-04-18T17:58:09.000+03:00
diff --git a/ClickHouse.Client.Tests/SQL/SqlSimpleSelectTests.cs b/ClickHouse.Client.Tests/SQL/SqlSimpleSelectTests.cs
@@ -27,6 +27,9 @@ public SqlSimpleSelectTests(bool useCompression)
     public static IEnumerable<TestCaseData> SimpleSelectQueries => TestUtilities.GetDataTypeSamples()
         .Select(sample => new TestCaseData($"SELECT {sample.ExampleExpression}") { ExpectedResult = sample.ExampleValue });
 
+    public static IEnumerable<TestCaseData> SimpleSelectTypes => TestUtilities.GetDataTypeSamples()
+        .Select(sample => new TestCaseData(sample.ClickHouseType));
+
     [Test]
     [Parallelizable]
     [TestCaseSource(typeof(SqlSimpleSelectTests), nameof(SimpleSelectQueries))]
@@ -209,5 +212,18 @@ public async Task ShouldSelectRandomizedData()
         while (await reader.ReadAsync()) ;
     }
 
+    [Test]
+    [FromVersion(23, 6)]
+    [Parallelizable]
+    [TestCaseSource(typeof(SqlSimpleSelectTests), nameof(SimpleSelectTypes))]
+    public async Task ShouldExecuteRandomDataSelectQuery(string type)
+    {
+        if (type.StartsWith("Nested") || type == "Nothing" || type.StartsWith("Variant"))
+            Assert.Ignore($"Type {type} not supported by generateRandom");
+
+        using var reader = await connection.ExecuteReaderAsync($"SELECT * FROM generateRandom('value {type.Replace("'", "\\'")}', 10, 10, 10) LIMIT 100");
+        reader.AssertHasFieldCount(1);
+    }
+
     public void Dispose() => connection?.Dispose();
 }
