8
0
mirror of https://github.com/FirebirdSQL/firebird.git synced 2025-01-22 20:43:02 +01:00
Commit Graph

466 Commits

Author SHA1 Message Date
asfernandes
359f74e73a Misc. 2011-12-24 18:08:13 +00:00
asfernandes
1bb24e6c08 Fixed CORE-3238 - Makes GEN_UUID return a compliant RFC-4122 binary UUID and introduce CHAR_TO_UUID2 and UUID_TO_CHAR2 to convert UUIDs from/to string also complying with the RFC. 2011-12-20 14:30:41 +00:00
asfernandes
a25584f7a2 Fixed CORE-3382 - Incomplete description of POSITION() function. 2011-12-06 14:38:49 +00:00
asfernandes
906ea4729e Misc. 2011-10-27 01:04:14 +00:00
asfernandes
372d48c97b Improvement CORE-3639 - Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification.
Also updated MERGE and RETURNING docs, and fixed a bug with MERGE WHEN MATCHED DELETE and RETURNING.
2011-10-23 01:31:11 +00:00
robocop
ec9ec671c4 Misc. 2011-04-01 04:03:49 +00:00
asfernandes
dfe830af7c Added EVENT_TYPE and OBJECT_TYPE to DDL_TRIGGER context. Improvement suggested by Thomas Steinmaurer. 2011-02-20 01:08:48 +00:00
asfernandes
e623bb4bf1 Misc 2011-02-18 00:52:10 +00:00
hvlad
9f5a439868 Fixed bug CORE-3349 : Constants isc_lock_conflict / isc_eds_statement not recognized in PSQL 2011-02-14 15:21:07 +00:00
hvlad
ff4baf32a8 Correction 2011-02-13 19:16:16 +00:00
asfernandes
9a9a5f2570 Fixed doc. mismatch reported by Paul Vinkenoog 2010-09-10 01:59:19 +00:00
dimitr
d29c9df5cf CORE-3102 (minor documentation mistake) 2010-08-09 14:50:11 +00:00
asfernandes
087b3c8fba Misc 2010-06-18 13:13:37 +00:00
asfernandes
79029ac87d Misc 2010-06-18 12:41:59 +00:00
robocop
f08b9d9a71 Misc. 2010-03-19 07:04:39 +00:00
hvlad
8e3eb47de9 Update documentation 2010-03-18 11:52:07 +00:00
robocop
d74b3f4774 Misc. 2010-01-15 05:13:43 +00:00
asfernandes
e0ce09805a Remove the not agreed feature. Bad, bad... 2010-01-15 03:00:15 +00:00
asfernandes
7c59c445e7 Misc 2010-01-14 16:47:47 +00:00
asfernandes
9c1bab1793 Feature CORE-1385 Identity columns - in its basic form 2010-01-13 19:14:15 +00:00
robocop
7f4e9cedc3 Misc. 2010-01-10 09:20:16 +00:00
asfernandes
72fab0e317 Update way to deliver parameterized exceptions so the client doesn't need special handling 2010-01-08 14:13:12 +00:00
asfernandes
be859980ea Feature CORE-832 - Parameterized exceptions 2010-01-07 00:16:50 +00:00
robocop
e229d40d8c Misc. 2009-12-29 07:08:59 +00:00
asfernandes
c9b8938854 Package example 2009-11-14 20:17:30 +00:00
robocop
6cce8ea94e Misc. 2009-11-09 10:41:21 +00:00
asfernandes
ad7ec2bb48 Doc. typo 2009-10-22 00:21:41 +00:00
robocop
9e6a713f0f Misc. 2009-10-21 07:25:43 +00:00
asfernandes
ed0e0daeb3 - External Engines implementation.
- Plugins API.

- Feature CORE-2700 - UDR (User Defined Routines) Engine - C++ API supporting functions, triggers and stored procedures.
- Feature CORE-2470 - Support for alternate format of strings literals.
- Feature CORE-2310 - DDL triggers.
- Feature CORE-2312 - PSQL Packages.
- Feature CORE-1209 - CONTINUE statement.
- Feature CORE-1180 - DDL syntax to change (not) nullable state of columns.
- Feature CORE-2090 - Support OVER () clause with current aggregate functions.

- Fixed CORE-2699 - Common table expression context could be used with parameters.

- Introduce ODS 12.0.

- Work in progress in type-safe parser.
- Refactor some DDL commands (procedures and triggers) from DYN to DdlNodes.
- Refactor virtual tables to use a class hierarchy instead of namespaces. This is basic thing, not based on the changes done in Vulcan. Window functions is based on this work.
- Refactor COMMENT ON and DROP FUNCTION from DYN to DdlNodes. COMMENT ON do not use GDML anymore, it uses DSQL with PreparedStatement class.
- Refactor EXECUTE BLOCK to StmtNodes.
- Refactor the IUDF to SysFunctions. That eliminates RDB$GET_CONTEXT and RDB$SET_CONTEXT from RDB$FUNCTIONS.
2009-10-21 00:42:38 +00:00
robocop
4d468895ea Misc & style. 2009-05-17 11:20:43 +00:00
asfernandes
c991e7d5cf Misc 2009-05-15 00:51:21 +00:00
hvlad
e001741d4b Documentation for improvement CORE-2452 : Add Role Name in input parameters for EXECUTE STATEMENT 2009-05-14 10:37:51 +00:00
asfernandes
9e0c4f06f2 Misc 2009-04-04 16:28:33 +00:00
alexpeshkoff
77498cac9b Fixed some warnings 2009-04-03 10:49:07 +00:00
asfernandes
f0de59cde9 Misc 2009-02-13 21:08:56 +00:00
robocop
6612f1b08c Misc. 2009-02-13 07:48:28 +00:00
hvlad
943fbe0e90 Update documentation 2009-02-12 09:34:00 +00:00
dimitr
38cc346f86 Updated docs. Getting prepared for Beta. 2009-01-29 11:52:47 +00:00
alexpeshkoff
203cf9afdb added readme for CORE-2113 2008-11-30 17:45:47 +00:00
robocop
586c3a6cde CORE-1799: improve the almost useless "expression evaluation not supported" error message.
Did the JRD side except par.cpp because this part is covered by DSQL (only ESQL programs won't get the improved messages).
2008-10-03 05:41:16 +00:00
dimitr
3734b9099f Correction. 2008-07-04 05:05:08 +00:00
asfernandes
17c20e8392 1) Fixed CORE-1935 – SIMILAR TO character classes are incorrectly recognized.
2) Improve the documentation after some questions from Claudio.
2008-06-14 02:17:20 +00:00
robocop
a44eede5c4 Correction. 2008-06-13 11:07:41 +00:00
robocop
25b9ff2277 Misc. 2008-06-13 11:02:17 +00:00
asfernandes
ba55f64dd7 Put in the tree the docs previo usly done in the wiki as per Dmitry request 2008-06-12 01:02:00 +00:00
alexpeshkoff
635ba3ea00 Added documentation for GRANTED BY clause 2008-06-10 11:00:19 +00:00
robocop
99dfcbedc3 Misc. 2008-06-10 10:17:20 +00:00
hvlad
9b0c5b706f Updated documentation 2008-06-09 09:29:28 +00:00
asfernandes
e35a4764ce Documentation for hexadecimal numeric and binary strings literals 2008-05-15 15:28:32 +00:00
alexpeshkoff
0c63e27b57 misc 2008-05-15 15:19:14 +00:00
hvlad
8cf8a6b00b Correctly written my name and e-mail 2008-05-13 07:26:32 +00:00
asfernandes
453721c881 Documentation for ALTER VIEW 2008-05-13 00:59:49 +00:00
alexpeshkoff
5a28de37be added doc 2008-05-12 16:09:30 +00:00
asfernandes
7d34ead84e 1) Allow to reference others fields in the expression of ALTER...COMPUTED
2) Documentation
2008-05-11 20:05:12 +00:00
asfernandes
8b4a83f201 Misc 2008-05-11 03:00:46 +00:00
asfernandes
6e827b8633 Documentation for CHAR_TO_UUID and UUID_TO_CHAR 2008-05-09 15:27:31 +00:00
asfernandes
5575f29694 Update doc. 2008-04-25 11:00:55 +00:00
asfernandes
5a059b20c0 Misc 2008-04-16 02:09:14 +00:00
robocop
3d750c2bf1 Enable WEEK for dateAdd and dateDiff. 2008-04-14 13:21:05 +00:00
robocop
d54a9f7ef6 - Let BIN_AND, BIN_OR and BIN_XOR take two params as minimum.
- Implement BIN_NOT.
2008-04-14 11:09:16 +00:00
asfernandes
aab534e66c 1) Misc 2) Remove temp. comment found by Claudio 2008-04-13 14:38:39 +00:00
robocop
bf0db00991 Misc. 2008-04-13 06:40:26 +00:00
hvlad
7f836bb8e7 Update documentation. 2008-04-12 21:13:19 +00:00
robocop
62a2cddd9d I consider useful to be able to add weeks or get differences in weeks without going back and forth with *7 or /7, but if others want to follow the standard literally and leave week only as week number in a year... 2008-04-12 13:40:48 +00:00
robocop
7cc216e732 Update doc for DATEADD and DATEDIFF. 2008-04-12 12:43:58 +00:00
dimitr
191a8fca58 Update. 2008-04-10 10:54:26 +00:00
asfernandes
0e8febd6e3 Misc 2008-04-10 02:35:30 +00:00
hvlad
0809f1f1c6 Documentation for EXECUTE STATEMENT with support of external data sources 2008-04-09 22:20:17 +00:00
asfernandes
0adc1aa1f9 Misc 2008-04-04 02:14:17 +00:00
dimitr
5b0b26982b Update. 2008-04-03 09:05:48 +00:00
dimitr
887206e65b The merge is being fixed. 2008-01-16 13:38:46 +00:00
dimitr
099f99cde2 Fixed docs. 2007-12-04 08:29:10 +00:00
robocop
1c4d0a2629 Misc. 2007-12-04 08:23:13 +00:00
asfernandes
34e2843708 Change function description 2007-11-30 13:49:09 +00:00
asfernandes
40997f0bc8 Task CORE-1618 - Change GBAK option to not run database triggers to use the same name as the ISQL equivalent option 2007-11-26 14:26:46 +00:00
asfernandes
4e47cd4846 Feature CORE-1511 - POSITION(string_exp1, string_exp2 [, start]) 2007-11-12 00:31:11 +00:00
asfernandes
ca7004e241 1) Fixing another case of CORE-1514 - Many new 2.1 built in functions have incorrect NULL semantics
2) Improvement CORE-1569 - ROUND function second parameter - make optional like TRUNC
2007-11-12 00:02:18 +00:00
asfernandes
78e4d71ee1 Remove weekday support in DATEADD/DATEDIFF - CORE-1526 2007-10-23 14:14:23 +00:00
asfernandes
ed67711a48 Update 2007-10-08 01:21:39 +00:00
asfernandes
3ed4d0373a Misc 2007-10-06 16:07:31 +00:00
asfernandes
d8dde42d07 Fixed CORE-1490 - New builtin function DATEDIFF() implements wrong choice of keywords for expanded syntax 2007-10-02 15:37:38 +00:00
dimitr
1c5c4e0feb Corrections for v2.0 and above. 2007-07-03 12:10:22 +00:00
asfernandes
e25dcbc17c Improvement CORE-1340 - Add a scale parameter to TRUNC function 2007-07-03 00:09:39 +00:00
asfernandes
1a427efe19 Changed UPDATE OR INSERT to check existence of records with IS NOT DISTINCT 2007-05-13 14:06:41 +00:00
asfernandes
6cafdc1738 Removed incorrect note 2007-05-11 11:18:40 +00:00
asfernandes
620d0550d0 Updated LIST documentation - thanks to Maycon Ferraça 2007-05-09 15:23:33 +00:00
asfernandes
fd33f237d2 Doc. for new join types 2007-05-03 01:32:08 +00:00
asfernandes
b06deea4c6 CORE-1226: Allow RETURNING in INSERT...SELECT, UPDATE and DELETE 2007-04-24 15:22:05 +00:00
robocop
fe757d1562 Misc. 2007-04-24 06:11:08 +00:00
asfernandes
348e167309 Some more info proposed by Claudio 2007-04-21 21:27:22 +00:00
robocop
538fea0157 Misc. 2007-04-15 11:56:14 +00:00
asfernandes
737a1b2e55 Documentation for new builtin functions 2007-04-15 01:11:35 +00:00
dimitr
7fd8985732 Corrections. 2007-04-09 14:39:03 +00:00
asfernandes
773cd71543 Document the new context variable - thanks to Maicon Ferraça 2007-03-22 13:07:10 +00:00
dimitr
9f9d80f1b4 Docs. 2007-03-20 09:19:31 +00:00
robocop
7764abc795 Misc. 2007-03-15 09:35:57 +00:00
robocop
d455c9f170 Misc. 2007-03-15 09:14:00 +00:00
asfernandes
063c54bf8b Documentation for domains in PSQL 2007-03-14 13:58:40 +00:00
hvlad
b845c06efb Documentation for GTT and CTE features 2007-03-14 13:51:41 +00:00
asfernandes
9493f2fb66 Fix problems with COMMIT triggers:
1) Fix a problem when the transaction could not be commited due to errors in DFW.
2) Run triggers inside a savepoint when "preparing" the transaction.
3) More doc.
2007-01-06 23:54:23 +00:00
asfernandes
48d09afc20 More documentation for database triggers 2007-01-04 14:43:38 +00:00
asfernandes
5db5421a66 Misc 2006-12-30 16:55:06 +00:00
robocop
b6856f4287 Misc. 2006-12-30 06:03:16 +00:00
asfernandes
c80604c60e Document database triggers 2006-12-30 01:59:03 +00:00
asfernandes
71b71e3059 Correction - thanks to Maycon Ferraça 2006-12-14 10:30:46 +00:00
asfernandes
09ccfb5c6a Documentation for MERGE 2006-12-11 22:55:20 +00:00
asfernandes
5e818bd4a9 Rename REPLACE to UPDATE OR INSERT 2006-11-26 15:40:10 +00:00
dimitr
7c405166aa 1) Support for client PID in the monitoring data.
2) Changed XNET to return local hostname instead of PID as its remote address.
2006-09-14 13:47:31 +00:00
asfernandes
55ec30965d REPLACE statement 2006-09-03 01:09:23 +00:00
robocop
b43ad7ae16 Misc, adding example. 2006-07-31 07:42:47 +00:00
hvlad
240f5d25e7 Correct documentation for isc_info_creation_date 2006-02-09 07:48:14 +00:00
hvlad
0574ce4b5f Document isc_info_creation_date 2006-02-08 21:21:12 +00:00
hvlad
95deca1591 Typo's 2006-02-05 12:39:35 +00:00
hvlad
ba8dac922c Documentation for new isc_info_xxx calls 2006-02-05 12:33:54 +00:00
dimitr
43e6fc05c8 Corrections, thanks to Claudio. 2006-01-10 07:59:54 +00:00
dimitr
924400214f More docs. 2006-01-09 12:45:39 +00:00
dimitr
4ec2700475 Fixed typos. 2005-12-03 11:09:39 +00:00
robocop
24d11d0b36 Document the blob filter restriction in FB2. 2005-12-01 07:12:00 +00:00
robocop
322d28a1c7 Add documentation for the extra options exposed through the DSQL's SET TRANSACTION command. This functionality exists already using TPB's. 2005-12-01 02:34:47 +00:00
dimitr
d094341e79 Typo. 2005-10-21 09:49:22 +00:00
robocop
0d168fa72d Misc: missing double quote in readme. 2005-10-08 09:56:17 +00:00
dimitr
c7374d3a99 Updated docs. 2005-10-03 12:34:50 +00:00
dimitr
8b4ba818ee Updated docs. 2005-10-03 12:26:41 +00:00
robocop
ca33eef645 Update DDL documentation for setting/dropping default values in table fields. 2005-08-16 06:22:14 +00:00
dimitr
2f7b27ac45 Added some docs. 2005-07-05 08:07:38 +00:00
dimitr
5a42643c62 Added some docs. 2005-07-05 08:02:01 +00:00
asfernandes
59213efe7e Merge INTL branch into HEAD 2005-05-27 22:45:31 +00:00
robocop
83945cc239 Explain how metadata comments syntax works. 2005-05-17 07:21:56 +00:00
dimitr
e46c68c9d2 no message 2005-05-01 11:45:52 +00:00
robocop
055d3a4099 Update some docos. 2005-04-03 06:59:41 +00:00
robocop
5089939cd7 Write my pending documentation. 2005-03-10 02:35:55 +00:00
robocop
08cd3467ae Misc. 2005-02-11 07:06:14 +00:00
robocop
1dd20ab74c To do's. 2005-02-04 09:58:18 +00:00
skidder
e3f7b67f38 Update documentation for context variables 2005-02-02 03:59:30 +00:00
arnobrinkman
56892f3fb0 update readme's with method used for determing result data type 2005-02-01 23:55:56 +00:00
dimitr
f472ed3086 More docs. 2005-01-28 14:07:11 +00:00
robocop
89af0c2a66 Little corrections. 2005-01-28 06:52:37 +00:00
arnobrinkman
1f74a0a351 no message 2005-01-26 23:31:50 +00:00
hvlad
93042e65b2 New readme 2005-01-26 14:49:49 +00:00
robocop
607816519d Minor fixes. 2005-01-25 06:24:30 +00:00
dimitr
fe5aa5e822 Placeholders for further docs. 2005-01-22 21:18:33 +00:00
dimitr
dc04b6d07c More docs. 2005-01-22 21:13:15 +00:00
dimitr
a77d9e3a79 More docs. 2005-01-22 21:03:03 +00:00
dimitr
735f10b5a1 More docs. 2005-01-22 20:26:58 +00:00
dimitr
96f1156adf Some docs. 2005-01-20 12:35:38 +00:00
robocop
c4473d4071 Misc. 2005-01-07 03:56:29 +00:00
dimitr
d44367f80b Added some docs. 2005-01-06 18:32:22 +00:00
skidder
d417b0207b Preliminary explanation for new context variables logic 2004-11-23 05:26:19 +00:00
dimitr
c57ca98904 Corrected a typo. 2004-06-08 14:00:01 +00:00
hvlad
c0e9a56fc8 1. Added new EXECUTE BLOCK statement
2. Added 	default paremeters in stored procedures
2004-01-16 09:32:57 +00:00
dimitr
5dbdb1278d Added extra note. 2003-10-08 09:15:31 +00:00
alexpeshkoff
75c35844b8 Added security note 2003-10-06 13:22:11 +00:00
skidder
4234b34098 Fix typo 2003-07-31 11:54:46 +00:00
skidder
73d496463d Fix typo 2003-07-29 13:31:34 +00:00
skidder
9f6ac0a96f Added docs for savepoints 2003-07-29 11:33:26 +00:00
arnobrinkman
70ac4f226c Please give some comments 2003-07-29 00:55:34 +00:00
skidder
1ca335f68e Fix a couple typos 2003-07-28 09:29:40 +00:00
skidder
b607034b35 Correct docs a little 2003-07-28 09:21:08 +00:00
skidder
0e0aaf9c99 Some more docs 2003-07-27 18:00:43 +00:00
skidder
c0782b9bee Add docs for explicit locking 2003-07-27 15:44:37 +00:00
dimitr
37278240a9 no message 2003-07-15 10:32:02 +00:00
dimitr
ce14c3057d Added some documentation for RelNotes. More will follow shortly. 2003-07-15 09:09:28 +00:00
alexpeshkoff
fb2a367963 fixed word repetition 2003-06-22 11:52:43 +00:00
alexpeshkoff
852e6ff73f Initial revision of EXECUTE STATEMENT description 2003-06-18 13:29:09 +00:00
skywalker
ecb708e39f Update the description, it is now correct. 2002-08-09 07:25:49 +00:00
skywalker
47fc3374d0 documentation for new sql clauses case, coalesce and nullif
contributed by Arno Brinkman <firebird@abvisie.nl>
2002-08-08 23:33:23 +00:00