On Fri, Jan 31, 2025 at 4:31 PM Alena Rybakina <a.rybak...@postgrespro.ru> wrote: > I started reviewing at the patch and saw some output "ERROR" in the output of > the test and is it okay here? > > SELECT * FROM tenk1 t1 > WHERE t1.thousand = 42 OR t1.thousand = (SELECT t2.tenthous FROM tenk1 t2 > WHERE t2.thousand = t1.tenthous); > ERROR: more than one row returned by a subquery used as an expression
The output is correct for this query. But the query is very unfortunate for the regression test. I've revised query in the v47 revision [1]. Links. 1. https://www.postgresql.org/message-id/CAPpHfdsBZmNt9qUoJBqsQFiVDX1%3DyCKpuVAt1YnR7JCpP%3Dk8%2BA%40mail.gmail.com ------ Regards, Alexander Korotkov Supabase
