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 tf...@apache.org on 2005/02/08 11:12:19 UTC
cvs commit: db-torque/src/rttest/org/apache/torque DocsTest.java
tfischer 2005/02/08 02:12:19
Modified: src/rttest/org/apache/torque DocsTest.java
Log:
use lower case for table names, because mysql is treating column names in a case sensitive way
Revision Changes Path
1.3 +6 -6 db-torque/src/rttest/org/apache/torque/DocsTest.java
Index: DocsTest.java
===================================================================
RCS file: /home/cvs/db-torque/src/rttest/org/apache/torque/DocsTest.java,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- DocsTest.java 31 Jan 2005 19:43:58 -0000 1.2
+++ DocsTest.java 8 Feb 2005 10:12:19 -0000 1.3
@@ -217,9 +217,9 @@
try
{
result = BasePeer.executeQuery(
- "SELECT BOOK.* FROM BOOK "
- + "INNER JOIN AUTHOR "
- + "ON BOOK.AUTHOR_ID=AUTHOR.AUTHOR_ID");
+ "SELECT book.* FROM book "
+ + "INNER JOIN author "
+ + "ON book.AUTHOR_ID=author.AUTHOR_ID");
}
catch (Exception e)
{
@@ -238,8 +238,8 @@
try
{
result = BasePeer.executeQuery(
- "SELECT BOOK.* FROM BOOK,AUTHOR "
- + "WHERE BOOK.AUTHOR_ID=AUTHOR.AUTHOR_ID");
+ "SELECT book.* FROM book,author "
+ + "WHERE book.AUTHOR_ID=author.AUTHOR_ID");
}
catch (Exception e)
{
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org