ok. I changed the query a bit so the results are easier to compare: When the bug appears, most rows in the result set of the following query contain NULL as a value, and we have 369 rows.
If I insert the dummy entry in the table plib_objects_plib_objects_dbo_temp, then the bug disappears and now all rows contain numbers (There is not a single NULL row). We also have more rows (430). The test was done with the following query: SELECT shop_element_oid FROM ((`plib_objects_plib_objects_dbo` a20_1_dbo, ((`plib_objects_at_telacc_demopool_shops_product` a20_1_product) LEFT JOIN ((`plib_objects_at_telacc_demopool_shops_product_distributor` a20_1_distributor) ) ON a20_1_distributor.part_nr = a20_1_product.part_nr), (`plib_objects_at_telacc_demopool_shops_shop_element` a20_1_shop_element) ) LEFT JOIN ((`plib_objects_plib_objects_dbo` a21_1_dbo, (`plib_objects_plib_objects_dbo_type` a21_1_dbo_type) ) ) ON a21_1_dbo_type.oid = a21_1_dbo.oid AND a20_1_dbo.type_oid = a21_1_dbo.oid LEFT JOIN ((`plib_objects_plib_objects_dbo` a23_1_dbo, (`plib_objects_at_telacc_demopool_shops_shop_element` a23_1_shop_element) , (`plib_objects_at_telacc_demopool_shops_category` a23_1_shop_category) ) LEFT JOIN ((`plib_objects__telacc_demopool_shops_category__shop_element` a23_1_children) ) ON a23_1_children.oid = a23_1_dbo.oid) ON a23_1_shop_element.oid = a23_1_dbo.oid AND a23_1_shop_category.oid = a23_1_dbo.oid AND a20_1_dbo.oid = a23_1_children.shop_element_oid LEFT JOIN ((`plib_objects_plib_objects_dbo_temp` a20_1_temp) ) ON a20_1_temp.oid = a20_1_dbo.oid ) LEFT JOIN ((`plib_objects_at_telacc_demopool_shops_shop_element__shop` a20_1_shops) LEFT JOIN ((`plib_objects_plib_objects_dbo` a22_1_dbo, (`plib_objects_at_telacc_demopool_shops_shop` a22_1_shop) ) ) ON ((a20_1_shops.flags & 4) = 4) AND a22_1_shop.oid = a22_1_dbo.oid AND a20_1_shops.shop_oid = a22_1_dbo.oid) ON a20_1_shops.oid = a20_1_dbo.oid WHERE a20_1_product.oid = a20_1_dbo.oid AND a20_1_shop_element.oid = a20_1_dbo.oid -- mysql queries "lose" results https://bugs.launchpad.net/bugs/352321 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
