You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@oodt.apache.org by "Tom Barber (JIRA)" <ji...@apache.org> on 2013/08/28 22:56:51 UTC

[jira] [Assigned] (OODT-460) DataSourceCatalog doesn't work with MySQL

     [ https://issues.apache.org/jira/browse/OODT-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tom Barber reassigned OODT-460:
-------------------------------

    Assignee: Tom Barber
    
> DataSourceCatalog doesn't work with MySQL
> -----------------------------------------
>
>                 Key: OODT-460
>                 URL: https://issues.apache.org/jira/browse/OODT-460
>             Project: OODT
>          Issue Type: Bug
>          Components: file manager
>    Affects Versions: 0.3
>         Environment: none
>            Reporter: Brian Foster
>            Assignee: Tom Barber
>             Fix For: 0.7
>
>
> It appears when support was added for BooleanQueries we lost support with MySQL.
> Either a INTERSECT substitute which is supported across the board can be used or maybe just turn DataSourceCatalog into OracleDataSourceCatalog and then create a MySqlDataSourceCatalog (this way each can be further customized to use custom statements for each to gain speed improvements)... then possible find some happy medium command for INTERSECT and have DataSourceCatalog use that -- in other words, this issue will split DataSourceCatalog into 3 classes:
> DataSourceCatalog : generic data source catalog (not neccessarily fast or pretty, but works for all SQL DBs)
> OracleDataSourceCatalog : customized for speed and use with Oracle specifically
> MySqlDataSourceCatalog : customized for speed and use with MySQL specifically 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira