<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Datetime fields causing error message "the data content could not be loaded" with MySQL Connector/J 8.0.11 or 8.0.12"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=120091#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Datetime fields causing error message "the data content could not be loaded" with MySQL Connector/J 8.0.11 or 8.0.12"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=120091">bug 120091</a>
from <span class="vcard"><a class="email" href="mailto:iplaw67@tuta.io" title="Alex Thurgood <iplaw67@tuta.io>"> <span class="fn">Alex Thurgood</span></a>
</span></b>
<pre>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))</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>