[Libreoffice-bugs] [Bug 120091] Datetime fields causing error message "the data content could not be loaded" with MySQL Connector/J 8.0.11 or 8.0.12

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=120091

--- Comment #4 from Alex Thurgood <iplaw67 at tuta.io> ---
I also see this same error message with server side views containing calculated
dates such as this one :

CREATE VIEW `natpha_ddl` AS 
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`,
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 `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))

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180924/0fba5c55/attachment.html>