[
https://issues.apache.org/jira/browse/DERBY-4586?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12846435#action_12846435
]
Bryan Pendleton commented on DERBY-4586:
----------------------------------------
[ From a derby-dev mail thread ... ]
But I think we are specifically interested in the idea of compatibility
*tests* which we could use to demonstrate compatibility with Oracle, SQL Server,
MySQL, Postgres, etc.
Are there existing compatibility test suites out there? Can you research this?
What would it take to run those tests against a variety of implementations,
including both Derby and others?
How could we automate that process so that we could add it to our test
suites and keep it up to date over time?
We have some existing information about Derby compatibility in our wiki:
- http://wiki.apache.org/db-derby/SQLvsDerbyFeatures
- http://wiki.apache.org/db-derby/JDBCSupport
- http://wiki.apache.org/db-derby/PlatformTestsDerby
What would we need to do in order to be able to write a similar page which
discusses Derby compatibility with, e.g., MySQL and/or Postgres? That is,
what tests do we have to run to gather this information?
One place to start would be to see if either MySQL or Postgres have existing
SQL-compliance or JDBC-compliance suites that we could run against Derby to
compare the results.
> Add compatibility tests to explore behavior differences between Derby and
> other DBMS implementations
> ----------------------------------------------------------------------------------------------------
>
> Key: DERBY-4586
> URL: https://issues.apache.org/jira/browse/DERBY-4586
> Project: Derby
> Issue Type: Improvement
> Components: Documentation, JDBC, SQL, Test
> Reporter: Bryan Pendleton
> Assignee: Bryan Pendleton
>
> It would be interesting to understand Derby's compatibility with other major
> DBMS implementations, such as: Oracle, Sybase, SQL Server, DB2, MySQL, etc.
> I believe this would be an excellent project for a motivated Google Summer of
> Code intern.
> The goal of the project would be to locate various existing compatibility
> test suites and bring them into the Derby test environment, as well as to
> augment those test suites with additional tests developed during the project.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
