ViewVC Help

View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing

root/public/ibx/branches/udr/changelog

Comparing:
ibx/trunk/fbintf/changelog (file contents), Revision 338 by tony, Wed Jun 9 12:07:56 2021 UTC vs.
ibx/branches/udr/changelog (file contents), Revision 381 by tony, Sat Jan 15 00:06:22 2022 UTC

#	Line 1 | Line 1
1	<	FBINTF Change Log  version          (1.2-1 Build 12546) Wed, 09 Jun 2021 11:57:29 +0100
1	>	FBINTF Change Log  version          (1.4-0 Build 13090) Fri, 14 Jan 2022 23:07:28 +0000
2	>
3	>	1. Support package fbudr added for support of User Defined Routines (UDRs), and package
4	>	fbudrtestbed for client side debugging of UDR libraries.
5	>
6	>	2. Package layout changed with introduction of udr support. IB*.pas files moved from
7	>	root directory to "client". IBHeader move to "Client".
8	>
9	>	3. Delphi packages: all packages now compile .dcp and .bpi files to either
10	>	fbintf\Win32\Debug or fbintf\Win64\Debug by default. Please remove any pre-existing
11	>	fbintf.dcp and fbintf.bpi files from other locations.
12	>
13	>	4. Client side journaling support added. Interface changes
14	>	IAttachment
15	>	function JournalingActive: boolean;
16	>	function GetJournalOptions: TJournalOptions;
17	>	function StartJournaling(aJournalLogFile: AnsiString): integer; overload;
18	>	function StartJournaling(aJournalLogFile: AnsiString; Options: TJournalOptions): integer; overload;
19	>	function StartJournaling(S: TStream; Options: TJournalOptions): integer; overload;
20	>	procedure StopJournaling(RetainJournal: boolean);
21	>
22	>	5. Transactions may now be given a local transaction name:
23	>	IFirebirdAPI
24	>	function StartTransaction(Attachments: array of IAttachment;
25	>	TPB: array of byte; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
26	>	TPB: array of byte; DefaultCompletion: TTransactionCompletion=taCommit;
27	>	aName: AnsiString=''): ITransaction; overload;
28	>	function StartTransaction(Attachments: array of IAttachment;
29	>	TPB: ITPB; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
30	>	TPB: ITPB; DefaultCompletion: TTransactionCompletion=taCommit;
31	>	aName: AnsiString=''): ITransaction; overload;
32	>
33	>	IAttachment
34	>	function StartTransaction(TPB: array of byte; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
35	>	function StartTransaction(TPB: ITPB; DefaultCompletion: TTransactionCompletion=taCommit): ITransaction; overload;
36	>	function StartTransaction(TPB: array of byte;
37	>	DefaultCompletion: TTransactionCompletion=taCommit;
38	>	aName: AnsiString=''): ITransaction; overload;
39	>	function StartTransaction(TPB: ITPB;
40	>	DefaultCompletion: TTransactionCompletion=taCommit;
41	>	aName: AnsiString=''): ITransaction; overload;
42	>
43	>	ITransaction
44	>	function GetTransactionName: AnsiString;
45	>	procedure SetTransactionName(aValue: AnsiString);
46	>
47	>	6. Additional Transaction information
48	>	ITPB.function AsText: AnsiString; {Returns TPB as a text string}
49	>
50	>	ITransaction
51	>	function GetDefaultCompletion: TTransactionCompletion;
52	>	function GetJournalingActive(attachment: IAttachment): boolean; {attachment must be specified when multi-database transaction}
53	>
54	>	7. New IAttachment helper functions
55	>	function HasTable(aTableName: AnsiString): boolean;
56	>	function HasFunction(aFunctionName: AnsiString): boolean;
57	>	function HasProcedure(aProcName: AnsiString): boolean;
58	>	function GetAttachmentID: integer;
59	>	function GetCharSetID: integer;
60	>
61	>	8. IStatement: if the BatchRowLimit is set to maxint, the maximum possible buffer size
62	>	will be allocted for batch operations.
63	>
64	>	9. IStatement, IColumnMetaData and ISQLParam all now consistently provide:
65	>	function GetStatement: IStatement;
66	>	function GetTransaction: ITransaction;
67	>	function GetAttachment: IAttachment;
68	>
69	>	10. Internal: a more disciplined approach to the handling of Firebird.IReferenceCounted
70	>	interfaces.
71	>
72	>	11. New interface type: IFBNumeric. IFBNumeric is implemented in the unit FBNumeric
73	>	and concentrates all handling of Fixed Point numbers. New ISQLItem and ISQLParam
74	>	functions getAsNumeric and setAsNumeric allow for direct retrival and manipulation
75	>	of numerics without loss of precision.
76	>
77	>	12. TryStrToNumeric and NumericToDouble moved from IBUtils to FBNumeric.
78	>
79	>	13. ISQLParams new method "Clear"
80	>
81	>	14. Connection Info (e.g. ODS Version, Remote Protocol) now retrieved on first
82	>	request rather than on attachment connect.
83	>
84	>
85	>	FBINTF Change Log  version          (1.3-3 Build 12935) Mon, 06 Dec 2021 23:17:13 +0000
86	>
87	>	1. Fix compile error with fpc trunk (3.3.1 and later), due to type change to tzname in "unix" unit.
88	>
89	>	2. Remove constraint in IAttachment.HasScollableCursors that returned false when
90	>	using remote protocol. Scrollable cursors with remote database expected to
91	>	be support for Firebird 4.0.1 onwards. Note: Firebird 4.0.0 will return
92	>	a not supported error.
93	>
94	>	3. IStatement: new function;
95	>	TStatementFlag = (stHasCursor,stRepeatExecute,stScrollable);
96	>	TStatementFlags = set of TStatementFlag;
97	>	function GetFlags: TStatementFlags;
98	>
99	>	4. Revised behaviour for IStatement.ExecuteQuery in order to preserve backwards
100	>	compatibility.
101	>	In Firebird 5, Update..Returning may returns multiple rows and hence the statemen
102	>	type changes from ExecProcedure to Select. So that ExecuteQuery can continue
103	>	to be used with Update...Retruning statements that return a singleton row,
104	>	instead of raising an exception when ExecuteQuery is used with a (SELECT) statement,
105	>	it will open the cursor and return the first row only.
106	>
107	>	5. ITransaction: new functions:
108	>	function GetIsReadOnly: boolean;
109	>	function GetTransactionID: integer;
110	>	function GetTrInformation(Requests: array of byte): ITrInformation; overload;
111	>	function GetTrInformation(Request: byte): ITrInformation; overload;
112	>
113	>	The latter two return the Transaction Information block. The first two extract
114	>	information the Transaction Information block
115	>
116	>	6. New function TSQLTokeniser.ReadCharacters
117	>	Used internally.
118	>
119	>	7. IStatement: GetProcessedSQL bug fix. No longer raises and error if SQL contains
120	>	parameter placeholders instead of named parameters.
121	>
122	>	8. ITransaction (Firebird 3 and later): An exception raised when freeing an underlying
123	>	transaction handle is now ignored if Rollback/Commit is called with Force=true
124	>
125	>	9. Tidy up of exception handling code. Under the legacy API, fb_interpret is now
126	>	used to get an IBError Message instead of isc_interprete.
127	>
128	>	10. Internal tidyup. Native code now used for decoding integers and the events
129	>	buffer. Avoids dependencies on fbclient functions isc_portable_integer,
130	>	isc_event_block and isc_event_counts.
131	>
132	>	11. New IAttachment function
133	>	function GetAttachmentID: integer;
134	>
135	>	12. Internal changes to TFBClientAPI, TFBAttachment and TFBTransaction and TFB30
136	>	subclasses to enable UDR support.
137	>
138	>	FBINTF Change Log  version          (1.3-2 Build 12889) Sun, 24 Oct 2021 13:49:28 +0100
139	>
140	>	1. TFBClientAPI.GetProcAddr. Add check for nil reference.
141	>
142	>	2. IStatement: new methods:
143	>	procedure SetStaleReferenceChecks(Enable:boolean); {default true}
144	>	function GetStaleReferenceChecks: boolean;
145	>
146	>	In previous versions, stale reference checks were always enabled. This allows the
147	>	user to disable them on a per statement basis. Note this can risk out-of-date
148	>	statement BLR. See User Guide.
149	>
150	>	3. IBUtils: TSQLwithNamedParamsTokeniser now recognises a CASE...END block within a
151	>	stored procedure and hence avoids replacing named parameters within a containing
152	>	BEGIN..END block.
153	>
154	>	4. ISQLParam: using a string value to set an integer field with a scale factor of
155	>	zero is now treated as a special case to avoid the risk of floating point
156	>	rounding errors affecting pure integers.
157	>
158	>	5. ISQLParam:  Review and tidy-up of SetAsString for numeric types.
159	>
160	>	6. ISQLParam is now subclassed from IParamMetaData, which provides access to the mutable
161	>	SQL Parameter metadata (methods moved from ISQLParam).
162	>
163	>	7. ISQLParam: new method
164	>	function getColMetadata: IParamMetaData;
165	>	This instance of IParamMetaData returns the original column metadata which is unmutable.
166	>	Note: ISQLParam metadata can change after a parameter value has been set e.g when
167	>	setting a VARCHAR column to an integer value.
168	>
169	>	8. IStatement: can now set cursor name when opening a cursor. New overloaded method:
170	>	procedure Prepare(CursorName: AnsiString; aTransaction: ITransaction=nil); overload;
171	>	also IAttachment:
172	>	function Prepare(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer; CursorName: AnsiString=''): IStatement; overload;
173	>	function Prepare(transaction: ITransaction; sql: AnsiString; CursorName: AnsiString=''): IStatement; overload;
174	>	function PrepareWithNamedParameters(transaction: ITransaction; sql: AnsiString;
175	>	aSQLDialect: integer; GenerateParamNames: boolean=false;
176	>	CaseSensitiveParams: boolean = false; CursorName: AnsiString=''): IStatement; overload;
177	>	function PrepareWithNamedParameters(transaction: ITransaction; sql: AnsiString;
178	>	GenerateParamNames: boolean=false;
179	>	CaseSensitiveParams: boolean = false; CursorName: AnsiString=''): IStatement; overload;
180	>
181	>	9. Support for scrollable cursors added. New/updated methods:
182	>	IAttachment:
183	>	function HasScollableCursors: boolean;
184	>	function OpenCursor(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer;
185	>	Scrollable: boolean=false): IResultSet; overload;
186	>	function OpenCursor(transaction: ITransaction; sql: AnsiString; Scrollable: boolean=false): IResultSet; overload;
187	>	function OpenCursor(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer; Scrollable: boolean;
188	>	params: array of const): IResultSet; overload;
189	>	function OpenCursor(transaction: ITransaction; sql: AnsiString; Scrollable: boolean=false;
190	>	params: array of const): IResultSet; overload;
191	>	function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer; Scrollable: boolean;
192	>	params: array of const): IResultSet; overload;
193	>	function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; aSQLDialect: integer;
194	>	Scrollable: boolean=false): IResultSet; overload;
195	>	function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; Scrollable: boolean=false): IResultSet; overload;
196	>	function OpenCursorAtStart(transaction: ITransaction; sql: AnsiString; Scrollable: boolean;
197	>	params: array of const): IResultSet; overload;
198	>	function OpenCursorAtStart(sql: AnsiString; Scrollable: boolean=false): IResultSet; overload;
199	>	function OpenCursorAtStart(sql: AnsiString; Scrollable: boolean;
200	>	params: array of const): IResultSet; overload;
201	>	IStatement:
202	>	function OpenCursor(Scrollable: boolean; CursorName: AnsiString =''; aTransaction: ITransaction=nil): IResultSet; overload;
203	>	IResultSet:
204	>	function FetchPrior: boolean; {fetch previous record}
205	>	function FetchFirst:boolean; {fetch first record}
206	>	function FetchLast: boolean; {fetch last record}
207	>	function FetchAbsolute(position: Integer): boolean; {fetch record by its absolute position in result set}
208	>	function FetchRelative(offset: Integer): boolean; {fetch record by position relative to current}
209	>	function IsBof: boolean;
210	>
211	>	10. IArray: tidyup of SetAsString method to ensure correct handling of fixed point numbers.
212	>
213	>	11. IBUtils: TSQLTokeniser. CRLF now combined by low level parser into sqltEOL token. This
214	>	may be noticeable when a line separator occurs inside quoted text. The quoted text
215	>	output by the tokeniser will now use the platform specific lineEnding regardless
216	>	of whether the input uses the CRLF or LF as a line separator.
217	>
218	>	12. IStatement, IResultsSet: Support for scrollable cursors added (note: local databases only)
219	>
220	>
221	>	FBINTF Change Log  version          (1.3-1 Build 12776) Mon, 23 Aug 2021 11:09:33 +0100
222	>
223	>	1. Integer decodes in information blocks (e.g. IDBInfoItem) widened from 32 bit to 64-bit integers.
224	>
225	>	2. Support for inline blob encoding. Blob values pass using the "SetAsString" method
226	>	will now be encoded inline (i.e. as part of the parameter buffer) if they are
227	>	shorter than a pre-set limit. Longer values continue to be saved as blobs as a
228	>	separate server interaction. This is intended as a performance optimisation.
229	>
230	>	The pre-set limit defaults to 8192 bytes and can be inspected/modified using the new
231	>	IAttachment interface functions:
232	>
233	>	function GetInlineBlobLimit: integer;
234	>	procedure SetInlineBlobLimit(limit: integer);
235	>
236	>	3. Support for Firebird 4 IBatch interface added. This is largely transparent to the API
237	>	user as the functionality is embedded in the implementation of the IStatement
238	>	interface. Three new functions are defined:
239	>
240	>	procedure AddToBatch;
241	>	function ExecuteBatch(aTransaction: ITransaction=nil): IBatchCompletion;
242	>	procedure CancelBatch;
243	>	function GetBatchCompletion: IBatchCompletion;
244	>	function GetBatchRowLimit: integer;
245	>	procedure SetBatchRowLimit(aLimit: integer);
246	>
247	>	Also
248	>
249	>	function IsInBatchMode: boolean;        {true after call to execute(eaDefer)}
250	>	function HasBatchMode: boolean;         {true if and only if IBatch Supported}
251	>
252	>	For more information see the User Guide.
253	>
254	>	4. Default error message contents. Now aligned with User Guide section 10.2 i.e. error messages
255	>	provided with the EIBInterBaseError now include all three parts.
256	>
257	>	5. Firebird.pas and include files updated to Firebird 4.0.0
258	>
259	>	6. New IStatement method: function GetSQLStatementTypeName: AnsiString;
260	>	Returns SQL Statement type as a text string;
261	>
262	>	7. ISQLData.AsInteger and AsInt64 now use "Round" to convert a float field to
263	>	an integer instead of "trunc". This is for compatibility with TFloatField.AsInteger.
264	>
265	>	FBINTF Change Log  version          (1.2-1 Build 12552) Wed, 09 Jun 2021 13:05:40 +0100
266
267		1. Big fix for Firebird 4.0. A internal change in Firebird 4.0.0 from RC1 flushed out a
268		typo in FB30Statement.pas that caused an unknown parameter error.

Comparing:
ibx/trunk/fbintf/changelog (property svn:eol-style), Revision 338 by tony, Wed Jun 9 12:07:56 2021 UTC vs.
ibx/branches/udr/changelog (property svn:eol-style), Revision 381 by tony, Sat Jan 15 00:06:22 2022 UTC

#	Line 0 | Line 1
1	+	native

Diff Legend

–	Removed lines
+	Added lines
<	Changed lines
>	Changed lines