News for hackers. Stuff that matters.
Re:MySQL is to SQL like MongoDB to NoSQL by pyre on Wednesday October 02, 2013 @01:31PM (#6483902)
Oracle doesn't have transactional DDL.
Re:MySQL is to SQL like MongoDB to NoSQL by dragonwriter on Wednesday October 02, 2013 @01:39PM (#6483951)
The upthread comparison was to PostgreSQL (which fully supports transactional DDL), not Oracle (which does not.)

(Oracle 11g R2 provides something like Transactional DDL via Edition Based Redefinition. MS SQL has partial support for transactional DDL; PostgreSQL, DB2, Firebird, Informix, and Sybase Adaptive Server all support Transactional DDL [1].)

[1] http://wiki.postgresql.org/wiki/Transactional_DDL_in_Postgre...

Re:MySQL is to SQL like MongoDB to NoSQL by pyre on Wednesday October 02, 2013 @03:20PM (#6484619)
True but Oracle owns MySQL. If their flagship product doesn't have it, are they going to put in the effort to add it to their free offering?
Re:MySQL is to SQL like MongoDB to NoSQL by VLM on Wednesday October 02, 2013 @05:53PM (#6485647)
A conspiracy theory would be putting an intentionally buggy one in their free offering. It would have to be buggy by design such that it would be incompatible with a later patch. Then put non buggy design 2.0 in the paid product. Perhaps the inability to design a bad design like that is why that scenario hasn't been initiated. Sometimes it is hard to think of intentionally bad code, although it seems easy enough to generate when I'm trying to write good code.