http://nagoya.apache.org/bugzilla/show_bug.cgi?id=1735 *** shadow/1735 Sun May 13 19:08:24 2001 --- shadow/1735.tmp.12734 Sun May 13 19:08:24 2001 *************** *** 0 **** --- 1,46 ---- + +============================================================================+ + | LIMIT clause is missed in MySQL query | + +----------------------------------------------------------------------------+ + | Bug #: 1735 Product: Turbine | + | Status: NEW Version: 2.1b1 | + | Resolution: Platform: PC | + | Severity: Major OS/Version: Linux | + | Priority: High Component: Source | + +----------------------------------------------------------------------------+ + | Assigned To: [EMAIL PROTECTED] | + | Reported By: [EMAIL PROTECTED] | + | CC list: Cc: | + +----------------------------------------------------------------------------+ + | URL: | + +============================================================================+ + | DESCRIPTION | + When I called criteria.setOffset() & criteria.setLimit() method in + Index.java in generated turbine app, + I found a bug that LIMIT clause is missed in MySQL query. + + 1) generate turbine peer application + 2) add criteria.setOffset(), criteria.setLimit() method in Index.java + + Here is a result of criteria.toString(). + + Current SQL: SELECT ADDRBOOK.UID, ADDRBOOK.USERID, + ...(omitted)... + FROM ADDRBOOK WHERE (ADDRBOOK.USERID = 'turbine') LIMIT 20, 10 + + Here is a part of mysql log. + As you can see, LIMIT clause is missed. + + SELECT ADDRBOOK.UID, ADDRBOOK.USERID + ...(omitted)... + FROM ADDRBOOK WHERE (ADDRBOOK.USERID = 'turbine') + + I found this bug while upgrading from tdk-1.1a11 to tdk-1.1a13. + This bug is not exist in tdk-1.1a11. + I'm using tdk-1.1a13 and update only turbine.jar from CVS, but this + problem still exists. + + This is my environment. + $ mysql --version + mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) + $ uname -a + Linux archon 2.2.14-5.0 #1 Tue Mar 7 21:07:39 EST 2000 i686 unknown --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
