Re: [Firebird-devel] FB4 reserved word "LOCAL"

2019-02-03 Thread Mark Rotteveel
ions/README.keywords. This was needed as part of the time zone support. LOCAL is also a reserved word in SQL:2016 (earlier version as well). doc/sql.extensions/README.keywords also lists other keywords added as reserved or non-reserved keywords in Firebird 4. Mark -- Mark Rotteveel Firebird-Dev

[Firebird-devel] Inconsistency between TimeZoneUtil::MAX_LEN and definition of RDB$TIME_ZONES.RDB$TIME_ZONE_NAME

2019-02-02 Thread Mark Rotteveel
definitions seems like an accident waiting to happen if in the future a zone is added with a length longer than 32. Could this be fixed so they both use the same length (I'd suggest 63)? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists

[Firebird-devel] Full ICU in Firebird 4?

2019-01-26 Thread Mark Rotteveel
With the recent changes to the ICU version, does Firebird 4 on Windows now have the full ICU? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Time zone identifier to displacement convertion

2019-01-20 Thread Mark Rotteveel
On 2019-01-20 15:30, Jorge Gonçalves wrote: according to the time zone documentation the time_zone member in the ISC_TIME_TZ and ISC_TIMESTAMP_TZ structure returns the time zone identifier or displacement. There are any way to convert the time zone identifier to the displacement on the client

[Firebird-devel] Difference in performance between current_timestamp and localtimestamp

2018-12-29 Thread Mark Rotteveel
: updatedts timestamp default current_timestamp Why is that? I'd expect equivalent performance, or otherwise the reverse given the current_timestamp timestamp with time zone value needs to be converted to a timestamp without time zone. Mark -- Mark Rotteveel Firebird-Devel mailing list, web

Re: [Firebird-devel] Support for RETURNING *?

2018-12-28 Thread Mark Rotteveel
On 17-12-2018 13:26, Adriano dos Santos Fernandes wrote: On 09/12/2018 11:55, Mark Rotteveel wrote: Back in 2012 I created CORE-3808 to request support for RETURNING *, which should - equivalent to SELECT * - return all columns instead of having to manually include all columns in the returning

[Firebird-devel] Database creation slower in Firebird 4

2018-12-28 Thread Mark Rotteveel
share a database). To be clear, I'm only asking if this is an unexpected performance regression, or if it is something that is expected with no room for improvement. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird

[Firebird-devel] [FB-Tracker] Created: (CORE-5976) gbak multi-database file restore uses wrong minimum number of pages for first database file

2018-12-27 Thread Mark Rotteveel (JIRA)
Project: Firebird Core Issue Type: Bug Components: GBAK Affects Versions: 4.0 Alpha 1 Environment: Firebird-4.0.0.1352-0_x64 Reporter: Mark Rotteveel I have a Jaybird test that creates a multi-file database using a gbak restore (through the services

[Firebird-devel] Error "Invalid time zone region" with syntactically questionable timestamp string

2018-12-27 Thread Mark Rotteveel
ot;ICU error retrieving the system time zone: -128.")? Is there a problem with timezone support on Windows? 4. Errors logged during build should be fixed, right? And a nitpick: "Fallbacking" should be "Falling back" Mark -- Mark Rotteveel Firebird-Devel mailing

[Firebird-devel] [FB-Tracker] Created: (CORE-5975) Add boolean aggregate functions EVERY, ANY and SOME

2018-12-23 Thread Mark Rotteveel (JIRA)
: Engine Reporter: Mark Rotteveel The SQL standard defines the boolean aggregate functions EVERY, ANY and SOME (see SQL:2016-2 10.9 ). In a way, these are the counterpart of the quantified comparison predicates (ALL, ANY and SOME) that Firebird already supports. The value expression

Re: [Firebird-devel] Comparison of many standard (and non-standard) SQL features amongst 10 databases

2018-12-17 Thread Mark Rotteveel
t you mail to the address listed on that page. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Support for RETURNING *?

2018-12-17 Thread Mark Rotteveel
On 17-12-2018 13:26, Adriano dos Santos Fernandes wrote: On 09/12/2018 11:55, Mark Rotteveel wrote: Back in 2012 I created CORE-3808 to request support for RETURNING *, which should - equivalent to SELECT * - return all columns instead of having to manually include all columns in the returning

Re: [Firebird-devel] ODS hdr_creation_date

2018-11-24 Thread Mark Rotteveel
the ODS should be stable after the first beta, but I don't think that should be a hard requirement. Disallowing ODS changes during development because it inconveniences people is IMHO not a good enough reason. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https

Re: [Firebird-devel] Batch API wire protocol

2018-11-10 Thread Mark Rotteveel
)? Mark On 27-10-2018 19:35, Alex Peshkoff via Firebird-devel wrote: On 10/27/18 15:02, Mark Rotteveel wrote: What is the wire protocol of the batch API (that is: what operations, what message format, etc)?     op_batch_create = 99,     op_batch_msg    = 100

Re: [Firebird-devel] FB4 Windows snapshots not updated since Wednesday

2018-11-09 Thread Mark Rotteveel
On 2018-11-05 14:45, Adriano dos Santos Fernandes wrote: On 03/11/2018 12:55, Mark Rotteveel wrote: The Windows snapshots of Firebird 4 haven't been updated since the 31st of October, while the Linux snapshot was last updated today (the 3rd of November). Because there were no commits since

[Firebird-devel] FB4 Windows snapshots not updated since Wednesday

2018-11-03 Thread Mark Rotteveel
The Windows snapshots of Firebird 4 haven't been updated since the 31st of October, while the Linux snapshot was last updated today (the 3rd of November). Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Batch API wire protocol

2018-10-27 Thread Mark Rotteveel
with protocol v16 (if I have my protocol versions right)? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] ODP: Some OLTP numbers

2018-10-27 Thread Mark Rotteveel
this one wasn't moved to GitHub though. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Status of time zone support

2018-10-26 Thread Mark Rotteveel
What is the status for time zone support? Is it going to be included in Firebird 4 or not? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Expired certificate for firebirdsql.org

2018-10-26 Thread Mark Rotteveel
HTTP String Transport Security. Regards, Hristo Stefanov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Case (and accent) insensitive ICU collations in multiple columns

2018-10-25 Thread Mark Rotteveel
that was synced from subversion and hasn't been updated since 2015. The Firebird repository is on https://github.com/FirebirdSQL/firebird Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] LOCALTIMESTAMP name

2018-10-23 Thread Mark Rotteveel
describes an aspect of the value (the 'when'). They could also have chosen to use CURRENT_LOCALTIME, but maybe they judged that too long. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] LOCALTIMESTAMP name

2018-10-23 Thread Mark Rotteveel
and LOCALTIME and LOCALTIMESTAMP . Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 3.0.4 unicode_ci_ai index problems

2018-10-17 Thread Mark Rotteveel
the problem explicit by describing it. That is especially important if you want people to actually reply and address your problem. Questions without an explicit problem statement are far more likely to go unanswered. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https

Re: [Firebird-devel] Firebird 3.0.4 unicode_ci_ai index problems

2018-10-17 Thread Mark Rotteveel
ird-devel -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5937) Inconsistency between ALTER and USAGE privileges for sequences (generators).

2018-10-06 Thread Mark Rotteveel (JIRA)
Issue Type: Bug Components: Security Affects Versions: 3.0.4, 3.0.3, 4.0 Alpha 1, 3.0.2, 3.0.1, 3.0.0, 4.0 Initial Reporter: Mark Rotteveel There appears to be an inconsistency between the ALTER and USAGE privileges for sequences. Only users with ALTER permission

Re: [Firebird-devel] NULL and/or true/false

2018-10-01 Thread Mark Rotteveel
-- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-5930) internal Firebird consistency check (Incorrect snapshot deallocation - too few slots)

2018-09-30 Thread Mark Rotteveel (JIRA)
: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 4.0 Beta 1 Environment: Firebird-4.0.0.1227-0_x64 Windows 10 + Jaybird master Reporter: Mark Rotteveel I was just running the Jaybird tests against Firebird-4.0.0.1227-0_x64 (Windows 10

Re: [Firebird-devel] Error java.sql.SQLException: internal Firebird consistency check (Incorrect snapshot deallocation - too few slots) [SQLState:XX000, ISC error code:335544333]

2018-09-30 Thread Mark Rotteveel
On 29-9-2018 22:21, Vlad Khorsun wrote: 29.09.2018 19:14, Mark Rotteveel wrote: ... Do I need to create a ticket for this, or is this a known problem?   Yes, create a ticket please. Done: CORE-5930 I included both problems into that one ticket as I think they are the same. Mark -- Mark

Re: [Firebird-devel] Error java.sql.SQLException: internal Firebird consistency check (Incorrect snapshot deallocation - too few slots) [SQLState:XX000, ISC error code:335544333]

2018-09-29 Thread Mark Rotteveel
On 29-9-2018 18:14, Mark Rotteveel wrote: I was just running the Jaybird tests against Firebird-4.0.0.1227-0_x64 (Windows 10). It has been a while since I tested with Firebird 4, so I don't know when this problem was introduced. When running the test

[Firebird-devel] Error java.sql.SQLException: internal Firebird consistency check (Incorrect snapshot deallocation - too few slots) [SQLState:XX000, ISC error code:335544333]

2018-09-29 Thread Mark Rotteveel
ns are rejected, but the process does not stop and needs to be killed. Attempting to connect after trying to stop Firebird logs: """ RAMONA Sat Sep 29 18:07:55 2018 Authentication error connection shutdown """ Do I need to create a ticket for th

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

2018-09-29 Thread Mark Rotteveel
by something rows between 5 preceding and 5 following)`. I also don't see how your syntax discerns between accumulation and finishing, for example how would the value of `accumulated` in `custom_avg` be retained? Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https

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

2018-09-29 Thread Mark Rotteveel
function, it does seem to be using a pass by reference: the value of the parameter can be changed from outside while within the loop, which is something entirely new for PSQL. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo

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

2018-09-29 Thread Mark Rotteveel
on), SUSPEND is used to feed input and produce result. Maybe Sean is talking about SQL standard grouping sets which Firebird doesn't support yet. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

2018-09-29 Thread Mark Rotteveel
m rdb$database where 1 = 0 -- returns 1000 create aggregate function custom_count_plus_1000 (i integer) returns (o integer) as begin     o = 0;     while (not agg_finished)     do     begin    o = o + 1;         suspend;     end     o = o + 1000; end -- Mark Rotteveel Firebird-Dev

Re: [Firebird-devel] Transliteration problem with table locks?

2018-09-18 Thread Mark Rotteveel
PB string properties, which on most platforms - IIRC - is not UTF-8, see https://github.com/cincuranet/FirebirdSql.Data.FirebirdClient/blob/74580961c9ada64aea49dcaabacae0de4fac3540/Provider/src/FirebirdSql.Data.FirebirdClient/Common/TransactionParameterBuffer.cs#L38 Mark -- Mark Rotteveel

Re: [Firebird-devel] Login with mixed case fails

2018-09-17 Thread Mark Rotteveel
ever uppercased except in dpbItemUpper. Although I may have mislocated that, but it seems that the only plugin where this is relevant right now is the Srp plugin, right? That does make you wonder if this shouldn't be moved from ClntAuthBLock to SrpClient. Mark -- Mark Rotteveel Firebird-Devel mai

Re: [Firebird-devel] Login with mixed case fails

2018-09-17 Thread Mark Rotteveel
On 17-9-2018 15:36, Alex Peshkoff via Firebird-devel wrote: On 09/17/18 16:31, Mark Rotteveel wrote: Lets rephrase my question. Assuming I have created a user using   create user "CaseSensitive" password 'password' using plugin Srp; Exactly which value must I pass from server

Re: [Firebird-devel] Login with mixed case fails

2018-09-17 Thread Mark Rotteveel
On 17-9-2018 14:58, Alex Peshkoff via Firebird-devel wrote: On 09/17/18 15:45, Mark Rotteveel wrote: On 16-9-2018 17:28, Mark Rotteveel wrote: I think you should probably post this to the Firebird .net provider mailing list. The problem seems to be that case-sensitive user names need

Re: [Firebird-devel] Login with mixed case fails

2018-09-17 Thread Mark Rotteveel
On 16-9-2018 17:28, Mark Rotteveel wrote: I think you should probably post this to the Firebird .net provider mailing list. The problem seems to be that case-sensitive user names need to be correctly supported by the client. And in the case of Firebird.net provider (and Jaybird

Re: [Firebird-devel] Login with mixed case fails

2018-09-16 Thread Mark Rotteveel
and & in any of these tests, so there should be no problems caused by OEM/ANSI/UTF8 code page mixups. Mvh, Kjell Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

2018-09-13 Thread Mark Rotteveel
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://stackoverflow.com/q/39148222/466862 In short, this error occurs if you allocate too many

[Firebird-devel] Expected dates for 2.5.9 and 3.0.4 releases?

2018-08-25 Thread Mark Rotteveel
When can we expect the release of Firebird 2.5.9 and 3.0.4? Mark -- Mark Rotteveel -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird

Re: [Firebird-devel] FB4 - Windows snapshots vs ICU

2018-08-03 Thread Mark Rotteveel
On 2018-08-03 07:51, Gabor Boros wrote: 2018. 08. 02. 13:53 keltezéssel, Gabor Boros írta: Is some external files needed or wrong files included in the snapshots? Yes, two external files. msvcp100.dll and msvcr100.dll from Microsoft Visual C++ 2010 SP1 Redistributable Package. That sounds

Re: [Firebird-devel] Read consistency patch

2018-07-24 Thread Mark Rotteveel
On 2018-07-24 10:13, liviuslivius wrote: Hi, question about this patch https://github.com/FirebirdSQL/firebird/pull/105 Is this possible that this CN(commit number) of transactions (pair transaction id + CN) can be stored into some table? Is it possible to retrive most recent CN from

Re: [Firebird-devel] Jaybird hang on Firebird 4 with modified TcpRemoteBufferSize

2018-07-23 Thread Mark Rotteveel
On 23-7-2018 17:25, Adriano dos Santos Fernandes wrote: On 23/07/2018 11:12, Mark Rotteveel wrote: The problem can't be reproduced with the native client, which suggests Jaybird does something wrong, or this is something that is only triggered by what Jaybird does. Mark, are you dealing

Re: [Firebird-devel] Jaybird hang on Firebird 4 with modified TcpRemoteBufferSize

2018-07-23 Thread Mark Rotteveel
On 23-7-2018 15:07, Alex Peshkoff via Firebird-devel wrote: On 22.07.2018 18:03, Mark Rotteveel wrote: On 22-7-2018 16:14, Dimitry Sibiryakov wrote: 22.07.2018 14:56, Mark Rotteveel wrote: If I change one of the two test classes that triggers this problem to create a single database

Re: [Firebird-devel] Time zone feature documentation

2018-07-22 Thread Mark Rotteveel
for isc_dpb_session_time_zone is undocumented. Looking at the implementation it is a string like passed to SET TIME ZONE, is that correct? I'd also like to know what the plans are for this: will it land in Firebird 4? If so: when? Mark -- Mark Rotteveel

Re: [Firebird-devel] Jaybird hang on Firebird 4 with modified TcpRemoteBufferSize

2018-07-22 Thread Mark Rotteveel
error code:337248276] This error means that Jaybird received a response packet with an operation code of 16777216 instead of a valid operation code (op_response (9), op_fetch_response (66) or op_sql_response (78)). Mark On 27-3-2018 19:08, Mark Rotteveel wrote: I increased

Re: [Firebird-devel] [moved from support] LOCALTIME and LOCALTIMESTAMP

2018-07-19 Thread Mark Rotteveel
On 2018-07-18 22:51, livius wrote: Hi, thank you for the link. If i understand correctly then all functions "CURRENT_..." and "LOCAL_..." result are in session TZ? Note that it is LOCALTIME and LOCALTIMESTAMP, so no underscore there. If yes, then now it is much clearer, I thought that

Re: [Firebird-devel] Authentication plugin mismatch not clearly reported to client

2018-06-25 Thread Mark Rotteveel
ark -- Mark Rotteveel -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/li

Re: [Firebird-devel] Authentication plugin mismatch not clearly reported to client

2018-06-25 Thread Mark Rotteveel
On 25-6-2018 10:35, Alex Peshkoff via Firebird-devel wrote: On 25.06.2018 10:47, Mark Rotteveel wrote: On 2018-06-24 20:49, Alex Peshkoff via Firebird-devel wrote: Because it's bad idea to open to client (specially not authenticated) details of problems with authentication. I agree

Re: [Firebird-devel] Passing plugin list to native client

2018-06-25 Thread Mark Rotteveel
On 25-6-2018 10:32, Alex Peshkoff via Firebird-devel wrote: On 25.06.2018 10:51, Mark Rotteveel wrote: On 2018-06-24 20:51, Alex Peshkoff via Firebird-devel wrote: Because it's as designed. What problems with it? Having to construct the config string is awkward, especially when you already

Re: [Firebird-devel] Passing plugin list to native client

2018-06-25 Thread Mark Rotteveel
On 2018-06-24 20:51, Alex Peshkoff via Firebird-devel wrote: On 23.06.2018 19:05, Mark Rotteveel wrote: When using the native fbclient, why can't I use isc_dpb_auth_plugin_list/isc_spb_auth_plugin_list to pass the authentication plugins to try, and why do I need to use the isc_dpb_config

Re: [Firebird-devel] Authentication plugin mismatch not clearly reported to client

2018-06-25 Thread Mark Rotteveel
On 2018-06-24 20:49, Alex Peshkoff via Firebird-devel wrote: On 23.06.2018 17:06, Mark Rotteveel wrote: Why is an authentication plugin mismatch (as in the list of plugins between client and server have no overlap) not clearly communicated to the client? For example if I have AuthServer

[Firebird-devel] Passing plugin list to native client

2018-06-23 Thread Mark Rotteveel
When using the native fbclient, why can't I use isc_dpb_auth_plugin_list/isc_spb_auth_plugin_list to pass the authentication plugins to try, and why do I need to use the isc_dpb_config/isc_spb_config with "AuthClient = " (+ other config items if necessary)? Mark -- Mark

[Firebird-devel] Authentication plugin mismatch not clearly reported to client

2018-06-23 Thread Mark Rotteveel
atching plugins on server" not reported back to the client? -- Mark Rotteveel -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebir

Re: [Firebird-devel] Fwd: [FB-Tracker] Commented: (CORE-5788) Proposed Security Patch: Replacement of use of SHA-1 in the SRP Client Proof with SHA-256

2018-06-23 Thread Mark Rotteveel
ird.conf. In all cases hashes stored in security database are fully compatible between Srp & Srp256, i.e. security.db does not require any upgrade. I have added support for this in Jaybird 3.0.5 and Jaybird 4. Mark -- Ma

Re: [Firebird-devel] Fwd: [FB-Tracker] Commented: (CORE-5788) Proposed Security Patch: Replacement of use of SHA-1 in the SRP Client Proof with SHA-256

2018-06-21 Thread Mark Rotteveel
for compatibility with older Firebird 3 servers only. I understand that, but I was thinking about when introducing this now in a Jaybird 3 point-release. Mark -- Mark Rotteveel -- Check out the vibrant tech community on one

Re: [Firebird-devel] Fwd: [FB-Tracker] Commented: (CORE-5788) Proposed Security Patch: Replacement of use of SHA-1 in the SRP Client Proof with SHA-256

2018-06-21 Thread Mark Rotteveel
On 21-6-2018 15:57, Alex Peshkoff via Firebird-devel wrote: On 21.06.2018 16:36, Mark Rotteveel wrote: That is everything continues to use SHA-1, except the generating of M itself. As far as I can see - yes. The only detail that you need to support both cases depending upon plugin name

Re: [Firebird-devel] Fwd: [FB-Tracker] Commented: (CORE-5788) Proposed Security Patch: Replacement of use of SHA-1 in the SRP Client Proof with SHA-256

2018-06-21 Thread Mark Rotteveel
.toUpperCase().getBytes(StandardCharsets.UTF_8)), // n2 in FB salt, toBigByteArray(publicKey), toBigByteArray(serverPublicKey), K); Where XXX is the relevant SHA variant applied. That is everything continues to use SHA-1, except the generating of M itself. -- Ma

Re: [Firebird-devel] [FB-Tracker] Closed: (CORE-5726) Unclear error message when inserting value exceeding max of dec_fixed decimal

2018-06-19 Thread Mark Rotteveel
release is something like 2.5.8, which is a point release for Firebird 2.5. -- Mark Rotteveel -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link

Re: [Firebird-devel] [FB-Tracker] Closed: (CORE-5726) Unclear error message when inserting value exceeding max of dec_fixed decimal

2018-06-19 Thread Mark Rotteveel
On 2018-06-18 14:49, Alex Peshkoff via Firebird-devel wrote: On 17.06.2018 13:17, Mark Rotteveel wrote: I don't agree with this ticket getting closed. I raised an objection to the current solution in the comments that I think needs to be addressed. The current solution causes a divergence

Re: [Firebird-devel] [FB-Tracker] Closed: (CORE-5726) Unclear error message when inserting value exceeding max of dec_fixed decimal

2018-06-19 Thread Mark Rotteveel
On 2018-06-18 15:10, Carlos H. Cantu wrote: I dream about the day that "arithmetic exception, numeric overflow, or string truncation" will be replaced by more specific errors. You may want to look closer at that error: it actually consists of two error codes, which will pretty much narrow it

Re: [Firebird-devel] [FB-Tracker] Closed: (CORE-5726) Unclear error message when inserting value exceeding max of dec_fixed decimal

2018-06-17 Thread Mark Rotteveel
CORE-5726 URL: http://tracker.firebirdsql.org/browse/CORE-5726 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 4.0 Alpha 1 Environment: Firebird-4.0.0.864-0_x64 (Windows 10) Reporter: Mark Rotteveel

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

2018-06-16 Thread Mark Rotteveel
ld suggest extending MON$CONTEXT_VARIABLES, including a MON$NAME_SPACE column, and then including the SYSTEM variables. BTW: Having a selectable source of keywords would actually be a great idea. Mark -- Mark Rotteveel --

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

2018-06-15 Thread Mark Rotteveel
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 I can do that for USER_SESSION and USER_TRANSACTION. Mark -- Mark Rotteveel

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

2018-06-15 Thread Mark Rotteveel
On 15-6-2018 17:25, Dimitry Sibiryakov wrote: 15.06.2018 17:19, Mark Rotteveel wrote: Having to rely on external lists like the Firebird 2.5 language reference is a bit too brittle for my tastes, I'd like the truth according to the Firebird itself.   But documentation is the only place

[Firebird-devel] Listing all SYSTEM context variable names

2018-06-15 Thread Mark Rotteveel
like the Firebird 2.5 language reference is a bit too brittle for my tastes, I'd like the truth according to the Firebird itself. Mark -- Mark Rotteveel -- Check out the vibrant tech community on one of the world's most

Re: [Firebird-devel] ALTER SESSION RESET not allowed if there are transactions?

2018-06-11 Thread Mark Rotteveel
-- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Mark Rotteveel ---

Re: [Firebird-devel] Pseudo columns in Firebird

2018-06-10 Thread Mark Rotteveel
On 10-6-2018 11:37, Dmitry Yemanov wrote: 09.06.2018 16:09, Mark Rotteveel wrote: Besides RDB$DB_KEY and RDB$RECORD_VERSION, does Firebird have any other pseudo columns? No, it doesn't. Thanks! -- Mark Rotteveel

Re: [Firebird-devel] Pseudo columns in Firebird

2018-06-10 Thread Mark Rotteveel
. On 09.06.2018 20:09 Mark wrote: Besides RDB$DB_KEY and RDB$RECORD_VERSION, does Firebird have any other pseudo columns? -- Mark Rotteveel -- Check out the vibrant tech community on one of the world's most engaging tech

[Firebird-devel] Pseudo columns in Firebird

2018-06-09 Thread Mark Rotteveel
Besides RDB$DB_KEY and RDB$RECORD_VERSION, does Firebird have any other pseudo columns? -- Mark Rotteveel -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-06 Thread Mark Rotteveel
be exclusive, so [start, end), which means that "end" is the same value as "start" of the next one, eg 1. [start_1, start_2) 2. [start_2, start_3) ... Which might seem nice from a theory perspective, but does not play nice with for example usage of BETWEEN. Ma

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-05 Thread Mark Rotteveel
On 5-6-2018 11:43, Lester Caine wrote: On 05/06/18 09:39, Mark Rotteveel wrote: On 5-6-2018 10:16, Lester Caine wrote: On 05/06/18 08:50, Mark Rotteveel wrote: That naming doesn't make much sense to me, and I actually found the RULE_START and RULE_END naming pretty clear and self-explanatory

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-05 Thread Mark Rotteveel
On 5-6-2018 10:16, Lester Caine wrote: On 05/06/18 08:50, Mark Rotteveel wrote: That naming doesn't make much sense to me, and I actually found the RULE_START and RULE_END naming pretty clear and self-explanatory. Except that it's not the rule itself, but the transitions within the rule

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-05 Thread Mark Rotteveel
and therefor confusing. Why not just use RULE_START and RULE_END, or maybe VALID_FROM and VALID_TO. Mark -- Mark Rotteveel -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org

Re: [Firebird-devel] ALTER SESSION RESET not allowed if there are transactions?

2018-06-04 Thread Mark Rotteveel
On 4-6-2018 11:49, Vlad Khorsun via Firebird-devel wrote: 02.06.2018 19:54, Mark Rotteveel wrote: JDBC API requires that statements are executed in a transaction. In theory I can break that rule, but the problem with that is that it requires explicit handling, which is 1) annoying to do and 2

Re: [Firebird-devel] RDB$TIME_ZONE_UTIL package

2018-06-03 Thread Mark Rotteveel
T', CON> date '2016-01-01', CON> date '2019-12-31'); RULE_START 0001-01-01 00:00:00. GMT RULE_END -12-31 23:59:59. GMT ZONE_OFFSET 0 DST_OFFSET 0 --- -- Mark Rotteveel -- Che

Re: [Firebird-devel] ALTER SESSION RESET not allowed if there are transactions?

2018-06-02 Thread Mark Rotteveel
On 2-6-2018 17:56, Vlad Khorsun via Firebird-devel wrote: 02.06.2018 18:07, Mark Rotteveel wrote: I just saw the following commit: https://github.com/FirebirdSQL/firebird/commit/bbf8348817c4592999fc137b18ba1be7326ad42d This disallows execution of ALTER SESSION RESET

[Firebird-devel] ALTER SESSION RESET not allowed if there are transactions?

2018-06-02 Thread Mark Rotteveel
the current restriction also doesn't allow for prepared but not yet committed transactions. Prepared transactions are not active, and presence of these should not block execution of ALTER SESSION RESET. Mark -- Mark Rotteveel

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-24 Thread Mark Rotteveel
On 2018-05-24 11:01, Mark Rotteveel wrote: On 2018-05-24 01:08, Vlad Khorsun via Firebird-devel wrote: 3. Never reset external connection when it gets out of use. It also could make system work differently - when local system was upgraded from v3 to v4 and start to use connection pooling

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-24 Thread Mark Rotteveel
On 2018-05-24 01:08, Vlad Khorsun via Firebird-devel wrote: 24.05.2018 0:39, Dimitry Sibiryakov wrote: So far we have following propositions: 1. Always reset external connection when it gets out of use. Close connection if any kind of error happens. It actually disables connections pool

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-23 Thread Mark Rotteveel
in this topic. I see a number of typos, but maybe I'll propose a pull request for those if I can find the time. -- Mark Rotteveel -- Check out the vibrant tech community on one of the world's most engaging tech sites

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-21 Thread Mark Rotteveel
On 20-5-2018 17:24, Vlad Khorsun via Firebird-devel wrote: 20.05.2018 14:15, Mark Rotteveel wrote: I would expect such a feature to reset all session state to the initial state on connect, including things like * Clear context USER_SESSION * Reset role to the initial role specified on attach

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-20 Thread Mark Rotteveel
) allows DBA to play with pool properties to find an optimal values and then put in into config - this was initial idea. Ok, but I think in the longer term, we may want to consider to make DDL to control engine/server configuration to be durable (that is persistent across restarts). Mark -- Mark

Re: [Firebird-devel] Time zone feature documentation

2018-05-20 Thread Mark Rotteveel
time zone, as I guess it should also apply to things like the DECFLOAT bind and error configuration. Mark -- Mark Rotteveel -- Check out the vibrant tech community on one of the world's most engaging tech sites

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-20 Thread Mark Rotteveel
a local connection to database 1 on the same host as the Firebird server itself? Mark -- Mark Rotteveel -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-20 Thread Mark Rotteveel
ar context USER_SESSION * Reset role to the initial role specified on attach * Reset other session configuration (eg DECFLOAT behavior, timeouts, session timezone, etc) Mark -- Mark Rotteveel -- Check out the vibrant tech commun

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-20 Thread Mark Rotteveel
On 20-5-2018 12:47, Vlad Khorsun via Firebird-devel wrote: 20.05.2018 12:55, Mark Rotteveel wrote: On 19-5-2018 17:11, Vlad Khorsun via Firebird-devel wrote: 19.05.2018 13:08, Mark Rotteveel wrote: 2. Fine-grained privilege that applies only to this single option

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-20 Thread Mark Rotteveel
On 19-5-2018 17:11, Vlad Khorsun via Firebird-devel wrote: 19.05.2018 13:08, Mark Rotteveel wrote: 2. Fine-grained privilege that applies only to this single option: ALTER_EXTERNAL_CONNECTIONS_POOL or if shorter is preferred: ALTER_EXT_CONN_POOL 3. In addition to option 2, maybe allow even

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-19 Thread Mark Rotteveel
On 19-5-2018 10:43, Vlad Khorsun via Firebird-devel wrote: 19.05.2018 11:04, Mark Rotteveel wrote: On 18-5-2018 18:44, Vlad Khorsun via Firebird-devel wrote: ...    Please, read and comment: https://github.com/FirebirdSQL/firebird/blob/ExternalConnectionsPool/doc/sql.extensions

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-19 Thread Mark Rotteveel
d to control engine-wide configuration options. If the pool (and config) is global, I think this requires a global privilege, preferably a separate one. If the pool **and** config is local, then it is ok. Mark -- Mark Rotteveel --

Re: [Firebird-devel] FBJava plugin issues

2018-05-18 Thread Mark Rotteveel
On 18-5-2018 14:53, Adriano dos Santos Fernandes wrote: On 18/05/2018 09:45, Mark Rotteveel wrote: On 18-5-2018 14:32, Adriano dos Santos Fernandes wrote: On 18/05/2018 08:57, Mark Rotteveel wrote: We also tried to push our own JARs into the DB, but ended up getting tons of "PK viol

Re: [Firebird-devel] FBJava plugin issues

2018-05-18 Thread Mark Rotteveel
On 18-5-2018 14:32, Adriano dos Santos Fernandes wrote: On 18/05/2018 08:57, Mark Rotteveel wrote: We also tried to push our own JARs into the DB, but ended up getting tons of "PK violation" errors. This one is because Java has no problem if you have class x.y.Class in

Re: [Firebird-devel] FBJava plugin issues

2018-05-18 Thread Mark Rotteveel
be in more detail what you did and what error you get. The fbjava plugin probably hasn't seen a lot of use, so unless you describe exactly what you did, it will be harder to replicate what you did and either point out what you did wrong, or what is wrong with the current plugin so it can be f

Re: [Firebird-devel] Reason for "Missing master config file firebird.conf"

2018-05-18 Thread Mark Rotteveel
nly when from script from AppVeyor then I get this messsage. Any hints to check? It's a vanilla Firebird 3, the CWD is the location where firebird.exe is located. Maybe an issue with access rights? Mark -- Mark Rotteveel

Re: [Firebird-devel] CORE-5343 and CORE-2557

2018-05-16 Thread Mark Rotteveel
of that third-party application. If you have a question about using Firebird, then subscribe to the firebird-support mailing list and ask your question there. Mark -- Mark Rotteveel -- Check out the vibrant tech community on one

Re: [Firebird-devel] FBJava plugin issues

2018-05-16 Thread Mark Rotteveel
is not recommended, I wouldn't do it. Looking at the code involved, deploying this way will probably require a restart of Firebird for each change (but my knowledge of C++ and Firebird plugins is limited). I'm not sure if that is desirable. Mark -- Mark Rotteveel

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

2018-05-16 Thread Mark Rotteveel
or new releases (especially given the annoying habit of some countries of making changes like this on short notice). If we can't do that, we will need to provide some way to make update the time zone data easily(!). No hacks or requiring users to recompile ICU or anything like that. Mark -- Mark Rot

<    2   3   4   5   6   7   8   9   10   11   >