Hi,<br><br>My application was generating an sql statement that contained a subquery error (the third one listed on <a href="http://dev.mysql.com/doc/refman/5.0/en/subquery-errors.html">http://dev.mysql.com/doc/refman/5.0/en/subquery-errors.html</a>.) Executing the statement at the mysql command line revealed the error, but vtkMySQLQuery::Execute() did not catch the error, and subsequently crashed in vtkMySQLQuery::NextRow().<br>
<br>The mysql doc explains that it is possible for mysql_query() to succeed, but mysql_store_result() returns
null when it should not. See: <a href="http://dev.mysql.com/doc/refman/5.0/en/null-mysql-store-result.html">http://dev.mysql.com/doc/refman/5.0/en/null-mysql-store-result.html</a><br><br>I created a bug report and attached a patch that fixes the bug. I think the fix is correct, but I'm not sure how to run vtk's mysql tests (wasn't sure how to set VTK_MYSQL_TEST_URL.) Maybe one of the authors of this class wants to take a look? My application doesn't use vtk head, so I'm not actually in a huge rush to see this bug fix pushed.<br>
<br><a href="http://public.kitware.com/Bug/view.php?id=10788">http://public.kitware.com/Bug/view.php?id=10788</a><br><br>Pat<br><br>