17.06.2020 21:34, Adriano dos Santos Fernandes wrote:
So it's about this, correct?
-- Uses two index segments
select registro_sec_roest from dp_registro_oest where registro_pri_roest
= 1 and registro_sec_roest = 1;
-- Uses one index segment - more generalization of IN problem
select registro_s
On 17/06/2020 19:45, liviuslivius wrote:
> Are you sure?
> It shoul use 2 as it i equal to
> (registro_pri_roest = 1 and registro_sec_roest = 1) or
> (registro_pri_roest = 1 and registro_sec_roest = 2)
>
With this the two segments is used in the plan.
But then I see what Dmitry said about Condi
Are you sure?It shoul use 2 as it i equal to(registro_pri_roest = 1 and
registro_sec_roest = 1) or(registro_pri_roest = 1 and registro_sec_roest = 2)
Regards,Karol Bieniaszewski
Oryginalna wiadomość Od: Adriano dos Santos Fernandes
Data: 17.06.2020 21:00 (GMT+01:00) Do:
fire
> 18.06.2020 00:00, Leyne, Sean wrote:
> > "they" is also accepted as a singular, although it seems ungrammatical.
>
>Ok, thanks.
>
>BTW, when you start your search-and-replace work, don't forget to find
> substitutions for "owner", "invalid", "dependency" and "creator". First and
> t
18.06.2020 00:00, Leyne, Sean wrote:
"they" is also accepted as a singular, although it seems ungrammatical.
Ok, thanks.
BTW, when you start your search-and-replace work, don't forget to find substitutions
for "owner", "invalid", "dependency" and "creator". First and third offend ex-slave
>I don't know English well enough, sorry. What is singular for "they"?
> "This"..?
"they" is also accepted as a singular, although it seems ungrammatical.
"you" or "them" are also accepted.
Sean
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listin
On 17/06/2020 14:56, Dmitry Yemanov wrote:
>
> The difference is in the sub-query plan, there's no ConditionalStream
> there. So it doesn't make any difference whether is NULL or not,
> in both cases index for COLUMN = VALUE is simply not used thus returning
> the same result set for the every in
17.06.2020 21:55, Mark Rotteveel wrote:
the commonly accepted gender-neutral term is singular they.
I don't know English well enough, sorry. What is singular for "they"?
"This"..?
--
WBR, SD.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/fir
On 16-06-2020 21:51, Pavel Cisar wrote:
Certainly! And when we'll be at that, we should also use strictly
gender-neutral terms everywhere and replace the red color with rainbow
in our logo!
Hail to the correctness, take no prisoners!
I think this is rather insensitive and tone-deaf. Using
p
On 2020-06-17 22:00, Dimitry Sibiryakov wrote:
17.06.2020 18:18, Alex Peshkoff via Firebird-devel wrote:
Auth block 2, length 80
AUTH_TYPE: USER
AUTH_NAME: SD
BTW, can I rely on fact that AUTH_TYPE is always come before
AUTH_NAME in the block?
Better not
On 17-06-2020 11:13, Dimitry Sibiryakov wrote:
17.06.2020 02:57, Leyne, Sean wrote:
I don't see why we shouldn't be doing the same.
Because we have no resources and time to waste to it...?
But I found idea to be gender-neutral very attractive. From this on
I'll use politically correc
17.06.2020 21:03, Leyne, Sean wrote:
I think that "replica" clearly denotes that it is "controlled"
Equally, "destination" clearly denotes that it is "not controlled".
Fortunately FireSwarm is a multimaster system. Or should I care and rename it into
peer-to-peer?..
--
WBR, SD.
Firebi
> That's for example the case of "replica" instead "slave" in replication
> context.
> But master/slave is still the best method to explain or refer to
> controller/controlled principle that is accurate in all languages and does not
> need a thousand words, and master is still best term to descr
On 17/06/2020 15:46, Leyne, Sean wrote:
>
>> So it's about this, correct?
>>
>> -- Uses two index segments
>> select registro_sec_roest from dp_registro_oest where registro_pri_roest = 1
>> and registro_sec_roest = 1;
>>
>> -- Uses one index segment - more generalization of IN problem select
>> reg
17.06.2020 18:18, Alex Peshkoff via Firebird-devel wrote:
Auth block 2, length 80
AUTH_TYPE: USER
AUTH_NAME: SD
BTW, can I rely on fact that AUTH_TYPE is always come before AUTH_NAME in the
block?
--
WBR, SD.
Firebird-Devel mailing list, web interface at
Adriano,
Dne 17. 06. 20 v 18:52 Adriano dos Santos Fernandes napsal(a):
You like or not, the market will do things and specifically about
replication, the terms where being changed already and will advance.
There is no dispute that terminology evolves and if there are terms that
are more acc
> So it's about this, correct?
>
> -- Uses two index segments
> select registro_sec_roest from dp_registro_oest where registro_pri_roest = 1
> and registro_sec_roest = 1;
>
> -- Uses one index segment - more generalization of IN problem select
> registro_sec_roest from dp_registro_oest where r
On 17/06/2020 14:56, Dmitry Yemanov wrote:
> 17.06.2020 19:42, Adriano dos Santos Fernandes wrote:
>>
>>> Unfortunately, not exactly so. ConditionalStream is good only when
>>> choice is between NATURAL and INDEX plans. It cannot be used when
>>> choosing between good and bad index matches.
>>>
>>>
On 17/06/2020 14:56, Dmitry Yemanov wrote:
> 17.06.2020 19:42, Adriano dos Santos Fernandes wrote:
>>
>>> Unfortunately, not exactly so. ConditionalStream is good only when
>>> choice is between NATURAL and INDEX plans. It cannot be used when
>>> choosing between good and bad index matches.
>>>
>>>
17.06.2020 19:42, Adriano dos Santos Fernandes wrote:
Unfortunately, not exactly so. ConditionalStream is good only when
choice is between NATURAL and INDEX plans. It cannot be used when
choosing between good and bad index matches.
Currently, your PR shows a regression for CORE-5236, subquery
On 2020-06-17 19:50, Dimitry Sibiryakov wrote:
17.06.2020 18:18, Alex Peshkoff via Firebird-devel wrote:
Ignore and keep 'as is'. They are needed if later that block is
passed once again to mapping code (after execute statement for example).
Unfortunately SQLConnect() accepts only plain user
On 17/06/2020 13:26, Pavel Cisar wrote:
> Sean,
>
> Dne 17. 06. 20 v 17:09 Leyne, Sean napsal(a):
>>
>> Time to perform a simple search and replace!?!!
>>
>> If the terms being discussed were "commie", "chink", "pollack",
>> "spik" "n.gg.r" would they be any less problematic?
>
> More argument fall
17.06.2020 18:18, Alex Peshkoff via Firebird-devel wrote:
Ignore and keep 'as is'. They are needed if later that block is passed once again to
mapping code (after execute statement for example).
Unfortunately SQLConnect() accepts only plain user name and password so ignoring them
is the only
On 16/06/2020 13:00, Dmitry Yemanov wrote:
>
> Unfortunately, not exactly so. ConditionalStream is good only when
> choice is between NATURAL and INDEX plans. It cannot be used when
> choosing between good and bad index matches.
>
> Currently, your PR shows a regression for CORE-5236, subquery uses
17.06.2020 18:14, Alex Peshkoff via Firebird-devel wrote:
If they are OK for VS now in use - why not?
ExtAuth has dependency (hardcoded include path) to TomCrypt library which is a problem
out of Firebird source tree. The rest seems to be ok so far.
--
WBR, SD.
Firebird-Devel mailing l
Sean,
Dne 17. 06. 20 v 17:09 Leyne, Sean napsal(a):
Time to perform a simple search and replace!?!!
If the terms being discussed were "commie", "chink", "pollack", "spik" "n.gg.r"
would they be any less problematic?
More argument fallacies? C'mon! I'm sure you can do better.
Would we be a
On 2020-06-17 18:56, Dimitry Sibiryakov wrote:
Hello All.
In my provider I'm getting following auth block:
isc_dpb_auth_block
Auth block 0, length 53
AUTH_TYPE: Seen
AUTH_SECURE_DB: C:\PROGRAMS\FIREBIRD\FIREBIRD4.X86\TEST
Auth block 1, length 62
On 2020-06-17 17:31, Dimitry Sibiryakov wrote:
14.06.2020 13:17, Dimitry Sibiryakov wrote:
Are these project supposed to be included into distribution packages?
Nobody cares? Ok...
If they are OK for VS now in use - why not?
Firebird-Devel mailing list, web interface at
https://li
Hello All.
In my provider I'm getting following auth block:
isc_dpb_auth_block
Auth block 0, length 53
AUTH_TYPE: Seen
AUTH_SECURE_DB: C:\PROGRAMS\FIREBIRD\FIREBIRD4.X86\TEST
Auth block 1, length 62
17.06.2020 17:22, Leyne, Sean wrote:
If someone would help me with git, I would more than happily do it.
Git have a very good documentation. Just type "git help" in command line.
--
WBR, SD.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/fireb
> > >> If it does not belong to both them?
> >
> > Its usege should be considered as use at own risk.
>
> That's not apropriate when working on a project as a group.
I agree the usage cannot/should not be ambiguous.
I believe that there already is an established pattern for "allow"/"deny" lis
> 17.06.2020 17:09, Leyne, Sean wrote:
> > Time to perform a simple search and replace!?!!
>
>Ah, ok. Feel free to prepare PR.
If someone would help me with git, I would more than happily do it.
(Just as I helped cleaning up the original FB codebase on legacy arch's).
Sean
Firebird-D
17.06.2020 17:09, Leyne, Sean wrote:
Time to perform a simple search and replace!?!!
Ah, ok. Feel free to prepare PR.
--
WBR, SD.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
> > I don't see why we shouldn't be doing the same.
>
>Because we have no resources and time to waste to it...?
Time to perform a simple search and replace!?!!
If the terms being discussed were "commie", "chink", "pollack", "spik" "n.gg.r"
would they be any less problematic?
Would we
14.06.2020 13:17, Dimitry Sibiryakov wrote:
Are these project supposed to be included into distribution packages?
Nobody cares? Ok...
--
WBR, SD.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 2020-06-17 15:44, Karol Bieniaszewski wrote:
>> If feature belongs to both lists - is it allowed or denied?
Please explain how? 😊
By mistake.
>> If it does not belong to both them?
Its usege should be considered as use at own risk.
That's not apropriate when working on a project as
>> If feature belongs to both lists - is it allowed or denied?
Please explain how? 😊
>> If it does not belong to both them?
Its usege should be considered as use at own risk.
regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinf
17.06.2020 14:33, Dimitry Sibiryakov wrote:
What is coding style rules about indents? Only tabs are allowed?
https://firebirdsql.org/en/coding-style/
#38. Tabs are allowed and must be used for indentation.
Dmitry
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net
Hello All.
What is coding style rules about idents? Only tabs are allowed?
--
WBR, SD.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
17.06.2020 12:35, Lester Caine wrote:
Same discussion is going on on many lists
Yeah, a million of lemmings can't run wrong.
--
WBR, SD.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
On 17/06/2020 10:13, Dimitry Sibiryakov wrote:
17.06.2020 02:57, Leyne, Sean wrote:
I don't see why we shouldn't be doing the same.
Because we have no resources and time to waste to it...?
Same discussion is going on on many lists but the general consensus
seems to be to wait until some
INSERT ... RETURNING does not require a SELECT privilege
Key: CORE-6335
URL: http://tracker.firebirdsql.org/browse/CORE-6335
Project: Firebird Core
Issue Type: Bug
Components
On 2020-06-16 19:53, Karol Bieniaszewski wrote:
>> we may have black list instead white list like now.
As always better is to have both black + white.
Both lists is something non logical. If feature belongs to both lists -
is it allowed or denied? If it does not belong to both them?
Fi
17.06.2020 02:57, Leyne, Sean wrote:
I don't see why we shouldn't be doing the same.
Because we have no resources and time to waste to it...?
But I found idea to be gender-neutral very attractive. From this on I'll use
politically correct word "it" instead of offending "he" and "she" in
Dne 17. 06. 20 v 2:57 Leyne, Sean napsal(a):
If much larger projects than ours can make these changes, I don't see why we
shouldn't be doing the same.
When I was a kid and came up with such classic "Bandwagon Fallacy", my
mother asked me "If others would go and jump off the cliff, does it
45 matches
Mail list logo
