👀 Introduction toggle

Disallow Leading % in LIKE

Database cannot use an index to match entries when there is a leading wildcard. It can cause serious performance problems because it may scan the entire table.

schema-review-query-where-no-leading-wildcard-like

How the rule works

Bytebase considers this rule to be violated if the SQL has leading wildcard LIKE.

Support database engine

  • MySQL
  • TiDB

Support for PostgreSQL is coming soon.