1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213
|
/*
Copyright (c) 2009, 2010, Oracle and/or its affiliates. All rights reserved.
The MySQL Connector/C++ is licensed under the terms of the GPLv2
<http://www.gnu.org/licenses/old-licenses/gpl-2.0.html>, like most
MySQL Connectors. There are special exceptions to the terms and
conditions of the GPLv2 as it is applied to this software, see the
FLOSS License Exception
<http://www.mysql.com/about/legal/licensing/foss-exception.html>.
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published
by the Free Software Foundation; version 2 of the License.
This program is distributed in the hope that it will be useful, but
WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License
for more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
*/
#include "bugs.h"
#include <sstream>
namespace testsuite
{
namespace regression
{
void bugs::net_write_timeout39878()
{
logMsg("Test for #39878 - not fixed. And looks like there is no way to fix it at the moment.");
logMsg("If the test doesn't fail - that rather means that you should tweak parameters for your system");
logMsg("You can do that with command line parameters:");
logMsg(" --nwtTimeout=<val> for the value net_write timeout to set to (default 1)");
logMsg(" --nwtPause=<val> for the length of pause test shoud take while fetching rows (default 2)");
logMsg(" --nwtRows=<val> for the number of rows to insert into table (default 9230)");
int timeout = 1;
int pause = 2;
int rows = 9230;
int tmp = TestsRunner::getStartOptions()->getInt("nwtTimeout");
if (tmp > 0)
timeout = tmp;
tmp = TestsRunner::getStartOptions()->getInt("nwtPause");
if (tmp > 0)
pause = tmp;
tmp = TestsRunner::getStartOptions()->getInt("nwtRows");
if (tmp > 0)
rows = tmp;
pstmt.reset(con->prepareStatement("set net_write_timeout=?"));
pstmt->setInt(1, timeout);
pstmt->execute();
res.reset(stmt->executeQuery("show variables like \"net_write_timeout\""));
res->next();
TestsListener::messagesLog() << "We've set net_write_timeout to " << res->getString(2) << std::endl;
stmt->execute("drop table if exists bug39878");
stmt->execute("create table bug39878 (id int unsigned not null)");
stmt->execute("lock table bug39878 write");
pstmt.reset(con->prepareStatement("insert into bug39878 ( id ) values( ? )"));
for (int i = 1; i <= rows; ++i) {
pstmt->setInt(1, i);
pstmt->execute();
}
stmt->execute("unlock tables");
res.reset(stmt->executeQuery("select count(*) from bug39878"));
res->next();
uint32_t rowsCount = res->getUInt(1);
TestsListener::messagesLog() << "Now we have " << rowsCount << " rows in the table" << std::endl;
// Must set ResultSet Type to TYPE_FORWARD_ONLY
stmt->setResultSetType(sql::ResultSet::TYPE_FORWARD_ONLY);
res.reset(stmt->executeQuery("select * from bug39878"));
TestsListener::messagesLog() << "ResultSetType: " << stmt->getResultSetType() << std::endl;
uint32_t rowsRead = 0;
try {
while (res->next()) {
if (rowsRead == 0) {
TestsListener::messagesLog() << "Pause " << pause << "s." << std::endl;
SLEEP(pause);
}
++rowsRead;
}
} catch (sql::SQLException& /*e*/) {
//if ( e.errNo == 2006 )
/* let's think that exception is a god result itself.
also not sure which errno should it be */
return;
}
TestsListener::messagesLog() << "We've fetched " << rowsRead << " rows." << std::endl;
try {
stmt->execute("drop table if exists bug39878");
} catch (sql::SQLException& e) {
// Expected, that Server has gone away
logMsg(e.what());
// Lazy way to reconnect
setUp();
stmt->execute("drop table if exists bug39878");
}
ASSERT_EQUALS(rowsCount, rowsRead);
}
void bugs::store_result_error_51562()
{
std::stringstream msg;
logMsg("Regression test for #51562");
try {
stmt.reset(con->createStatement());
/* Running a SELECT and storing the returned result set in this->res */
res.reset(stmt->executeQuery("select 1, (select 'def' union all select 'abc')"));
fail("SQL error not detected or the server has changed its behavior", __FILE__, __LINE__);
} catch (sql::SQLException &e) {
/* If anything goes wrong, write some info to the log... */
logMsg("Expecting error: ERROR 1242 (21000): Subquery returns more than 1 row, got:");
logMsg(e.what());
logMsg("SQLState: " + std::string(e.getSQLState()));
if (e.getErrorCode() != 1242) {
msg.str("");
msg << "Expecting MySQL error code 1242, got " << e.getErrorCode() << ".";
msg << "This may be a compatible and acceptable code - check manually and update test if nedded!";
logMsg(msg.str());
fail("Wrong error code, check verbose output for details", __FILE__, __LINE__);
}
}
logMsg("Checking prepared statements");
try {
pstmt.reset(con->prepareStatement("select 1, (select 'def' union all select 'abc')"));
/* Running a SELECT and storing the returned result set in this->res */
res.reset(pstmt->executeQuery());
fail("SQL error not detected or the server has changed its behavior", __FILE__, __LINE__);
} catch (sql::SQLException &e) {
/* If anything goes wrong, write some info to the log... */
logMsg("Expecting error: ERROR 1242 (21000): Subquery returns more than 1 row, got:");
logMsg(e.what());
logMsg("SQLState: " + std::string(e.getSQLState()));
if (e.getErrorCode() != 1242) {
msg.str("");
msg << "Expecting MySQL error code 1242, got " << e.getErrorCode() << ".";
msg << "This may be a compatible and acceptable code - check manually and update test if nedded!";
logMsg(msg.str());
fail("Wrong error code, check verbose output for details", __FILE__, __LINE__);
}
}
}
void bugs::getResultSet_54840()
{
stmt->executeUpdate("DROP function if exists _getActivePost");
stmt->executeUpdate("CREATE Function _getActivePost(_author INT) "
"RETURNS INT "
"DETERMINISTIC "
"BEGIN "
" RETURN 55;"
"END");
ASSERT(stmt->execute("select _getActivePost()"));
try
{
res.reset(stmt->getResultSet());
}
catch (::sql::SQLException & /*e*/)
{
stmt->executeUpdate("DROP function _getActivePost");
return; /* Everything is fine */
}
stmt->executeUpdate("DROP function _getActivePost");
FAIL("Exception wasn't thrown by getResultSet");
}
} /* namespace regression */
} /* namespace testsuite */
|