message: Added random string benchmark for the suffix function.
diff: @@ -252,3 +252,56 @@ string BenchmarkInfo() override {
  return "STRING PREFIX store pointer LIKE";
  }
  FINISH_BENCHMARK(StringPrefixPointerLike)
  +
  +//----------------------- SUFFIX benchmark ----------------------------------//
  +DUCKDB_BENCHMARK(StringSuffixShort, "[string]")
  +STRING_DATA_GEN_BODY(4)
  +string GetQuery() override {
  + return "SELECT suffix(s1, 'a') FROM strings";
  +}
  +string BenchmarkInfo() override {
  + return "Short string for suffix";
  +}
  +FINISH_BENCHMARK(StringSuffixShort)
  +
  +DUCKDB_BENCHMARK(StringSuffixLong, "[string]")
  +STRING_DATA_GEN_BODY(20)
  +string GetQuery() override {
  + return "SELECT suffix(s1, 'a') FROM strings";
  +}
  +string BenchmarkInfo() override {
  + return "Long string for suffix";
  +}
  +FINISH_BENCHMARK(StringSuffixLong)
  +
  +//----------------------- SUFFIX REGEX benchmark ----------------------------------//
  +DUCKDB_BENCHMARK(StringSuffixRegEX, "[string]")
  +STRING_DATA_GEN_BODY(4)
  +string GetQuery() override {
  + return "SELECT REGEXP_MATCHES(s1, '%a') FROM strings";
  +}
  +string BenchmarkInfo() override {
  + return "STRING suffix REGEX";
  +}
  +FINISH_BENCHMARK(StringSuffixRegEX)
  +
  +//----------------------- SUFFIX LIKE benchmark ----------------------------------//
  +DUCKDB_BENCHMARK(StringSuffixLikeShort, "[string]")
  +STRING_DATA_GEN_BODY(4)
  +string GetQuery() override {
  + return "SELECT s1 FROM strings WHERE s1 LIKE '%a'";
  +}
  +string BenchmarkInfo() override {
  + return "Short string for suffix with LIKE";
  +}
  +FINISH_BENCHMARK(StringSuffixLikeShort)
  +
  +DUCKDB_BENCHMARK(StringSuffixLikeLong, "[string]")
  +STRING_DATA_GEN_BODY(20)
  +string GetQuery() override {
  + return "SELECT s1 FROM strings WHERE s1 LIKE '%a'";
  +}
  +string BenchmarkInfo() override {
  + return "Long string for suffix with LIKE";
  +}
  +FINISH_BENCHMARK(StringSuffixLikeLong)
  