Eugene Kosov
c5801dd67b
SQL: hide archive tables [ closes #193 ]
2017-09-27 22:08:20 +03:00
Aleksey Midenkov
e9e3cb0f6e
SQL: VTMD for SHOW CREATE fixes [related to #125 ]
2017-09-27 20:42:22 +03:00
Aleksey Midenkov
75bc483d7a
Tests: moved concat_execN() to common.inc
2017-09-25 22:07:01 +03:00
Aleksey Midenkov
11a9d8f7e3
Tests: typo fix in cte.test
...
Related to c2c8808a16
2017-09-20 13:14:16 +03:00
Aleksey Midenkov
6c9b71d734
SQL: VTMD for OR REPLACE [ fixes #270 ]
2017-09-20 13:07:15 +03:00
Aleksey Midenkov
9ba635fda3
SQL: VIEW with UNION fix [ fixes #269 ]
2017-09-14 14:38:49 +03:00
Aleksey Midenkov
7e764ae188
SQL: 1-row partition rotation fix [ fixes #260 ]
2017-09-13 10:57:46 +03:00
Eugene Kosov
78d2430aa2
Tests: VTMD + modify column
2017-09-12 16:27:44 +03:00
Eugene Kosov
a49239b57a
SQL: truncate syntax and privilege [ closes #229 ]
2017-09-08 10:22:24 +03:00
Aleksey Midenkov
904b69cd9e
SQL: partitioning misc fixes [ closes #242 ]
...
* cleanup: *never* use assert(A && B)
* vers_setup_1() revisited
* vers_setup_2() renamed
* partition_element::type removed
* Copy ctor instead of memcpy()
* Handle return value from check_range_constants()
* Malloc error fix
* error, style, misc fixes
2017-09-07 15:49:11 +03:00
Aleksey Midenkov
88ccf759c1
SQL: pruning, derived, view fixes [ fixes #244 ]
2017-09-01 19:05:20 +03:00
Eugene Kosov
c2a70c8050
SQL, IB: option to drop historical rows on ALTER [ closes #249 ]
2017-09-01 12:41:46 +03:00
Eugene Kosov
b4cd2d3c12
Tests: duplicate system versioning field
2017-08-18 15:30:55 +03:00
Eugene Kosov
99baeaa951
SQL: MAX microseconds for current system rows [ fixes #245 ]
2017-08-18 14:29:22 +03:00
Aleksey Midenkov
d3d2ea9fd5
SQL, Parser: system_time logic and syntax fixes [ closes #237 ]
2017-08-08 17:12:16 +03:00
Aleksey Midenkov
53370de103
IB: partition-wise ha_innopart::rnd_init() [ fixes #208 ]
2017-08-04 17:17:28 +03:00
Eugene Kosov
5ce6044b1c
SQL: remove versioning only when hidden system fields
...
[closes #211 ]
2017-08-03 16:03:19 +03:00
Aleksey Midenkov
c2c8808a16
SQL: compare TRX_ID fields against timestamps [ closes #231 ]
2017-08-03 16:01:16 +03:00
Eugene Kosov
d998da0306
SQL: replication fixes [ fixes #234 ]
2017-07-31 11:44:12 +03:00
Aleksey Midenkov
aa292666cc
Parser: moved 'for system_time' before alias
...
Due to standard (see 7.6 <table reference>).
2017-07-23 17:08:00 +03:00
Aleksey Midenkov
c2f6214671
Tests: renamed optimized_fields to optimized
2017-07-21 07:53:58 +03:00
Eugene Kosov
c99bd3ac1a
Tests: truncate.test: get rid of transaction number
2017-07-20 17:15:11 +03:00
Eugene Kosov
f8b6256992
SQL: disallow ALTER CHANGE of system fields [ fixes #213 ]
2017-07-19 23:06:07 +03:00
Eugene Kosov
909867d014
SQL: optimized fields fix for NOT NULL [ fixes #226 ]
2017-07-13 18:48:30 +03:00
Aleksey Midenkov
91c8b43e77
Parser: syntax for query system_time [ closes #230 ]
...
Eliminated `QUERY FOR`.
2017-07-12 12:10:13 +03:00
Aleksey Midenkov
60e456df33
SQL: system_time propagation from derived table [ fixes #228 ]
2017-07-12 10:36:52 +03:00
Aleksey Midenkov
dcb54040bc
SQL: VTQ testing iface moved to plugin [ closes #224 ]
2017-07-07 17:52:23 +03:00
Eugene Kosov
42a0289de9
Tests: optimized fields
2017-07-06 16:19:16 +03:00
Eugene Kosov
1903b407da
SQL: ignore columns WITHOUT VERSIONING [ fixes #220 ]
2017-07-04 17:45:14 +03:00
Aleksey Midenkov
bdcce58fad
IB: long names in information_schema
2017-07-04 12:09:33 +03:00
Aleksey Midenkov
72de7721b9
SQL: No implicit versioning when created from SELECT [ closes #219 ]
2017-07-03 17:38:59 +03:00
Aleksey Midenkov
4b0f1284ee
SQL: revisit error messages [ closes #217 ]
2017-07-03 14:04:34 +03:00
Aleksey Midenkov
177e477553
Tests: VTQ iso_level check fix
2017-06-29 15:11:06 +03:00
Eugene Kosov
229c528110
SQL: hide system fields instead of drop [ closes #210 ]
2017-06-29 12:07:16 +03:00
Eugene Kosov
46d572dde4
SQL: default engine fix in create from versioned [ fixes #206 ]
2017-06-29 12:07:16 +03:00
Eugene Kosov
2442a81eff
IB: read lock on partitioned table read [ closes #200 ]
...
Closes #204
2017-06-22 18:37:49 +03:00
Eugene Kosov
ac5eb9771e
SQL: Versioned SHOW CREATE TABLE [ closes #125 ]
2017-06-19 15:21:48 +03:00
Aleksey Midenkov
448374a228
SQL, IB: (0.10) VTMD tracking [ closes #124 ]
...
IB: Fixes in logic when to do versioned or usual row updates. Now it is
able to do unversioned updates for versioned tables just by disabling
`TABLE_SHARE::versioned` flag.
SQL: DDL tracking for:
* RENAME TABLE, ALTER TABLE .. RENAME TO;
* DROP TABLE;
* data-modifying operations (f.ex. ALTER TABLE .. ADD/DROP COLUMN).
2017-06-19 15:21:39 +03:00
Eugene Kosov
414651c80a
SQL: ALTER ADD COLUMN order fix
2017-05-25 15:25:04 +03:00
kevg
45f6acd296
Scripts: VTMD table [ closes #122 ]
2017-05-24 18:46:56 +03:00
kevg
ec0002e908
Parser: useful attributes for AS ROW fields
2017-05-18 17:46:04 +03:00
kevg
fe71bdf568
Tests: order independence of versioning fields
2017-05-16 13:44:55 +03:00
kevg
0185872449
SQL: versioning DDL part I [ closes #172 ]
2017-05-05 20:36:40 +03:00
Aleksey Midenkov
44506f2669
SQL: vers_ sysvars renamed to versioning_
2017-05-05 20:36:40 +03:00
Aleksey Midenkov
7e0ff13d7a
SQL: derived fixes [related to #185 ]
2017-05-05 20:36:39 +03:00
Aleksey Midenkov
7153ff85a1
SQL: derived tables improvements [ closes #185 ]
2017-05-05 20:36:38 +03:00
Aleksey Midenkov
642525b9ad
Tests: cte_recursive, simple (new plans)
...
Author: Alvin Richards
2017-05-05 20:36:38 +03:00
Aleksey Midenkov
1e8a81dea6
SQL: CREATE VIEW and misc improvements [ fixes #183 ]
2017-05-05 20:36:37 +03:00
Aleksey Midenkov
27a6ef0a9e
IB,SQL: Innopart UPDATE [ fixes #178 ]
2017-05-05 20:36:37 +03:00
kevg
ecd18bc099
SQL: allow FOR SYSTEM_TIME BEFORE for SELECT queries [ closes #170 ]
2017-05-05 20:36:35 +03:00
