27

I've been searching for half an hour and can't find any resources stating what level of the SQL ANSI standard is supported on various database engines.

It looks like some level of support is provided by most engines, but I'd like to know exactly what level is officially supported.

I'm primarily interested in MySQL, PostgreSQL, SQL Server, and Oracle.

EDIT: PostgreSQL has a great page on compliance, exactly what I was looking for regarding the other engines: http://www.postgresql.org/docs/current/interactive/features.html

Deduplicator
  • 44,692
  • 7
  • 66
  • 118
bitblit
  • 413
  • 1
  • 4
  • 7
  • 1
    ANSI support depends on specific versions of the database products you listed, so it'd help us if you can clarify. This is a very broad question... – OMG Ponies Aug 30 '10 at 17:16
  • I am interested in the latest version of each product. However, I couldn't find ANSI compliance information even without restricting my research to a specific version. – bitblit Aug 30 '10 at 17:23
  • ANSI-89 would be the fundamental level. After that, it's not wholesale support--just features & functions as seen fit. – OMG Ponies Aug 30 '10 at 17:28
  • http://download.oracle.com/docs/cd/E11882_01/server.112/e10592/ap_standard_sql.htm – Shannon Severance Aug 30 '10 at 20:51

5 Answers5

15

these might help a little:

Comparison of different SQL implementations

wikipedia - Comparison of relational database management systems

wikipedia - SQL - Standardization

KM.
  • 101,727
  • 34
  • 178
  • 212
6

The question of "which level of the standard" is too simple.

There are portions of the standard that are implemented by no engine at all, e.g. CREATE ASSERTION.

For that reason, it might be better to speak of "percentage of standard features supported" for each individual engine. But the vendors will be very reluctant to publish such measurements themselves.

Erwin Smout
  • 18,113
  • 4
  • 33
  • 52
2

The PostgreSQL manual has for all SQL statements a compatibility section.

Frank Heikens
  • 117,544
  • 24
  • 142
  • 135
2

According to the HSQLDB manual, it is the most standards compliant RDBMS.

  • Almost all syntactic features of SQL-92 up to Advanced Level are supported
  • SQL:2008 core and many optional features of this standard
Janus Troelsen
  • 20,267
  • 14
  • 135
  • 196
  • 1
    " supports the widest range of SQL standard features among all open source RDBMS." – Erwin Smout Feb 24 '15 at 13:56
  • Other comparisons that actually list the features such as here: http://troels.arvin.dk/db/rdbms/ (granted it needs to be updated), have SQL Server as the least compliant. Which makes one wonder what standard they are talking about in your quote? – markmnl Oct 12 '16 at 23:50
  • @markmnl This answer is about HSQLDB, not SQL Server. The guide you're quoting doesn't even mention HSQLDB. Which makes one wonder what you're talking about? :-) – Aaron Bertrand Aug 13 '18 at 12:22
0

Firebird 3 sql standard conformance page

Mariuz
  • 1,190
  • 2
  • 10
  • 19
Hugues Van Landeghem
  • 6,755
  • 3
  • 34
  • 59