[ http://jira.jboss.com/jira/browse/JBAS-14?page=comments#action_12310868 ] Alex Loubyansky commented on JBAS-14: -------------------------------------
These tests are bad as they report failures when generated queries are in fact correct from the data fetching point of view. The problem is that you can't predict the exact order of a sequence of conjunctions/disjunctions in the WHERE clause, tables in the FROM clause, etc. So, in general, if these tests pass it's a luck. > CompleteUnitTestCase fails under java5 > -------------------------------------- > > Key: JBAS-14 > URL: http://jira.jboss.com/jira/browse/JBAS-14 > Project: JBoss Application Server > Type: Bug > Versions: JBossAS-4.0.1 Final > Environment: 13:35:08,406 INFO [Server] Starting JBoss (MX MicroKernel)... > 13:35:08,406 INFO [Server] Release ID: JBoss [Zion] 4.0.1RC2 (build: > CVSTag=Branch_4_0 date=200411271821) > 13:35:08,406 INFO [Server] Home Dir: > C:\cvs\JBoss4.0\jboss-4.0\build\output\jboss-4.0.1RC2 > 13:35:08,406 INFO [Server] Home URL: > file:/C:/cvs/JBoss4.0/jboss-4.0/build/output/jboss-4.0.1RC2/ > 13:35:08,406 INFO [Server] Library URL: > file:/C:/cvs/JBoss4.0/jboss-4.0/build/output/jboss-4.0.1RC2/lib/ > 13:35:08,406 INFO [Server] Patch URL: null > 13:35:08,406 INFO [Server] Server Name: all > 13:35:08,406 INFO [Server] Server Home Dir: > C:\cvs\JBoss4.0\jboss-4.0\build\output\jboss-4.0.1RC2\server\all > 13:35:08,421 INFO [Server] Server Home URL: > file:/C:/cvs/JBoss4.0/jboss-4.0/build/output/jboss-4.0.1RC2/server/all/ > 13:35:08,421 INFO [Server] Server Data Dir: > C:\cvs\JBoss4.0\jboss-4.0\build\output\jboss-4.0.1RC2\server\all\data > 13:35:08,421 INFO [Server] Server Temp Dir: > C:\cvs\JBoss4.0\jboss-4.0\build\output\jboss-4.0.1RC2\server\all\tmp > 13:35:08,421 INFO [Server] Server Config URL: > file:/C:/cvs/JBoss4.0/jboss-4.0/build/output/jboss-4.0.1RC2/server/all/conf/ > 13:35:08,421 INFO [Server] Server Library URL: > file:/C:/cvs/JBoss4.0/jboss-4.0/build/output/jboss-4.0.1RC2/server/all/lib/ > 13:35:08,421 INFO [Server] Root Deployment Filename: jboss-service.xml > 13:35:08,421 INFO [Server] Starting General Purpose Architecture (GPA)... > 13:35:08,937 INFO [ServerInfo] Java version: 1.5.0,Sun Microsystems Inc. > 13:35:08,937 INFO [ServerInfo] Java VM: Java HotSpot(TM) Server VM > 1.5.0-b64,Sun Microsystems Inc. > 13:35:08,937 INFO [ServerInfo] OS-System: Windows XP 5.1,x86 > Reporter: Scott M Stark > Assignee: Alex Loubyansky > > > When running the org.jboss.test.cmp2.commerce.CompleteUnitTestCase test under > java5 there are two failures related to query expecation failures: > Suite: org.jboss.test.cmp2.commerce.CompleteUnitTestCase > Test: testJBossQL > Type: failure > Exception: net.sourceforge.junitejb.RemoteAssertionFailedError > Message: Expected: SELECT t0_o1.ORDER_NUMBER FROM ORDER_DATA t0_o1, > ORDER_DATA t3_o2, CUSTOMEREJB t1_o1_customer, CUSTOMEREJB t2_o2_customer > WHERE (( NOT (t1_o1_customer.id=t2_o2_customer.id)) AND > (t0_o1.CC_TYPE=t3_o2.CC_TYPE AND t0_o1.CC_FIRST_NAME=t3_o2.CC_FIRST_NAME AND > t0_o1.CC_MI=t3_o2.CC_MI AND t0_o1.CC_LAST_NAME=t3_o2.CC_LAST_NAME AND > t0_o1.CC_BILLING_ZIP=t3_o2.CC_BILLING_ZIP AND > t0_o1.CC_CARD_NUMBER=t3_o2.CC_CARD_NUMBER) AND > t0_o1.customer=t1_o1_customer.id AND t3_o2.customer=t2_o2_customer.id) but > got: SELECT t0_o1.ORDER_NUMBER FROM ORDER_DATA t0_o1, ORDER_DATA t3_o2, > CUSTOMEREJB t2_o2_customer, CUSTOMEREJB t1_o1_customer WHERE (( NOT > (t1_o1_customer.id=t2_o2_customer.id)) AND (t0_o1.CC_TYPE=t3_o2.CC_TYPE AND > t0_o1.CC_FIRST_NAME=t3_o2.CC_FIRST_NAME AND t0_o1.CC_MI=t3_o2.CC_MI AND > t0_o1.CC_LAST_NAME=t3_o2.CC_LAST_NAME AND > t0_o1.CC_BILLING_ZIP=t3_o2.CC_BILLING_ZIP AND > t0_o1.CC_CARD_NUMBER=t3_o2.CC_CARD_NUMBER) AND > t3_o2.customer=t2_o2_customer.id AND t0_o1.customer=t1_o1_customer.id) > --------------------------------- > Suite: org.jboss.test.cmp2.commerce.CompleteUnitTestCase > Test: testEJBQL > Type: failure > Exception: net.sourceforge.junitejb.RemoteAssertionFailedError > Message: expected:<...0_o.ORDER_NUMBER=t4_l.ORDER_NUMBER AND > t6_l_product.id=t5_l_product_productCategories_R.PRODUCT_ID AND > t1_pc.id=t5_l_product_productCategories_R.PRODUCT_CATEGORY_ID AND > t1_pc.subId=t5_l_product_productCategories_R.PRODUCT_CATEGORY_SUBID AND > t4_l.product=t6_l_product.id> but > was:<...6_l_product.id=t5_l_product_productCategories_R.PRODUCT_ID AND > t1_pc.id=t5_l_product_productCategories_R.PRODUCT_CATEGORY_ID AND > t1_pc.subId=t5_l_product_productCategories_R.PRODUCT_CATEGORY_SUBID AND > t4_l.product=t6_l_product.id AND t0_o.ORDER_NUMBER=t4_l.ORDER_NUMBER> > --------------------------------- -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
