LWN.net Logo

MySQL 5.0 Preview: still no sequences

MySQL 5.0 Preview: still no sequences

Posted Jan 15, 2004 11:33 UTC (Thu) by melo@simplicidade.org (guest, #4380)
Parent article: MySQL 5.0 Preview

I find it amusing that MySQL tries to add enterprise features, but fails completely to ease the
porting of Oracle SQL to MySQL.

I have a large application written for Oracle. The SQL is fairly standart and I probably could
use it with MySQL. The only exception is Sequences.

I'm amazed that a relativelly simple thing as sequences haven't maded into MySQL.

Oh well,


(Log in to post comments)

MySQL 5.0 Preview: still no sequences

Posted Jan 15, 2004 18:37 UTC (Thu) by freethinker (guest, #4397) [Link]

Did you email the MySQL team to ask for them?

MySQL 5.0 Preview: still no sequences

Posted Jan 16, 2004 0:35 UTC (Fri) by melo@simplicidade.org (guest, #4380) [Link]

Two years ago.

MySQL 5.0 Preview: still no sequences

Posted Jan 16, 2004 21:30 UTC (Fri) by Dom2 (guest, #458) [Link]

Does it have to be MySQL? PostgreSQL is a better match for Oracle features. Sequences in particular are there. And PLPGSQL is very similiar to PL/SQL.

-Dom

MySQL 5.0 Preview: still no sequences

Posted Jan 22, 2004 16:08 UTC (Thu) by leandro (guest, #1460) [Link]

> fails completely to ease the porting of Oracle SQL to MySQL.

One can have either standards conformance, or Oracle compatibility. Not both. Even data types are different.

I doubt Oracle migration is a market for MySQL. Witness they appointed SAPdb under the MaxDB moniker as their upgrade path.

> I have a large application written for Oracle. The SQL is fairly standart

No, it is not. Oracle is in serious deviation from the ISO SQL standard.

MySQL 5.0 Preview: still no sequences

Posted Feb 3, 2004 10:49 UTC (Tue) by shane (subscriber, #3335) [Link]

Oracle is in serious deviation from the ISO SQL standard.

This is true, but I give them a little credit since they were the first platform-independent SQL server (as in, you didn't have to buy vendor-specific hardware with it). ;)

MySQL 5.0 Preview: still no sequences

Posted Feb 9, 2004 20:45 UTC (Mon) by leandro (guest, #1460) [Link]

> they were the first platform-independent SQL server

In fact they were the first, period. Larry Elison launched Oracle from IBM's System R papers even before IBM itself had a product.

This 'merit' is more of a function of them not being hardware vendors, just like Microsoft in the OS field.

Copyright © 2013, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds