View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001729 | CaseTalk Modeler | Generation (SQL, XML, etc) | public | 2018-05-26 11:11 | 2022-01-10 20:40 |
Reporter | Marco Wobben | Assigned To | Marco Wobben | ||
Priority | normal | Severity | feature | Reproducibility | have not tried |
Status | closed | Resolution | fixed | ||
Target Version | Future | Fixed in Version | 11.0 | ||
Summary | 0001729: Add SQL2011 generator | ||||
Description | SQL92 is usable for many DBMS's, yet more modern versions have been around for a long time. Providing various new features, but also more variations in datatypes. Therefor a more recent SQL standard might be needed. | ||||
Additional Information | https://en.wikipedia.org/wiki/SQL https://en.wikipedia.org/wiki/SQL:2011 DBMS's: https://mariadb.com/kb/en/library/system-versioned-tables/ | ||||
Tags | No tags attached. | ||||
CaseTalk Edition | unknown | ||||
related to | 0000343 | closed | Marco Wobben | Generate temporal database script |
The SQL2011 plugin is not much different in comparison to the SQL92 plugin, with the exception of the new Temporal support to generate (bi)temporal tables. | |
Closing automatically, stayed too long in resolved state. Feel free to re-open with additional information if you think the issue is not resolved. | |
Date Modified | Username | Field | Change |
---|---|---|---|
2018-05-26 11:11 | Marco Wobben | New Issue | |
2018-07-11 18:38 | Marco Wobben | Summary | Upgrade SQL92 export => Upgrade SQL92 to SQL2011 |
2018-07-11 18:38 | Marco Wobben | Additional Information Updated | |
2018-07-26 09:52 | Marco Wobben | Additional Information Updated | |
2020-11-05 12:13 | Marco Wobben | Relationship added | related to 0000343 |
2020-11-05 12:14 | Marco Wobben | Assigned To | => Marco Wobben |
2020-11-05 12:14 | Marco Wobben | Status | new => resolved |
2020-11-05 12:14 | Marco Wobben | Resolution | open => fixed |
2020-11-05 12:14 | Marco Wobben | Fixed in Version | => 11.0 |
2020-11-05 12:14 | Marco Wobben | Note Added: 0001806 | |
2020-11-05 12:15 | Marco Wobben | Summary | Upgrade SQL92 to SQL2011 => Add SQL2011 generator |
2022-01-10 20:40 | Marco Wobben | Note Added: 0003494 | |
2022-01-10 20:40 | Marco Wobben | Status | resolved => closed |