db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4586) Add compatibility tests to explore behavior differences between Derby and other DBMS implementations
Date Sat, 05 Mar 2011 22:41:45 GMT

    [ 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

The compatibility pages that you linked to are very interesting; these are definitely the
of issues that we can work on.

I'm particularly interested in finding test suites for other open source databases, which
test cases which can be run against Derby, to determine whether Derby passes those tests or

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
> ----------------------------------------------------------------------------------------------------
>                 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


View raw message