Re: [Firebird-devel] Is batch release necessary in the wire protocol?

2022-07-26 Thread Leyne, Sean
> -Original Message- > From: Alex Peshkoff via Firebird-devel de...@lists.sourceforge.net> > On 7/26/22 14:39, Mark Rotteveel wrote: > > On 16-07-2022 10:54, Mark Rotteveel wrote: > >> Is sending op_batch_rls necessary in the wire protocol, or is closing > >> the statement itself

Re: [Firebird-devel] isc_dpb_dbkey_scope

2022-05-19 Thread Leyne, Sean
ection level approach required? The 2 approaches provide the same outcome, no? Sean > On 5/19/2022 2:35 PM, Leyne, Sean wrote: > > > >> -Original Message- > >> From: Paul Beach > >> Sent: May 19, 2022 12:10 PM > >> It maintains al

Re: [Firebird-devel] isc_dpb_dbkey_scope

2022-05-19 Thread Leyne, Sean
> -Original Message- > From: Paul Beach > Sent: May 19, 2022 12:10 PM > It maintains all the rdb$db_key values for the length of a connection - i.e. > they are not allowed to change. An internal transaction gets started for this. > It was introduced to support Cognos' Powerhouse 4GL

Re: [Firebird-devel] Commit (un)certainity

2022-01-11 Thread Leyne, Sean
> Mark Rotteveel wrote 06.01.2022 13:06: > > BTW: I think in most cases you should be able to infer from the socket > > error if the problem occurred on sending or on reading data (at least, > > when using blocking socket reads/writes, not sure about non-blocking). > >It is not true: > >

Re: [Firebird-devel] WNET future

2021-11-30 Thread Leyne, Sean
> Leyne, Sean wrote 30.11.2021 17:15: > > (We have 200+ servers deployed and none of them use (have never) > WNET > >With dropping this option ability to open database file from mounted > network drive also will be dropped (or at least must be heavily reworked). Wh

Re: [Firebird-devel] WNET future

2021-11-30 Thread Leyne, Sean
> On 30/11/2021 10:24, Jiří Činčura wrote: > > My vote goes to dropping it. > > > > Agreed. +1 (We have 200+ servers deployed and none of them use (have never) WNET Sean Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Function to generate random bytes

2021-05-24 Thread Leyne, Sean
> On 23-05-2021 19:58, Leyne, Sean wrote: > > A comment from a "simple language" POV. > > > > While "IV" or "Initialization Vector" are the technically correct terms, I > > would > suggest that we use the term "seed" or &qu

Re: [Firebird-devel] Function to generate random bytes

2021-05-23 Thread Leyne, Sean
Mark, > I was polishing the Language Reference for Firebird 4.0, and I noticed that we > seem to be missing a function to use with ENCRYPT: > > A function to generate a BINARY (or VARBINARY) of a specified size populated > with random bytes (from a secure random number generator). A lot of >

Re: [Firebird-devel] Increasing CHAR/VARCHAR max. length to 64KB

2021-05-21 Thread Leyne, Sean
> >> dsc_length is currently the descriptor's physical length. With the > >> change it will represent a logical length. To support that I added > >> getPhysicalLength() method to struct dsc returning an unsigned 32-bit > >> that sums +2/+1 for dtype_varying/dtype_cstring. > > > > During such

Re: [Firebird-devel] Change metadata domain from "DOUBLE PRECISION" to "BIGINT"

2021-02-23 Thread Leyne, Sean
Karol, > Why not standard way by creating new field copy data delete old and > rename? > > It can be slow operation, is it your conern to do not take production database > too long offline? If yes, you can speed up such process if you have access to > good hardware with a loot of RAM and do all

Re: [Firebird-devel] SIO_LOOPBACK_FAST_PATH deprecated

2021-02-01 Thread Leyne, Sean
Vlad, > https://www.gitmemory.com/issue/grpc/grpc/18057/486312183 There is no mention of SIO_LOOPBACK_FAST_PATH in this link > https://support.microsoft.com/en-us/topic/stop-error-0xd1-when-you-set- > the-sio-loopback-fast-path-flag-in-windows-8-or-windows-server-2012- >

Re: [Firebird-devel] SIO_LOOPBACK_FAST_PATH deprecated

2021-02-01 Thread Leyne, Sean
Seems that is just a warning , googling about it and they offer no alternative to replace it https://stackoverflow.com/questions/57610475/sio-loopback-fast-path-replacement I suspect that Microsoft is quietly ignoring the API call/settings when used – otherwise, they would have provided

Re: [Firebird-devel] Local table in repicated database

2021-01-25 Thread Leyne, Sean
Karol et al, Question about other DB engines which support separate ‘schemas’/’schema spaces’. Do they support FK references across schema? Sean From: liviuslivius Sent: Saturday, January 23, 2021 6:29 PM To: For discussion among Firebird Developers Subject: Re: [Firebird-devel] Local

Re: [Firebird-devel] PSQL profiler

2020-09-27 Thread Leyne, Sean
> Here is link to pull request, starting with the README describing the > feature: > > https://github.com/FirebirdSQL/firebird/pull/285/files > > I have a doubt about permissions. > > If user can call procedure P1 but cannot himself call procedure P2, but > procedure > P1 can call P2, if

Re: [Firebird-devel] Should CRC32 function be part of HASH?

2020-08-10 Thread Leyne, Sean
> That old form is kept for backward compatibility. If your suggestion comes > true > (hope not) some idiot may try to use PJW as cryptographic hash. > > To summarize - I withdraw my initial agreement to add CRC32 calculation to > function HASH(). The only argument for this is same name in

[Firebird-devel] Emergency maintenance/potential outages for Firebird resources starting @ 4pm EDT/22:00 GMT today

2020-06-26 Thread Leyne, Sean
All, The cluster which is hosting some Firebird systems requires emergency maintenance to address a storage sub-system problem. The maintenance is expected to take 48 hours and may affect the following systems/resources: - tracker.firebirdsql.org - web.firebirdsql.org (where

Re: [Firebird-devel] ODP: Modern C++: constexpr

2020-06-18 Thread Leyne, Sean
>90 years passed since the last book burning. Hardly can anyone remember so > the new loop can start. Actually. Book burnings have been occurred much more recently. https://en.wikipedia.org/wiki/List_of_book-burning_incidents As recently, as 2013 in the US and 2019 in Poland. Sean

Re: [Firebird-devel] ODP: Modern C++: constexpr

2020-06-17 Thread Leyne, Sean
> 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",

Re: [Firebird-devel] ODP: Modern C++: constexpr

2020-06-17 Thread Leyne, Sean
>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

[Firebird-devel] Replication terminology (was: ODP: Modern C++: constexpr

2020-06-17 Thread Leyne, Sean
> 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

Re: [Firebird-devel] Odd difference for IN (..) and = ANY (..) in SELECT vs WHERE

2020-06-17 Thread Leyne, Sean
> 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

Re: [Firebird-devel] ODP: ODP: Modern C++: constexpr

2020-06-17 Thread Leyne, Sean
> > >> 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"

Re: [Firebird-devel] ODP: Modern C++: constexpr

2020-06-17 Thread Leyne, Sean
> 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). S

Re: [Firebird-devel] ODP: Modern C++: constexpr

2020-06-17 Thread Leyne, Sean
> > 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

Re: [Firebird-devel] ODP: Modern C++: constexpr

2020-06-16 Thread Leyne, Sean
> 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! If much larger projects than ours can make these changes, I don't see why we shouldn't

Re: [Firebird-devel] ODP: Modern C++: constexpr

2020-06-16 Thread Leyne, Sean
> >> we may have black list instead white list like now. > > As always better is to have both black + white. Even better would be "Allow" or "Allowed" and "Deny" or "Denied" terminology. Sean P.S.The same applies to the terms "master/slave" which should be "Primary/Replica" or

[Firebird-devel] Tracker outage June 3rd or June 4th 2020 between 8:00pm and 11:00pm EDT (GMT -4)

2020-06-01 Thread Leyne, Sean
All FYI, Our ISP has advised that they will be performing emergency maintenance work on their network infrastructure. This maintenance will result in a 5 to 10 minute outage window, which will affect project tracker access. Sean Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Error message 'Install incomplete' in FB4

2020-06-01 Thread Leyne, Sean
> On Fri, May 29, 2020, at 22:07, Leyne, Sean wrote: > > 1- SRP is not a commonly used protocol > > You mean in general or in Firebird? In general. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Error message 'Install incomplete' in FB4

2020-05-29 Thread Leyne, Sean
> > The default list should only contain options which are available > > without additional configuration or initialization. > > I disagree. > > The default should represent best practice, most sensible and reasonable > values. 1- SRP is not a commonly used protocol 2- If not for the extra

Re: [Firebird-devel] Error message 'Install incomplete' in FB4

2020-05-28 Thread Leyne, Sean
>If by default SRP is not initialized then by default it must not be in > list of auth > plugins and vice versa if it is in the default list, it must be always ready > to work. Completely agree! The fact that SRP is an available option does not mean that it should be in the default

Re: [Firebird-devel] Fwd: CASE statement Error : Datatypes are not comparable in expression CASE

2020-05-21 Thread Leyne, Sean
> This looks like a bug to me, could you report it on > http://tracker.firebirdsql.org/browse/CORE ? Could not disagree more!!! > After a more detailed analysis I have found the problem. > > I have run the upgrade process of my application that creates a table with one > field "DELETED" with

Re: [Firebird-devel] gbak and non-native ODS

2020-04-07 Thread Leyne, Sean
> > Sean, as soon as the database contains new features not supported in > > older versions one can not downgrade ODS version. > > That is not true for all changes. > > > > Restore (by gbak) of such database in a version which does not support > > actually used features is just nonsense. >

Re: [Firebird-devel] gbak and non-native ODS

2020-04-07 Thread Leyne, Sean
> Sean, as soon as the database contains new features not supported in older > versions one can not downgrade ODS version. That is not true for all changes. > Restore (by gbak) of such database in a version which does not support > actually > used features is just nonsense. Then how do

Re: [Firebird-devel] gbak and non-native ODS

2020-04-06 Thread Leyne, Sean
Alex, > >> If we keep it, let's decide what new tables can be ignored when > >> restoring backwards and what ones are mandatory and thus should raise > >> an error. We may also consider going half-way and limiting the > >> backward restore to the one prior ODS version -- this will also simplifies

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

2020-03-02 Thread Leyne, Sean
Holger, Please clarify > i had discusses their benchmark results already with a embarcadero > employee in a german forum and they insisted that tpc was bad > with firebird  and good with interbase. > > When i reproduced their description of the test on a known powerful firebird > machine and

Re: [Firebird-devel] Interbase vs Firebird by Embarcadero

2020-02-26 Thread Leyne, Sean
> What will be very interesting re journalling - compare interbase with > journalling and async writes vs. interbase without journalling and sync > writes. > This can give us an idea what effect does journalling give. Actually in order to be failsafe, journaling would also need to use

Re: [Firebird-devel] Protocol prefixes in URL-style connection strings

2020-02-04 Thread Leyne, Sean
Dmitry >Is subj supposed to be case-sensitive or not? You mean "http" or "https" of a URL? According to some quick searches, all aspects of a URL up to the end of the domain name is case incentive. So: HTTP://firebirdsql.org and http://firebirdsql.org are equivalent But

Re: [Firebird-devel] Stored procedures example

2020-02-03 Thread Leyne, Sean
It really should be rewritten/updated. 1. First select should use new type join kind not comma join kind. +1 2. Field po_number should be prefixed with alias of the table. +1 3. Order of exception and update should be reverted, sussped removed, also maybe this update should be run in

Re: [Firebird-devel] Replacing zlib with zstd was: Interesting changes in mysql 8.0.18

2019-10-23 Thread Leyne, Sean
> -Original Message- > From: Alex Peshkoff > Sent: Wednesday, October 23, 2019 3:38 AM > > On 10/22/19 6:19 PM, Leyne, Sean wrote: > >> It's faster but that makes no difference for our use cases. When > >> working with LAN passing uncompress

[Firebird-devel] Replacing zlib with zstd was: Interesting changes in mysql 8.0.18

2019-10-22 Thread Leyne, Sean
> It's faster but that makes no difference for our use cases. When working with > LAN passing uncompressed data is anyway the best option. > Compression makes sense only for very slow and/or very long (many hops) > WAN. Under that conditions compression's performance does not matter. If you are

Re: [Firebird-devel] Power efficient userspace waiting with the umwait x86 instructions

2019-09-16 Thread Leyne, Sean
Roman, > From: Roman Simakov > Sent: Monday, September 16, 2019 7:51 AM > I guess it would be interesting alternative for spinlock > (https://kernelnewbies.org/Linux_5.3) > 1.6. Power efficient userspace waiting with the umwait x86 instructions > > More description is here: >

Re: [Firebird-devel] Query statistics

2019-08-02 Thread Leyne, Sean
> >>> I was hoping to gather those details via MON$ tables. > >> > >> It is present in MON$RECORD_STATS and MON$TABLE_STATS (since FB4) > > > > Am running v2.5.x > >Hope, you have one more argument to try FB4 ;) The issue is not philosophical, rather it is "physical". We have over

Re: [Firebird-devel] Query statistics

2019-08-02 Thread Leyne, Sean
> > I was hoping to gather those details via MON$ tables. > >It is present in MON$RECORD_STATS and MON$TABLE_STATS (since FB4) Am running v2.5.x > > I have a DB SP which itself calls several SPs, and I was hoping to collect > > details > on the operations that each child SP performs

Re: [Firebird-devel] Query statistics

2019-08-02 Thread Leyne, Sean
> Sean, > > > How can those stats be related to the *tables* on which the activity is > performed against? > >Below is excerpt from APU Guide, if your question was about something else > - > please, clarify: > > --- >Database operation counts > >Several information items

Re: [Firebird-devel] Query statistics

2019-08-02 Thread Leyne, Sean
> >> More details is available at API Guide, see "Database operation > >> counts" at chapter 4 "WORKING WITH DATABASES". > > > > Please provide link to the API Guide, went to the project site and was > > unable to > find the doc. > >Links to all IB6 docs are placed here: > >

Re: [Firebird-devel] Query statistics

2019-08-01 Thread Leyne, Sean
> More details is available at API Guide, see "Database operation counts" at > chapter 4 "WORKING WITH DATABASES". Please provide link to the API Guide, went to the project site and was unable to find the doc. Sean Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Query statistics

2019-08-01 Thread Leyne, Sean
Vlad, How can those stats be related to the *tables* on which the activity is performed against? Sean > -Original Message- > From: Vlad Khorsun > Sent: Thursday, August 1, 2019 5:15 AM > To: firebird-devel@lists.sourceforge.net > Subject: Re: [Firebird-devel] Query statistics > >

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-07-06 Thread Leyne, Sean
> I would accept the thing if it purposely formats the string with a invalid and > distinguishable string, for example: GMT* Why do you feel that it is necessary to use such a 'marker'? The return value would be a correct GMT/UTC representation, no? Sean Firebird-Devel mailing list, web

Re: [Firebird-devel] System package for blob manipulation in PSQL

2019-06-27 Thread Leyne, Sean
> About S3, it's a non-standard product and certainly Firebird should not > support it > builtin. I would argue that S3 is *the* standard for cloud based storage. Sean Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] System package for blob manipulation in PSQL

2019-06-27 Thread Leyne, Sean
> RDB$BLOB_UTIL will have procedures and functions so blobs could be created, > opened, read in chunks, written in chunks, discarded (cancel). What about functions: - to read from/write to local disk* - to read from/write to any external source (Thinking of S3 compatible storage)* Sean

Re: [Firebird-devel] UDR vs PSQL

2019-06-20 Thread Leyne, Sean
> Calling UDF is hard process. We must emulate C call stack therefore parameters > are multiple times copied here and there, making CSTRING from CHAR / > VARCHAR is also headache - there is no place for terminating zero in the end > of > that string, therefore memory allocation takes place. >

Re: [Firebird-devel] Open-sourcing F14 for memory-efficient hash tables - Facebook Code

2019-04-26 Thread Leyne, Sean
Adriano, Definitely an interesting article. By posting it to this list, were you thinking that the code could be of benefit to Firebird? If so, any specific areas you were proposing? Sean > -Original Message- > From: Adriano dos Santos Fernandes > Sent: Friday, April 26, 2019 12:24

Re: [Firebird-devel] Max lock slots for Classic Server v2.5 x64?

2019-03-19 Thread Leyne, Sean
> > There is very little documentation available on the Classic lock > > manager related settings, which is why I ask the question in this forum. > > Interested in v2. 5 limitations, but details/differences for other > > versions would be appreciated. > > I assume you mean hash table slots: >

[Firebird-devel] Max lock slots for Classic Server v2.5 x64?

2019-03-17 Thread Leyne, Sean
All, There is very little documentation available on the Classic lock manager related settings, which is why I ask the question in this forum. Interested in v2. 5 limitations, but details/differences for other versions would be appreciated. Sean Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] ODP: Latest OLTP results DB size resolved

2019-02-14 Thread Leyne, Sean
OK, thanks for the explanation. I should also have asked: (i) How many core/threads is your CPU? (ii)(ii) how much RAM does your system have? Sean From: Karol Bieniaszewski Sent: Thursday, February 14, 2019 4:39 PM To: For discussion among Firebird Developers

Re: [Firebird-devel] Latest OLTP results DB size resolved

2019-02-14 Thread Leyne, Sean
Karol, I am not familiar with the OLTP tests, but it seems odd that the number of rows/records in the databases are different. I thought that OLTP tests operated on a fixed dataset size. I am pleased to see that the increase DB size (x4.24) is close to the increase in the number of rows

Re: [Firebird-devel] Digital signing of Firebird installers, executables etc.

2019-01-22 Thread Leyne, Sean
> > Are there any plans to sign Firebird installers, executables etc.? It > > is my understanding that some versions have been signed in the past, > > but signing is not always done. Can it be adopted as a general policy > > to sign all distributions? > > > > It's really funny. Sha256

Re: [Firebird-devel] ODP: 32-bit builds check

2019-01-21 Thread Leyne, Sean
>> Do not know why but 25% of users continue downloading i86 firebird binaries Because they need fbclient.dll in 32 bit version for 32bit projects 32 bit Linux builds?? I can understand for 32 bit Windows applications, but for Linux??? Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Some OLTP numbers

2019-01-03 Thread Leyne, Sean
Gabor, Thanks for the numbers. It would have been more appropriate, IMO, to have simply pasted the numbers as text in the body of your message, rather than as image attachments. I am confused by the meaningfulness of the numbers, given that you compared SuperClassic and SuperServer engines,

Re: [Firebird-devel] ODS hdr_creation_date

2018-11-26 Thread Leyne, Sean
> 26.11.2018 10:49, Alex Peshkoff via Firebird-devel wrote: > > In the worst case when we need to make changes after first beta we can > > use next major ODS version if change is absolutely incompatible. > >IMHO it is not given that they are necessary. >Database creation timestamp is

[Firebird-devel] Universal datatype was: ODP: User-defined aggregate functions

2018-09-28 Thread Leyne, Sean
Adriano, > I like your opinion to not limit to only one input parameters. This limitation > seems to not have sense. I agree. But then, would you agree that it is finally time for us to solve the problem of having to create multiple versions of a function to handle different data types. Why

Re: [Firebird-devel] User-defined aggregate functions

2018-09-28 Thread Leyne, Sean
> -Original Message- > From: Adriano dos Santos Fernandes > Sent: Friday, September 28, 2018 1:55 PM > To: firebird-devel@lists.sourceforge.net > Subject: Re: [Firebird-devel] User-defined aggregate functions > > On 28/09/2018 14:35, Leyne, Sean wrote: > &

Re: [Firebird-devel] User-defined aggregate functions

2018-09-28 Thread Leyne, Sean
> -- Works as standard AVG. > create aggregate function custom_avg (i double precision) returns (o double > precision) as >     declare count integer = 0; >     declare accumulated double precision = 0; begin >     while (not agg_finished) >     do >     begin >         if (i is not null) then >

Re: [Firebird-devel] GDS Exception. 335544761. too many open handles to database

2018-09-13 Thread Leyne, Sean
any open > handles to database > > On 2018-09-13 19:16, Leyne, Sean wrote: > > Our Java application is receiving the noted error, have done a web > > search for details on same without luck. > > > > Can someone explain what the error means. > > See https://stac

[Firebird-devel] GDS Exception. 335544761. too many open handles to database

2018-09-13 Thread Leyne, Sean
Our Java application is receiving the noted error, have done a web search for details on same without luck. Can someone explain what the error means. Thanks Sean Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Improvement for EXECUTE STATEMENT

2018-08-15 Thread Leyne, Sean
> > I do not see this feature as providing any benefit, which can't be > accomplished by more secure/appropriate mechanisms. > > > What mechanisms? > > > PS. I know that having tablespaces & partitioning is much better solution but > this requires big changes in engine, improvement to EXECUTE

Re: [Firebird-devel] Improvement for EXECUTE STATEMENT

2018-08-15 Thread Leyne, Sean
> I want to suggest simple improvement to execute statement - make it > possible to run in it CREATE DATABASE statements. It will not accept > parameters and ignore clauses ON EXTERNAL DATA SOURCE, WITH ... > TRANSACTION and WITH CALLER PRIVILEGES. Unlike ISQL which switches to > the context of

Re: [Firebird-devel] Listing all SYSTEM context variable names

2018-06-15 Thread Leyne, Sean
> That is not within Firebird itself. I want to be able to do something like > > select RDB$GET_CONTEXT('SYSTEM', variable_name) from > > or even > > select variable_name, variable_value from Sorry, are you looking for a list of the *names* or the names *and* the values? Why do you feel

Re: [Firebird-devel] Listing all SYSTEM context variable names

2018-06-15 Thread Leyne, Sean
Mark, > Is there currently an option (table (virtual?) or otherwise) to list all the > SYSTEM context variable names for use with RDB$GET_CONTEXT (and maybe > the values)? They are in the README.context_variables file in the doc\sql.extensions folder Sean

Re: [Firebird-devel] Tracker

2018-06-11 Thread Leyne, Sean
will be good if tracker and any FB page do not show server details when it is off now it show something like this: “ Service Temporarily Unavailable The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later. Apache/2.2.3

[Firebird-devel] Scheduled maintenance outage for Firebird Tracker @ 20:00 UTC June 11th/Today

2018-06-11 Thread Leyne, Sean
The Firebird Tracker will be taken down for internal network reconfiguration @ 20:00 UTC today. The outage should last less than 30 minutes. Sean -- Check out the vibrant tech community on one of the world's most

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-04 Thread Leyne, Sean
> Output columns RULE_START and RULE_END is renamed to > INITIAL_TIMESTAMP and FINAL_TIMESTAMP. START_TIMESTAMP and END_TIMESTAMP would be better (language wize) DEFINITION_START/DEFINITION_END (or EFFECTIVE_FROM/EFFECTIVE_TO) would be even better (the fact that the values are TIMESTAMPs does

Re: [Firebird-devel] FBJava plugin issues

2018-05-21 Thread Leyne, Sean
> > Hello Mark, > > > > Here it is what we did in details: > > > > 1) Install plugin into C:\Firebird_Java\fbjava-1.0.0-alpha-1. > > I advice to prefer use the version of master instead of alpha-1. > > Yes, it's not released as binary yet, but important fixes and many changes has > done since

Re: [Firebird-devel] FBJava plugin issues

2018-05-16 Thread Leyne, Sean
> > > We are testing FBJava plugin to see how well it suits our purposes. > > > For the testing we use example provided with the package. It works > > > well when deployed directly into the DB. However, when JAR is placed > > > externally, org.firebirdsql.fbjava.examples.fbjava_example example.

Re: [Firebird-devel] FBJava plugin issues

2018-05-16 Thread Leyne, Sean
> > We are testing FBJava plugin to see how well it suits our purposes. > > For the testing we use example provided with the package. It works > > well when deployed directly into the DB. However, when JAR is placed > > externally, org.firebirdsql.fbjava.examples.fbjava_example example. > >

Re: [Firebird-devel] FBJava plugin issues

2018-05-16 Thread Leyne, Sean
> The fbjava documentation specifically says not to put more jar files there: > > """ > The internal classes necessary for FB/Java are in > /jar/*.jar > and is not recommended to put more jar files there. > """ "Not recommended" does not mean "must not" or "is not supported" >

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Leyne, Sean
> >> No other database engine is maintaining various versions at the same > time. > >> Fortunately. > > > > I believe that Oracle is. > > > > How? > > I already put here link describing that when tz db is updated, times may > change if used in wrong version. I think I misunderstood which

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Leyne, Sean
> No other database engine is maintaining various versions at the same time. > Fortunately. I believe that Oracle is. Sean -- Check out the vibrant tech community on one of the world's most engaging tech sites,

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Leyne, Sean
> 10.05.2018 19:02, Adriano dos Santos Fernandes wrote: > > On 10/05/2018 12:53, Lester Caine wrote: > ... > >> And how will the version of TZ data be handled! This is a key element > >> that has screwed normalized data in the past, and some way to manage > >> that normalized data needs to be

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Leyne, Sean
Adriano, > I want to create a virtual table that lists available time zones. > > For now there is RDB$ (non-virtual), MON$ (virtual, but all about monitoring), > SEC$ (security plugin). > > What prefix should TIME_ZONES have? My feeling is to use the RDB$ prefix. Q's: How will the data be

Re: [Firebird-devel] Firebird v3.0.x support for External Functions plug-in

2018-05-08 Thread Leyne, Sean
> Since nobody really cared to do any help, there is no "Building" readme. > > But it's really no difficult for a people that ever built a C++ and Java > application to figure it out, as code base is small and has intuitively named > scripts. > > Anyway, you should start telling what has been

[Firebird-devel] Firebird v3.0.x support for External Functions plug-in

2018-05-07 Thread Leyne, Sean
The Firebird v3.0.x release notes outlines that plug-ins support has been added, and mentions that it will be extended to supporting SP, Functions and Triggers. Was this ever implemented/completed? {The Prague 2014 Firebird Conference had a "What's new in Firebird 3" presentation that listed

Re: [Firebird-devel] ALTER COLUMN and index rebuild

2018-03-19 Thread Leyne, Sean
> >> And, probably, we should add: > >> (3) - NOT NULL is set and default value was set before > > > > Really, why? > > > > I don't see that as a change that would affect the existing index values. > >The question was about existing NULL values. After i tried it i see that > NOT > NULL

Re: [Firebird-devel] ALTER COLUMN and index rebuild

2018-03-19 Thread Leyne, Sean
> And, probably, we should add: > (3) - NOT NULL is set and default value was set before Really, why? I don't see that as a change that would affect the existing index values. Sean -- Check out the vibrant tech

Re: [Firebird-devel] ALTER COLUMN and index rebuild

2018-03-19 Thread Leyne, Sean
Vlad, >Looking at bug CORE-5774 i found very odd behavior of engine: it seems it > rebuilds indices in many unneeded cases, when almost any property of the > indexed field is changed. > >I understand that index should be rebuild in this cases only: > (1) - field data type is changed

Re: [Firebird-devel] Valid date or not

2018-02-28 Thread Leyne, Sean
> Exactly what do you mean with this? -MM-DD is already supported. I wasn't sure it was -- it is not a string format that I/we use. Sean -- Check out the vibrant tech community on one of the world's most engaging

Re: [Firebird-devel] Valid date or not

2018-02-28 Thread Leyne, Sean
> 28.02.2018 16:42, Leyne, Sean wrote: > > Based on this, and considering legacy FB applications I propose the > following: > > > > 1- The only acceptable string format for the new Date/Time with > > Timezone datatypes should be the ISO/SQL standard > > &

Re: [Firebird-devel] Valid date or not

2018-02-28 Thread Leyne, Sean
> Should this be considered a bug, i.e., separators should be necessary in this > case (12-Mar-92, 12/Mar/92, 12.Mar.92)? My initial reaction was yes, but when I started thinking about/listing my "formatting rules" and came to realize that "no separator" was a reasonable/logical extension.

Re: [Firebird-devel] Meltdown and Spectre

2018-01-10 Thread Leyne, Sean
András, > -Original Message- > From: Omacht András [mailto:aoma...@mve.hu] > Sent: Wednesday, January 10, 2018 9:08 AM > finally we choose the easiest way, backup the system and update it to > Debian SID. > > # uname -a > Linux firebirdtest 4.14.0-3-amd64 #1 SMP Debian 4.14.12-2

Re: [Firebird-devel] Meltdown and Spectre

2018-01-09 Thread Leyne, Sean
András, > We've done some test runs with the 'old' kernel (linux-image-4.9.0-4- > amd64) and the 'new' one (linux-image-4.9.0-5-amd64). > > No. of tests: 6014 > No. of result checks: 253555   (checking column values, stored procedure > results, etc.) > > Average running time on 4.9.0-4: 466

[Firebird-devel] Jaybird not showing "application" name for connections/attachments {Was: Jaybird tests hang on Firebird 4 + WireCrypt enabled}

2018-01-08 Thread Leyne, Sean
Mark, I had been meaning to mention this for a while. > 1 attachment by SYSDBA using unknown (empty) application, protocol P13 It would be good if Jaybird applications could set the "application" name details. Sean

Re: [Firebird-devel] DECFLOAT behavior with NaNs

2018-01-06 Thread Leyne, Sean
> > Would this issue be part of the 3 tracker cases you opened, today, or > > a separate case? > > This would be a separate case. I'll leave it for you to create a case, since you will be in the best position to test any fix. > The case for literals for Infinities and NaNs (CORE-5698) can be

Re: [Firebird-devel] DECFLOAT behavior with NaNs

2018-01-06 Thread Leyne, Sean
> Not allowing +/-Infinity, +/-NaN, +/-sNaN for DECFLOAT seems to be > supported by the rules of 6.29 : Would this issue be part of the 3 tracker cases you opened, today, or a separate case? Sean -- Check out the

Re: [Firebird-devel] Support for timed-zones datatypes

2017-12-15 Thread Leyne, Sean
> > Separately, consider that calendar applications exchange times using UTC > offset contexts not time zone/region names. Why? Local Timezone UTC > offsets and DST rules are *variable*, UTC offsets are not. > > It's stored normalized to UTC, but the point in also store the region or >

Re: [Firebird-devel] Support for timed-zones datatypes

2017-12-15 Thread Leyne, Sean
Lester > The problem I had in the past was with meetings being moved over a DST > boundary. And this was in a SINGLE timezone. The software was normalizing > everything to UTC time, so that it could be displayed in local time of the > client, but what was forgotten in the software was which

Re: [Firebird-devel] Support for timed-zones datatypes

2017-12-14 Thread Leyne, Sean
> On 13/12/2017 15:20, Leyne, Sean wrote: > >> I must agree with Lester. Initially I want to only implement offsets, > >> but testing Oracle, PostgreSQL and reading the standard, I think > >> offsets are useless for almost everything. > > I don't agree,

Re: [Firebird-devel] Support for timed-zones datatypes

2017-12-13 Thread Leyne, Sean
> I must agree with Lester. Initially I want to only implement offsets, but > testing Oracle, PostgreSQL and reading the standard, I think offsets are > useless for almost everything. I don't agree, offsets are the appropriate for all but boundary cases that can be handled by appropriate

Re: [Firebird-devel] [FB-Tracker] Commented: (CORE-5631) Allow isc_info_svc_to_eof be used for sending binary stream to service

2017-10-06 Thread Leyne, Sean
> > A general question about the idea of "streaming" fbk file to a remote > server for restore. > > > > There would need to be a proper protocol to handle the stream, no? > > > > It would be impossible to send the fbk in a single operation, so sending the > fbk in blocks would be required. > >

Re: [Firebird-devel] [FB-Tracker] Commented: (CORE-5631) Allow isc_info_svc_to_eof be used for sending binary stream to service

2017-10-06 Thread Leyne, Sean
> > It's clear that choice to use isc_info_svc_line to mark chunk of stdin sent > > to > service via SPB was not wise choice (to say it mildly). Both > isc_info_svc_to_eof and isc_info_svc_line are normally used for service > output (query items) and they were created just for that purpose. > >

Re: [Firebird-devel] Lateral derived tables (was: Plans to support cross and outer apply)

2017-09-08 Thread Leyne, Sean
Dmitry, > Opinions, please. > > My personal votes: 1d, 2c, 3a, 4b For myself: 1d, 2c, 3a or 3b, 4b -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org!

  1   2   3   4   >