Re: [Firebird-devel] Dropping index on domain change?

2015-07-01 Thread Ann Harrison
> On Jul 1, 2015, at 9:34 AM, Dmitry Yemanov wrote: > > 01.07.2015 13:49, Vlad Khorsun wrote: > >>> Not sure what you mean by same? Let's say I change it from smallint to int. >> >> All kind of numbers have the same representation in index keys. > > Except BIGINT, IIRC. > Which was a mista

[Firebird-devel] [FB-Tracker] Created: (CORE-4853) User without admin role gets slightly different messages about not found record depending on UserManager = Legacy_UserManager vs Srp

2015-07-01 Thread Pavel Zotov (JIRA)
User without admin role gets slightly different messages about not found record depending on UserManager = Legacy_UserManager vs Srp Key: CORE-4853

Re: [Firebird-devel] Dropping index on domain change?

2015-07-01 Thread Vlad Khorsun
01.07.2015 16:34, Dmitry Yemanov wrote: > 01.07.2015 13:49, Vlad Khorsun wrote: > >>> Not sure what you mean by same? Let's say I change it from smallint to int. >> >> All kind of numbers have the same representation in index keys. > > Except BIGINT, IIRC. Correct. Regards, Vlad PS One can f

Re: [Firebird-devel] Dropping index on domain change?

2015-07-01 Thread Dmitry Yemanov
01.07.2015 13:49, Vlad Khorsun wrote: >> Not sure what you mean by same? Let's say I change it from smallint to int. > > All kind of numbers have the same representation in index keys. Except BIGINT, IIRC. Dmitry -- D

Re: [Firebird-devel] Dropping index on domain change?

2015-07-01 Thread Jiří Činčura
>Look at execution statistics. If commit took more time than expected > (few ms), performs a lot of fetches\marks, etc - it could be sign that > index(es) was rebuild. Thanks. I'm testing now on empty database, just to see what's possible. I'll generate some data. -- Mgr. Jiří Činčura Inde

Re: [Firebird-devel] Dropping index on domain change?

2015-07-01 Thread Vlad Khorsun
01.07.2015 13:34, Jiří Činčura wrote: >> If new datatype is the same from index POV, there is no need to rebuild >> index. > > Not sure what you mean by same? Let's say I change it from smallint to int. All kind of numbers have the same representation in index keys. So, in the case above th

Re: [Firebird-devel] Dropping index on domain change?

2015-07-01 Thread Jiří Činčura
>If new datatype is the same from index POV, there is no need to rebuild > index. Not sure what you mean by same? Let's say I change it from smallint to int. > Else, IIRC, engine rebuild all indices dependent on domain-based fields. > You can check it yourself, btw :) How? -- Mgr. Jiří Či

[Firebird-devel] [FB-Tracker] Created: (CORE-4852) conversion error from string "" when doing INNER JOIN with empty result set.

2015-07-01 Thread Marcin (JIRA)
conversion error from string "" when doing INNER JOIN with empty result set. Key: CORE-4852 URL: http://tracker.firebirdsql.org/browse/CORE-4852 Project: Firebird Core

Re: [Firebird-devel] Any chance for realisation of CORE-2040?

2015-07-01 Thread Björn Reimer
Hello, Ok, well. My use case is in short words: Some SPs calling other SPs with dynamically built SQL code executed with execute statement or for execute loops. Error handling is hardened with a when any statement after special handling of "expected" errors. In that when an

Re: [Firebird-devel] employee db build broken

2015-07-01 Thread Paul Reeves
On Wednesday 01 July 2015 11:34:08 Dmitry Yemanov wrote: > 24.06.2015 11:50, Paul Reeves wrote: > > The 64-bit windows build of the employee db is broken. > > Can you confirm that the issue is gone now? > > Yes. Adriano supplied a fix and tagged it for Beta 2. I've checked that make_examples.bat

Re: [Firebird-devel] employee db build broken

2015-07-01 Thread Dmitry Yemanov
24.06.2015 11:50, Paul Reeves wrote: > > The 64-bit windows build of the employee db is broken. Can you confirm that the issue is gone now? Dmitry -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solu

Re: [Firebird-devel] Dropping index on domain change?

2015-07-01 Thread Vlad Khorsun
01.07.2015 12:14, Jiří Činčura wrote: > Hi *, > > Firebird allows me to change domain's datatype even if column with this > domain is used in an index. > Is it OK or should the index be dropped and created again? If new datatype is the same from index POV, there is no need to rebuild index.

[Firebird-devel] Dropping index on domain change?

2015-07-01 Thread Jiří Činčura
Hi *, Firebird allows me to change domain's datatype even if column with this domain is used in an index. Is it OK or should the index be dropped and created again? -- Mgr. Jiří Činčura Independent IT Specialist -- Don