Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.2.18
-
None
Description
COM_RESET_CONNECTION doesn't reset temporary table anymore, this is a regression on 10.2.18,
This works well on 10.2.17 and 10.3.
COM_RESET still reset user variables, current transaction, ...
example :
base
|
.createConnection()
|
.then(conn => {
|
conn
|
.query("CREATE TEMPORARY TABLE ttt(t varchar(128))") |
.then(() => {
|
return conn.query("select * from ttt"); |
})
|
.then(rows => {
|
assert.deepEqual(rows, []); |
return conn.reset(); |
})
|
.then(() => {
|
return conn.query("select * from ttt"); |
})
|
.then(rows => {
|
done(new Error("temporary table must not exist !")); // => THROW THIS ERROR, BECAUSE QUERY WORKS. |
})
|
.catch(err => { |
if ( |
(conn.info.isMariaDB() && conn.info.hasMinVersion(10, 2, 4)) || |
(!conn.info.isMariaDB() && conn.info.hasMinVersion(5, 7, 3)) |
) {
|
assert.equal(err.errno, 1146); |
}
|
conn.end();
|
done();
|
});
|
})
|
.catch(done); |
|