A scalar subquery must return exactly one row (or zero rows, which MySQL treats as NULL). When it returns multiple rows, it should raise a proper error with a clear message.
Ada, Akka, C++, COBOL, Component Pascal, Dafny, Dart, Deno, Docker, Erlang, Flix, Go, GraalVM, Haskell, Kotlin, LLVM, Modula-2, Node.js, Rust, Scala 3, Spark, Spring ...