v.22.9Improvement
Allow CONSTRAINTs for ODBC and JDBC tables
Allow CONSTRAINTs for ODBC and JDBC tables. #34551 (Alexey Milovidov).
Why it matters
This feature enables users to add CONSTRAINTs when working with ODBC and JDBC table engines, improving data integrity and validation by enforcing rules directly on external tables accessed via these connectors.How to use it
Users can now include CONSTRAINT definitions when creating or altering ODBC and JDBC tables, similar to other table engines. Define constraints within theCREATE TABLE or ALTER TABLE statements as usual.