03 – Full-Text Search

Theory

GIN index for full-text

Boolean operators in tsquery

Common configuration

Task

Full Working Code

`src/main/java/com/example/demo/model/Order.java` (augmented)

SQL Setup (executed in `@BeforeEach` or Flyway migration)

`src/main/java/com/example/demo/repository/OrderRepository.java` (augmented)

`src/test/java/com/example/demo/repository/FullTextSearchTest.java`

Expected Output

Lexemes output:

Full-text search results:

EXPLAIN plan:

Verification Steps