MySQL Bugs: #40860: funcs_1.ndb

Bug #40860	funcs_1.ndb_views fail
Submitted:	19 Nov 2008 16:56	Modified:	25 Feb 2009 19:12
Reporter:	Tomas Ulin	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S3 (Non-critical)
Version:	6.2	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
funcs_1.ndb_views              [ fail ]

--- /home/tomas/mysql_src/mysql-5.1-telco-6.2-merge/mysql-test/suite/funcs_1/r/ndb_views.result 2008-08-29 15:26:22 +03:00
+++ /home/tomas/mysql_src/mysql-5.1-telco-6.2-merge/mysql-test/suite/funcs_1/r/ndb_views.reject 2008-11-19 18:53:51 +03:00
@@ -21567,7 +21567,8 @@
 v28    CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `test1`.`v28` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test3`.`t1` `tab1` join `test1`.`v27` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`))))  latin1  latin1_swedish_ci
 SELECT CAST(f1 AS SIGNED INTEGER) AS f1,
 CAST(f2 AS CHAR) AS f2 FROM test1.v28;
-ERROR HY000: Got temporary error 4006 'Connect failure - out of connection objects (increase MaxNoOfConcurrentTransactions)' from NDBCLUSTER
+f1     f2
+5      five

How to repeat:
.

new testcase, create view fails with out of resouce
E3: for finding out what is it...tomas tried and failed

http://bugs.mysql.com/bug.php?id=39125

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/67604

2884 Jonathan.Miller@sun.com	2009-02-25
      Bug#39125 and Bug#40860 show that the results had been orginally created with a resource issue. This should have been addressed by the creator before check in. Nonetheless, the results now do not contain the error and the test is currently passing for me. Commenting out the entry in disable.def. If problem is seen again, please reopen Bug#39125
      modified:
        mysql-test/suite/funcs_1/t/disabled.def