Обсуждение: re: SQL compliance, was Re: [HACKERS] follow-up on PC Week Labs benchmark results

Поиск
Список
Период
Сортировка

re: SQL compliance, was Re: [HACKERS] follow-up on PC Week Labs benchmark results

От
Timothy Dyck
Дата:

>You had inquired earlier about "when we would support complete SQL92"
(give or take a few words). What areas of entry level SQL92 are we
missing in your opinion (or should we wait for the article)?

Well, what I look for on the language side is complete SQL-92 entry level
compliance, plus common language extensions like outer joins, cast, case,
cube, rollup, a datetime data type, add table constraint and alter table.
Also, I look for a stored procedure language. Basically, parity with the
commercial databases. :)

The key measure I'd look for with SQL compliance is passing the NIST FIPS
127 SQL92 test. NIST discontinued its testing policy, which was a bad thing
for the industry, but the test may still be available from NIST. The spec
itself still is available for free; I ordered a copy a few weeks ago.

-Tim Dyck