List:Commits« Previous MessageNext Message »
From:Luis Soares Date:July 21 2011 4:01pm
Subject:bzr push into mysql-trunk branch (luis.soares:3256 to 3257)
View as plain text  
 3257 Luis Soares	2011-07-21
      Fixed VERSION file to have as the extra field:

 3256 Jon Olav Hauglid	2011-07-13
      Bug #11757397 49437: CANNOT DO SHOW FIELDS FOR BIG VIEW
      The problem was that views with too many columns in some
      cases would appear to work correctly, while in other cases gave
      various error messages. For example, DESCRIBE and SHOW commands
      could give "Incorrect key file for table..." errors.
      Depending on column datatypes used, views are materialized
      as either MyISAM or Memory internal temporary tables.
      The root cause of the problem was that MyISAM tables support
      a limited number of columns. This is due too a 64K file header
      size limitation. This limitation was not checked by CREATE VIEW.
      Therefore views with unsupported sizes could be made, leading to
      various errors when the view was later used.
      This patch fixes the problem by reporting ER_TOO_MANY_FIELDS
      error ("Too many columns") if views with more than 4096 columns
      are created. Thus ensuring that any MyISAM table which might
      be created for view processing will fit into the 64K header limit.
      Note that 4096 was chosen as limit as this number is already the
      limit on the number of columns for base tables.
      Test case added to view.test.

=== modified file 'VERSION'
--- a/VERSION	2011-07-07 09:45:10 +0000
+++ b/VERSION	2011-07-21 16:00:22 +0000
@@ -1,4 +1,4 @@

No bundle (reason: useless for push emails).
bzr push into mysql-trunk branch (luis.soares:3256 to 3257) Luis Soares21 Jul