[
https://issues.apache.org/jira/browse/DERBY-4586?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13003053#comment-13003053
]
Bryan Pendleton commented on DERBY-4586:
----------------------------------------
I think that SQL Syntax compatibility and JDBC API compatibility are the two
most important issues.
The compatibility pages that you linked to are very interesting; these are
definitely the sort
of issues that we can work on.
I'm particularly interested in finding test suites for other open source
databases, which contain
test cases which can be run against Derby, to determine whether Derby passes
those tests or not.
If Derby does NOT pass a certain test, we need to determine whether it is:
a) a non-standard test which uses non-standard SQL or JDBC features, in which
case the other database has chosen to support this non-standard behavior but
Derby may not wish to. We would then add documentation of this sort of
behavior difference to the Derby documentation (e.g., in the Derby wiki).
b) OR, it is a standard test using standard SQL and JDBC features, but it
reveals
a bug in Derby as Derby does not implement that feature properly. In this case,
we would log a new Jira issue against Derby, add that test case to the Derby
test
suite, and see if we could fix the bug in Derby.
That is the goal of this project.
> 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
> Labels: gsoc, gsoc2010, gsoc2011, mentor
>
> 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.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
