db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Fischer (JIRA)" <j...@apache.org>
Subject [jira] Commented: (TORQUE-65) Test Project Testcase: DataTest.testSubqueries fails with MySQL 4.0
Date Sat, 11 Nov 2006 12:11:38 GMT
    [ http://issues.apache.org/jira/browse/TORQUE-65?page=comments#action_12448966 ] 
            
Thomas Fischer commented on TORQUE-65:
--------------------------------------

This is a known issue (hm, probably only known to me :-( )
The best thing to do in the test would be to ask mysql whether it is mysql4 or mysql5. According
to the docs, this should be possible by issuing the sql command
show variables like "version";
If it is mysql4 and the test fails, print an error. If its mysql5 and the test fails, fail.

In my opionion, there is no need to ask the DB adaptor whether subselects are supported. If
they are not supported, an error will be thrown no matter whether the adaptor knows whether
the db supports subselects or not (in the first case, the error would be thrown by torque's
sql generation process, in the latter case, it will be thrown by the database). So this does
not make any difference to the user.

> Test Project Testcase: DataTest.testSubqueries fails with MySQL 4.0
> -------------------------------------------------------------------
>
>                 Key: TORQUE-65
>                 URL: http://issues.apache.org/jira/browse/TORQUE-65
>             Project: Torque
>          Issue Type: Bug
>          Components: Test Project
>    Affects Versions: 3.2.1
>            Reporter: CG Monroe
>            Priority: Minor
>
> MySQL 4.0 does not support subselect (and some other Torque supported DBs).  But the
testSubqueries testcase uses them.  This should not be an error or failure condition.  
> Should this just catch exceptions and print a warning or does there need to be a "support
subselects" option on DBAdaptors (and MySQL 4.0 / 5.0 adaptor)?

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message