Bug 298 : ORDER BY I.NULL[*] "; expected "identifier"; .... when orderBy a complex object
Priority 
High
Reported Version 
 
Logged By 
Rob
Status 
Fixed
Fixed Version 
2.7.0
Assigned To 
 
Product 
Ebean - core
Duplicate Of 
 
Created 
20/05/2010
Updated 
20/05/2010
Type 
Bug
 
Attachments 
No attachments
public void testFindAndOrderByEType() {
        List<Item> items = getServer().find(Item.class).order("eType").findList();

        assertNotNull(items);
        assertEquals(2, items.size());
    }

javax.persistence.PersistenceException: Query threw SQLException:Syntax error in SQL statement

"SELECT I.CUSTOMER C0, I.ITEMNUMBER C1, I.DESCRIPTION C2, I.UNITS C3, I.TYPE C4, I.REGION C5, I.VERSION C6, I.DATE_MODIFIED C7, I.DATE_CREATED C8, I.MODIFIED_BY C9, I.CREATED_BY C10, I.CUSTOMER C11, I.TYPE C12, I.CUSTOMER C13, I.REGION C14
FROM ITEM I
ORDER BY I.NULL[*] "; expected "identifier";

 
Rob 20 May 10:47
Fixed in HEAD

Fixed in HEAD.

order by clause ... parsing now handles complex objects using IdBinder.

woResponse

Upload a file