https://bugs.freedesktop.org/show_bug.cgi?id=62645
--- Comment #12 from Alex Thurgood <[email protected]> --- If I run the SQL statement as a query from within the Query section of LO (Query in SQL View), I get the same error. If I remove : if(((`oldfmpro`.`Prio_FF_Date1` + interval 30 month) is not null),(`oldfmpro`.`Prio_FF_Date1` + interval 30 month),(`oldfmpro`.`Filing_Date1` + interval 30 month)) AS `NATPHA` from the query, then the following query does execute : select `oldfmpro`.`File_Num` AS `file_num`,`oldfmpro`.`Owner1` AS `Owner1`,`oldfmpro`.`Filing_Num` AS `filing_num`,`oldfmpro`.`Filing_Date1` AS `filing_date1`,`oldfmpro`.`Prio_FF_Date1` AS `Prio_FF_Date1` from `oldfmpro` where ((`oldfmpro`.`Filing_Num` is not null) and (`oldfmpro`.`Ctry_Short` = 'WO') and (`oldfmpro`.`IngJur` like '%ajt%') and (`oldfmpro`.`Filing_Date1` >= (curdate() + interval -(30) month))) order by if(((`oldfmpro`.`Prio_FF_Date1` + interval 30 month) is not null),(`oldfmpro`.`Prio_FF_Date1` + interval 30 month),(`oldfmpro`.`Filing_Date1` + interval 30 month)) so, LO will handle the IF condition in my WHERE clause, but not when I put it in my SELECT preamble as well ?? The VIEW used to work prior to LO 4.0. If I look at a blank Query Designer window, after adding the table "oldfmpro", in the list of available functions, I can see only following choices : None count() Any link between this and the inoperate "SELECT...IF" ? Alex -- 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
