Friday, April 20, 2012

Oracle 8 Bug

I don't suppose many of you are using Oracle 8 nowadays. Due to a bug in that version, if you tried to reference a synonym pointing to an object which did not exist, this produced a core dump:
  
SQL> create public synonym andrew for andrew;
 
Synonym created.
 
SQL> desc andrew
Stack overflow: pid 9058, proc sqlplus, addr 0x11fdfffd0, pc 0x3ff805900b8
Memory fault(coredump)

No comments: