Missing padding

[OlafvdSpek]

[akshilshah]

Hi, can you send the more details? like which system, browser, phpmyadmin version.

[OlafvdSpek]

Chrome, pMA git

[williamdes]

@OlafvdSpek Can you send more detailed information to reproduce ?

[OlafvdSpek]

What info is missing?

[williamdes]

@OlafvdSpek The query ?

[OlafvdSpek]

I doubt it's query-specific.

[williamdes]

@OlafvdSpek Can you please send a way to reproduce this issue ?

[williamdes]

This issue exists !
Run the following query:

use mysql;
SELECT `Host`, `User`, `Host` a, `Host` ddddddddddddddddddcddddddddddddddddddddddddb, `Host` cdddddddddddddddddcddddddddddddddddd, `Host` ddddddddddddddddddd, `Host` ddddddddddddddddddddde, `Host` ddddddddddddddddcddddddddddddddddddddddddddf, `Host` gzzzzzzzzzzzzcdddddddddddddddddzzzzzzzzzzzzzzzzzzz, `Host` gzzzzzzzdzzzzzcdddddddddddddddddzzzzzzzzzzzzzzzzzzz, `Host` gzzzzzzzzzzzzcdddddddddddddddddzzzzzzzszzzzzzzzzzzz, `Host` gzzzzzzzzfzzzzcdddddddddddddddddzzzzzzzezzzzzzzzzzzz, `Host` gzzzzzzzzzezzzcdddddddddddddddddzzzzzzzzzzzzzzzzzzz, `Host` gzzzzzzzzzzzzcdddddddddddddddddzzzzzzzzzzzzzfzzzzzz, `Host` gzzzzzzzzzzzzcdddddddddddddddddzzzzzzzzzzzzzzzzzzz, `Host` gzzzzzzzzzzzzcddddddfdddddddddddzzzzzzzzzzzzzzzzzzz, `Host` gzzzzzzzzzzzzcdddddddddddddddddzzzzzzzzzzzzfzzzzzzz,  `Host` gzzzzzzzzzzzzzzzzzzzzzzzzzzcdddddddddddddddddzzzzzzzzzzzzzzzzzzz,  `Host` gzzzzzzzzzzzzzzzzzzzzzzzzzzcdddddddddddddddddzzzzzzzzzzzzzzzzzzzz,  `Host` gzzzzzzzzzzazzzzzzzzzzzzzzcdddddddddddddddddzzzzzzzzzzzzzzzzzzz FROM `user` WHERE 1

This issue affects very long queries.

[beekalam]

@williamdes
In
import.php

there's

// (but if the query is too large, in case of an imported file, the parser
//  can choke on it so avoid parsing)
$sqlLength = mb_strlen($sql_query);
if ($sqlLength <= $GLOBALS['cfg']['MaxCharactersInDisplayedSQL']) {
   .........
}

if the query is bigger than 1000 characters long then it won't be parsed(or beautified).
is the issue about the query not being beautified or that it is not completely shown.
I am not sure what the issue is exactly?

[williamdes]

@beekalam Thank you for the research, can you create a pull-request if you know how to fix this issue ?
The issue is not having the beautifier and the padding is missing.
PS: I updated the query to have a better test sample.

Screenshot

[williamdes]

Still on 4.8.5

[khaydarov]

@williamdes
I wanted to start with this issue, but for me it is ok. Using 4.8.5