Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Query profile info shows 999,999999s

bperel's profile image bperel posted 6 years ago in Running SQL scripts Permalink

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.

1 attachment(s):
  • 2016-05-10_09-11-07
ansgar's profile image ansgar posted 6 years ago Permalink

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

ansgar's profile image ansgar posted 6 years ago Permalink

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?

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.