Bug #48535 please make "show create view" return something humanly readable....

• Submitted: 4 Nov 2009 16:04
• Modified: 4 Nov 2009 16:13
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Duplicate
• Category: MySQL Server: Views
• Severity: S4 (Feature request)
• Version: 5.1.40
• OS: Any
• CPU Architecture: Any

[4 Nov 2009 16:04] Shane Bester

Description:
I'm attaching two files as the description.
1) my perfectly formatted, readable view statement.
2) mysql's unreadable, horribly modified output of show create view.

This is a feature request to:
o) return the original line breaks in the view definition
o) return the original tabs in the view definition
o) not add excessive parenthesis all over the show

A similar complaint was made about show create table and partitioning, and that was fixed.

How to repeat:
view the before/after versions of the view definition

Suggested fix:
o) return the original line breaks in the view definition
o) return the original tabs in the view definition
o) not add excessive parenthesis all over the show

[4 Nov 2009 16:08] MySQL Verification Team

show create view output

Attachment: bug48535_show_create_view_output.sql (application/unknown, text), 7.71 KiB.

[4 Nov 2009 16:13] MySQL Verification Team

original!

Attachment: bug48535_original_view_definition.sql (application/unknown, text), 13.47 KiB.

[4 Nov 2009 16:13] Valeriy Kravchuk

Essentially, this is a duplicate of bug #5159 or one of its duplicates, like bug #13109.