The main problem in testing the software was lack of test cases. Potential customers provided some code and a little was obtained from various sites on the internet. There is a validation suite for SQL, however this is currently targeted at Entry level. Vendor extensions Vendor extensions are a major problem. Vendors have added many, disparate extensions to the language.
Most extensions involve additional syntax rules.
These create a burden on an already large grammar. Fortunately for us a small number of vendors have cornered most of the market. The decision was made to concentrate on those frequently used vendor extensions supported by the major vendors. Oracle have the largest market share and were given priority. Because these constructs are new they have yet to make a substantial impact on the code that OSPC processes.