Bug #35722 Blackhole field flag

• Submitted: 31 Mar 2008 21:59
• Modified: 1 Apr 2008 13:34
• Reporter: Olaf van der Spek (Basic Quality Contributor)
• Status: Verified
• Category: MySQL Server: General
• Severity: S4 (Feature request)
• Version: *
• OS: Any
• CPU Architecture: Any
• Tags: qc

[31 Mar 2008 21:59] Olaf van der Spek

Description:
Hi,

Could you add a blackhole field flag? When set, the field will always return the default value and not take up any storage space.
This is useful if you like to remove a field from a table, but you can't or don't want to update all queries that use it.

How to repeat:
-

[1 Apr 2008 13:34] Valeriy Kravchuk

Thank you for a reasonable feature request.

[5 Oct 2008 12:08] Konstantin Osipov

Why not use updatable views?