[prev in list] [next in list] [prev in thread] [next in thread] 

List:       turbine-torque-dev
Subject:    [jira] [Created] (TORQUE-241) qualified table names cause wrong sql to be created
From:       "Thomas Fox (JIRA)" <jira () apache ! org>
Date:       2012-10-29 21:26:12
Message-ID: 1430069522.41008.1351545972888.JavaMail.jiratomcat () arcas
[Download RAW message or body]

Thomas Fox created TORQUE-241:
---------------------------------

             Summary: qualified table names cause wrong sql to be created
                 Key: TORQUE-241
                 URL: https://issues.apache.org/jira/browse/TORQUE-241
             Project: Torque
          Issue Type: Bug
          Components: Runtime
    Affects Versions: 4.0-beta1
            Reporter: Thomas Fox


If I use the table name "bookstore.book" and then try to telete all booksby
        Criteria criteria = new Criteria();
        criteria.where(BookPeer.BOOK_ID, (Long) null, Criteria.NOT_EQUAL);
        BookPeer.doDelete(criteria);
 the generated sql will be
DELETE FROM bookstore.book, book WHERE book.book_id IS NOT NULL
whereas it should be
DELETE FROM bookstore.book WHERE book.book_id IS NOT NULL

Also other places should be checked for similar errors.

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

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


[prev in list] [next in list] [prev in thread] [next in thread]