Details
Description
on 7.0.0 community edition, following transaction in QWB:
BEGIN WORK;
|
SELECT * FROM `travel-sample` USE KEYS "airline_10"; |
COMMIT;
|
fails as follow:
[
|
{
|
"_sequence_num": 1, |
"_sequence_query": "BEGIN WORK;", |
"_sequence_query_status": "success", |
"_sequence_result": [ |
{
|
"txid": "59585df6-d3b6-4e8e-8ebb-1f9efaf61171" |
}
|
]
|
},
|
{
|
"_sequence_num": 2, |
"_sequence_query": "\nSELECT * FROM `travel-sample` USE KEYS \"airline_10\";", |
"_sequence_query_status": "success", |
"_sequence_result": [ |
{
|
"travel-sample": { |
"callsign": "MILE-AIR", |
"country": "United States", |
"iata": "Q5", |
"icao": "MLA", |
"id": 10, |
"name": "40-Mile Air", |
"type": "airline" |
}
|
}
|
]
|
},
|
{
|
"_sequence_num": 3, |
"_sequence_query": "\nCOMMIT;", |
"_sequence_query_status": "Internal Server Error", |
"_sequence_result": [ |
{
|
"code": 17002, |
"msg": "COMMIT statement is not supported outside the transaction", |
"query": "\nCOMMIT;" |
}
|
]
|
}
|
]
|
Note that this issue was mentioned in MB-44323 (see history) but defect was closed without opening a new one.