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 Wed, 17 Mar 2010 14:50:27 GMT

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

View raw message