Mercurial > hg > dbutils / file diff

--- a/test/main.c	Fri Jan 03 21:40:57 2025 +0100
+++ b/test/main.c	Sat Jan 04 13:03:01 2025 +0100
@@ -159,7 +159,7 @@
     dbuQuerySetSQL(roleQuery, "select * from role;");
     
     DBUQuery *query2 = conn->createQuery(conn, NULL);
-    dbuQuerySetSQL(query2, "select p.*, a.address_id as [__address__address_id], a.street, a.zip, a.city, r.role_id as [__role__role_id], r.person_id, r.name from Person p inner join Address a on p.address_id = a.address_id left join Role r on p.person_id = r.person_id;");
+    dbuQuerySetSQL(query2, "select p.*, a.address_id as [__address__address_id], a.street, a.zip, a.city, r.role_id as [__role__role_id], r.person_id, r.name from Person p inner join Address a on p.address_id = a.address_id left join Role r on p.person_id = r.person_id order by p.person_id, r.role_id;");
     
     DBUObjectBuilder *builder = dbuObjectBuilder(person, query2, cxDefaultAllocator);
     dbuObjectBuilderSetDenseResult(builder, true);