https://bugs.documentfoundation.org/show_bug.cgi?id=83121
Doug <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |UNCONFIRMED Ever confirmed|1 |0 --- Comment #7 from Doug <[email protected]> --- This continues to be unresolved in Version: 5.0.1.2.0+ Build ID: 00m0(Build:2) Locale: en-US (en_US.UTF-8). Step-by-step to reproduce. 1. Open the sample document, Query 1, in edit mode. 2. Inspect the GUI table relationships part of the window. You will see that the window has basically three columns of tables from left to right. 3. Right mouse click on every relationship to ensure that the relationships are all one-to-many with the 'one' side being the tables on the LEFT graphically (although some are defined by the GUI as 'RIGHT JOIN') and the 'many' side being the tables on the RIGHT. This setup, although complex, is common when using look-up tables. 4. In the course of inspecting, perhaps change one of the relationships to the wrong setting and then change it to the right setting. 5. Execute, save, and close. 6. Even close the whole database. 7. Now reopen. When I do so now, there are two problems. First, at least one of the one-to-many relationships has reversed. Instead of going left-to-right, the relationship is backwards (right-to-left). This breaks the query. Second, I get a new SQL error on the GUI-generated query: SQL Status: 37000 Error code: -16 Wrong data type: java.lang.NumberFormatException: For input string: "samsung" in statement [SELECT "owners"."owners", "owners"."owner_name", "car_key"."car_text", "addr"."addr_text", "clocks_key"."clocks_text", "smartphone_key"."smartphone_key" FROM "owners" LEFT OUTER JOIN "clocks" ON "owners"."owners" = "clocks"."owner_id" RIGHT OUTER JOIN "clocks_key" ON "clocks_key"."clocks_key" = "clocks"."clocks" RIGHT OUTER JOIN "clocks_num_key" ON "clocks_num_key"."id" = "clocks_key"."num_type_code" LEFT OUTER JOIN "cars" ON "owners"."owners" = "cars"."owner_id" RIGHT OUTER JOIN "addr" ON "addr"."addr_key" = "cars"."reg_addr" RIGHT OUTER JOIN "car_key" ON "car_key"."car_key" = "cars"."car" LEFT OUTER JOIN "smartphones" ON "owners"."owners" = "smartphones"."owner_id" RIGHT OUTER JOIN "smartphone_key" ON "smartphone_key"."smartphone_text" = "smartphones"."smartphone_id" ] Still a bug. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
