View Issue Details

IDProjectCategoryView StatusLast Update
0002197Database Workbench v6Firebird Modulepublic2024-04-02 15:46
ReporterMartijn Tonies Assigned ToMartijn Tonies  
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status resolvedResolutionfixed 
Fixed in Versionv6_next 
Summary0002197: Support for Firebird 5
Descriptionhttps://firebirdsql.org/file/documentation/release_notes/html/en/5_0/rlsnotes50.html

- MERGE or UPDATE OR INSERT: ORDER BY clause https://firebirdsql.org/file/documentation/release_notes/html/en/5_0/rlsnotes50.html#rnfb50-dml-merge-plan-order
- MERGE: WHEN NOT MATCHED BY SOURCE clause https://firebirdsql.org/file/documentation/release_notes/html/en/5_0/rlsnotes50.html#rnfb50-dml-matched-by-source
- PSQL: subroutines can access variables & parameters created in outer routine https://firebirdsql.org/file/documentation/release_notes/html/en/5_0/rlsnotes50.html#rnfb50-psql-subroutine-param-access
- partial indices (WHERE <where_clause>) https://firebirdsql.org/file/documentation/release_notes/html/en/5_0/rlsnotes50.html#rnfb50-ddl-partial-indices
- new non-reserved keywords: LOCKED - OPTIMIZE - QUARTER - TARGET - TIMEZONE_NAME - UNICODE_CHAR - UNICODE_VAL
- 2 new functions UNICODE_CHAR & UNICODE_VAL https://firebirdsql.org/file/documentation/release_notes/html/en/5_0/rlsnotes50.html#rnfb50-dml-unicode-funcs
- new system catalogs: RDB$KEYWORDS - MON$COMPILED_STATEMENTS
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2024-01-30 09:55 Martijn Tonies New Issue
2024-03-11 15:02 Martijn Tonies Assigned To => Martijn Tonies
2024-03-11 15:02 Martijn Tonies Status new => assigned
2024-03-11 15:02 Martijn Tonies Description Updated
2024-03-12 13:45 Martijn Tonies Description Updated
2024-03-12 15:54 Martijn Tonies Description Updated
2024-03-13 09:28 Martijn Tonies Description Updated
2024-04-02 11:30 Martijn Tonies Description Updated
2024-04-02 11:31 Martijn Tonies Description Updated
2024-04-02 14:24 Martijn Tonies Description Updated
2024-04-02 15:44 Martijn Tonies Description Updated
2024-04-02 15:46 Martijn Tonies Description Updated
2024-04-02 15:46 Martijn Tonies Status assigned => resolved
2024-04-02 15:46 Martijn Tonies Resolution open => fixed
2024-04-02 15:46 Martijn Tonies Fixed in Version => v6_next