This works well in version 1.3.159 SELECT t0.id, t0.name, t0.tarification_type, t0.fixed_price, t0.price_unlicenced, t0.price_licenced, t0.periodicity, null, 0, 0 FROM usr_item t0 JOIN usr_item_type t1 ON t1.id = t0.item_type_id
UNION SELECT t0.id, t0.name, t0.tarification_type, t0.fixed_price, t0.price_unlicenced, t0.price_licenced, t0.periodicity, null, percent, discount FROM usr_item t0 JOIN usr_item_type t1 ON t1.id = t0.item_type_id JOIN usr_member_subscription t2 ON t2.item_id = t0.id UNION SELECT t0.id, t2.name, t0.tarification_type, t0.fixed_price, t0.price_unlicenced, t0.price_licenced, t0.periodicity, t3.id registration_id, t3.discount, t3.discount_amount FROM usr_item t0 JOIN usr_item_type t1 ON t1.id = t0.item_type_id AND t0.periodicity = 3 JOIN usr_lesson_group t2 ON t2.item_id = t0.id JOIN usr_registration t3 ON t3.lesson_group_id = t2.id JOIN usr_registration_status t4 ON t4.id = t3.status_id ORDER BY t0.periodicity, t0.name But from version version 1.3.160 I have : General error: "java.lang.NullPointerException" [50000-161] HY000/50000 I changed my query to : SELECT t0.id, t0.name, t0.tarification_type, t0.fixed_price, t0.price_unlicenced, t0.price_licenced, t0.periodicity, null, 0 discount, 0 discount_amount FROM usr_item t0 JOIN usr_item_type t1 ON t1.id = t0.item_type_id UNION SELECT t0.id, t0.name, t0.tarification_type, t0.fixed_price, t0.price_unlicenced, t0.price_licenced, t0.periodicity, null, percent, discount FROM usr_item t0 JOIN usr_item_type t1 ON t1.id = t0.item_type_id JOIN usr_member_subscription t2 ON t2.item_id = t0.id UNION SELECT t0.id, t2.name, t0.tarification_type, t0.fixed_price, t0.price_unlicenced, t0.price_licenced, t0.periodicity, t3.id registration_id, t3.discount, t3.discount_amount FROM usr_item t0 JOIN usr_item_type t1 ON t1.id = t0.item_type_id AND t0.periodicity = 3 JOIN usr_lesson_group t2 ON t2.item_id = t0.id JOIN usr_registration t3 ON t3.lesson_group_id = t2.id JOIN usr_registration_status t4 ON t4.id = t3.status_id ORDER BY periodicity, name And it Works again. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
