On Wed, Aug 13, 2014 at 5:55 AM, Scott Chapman <[email protected]> wrote:
> Operative word here is "start". Having spent a fair bit of time poking at > MySQL (albeit not the most recent version, nor the MariaDB fork), let's > just say it's not DB2. Not that it's not a good product, especially given > it's price, but it definitely does a number of things in a non-standard > way. One of the most annoying is that table names are case sensitive on > *nix operating systems, in direct conflict with the SQL standard. And to > add to the confusion, table names are not cases sensitive on Windows. > Hum, I don't use MySQL/MariaDB and never had. The above is _NOT_ true of PostgreSQL, which is what I use exclusively. Transcript of interactive PostgreSQL session using the command line "psql" command on Linux Fedora 20: psql (9.3.4) Type "help" for help. tsh009=# create table x (id integer); CREATE TABLE tsh009=# create table X (ID integer); ERROR: relation "x" already exists tsh009=# insert into x values(1); INSERT 0 1 tsh009=# insert into X values(2); INSERT 0 1 tsh009=# select * from x; id ---- 1 2 (2 rows) tsh009=# select * from X; id ---- 1 2 (2 rows) tsh009=# > > But again, for the price, one probably is willing to put up with the > quirks. > I'm not. That's why I rejected MySQL when I was first looking for an SQL data base on Linux. The MySQL at the time was not ACID either. It was really just SQL like access to a data store. Like some z/OS products can do SQL queries against a VSAM data set. Nobody would say that VSAM is an RDMS. > > A couple of years ago I would have assumed that portability of > applications between databases would be relatively easy, but it turns out > that it's really not easy at all. > We've discovered that when we wanted to move from Oracle to MS SQL Server at work. > > Scott Chapman > > -- There is nothing more pleasant than traveling and meeting new people! Genghis Khan Maranatha! <>< John McKown ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
