https://bugs.freedesktop.org/show_bug.cgi?id=62645
--- Comment #1 from Alex Thurgood <[email protected]> --- In comparison, the following view does not cause an error : DROP VIEW IF EXISTS `prio_ddl`; CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`alex`@`%` SQL SECURITY DEFINER VIEW `prio_ddl` AS select `oldfmpro`.`fmpro_id` AS `fmpro_id`,`oldfmpro`.`Client` AS `Client`,concat(`oldfmpro`.`Client_Copy`,`oldfmpro`.`File_Code`,`oldfmpro`.`File_Num`,`oldfmpro`.`Ctry_Short`) AS `N_ref`,`oldfmpro`.`Filing_Num` AS `Filing_num`,`oldfmpro`.`Filing_Date1` AS `Filing_date1`,(`oldfmpro`.`Filing_Date1` + interval 1 year) AS `DDL_EXT`,`oldfmpro`.`Comments` AS `Comments`,`oldfmpro`.`Summary` AS `Summary` from `oldfmpro` where ((`oldfmpro`.`Filing_Date1` > (curdate() + interval -(1) year)) and isnull(`oldfmpro`.`Prio_FF_Date1`) and (`oldfmpro`.`File_Code` = 'P')) order by `oldfmpro`.`Filing_Date1`; -- 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
