DOCUMENTATION
/
Get started
Guides
Developer
Reference
Release notes
Tutorials
Status
  1. Overview
    • Release notes
    • All release notes
      • Snowflake server release notes and feature updates
      • Streamlit in Snowflake release notes
        • Client, driver, and library release notes
          1. Monthly release notes
          2. Client versions & support policy
          3. Snowflake Connector release notes
            1. Snowflake Connector for Google Analytics Raw Data
              • Snowflake Connector for Google Analytics Aggregate Data
                • Snowflake Connector for ServiceNow V2
                  • Snowflake Connector for MySQL
                    • Snowflake Connector for PostgreSQL
                      • Snowflake Connector for Sharepoint
                        • Native SDK for Connectors
                          1. Native SDK for Connectors Java library
                            • Native SDK for Connectors Java Test library
                              • Native SDK for Connectors Java Template
                                • Native SDK Example Java GitHub Connector
                              • Snowflake Openflow release notes
                                • Behavior changes
                                • Behavior change announcements
                                    1. About behavior changes
                                      • Behavior change policy
                                        • Behavior change management
                                          • Current bundles
                                          • 2025_06 Bundle (Preview)
                                          • 2025_05 Bundle (Disabled by default)
                                          • 2025_04 Bundle (Enabled by default)
                                          • 2025_03 Bundle (Generally Enabled)
                                          • Previous bundles
                                            1. 2025_02 Bundle
                                            2. 2025_01 Bundle
                                            3. 2024_08 bundle
                                            4. 2024_07 bundle
                                            5. 2024_06 bundle
                                            6. 2024_05 bundle
                                                1. SQL Changes - Commands & Functions
                                                2. CREATE <object> commands: Changes to error messages when creating an object in a share
                                                  • DESCRIBE ICEBERG TABLE command: SOURCE ICEBERG TYPE column value change
                                                    • Full-text search: TOKEN_SEARCH function renamed to SEARCH
                                                      • SHOW MODELS Command: New columns in output
                                                        • SHOW REGIONS command: Changes to region display names in output
                                                          • SQL Changes — Usage Views & Information Schema Views / Table Functions
                                                          • LISTING_ACCESS_HISTORY view: New columns
                                                            • SNOWPARK_CONTAINER_SERVICES_HISTORY View (ACCOUNT_USAGE): New Columns
                                                              • Data Lake
                                                              • Apache Iceberg™ tables: Metadata file naming convention change
                                                                • Apache Iceberg™ tables: version-hint.text file no longer generated
                                                                  • Extensibility & Developer
                                                                  • ALTER APPLICATION PACKAGE command: Expanded validation
                                                                • 2024_04 bundle
                                                                • 2024_03 bundle
                                                                • 2024_02 bundle
                                                                • 2024_01 bundle
                                                                • 2023_08 bundle
                                                                • 2023_07 bundle
                                                                • 2023_06 bundle
                                                                • 2023_05 bundle
                                                                • 2023_04 bundle
                                                                • 2023_03 bundle
                                                                • 2023_02 bundle
                                                                • 2023_01 bundle
                                                                • Earlier bundles
                                                                • Unbundled changes
                                                            • Recent improvements
                                                            • Performance improvements
                                                            • SQL improvements
                                                              • Feature information
                                                              • Preview features
                                                                Release notesBehavior change announcementsPrevious bundles2024_05 bundleFull-text search: TOKEN_SEARCH function renamed to SEARCH

                                                                Full-text search: TOKEN_SEARCH function renamed to SEARCH¶

                                                                Attention

                                                                This behavior change is in the 2024_05 bundle.

                                                                For the current status of the bundle, refer to Bundle History.

                                                                The full-text search SQL function named TOKEN_SEARCH behaves as follows:

                                                                Before the change:

                                                                The full-text search SQL function is named TOKEN_SEARCH.

                                                                After the change:

                                                                The full-text search SQL function is named SEARCH. However, the current function name, TOKEN_SEARCH, will continue to work for a period of time.

                                                                Customers who have user-defined functions (UDFs) or stored procedures named SEARCH must rename those UDFs or stored procedures. Attempting to call a UDF or a procedure named SEARCH without qualification will result in a SQL compilation error. It is also possible that the SEARCH function could be executed instead of the UDF or procedure if the function signatures match exactly.

                                                                Ref: 1633

                                                                Was this page helpful?

                                                                Visit Snowflake
                                                                Join the conversation
                                                                Develop with Snowflake
                                                                Share your feedback
                                                                Read the latest on our blog
                                                                Get your own certification
                                                                Privacy NoticeSite TermsCookies Settings© 2025 Snowflake, Inc. All Rights Reserved.
                                                                Language: English
                                                                • English
                                                                • Français
                                                                • Deutsch
                                                                • 日本語
                                                                • 한국어
                                                                • Português