Not every value fits a scalar column. Product attributes differ by kind, reviews are free text searched by word, and stores sit on a globe. MySQL 524 keeps all three in ordinary InnoDB tables: a binary JSON type with paths and indexes, FULLTEXT indexes with relevance ranking, and geometry types with ellipsoidal math. The small shop data set is deliberate: it exposes the tokenizer and axis-order rules that surprise people on real tables.
MENU
JSON, Full-Text, Spatial
JSON, Full-Text, and Spatial Data