MySQL Bugs: #36721: Test funcs1.<engine>_func_view failing for multiple engines

Bug #36721	Test funcs1.<engine>_func_view failing for multiple engines
Submitted:	14 May 2008 18:20	Modified:	28 Jul 2008 14:46
Reporter:	Patrick Crews	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Tests	Severity:	S3 (Non-critical)
Version:	5.1	OS:	Any
Assigned to:	Patrick Crews	CPU Architecture:	Any
Tags:	funcs_1, show create view, test

Description:
The test funcs_1.<engine>_func_view is failing for myisam, memory, and innodb.

The results returned include character set and collation data that aren't listed in the expected results.

The test is fine in 5.0, appears to be a problem in 5.1+

 SHOW CREATE VIEW v1;
-View	Create View
-v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select sqrt(`t1_values`.`my_bigint`) AS `sqrt(my_bigint)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values`
+View	Create View	character_set_client	collation_connection
+v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select sqrt(`t1_values`.`my_bigint`) AS `sqrt(my_bigint)`,`t1_values`.`my_bigint` AS `my_bigint`,`t1_values`.`id` AS `id` from `t1_values`	latin1	latin1_swedish_ci

How to repeat:
Run the test against the latest version of 5.1

./mysql-test-run --suite=funcs_1 --do-test func_view

Suggested fix:
Re-record the .results file for the affected engines to accurately reflect server output.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/46731

ChangeSet@1.2640, 2008-05-15 11:35:01-04:00, pcrews@pcrews-mac-local.local +14 -0
  Bug#36721 - Test funcs_1.<engine>_func_view failing for multiple engines
  Bug#36724 - Test funcs_1.<engine>_storedproc_02 needs to be updated
  Bug#36726 - Test funcs_1.<engine>_storedproc failing - Needs to be updated on 5.1+
  
  Altered tests and re-recorded .results files to account for changes
  made from 5.0 to 5.1+ (inclusion of data in 
  SHOW CREATE VIEW results, illegal SQLSTATE '00000')

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/46738

ChangeSet@1.2640, 2008-05-15 12:44:25-04:00, pcrews@pcrews-mac-local.local +13 -0
  Bug#36721 - Test funcs_1.<engine>_func_view failing for multiple engines
  Bug#36724 - Test funcs_1.<engine>_storedproc_02 needs to be updated
  Bug#36726 - Test funcs_1.<engine>_storedproc failing - Needs to be updated on 5.1+
  
  Altered tests and re-recorded .results files to account for changes
  made from 5.0 to 5.1+ (inclusion of data in 
  SHOW CREATE VIEW results, illegal SQLSTATE '00000')

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/46813

ChangeSet@1.2653, 2008-05-18 18:32:34-04:00, pcrews@pcrews-mac-local.local +9 -0
  Bug#36721 - Test funcs_1.<engine>_func_view failing for multiple engines
  Bug#36724 - Test funcs_1.<engine>_storedproc_02 needs to be updated
  Bug#36726 - Test funcs_1.<engine>_storedproc failing - Needs to be updated on 5.1+
  
  Needed to revise my patch from 5.1 to account for addition of falcon engine, as well as other 5.1 -> 6.0 changes.

Pushed into 5.1.28 and 6.0.7-alpha

Test case changes. No changelog entry needed.

Pushed into 5.1.27  (revid:joerg@mysql.com-20080626161101-h5hsaluwtf05xdr2) (version source revid:joerg@mysql.com-20080626161101-h5hsaluwtf05xdr2) (pib:3)