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: Benny B. (JIRA) <tr...@fi...> - 2019-03-05 08:58:06
|
Firebird .NET provider can not connect to Firebird 3 except sysdba using Legacy user manager
--------------------------------------------------------------------------------------------
Key: DNET-872
URL: http://tracker.firebirdsql.org/browse/DNET-872
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 6.5.0.0, 6.4.0.0, 6.3.0.0, 6.2.0.0, 6.1.0.0, 6.0.0.0, 5.12.1.0, 5.12.0.0, 5.11.0.0, 5.10.0.0
Environment: Windows Firebird 3
Reporter: Benny Bech
Assignee: Jiri Cincura
Priority: Minor
When trying to connect to Firebird 3 using NON sysdba (legacy user) error "Your user name and password are not defined. Ask your database administrator to set up a Firebird login." i s returned.
Test against Firebird 3 configured as:
AuthServer = Legacy_Auth
Srp AuthClient = Legacy_Auth
Srp UserManager = Legacy_UserManager
Srp WireCrypt = Enabled
ServerMode = Classic
Tried on 2 users:
CREATE USER USR_LEG PASSWORD 'PASLEG11' USING PLUGIN Legacy_UserManager;
CREATE USER USR_SRP PASSWORD 'PASSRP22' USING PLUGIN Srp;
User USR_LEG is working with FirebirdClient 4.10 and below
User USR_SRP is working with FirebirdClient 5.10 and above.
Both users is working using ISQL and IBexpert.
--
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...> - 2019-02-20 08:45:00
|
Add FbConnection.ClearPool overload that takes connection string
----------------------------------------------------------------
Key: DNET-871
URL: http://tracker.firebirdsql.org/browse/DNET-871
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider
Affects Versions: 6.5.0.0
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...> - 2019-02-18 15:37:59
|
Subselects in WHEN not generated correctly
------------------------------------------
Key: DNET-870
URL: http://tracker.firebirdsql.org/browse/DNET-870
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework Core
Affects Versions: 6.5.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
return Ok(
new {
OP = await db.HT_REZERVARI
.Where(r => r.ID == id)
.Select(r => new
{
r.ID,
r.ID_CAMERA,
r.DATAI,
r.NRZILE,
r.STARE,
r.ID_CF,
r.IDOPERATOR,
r.FACTURAT,
r.FACTURAT3,
r.TIPFCCUR,
r.NR_FACT,
r.DATAF,
r.NR_FACTP,
r.DATAFP,
r.NR_FACT3,
DATAF3 = r.HT_INFEXPED.Where(x => x.TIP == 3).Select(x => x.DATAF).FirstOrDefault(),
TAXESUPL= r.HT_TAXE.Any(t=>t.TIP==3) ? 1 : 0,
DENCL = r.CF.DENUMIRE,
DENCAMERA = r.HT_CAMERE.DEN,
DENZONA = r.HT_CAMERE.HT_ZONE.DENUMIRE,
r.IDGRUP,
DENGRUP = r.HT_REZGRUPE.DENUMIRE,
r.AVANS,
r.AVANSCUFC,
NR_FACTA = r.HT_INFEXPED.Where(x => x.TIP == 2).Select(x => x.NRFACT).FirstOrDefault(),
DATAFA = r.HT_INFEXPED.Where(x => x.TIP == 2).Select(x => x.DATAF).FirstOrDefault(),
r.NR_CAMERE,
RONLY = r.IDGRUP>0 && db.HT_REZERVARI.Any(re => re.IDGRUP == r.IDGRUP && re.ID !=r.ID
&& ((re.STARE==1 && re.NR_FACTP>0) || re.STARE==0 && re.NR_FACT>0)),
r.DATAPLATA
}).ToListAsync(),
PLATI = await db.HT_PLATI
.Where(p => p.IDCAZARE == id)
.Join(db.HT_REZERVARI, p => new {ID= p.IDCAZARE, p.TIPFC }, r => new { r.ID, TIPFC=r.TIPFCCUR }, (p, r) => new { p, r })
.Select(g=> new { g.p.TIP, g.p.VALOARE })
.ToListAsync()
}
);
===
SELECT "r"."ID", "r"."ID_CAMERA", "r"."DATAI", "r"."NRZILE", "r"."STARE", "r"."ID_CF", "r"."IDOPERATOR", "r"."FACTURAT", "r"."FACTURAT3", "r"."TIPFCCUR", "r"."NR_FACT", "r"."DATAF", "r"."NR_FACTP", "r"."DATAFP", "r"."NR_FACT3", (
SELECT FIRST 1 "x"."DATAF"
FROM "HT_INFEXPED" AS "x"
WHERE ("x"."TIP" = 3) AND ("r"."ID" = "x"."ID_REZERVARE")
) AS "DATAF3", CASE
WHEN (
SELECT CASE
WHEN EXISTS (
SELECT 1
FROM "HT_TAXE" AS "t"
WHERE ("t"."TIP" = 3) AND ("r"."ID" = "t"."ID_REZERVARE"))
THEN TRUE ELSE FALSE
END
)
FROM RDB$DATABASE = TRUE
THEN 1 ELSE 0
END AS "TAXESUPL", "r.CF"."DENUMIRE" AS "DENCL", "r.HT_CAMERE"."DEN" AS "DENCAMERA", "r.HT_CAMERE.HT_ZONE"."DENUMIRE" AS "DENZONA", "r"."IDGRUP", "r.HT_REZGRUPE"."DENUMIRE" AS "DENGRUP", "r"."AVANS", "r"."AVANSCUFC", COALESCE((
SELECT FIRST 1 "x0"."NRFACT"
FROM "HT_INFEXPED" AS "x0"
WHERE ("x0"."TIP" = 2) AND ("r"."ID" = "x0"."ID_REZERVARE")
), 0) AS "NR_FACTA", (
SELECT FIRST 1 "x1"."DATAF"
FROM "HT_INFEXPED" AS "x1"
WHERE ("x1"."TIP" = 2) AND ("r"."ID" = "x1"."ID_REZERVARE")
) AS "DATAFA", "r"."NR_CAMERE", CASE
WHEN ("r"."IDGRUP" > 0) AND ((
SELECT CASE
WHEN EXISTS (
SELECT 1
FROM "HT_REZERVARI" AS "re"
WHERE (("re"."IDGRUP" = "r"."IDGRUP") AND ("re"."ID" <> "r"."ID")) AND ((("re"."STARE" = 1) AND ("re"."NR_FACTP" > 0)) OR (("re"."STARE" = 0) AND ("re"."NR_FACT" > 0))))
THEN TRUE ELSE FALSE
END
)
FROM RDB$DATABASE = TRUE)
THEN TRUE ELSE FALSE
END AS "RONLY", "r"."DATAPLATA"
FROM "HT_REZERVARI" AS "r"
INNER JOIN "HT_REZGRUPE" AS "r.HT_REZGRUPE" ON "r"."IDGRUP" = "r.HT_REZGRUPE"."ID"
INNER JOIN "HT_CAMERE" AS "r.HT_CAMERE" ON "r"."ID_CAMERA" = "r.HT_CAMERE"."ID"
INNER JOIN "HT_ZONE" AS "r.HT_CAMERE.HT_ZONE" ON "r.HT_CAMERE"."ID_ZONA" = "r.HT_CAMERE.HT_ZONE"."ID"
INNER JOIN "CF" AS "r.CF" ON "r"."ID_CF" = "r.CF"."ID"
WHERE "r"."ID" = @__id_0
--
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: ilkara <il...@ho...> - 2019-02-18 14:06:08
|
<html><body> <p><font size="1" face="sans-serif">Σας ενημερώνω ότι το παρόν email θα καταργηθεί. Η νέα μου διεύθυνση είναι<br> </font><font size="1" face="sans-serif"><br> </font><font size="1" face="sans-serif">ilk...@gm...<br> </font><font size="1" face="sans-serif"><br> </font><font size="1" face="sans-serif"><br> </font><font size="1" color="#808080" face="sans-serif">Note: This is an automated response to your message </font><font size="1" face="sans-serif"><b>"[Firebird-net-provider] [FB-Tracker] Created: (DNET-869) Update EFCore to the latest 2.2"</b></font><font size="1" color="#808080" face="sans-serif"> sent on </font><font size="1" face="sans-serif"><b>18/02/2019 13:20:46</b></font><font size="1" color="#808080" face="sans-serif">. <br> </font><font size="1" color="#808080" face="sans-serif"><br> </font><font size="1" color="#808080" face="sans-serif">This is the only notification you will receive while this person is away.</font></body></html> |
|
From: Jiri C. (JIRA) <tr...@fi...> - 2019-02-18 11:21:05
|
Update EFCore to the latest 2.2
-------------------------------
Key: DNET-869
URL: http://tracker.firebirdsql.org/browse/DNET-869
Project: .NET Data provider
Issue Type: Task
Components: Entity Framework Core
Affects Versions: 6.5.0.0
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: Alan U. (JIRA) <tr...@fi...> - 2019-02-05 13:22:19
|
retrieve Non-Indexed and Indexed reads count of executed query for performance analysis
---------------------------------------------------------------------------------------
Key: DNET-868
URL: http://tracker.firebirdsql.org/browse/DNET-868
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider
Reporter: Alan Usiadek
Assignee: Jiri Cincura
Priority: Minor
It would be nice to have a possiblity to retrieve some additional informations of executed query (Tools like IBExpert can do this):
- Non-indexed reads count
- Indexed reads count
other useful informations are (a little bit more than affected recors count):
- updates count
- deletes count
- inserts count
with those it would be possible to monitor queries running in our programs and log if they have any non-indexed reads, and maybe they need some rewriting.
--
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...> - 2019-01-28 11:56:05
|
Race condition on FbConnectionPoolManager.Dispose and FbConnectionPoolManager.CleanupCallback
---------------------------------------------------------------------------------------------
Key: DNET-867
URL: http://tracker.firebirdsql.org/browse/DNET-867
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 6.4.0.0
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...> - 2019-01-25 15:46:06
|
Drop support for NS1.6
----------------------
Key: DNET-866
URL: http://tracker.firebirdsql.org/browse/DNET-866
Project: .NET Data provider
Issue Type: Task
Components: ADO.NET Provider
Affects Versions: 6.4.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Trivial
NS2.0 has the same support on .NET Framework (4.6.1) as NS1.6 and .NET Core 1.x apps either moved/need to move to .NET Core 2.x+ or stay on the current version (same story as with .NET 4.0).
If you have legitimate reason for NS1.6, let me know.
--
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...> - 2019-01-24 17:15:05
|
[ http://tracker.firebirdsql.org/browse/DNET-861?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jiri Cincura reopened DNET-861:
-------------------------------
Upload here. No need to create another ticket.
> FbConnection.GetSchema getting column information does not bring the column_size on varchar columns
> ---------------------------------------------------------------------------------------------------
>
> Key: DNET-861
> URL: http://tracker.firebirdsql.org/browse/DNET-861
> Project: .NET Data provider
> Issue Type: Bug
> Components: ADO.NET Provider
> Affects Versions: 6.3.0.0, 6.4.0.0
> Environment: Visual Studio 2017
> ASP.NET Core
> NET Standard libraries
> Firebird 2.5
> Reporter: Fabricio Araujo
> Assignee: Jiri Cincura
> Attachments: FbConn_BugViews.zip
>
>
> I have my own way to generate SQL to use with Dapper (Dapper.Contrib does not fit well
> in what I'm doing) and I need to get column information to do so.
> When I'm working with database tables directly, all works wonders when I use this call:
> DataTable dtb = conn.GetSchema("COLUMNS", new string[] { null, null, ParamTableName });
> When I use a view, things gets weird. Views (is not a trivial view, it has a few joins) with varchar columns comes with COLUMN_TYPE correct but COLUMN_SIZE comes NULL.
> I traced the executed SQL of GetSchema but while it does not bring the type of the column (only the reference to the domain) it DOES BRING
> the COLUMN_SIZE correctly
> The other columns comes correctly (all those are INTEGER columns though).
> Create the following view on the provided employee.fdb:
> CREATE OR ALTER VIEW PHONE_LIST_EXAMPLE(
> EMP_NO,
> FIRST_NAME,
> LAST_NAME,
> PHONE_EXT,
> HIRE_DATE,
> DEPT_NO,
> JOB_CODE,
> JOB_GRADE,
> JOB_COUNTRY,
> SALARY,
> FULL_NAME,
> PHONE_NO)
> AS
> WITH CtePhoneList as (
> SELECT
> E.Emp_No,
> E.First_Name,
> E.Last_Name,
> E.Phone_Ext,
> E.Hire_Date,
> E.Dept_No,
> E.Job_Code,
> E.Job_Grade,
> E.Job_Country,
> E.Salary,
> E.Full_Name ,
> d.Phone_No
> FROM
> Employee E
> inner join Department d
> on e.Dept_No = d.Dept_No
> )
> Select
> Emp_No,
> First_Name,
> Last_Name,
> Phone_Ext,
> Hire_Date,
> Dept_No,
> Job_Code,
> Job_Grade,
> Job_Country,
> Salary,
> Full_Name ,
> Phone_No
> from
> CtePhoneList;
> And build the provided winforms application to get the column info from that view. If you try on the original phone list view, all column will come ok.
> If you run the application on THAT view you'll see that varchar columns will come without column size.
--
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...> - 2019-01-23 13:43:04
|
Consider removing Detach from IDatabase...
------------------------------------------
Key: DNET-865
URL: http://tracker.firebirdsql.org/browse/DNET-865
Project: .NET Data provider
Issue Type: Task
Components: ADO.NET Provider
Affects Versions: 6.4.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
...because it very much supplies the Dispose method and IDatabase is already IDisposable.
--
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...> - 2019-01-22 14:54:00
|
Support for isc_info_sql_explain_plan
-------------------------------------
Key: DNET-864
URL: http://tracker.firebirdsql.org/browse/DNET-864
Project: .NET Data provider
Issue Type: New Feature
Components: ADO.NET Provider
Affects Versions: 6.4.0.0
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...> - 2019-01-17 11:12:01
|
Validate isc_spb_dbname in FbServices
-------------------------------------
Key: DNET-863
URL: http://tracker.firebirdsql.org/browse/DNET-863
Project: .NET Data provider
Issue Type: Task
Components: ADO.NET Provider
Affects Versions: 6.4.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Trivial
`EnsureDatabase`
--
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...> - 2019-01-14 15:17:04
|
Switch to AssemblyInfo from csproj
----------------------------------
Key: DNET-862
URL: http://tracker.firebirdsql.org/browse/DNET-862
Project: .NET Data provider
Issue Type: Task
Components: ADO.NET Provider, Entity Framework, Entity Framework Core
Affects Versions: 6.0.0.0
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: Fabricio A. (JIRA) <tr...@fi...> - 2019-01-07 03:23:07
|
FbConnection.GetSchema getting column information does not bring the column_size on varchar columns
---------------------------------------------------------------------------------------------------
Key: DNET-861
URL: http://tracker.firebirdsql.org/browse/DNET-861
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 6.4.0.0, 6.3.0.0
Environment: Visual Studio 2017
ASP.NET Core
NET Standard libraries
Reporter: Fabricio Araujo
Assignee: Jiri Cincura
I have my own way to generate SQL to use with Dapper (Dapper.Contrib does not fit well
in what I'm doing) and I need to get column information to do so.
When I'm working with database tables directly, all works wonders when I use this call:
DataTable dtb = conn.GetSchema("COLUMNS", new string[] { null, null, ParamTableName });
When I use a view, things gets weird. Views (is not a trivial view, it has a few joins) with varchar columns comes with COLUMN_TYPE correct but COLUMN_SIZE comes NULL.
I traced the executed SQL of GetSchema but while it does not bring the type of the column (only the reference to the domain) it DOES BRING
the COLUMN_SIZE correctly
The other columns comes correctly (all those are INTEGER columns though).
--
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: narasimha (JIRA) <tr...@fi...> - 2018-11-23 09:41:15
|
this is a test bug to test the application - check and please fix it.
---------------------------------------------------------------------
Key: DNET-860
URL: http://tracker.firebirdsql.org/browse/DNET-860
Project: .NET Data provider
Issue Type: Bug
Environment: test environment
Reporter: narasimha
Assignee: Jiri Cincura
Priority: Trivial
this is a test bug to test the application - check and please fix it.
--
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: Marcos R. W. (JIRA) <tr...@fi...> - 2018-11-20 12:44:01
|
ExecuteScriptFromFile, Execute Block, UnknowStatement
-----------------------------------------------------
Key: DNET-859
URL: http://tracker.firebirdsql.org/browse/DNET-859
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 6.4.0.0
Environment: 5.9.1.0 a 6.4.0.0
Reporter: Marcos R. Weimer
Assignee: Jiri Cincura
on execute:
ExecuteScriptFromFile("filescript.sql", false);
Error:
The type of the SQL statement could not be determined. See also UnknownStatement event.
Statement: BEGIN IF ((SELECT COUNT(*) FROM CAIXA_MOVTO WHERE MOVTOCAIXA_ID_ORIGEM = 442 AND DATACAIXA IS NULL ) = 0) THEN DELETAR = TRUE.
"filescript.sql" is a file with several sqls (approximately 230 thousand)
SQL statement that displays the error:
EXECUTE BLOCK AS
DECLARE VARIABLE DELETAR BOOLEAN;
BEGIN
IF ((SELECT COUNT(*) FROM CAIXA_MOVTO WHERE MOVTOCAIXA_ID_ORIGEM = 42483 AND DATACAIXA IS NULL ) = 0) THEN
DELETAR = TRUE;
ELSE
DELETAR = FALSE;
IF (DELETAR) THEN
DELETE FROM CAIXA_MOVTO WHERE MOVTOCAIXA_ID_ORIGEM = 42483;
ELSE
UPDATE OR INSERT INTO CAIXA_MOVTO( MOVTOCAIXA_ID, OPERADOR_CAIXA, DATACAIXA, SEQCAIXA, DATA, OPERACAO_CAIXA, HISTORICO, VALOR, TIPO, TIPO_DC, IDNACERTO_PENDENTE, MOVTOCAIXA_CONTRAPARTIDA, MOVTOCAIXA_ESTORNADO, OPERADOR, TOTAL_PAGAMENTOS, TOTAL_RECEBIMENTO, TOTAL_RECEITAS, TOTAL_FATURAS_RECEBIDAS, TOTAL_FATURAS_PAGAS, TOTAL_DESPESAS, TOTAL_CHEQTERC_ENT, TOTAL_CHEQTERC_SAI, TOTAL_CHEQUES_EMITIDOS, TOTAL_DEBITOS_BANCARIOS, TOTAL_CREDITOS_BANCARIOS, TOTAL_RECEBIMENTOS, TOTAL_CARTAO, CODFILIAL, DESCONTO_CHEQUE_ID, LOTE_LIQUIDACAO, LOTE_NUMERARIO, TOTAL_DINHEIRO, TROCO, DESCONTO_DUPL_ID, PDV_NUMERO_CAIXA, PDV_ID_CAIXA_ABERTURA, PDV_NUM_CAIXA, TOTAL_CONTRAVALES_ENT, TOTAL_CONTRAVALES_SAI, MOVTOCAIXA_ID_ORIGEM ) VALUES( IIF((SELECT COUNT(*) FROM CAIXA_MOVTO CM WHERE CM.MOVTOCAIXA_ID_ORIGEM = 42483) > 0, (SELECT CM.MOVTOCAIXA_ID FROM CAIXA_MOVTO CM WHERE CM.MOVTOCAIXA_ID_ORIGEM = 42483), GEN_ID(GEN_CAIXA_MOVTO, 1)), 4, '08.11.2018', 401, '08.11.2018', 'TRANSFERÊNCIA', '', 55, 'N', 'D', 'N', 42484, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, NULL, NULL, 57, 0, 0, NULL, '4', 59, NULL, 0, 0, 42483) MATCHING (MOVTOCAIXA_ID);
END;
--
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...> - 2018-10-28 19:57:01
|
Support for Batch API
---------------------
Key: DNET-858
URL: http://tracker.firebirdsql.org/browse/DNET-858
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...> - 2018-10-24 06:42:06
|
Use Span<T> for parsing in Isql namespace
-----------------------------------------
Key: DNET-857
URL: http://tracker.firebirdsql.org/browse/DNET-857
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
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...> - 2018-10-24 06:42:02
|
Add SourceLink into providers
-----------------------------
Key: DNET-856
URL: http://tracker.firebirdsql.org/browse/DNET-856
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider, Entity Framework, Entity Framework Core
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...> - 2018-10-22 08:26:39
|
[ http://tracker.firebirdsql.org/browse/DNET-855?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jiri Cincura reopened DNET-855:
-------------------------------
> DbMigration.CreateTable creates shared sequence (generator) for any identity column
> -----------------------------------------------------------------------------------
>
> Key: DNET-855
> URL: http://tracker.firebirdsql.org/browse/DNET-855
> Project: .NET Data provider
> Issue Type: Bug
> Components: ADO.NET Provider
> Affects Versions: 6.3.0.0
> Environment: .NET framework 4.6.1, VS 2017
> Reporter: robsonwk
> Assignee: Jiri Cincura
>
> Using DbMigration, method CreateTable with column Identity set to true, generates one, common sequence for any table, any column.
> Result sql code is as following:
> EXECUTE BLOCK
> AS
> BEGIN
> if (not exists(select 1 from rdb$generators where rdb$generator_name = 'GEN_IDENTITY')) then
> begin
> execute statement 'create sequence GEN_IDENTITY';
> end
> END;
> and trigger
> CREATE OR ALTER TRIGGER "ID_USERS_ID" ACTIVE BEFORE INSERT ON "USERS"
> AS
> BEGIN
> if (new."ID" is null) then
> begin
> new."ID" = next value for GEN_IDENTITY;
> end
> END;
> Proposal:
> For table "Users", column "ID", migration sql could be:
> EXECUTE BLOCK
> AS
> BEGIN
> if (not exists(select 1 from rdb$generators where rdb$generator_name = 'GEN_IDENTITY_USERS_ID')) then
> begin
> execute statement 'create sequence GEN_IDENTITY_USERS_ID';
> end
> END;
> and trigger
> CREATE OR ALTER TRIGGER "ID_USERS_ID" ACTIVE BEFORE INSERT ON "USERS"
> AS
> BEGIN
> if (new."ID" is null) then
> begin
> new."ID" = next value for GEN_IDENTITY_USERS_ID;
> end
> END;
--
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: robsonwk (JIRA) <tr...@fi...> - 2018-10-21 21:34:00
|
DbMigration.CreateTable creates shared sequence (generator) for any identity column
-----------------------------------------------------------------------------------
Key: DNET-855
URL: http://tracker.firebirdsql.org/browse/DNET-855
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 6.3.0.0
Environment: .NET framework 4.6.1, VS 2017
Reporter: robsonwk
Assignee: Jiri Cincura
Using DbMigration, method CreateTable with column Identity set to true, generates one, common sequence for any table, any column.
Result sql code is as following:
EXECUTE BLOCK
AS
BEGIN
if (not exists(select 1 from rdb$generators where rdb$generator_name = 'GEN_IDENTITY')) then
begin
execute statement 'create sequence GEN_IDENTITY';
end
END;
and trigger
CREATE OR ALTER TRIGGER "ID_USERS_ID" ACTIVE BEFORE INSERT ON "USERS"
AS
BEGIN
if (new."ID" is null) then
begin
new."ID" = next value for GEN_IDENTITY;
end
END;
Proposal:
For table "Users", column "ID", migration sql could be:
EXECUTE BLOCK
AS
BEGIN
if (not exists(select 1 from rdb$generators where rdb$generator_name = 'GEN_IDENTITY_USERS_ID')) then
begin
execute statement 'create sequence GEN_IDENTITY_USERS_ID';
end
END;
and trigger
CREATE OR ALTER TRIGGER "ID_USERS_ID" ACTIVE BEFORE INSERT ON "USERS"
AS
BEGIN
if (new."ID" is null) then
begin
new."ID" = next value for GEN_IDENTITY_USERS_ID;
end
END;
--
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...> - 2018-10-08 09:54:27
|
[ http://tracker.firebirdsql.org/browse/DNET-811?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jiri Cincura reopened DNET-811:
-------------------------------
> Can't use new created columns in SQL - Statement in Up() Migration
> ------------------------------------------------------------------
>
> Key: DNET-811
> URL: http://tracker.firebirdsql.org/browse/DNET-811
> Project: .NET Data provider
> Issue Type: Bug
> Components: Entity Framework
> Affects Versions: 5.9.1.0
> Reporter: Andreas Patock
> Assignee: Jiri Cincura
>
> If I have the following migration:
> public partial class AddDeviceType : DbMigration
> {
> public override void Up()
> {
> CreateTable(
> "dbo.DeviceType",
> c => new
> {
> Id = c.Int(nullable: false, identity: true),
> Name = c.String(nullable: false, maxLength: 128),
> ManufacturerId = c.Int(nullable: false),
> })
> .PrimaryKey(t => t.Id)
> .ForeignKey("dbo.Manufacturer", t => t.ManufacturerId, cascadeDelete: true)
> .Index(t => t.ManufacturerId);
>
> AddColumn("dbo.Device", "TempDeviceTypeId", c => c.Int());
> AddColumn("dbo.Device", "DeviceTypeId", c => c.Int(nullable: false));
> CreateIndex("dbo.Device", "DeviceTypeId");
> AddForeignKey("dbo.Device", "DeviceTypeId", "dbo.DeviceType", "Id", cascadeDelete: true);
> Sql("UPDATE \"Device\" d SET d.\"DeviceTypeId\" = (SELECT t.\"Id\" from \"DeviceType\" t where t.\"ManufacturerId\" = d.\"ManufacturerId\" ORDER BY t.\"Id\" ROWS 1)");
> }
> I can a Column unknown "DeviceTypeId" exception when running the migration. This can found on many examples in the internet and is working with mssql.
> I had the idea to do this in two migrations, but the "DeviceTypeId" is a not null field and so the first migration throws an exception also.
--
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...> - 2018-10-04 08:45:08
|
Investigate option to remove weak references for FbCommands in connection to be able to properly track everything
-----------------------------------------------------------------------------------------------------------------
Key: DNET-854
URL: http://tracker.firebirdsql.org/browse/DNET-854
Project: .NET Data provider
Issue Type: Task
Components: ADO.NET Provider
Affects Versions: 6.3.0.0
Reporter: Jiri Cincura
Assignee: Jiri Cincura
Priority: Minor
Importantly how one FbCommand would play in prepared statements when used in multiple FbConnections.
--
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...> - 2018-10-03 10:19:02
|
Less allocations in XdrStream for common operations (reading Int32, Int64)
--------------------------------------------------------------------------
Key: DNET-853
URL: http://tracker.firebirdsql.org/browse/DNET-853
Project: .NET Data provider
Issue Type: Improvement
Components: ADO.NET Provider
Affects Versions: 6.3.0.0
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: Dominik P. (JIRA) <tr...@fi...> - 2018-09-20 13:24:12
|
Firebird server leaking handles using .net provider > 5.12.0.0
--------------------------------------------------------------
Key: DNET-852
URL: http://tracker.firebirdsql.org/browse/DNET-852
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider, Entity Framework
Affects Versions: 6.3.0.0, 6.2.0.0, 6.1.0.0, 6.0.0.0, 5.12.1.0
Environment: Windows 7, Windows Server 2016
Reporter: Dominik Psenner
Assignee: Jiri Cincura
Priority: Blocker
After an update of the firebird ado.net driver from 5.12.0 to 5.12.1 or 6.3 we observe that the firebird server 2.5.x leaks memory that is related to a connection and/or the statements that a client runs against the firebird database using the ado.net provider > 5.12.0.
We observe both an increase in the private memory set (4GB) but also the nonpaged pool increases significantly (5000K) in the firebird server process until the firebird server process is no longer able to handle any statements. At this point the server returns IscError 335544761 "too many open handles to database" and the SQLSTATE is "HY000". This causes the offending client to crash.
As soon as the connection closes, the firebird server is able to recover. It does then free the allocated memory and the nonpaged pool decreases back to normal (<160K).
This may relates to changes implemented with in release 5.12.1. Before ado.net provider 5.12.1, the connection pool to the firebird server did not work properly and connections were closed too early. Connections used to be always short-living. 5.12.1 fixed that and from then on connections are properly pooled. This causes connections to become long-living as long as there is activity. If connections are not closed, the server end will not end up the resources it has allocated and sooner or later show the symptom observed.
We cannot disable the connection pool because of performance reasons. We cannot revert back to 5.12.0 because the connection pool would not work either and we have no further option. Therefore I set the priority of this issue to blocker.
We do also have a minimal sample application that reproduces the issue with a very simplistic database containing only one table with three columns.
--
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.
