The expected result is to return a value with 6 fractional digits without errors.
A "truncated" warning (or a note) is probably not necessary,
because decimal numbers do not produce warnings/notes when precision is too high.
The problem is repeatable even when 0 nanoseconds present:
This is a bug in
MDEV-3838, should be fixed before the release.