View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0001906Database Workbench v6Firebird Modulepublic2021-07-22 13:192021-12-03 12:27
ReporterMartijn Tonies Assigned To 
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status closedResolutionfixed 
Fixed in Version6.0 
Summary0001906: Firebird 4 support
DescriptionFirebird 4 support

Additional InformationDone
- new version & ODS 13 recognized
- meta data names of 63 characters ( https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb40-ddl-objectnames )
- SUSPEND no longer in output-less procedures: modify 'header SQL' for stored procedures ( http://tracker.firebirdsql.org/browse/CORE-6239 )
- max page size ( http://tracker.firebirdsql.org/browse/CORE-2192 )
- new HEX_ENCODE and HEX_DECODE functions ( https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb4-dml-new-builtin-hex )
- FIRST_DAY & LAST_DAY functions ( https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb40-dml-new-timefuncs )
- https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb4-builtin-crypto-functions
- new crypto functions ( https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb4-builtin-crypto-functions )
- INT128 data type ( http://tracker.firebirdsql.org/browse/CORE-6342 )
- new DECFLOAT type ( https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb40-ddl-decfloat )
- new keywords ( https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb40-reswords )
- SQL SECURITY for functions, packages, procedures, triggers ( https://firebirdsql.org/file/documentation/html/en/refdocs/fblangref40/firebird-40-language-reference.html#fblangref40-ddl-procedure )
- system privileges for Roles ( https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb40-security )
- timezones ( https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb40-timezone )
- changes to FLOAT ( https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb40-ddl-float )
- LATERAL derived tables support in parsing (SQL Insight) ( https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb40-dml-lateral )
- FILTER clause ( https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb40-dml-filter-clause )
- grant roles to roles ( https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb4-grant-role-to-role )
- Window functions changes ( https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb40-dml-framed-windows - https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb40-dml-named-windows - https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb40-dml-windows-newfunctions)
- RDB$ERROR ( https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb40-psql )
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2021-07-22 13:19 Martijn Tonies New Issue
2021-07-22 14:36 Martijn Tonies Description Updated
2021-07-22 14:36 Martijn Tonies Additional Information Updated
2021-07-22 15:07 Martijn Tonies Description Updated
2021-07-22 15:07 Martijn Tonies Additional Information Updated
2021-07-22 15:19 Martijn Tonies Description Updated
2021-07-22 15:19 Martijn Tonies Additional Information Updated
2021-07-26 10:17 Martijn Tonies Description Updated
2021-07-26 10:17 Martijn Tonies Additional Information Updated
2021-07-26 10:19 Martijn Tonies Description Updated
2021-07-26 10:19 Martijn Tonies Additional Information Updated
2021-07-26 10:36 Martijn Tonies Description Updated
2021-07-26 10:55 Martijn Tonies Description Updated
2021-07-26 10:55 Martijn Tonies Additional Information Updated
2021-07-27 10:31 Martijn Tonies Description Updated
2021-07-27 10:31 Martijn Tonies Additional Information Updated
2021-07-27 11:12 Martijn Tonies Description Updated
2021-07-27 11:12 Martijn Tonies Additional Information Updated
2021-07-27 11:24 Martijn Tonies Description Updated
2021-07-28 11:51 Martijn Tonies Description Updated
2021-07-28 11:51 Martijn Tonies Additional Information Updated
2021-07-28 14:48 Martijn Tonies Description Updated
2021-07-28 14:48 Martijn Tonies Additional Information Updated
2021-08-03 15:48 Martijn Tonies Description Updated
2021-08-03 15:48 Martijn Tonies Additional Information Updated
2021-08-03 15:52 Martijn Tonies Description Updated
2021-08-04 08:34 Martijn Tonies Description Updated
2021-08-04 08:34 Martijn Tonies Additional Information Updated
2021-08-04 09:50 Martijn Tonies Description Updated
2021-08-04 09:50 Martijn Tonies Additional Information Updated
2021-08-04 10:06 Martijn Tonies Description Updated
2021-08-04 10:06 Martijn Tonies Additional Information Updated
2021-08-04 12:23 Martijn Tonies Description Updated
2021-08-04 12:23 Martijn Tonies Additional Information Updated
2021-08-04 13:05 Martijn Tonies Description Updated
2021-08-04 13:07 Martijn Tonies Description Updated
2021-08-04 13:48 Martijn Tonies Description Updated
2021-08-04 13:48 Martijn Tonies Additional Information Updated
2021-08-05 08:41 Martijn Tonies Description Updated
2021-08-05 08:41 Martijn Tonies Additional Information Updated
2021-08-05 10:51 Martijn Tonies Description Updated
2021-09-20 13:34 Martijn Tonies Status new => resolved
2021-09-20 13:34 Martijn Tonies Resolution open => fixed
2021-09-20 13:34 Martijn Tonies Fixed in Version => 6.0
2021-09-20 13:34 Martijn Tonies Description Updated
2021-12-03 12:27 Martijn Tonies Status resolved => closed