Menu
▾
▴
firebird-net-provider — All about development of the MS .Net provider
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(10) |
Nov
(55) |
Dec
(36) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(38) |
Feb
(108) |
Mar
(79) |
Apr
(95) |
May
(64) |
Jun
(130) |
Jul
(146) |
Aug
(121) |
Sep
(96) |
Oct
(149) |
Nov
(161) |
Dec
(113) |
| 2004 |
Jan
(113) |
Feb
(163) |
Mar
(248) |
Apr
(132) |
May
(157) |
Jun
(160) |
Jul
(236) |
Aug
(284) |
Sep
(293) |
Oct
(277) |
Nov
(257) |
Dec
(356) |
| 2005 |
Jan
(203) |
Feb
(190) |
Mar
(220) |
Apr
(165) |
May
(124) |
Jun
(160) |
Jul
(190) |
Aug
(142) |
Sep
(152) |
Oct
(189) |
Nov
(187) |
Dec
(159) |
| 2006 |
Jan
(170) |
Feb
(151) |
Mar
(212) |
Apr
(262) |
May
(226) |
Jun
(196) |
Jul
(223) |
Aug
(165) |
Sep
(163) |
Oct
(348) |
Nov
(225) |
Dec
(141) |
| 2007 |
Jan
(261) |
Feb
(161) |
Mar
(222) |
Apr
(193) |
May
(121) |
Jun
(157) |
Jul
(151) |
Aug
(159) |
Sep
(61) |
Oct
(123) |
Nov
(172) |
Dec
(96) |
| 2008 |
Jan
(104) |
Feb
(138) |
Mar
(131) |
Apr
(131) |
May
(74) |
Jun
(107) |
Jul
(89) |
Aug
(89) |
Sep
(172) |
Oct
(158) |
Nov
(119) |
Dec
(86) |
| 2009 |
Jan
(52) |
Feb
(84) |
Mar
(78) |
Apr
(83) |
May
(54) |
Jun
(79) |
Jul
(60) |
Aug
(62) |
Sep
(50) |
Oct
(147) |
Nov
(50) |
Dec
(70) |
| 2010 |
Jan
(135) |
Feb
(113) |
Mar
(74) |
Apr
(93) |
May
(35) |
Jun
(71) |
Jul
(33) |
Aug
(110) |
Sep
(47) |
Oct
(18) |
Nov
(61) |
Dec
(34) |
| 2011 |
Jan
(46) |
Feb
(47) |
Mar
(25) |
Apr
(24) |
May
(21) |
Jun
(22) |
Jul
(20) |
Aug
(51) |
Sep
(31) |
Oct
(42) |
Nov
(22) |
Dec
(22) |
| 2012 |
Jan
(31) |
Feb
(19) |
Mar
(25) |
Apr
(55) |
May
(16) |
Jun
(28) |
Jul
(33) |
Aug
(25) |
Sep
(32) |
Oct
(25) |
Nov
(52) |
Dec
(35) |
| 2013 |
Jan
(43) |
Feb
(18) |
Mar
(36) |
Apr
(45) |
May
(22) |
Jun
(13) |
Jul
(31) |
Aug
(24) |
Sep
(19) |
Oct
(59) |
Nov
(47) |
Dec
(25) |
| 2014 |
Jan
(27) |
Feb
(15) |
Mar
(38) |
Apr
(10) |
May
(15) |
Jun
(36) |
Jul
(24) |
Aug
(28) |
Sep
(16) |
Oct
(6) |
Nov
(44) |
Dec
(40) |
| 2015 |
Jan
(52) |
Feb
(22) |
Mar
(13) |
Apr
(17) |
May
(22) |
Jun
(36) |
Jul
(18) |
Aug
(41) |
Sep
(71) |
Oct
(60) |
Nov
(49) |
Dec
(43) |
| 2016 |
Jan
(60) |
Feb
(13) |
Mar
(21) |
Apr
(28) |
May
(23) |
Jun
(39) |
Jul
(17) |
Aug
(37) |
Sep
(33) |
Oct
(15) |
Nov
(22) |
Dec
(20) |
| 2017 |
Jan
(27) |
Feb
(40) |
Mar
(48) |
Apr
(19) |
May
(29) |
Jun
(2) |
Jul
(19) |
Aug
(36) |
Sep
(18) |
Oct
(10) |
Nov
(11) |
Dec
(5) |
| 2018 |
Jan
(5) |
Feb
(4) |
Mar
(5) |
Apr
(3) |
May
(4) |
Jun
(17) |
Jul
(7) |
Aug
(7) |
Sep
(12) |
Oct
(8) |
Nov
(2) |
Dec
|
| 2019 |
Jan
(8) |
Feb
(5) |
Mar
(3) |
Apr
(5) |
May
(3) |
Jun
(2) |
Jul
(8) |
Aug
(7) |
Sep
(3) |
Oct
(12) |
Nov
(7) |
Dec
(1) |
| 2020 |
Jan
(8) |
Feb
(3) |
Mar
(7) |
Apr
(1) |
May
(2) |
Jun
(1) |
Jul
(3) |
Aug
(25) |
Sep
(5) |
Oct
(3) |
Nov
(7) |
Dec
(16) |
| 2021 |
Jan
(11) |
Feb
(10) |
Mar
(16) |
Apr
(8) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: tonim (JIRA) <tr...@fi...> - 2020-07-30 13:26:01
|
Compression buffer too small error thrown
-----------------------------------------
Key: DNET-944
URL: http://tracker.firebirdsql.org/browse/DNET-944
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: vNext
Environment: Firebird.net provider selecting rows, more frequent selecting data containing blobs, for example SELECT * FROM RDB$PROCEDURES on a database width some procedures. You can reproduce the bug easily setting the CompressionBufferSize to 8192 for example
Reporter: tonim
Assignee: Jiri Cincura
Any environment, when selecting Compression=true in Connection string, more common selecting packetsize=32000
A big constant decompression buffer size is defined in FirebirdNetwordStream.
const int CompressionBufferSize = 1 * 1024 * 1024;
Any decompression bigger than this size throws an exception in HandleDecompression function.
I provide a tested fix, the buffer will grow dynamically, depending on the uncompressed size.
// There is no need to define a big buffer size, it will grow as needed
const int CompressionBufferSize = 32000;
int HandleDecompression(byte[] buffer, int count)
{
_decompressor.OutputBuffer = _compressionBuffer;
_decompressor.InputBuffer = buffer;
_decompressor.NextOut = 0;
_decompressor.NextIn = 0;
_decompressor.AvailableBytesIn = count;
do
{
// Double the buffer size until the decompression fits in the output buffer
_decompressor.OutputBuffer = _compressionBuffer;
_decompressor.AvailableBytesOut = _compressionBuffer.Length - _decompressor.NextOut;
var rc = _decompressor.Inflate(Ionic.Zlib.FlushType.None);
if (rc != Ionic.Zlib.ZlibConstants.Z_OK)
throw new IOException($"Error '{rc}' while decompressing the data.");
if (_decompressor.AvailableBytesIn != 0)
{
byte[] newCompressionBuffer = new byte[_compressionBuffer.Length * 2];
Array.Copy(_compressionBuffer, newCompressionBuffer, _decompressor.NextOut);
_compressionBuffer = newCompressionBuffer;
}
} while (_decompressor.AvailableBytesIn != 0);
return _decompressor.NextOut;
}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-07-16 09:05:56
|
Support for ChaCha
------------------
Key: DNET-943
URL: http://tracker.firebirdsql.org/browse/DNET-943
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-07-16 09:05:50
|
Support for Srp256
------------------
Key: DNET-942
URL: http://tracker.firebirdsql.org/browse/DNET-942
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider
Reporter: Jiri Cincura
Assignee: Jiri Cincura
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Luciano M. (JIRA) <tr...@fi...> - 2020-06-14 23:35:22
|
Windows Trusted Authentication (Win_Sspi) exception on Client PC when Firebird Server is version 3.0.5
------------------------------------------------------------------------------------------------------
Key: DNET-941
URL: http://tracker.firebirdsql.org/browse/DNET-941
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 7.5.0.0
Environment: Windows 10 Pro Version 1909
Firebird 3.0.5
Reporter: Luciano Mendes
Assignee: Jiri Cincura
Attachments: LOGIN_ERROR.png
ACTUAL RESULT:
Windows Trusted Authentication (Win_Sspi) exception on Client PC when Firebird Server is version 3.0.5 (See LOGIN_ERROR.png picture attached):
- 335544382 - Invalid clumplet buffer structure: buffer end before end of clumplet - clumplet too long
EXPECTED RESULT:
No Windows Trusted Authentication (Win_Sspi) exception should be happen on Client PC when Firebird Server is version 3.0.5
STEPS TO REPRODUCE THE ISSUE:
- Try to connect a Firebird 3.0.5 Database Server from a client PC using Windows Trusted Authentication (Win_Sspi)
IMPORTANT NOTES:
- This issue does NOT happen when Firebird server version is 2.5.9;
- If the .NET application (FirebirdSql.Data.FirebirdClient 7.5.0) is installed on the same PC where Firebird 3.0.5 is installed (Server), the .NET application can authenticate via Windows Trusted Authentication (Win_Sspi) without any issue;
- The issue is only reproducible if the .NET application is installed on a client PC;
- The .NET application authentication via user/password (Srp) works perfectly on both the server PC and the client PC;
- The Windows Trusted Authentication (Win_Sspi) using the native Firebird 3.0.5 (fbclient.dll - FlameRobin) library is working perfectly on both the server PC and the client PC;
- The issue is the same described in the following Firebird FAQ: http://www.firebirdfaq.org/faq320/
ENVIRONMENT SETUP
===firebird.conf===
#SETUP
AuthClient = Legacy_Auth, Srp, Win_Sspi
AuthServer = Legacy_Auth, Srp, Win_Sspi
ServerMode = Super
UserManager = Legacy_UserManager, Srp
WireCrypt = Enabled
#PERFORMANCE
DefaultDbCachePages = 30K
FileSystemCacheThreshold = 2M
LockHashSlots = 30011
LockMemSize = 15M
RemoteServicePort = 3050
TempBlockSize = 2M
TempCacheLimit = 3000M
#SECURITY
DatabaseAccess = None
SecurityDatabase = $(dir_secDb)/security3.fdb
=============================
Database Page Size: 8192
=== ADO.NET Connection String ===
var fbConnectionStringBuilder = new FbConnectionStringBuilder
{
Pooling = true,
ServerType = FbServerType.Default,
DataSource = Properties.Settings.Default.Server,
Database = Properties.Settings.Default.Database,
Charset = "WIN1252",
Role = "RDB$ADMIN"
};
================
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Lars W. (JIRA) <tr...@fi...> - 2020-05-29 11:01:18
|
Events dont get triggered after online -> shutdown -> online
------------------------------------------------------------
Key: DNET-940
URL: http://tracker.firebirdsql.org/browse/DNET-940
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 7.5.0.0
Reporter: Lars Weber
Assignee: Jiri Cincura
The problem we are having is that already queued events are not received by the EventHandler after the database has been shutdown and brought back online.
The RemoveEventError handler does not throw an event that the application could react on and reregister the events.
The application is requiered to be restarted, as the database events are registered on application startup.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Yuriy (JIRA) <tr...@fi...> - 2020-05-19 12:56:30
|
IIS with Firebird Embeded uses dll and installer cannot overwrite them
----------------------------------------------------------------------
Key: DNET-939
URL: http://tracker.firebirdsql.org/browse/DNET-939
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework
Affects Versions: 6.7.0.0
Environment: Windows 10 IIS
Reporter: Yuriy
Assignee: Jiri Cincura
IIS with .NET provider 6.7.0.0 for entity framefork 6 and Firebird Embeded uses dll and installer cannot overwrite or delete them sometimes during new installation or uninstaling website.
Is this fixed in future releases? Or we should do some shutdown call to firebird before install uninstall website
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Krosaci (JIRA) <tr...@fi...> - 2020-04-01 09:29:10
|
ArgumentOutOfRangeException
---------------------------
Key: DNET-938
URL: http://tracker.firebirdsql.org/browse/DNET-938
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 6.4.0.0
Environment: Firebird net provider 6.4.0 and Firebird server 2.5.4.
Reporter: Krosaci
Assignee: Jiri Cincura
Hello, I ran on specific problem on Firebird net provider (ver. 6.4.0) . Sometimes (once or two times a month) on some machines provider throws after calling Begin Transaction ArgumentOutOfRangeException. Look at callstack:
System.ArgumentOutOfRangeException: operation=159
Parameter name: operation
at FirebirdSql.Data.Client.Managed.GdsConnection.ProcessOperation(Int32 operation, XdrStream xdr)
at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadSingleResponse()
at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse()
at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse()
at FirebirdSql.Data.Client.Managed.Version10.GdsTransaction.BeginTransaction(TransactionParameterBuffer tpb)
at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.BeginTransaction(TransactionParameterBuffer tpb)
at FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction(FbTransactionOptions options)
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.BeginTransaction(FbTransactionOptions options, String transactionName)
at FirebirdSql.Data.FirebirdClient.FbConnection.BeginTransaction(FbTransactionOptions options)
Or sometimes it throws similar exception but with parameter operation =-16777216.
We are using Firebird server 2.5.4.
Thanks for any advice to resolve this issue.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Daniel R. (JIRA) <tr...@fi...> - 2020-03-19 20:28:14
|
SQL for DbFunctions.CreateDateTime does not work
------------------------------------------------
Key: DNET-937
URL: http://tracker.firebirdsql.org/browse/DNET-937
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework
Affects Versions: 7.5.0.0
Reporter: Daniel Richter
Assignee: Jiri Cincura
Calling the DbFunctions method
CreateDateTime(int? year,int? month,int? day,int? hour,int? minute,double? second)
generates SQL code that is not executable.
The SQL generating method (HandleCanonicalFunctionCreateDateTime) assumes that all parameters are constants and all parameters are not null. Additionally, the parameter for seconds is of type double so the generated SQL contains a CAST inside a timestamp literal (so it won't work even if all parameters a non-null constants).
The call DbFunctions.CreateDateTime(2020,3,19,12,0,0) is translated to
CAST('2020-3-19 12:0:CAST(0 AS DOUBLE PRECISION)' AS TIMESTAMP)
The call DbFunctions.CreateDateTime(2020,3,19,null,null,null) is translated to
CAST('2020-3-19 NULL:NULL:NULL' AS TIMESTAMP)
The call DbFunctions.CreateDateTime(c.BirthYear,1,1,null,null,null) is translated to
CAST('"C"."BIRTHYEAR"-1-1 NULL:NULL:NULL' AS TIMESTAMP)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Foodstuffs I. t. (JIRA) <tr...@fi...> - 2020-03-18 22:09:13
|
win_sspi auth info overflows isc_dpb_version1 parameter block
-------------------------------------------------------------
Key: DNET-936
URL: http://tracker.firebirdsql.org/browse/DNET-936
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 7.5.0.0
Environment: Windows 10 64-bit / Firebird 3.0.5 server
Reporter: Foodstuffs INCA team
Assignee: Jiri Cincura
Expected behaviour: .NET provider supports connections with Windows Trusted User authentication.
Actual behaviour: Windows Trusted User authentication connection fails with "Invalid clumplet buffer structure: buffer end before end of clumplet - clumplet too long".
Steps to reproduce:
PS C:\temp> Add-Type -Path FirebirdSql.Data.FirebirdClient.7.5.0.dll
>> $factory = [FirebirdSql.Data.FirebirdClient.FirebirdClientFactory]::Instance
>> $conn = $factory.CreateConnection()
>> $conn.ConnectionString = "Server=dvpapainca01;Port=3051;Database=incastatus;"
>> $conn.Open()
Exception calling "Open" with "0" argument(s): "Invalid clumplet buffer structure: buffer end before end of clumplet - clumplet too long"
At line:5 char:1
+ $conn.Open()
+ ~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : FbException
Description:
This appears to be a result of win_sspi auth info overflowing the isc_dpb_version1 block - presumably there is a Windows domain specific element to this?
By changing to isc_dpb_version2, the connection succeeds. I've attached a diff for this change below, but it's a naive solution - presumably there would be backwards compatibility issues with a straight switch.
PS C:\temp> Add-Type -Path FirebirdSql.Data.FirebirdClient.7.5.0+isc_dpb_version2.dll
>> $factory = [FirebirdSql.Data.FirebirdClient.FirebirdClientFactory]::Instance
>> $conn = $factory.CreateConnection()
>> $conn.ConnectionString = "Server=dvpapainca01;Port=3051;Database=incastatus;"
>> $conn.Open()
PS C:\temp> $conn
ConnectionString : Server=dvpapainca01;Port=3051;Database=incastatus;
ConnectionTimeout : 15
Database : incastatus
DataSource : dvpapainca01
ServerVersion : WI-V3.0.5.33220 Firebird 3.0/tcp (DVPAPAINCA01)/P13
State : Open
PacketSize : 8192
Site :
Container :
diff --git a/Provider/src/FirebirdSql.Data.FirebirdClient/Common/DatabaseParameterBuffer.cs b/Provider/src/FirebirdSql.Data.FirebirdClient/Common/DatabaseParameterBuffer.cs
index 4f10ee72..aa851e6e 100644
--- a/Provider/src/FirebirdSql.Data.FirebirdClient/Common/DatabaseParameterBuffer.cs
+++ b/Provider/src/FirebirdSql.Data.FirebirdClient/Common/DatabaseParameterBuffer.cs
@@ -31,21 +31,21 @@ namespace FirebirdSql.Data.Common
public void Append(int type, byte value)
{
WriteByte(type);
- WriteByte(1);
+ Write((int)1);
Write(value);
}
public void Append(int type, short value)
{
WriteByte(type);
- WriteByte(2);
+ Write((int)2);
Write(value);
}
public void Append(int type, int value)
{
WriteByte(type);
- WriteByte((byte)4);
+ Write((int)4);
Write(value);
}
@@ -57,7 +57,7 @@ namespace FirebirdSql.Data.Common
public void Append(int type, byte[] buffer)
{
WriteByte(type);
- WriteByte(buffer.Length);
+ Write((int)buffer.Length);
Write(buffer);
}
}
diff --git a/Provider/src/FirebirdSql.Data.FirebirdClient/Common/IscCodes.cs b/Provider/src/FirebirdSql.Data.FirebirdClient/Common/IscCodes.cs
index 65c5b4e7..76a0cf0a 100644
--- a/Provider/src/FirebirdSql.Data.FirebirdClient/Common/IscCodes.cs
+++ b/Provider/src/FirebirdSql.Data.FirebirdClient/Common/IscCodes.cs
@@ -224,6 +224,7 @@ namespace FirebirdSql.Data.Common
#region Database Parameter Block
public const int isc_dpb_version1 = 1;
+ public const int isc_dpb_version2 = 2; // sjd: support >256-byte entries - requires FB3 / protocol 13
public const int isc_dpb_cdd_pathname = 1;
public const int isc_dpb_allocation = 2;
public const int isc_dpb_journal = 3;
diff --git a/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbConnection.cs b/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbConnection.cs
index f6d38a65..aa79ab62 100644
--- a/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbConnection.cs
+++ b/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbConnection.cs
@@ -73,7 +73,7 @@ namespace FirebirdSql.Data.FirebirdClient
{
var dpb = new DatabaseParameterBuffer();
- dpb.Append(IscCodes.isc_dpb_version1);
+ dpb.Append(IscCodes.isc_dpb_version2);
dpb.Append(IscCodes.isc_dpb_dummy_packet_interval, new byte[] { 120, 10, 0, 0 });
dpb.Append(IscCodes.isc_dpb_sql_dialect, new byte[] { options.Dialect, 0, 0, 0 });
if (!string.IsNullOrEmpty(options.UserID))
diff --git a/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbConnectionInternal.cs b/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbConnectionInternal.cs
index e4890dcd..cec4413d 100644
--- a/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbConnectionInternal.cs
+++ b/Provider/src/FirebirdSql.Data.FirebirdClient/FirebirdClient/FbConnectionInternal.cs
@@ -402,7 +402,7 @@ namespace FirebirdSql.Data.FirebirdClient
{
var dpb = new DatabaseParameterBuffer();
- dpb.Append(IscCodes.isc_dpb_version1);
+ dpb.Append(IscCodes.isc_dpb_version2);
dpb.Append(IscCodes.isc_dpb_dummy_packet_interval, new byte[] { 120, 10, 0, 0 });
dpb.Append(IscCodes.isc_dpb_sql_dialect, new byte[] { options.Dialect, 0, 0, 0 });
dpb.Append(IscCodes.isc_dpb_lc_ctype, options.Charset);
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Daniel R. (JIRA) <tr...@fi...> - 2020-03-16 14:17:11
|
Add .editorconfig file
----------------------
Key: DNET-935
URL: http://tracker.firebirdsql.org/browse/DNET-935
Project: .NET Data provider
Issue Type: Improvement
Reporter: Daniel Richter
Assignee: Jiri Cincura
Priority: Trivial
Create an .editorconfig file basend on your current Visual Studio settings and add it so the GitHub repository.
https://docs.microsoft.com/en-us/visualstudio/ide/code-styles-and-code-cleanup?view=vs-2019
This would prevent e.g. messing up whitespace when developers with different VS settings edit code.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Daniel R. (JIRA) <tr...@fi...> - 2020-03-13 18:40:15
|
Cast of string values to VARCHAR(8191) results in "Implementation limit exceeded"
---------------------------------------------------------------------------------
Key: DNET-934
URL: http://tracker.firebirdsql.org/browse/DNET-934
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework
Affects Versions: 7.5.0.0
Reporter: Daniel Richter
Assignee: Jiri Cincura
For string values in queries, the generated SQL results in CASTs to VARCHAR(8191)
dataContext.Articles.Select(_ => new { A1 = "1A", A2 = "2A" })
generates SQL such as
SELECT CAST(_UTF8'1A' AS VARCHAR(8191)) AS "A1", CAST(_UTF8'2A' AS VARCHAR(8191)) AS "A2" FROM "ARTICLE"
In case the string value is used in multiple* columns, the SQL command execution results in an error "SQL error code = -204, Implementation limit exceeded, block size exceeds implementation restriction".
*) With charset UTF8 the query fails with 2+ columns using string values. The amount of string values used in the column does not seem to affect the outcome (50+ string values in one column still work).
With charset WIN1252 the query fails with 8+ columns using one string value. Using multiple string values in a column shows different results; in some cases, 8+ string values used in the entire query fails, in some cases not.
It does not matter whether the string value is used inline or as a captured variable (the cast is also inserted for those).
Because of the following code in SqlGenerator.cs, Visit(DbConstantExpression)
// constant is always considered Unicode
isUnicode = true;
var length = MetadataHelpers.GetFacetValueOrDefault<int?>(e.ResultType,MetadataHelpers.MaxLengthFacetName,null)
?? (isUnicode ? FbProviderManifest.UnicodeVarcharMaxSize : FbProviderManifest.AsciiVarcharMaxSize);
The length will result in FbProviderManifest.UnicodeVarcharMaxSize (8191).
Is the CAST to VARCHAR(n) really necessary? The following two solutions will work without problems (so far) for my use-case:
1) Don't pass the explicitLength parameter to FormatString (SqlGenerator.cs), so the length of the string value will be used:
SELECT CAST(_UTF8'ABC' AS VARCHAR(3)) AS "A1", CAST(_UTF8'DEFGH' AS VARCHAR(5)) AS "A2" FROM "ARTICLE"
2) Omit the CAST entirely.
SELECT _UTF8'ABC' AS "A1", _UTF8'DEFGH' AS "A2" FROM "ARTICLE"
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Daniel R. (JIRA) <tr...@fi...> - 2020-03-13 17:42:13
|
_UTF8 prefix for string values does not work with WIN1252 charset
-----------------------------------------------------------------
Key: DNET-933
URL: http://tracker.firebirdsql.org/browse/DNET-933
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework
Affects Versions: 7.5.0.0
Reporter: Daniel Richter
Assignee: Jiri Cincura
For string values in queries, the generated SQL results in inline values with the prefix "_UTF8". E.g,
dataContext.Articles.Where(a => a.Name=="Mülltüte")
generates SQL such as
SELECT * FROM "ARTICLE" WHERE "NAME"=_UTF8'Mülltüte'
That works as long as the connection charset is set to "UTF8". In case the connection string defines a charset such as "WIN1252" the execution throws an error "Dynamic SQL Error, SQL error code = -104, Malformed string" (when e.g. the value contains an umlaut).
After removing the "_UTF8" prefix everything works fine (both WIN1252 and UTF8 charset):
SELECT * FROM "ARTICLE" WHERE "NAME"='Mülltüte'
Because of the following code in SqlGenerator.cs, Visit(DbConstantExpression)
// constant is always considered Unicode
isUnicode = true;
The "_UTF8" prefix will always be generated - no matter which charset was used to connect.
In my opinion it is not possible to use string values in queries with charsets other than UTF8. The "_UTF8" prefix should only be added in case the database connection uses UTF8, too.
Otherwise: Is it safe to connect via UTF8 to a database with WIN1252 as charset for columns or are there any side effects?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Daniel R. (JIRA) <tr...@fi...> - 2020-03-13 15:57:17
|
Explicit CAST for Timestamp values
----------------------------------
Key: DNET-932
URL: http://tracker.firebirdsql.org/browse/DNET-932
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework
Affects Versions: 7.5.0.0
Reporter: Daniel Richter
Assignee: Jiri Cincura
For DateTime values, the generated SQL statement contains the formatted value in quotation marks. E.g.
dataContext.Orders.Where(o => o.OrderDate==new DateTime(2020,1,2));
generates SQL such as
SELECT * FROM "ORDERS" WHERE "ORDERDATE" = '2020-01-02 00:00:00.0000'
That does _not_ work in case the DateTime value is used as a parameter for a function/procedure. E.g.
dataContext.Orders.Select(o => new { Days = DbFunctions.DiffDays(o.OrderDate,new DateTime(2020,1,2) })
generates SQL such as
SELECT DATEDIFF(DAY, "ORDERDATE", '2020-01-02 00:00:00.0000') AS "DAYS" FROM "ORDERS"
results in the following error message: "expression evaluation not supported. Expected DATE/TIME/TIMESTAMP type as first and second argument to DATEDIFF"
The solution is quite simple - explicitly casting as TIMESTAMP in SQL (SqlGenerator.cs):
internal static string FormatDateTime(DateTime value)
{
var result = new StringBuilder();
result.Append("CAST(");
result.Append("'");
result.Append(value.ToString("yyyy-MM-dd HH:mm:ss.ffff", CultureInfo.InvariantCulture));
result.Append("' AS TIMESTAMP)");
return result.ToString();
}
internal static string FormatTime(DateTime value)
{
var result = new StringBuilder();
result.Append("CAST(");
result.Append("'");
result.Append(value.ToString("HH:mm:ss.ffff", CultureInfo.InvariantCulture));
result.Append("' AS TIME)");
return result.ToString();
}
The resulting SQL will be as follows:
SELECT DATEDIFF(DAY, "ORDERDATE", CAST('2020-01-02 00:00:00.0000' AS TIMESTAMP)) AS "DAYS" FROM "ORDERS"
I don't know any cases where an explicit cast (in comparison to the current implementation) should be an issue.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: kickinespresso (JIRA) <tr...@fi...> - 2020-03-11 17:27:15
|
Cannot Receive POST_EVENT Data from FirebirdSql.Data.FirebirdClient Events
--------------------------------------------------------------------------
Key: DNET-931
URL: http://tracker.firebirdsql.org/browse/DNET-931
Project: .NET Data provider
Issue Type: Bug
Affects Versions: 7.5.0.0
Environment: Windows 10, FireBird 2.5, .NET Core 3.1
Reporter: kickinespresso
Assignee: Jiri Cincura
annot Receive POST_EVENT Data from FirebirdSql.Data.FirebirdClient Events
Windows 10, FireBird 2.5, .NET Core 3.1
Using the code from the example here: https://github.com/FirebirdSQL/NETProvider/blob/ccb602aa4eb373267423c37bc176ff04fba1d099/Provider/docs/events.md
I am not able to receive POST_EVENT from FireBird.
I was able to use the FirebirdSql.EntityFrameworkCore.Firebird DB Content just fine. Docs here: https://github.com/FirebirdSQL/NETProvider/blob/master/Provider/docs/entity-framework-core.md
Here is my sample Code: https://github.com/cdesch/FireBirdConsoleExample
In my setup (below), I create the database, table and trigger. I also verified that they are working by assigning a new value to FooBar inside the trigger.
When listening for the event on the FirebirdSql.Data.FirebirdClient side, nothing happens.
What am I doing wrong?
/* Here is the Script I used for creating the Database */
CREATE DATABASE 'C:\data\demo.fdb' page_size 8192
user 'SYSDBA' password 'masterkey';
CONNECT "C:\data\demo.fdb"
user 'SYSDBA' password 'masterkey';
create table demo (id int primary key, foobar varchar(20) character set utf8);
insert into demo values (6, 'FooBar');
set term !! ;
CREATE TRIGGER NEW_DEMO_RECORD_TRIGGER FOR demo
ACTIVE before insert
AS BEGIN
IF (inserting) THEN
BEGIN
new.foobar = 'NewFoobar';
POST_EVENT 'NEWFOOBARD_POSTEVENT';
END
END!!
set term ; !!
insert into demo values (7, 'FooBar');
select * from demo;
insert into demo values (8, 'FooBar');
/* Results */
Use CONNECT or CREATE DATABASE to specify a database
SQL> CREATE DATABASE 'C:\data\demo.fdb' page_size 8192
CON> user 'SYSDBA' password 'masterkey';
SQL> CONNECT "C:\data\demo.fdb"
CON> user 'SYSDBA' password 'masterkey';
Commit current transaction (y/n)?y
Committing.
Database: "C:\data\demo.fdb", User: SYSDBA
SQL> create table demo (id int primary key, foobar varchar(20) character set utf8);
SQL> insert into demo values (6, 'FooBar');
SQL> commit;
SQL>
SQL> set term !! ;
SQL> CREATE TRIGGER NEW_DEMO_RECORD_TRIGGER FOR demo
CON> ACTIVE before insert
CON> AS BEGIN
CON> IF (inserting) THEN
CON> BEGIN
CON> new.foobar = 'NewFoobar';
CON> POST_EVENT 'NEWFOOBARD_POSTEVENT';
CON> END
CON> END!!
SQL> set term ; !!
SQL> insert into demo values (7, 'FooBar');
SQL> select * from demo;
ID FOOBAR
============ ===============================================================================
6 FooBar
7 NewFoobar
SQL> insert into demo values (8, 'FooBar');
SQL> commit;
SQL> select * from demo;
ID FOOBAR
============ ===============================================================================
6 FooBar
7 NewFoobar
8 NewFoobar
SQL>
/* Output of the console */
Hello World!
Listening...
info: Microsoft.EntityFrameworkCore.Infrastructure[10403]
Entity Framework Core 2.1.2-rtm-30932 initialized 'MyContext' using provider 'EntityFrameworkCore.FirebirdSql' with options: None
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
Executed DbCommand (6ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT "d"."ID", "d"."FOOBAR"
FROM "DEMO" "d"
678
C:\Users\chris\source\repos\FireBirdConsoleExample\FireBirdConsoleExample\bin\Debug\netcoreapp3.1\FireBirdConsoleExample.exe (process 27392) exited with code 0.
To automatically close the console when debugging stops, enable Tools->Options->Debugging->Automatically close the console when debugging stops.
Press any key to close this window . . .
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Arto K. (JIRA) <tr...@fi...> - 2020-02-11 12:46:12
|
UDF invalid request BLR
-----------------------
Key: DNET-930
URL: http://tracker.firebirdsql.org/browse/DNET-930
Project: .NET Data provider
Issue Type: Bug
Affects Versions: 2.5.0
Environment: Windows 10
Reporter: Arto Kuvaja
Assignee: Jiri Cincura
I found excellent library for Visual Studio Firebird SMTP UDF Library and tries to install it to Firebird 2.5. Dll is compiled and in UDF folder. But I get the following error:
SQL Server Error: invalid request BLR at offset 36
function SMTPSERVERADD is not defined
module name or entrypoint could not be found
when trying to use it from a program called Axtools (after running DECLARE command). What could be wrong, is something missing?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-02-05 18:16:05
|
Default charset used for NONE locally assumes wrongly 1b per character
----------------------------------------------------------------------
Key: DNET-929
URL: http://tracker.firebirdsql.org/browse/DNET-929
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 7.1.1.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
...which means some computations are assuming wrong lengths either not throwing correct exception or trying to send unexpected buffers (or paddings).
I.e. the assumption is wrong on .NET Core, becase the Encoding.Default is not "ANSI", but UTF8 no matter what.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-02-05 18:10:04
|
Support for EF 6.4
------------------
Key: DNET-928
URL: http://tracker.firebirdsql.org/browse/DNET-928
Project: .NET Data provider
Issue Type: Task
Components: Entity Framework
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Jiri C. (JIRA) <tr...@fi...> - 2020-01-20 13:55:27
|
FbCommand.ExecuteNonQuery return value #breaking
------------------------------------------------
Key: DNET-927
URL: http://tracker.firebirdsql.org/browse/DNET-927
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 7.1.1.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
The FbCommand.ExecuteNonQuery should return -1 for everything except insert, update, delete, according to "spec".
https://docs.microsoft.com/en-us/dotnet/api/system.data.common.dbcommand.executenonquery
"For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements, the return value is -1."
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Ryno (JIRA) <tr...@fi...> - 2020-01-15 09:42:14
|
Dynamic SQL Error SQL error code = -104 Token unknown AND - EF Core - Two or more *Where* parameters in LINQ to SQL
--------------------------------------------------------------------------------------------------------------------
Key: DNET-926
URL: http://tracker.firebirdsql.org/browse/DNET-926
Project: .NET Data provider
Issue Type: Bug
Environment: FirebirdSql.Data.FirebirdClient - Firebird .NET EF Core
Reporter: Ryno
Assignee: Jiri Cincura
List<Document> documents = new List<Document>();
var docs = (from d in db.Documents
where d.DOCUMENT_DATE >= startDate & d.DOCUMENT_DATE <= endDate
select d).ToList();
foreach (Document doc in docs)
{
documents.Add(doc);
}
return documents;
RETURNS
SELECT "d"."DOCUMENT_ID", "d"."CLIENT_REF", "d"."CONVERSION_RATIO", "d"."CUSTOMER_CODE", "d"."DELIVERY_ADDRESS", "d"."DOCUMENT_DATE", "d"."DOCUMENT_TIME", "d"."DOC_NUMBER", "d"."DOC_STATUS", "d"."DOC_TYPE", "d"."EXCL", "d"."EXL_BIN", "d"."EXL_OVERREC", "d"."EXL_SURCHARGE", "d"."EXL_TRANSPORT", "d"."FINANCAIL_PERIOD", "d"."GROSSWEIGHT", "d"."INCL", "d"."INCL_BIN", "d"."INCL_OVERREC", "d"."INCL_SURCHARGE", "d"."INCL_TRANSPORT", "d"."INSTRUCTIONS", "d"."M3_QTY", "d"."MANUAL_NUMBER", "d"."OPTIONS", "d"."ORDER_NUMBER", "d"."PRICELIST_ID", "d"."PRODUCT_CODE", "d"."PRODUCT_UNIT", "d"."QTY", "d"."SUPPLIER_CODE", "d"."SURCHARGE_QTY", "d"."TRUCKTARE", "d"."VAT", "d"."VAT_CODE", "d"."VEHICLE_REG", "d"."ZONE_CODE"
FROM "DOCUMENT" AS "d"
WHERE (CASE
WHEN "d"."DOCUMENT_DATE" >= CAST(@__startDate_0 AS TIMESTAMP)
THEN TRUE ELSE FALSE
END AND CASE ---- ERROR
WHEN "d"."DOCUMENT_DATE" <= CAST(@__endDate_1 AS TIMESTAMP)
THEN TRUE ELSE FALSE
END) = TRUE
Which is invalid FB Sql
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Norbert S. G. (JIRA) <tr...@fi...> - 2020-01-08 08:07:17
|
Compatibility with Firebird 4 for Int128
----------------------------------------
Key: DNET-925
URL: http://tracker.firebirdsql.org/browse/DNET-925
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider, Entity Framework, Entity Framework Core
Reporter: Norbert Saint Georges
Assignee: Jiri Cincura
type INT128
BLR = 26
API = 32752
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Norbert S. G. (JIRA) <tr...@fi...> - 2020-01-08 08:01:32
|
Compatibility with Firebird 4 TimeStamp with Time Zone
------------------------------------------------------
Key: DNET-923
URL: http://tracker.firebirdsql.org/browse/DNET-923
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider, Entity Framework, Entity Framework Core
Reporter: Norbert Saint Georges
Assignee: Jiri Cincura
type TimeStamp with Time Zone
BLR = 29
API = 32754
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Norbert S. G. (JIRA) <tr...@fi...> - 2020-01-08 08:01:31
|
Compatibility with Firebird 4 for Time with Time Zone
------------------------------------------------------
Key: DNET-924
URL: http://tracker.firebirdsql.org/browse/DNET-924
Project: .NET Data provider
Issue Type: New Feature
Reporter: Norbert Saint Georges
Assignee: Jiri Cincura
type 4) Time with Time Zone
BLR = 28
API = 32756
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Norbert S. G. (JIRA) <tr...@fi...> - 2020-01-08 08:01:25
|
Compatibility with Firebird 4 for Decfloat(16)
----------------------------------------------
Key: DNET-921
URL: http://tracker.firebirdsql.org/browse/DNET-921
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider, Entity Framework, Entity Framework Core
Reporter: Norbert Saint Georges
Assignee: Jiri Cincura
type Decfloat(16)
BLR = 24
API = 32760
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Norbert S. G. (JIRA) <tr...@fi...> - 2020-01-08 08:01:25
|
Compatibility with Firebird 4 for Decfloat(34)
----------------------------------------------
Key: DNET-922
URL: http://tracker.firebirdsql.org/browse/DNET-922
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider, Entity Framework, Entity Framework Core
Reporter: Norbert Saint Georges
Assignee: Jiri Cincura
type 2) Decfloat(34)
BLR = 25
API = 32762
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
|
From: Norbert S. G. (JIRA) <tr...@fi...> - 2020-01-08 07:50:16
|
Compatibility with Firebird 4
-----------------------------
Key: DNET-920
URL: http://tracker.firebirdsql.org/browse/DNET-920
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider, Entity Framework, Entity Framework Core, NuGet packages
Reporter: Norbert Saint Georges
Assignee: Jiri Cincura
1) Decfloat(16) BLR = 24 API = 32760
2) Decfloat(34) BLR = 25 API = 32762
3) TimeStamp with TimeZone BLR = 29 API = 32754
4) Time with TimeZone BLR = 28 API = 32756
5) INT128 BLR = 26 API = 32752
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
211 messages has been excluded from this view by a project administrator.
