You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by "CG Monroe (JIRA)" <ji...@apache.org> on 2006/11/10 00:18:37 UTC
[jira] Created: (TORQUE-65) Test Project Testcase:
DataTest.testSubqueries fails with MySQL 4.0
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
[jira] Commented: (TORQUE-65) Test Project Testcase:
DataTest.testSubqueries fails with MySQL 4.0
Posted by "Thomas Fischer (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/TORQUE-65?page=comments#action_12448970 ]
Thomas Fischer commented on TORQUE-65:
--------------------------------------
Just found out that subqueries are supported since mysql 4.1. This is why I did not run into this error any more.
> 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
[jira] Closed: (TORQUE-65) Test Project Testcase:
DataTest.testSubqueries fails with MySQL 4.0
Posted by "Thomas Vandahl (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/TORQUE-65?page=all ]
Thomas Vandahl closed TORQUE-65.
--------------------------------
> 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.3
> Reporter: CG Monroe
> Priority: Minor
> Fix For: 3.3
>
>
> 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
[jira] Resolved: (TORQUE-65) Test Project Testcase:
DataTest.testSubqueries fails with MySQL 4.0
Posted by "Thomas Fischer (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/TORQUE-65?page=all ]
Thomas Fischer resolved TORQUE-65.
----------------------------------
Fix Version/s: 3.3
Resolution: Fixed
Fixed by checking mysql version, if < 4.1, do not test subselects.
> 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.3
> Reporter: CG Monroe
> Priority: Minor
> Fix For: 3.3
>
>
> 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
[jira] Commented: (TORQUE-65) Test Project Testcase:
DataTest.testSubqueries fails with MySQL 4.0
Posted by "Thomas Fischer (JIRA)" <ji...@apache.org>.
[ 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