[phpMyAdmin Developers] [BUG REPORT]: profiling not working & cut of errors

[Michal Čihař]

Hi

Dne 8.6.2016 v 02:35 Alec Teal napsal(a):
> Hello there,
> 
> I've had a few problems with PMA (I'm trying to migrate from the
> 7-year-deprecated mysql gui tools I still run via Wine, am I alone in
> this?) and I've found a bug, and a minor bug.

Can you please use issue tracker for reporting bugs? Things on mailing
list are easy to forget when not handled immediately.

> First, if you profile a select that uses a user-defined function, no
> profiling result is shown, there's no error or warning either, nothing.
> Just the result set.
> 
> That's the bug.

I've reported it: https://github.com/phpmyadmin/phpmyadmin/issues/12313

It would be great if you could add query example there.

> Second, when designing the user defined function that has the power to
> disable profiles I'd get quite a long error report if the syntax was
> wrong, something like:
> 
> "Error in statement (ENTIRE BODY OF QUERY) at or around (bit that
> actually went wrong)"
>
> I had to use a mix of zoom and responsive design view to actually get to
> read the bit I wanted.
> 
> If you could make the error box wider, or show the useful bit of
> information, that'd be great.

Reported as https://github.com/phpmyadmin/phpmyadmin/issues/12314

> While I am here, I'd really love an "explain extended" option next to
> explain, and also there's a new JSON format, it'd be really good if you
> guys allowed fields to be of a JSON type (so you can collapse and expand
> lists, items of lists) - you wouldn't need to interpret the actual
> explain format to make this useful as it's pretty self descriptive.

The JSON fields should be supported, though there is no nice
manipulation available for these...

-- 
	Michal Čihař | http://cihar.com/ | https://weblate.org/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
URL: <https://lists.phpmyadmin.net/pipermail/developers/attachments/20160610/321ee8f5/attachment.sig>