DOCUMENTATION
/
Getting Started
Guides
Developer
Reference
Releases
Tutorials
Snowflake Open Catalog
Status
  1. Overview
    • Release notes
    • Snowflake weekly, Snowsight, and feature releases
    • Behavior changes
        1. About behavior changes
          • Behavior change policy
            • Behavior change management
              • Current bundles
              • 2025_03 Bundle (Disabled by Default)
              • 2025_02 Bundle (Enabled by Default)
              • 2025_01 Bundle (Generally Enabled)
              • Previous bundles
                1. 2024_08 bundle
                2. 2024_07 bundle
                3. 2024_06 bundle
                4. 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
                                • Streamlit in Snowflake releases
                                  • Client, driver, and library releases
                                    1. Monthly releases
                                    2. Client versions & support policy
                                    3. Snowflake Connector releases
                                      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
                                                        • Recent improvements
                                                        • Performance improvements
                                                        • SQL improvements
                                                          • Feature information
                                                          • Preview features
                                                            ReleasesBehavior changesPrevious 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 Terms© 2025 Snowflake, Inc. All Rights Reserved.
                                                            Language: English
                                                            • English
                                                            • Français
                                                            • Deutsch
                                                            • 日本語
                                                            • 한국어
                                                            • Português