Please post the rest of the stack trace
On Tuesday, 6 December 2011, iNumerix <[email protected]> wrote: > 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. > > -- 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.
