firebird/firebird-mirror
firebird/firebird-mirror
8
0
Fork 1
mirror of https://github.com/FirebirdSQL/firebird.git synced 2025-01-22 17:23:03 +01:00
Code Issues
57,831 Commits 55 Branches 76 Tags 280 MiB
master
Commit Graph

466 Commits

Author SHA1 Message Date
AlexPeshkoff
c3b172d4e2 Implemented #7046: Make ability to add comment to mapping ('COMMENT ON MAPPING ... IS ...') 2022-07-01 18:25:42 +03:00
Adriano dos Santos Fernandes
2f2f5fec30 Design for future extensions with different timings types. 
Add ProfilerStats interface and pass it to plugin instead of runTime parameter.

Rename *_TIME columns to *_ELAPSED_TIME.
 2022-06-22 22:25:47 -03:00
Adriano dos Santos Fernandes
208f25b073 Update view's field types. 2022-06-10 22:53:36 -03:00
Adriano dos Santos Fernandes
82b98c07d1 Add TOTAL_TIME column to PLG$PROF_REQUESTS. Add view PLG$PROF_STATEMENT_STATS_VIEW. 2022-06-10 22:14:36 -03:00
Adriano dos Santos Fernandes
35ba33592f Add procedure SET_FLUSH_INTERVAL. 
Add parameter FLUSH_INTERVAL to START_SESSION.
 2022-06-06 21:52:00 -03:00
Adriano dos Santos Fernandes
e090ec0f60 Add system privilege PROFILE_ANY_ATTACHMENT and permission check. 
Add some static_asserts.
 2022-06-04 22:48:56 -03:00
Adriano dos Santos Fernandes
3fe37a6a60 Do not pass user's transaction to plugin. 
Use autonomous transaction in flush.
 2022-06-04 15:00:42 -03:00
Adriano dos Santos Fernandes
bb139df3c7 Remote attachment profiling. 2022-06-04 15:00:42 -03:00
Adriano dos Santos Fernandes
b3654c48e8 Add PLUGIN_OPTIONS parameters to RDB$PROFILER.START_SESSION. 2022-06-04 15:00:42 -03:00
Adriano dos Santos Fernandes
12f8d087d3 Add defaults to RDB$PROFILER.PAUSE_SESSION and RDB$PROFILER.FINISH_SESSION parameters. 2022-06-04 15:00:42 -03:00
Adriano dos Santos Fernandes
a8ae90d9f7 Add configuration parameter DefaultProfilerPlugin. 
Change RDB$PROFILER.START_SESSION parameters order and put defaults on them.
 2022-06-04 15:00:42 -03:00
Adriano dos Santos Fernandes
0c5874eed9 Add procedure RDB$PROFILER.DISCARD. 2022-06-04 15:00:42 -03:00
Adriano dos Santos Fernandes
9365493cde Add procedure RDB$PROFILER.CANCEL_SESSION. 2022-06-04 15:00:42 -03:00
Adriano dos Santos Fernandes
3056a1c302 Rename SESSION_ID columns to PROFILE_ID. 2022-06-04 15:00:42 -03:00
Adriano dos Santos Fernandes
25a5de4112 Rename fbprof$ prefix to plg$prof_. 2022-06-04 15:00:42 -03:00
Adriano dos Santos Fernandes
3c22c23874 Improvement #4769 - Allow sub-routines to access variables/parameters 
defined at the outer/parent level [CORE4449].

Remove blr_parameter3.

Comment unused blr_run_count.
 2022-01-30 12:15:03 -03:00
Dmitry Yemanov
82da31ccfd
Remove the WNET protocol (#7082) 
* Wiped out the WNET support

* Remove the WNET files
 2022-01-05 10:34:07 +03:00
Adriano dos Santos Fernandes
2f503f2e2d Profiler. 2021-12-23 15:08:04 -03:00
Roman Simakov
1da899ab80
Update README.time_zone.md 
Fix typo
 2021-11-07 18:00:42 +03:00
Adriano dos Santos Fernandes
f412800202 Cleanup: get rid of unused variables. 2021-09-21 09:47:30 -03:00
Adriano dos Santos Fernandes
854b809c77 Feature #6681 and fix for #6942. 
- #6681 - Support for WHEN NOT MATCHED BY SOURCE for MERGE statement [CORE6448].
- #6942 - Incorrect singleton error with MERGE and RETURNING.
 2021-09-02 10:00:15 -03:00
Adriano dos Santos Fernandes
b32f96f2a9 Feature #6815 - Support multiple rows for DML RETURNING. 2021-08-25 14:56:20 -03:00
AlexPeshkoff
84f78b4fad Implemented #6929: Add support of PKCS v.1.5 padding to RSA functions, needed for backward compatibility with old systems. 2021-08-24 19:58:20 +03:00
Dmitry Yemanov
4218e335d7
Merge pull request #6793 from FirebirdSQL/work/gh-6788 
Improvement #6788 - Extend EXTRACT to extract time zone strings.
 2021-05-14 20:48:01 +03:00
Adriano dos Santos Fernandes
225b01442e Correction for #6798 docs as noted by Mark. 2021-05-14 13:45:28 -03:00
Adriano dos Santos Fernandes
3b372197e4 Feature #6798 - Add built-in functions UNICODE_CHAR and UNICODE_VAL to convert between Unicode code point and character. 2021-05-14 11:20:38 -03:00
Adriano dos Santos Fernandes
2ca31bf7d1 Update readme for #5588. 2021-05-13 14:11:29 -03:00
AlexPeshkoff
901c7021e0 Resolved #6797 2021-05-13 14:11:23 +03:00
AlexPeshkoff
cc443cce20 Resolve #6806, fixed related examples in readme 2021-05-12 19:32:49 +03:00
Adriano dos Santos Fernandes
57c8fd53b9 Fix #6800 - Client config DefaultTimeZone is not passed to server when isc_dpb_session_time_zone is not set. 2021-05-10 10:45:05 -03:00
Adriano dos Santos Fernandes
a02f0dea81 Improvement #6788 - Extend EXTRACT to extract time zone strings. 2021-05-04 11:41:35 -03:00
Adriano dos Santos Fernandes
5018dd6109 Improvement #6786 - Add session time zone to system context. 2021-05-04 11:32:47 -03:00
Mark Rotteveel
0e934bd662
SIMILAR TO also requires escape of } 
See also https://github.com/FirebirdSQL/firebird-documentation/issues/124
 2021-04-27 15:29:47 +02:00
Mark Rotteveel
6e685c3f82 Fix syntax error in substring-similar doc 2021-04-05 13:07:39 +02:00
Dmitry Yemanov
034e6e2453 Adjusted the docs 2021-01-28 20:33:40 +03:00
Dmitry Yemanov
b30ff76118 Replaced ADD/DROP with INCLUDE/EXCLUDE in replication DDL 2020-10-27 15:15:35 +03:00
Adriano dos Santos Fernandes
ff37d445ce Fixed CORE-6427 and CORE-6429: 
- CORE-6427 - Whitespace as date separator causes conversion error.
- CORE-6429 - Timezone offset in timestamp/time literal and CAST should follow SQL standard syntax only.
 2020-10-26 12:30:21 -03:00
AlexPeshkoff
e9f3eb360d Moved cryptographic hashes to separate function crypt_hash(), crc32 - into function hash() 2020-08-26 18:46:53 +03:00
Dmitry Yemanov
22ad236f62 CORE-6300 (next attachment/statement ID) and some other additions 2020-08-09 12:34:58 +03:00
AlexPeshkoff
23906efcff Fixed CORE-6303: Error writing to TIMESTAMP/TIME WITH TIME ZONE array 2020-07-21 19:07:04 +03:00
AlexPeshkoff
422035f291 Documentation 2020-06-24 13:11:29 +03:00
AlexPeshkoff
c2692c6cee Added explicit datatype INT128 (base type for high precision numeric/decimal), enhanced processing of SET BIND for exact digital datatypes 2020-06-24 12:57:18 +03:00
Dimitry Sibiryakov
926db40d88 Renames requested by Vlad Khorsun 2020-06-16 14:10:18 +02:00
Dimitry Sibiryakov
6a37221faf Missed piece of documentation 2020-06-15 20:32:50 +02:00
Dimitry Sibiryakov
2401b66e9e
Receive features list from a real provider (#266) 
* Receive features list from a real provider

* Prevent statement caching if the provider doesn't support it

* Changes requested by Dmitry Yemanov
 2020-06-14 20:01:53 +03:00
Adriano dos Santos Fernandes
b5840da376 Remove appendix with time zone regions from README.time_zone.md. 2020-05-17 22:39:02 -03:00
Dmitry Yemanov
e49fe26b58 Misc adjustments 2020-05-07 10:21:41 +03:00
Adriano dos Santos Fernandes
805dee4d0b Added new time zones. 2020-05-04 13:04:18 -03:00
Adriano dos Santos Fernandes
f6cda2a693 Fixed CORE-6271 - Bind time with time zone to legacy produces wrong values. 2020-05-04 13:03:28 -03:00
Mark Rotteveel
e5b049d2bb
Update URL to tzdata in README.time_zone.md 2020-04-24 18:22:44 +02:00
Dmitry Yemanov
54ed1e6b33 Adjusted docs 2020-04-21 19:36:43 +03:00
Dmitry Yemanov
2231e6e187 Documentation 2020-04-21 19:36:43 +03:00
Dmitry Yemanov
ddd5621666 DDL control for replication 2020-04-21 19:36:43 +03:00
AlexPeshkoff
928242e54d Misc docs 2020-04-13 14:20:53 +03:00
hvlad
e44446e855 Some additional checks and documentation for new MAKE_DBKEY function. 2020-04-10 13:06:04 +03:00
AlexPeshkoff
1e37604cd0 Implemented CORE-6279: Put options in user management statements in any order 2020-04-08 14:17:16 +03:00
Dmitry Yemanov
ef565b1832 Documentation 2020-04-06 11:32:31 +03:00
hvlad
9ac2238c3d Merge branch 'query_restarts_2' 2020-03-28 12:20:04 +02:00
Alexander Peshkov
2d2df601a3
None gmt fallback (#260) 
Added new form of set bind: SET BIND OF TIME ZONE TO EXTENDED
 2020-03-04 19:14:58 +03:00
hvlad
24e4944b05 Merge branch 'master' into query_restarts_2 2020-02-13 02:04:02 +02:00
hvlad
447974bd84 Reworked request restart logic 2020-02-13 01:47:14 +02:00
AlexPeshkoff
b9f4c65220 Added various ways to get infomation about wire crypt plugin name: variable in rdb$get_context(), field in mon$attachments and tag in Attachment::getInfo() 2020-01-15 18:02:19 +03:00
Adriano dos Santos Fernandes
64ecbd8dd2 CORE-6214 - Update outdated tzdata version. 
Added documentation and script for update.

zipjs.bat is downloaded from https://github.com/npocmaka/batch.scripts/blob/master/hybrids/jscript/zipjs.bat
 2020-01-14 12:41:15 -03:00
AlexPeshkoff
a46a3df0fb Fixup some issues with numeric & decimal datatypes 2019-12-27 15:46:45 +03:00
AlexPeshkoff
4e8674e81e Make raw .md look a bit better 2019-12-10 10:34:45 +03:00
AlexPeshkoff
011546154c Fixed docs 2019-12-06 18:35:43 +03:00
AlexPeshkoff
be6c4c2d28 Documentation, firebird.conf 2019-12-06 18:35:43 +03:00
AlexPeshkoff
6a4db49be4 Added NATIVE binding support 2019-12-06 18:35:43 +03:00
AlexPeshkoff
a6b05a671e Started with doc for a feature 2019-12-06 18:35:43 +03:00
AlexPeshkoff
d5019220f1 Fixed CORE-6186: Original content of column which is involved into ENCRYPT() is displayed as distorted view after this call 2019-12-06 17:25:58 +03:00
hvlad
94d3a7cfe8 Let external transaction run with CONCURRENCY isolation mode if local transaction runs with READ COMMITED READ CONSISTENCY isolation and such isolation mode is not supported by external data source. 
Allow to reuse external connection if external data source doesn't support ALTER SESSION RESET statement.
Update documentation.
 2019-11-15 10:54:50 +02:00
Alexander Peshkov
861d536fc2
Int128 - new datatype (#220) 
* Int128 support - work in progress

* Work in progress

* Int128 datatype appears to be mostly OK except sort & index

* Fixed divide scaling, added sorting & network (xdr) support

* Binding control, aggregate nodes, cleanup and documentation

* Fixed VS2017 AppVeyor build

* Next attempt to fix vs2017 build

* Next attempt to fix vs2017 build

* Next attempt to fix vs2017 build

* Update MSVC build.

* Set VS architecture correctly

* Fixed a number of issues noticed by Mark
 2019-09-16 20:59:54 +03:00
hvlad
043f7b2361 Merge branch 'query_restarts' of https://github.com/samofatov/firebird into query_restarts 2019-08-26 20:11:36 +03:00
nikolay.samofatov
accb0e9f8a Use snapshot mode for PSQL blocks executed in autonomous transactions 2019-08-16 12:11:53 +03:00
Adriano dos Santos Fernandes
28e18749ff WIP: Reimplementation of SIMILAR TO and SUBSTRING...SIMILAR using Google's re2 library. 
This should fix:
CORE-4874
CORE-5664
CORE-3858
CORE-6088
CORE-3773
CORE-5931
CORE-6088
CORE-4893
 2019-08-10 22:39:19 -03:00
Mark Rotteveel
426aeb50c8 CORE-6109 SQL standard FLOAT type syntax support (#218) 
* CORE-6109 SQL standard FLOAT type syntax support

* Fix type or copy/paste error

* Delete unused precision_opt rule
 2019-08-02 20:55:34 +03:00
Adriano dos Santos Fernandes
d046a2ca86 Fallback for problem converting time-tz/timestamp-tz when ICU is not present in client. 2019-07-14 21:31:17 -03:00
Adriano dos Santos Fernandes
9c76811fae Improvement CORE-6058 - Change behavior of skipped and repeated wall times within time zones. 2019-05-01 16:32:29 -03:00
AlexPeshkoff
97f33ec4eb Added doc for HEX functions 2019-04-17 13:15:30 +03:00
AlexPeshkoff
456e7a03cf Implemented CORE-4726: REcreate user <user_name> password <user_pwd> 2019-04-13 21:21:56 +03:00
hvlad
7ce2a344f0 Fixed bug CORE-6043 : GTTs do not release used space 2019-04-12 15:44:18 +03:00
Adriano dos Santos Fernandes
2a9f8fa60b Improvement CORE-6032 - Add DPB properties for time zone bind and decfloat configuration. 2019-04-07 11:56:02 -03:00
Adriano dos Santos Fernandes
a64b202dad Fixed CORE-6034 - The original time zone should be set to the current time zone at routine invocation. 2019-03-26 13:13:59 -03:00
Roman Simakov
bb3c2e94ec Fixed CORE-5892: SQL SECURITY DEFINER context is not properly evaluated for monitoring tables (#196) 
* Now we take into account the call hierarchy when use SQL SECURITY
option.
Added new context variable in SYSTEM namespace - EFFICIENT_USER which is
returns user name in which context a code works.
We change efficient user before call procedure and function, fetch a
record from selective procedure and before execute a trigger.

* Renamed new context variable to EFFECTIVE_USER. Fixed nested calls.

* Improved error messages to print effective user when there is no permission.

* Added description of new context variable EFFECTIVE_USER. Improved description of SQL SECURITY clause.
 2019-03-18 14:17:02 +03:00
hvlad
e17bff156b Improvement CORE-5658 : Execute statement with excess parameters 
Documentation
 2019-03-06 13:37:50 +02:00
Adriano dos Santos Fernandes
cfbcbeda3c
Make it possible to start multiple transactions using the same initial transaction snapshot - CORE-6018 (#193) 
With this feature it's possible to create parallel (via different attachments) processes reading consistent data from a database.

For example, a backup process may create multiple threads paralleling read data from the database.

Also a web service may dispatch distributed sub services paralleling doing some processing.

That is accomplished creating a transaction with SET TRANSACTION SNAPSHOT [ AT NUMBER <snapshot number> ] or isc_tpb_at_snapshot_number.

The <snapshot number> from the first transaction may be obtained with RDB$GET_CONTEXT('SYSTEM', 'SNAPSHOT_NUMBER') or transaction info call with fb_info_tra_snapshot_number.

Also added CORE-6017 - Add transaction info fb_info_tra_snapshot_number.
 2019-03-01 16:17:19 -03:00
Adriano dos Santos Fernandes
05b5d16c44 Task CORE-6016 - Rename RDB$GET_CONTEXT('SYSTEM', 'SNAPSHOT_CN') to RDB$GET_CONTEXT('SYSTEM', 'SNAPSHOT_NUMBER'). 2019-03-01 12:14:14 -03:00
Dmitry Yemanov
37e5a89d8f Misc docs fixes 2019-01-28 09:48:05 +03:00
Dmitry Yemanov
932ca51574
Replication support (#182) 
* Initial implementation of replication

* Postfixes for configuration and Windows builds

* Misc Windows adjustments

* Forgotten changes from prior commits

* Last round (fingers crossed) of fixing the Windows build

* Improve self-documentation

* Misc improvements

* Updates the docs

* More configuration

* Frontported some remaining pieces

* Installation post-fixes

* Special permission for replication
 2019-01-25 12:09:01 +03:00
Adriano dos Santos Fernandes
558c69151b Improve RETURNING readme about usage of * (CORE-3808). 2019-01-22 12:20:42 -02:00
Adriano dos Santos Fernandes
d936c74cdd Misc. 2019-01-05 18:47:04 -02:00
AlexPeshkoff
38823d0184 Post-improvement for CORE-5970: added 3 useful related helper functions: base64_encode/decode and crc32 2019-01-05 18:29:03 +03:00
Adriano dos Santos Fernandes
ee05dbf7b9 Merge branch 'work/time-zone-support-mon' 2018-12-29 15:38:22 -02:00
Adriano dos Santos Fernandes
3ca18c540c Add config. parameter DefaultTimeZone. 2018-12-28 15:52:39 -02:00
Adriano dos Santos Fernandes
71bc2536f8 Improve named window documentation re. name scopes. 2018-12-16 18:27:00 -02:00
Adriano dos Santos Fernandes
9604d1c89a Misc. 2018-12-15 18:44:59 -02:00
AlexPeshkoff
9169049c28 Misc 2018-12-07 20:20:28 +03:00
AlexPeshkoff
38bc6242d4 Improved documentation 2018-12-07 20:17:39 +03:00
AlexPeshkoff
aacdeb274c Added 8 new builtin functions supporting various encryption algorithms 2018-12-07 11:17:06 +03:00
Mark Rotteveel
8af76dd576
Syntax correction FILTER 
FILTER-clause and OVER-clause are separately optional
 2018-11-30 14:56:52 +01:00