Query profile info shows 999,999999s

Hi,

I got the value "999,999999s" for the query operation "Copying to tmp table" while running a long query (49 minutes according to HeidiSQL's console, 1002 seconds according to the profile info). Is this a MariaDB or a HeidiSQL bug ?

I'm running HeidiSQL 9.3.0.4984 with MariaDB 10.0.25.

Could be both. Probably in HeidiSQL due to a data type which is not capable of using numbers over 1000. I can check that.

Does not seem to be the case. I could just use hardcoded numbers over 1000 and these were displayed correctly there. So, I guess this is a limitation in MySQL?