diff options
| author | Aleksey Midenkov <midenok@gmail.com> | 2018-07-30 19:50:42 +0300 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2019-03-29 12:51:19 +0100 |
| commit | 8df04fb894bd06706ee6292d4dd991aacfc1989a (patch) | |
| tree | 2e42848d4515f9e0fec94705e4f05386d17ee8f7 /mysql-test/suite/versioning | |
| parent | 5c0bb0766d46840bf96555ecd5cb2ed17028c847 (diff) | |
| download | mariadb-git-8df04fb894bd06706ee6292d4dd991aacfc1989a.tar.gz | |
MDEV-15412 For any non-existing transaction ID, AS OF provides the current table contents without a warning
Fail with error on non-existing TRX_ID.
Closes #832
Diffstat (limited to 'mysql-test/suite/versioning')
| -rw-r--r-- | mysql-test/suite/versioning/r/trx_id.result | 14 | ||||
| -rw-r--r-- | mysql-test/suite/versioning/t/trx_id.test | 10 |
2 files changed, 12 insertions, 12 deletions
diff --git a/mysql-test/suite/versioning/r/trx_id.result b/mysql-test/suite/versioning/r/trx_id.result index 7d5e908b85a..fbcabf9673b 100644 --- a/mysql-test/suite/versioning/r/trx_id.result +++ b/mysql-test/suite/versioning/r/trx_id.result @@ -334,18 +334,16 @@ x # # HEX hybrids resolve to TRANSACTION # -SELECT * FROM t1 FOR SYSTEM_TIME AS OF (0x60); -x -1 -SELECT * FROM t2 FOR SYSTEM_TIME AS OF (0x60); +SELECT * FROM t1 FOR SYSTEM_TIME AS OF (0xFFFFFFFF); +ERROR HY000: TRX_ID 4294967295 not found in `mysql.transaction_registry` +SELECT * FROM t2 FOR SYSTEM_TIME AS OF (0xFFFFFFFF); ERROR HY000: Transaction system versioning for `t2` is not supported # # BIT literals resolve to TRANSACTION # -SELECT * FROM t1 FOR SYSTEM_TIME AS OF (b'1100000'); -x -1 -SELECT * FROM t2 FOR SYSTEM_TIME AS OF (b'1100000'); +SELECT * FROM t1 FOR SYSTEM_TIME AS OF (b'11111111111111111111111111111111'); +ERROR HY000: TRX_ID 4294967295 not found in `mysql.transaction_registry` +SELECT * FROM t2 FOR SYSTEM_TIME AS OF (b'11111111111111111111111111111111'); ERROR HY000: Transaction system versioning for `t2` is not supported DROP TABLE t1, t2; # diff --git a/mysql-test/suite/versioning/t/trx_id.test b/mysql-test/suite/versioning/t/trx_id.test index 885455a6977..b0691e4580c 100644 --- a/mysql-test/suite/versioning/t/trx_id.test +++ b/mysql-test/suite/versioning/t/trx_id.test @@ -361,18 +361,20 @@ SELECT * FROM t2 FOR SYSTEM_TIME AS OF '2038-12-30 00:00:00'; --echo # HEX hybrids resolve to TRANSACTION --echo # -SELECT * FROM t1 FOR SYSTEM_TIME AS OF (0x60); +--error ER_VERS_NO_TRX_ID +SELECT * FROM t1 FOR SYSTEM_TIME AS OF (0xFFFFFFFF); --error ER_VERS_ENGINE_UNSUPPORTED -SELECT * FROM t2 FOR SYSTEM_TIME AS OF (0x60); +SELECT * FROM t2 FOR SYSTEM_TIME AS OF (0xFFFFFFFF); --echo # --echo # BIT literals resolve to TRANSACTION --echo # -SELECT * FROM t1 FOR SYSTEM_TIME AS OF (b'1100000'); +--error ER_VERS_NO_TRX_ID +SELECT * FROM t1 FOR SYSTEM_TIME AS OF (b'11111111111111111111111111111111'); --error ER_VERS_ENGINE_UNSUPPORTED -SELECT * FROM t2 FOR SYSTEM_TIME AS OF (b'1100000'); +SELECT * FROM t2 FOR SYSTEM_TIME AS OF (b'11111111111111111111111111111111'); DROP TABLE t1, t2; |