Update versions, add test

rschu1ze · rschu1ze · commit ff10498b9a7b · 2025-05-05T08:31:04.000Z
diff --git a/src/Functions/array/arrayNormalizedGini.cpp b/src/Functions/array/arrayNormalizedGini.cpp
@@ -406,7 +406,7 @@ REGISTER_FUNCTION(NormalizedGini)
         = {{"Example",
             "SELECT arrayNormalizedGini([0.9, 0.3, 0.8, 0.7],[6, 1, 0, 2]);",
             "(0.18055555555555558,0.2638888888888889,0.6842105263157896)"}};
-    FunctionDocumentation::IntroducedIn doc_introduced_in = FunctionDocumentation::VERSION_UNKNOWN;
+    FunctionDocumentation::IntroducedIn doc_introduced_in = {25, 1};
     FunctionDocumentation::Category doc_category = FunctionDocumentation::Category::Array;
 
     factory.registerFunction<FunctionArrayNormalizedGini>(
diff --git a/src/Functions/base64Decode.cpp b/src/Functions/base64Decode.cpp
@@ -13,7 +13,7 @@ REGISTER_FUNCTION(Base64Decode)
     FunctionDocumentation::Arguments arguments = {{"encoded", "String column or constant. If the string is not a valid Base64-encoded value, an exception is thrown."}};
     FunctionDocumentation::ReturnedValue returned_value = "A string containing the decoded value of the argument.";
     FunctionDocumentation::Examples examples = {{"Example", "SELECT base64Decode('Y2xpY2tob3VzZQ==')", "clickhouse"}};
-    FunctionDocumentation::IntroducedIn introduced_in = FunctionDocumentation::VERSION_UNKNOWN;
+    FunctionDocumentation::IntroducedIn introduced_in = {18, 16};
     FunctionDocumentation::Category category = FunctionDocumentation::Category::Encoding;
 
     factory.registerFunction<FunctionBase64Conversion<Base64Decode<Base64Variant::Normal>>>({description, syntax, arguments, returned_value, examples, introduced_in, category});
diff --git a/src/Functions/base64Encode.cpp b/src/Functions/base64Encode.cpp
@@ -13,7 +13,7 @@ REGISTER_FUNCTION(Base64Encode)
     FunctionDocumentation::Arguments arguments = {{"plaintext", "String column or constant."}};
     FunctionDocumentation::ReturnedValue returned_value = "A string containing the encoded value of the argument.";
     FunctionDocumentation::Examples examples = {{"Example", "SELECT base64Encode('clickhouse')", "Y2xpY2tob3VzZQ=="}};
-    FunctionDocumentation::IntroducedIn introduced_in = FunctionDocumentation::VERSION_UNKNOWN;
+    FunctionDocumentation::IntroducedIn introduced_in = {18, 16};
     FunctionDocumentation::Category category = FunctionDocumentation::Category::String;
 
     factory.registerFunction<FunctionBase64Conversion<Base64Encode<Base64Variant::Normal>>>({description, syntax, arguments, returned_value, examples, introduced_in, category});
diff --git a/src/Functions/base64URLDecode.cpp b/src/Functions/base64URLDecode.cpp
@@ -13,7 +13,7 @@ REGISTER_FUNCTION(Base64URLDecode)
     FunctionDocumentation::Arguments arguments = {{"encodedURL", "String column or constant. If the string is not a valid Base64-encoded value, an exception is thrown."}};
     FunctionDocumentation::ReturnedValue returned_value = "A string containing the decoded value of the argument.";
     FunctionDocumentation::Examples examples = {{"Example", "SELECT base64URLDecode('aHR0cDovL2NsaWNraG91c2UuY29t')", "https://clickhouse.com"}};
-    FunctionDocumentation::IntroducedIn introduced_in = FunctionDocumentation::VERSION_UNKNOWN;
+    FunctionDocumentation::IntroducedIn introduced_in = {24, 6};
     FunctionDocumentation::Category category = FunctionDocumentation::Category::Encoding;
 
     factory.registerFunction<FunctionBase64Conversion<Base64Decode<Base64Variant::URL>>>({description, syntax, arguments, returned_value, examples, introduced_in, category});
diff --git a/src/Functions/base64URLEncode.cpp b/src/Functions/base64URLEncode.cpp
@@ -13,7 +13,7 @@ REGISTER_FUNCTION(Base64URLEncode)
     FunctionDocumentation::Arguments arguments = {{"url", "String column or constant."}};
     FunctionDocumentation::ReturnedValue returned_value = "A string containing the encoded value of the argument.";
     FunctionDocumentation::Examples examples = {{"Example", "SELECT base64URLEncode('https://clickhouse.com')", "aHR0cHM6Ly9jbGlja2hvdXNlLmNvbQ"}};
-    FunctionDocumentation::IntroducedIn introduced_in = FunctionDocumentation::VERSION_UNKNOWN;
+    FunctionDocumentation::IntroducedIn introduced_in = {24, 6};
     FunctionDocumentation::Category category = FunctionDocumentation::Category::Encoding;
 
     factory.registerFunction<FunctionBase64Conversion<Base64Encode<Base64Variant::URL>>>({description, syntax, arguments, returned_value, examples, introduced_in, category});
diff --git a/src/Functions/dateTimeToSnowflakeID.cpp b/src/Functions/dateTimeToSnowflakeID.cpp
@@ -140,7 +140,7 @@ REGISTER_FUNCTION(DateTimeToSnowflakeID)
         };
         FunctionDocumentation::ReturnedValue returned_value = "Input value converted to [UInt64](../data-types/int-uint.md) as the first Snowflake ID at that time.";
         FunctionDocumentation::Examples examples = {{"simple", "SELECT dateTimeToSnowflakeID(toDateTime('2021-08-15 18:57:56', 'Asia/Shanghai'))", "6832626392367104000"}};
-        FunctionDocumentation::IntroducedIn introduced_in = FunctionDocumentation::VERSION_UNKNOWN;
+        FunctionDocumentation::IntroducedIn introduced_in = {24, 6};
         FunctionDocumentation::Category category = FunctionDocumentation::Category::UUID;
 
         factory.registerFunction<FunctionDateTimeToSnowflakeID>({description, syntax, arguments, returned_value, examples, introduced_in, category});
@@ -155,7 +155,7 @@ REGISTER_FUNCTION(DateTimeToSnowflakeID)
         };
         FunctionDocumentation::ReturnedValue returned_value = "Input value converted to [UInt64](../data-types/int-uint.md) as the first Snowflake ID at that time.";
         FunctionDocumentation::Examples examples = {{"simple", "SELECT dateTime64ToSnowflakeID(toDateTime64('2021-08-15 18:57:56', 3, 'Asia/Shanghai'))", "6832626394434895872"}};
-        FunctionDocumentation::IntroducedIn introduced_in = FunctionDocumentation::VERSION_UNKNOWN;
+        FunctionDocumentation::IntroducedIn introduced_in = {24, 6};
         FunctionDocumentation::Category category = FunctionDocumentation::Category::UUID;
 
         factory.registerFunction<FunctionDateTime64ToSnowflakeID>({description, syntax, arguments, returned_value, examples, introduced_in, category});
diff --git a/src/Functions/generateSnowflakeID.cpp b/src/Functions/generateSnowflakeID.cpp
@@ -224,7 +224,7 @@ REGISTER_FUNCTION(GenerateSnowflakeID)
     };
     FunctionDocumentation::ReturnedValue returned_value = "A value of type UInt64";
     FunctionDocumentation::Examples examples = {{"no_arguments", "SELECT generateSnowflakeID()", "7201148511606784000"}, {"with_machine_id", "SELECT generateSnowflakeID(1)", "7201148511606784001"}, {"with_expression_and_machine_id", "SELECT generateSnowflakeID('some_expression', 1)", "7201148511606784002"}};
-    FunctionDocumentation::IntroducedIn introduced_in = FunctionDocumentation::VERSION_UNKNOWN;
+    FunctionDocumentation::IntroducedIn introduced_in = {24, 6};
     FunctionDocumentation::Category category = FunctionDocumentation::Category::UUID;
 
     factory.registerFunction<FunctionGenerateSnowflakeID>({description, syntax, arguments, returned_value, examples, introduced_in, category});
diff --git a/src/Functions/generateUUIDv7.cpp b/src/Functions/generateUUIDv7.cpp
@@ -218,7 +218,7 @@ REGISTER_FUNCTION(GenerateUUIDv7)
     FunctionDocumentation::Arguments arguments = {{"expression", "The expression is used to bypass common subexpression elimination if the function is called multiple times in a query but otherwise ignored. Optional."}};
     FunctionDocumentation::ReturnedValue returned_value = "A value of type UUID version 7.";
     FunctionDocumentation::Examples examples = {{"single", "SELECT generateUUIDv7()", ""}, {"multiple", "SELECT generateUUIDv7(1), generateUUIDv7(2)", ""}};
-    FunctionDocumentation::IntroducedIn introduced_in = FunctionDocumentation::VERSION_UNKNOWN;
+    FunctionDocumentation::IntroducedIn introduced_in = {24, 5};
     FunctionDocumentation::Category category = FunctionDocumentation::Category::UUID;
 
     factory.registerFunction<FunctionGenerateUUIDv7Base>({description, syntax, arguments, returned_value, examples, introduced_in, category});
diff --git a/src/Functions/icebergTruncate.cpp b/src/Functions/icebergTruncate.cpp
@@ -191,7 +191,7 @@ REGISTER_FUNCTION(IcebergTruncate)
     FunctionDocumentation::Arguments arguments = {{"value", "String, integer or Decimal value."}};
     FunctionDocumentation::ReturnedValue returned_value = "The same type as argument";
     FunctionDocumentation::Examples examples = {{"Example", "SELECT icebergTruncate(3, 'iceberg')", "ice"}};
-    FunctionDocumentation::IntroducedIn introduced_in = FunctionDocumentation::VERSION_UNKNOWN;
+    FunctionDocumentation::IntroducedIn introduced_in = {25, 3};
     FunctionDocumentation::Category category = FunctionDocumentation::Category::Other;
 
     factory.registerFunction<FunctionIcebergTruncate>({description, syntax, arguments, returned_value, examples, introduced_in, category});
diff --git a/src/Functions/locate.cpp b/src/Functions/locate.cpp
@@ -26,7 +26,7 @@ REGISTER_FUNCTION(Locate)
                                                       {"start_pos", "Position (1-based) in `haystack` at which the search starts (UInt*)."}};
     FunctionDocumentation::ReturnedValue doc_returned_value = "Starting position in bytes and counting from 1, if the substring was found. 0, if the substring was not found.";
     FunctionDocumentation::Examples doc_examples = {{"Example", "SELECT locate('abcabc', 'ca');", "3"}};
-    FunctionDocumentation::IntroducedIn doc_introduced_in = FunctionDocumentation::VERSION_UNKNOWN;
+    FunctionDocumentation::IntroducedIn doc_introduced_in = {18, 16};
     FunctionDocumentation::Category doc_category = FunctionDocumentation::Category::StringSearch;
 
     factory.registerFunction<FunctionLocate>({doc_description, doc_syntax, doc_arguments, doc_returned_value, doc_examples, doc_introduced_in, doc_category}, FunctionFactory::Case::Insensitive);
diff --git a/src/Functions/lowerUTF8.cpp b/src/Functions/lowerUTF8.cpp
@@ -28,7 +28,7 @@ REGISTER_FUNCTION(LowerUTF8)
     FunctionDocumentation::Arguments arguments = {{"input", "Input with String type"}};
     FunctionDocumentation::ReturnedValue returned_value = "A String data type value";
     FunctionDocumentation::Examples examples = { {"first", "SELECT lowerUTF8('München') as Lowerutf8;", "münchen"}, };
-    FunctionDocumentation::IntroducedIn introduced_in = FunctionDocumentation::VERSION_UNKNOWN;
+    FunctionDocumentation::IntroducedIn introduced_in = {1, 1};
     FunctionDocumentation::Category category = FunctionDocumentation::Category::String;
 
     factory.registerFunction<FunctionLowerUTF8>({description, syntax, arguments, returned_value, examples, introduced_in, category});
diff --git a/src/Functions/snowflakeIDToDateTime.cpp b/src/Functions/snowflakeIDToDateTime.cpp
@@ -187,7 +187,7 @@ REGISTER_FUNCTION(SnowflakeIDToDateTime)
         };
         FunctionDocumentation::ReturnedValue returned_value = "The timestamp component of `value` as a [DateTime](../data-types/datetime.md) value.";
         FunctionDocumentation::Examples examples = {{"simple", "SELECT snowflakeIDToDateTime(7204436857747984384)", "2024-06-06 10:59:58"}};
-        FunctionDocumentation::IntroducedIn introduced_in = FunctionDocumentation::VERSION_UNKNOWN;
+        FunctionDocumentation::IntroducedIn introduced_in = {24, 6};
         FunctionDocumentation::Category category = FunctionDocumentation::Category::UUID;
 
         factory.registerFunction<FunctionSnowflakeIDToDateTime>({description, syntax, arguments, returned_value, examples, introduced_in, category});
@@ -203,7 +203,7 @@ REGISTER_FUNCTION(SnowflakeIDToDateTime)
         };
         FunctionDocumentation::ReturnedValue returned_value = "The timestamp component of `value` as a [DateTime64](../data-types/datetime64.md) with scale = 3, i.e. millisecond precision.";
         FunctionDocumentation::Examples examples = {{"simple", "SELECT snowflakeIDToDateTime64(7204436857747984384)", "2024-06-06 10:59:58"}};
-        FunctionDocumentation::IntroducedIn introduced_in = FunctionDocumentation::VERSION_UNKNOWN;
+        FunctionDocumentation::IntroducedIn introduced_in = {24, 6};
         FunctionDocumentation::Category category = FunctionDocumentation::Category::UUID;
 
         factory.registerFunction<FunctionSnowflakeIDToDateTime64>({description, syntax, arguments, returned_value, examples, introduced_in, category});
diff --git a/src/Functions/toMonthNumSinceEpoch.cpp b/src/Functions/toMonthNumSinceEpoch.cpp
@@ -16,7 +16,7 @@ REGISTER_FUNCTION(ToMonthNumSinceEpoch)
     FunctionDocumentation::Arguments arguments = {{"date", "Date, DateTime or DateTime64"}};
     FunctionDocumentation::ReturnedValue returned_value = "Positive integer";
     FunctionDocumentation::Examples examples = {{"Example", "SELECT toMonthNumSinceEpoch(toDate('2024-10-01'))", "657"}};
-    FunctionDocumentation::IntroducedIn introduced_in = FunctionDocumentation::VERSION_UNKNOWN;
+    FunctionDocumentation::IntroducedIn introduced_in = {25, 3};
     FunctionDocumentation::Category category = FunctionDocumentation::Category::DateAndTime;
 
     factory.registerFunction<FunctionToMonthNumSinceEpoch>({description, syntax, arguments, returned_value, examples, introduced_in, category});
diff --git a/src/Functions/toYearNumSinceEpoch.cpp b/src/Functions/toYearNumSinceEpoch.cpp
@@ -16,7 +16,7 @@ REGISTER_FUNCTION(ToYearNumSinceEpoch)
     FunctionDocumentation::Arguments arguments = {{"date", "Date, DateTime or DateTime64"}};
     FunctionDocumentation::ReturnedValue returned_value = "Positive integer";
     FunctionDocumentation::Examples examples = {{"Example", "SELECT toYearNumSinceEpoch(toDate('2024-10-01'))", "54"}};
-    FunctionDocumentation::IntroducedIn introduced_in = FunctionDocumentation::VERSION_UNKNOWN;
+    FunctionDocumentation::IntroducedIn introduced_in = {25, 3};
     FunctionDocumentation::Category category = FunctionDocumentation::Category::DateAndTime;
 
     factory.registerFunction<FunctionToYearNumSinceEpoch>({description, syntax, arguments, returned_value, examples, introduced_in, category});
diff --git a/src/Functions/tryBase64Decode.cpp b/src/Functions/tryBase64Decode.cpp
@@ -12,7 +12,7 @@ REGISTER_FUNCTION(TryBase64Decode)
     FunctionDocumentation::Arguments arguments = {{"encoded", "String column or constant. If the string is not a valid Base64-encoded value, returns an empty string."}};
     FunctionDocumentation::ReturnedValue returned_value = "A string containing the decoded value of the argument.";
     FunctionDocumentation::Examples examples = {{"valid", "SELECT tryBase64Decode('Y2xpY2tob3VzZQ==')", "clickhouse"}, {"invalid", "SELECT tryBase64Decode('invalid')", ""}};
-    FunctionDocumentation::IntroducedIn introduced_in = FunctionDocumentation::VERSION_UNKNOWN;
+    FunctionDocumentation::IntroducedIn introduced_in = {18, 16};
     FunctionDocumentation::Category category = FunctionDocumentation::Category::Encoding;
 
     factory.registerFunction<FunctionBase64Conversion<TryBase64Decode<Base64Variant::Normal>>>({description, syntax, arguments, returned_value, examples, introduced_in, category});
diff --git a/src/Functions/tryBase64URLDecode.cpp b/src/Functions/tryBase64URLDecode.cpp
@@ -12,7 +12,7 @@ REGISTER_FUNCTION(TryBase64URLDecode)
     FunctionDocumentation::Arguments arguments = {{"encodedURL", "String column or constant. If the string is not a valid Base64-encoded value with URL-specific modifications, returns an empty string."}};
     FunctionDocumentation::ReturnedValue returned_value = "A string containing the decoded value of the argument.";
     FunctionDocumentation::Examples examples = {{"valid", "SELECT tryBase64URLDecode('aHR0cHM6Ly9jbGlja2hvdXNlLmNvbQ')", "https://clickhouse.com"}, {"invalid", "SELECT tryBase64UrlDecode('aHR0cHM6Ly9jbGlja')", ""}};
-    FunctionDocumentation::IntroducedIn introduced_in = FunctionDocumentation::VERSION_UNKNOWN;
+    FunctionDocumentation::IntroducedIn introduced_in = {24, 6};
     FunctionDocumentation::Category category = FunctionDocumentation::Category::Encoding;
 
     factory.registerFunction<FunctionBase64Conversion<TryBase64Decode<Base64Variant::URL>>>({description, syntax, arguments, returned_value, examples, introduced_in, category});
diff --git a/src/Functions/upperUTF8.cpp b/src/Functions/upperUTF8.cpp
@@ -28,7 +28,7 @@ REGISTER_FUNCTION(UpperUTF8)
     FunctionDocumentation::Arguments arguments = {{"input", "Input with String type"}};
     FunctionDocumentation::ReturnedValue returned_value = "A String data type value";
     FunctionDocumentation::Examples examples = { {"first", "SELECT upperUTF8('München') as Upperutf8;", "MÜNCHEN"}, };
-    FunctionDocumentation::IntroducedIn introduced_in = FunctionDocumentation::VERSION_UNKNOWN;
+    FunctionDocumentation::IntroducedIn introduced_in = {1, 1};
     FunctionDocumentation::Category category = FunctionDocumentation::Category::String;
 
     factory.registerFunction<FunctionUpperUTF8>({description, syntax, arguments, returned_value, examples, introduced_in, category});
diff --git a/tests/queries/0_stateless/02414_all_new_table_functions_must_be_documented.sql b/tests/queries/0_stateless/02414_all_new_table_functions_must_be_documented.sql
@@ -1,6 +1,7 @@
--- This outputs the list of undocumented table functions. No new items in the list should appear.
--- Please help shorten this list down to zero elements.
+-- This outputs the list of undocumented table functions.
+-- No new items in the list should appear. Please help shorten this list down to zero elements.
 SELECT name FROM system.table_functions WHERE length(description) < 10
 AND name NOT IN (
-    'cosn', 'oss', 'hdfs', 'hdfsCluster', 'hive', 'mysql', 'postgresql', 's3', 's3Cluster', 'sqlite', 'urlCluster', 'mergeTreeParts' -- these functions are not enabled in fast test
+    -- these table functions are not enabled in fast test
+    'cosn', 'oss', 'hdfs', 'hdfsCluster', 'hive', 'mysql', 'postgresql', 's3', 's3Cluster', 'sqlite', 'urlCluster', 'mergeTreeParts'
 ) ORDER BY name;
diff --git a/tests/queries/0_stateless/02415_all_new_functions_must_be_documented.sql b/tests/queries/0_stateless/02415_all_new_functions_must_be_documented.sql
@@ -1,7 +1,8 @@
--- This outputs the list of undocumented functions. No new items in the list should appear.
--- Please help shorten this list down to zero elements.
+-- This outputs the list of undocumented functions.
+-- No new items in the list should appear. Please help shorten this list down to zero elements.
 SELECT name FROM system.functions WHERE NOT is_aggregate AND origen = 'System' AND alias_to = '' AND length(description) < 10
 AND name NOT IN (
+     -- these functions are not enabled in fast test
     'aes_decrypt_mysql', 'aes_encrypt_mysql', 'decrypt', 'encrypt',
     'convertCharset',
     'detectLanguage', 'detectLanguageMixed',
@@ -15,5 +16,4 @@ AND name NOT IN (
     'normalizeUTF8NFC', 'normalizeUTF8NFD', 'normalizeUTF8NFKC', 'normalizeUTF8NFKD',
     'lemmatize', 'tokenize', 'stem', 'synonyms', 'kql_array_sort_asc', 'kql_array_sort_desc',
     'detectCharset', 'detectLanguageUnknown', 'detectProgrammingLanguage', 'detectTonality'
-     -- these functions are not enabled in fast test
 ) ORDER BY name;
diff --git a/tests/queries/0_stateless/02415_all_new_functions_must_have_version_information.reference b/tests/queries/0_stateless/02415_all_new_functions_must_have_version_information.reference
diff --git a/tests/queries/0_stateless/02415_all_new_functions_must_have_version_information.sql b/tests/queries/0_stateless/02415_all_new_functions_must_have_version_information.sql
