Need some sleep, 18c XE
From: Michael D O'Shea/Woodward Informatics Ltd <woodwardinformatics_at_strychnine.co.uk>
Date: Thu, 10 Dec 2020 18:17:57 +0000
Message-Id: <62C6ED99-2253-4E40-AAC8-1099079848D1_at_strychnine.co.uk>
Chaps, it has been a long day and I have been chasing a bug in ORM generated SQL all afternoon. I demo it minimally below using some contrived code.
Date: Thu, 10 Dec 2020 18:17:57 +0000
Message-Id: <62C6ED99-2253-4E40-AAC8-1099079848D1_at_strychnine.co.uk>
Chaps, it has been a long day and I have been chasing a bug in ORM generated SQL all afternoon. I demo it minimally below using some contrived code.
Do I just need some sleep? 3, really?
Mike
Woodward Informatics Ltd
SQL> SQL> SQL> desc foo Name Null? Type ----------------------------------------- -------- ---------------------------- ID NUMBER
SQL> select * from foo;
ID
1
2
3
SQL> select f1.id from foo f1 where f1.id > all (select f0.id from foo f0 where f0.id > f1.id);
ID
3
SQL> SQL> SQL>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 10 2020 - 19:17:57 CET