#1412 (ok 4.1) Creating a view from an empty set of results

[Victor Porton]

phpMyAdmin does not allow to create a view from a query which has returned an empty set of results.

It is a bug. I should be able to create a view even when my tables are yet empty without the need to add some testing data into my tables.

[Marc Delisle]

Bug: something the software is supposed to do but does badly

Missing feature: something you wish the software would do

Moving to feature requests

[Marc Delisle]

Ticket moved from /p/phpmyadmin/bugs/3844/

[Jaroslav Minarik]

Hey,
I'm a student at CTU Prague, attending "Open source programming" class where as a project we have to participate in some open source project. Do you think I could take this on?

[Marc Delisle]

Jaroslav,
sure, give it a try!

[Jaroslav Minarik]

Thanks!
This feature request has it's milestone set to "Needs_planning". My question therefore is, what version should I implement this in.
Thanks again.

[Marc Delisle]

Use the "master" branch.

[Jaroslav Minarik]

So I gave it a try:
https://github.com/phpmyadmin/phpmyadmin/pull/226

If the given solution is somehow against phpmyadmin code style or philosophy, we can review it together and I can give it necessary tweaks.

[Marc Delisle]

See also https://github.com/phpmyadmin/phpmyadmin/pull/285

[Isaac Bennetch]

Fixed with https://github.com/phpmyadmin/phpmyadmin/pull/287. This will be part of the 4.1 release. Thanks for reporting.