[Firebird-devel] New generated files

2015-12-24 Thread Claudio Valderrama C.
Hello, in fb_get_master_interface.pas I see: ===begin file function fb_get_master_interface : IMaster; cdecl; external 'fbclient'; const ===end file This "const" seems spurious. Didn't try to search where it comes from. C. --- Claudio Valderrama C.

Re: [Firebird-devel] Enhancement for numbers calculations

2015-12-07 Thread Claudio Valderrama C.
> -Original Message- > From: Carlos H. Cantu [mailto:lis...@warmboot.com.br] > Sent: Lunes, 07 de Diciembre de 2015 21:40 > > SS> The final solution will be support for high precision arithmetics. > SS> https://en.wikipedia.org/wiki/Arbitrary-precision_arithmetic > > Maybe. But will some

Re: [Firebird-devel] Plugin initialization

2015-11-13 Thread Claudio Valderrama C.
> -Original Message- > From: Alex Peshkoff [mailto:peshk...@mail.ru] > Sent: Viernes, 13 de Noviembre de 2015 7:25 > > On 11/13/2015 01:17 PM, Vlad Khorsun wrote: > > > > interface LoadedModuleInfo : Versioned > > { > > const string getModuleName(); > > ... > > } > > It should be Ref

Re: [Firebird-devel] Coalesce of the damned

2015-10-28 Thread Claudio Valderrama C.
> -Original Message- > From: Arno Brinkman [mailto:fbsupp...@abvisie.nl] > Sent: Miércoles, 28 de Octubre de 2015 21:27 > > I've to dig deep in my memory (ooh boy), but i think the > stream flag NULL is > not treated proper in this case. > > Thinking i've fixed something simular or eve

Re: [Firebird-devel] Coalesce of the damned

2015-10-28 Thread Claudio Valderrama C.
> -Original Message- > From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] > Sent: Martes, 27 de Octubre de 2015 6:40 > > The problem is that we can't go to evaluate blr_coalesce for a "null > stream". Yes, I thought so but there are two cases with a null stream: - coalesce

[Firebird-devel] Coalesce of the damned

2015-10-27 Thread Claudio Valderrama C.
ons and will give us more freedom to fix things. C. --- Claudio Valderrama C. Consultant, SW developer. -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 3.0 B2 (and lastsnapshot)fbclient.dll(Win32) slow unload?

2015-10-26 Thread Claudio Valderrama C.
> -Original Message- > From: Arno Brinkman [mailto:fbsupp...@abvisie.nl] > Sent: Lunes, 26 de Octubre de 2015 5:37 > > Would you consider the unloading time acceptable? > I think 500ms is quite a lot. Well, if you think about many clients connecting and disconnecting, it becomes a proble

Re: [Firebird-devel] Firebird 3.0 B2 (and last snapshot) fbclient.dll(Win32) slow unload?

2015-10-23 Thread Claudio Valderrama C.
> -Original Message- > From: Arno Brinkman [mailto:fbsupp...@abvisie.nl] > Sent: Viernes, 23 de Octubre de 2015 3:59 > > Hi All, > > Testing things with Firebird 3 i notice that when the fbclient.dll is > unloaded it cost 0,5 sec. ? > Anyone else seeing this behaviour? Are you alive? :

Re: [Firebird-devel] optional SET TERM

2015-10-15 Thread Claudio Valderrama C.
> -Original Message- > From: Ann Harrison [mailto:aharri...@nimbusdb.com] > Sent: Jueves, 15 de Octubre de 2015 12:34 > > > On Oct 15, 2015, at 9:59 AM, Dimitry Sibiryakov > wrote: > > > > 15.10.2015 15:51, marius adrian popa wrote: > >> In InterBase 7 is changed so procedure and trigg

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-07 Thread Claudio Valderrama C.
> -Original Message- > From: Helen Borrie [mailto:hele...@tpg.com.au] > Sent: Miércoles, 07 de Octubre de 2015 5:29 > > OK, so now I changed this to: > > ExternalFileAccess = Restrict h:\databases\externalfiles; > > -- and it works. > > IOW, in Fb 2.5, you can't use the single-quoting

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-06 Thread Claudio Valderrama C.
> -Original Message- > From: Helen Borrie [mailto:hele...@tpg.com.au] > Sent: Miércoles, 07 de Octubre de 2015 0:45 > > I wonder who is the "user" to which Windows is denying access > everywhere except within Firebird's own root structure. On > my system, I am user 'helen', which is an

Re: [Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-06 Thread Claudio Valderrama C.
> -Original Message- > From: Helen Borrie [mailto:hele...@tpg.com.au] > Sent: Martes, 06 de Octubre de 2015 22:58 > > Configuring ExternalFileAccess with Restrict in v.2.5.4 SS on > Win7 doesn't seem to work properly. Full does work; None > (the default) works. Restrict seems not to

Re: [Firebird-devel] [Spam] Re: revoke all on all

2015-09-29 Thread Claudio Valderrama C.
> -Original Message- > From: Alex Peshkoff [mailto:peshk...@mail.ru] > Sent: Martes, 29 de Septiembre de 2015 8:01 > So what should be better done: > 1. Keep it as is > 2. Add an option to revoke granted by ABC rights too Is there anything in the SQL standard describing such situation? If

Re: [Firebird-devel] RDB$VIEW_RELATIONS

2015-09-16 Thread Claudio Valderrama C.
> -Original Message- > From: Helen Borrie [mailto:hele...@tpg.com.au] > Sent: Miércoles, 16 de Septiembre de 2015 21:46 > > The new FBLangref 25 says RDB$VIEW_RELATIONS is not used in > current versions. As Mark R. has pointed in his review (and > as I meant to ask before, and forgot t

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4935) Increase performance of backout of dead record version (or undo of just created primary record version) when backversions chain is too long

2015-09-16 Thread Claudio Valderrama C.
> Key: CORE-4935 > URL: http://tracker.firebirdsql.org/browse/CORE-4935 > Project: Firebird Core > > Another improvement is to cut and cleanup tail of the > back-versions chain at point where it is legal Vlad, did you do that second improvement, too

Re: [Firebird-devel] SET TRANSACTION in isql

2015-09-15 Thread Claudio Valderrama C.
> -Original Message- > From: Dmitry Kuzmenko [mailto:k...@ibase.ru] > Sent: Martes, 15 de Septiembre de 2015 7:47 > > default "no_rec_version" for read_committed also confuses people, > because it "blocks reading of concurrent uncommitted changes". > Jiri said that > "that was Dmitry Kuzm

Re: [Firebird-devel] SET TRANSACTION in isql

2015-09-14 Thread Claudio Valderrama C.
> -Original Message- > From: Mark Rotteveel [mailto:m...@lawinegevaar.nl] > Sent: Lunes, 14 de Septiembre de 2015 16:54 > > Personally, I'd expect the previously used transaction > options to be used until a new explicit set transaction is executed. I think there's a confusion between S

Re: [Firebird-devel] Different collation ID for alteredcomputedcolumn

2015-09-14 Thread Claudio Valderrama C.
> -Original Message- > From: Jirí Cincura [mailto:j...@cincura.net] > Sent: Lunes, 14 de Septiembre de 2015 11:30 > > The resulting "show domain" produces different results. Which is at > least confusing. You never do show domain under normal circumstances. You do show domain or show

Re: [Firebird-devel] Different collation ID for altered computedcolumn

2015-09-14 Thread Claudio Valderrama C.
> -Original Message- > From: Jirí Cincura [mailto:j...@cincura.net] > Sent: Lunes, 14 de Septiembre de 2015 1:45 > > I'm not interested in actual value. I'm just wondering why the two > values differ after alter, given the alter changed nothing. You were looking in the wrong place, remem

Re: [Firebird-devel] Different collation ID for altered computed column

2015-09-13 Thread Claudio Valderrama C.
> -Original Message- > From: Jirí Cincura [mailto:j...@cincura.net] > Sent: Viernes, 11 de Septiembre de 2015 6:10 > > Hi, > > can somebody explain this behavior? Tested on FB 2.5.4 and > 2.5.3 x64 SC. > > CREATE TABLE T_TRANSLATION_META ( > F_TRM_ID BIGINT NOT NULL, >

Re: [Firebird-devel] Apropos of implicit domains.

2015-09-03 Thread Claudio Valderrama C.
> -Original Message- > From: Dalton Calford [mailto:dalton.calf...@gmail.com] > Sent: Jueves, 03 de Septiembre de 2015 15:27 > > Changing a column definition for a column defined with a > domain, should result in an error. > ie > alter table alter type should not work for columns that u

[Firebird-devel] Apropos of implicit domains.

2015-09-03 Thread Claudio Valderrama C.
ter a type double precision; show table t2; A DOUBLE PRECISION Nullable So far so good, but: show table t1; A DOUBLE PRECISION Nullable We have a problem of quantum entanglement between fields from different tables. :-) C. --- Claudio Va

Re: [Firebird-devel] System tables changes in read only databases

2015-07-30 Thread Claudio Valderrama C.
> -Original Message- > From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] > Sent: Jueves, 30 de Julio de 2015 13:02 > > Hi! > > I purposely put a MODIFY of system tables in epp file without > considering dbb->readOnly() flag. > > And it worked (changed the database) and com

Re: [Firebird-devel] [Spam] Re: Firebird 3, execution modes

2015-07-15 Thread Claudio Valderrama C.
> -Original Message- > From: Alex Peshkoff [mailto:peshk...@mail.ru] > Sent: Miércoles, 15 de Julio de 2015 6:41 > > On 07/15/2015 12:20 AM, Claudio Valderrama C. wrote: > > > same as the strange need of > > using sysdba to add sysdba to complete the com

Re: [Firebird-devel] code quality and strange comments

2015-07-15 Thread Claudio Valderrama C.
> -Original Message- > From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] > Sent: Miércoles, 15 de Julio de 2015 9:23 > > And? > > Any of these comments are not compiling? > > > Adriano Adriano, I think you shouldn't waste your time with Internet trolls. Just ignore them.

Re: [Firebird-devel] Firebird 3, execution modes

2015-07-14 Thread Claudio Valderrama C.
> -Original Message- > From: Carlos H. Cantu [mailto:lis...@warmboot.com.br] > Sent: Martes, 14 de Julio de 2015 21:24 > > Btw, seems that firebird.conf from today's snapshot doesn't > has SharedCache and SharedDatabase parameters anymore. > Instead, you will find just a new parameters

Re: [Firebird-devel] Firebird 3, execution modes

2015-07-14 Thread Claudio Valderrama C.
> -Original Message- > From: Walter R. Ojeda Valiente > [mailto:sistemas2000profesio...@gmail.com] > Sent: Martes, 14 de Julio de 2015 17:56 > > First, it says that for choicing the working modes (models) I > need to put values 0 or 1 at SharedCache and SharedDatabase. > Ok with that.

Re: [Firebird-devel] Firebird 3 problem with inserting string to blob

2015-07-07 Thread Claudio Valderrama C.
> -Original Message- > From: Ivan Pøenosil [mailto:ivan.preno...@seznam.cz] > Sent: Martes, 07 de Julio de 2015 18:10 > > In FB2, FB2.5, FB3-Beta1, FB3-31661 it was possible to > directly insert 50k long text into blob field: > > CREATE TABLE Tab (B BLOB SUB_TYPE TEXT); > INSERT INTO T

Re: [Firebird-devel] Problem with MERGE

2015-06-10 Thread Claudio Valderrama C.
> -Original Message- > From: Dmitry Yemanov [mailto:firebi...@yandex.ru] > Sent: Miércoles, 10 de Junio de 2015 15:40 > > > > With the old logic, the result is one. With the new logic, > the result is two > > becaise we get the direct and indirect effects. > > I doubt the new logic would

Re: [Firebird-devel] Problem with MERGE

2015-06-10 Thread Claudio Valderrama C.
> -Original Message- > From: Dmitry Yemanov [mailto:firebi...@yandex.ru] > Sent: Martes, 09 de Junio de 2015 6:19 > > 09.06.2015 13:11, Dimitry Sibiryakov wrote: > > > > ISQL would better always report "Rows affected" as a sum of > all three components of > > info response: inserts+upda

[Firebird-devel] Problem with MERGE

2015-06-08 Thread Claudio Valderrama C.
better? (I hope.) C. --- Claudio Valderrama C. Consultant, SW developer. -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Semantics of field [NOT] NULL flag based on domains

2015-04-02 Thread Claudio Valderrama C.
> -Original Message- > From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] > Sent: Miércoles, 01 de Abril de 2015 22:29 > > On 31-03-2015 07:41, Alex Peshkoff wrote: > > > > I.e. we can not override NOT NULL constraint set in the domain. > > > > Changed. Thanks. Should we

Re: [Firebird-devel] The Power of C++11 in CUDA 7

2015-03-20 Thread Claudio Valderrama C.
> -Original Message- > From: marius adrian popa [mailto:map...@gmail.com] > Sent: Jueves, 19 de Marzo de 2015 9:34 > > I wonder how we can use the power of cuda in the engine > > http://devblogs.nvidia.com/parallelforall/power-cpp11-cuda-7/# > more-4999 But does it need the latest C++?

Re: [Firebird-devel] Time to update our headers.

2015-03-06 Thread Claudio Valderrama C.
> -Original Message- > From: Paul Beach [mailto:pbe...@ibphoenix.com] > Sent: Jueves, 05 de Marzo de 2015 12:07 > > The IPL license hosted on IBPhoenix was the license > originally used, i.e. we hosted the original license that the > InterBase code was > released with (as Ann and I devi

[Firebird-devel] Commits visible in our main page.

2015-03-05 Thread Claudio Valderrama C.
#x27;s too nerdy, I think it's of utmost importance to show the project is alive. Currently we are like the magma: we are moving but under the surface... then nobody cares and a lot of people think the project stagnated years ago. C. --- Claudio Valderrama C. Consultan

[Firebird-devel] Time to update our headers.

2015-03-04 Thread Claudio Valderrama C.
People, http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_idpl. is pointing to nothing. We need to update the files in the repository to point to the right location of the license or please suggest an alternative. I think that only FB v3 matters. C. --- Claudio Valderrama C. Consultant

Re: [Firebird-devel] Fwd: [Firebird-checkins] SF.net SVN: firebird:[60440] firebird/trunk/src (and CORE-4654)

2015-01-11 Thread Claudio Valderrama C.
> -Original Message- > From: Alex Peshkoff [mailto:peshk...@mail.ru] > Sent: Jueves, 08 de Enero de 2015 5:27 > > On 01/08/15 06:45, Claudio Valderrama C. wrote: > > I agree with Alex but we should first remove the VC8 and > VC9 projects from > > our FB3

Re: [Firebird-devel] Fwd: [Firebird-checkins] SF.net SVN: firebird:[60440] firebird/trunk/src (and CORE-4654)

2015-01-07 Thread Claudio Valderrama C.
I agree with Alex but we should first remove the VC8 and VC9 projects from our FB3 tree. It doesn't make sense to offer them if they are obsolete. Claudio. > -Original Message- > From: Alex Peshkoff [mailto:peshk...@mail.ru] > Sent: Lunes, 29 de Diciembre de 2014 7:46 > > I strongly dis

[Firebird-devel] GarbageCollector.cpp

2014-12-12 Thread Claudio Valderrama C.
o be told that the current code is correct and I didn't take something obvious into account. C. --- Claudio Valderrama C. Consultant, SW developer. -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server fr

[Firebird-devel] Code out of order

2014-12-08 Thread Claudio Valderrama C.
ase(); // See if JRD thread data structure looks sane for occasion if (!tdbb || !dbb) You'll agree that the check for !tdbb became obsolete or the code should be reordered because tdbb is used to get dbb before it's tested for NULL. ;-) C. --- Claudio Valderrama C. C

[Firebird-devel] Cannot build FB2.5

2014-08-16 Thread Claudio Valderrama C.
d::RefCounted *' 1> Types pointed to are unrelated; conversion requires reinterpret_cast, C-style cast or function-style cast I prefer to not touch the interfaces and let someone else fix this. Thanks. C.

Re: [Firebird-devel] DDL permissions

2014-08-03 Thread Claudio Valderrama C.
> -Original Message- > From: Dmitry Yemanov [mailto:firebi...@yandex.ru] > Sent: Sábado, 02 de Agosto de 2014 12:15 > > 01.08.2014 18:55, Simonov Denis wrote: > > > SQL> insert into RDB$EXCEPTIONS(RDB$EXCEPTION_NAME) VALUES ('E1'); > > At the first glance, I don't see why it cannot be p

Re: [Firebird-devel] SF.net SVN: firebird:[59774] firebird/trunk/src

2014-07-01 Thread Claudio Valderrama C.
> -Original Message- > From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] > Sent: Martes, 01 de Julio de 2014 22:22 > > > Frank, > > Please don't mess with obj.h for ISQL support. > > I think you should do it different, for example, passing extra > parameters instead of th

Re: [Firebird-devel] DDL Triggers, how to retrieve type?

2014-05-24 Thread Claudio Valderrama C.
> -Original Message- > From: Dimitry Sibiryakov [mailto:s...@ibphoenix.com] > Sent: Sábado, 24 de Mayo de 2014 3:13 > > 24.05.2014 2:28, Claudio Valderrama C. wrote: > > We have > > BIN_SHL > > BIN_SHR > > for shifting bits. > >Oh,

Re: [Firebird-devel] DDL Triggers, how to retrieve type?

2014-05-23 Thread Claudio Valderrama C.
> -Original Message- > From: Alex Peshkoff [mailto:peshk...@mail.ru] > Sent: Viernes, 23 de Mayo de 2014 6:05 > > On 05/23/14 13:59, Dimitry Sibiryakov wrote: > > 23.05.2014 11:54, Alex Peshkoff wrote: > >> Did you read that this is mask, not code? It's anyway > impossible to join > >> d

Re: [Firebird-devel] DDL Triggers, how to retrieve type?

2014-05-22 Thread Claudio Valderrama C.
> -Original Message- > From: Vlad Khorsun [mailto:hv...@users.sourceforge.net] > Sent: Jueves, 22 de Mayo de 2014 11:24 > > > Yes, it's a bit mask. See the constants: > > Shouldn't it be present in RDB$TYPES, as all other > "special" numbers ? I have them commented in my private so

Re: [Firebird-devel] Fb3 gbak problem

2014-05-11 Thread Claudio Valderrama C.
There may be more problems, who knows. Changing a 30 years old behavior is guaranteed to produce surprises. ;-) Claudio. > -Original Message- > From: Simonov Denis [mailto:sim-m...@list.ru] > Sent: Domingo, 11 de Mayo de 2014 1:46 > > Thank you Claudio. Build 3.0.0.31129 works without e

Re: [Firebird-devel] Cleaning up transaction info

2014-05-07 Thread Claudio Valderrama C.
> -Original Message- > From: Mark Rotteveel [mailto:m...@lawinegevaar.nl] > Sent: Miércoles, 07 de Mayo de 2014 8:14 > > As the value of RDB$TRANSACTION_STATE is modified, I assume > this code (or > something very similar) is actually called, but then the `else` branch > shown above. Wha

Re: [Firebird-devel] Idleness

2014-05-07 Thread Claudio Valderrama C.
> -Original Message- > From: Mark Rotteveel [mailto:m...@lawinegevaar.nl] > Sent: Miércoles, 07 de Mayo de 2014 13:56 > > > > SQL> set recordbuf on; > > SQL> select first 3 rdb$trigger_name, rdb$relation_name > from rdb$triggers; > > > > RDB$TRIGGER_NAME RDB$RELATION_NAME > >

[Firebird-devel] Idleness

2014-05-07 Thread Claudio Valderrama C.
nyway, idleness in classic Greece was the task of the philosophers. The vulgar people did business. ;-) C. --- Claudio Valderrama C. Consultant, SW developer. -- Is your legacy SCM system holding you back? Join Perforce Ma

Re: [Firebird-devel] Fb3 gbak problem

2014-05-07 Thread Claudio Valderrama C.
> -Original Message- > From: Philippe Makowski [mailto:pmakow...@ibphoenix.fr] > Sent: Miércoles, 07 de Mayo de 2014 3:05 > > Hi, > > just for information, seems that some last commit broke > something in gbak : > > sudo /opt/firebird/bin/gbak -c /home/vagrant/fbtest.fbk > localhost:/

Re: [Firebird-devel] Cleaning up transaction info

2014-05-07 Thread Claudio Valderrama C.
> -Original Message- > From: Mark Rotteveel [mailto:m...@lawinegevaar.nl] > Sent: Martes, 06 de Mayo de 2014 15:41 > > This leads me to the questions: > 1) When are prepared or rolled back transactions removed from > RDB$TRANSACTIONS? Or are they kept indefinitely? > 2) Is there an alter

Re: [Firebird-devel] Fb3 gbak problem

2014-05-07 Thread Claudio Valderrama C.
> -Original Message- > From: Philippe Makowski [mailto:pmakow...@ibphoenix.fr] > Sent: Miércoles, 07 de Mayo de 2014 3:05 > > just for information, seems that some last commit broke > something in gbak : > > sudo /opt/firebird/bin/gbak -c /home/vagrant/fbtest.fbk > localhost:/home/vagr

Re: [Firebird-devel] Cleaning up transaction info

2014-05-06 Thread Claudio Valderrama C.
> -Original Message- > From: Mark Rotteveel [mailto:m...@lawinegevaar.nl] > Sent: Martes, 06 de Mayo de 2014 15:41 > > After successfully recovering a transaction that way, the current > implementation in Jaybird deletes the entry in RDB$TRANSACTIONS > (probably as a form of house-keepin

Re: [Firebird-devel] Questions on External Sort logic

2014-05-04 Thread Claudio Valderrama C.
> -Original Message- > From: Thomas Steinmaurer [mailto:t...@iblogmanager.com] > Sent: Domingo, 04 de Mayo de 2014 5:43 > > > > Personally, I find it frustrating to what Firebird disk IO > profile when performing large select/sorts, on systems which > have IO to burn (RAM Disk, SSD or PC

Re: [Firebird-devel] Not handled correctly is such a design in LegacyAPI.

2014-05-04 Thread Claudio Valderrama C.
> -Original Message- > From: Simonov Denis [mailto:sim-m...@list.ru] > Sent: Domingo, 04 de Mayo de 2014 5:11 > > > Not handled correctly is such a design in Legacy API. > > IBExpert > > execute block > as > begin > suspend; > end > > FB2.5 > > No result. It's good. I would say

[Firebird-devel] [FB-Tracker] Created: (CORE-4415) Useless extraction of generic DDL trigger

2014-05-01 Thread Claudio Valderrama C. (JIRA)
: 3.0 Alpha 2, 3.0 Alpha 1 Reporter: Claudio Valderrama C. The example uses the SHOW command, but extracting a script produces the same result: SQL> create trigger tr before any ddl statement as begin end; SQL> show trigger tr; TR, Sequence: 0, Type: BEFORE CREATE TABLE OR ALTER

[Firebird-devel] [FB-Tracker] Created: (CORE-4413) Gpre produces invalid DDL for FB3

2014-05-01 Thread Claudio Valderrama C. (JIRA)
Alpha 1, 3.0 Beta 1, 3.0 RC 1, 3.0 Beta 2, 3.0.0 Reporter: Claudio Valderrama C. Priority: Minor When GPRE v3 is asked to generate code for DB objects creation, it emits DYN, but DYN is not available in FB3. -- This message is automatically generated by JIRA. - If you

[Firebird-devel] [FB-Tracker] Created: (CORE-4412) Conflicting ordering clauses

2014-05-01 Thread Claudio Valderrama C. (JIRA)
, 2.5.2 Update 1, 2.1.5 Update 1, 2.5.2, 2.1.5, 2.1.6, 2.5.3, 3.0 Beta 1, 3.0 RC 1, 3.0 Beta 2, 2.5.4, 3.0.0 Reporter: Claudio Valderrama C. Priority: Minor Currently, it's possible to do select ... order by field asc, field desc; The first one wins; the second is ig

[Firebird-devel] [FB-Tracker] Created: (CORE-4411) Implicit objects should have their own number in rdb$system_flag

2014-05-01 Thread Claudio Valderrama C. (JIRA)
: Improvement Components: Engine Affects Versions: 3.0 Alpha 2, 3.0 Alpha 1, 2.5.2 Update 1, 2.1.5 Update 1, 2.5.2, 2.1.5, 2.1.6, 2.5.3, 3.0 Beta 1, 3.0 RC 1, 3.0 Beta 2, 2.5.4, 3.0.0 Reporter: Claudio Valderrama C. Currently, only generators used to implement identity columns

Re: [Firebird-devel] Planning the post v3 development

2014-04-29 Thread Claudio Valderrama C.
> -Original Message- > From: Dmitry Yemanov [mailto:firebi...@yandex.ru] > Sent: Martes, 29 de Abril de 2014 3:44 > > 29.04.2014 01:21, Claudio Valderrama C. wrote: > > > I know people will feel outraged with my opinion, but > anyway: make DDL > >

Re: [Firebird-devel] Planning the post v3 development

2014-04-28 Thread Claudio Valderrama C.
> -Original Message- > From: Dimitry Sibiryakov [mailto:s...@ibphoenix.com] > Sent: Lunes, 28 de Abril de 2014 18:03 > > 28.04.2014 23:21, Claudio Valderrama C. wrote: > > I know people will feel outraged with my opinion, but > anyway: make DDL > > o

Re: [Firebird-devel] Planning the post v3 development

2014-04-28 Thread Claudio Valderrama C.
> -Original Message- > From: Dalton Calford [mailto:dalton.calf...@gmail.com] > Sent: Lunes, 28 de Abril de 2014 11:49 > > For example, you could put each schema into a remote > server/database, allowing for basic clustering (before you > jump on me, I know it is more complex than that,

Re: [Firebird-devel] Planning the post v3 development

2014-04-28 Thread Claudio Valderrama C.
> -Original Message- > From: Dmitry Yemanov [mailto:firebi...@yandex.ru] > Sent: Lunes, 28 de Abril de 2014 14:21 > > > 7) It is known that mixing DDL/DML in the same transaction can cause > > corruption in DBs. If this cannot be 100% fixed, I suggest to > > introduce some mechanism to de

Re: [Firebird-devel] Planning the post v3 development

2014-04-28 Thread Claudio Valderrama C.
> -Original Message- > From: Carlos H. Cantu [mailto:lis...@warmboot.com.br] > Sent: Lunes, 28 de Abril de 2014 12:30 > > DY> Thanks, but I seemed to explicitly state that plain > wishlists don't > DY> count. > > It seems that I also didn't understand that you wanted separated > message

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4403) Allow referencing cursors as record variables in PSQL

2014-04-24 Thread Claudio Valderrama C.
> -Original Message- > From: Dmitry Yemanov (JIRA) [mailto:trac...@firebirdsql.org] > Sent: Jueves, 24 de Abril de 2014 10:55 > > Either explicit (DECLARE AS CURSOR) or implicit (FOR SELECT) > PSQL cursors could make their current record available via > the cursor name similar to OLD/NE

Re: [Firebird-devel] isql v3 with older servers

2014-04-15 Thread Claudio Valderrama C.
> -Original Message- > From: Dimitry Sibiryakov [mailto:s...@ibphoenix.com] > Sent: Martes, 15 de Abril de 2014 12:00 > >The only version-depended part of isql is metadata > extraction. I don't think that there > is a point to worry about its compatibility. I think that extracting

[Firebird-devel] isql v3 with older servers

2014-04-15 Thread Claudio Valderrama C.
on of server, but how much backwards compatibility do we want for isql? For example, gbak tries to cater for several versions. Let's make a clear and definitive statement once for all, please. C. --- Claudio Valderrama C. Consultant, SW

Re: [Firebird-devel] Bad constant specification in common.h

2014-04-11 Thread Claudio Valderrama C.
> -Original Message- > From: Mark Rotteveel [mailto:m...@lawinegevaar.nl] > Sent: Viernes, 11 de Abril de 2014 2:58 > > Visual Studio (and related libraries like MS VC) have an end-of-life > policy; I'd suggest we only support and use products that are > in mainstream > support. For 2008

[Firebird-devel] Bad constant specification in common.h

2014-04-10 Thread Claudio Valderrama C.
1400)) #define QUADCONST(n) (n##LL) #else #define QUADCONST(n) (n) #endif C. --- Claudio Valderrama C. Consultant, SW developer. -- Put Bad Developers to Shame Dominate Development with Jenkins Continuous Integration Co

[Firebird-devel] Rogue trigger plays tricks on the poor isql

2014-04-10 Thread Claudio Valderrama C.
++ + Ouch! Since I didn't do the code, I would prefer to not put my muddy paws there. The presence of OR OR in the output seems to indicate that the mask defined as const FB_UINT64 TRIGGER_TYPE_MASK = (QUADCONST(3) << TRIGGER_TYPE_SHIFT

Re: [Firebird-devel] Implemented STEP for generators / sequences

2014-04-08 Thread Claudio Valderrama C.
> -Original Message- > From: Simonov Denis [mailto:sim-m...@list.ru] > Sent: Miércoles, 09 de Abril de 2014 1:27 > > Ability to specify the step for generators / sequences is > very good. But I > think the syntax would be much closer to the standard. So in > Oracle / MS > SQL / Post

[Firebird-devel] classes\InternalMessageBuffer.h

2014-04-08 Thread Claudio Valderrama C.
included in other places. C. --- Claudio Valderrama C. Consultant, SW developer. -- Put Bad Developers to Shame Dominate Development with Jenkins Continuous Integration Continuously Automate Build, Test & Deployment

Re: [Firebird-devel] Regression: systemgeneratorRDB$BACKUP_HISTORYcannot be modified

2014-04-08 Thread Claudio Valderrama C.
> -Original Message- > From: Vlad Khorsun [mailto:hv...@users.sourceforge.net] > Sent: Martes, 08 de Abril de 2014 3:06 > > >> > Unfortunately, rdb$backup_history is the only sys gen > >> that's not modified > >> > from an internal request. > >> > >> Time to use triggers and INSERT

Re: [Firebird-devel] Regression: system generatorRDB$BACKUP_HISTORY cannot be modified

2014-04-07 Thread Claudio Valderrama C.
> -Original Message- > From: Vlad Khorsun [mailto:hv...@users.sourceforge.net] > Sent: Martes, 08 de Abril de 2014 2:38 > > > Unfortunately, rdb$backup_history is the only sys gen > that's not modified > > from an internal request. > > Time to use triggers and INSERT RETURNING ? :)

Re: [Firebird-devel] Confusing BLR constants.

2014-04-07 Thread Claudio Valderrama C.
> -Original Message- > From: Dmitry Yemanov [mailto:firebi...@yandex.ru] > Sent: Martes, 08 de Abril de 2014 2:12 > > > > Extending an idea it would be good to rename all such > constants in the > > same manner. No? > > Perhaps. But formally, BLR is a part of the public API, such a chang

Re: [Firebird-devel] Regression: system generator RDB$BACKUP_HISTORYcannot be modified

2014-04-07 Thread Claudio Valderrama C.
> -Original Message- > From: Alex Peshkoff [mailto:peshk...@mail.ru] > Sent: Lunes, 07 de Abril de 2014 11:53 > > Hi all! > > nbackup in trunk is broken: > > fbs bin # ./nbackup -b 0 employee l0.nbk > [ > PROBLEM ON "execute history insert". > System generator RDB$BACKUP_HISTORY cannot

[Firebird-devel] Confusing BLR constants.

2014-04-07 Thread Claudio Valderrama C.
People, I think I'm not the only one that has been misled by the BRL symbols blr_boolean and blr_bool. I propose to rename them blr_boolean -> blr_boolean_op blr_bool -> blr_boolean_type. Even if awkward to write, the names avoid the current confusion. C. --- Claudio Valderrama C. Con

[Firebird-devel] Sort with conflicting options

2014-04-05 Thread Claudio Valderrama C.
some reason to allow that. C. --- Claudio Valderrama C. Consultant, SW developer. -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] The invisible generator and the rdb$ prefix

2014-04-03 Thread Claudio Valderrama C.
> -Original Message- > From: Leyne, Sean [mailto:s...@broadviewsoftware.com] > Sent: Domingo, 30 de Marzo de 2014 14:31 > To: For discussion among Firebird Developers > > Claudio, > > > To the dismay of Sean, I continue saying that while we > don't declare "name > > independence" and co

[Firebird-devel] Code the needs revision

2014-04-03 Thread Claudio Valderrama C.
tachment. Hence, the condition (attachment->att_flags & ATT_gbak_attachment) seems impossible. I could delete that part of the condition or someone please suggest another interpretation. Maybe the code was intended to run when someone is running a script with objects creation in an actively use

Re: [Firebird-devel] garbage_collect_idx() doesn't work?..

2014-03-29 Thread Claudio Valderrama C.
> -Original Message- > From: Vlad Khorsun [mailto:hv...@users.sourceforge.net] > Sent: Sábado, 29 de Marzo de 2014 15:07 > b) VIO_verb_cleanup() also can't use more than one instance > of record buffer itself but it could call verb_post() > while record buffer is already used:

[Firebird-devel] The invisible generator and the rdb$ prefix

2014-03-29 Thread Claudio Valderrama C.
il a sys domain. I can't go back because the system protects the data integrity: SQL> alter domain rdb$linger type int; Statement failed, SQLSTATE = 42000 unsuccessful metadata update -ALTER DOMAIN RDB$LINGER failed -Cannot change datatype for RDB$LINGER. Conver

Re: [Firebird-devel] Gpre and DYN

2014-03-27 Thread Claudio Valderrama C.
> -Original Message- > From: Alex Peshkoff [mailto:peshk...@mail.ru] > Sent: Viernes, 21 de Marzo de 2014 3:02 > > On 03/21/14 01:38, Claudio Valderrama C. wrote: > >> -Original Message- > >> From: Alex [mailto:peshk...@mail.ru] > >>

[Firebird-devel] Doubt in jrd.cpp's dropDatabase

2014-03-23 Thread Claudio Valderrama C.
w->sdw_file) || err; because I think we want to drop as much files as possible. Comments? C. --- Claudio Valderrama C. Consultant, SW developer. -- Learn Graph Databases - Download FREE O'Reilly Book "Graph Data

Re: [Firebird-devel] RFC: stop fiddling with sys tables

2014-03-20 Thread Claudio Valderrama C.
> -Original Message- > From: Thomas Beckmann [mailto:thomas.beckm...@assfinet.de] > Sent: Viernes, 21 de Marzo de 2014 2:26 > > Hm, I'm using read access to system tables quite a bit, We are speaking about stopping DIRECT WRITES to sys tables. READS will be allowed as always. People can

Re: [Firebird-devel] RFC: stop fiddling with sys tables

2014-03-20 Thread Claudio Valderrama C.
> -Original Message- > From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] > Sent: Jueves, 20 de Marzo de 2014 21:34 > > On 20-03-2014 18:38, Claudio Valderrama C. wrote: > > - Using ATT_gbak_attachment is a security risk, but I don't > know how

Re: [Firebird-devel] Sysdba not defined by default?

2014-03-20 Thread Claudio Valderrama C.
> -Original Message- > From: Claudio Valderrama C. [mailto:cva...@usa.net] > Sent: Jueves, 20 de Marzo de 2014 16:51 > > F:\fb3dev\fbbuild\firebird30\temp\Win32\Debug\firebird>isql > localhost:x.fdb > -user sysdba -pass masterkey > Statement failed, SQLSTATE =

Re: [Firebird-devel] RFC: stop fiddling with sys tables

2014-03-20 Thread Claudio Valderrama C.
> -Original Message- > From: Leyne, Sean [mailto:s...@broadviewsoftware.com] > Sent: Jueves, 20 de Marzo de 2014 18:05 > > > - Creating user objects with RDB$ prefix should be > forbidden (at least until > > we implement schemas). > > Why? > > RDB$System_Flag already exists in RDB$Rela

Re: [Firebird-devel] RFC: stop fiddling with sys tables

2014-03-20 Thread Claudio Valderrama C.
> -Original Message- > From: Leyne, Sean [mailto:s...@broadviewsoftware.com] > Sent: Jueves, 20 de Marzo de 2014 18:46 > > >That's what DDL triggers are for. They can write change > > log to a user table, > > no need to touch system ones. > > OK, but since DDL Triggers don't yet exi

[Firebird-devel] RFC: stop fiddling with sys tables

2014-03-20 Thread Claudio Valderrama C.
user should be given the possibility of messing everything at will if it activates a flag. From this POV, checking rights in code is (for me) more flexible than a set of ACLs for sys tables. Comments? C. --- Claudio Valderrama C. Consultant, SW developer. --

Re: [Firebird-devel] Gpre and DYN

2014-03-20 Thread Claudio Valderrama C.
> -Original Message- > From: Alex [mailto:peshk...@mail.ru] > Sent: Miércoles, 19 de Marzo de 2014 3:09 > > > On 03/19/2014 10:40 AM, Claudio Valderrama C. wrote: > >> > > Alex said: > >> Main idea was to be able to generate programs for olde

[Firebird-devel] Sysdba not defined by default?

2014-03-20 Thread Claudio Valderrama C.
s a global user, I should not need to create it. If I try an unknown user but without password, I don't get the "fetch past the last record". Same if I try a known user but with the wrong pw. C. --- Claudio Valderrama C. Consultant, SW developer. ---

Re: [Firebird-devel] Gpre and DYN

2014-03-18 Thread Claudio Valderrama C.
> -Original Message- > From: Alex [mailto:peshk...@mail.ru] > Sent: Miércoles, 19 de Marzo de 2014 1:16 > >>> > Adriano: > >> Why the engine error message about unsupported DYN is not > sufficient? > > Steve: > > < and discovering that > > the DDL doesn't work when you compile the preproc

Re: [Firebird-devel] Gpre and DYN

2014-03-18 Thread Claudio Valderrama C.
> -Original Message- > From: Adriano dos Santos Fernandes [mailto:adrian...@gmail.com] > Sent: Martes, 18 de Marzo de 2014 11:25 > > On 18/03/2014 13:09, Claudio Valderrama C. wrote: > > People, GPRE's cmd.cpp and sql.cpp generate a lot of DYN commands. >

[Firebird-devel] Gpre and DYN

2014-03-18 Thread Claudio Valderrama C.
People, GPRE's cmd.cpp and sql.cpp generate a lot of DYN commands. FB3 doesn't understand DYN. What should we do, disable those places in GPRE with an error message? C. --- Claudio Valderrama C. Consultant, SW

Re: [Firebird-devel] IMessageMetadata::getLength() - const?

2014-03-11 Thread Claudio Valderrama C.
> -Original Message- > From: Dimitry Sibiryakov [mailto:s...@ibphoenix.com] > Sent: Martes, 11 de Marzo de 2014 5:15 > > 11.03.2014 6:38, Alex wrote: > > On 03/09/2014 03:43 PM, Dimitry Sibiryakov wrote: > > > > For me it looks like historical artifact from some old > > implementation. >

Re: [Firebird-devel] MySQL versus Firebird

2014-03-11 Thread Claudio Valderrama C.
> I needed comments from developers also > > On Tue, Mar 11, 2014 at 8:46 AM, Claudio Valderrama C. > wrote: > >> -Original Message- > >> From: marius adrian popa [mailto:map...@gmail.com] > >> Sent: Lunes, 10 de Marzo de 2014 3:00 > >> >

Re: [Firebird-devel] MySQL versus Firebird

2014-03-11 Thread Claudio Valderrama C.
> -Original Message- > From: Dmitry Kovalenko [mailto:dmitry.lipe...@gmail.com] > Sent: Martes, 11 de Marzo de 2014 5:00 > > Allow me behead him. > > Dmitry Kovalenko. You can beat him with a whip made of barbed wire if you want, but you don't have permission to kill him. Marius is a ti

Re: [Firebird-devel] MySQL versus Firebird

2014-03-10 Thread Claudio Valderrama C.
> -Original Message- > From: marius adrian popa [mailto:map...@gmail.com] > Sent: Lunes, 10 de Marzo de 2014 3:00 > > I decided to compare the current versions of MySQL 5.6 and Firebird > SQL 2.5. I only looked at features that end users can see, without > benchmarking. http://ocelot.ca/b

  1   2   >