[firebird-support] Cannot create sequence

Hello all. To use a replication solution (not longer maintaned) i need to create a generator/sequence named "RDB$GEN_REPLICADOR" but when I try to do it i get (using Flamerobin): Error: *** IBPP::SQLException *** Context: Statement::Execute( CREATE GENERATOR RDB$GEN_REPLICADOR ) Message:

[firebird-support] Re: Cannot create sequence

Solved. I was missing to do GRANT USAGE ON SEQUENCE RDB$GEN_REPLICADOR TO [user] WITH GRANT OPTION (Sequence seems to be considered system one and dont get listed) Regards! 2017-09-22 21:44 GMT-03:00 Jorge Andres Brugger : > Hello all. > To use a replication solution

RE: [firebird-support] Huge performance different from FB 2.5.2 vs FB 3.02

Hi, Thanks for the tips. I will test again with your tip. Those Query plan created automaticaly by Firebird. But on FB 3.0.2, it was a bad plan that hurt performance a lot. I want to moved to FB 3, but because of this, i am hesited. Anto.

RE: [firebird-support] Cannot join CTEs (using indices) containing FIRST/ROWS/OFFSET

> As soon as i add the ROWS clause to a CTE FB cannot use indices available in > the CTEs tables. > Is this a bug, or as designed? > > This: > > with low as ( >   select igc.issue_id, ia.occasion >   from issues_groups igc >     left join issues_groups igb on (igb.issue_significant_id = >

Re: [firebird-support] Huge performance different FB 2.5.2 vs FB 3.02

Hi, show View (M_FNGD_VW) definition and also what are the settings – especially PAGE buffers and Page size in both 2.5 and 3 regards, Karol Bieniaszewski From: trsk...@yahoo.com [firebird-support] Sent: Friday, September 22, 2017 11:05 AM To: firebird-support@yahoogroups.com Subject:

Re: [firebird-support] Huge performance different from FB 2.5.2 vs FB 3.02

Hi, this is terible to read. Please change join style to explicite join style instead SELECT .. FROM TABLE_A A, TABLE_B B WHERE A.ID=B.ID write SELECT .. FROM TABLE_A A INNER JOIN TABLE_B B ON A.ID=B.ID regards, Karol Bieniaszewski From: trsk...@yahoo.com [firebird-support] Sent: Friday,

[firebird-support] Huge performance different from FB 2.5.2 vs FB 3.02

Hello guys, I have this Query select c.ID , e.CD, f.CD, sum(a.STCK_CLC) as qty, e.UNT, d.ID, g.ID from t_in_ot2 a, t_in_ot1 b, M_FNGD c, M_ART d, M_Sz e, M_ASST f, M_CLR g, m_trs_typ h, G_TMP j where d.ID = c.ART_ID and g.ID = c.CLR_ID and e.ID = c.SZ_ID and f.ID = c.ASST_ID and c.id =

[firebird-support] Huge performance different FB 2.5.2 vs FB 3.02

Hello guys, I have this query : SELECT a.BB, a.PLUS, a.MINUS, a.ENDBLNC, vw.UNT,vw.SLS_PRC_DS,vw.SLS_PRC_DT from GET_STCK_MUT_PSG_CNT('09-18-17','09-18-17','All') a, M_FNGD_VW vw where a.ID = vw.FNGD_ID and a.ENDBLNC >= 0 order by vw.NM,vw.cl, vw.SZ_CD, vw.ASST_CD On SuperClasic FB 2.52 on

[firebird-support] Cannot join CTEs (using indices) containing FIRST/ROWS/OFFSET

As soon as i add the ROWS clause to a CTE FB cannot use indices available in the CTEs tables. Is this a bug, or as designed? This: with low as ( select igc.issue_id, ia.occasion from issues_groups igc left join issues_groups igb on (igb.issue_significant_id =

[firebird-support] Re: Collation with Numeric-Sort and index

Did you have a setup (version of FB and ICU) that passes these tests? I do not use CI so i have not suffered from the potential disasters you point put above. IMHO looks like bugs. HTH, /D

[firebird-support] Re: FB 3.0 Replacing ICU libraries

I am using FB3.0.2 with swedish collation, but with the unicode libs that worked with FB2.5. I have not had the time to research the use of newer versions of these libraries. This is what i do: Put the icudt44.dll, icuin44.dll and icuuc44.dll lib files in Firebird_3_0 (might have typos here,