diff options
| author | Aleksey Midenkov <midenok@gmail.com> | 2017-08-08 17:12:16 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-08-08 17:12:16 +0300 |
| commit | d3d2ea9fd59a836dd0b0577658c5961712a5ed9d (patch) | |
| tree | 2c146dff86192cd7073380c2b6632ea7ac8ed2f2 /mysql-test/suite/versioning/t/select.test | |
| parent | 53370de103a58bff2d6c566f411e58d70bd5d446 (diff) | |
| download | mariadb-git-d3d2ea9fd59a836dd0b0577658c5961712a5ed9d.tar.gz | |
SQL, Parser: system_time logic and syntax fixes [closes #237]
Diffstat (limited to 'mysql-test/suite/versioning/t/select.test')
| -rw-r--r-- | mysql-test/suite/versioning/t/select.test | 18 |
1 files changed, 6 insertions, 12 deletions
diff --git a/mysql-test/suite/versioning/t/select.test b/mysql-test/suite/versioning/t/select.test index 5dc5f603d54..345e28f610c 100644 --- a/mysql-test/suite/versioning/t/select.test +++ b/mysql-test/suite/versioning/t/select.test @@ -42,28 +42,22 @@ if ($default_engine == 'innodb') select x, y from t1; select x as ASOF_x, y from t1 for system_time as of timestamp @t0; -select x as FROMTO_x, y from t1 for system_time from timestamp '0-0-0 0:0:0' to timestamp @t1; -select x as BETWAND_x, y from t1 for system_time between timestamp '0-0-0 0:0:0' and timestamp @t1; -select x as FROMTO_ext_x, y from t1 for system_time from timestamp '0-0-0 0:0:0' to timestamp @t1; -select x as BETWAND_ext_x, y from t1 for system_time between timestamp '0-0-0 0:0:0' and timestamp @t1; +select x as FROMTO_x, y from t1 for system_time from '0-0-0 0:0:0' to timestamp @t1; +select x as BETWAND_x, y from t1 for system_time between '0-0-0 0:0:0' and timestamp @t1; select x as ALL_x, y from t1 for system_time all; --disable_query_log if ($default_engine == 'innodb') { - select x as ASOF2_x, y from t1 for system_time as of transaction @x0; - select x as FROMTO2_x, y from t1 for system_time from transaction @x0 to transaction @x1; + select x as ASOF2_x, y from t1 for system_time as of @x0; + select x as FROMTO2_x, y from t1 for system_time from @x0 to @x1; select x as BETWAND2_x, y from t1 for system_time between transaction @x0 and transaction @x1; - select x as FROMTO2_ext_x, y from t1 for system_time transaction from @x0 to @x1; - select x as BETWAND2_ext_x, y from t1 for system_time transaction between @x0 and @x1; } if ($default_engine != 'innodb') { - select x as ASOF2_x, y from t1 for system_time as of timestamp @t0; - select x as FROMTO2_x, y from t1 for system_time from timestamp '0-0-0 0:0:0' to timestamp @t1; + select x as ASOF2_x, y from t1 for system_time as of @t0; + select x as FROMTO2_x, y from t1 for system_time from '0-0-0 0:0:0' to @t1; select x as BETWAND2_x, y from t1 for system_time between timestamp '0-0-0 0:0:0' and timestamp @t1; - select x as FROMTO2_ext_x, y from t1 for system_time from timestamp '0-0-0 0:0:0' to timestamp @t1; - select x as BETWAND2_ext_x, y from t1 for system_time between timestamp '0-0-0 0:0:0' and timestamp @t1; } --enable_query_log |