[Firebird-devel] [FB-Tracker] Created: (CORE-5996) BUILDS: Provide digital signing on installation kits

2019-01-31 Thread Helen Borrie (JIRA)
Components: Build Issues / Porting Affects Versions: 4.0 Beta 1, 2.5.9, 3.0.5 Environment: All platforms Reporter: Helen Borrie John Frankland in firebird-devel and several other forums: > What is the practice regarding digital signing of Firebird executables and > installe

[Firebird-devel] [FB-Tracker] Created: (CORE-5671) Fb 3 gstat not properly reporting old ODS error

2017-11-27 Thread Helen Borrie (JIRA)
Affects Versions: 3.0.2, 3.0.1, 3.0.0 Environment: Windows 10 Reporter: Helen Borrie Priority: Minor C:\Programs64\Firebird_3_0>gstat -h c:\programs64\firebird_2_5\examples\empbuild\employee.fdb Wrong ODS version, expected 12, encountered 11 It should have repor

[Firebird-devel] [FB-Tracker] Created: (CORE-5593) System function RDB$ROLE_IN_USE cannot take long role names

2017-08-07 Thread Helen Borrie (JIRA)
Components: Engine Affects Versions: 4.0 Initial Environment: Any Reporter: Helen Borrie Priority: Minor Function RDB$ROLE_IN_USE takes a varchar(32), which is meant to be a role name. Varchar(32) won't be long enough to take a longer role name. -- This message

[Firebird-devel] [FB-Tracker] Created: (CORE-5404) Inconsistent column/line references when PSQL definitions return errors

2016-11-21 Thread Helen Borrie (JIRA)
Issue Type: Bug Components: Engine Affects Versions: 3.0.1, 2.5.6 Environment: Any Reporter: Helen Borrie Priority: Minor line/column numbers are not shown in the error message for first SP, but are shown in the error message for second SP: SET TERM

[Firebird-devel] [FB-Tracker] Created: (CORE-5402) Let non-null integer type columns be convertible to IDENTITY

2016-11-19 Thread Helen Borrie (JIRA)
Affects Versions: 3.0.1, 4.0 Initial Environment: Any Reporter: Helen Borrie Priority: Minor Is it a trivial change to enable conversion of an integer type column that is populated from a generator from a trigger to IDENTITY type? Example create

[Firebird-devel] [FB-Tracker] Created: (CORE-5375) SHOW commands should show RDB$DESCRIPTION in output

2016-10-12 Thread Helen Borrie (JIRA)
: ISQL Affects Versions: 3.0.1, 2.5.6, 3.0.0, 4.0 Initial Environment: Any environment. Reporter: Helen Borrie Priority: Minor It would be useful to display the text from RDB$DESCRIPTION in the SHOW commands for object types that have COMMENT ON syntax

[Firebird-devel] [FB-Tracker] Created: (CORE-5365) Authentication for gbak broken in v.2.5.6

2016-10-01 Thread Helen Borrie (JIRA)
: 2.5.6 Environment: Windows 64-bit platform and installation, V.2.5.5 installation updated to 2.5.6 via zip file, existing .conf files and security2.fdb from 2.5.5 copied over while service stopped. Reporter: Helen Borrie Gbak returning "user name and password not de

Re: [Firebird-devel] Limit on Old and New context variables in triggers ?

2016-02-16 Thread Helen Borrie
Wednesday, February 17, 2016, 7:03:12 AM, Dmitry wrote: > 16.02.2016 20:07, Leyne, Sean wrote: >> >> Would INSERTs (as below) to a table count as a context? > Sure. Every table reference is a context. Be it SELECT/INSERT/whatever. > For UPDATE it takes two contexts. What if one were to replace

Re: [Firebird-devel] FB3 Run-time Statistics in gbak Verbose Output and also Release Notes

2015-11-10 Thread Helen Borrie
> 10.11.2015 15:19, liviuslivius wrote: >> and also on page 110: >> "See also: Tracker ticket CORE-4919" - this tracker ticket have not >> correlation with subject >> I suppose that different number should be? >> regards, Wednesday, November 11, 2015, 2:34:20 AM, Vlad wrote: >Looks like

Re: [Firebird-devel] -m switch

2015-10-15 Thread Helen Borrie
Hello Dmitry, > 15.10.2015 09:21, Helen Borrie wrote: >> >> Where is this? It's not in Fb3 Beta2 config file... Thursday, October 15, 2015, 7:25:53 PM, you wrote: > Current trunk. It was changed between Beta 2 and RC1. Thanks for

Re: [Firebird-devel] -m switch

2015-10-15 Thread Helen Borrie
Hello Dmitry, Thursday, October 15, 2015, 7:25:53 PM, you wrote: > Current trunk. It was changed between Beta 2 and RC1. When can we expect to get snapshots? Currently the Windows snapshots are just the Examples sub-tree or, in the case of the PDB kits, just fbclient and engine12 dlls. Helen

Re: [Firebird-devel] -m switch

2015-10-15 Thread Helen Borrie
Hello Dmitry, Thursday, October 15, 2015, 8:55:30 PM, you wrote: > Snapshots are rebuilt and re-uploaded. Thanks - downloaded the x64 7z kit and it's OK. Helen -- Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] -m switch

2015-10-15 Thread Helen Borrie
Hello Dmitry, > 15.10.2015 04:43, Helen Borrie wrote: >> >> Classic & Superclassic: SharedCache=0, SharedDatabase=1 >> So - what configuration parameter distinguishes Superclassic from >> Classic? Thursday, October

Re: [Firebird-devel] -m switch

2015-10-14 Thread Helen Borrie
> 14.10.2015 15:02, Dimitry Sibiryakov wrote: >> >> Since operation mode is now configured in config file, does firebird.exe >> still require >> -m switch to be multi-threaded? Thursday, October 15, 2015, 2:24:10 AM, Dmitry Yemanov wrote: > No. Classic & Superclassic: SharedCache=0,

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

2015-10-07 Thread Helen Borrie
At 05:07 p.m. 7/10/2015, Claudio Valderrama C. wrote: >> -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 &g

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

2015-10-07 Thread Helen Borrie
At 08:45 p.m. 7/10/2015, Helen Borrie wrote: >>For what I understand the config should read >>DatabaseAccess = Restrict h:\externalfiles >As to the format - copy/pasting from firebird.conf: > >"# ># External File Paths/Directories

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

2015-10-07 Thread Helen Borrie
At 01:06 a.m. 8/10/2015, Alex Peshkoff wrote: >On 10/07/2015 02:59 PM, Paul Vinkenoog wrote: >> Helen Borrie wrote: >> >>>> ExternalFileAccess = Restrict 'ExternalFiles'; >>> OK, so now I changed this to: >>> >>> ExternalFileAccess = Restri

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

2015-10-06 Thread Helen Borrie
At 03:25 p.m. 7/10/2015, Claudio Valderrama C. wrote: >> -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

[Firebird-devel] ExternalFileAccess in v.2.5.4

2015-10-06 Thread Helen Borrie
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 work as documented in firebird.conf. RECREATE TABLE EXT_LOG EXTERNAL FILE 'h:\externalfiles\test1.txt' ( STAMP CHAR(24),

Re: [Firebird-devel] CORE-4881

2015-09-21 Thread Helen Borrie
At 06:59 p.m. 21/09/2015, Dmitry Yemanov wrote: >21.09.2015 09:08, Simonov Denis wrote: > >>> 1. Can a string literal really be 64Kb if, internally, it is converted >>> to varchar? > >Yes, it can. Internally our varchars allow strings up to 64KB, but this >is not always respected in other

[Firebird-devel] Fb 3.0 RC1 User Name and Password Issues

2015-09-20 Thread Helen Borrie
All, I'm trying (or it is trying!) to do the release notes for RC1. Several "improvements" regarding what's legal for user names and passwords are flagged in WhatsNew but apparently there is no documentation describing what, why or how. All I can conclude from reading through the descriptions

[Firebird-devel] CORE-4881

2015-09-20 Thread Helen Borrie
Flagged as an improvement in RC1: core-4881 "Increase maximum string literal length to 64K (bytes) while setting a lower limit (of characters) for multibyte charsets based on their max char. length (UTF-8 literals will be limited to 16383 characters)" 1. Can a string literal really be 64Kb if,

[Firebird-devel] RDB$VIEW_RELATIONS

2015-09-16 Thread Helen Borrie
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 to!) it clearly *is* used or, at least, populated when a view is created. What's the back-story? Helen

[Firebird-devel] [FB-Tracker] Created: (CORE-4933) Add better transaction control to isql

2015-09-14 Thread Helen Borrie (JIRA)
: Any Reporter: Helen Borrie Priority: Minor This is a suggestion for a new feature in isql. Currently, it is not possible to change the attributes of the default transaction in isql. Whilst you can use SET TRANSACTION to start one transaction that is not the global

[Firebird-devel] [NO] RECORD_VERSION

2015-09-14 Thread Helen Borrie
According to both editions of The Firebird Book, for read/write read committed transactions, RECORD_VERSION is the default. According to the Firebird 2.5 Language Reference, NO RECORD_VERSION is the default. So - which is it? Did it change at some point? If so, at which release/sub-release?

[Firebird-devel] SET TRANSACTION in isql

2015-09-14 Thread Helen Borrie
A series of questions from a newbie in firebird-support prompted me to try and reproduce his results. He is trying to chart the effects of READ WRITE READ COMMITTED transactions in two simultaneous isql sessions, with and without WAIT and RECORD_VERSION. His theory was that using SET

Re: [Firebird-devel] [NO] RECORD_VERSION

2015-09-14 Thread Helen Borrie
At 08:28 p.m. 14/09/2015, Vlad Khorsun wrote: > NO RECORD_VERSION is the default for READ COMMITTED and it was not changed > since FB 0.x times. >I.e. if TPB containts "isc_tpb_read_committed" tag and contains nor >isc_tpb_rec_version, nor >isc_tpb_no_rec_version, engine will create READ

Re: [Firebird-devel] Differences between triggers

2015-06-27 Thread Helen Borrie
At 05:15 a.m. 28/06/2015, Adriano dos Santos Fernandes wrote: On 27-06-2015 04:19, Jiří Činčura wrote: Just a way to store the order you passed. I know it doesn't matter now, but is there a reason to store the order? Extract the metadata in the same way it was created, I guess.

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

2015-03-06 Thread Helen Borrie
At 02:36 p.m. 7/03/2015, Claudio Valderrama C. wrote: -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

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

2015-03-05 Thread Helen Borrie
At 09:16 p.m. 5/03/2015, marius adrian popa wrote: While there can we upgrade the license to mpl2 ? No. The source code we used for Firebird is licensed under MPL v.1.0. *That* version of the source code, *that* version of the MPL. Helen

Re: [Firebird-devel] FB3 and .Net provider

2014-12-07 Thread Helen Borrie
At 05:39 a.m. 8/12/2014, liviusliv...@poczta.onet.pl wrote: Hi, i can not connect to firebird 3 from .Net I do not know if this is becaouse of net provider my connection string is: character set=UTF8;client library=C:\Users\livius\Documents\Visual Studio

Re: [Firebird-devel] Snapshot 3.0.0.31439 Not listen on any port?

2014-11-19 Thread Helen Borrie
19.11.2014 11:37, Mark Rotteveel wrote: On Wed, 19 Nov 2014 11:28:15 +0200, Vlad Khorsun hv...@users.sf.net wrote: ... Seems, recently introduced support for IPv6 doens't work in XP. It is currently investigated. Windows XP doesn't have IPv6 installed/enabled by default IIRC. Maybe that

Re: [Firebird-devel] Bug release notes 3.0 Alpha 2

2014-10-22 Thread Helen Borrie
Dear Boys. At 09:03 p.m. 22/10/2014, Robbert-Jan wrote: Already reported by DOC-92. -Oorspronkelijk bericht- From: Mark Rotteveel Sent: Tuesday, October 21, 2014 10:14 PM To: firebird-devel@lists.sourceforge.net Subject: [Firebird-devel] Bug release notes 3.0 Alpha 2 Helen, In the

Re: [Firebird-devel] Meaning of incarnation

2014-07-01 Thread Helen Borrie
At 06:46 a.m. 2/07/2014, Mark Rotteveel wrote: In various places of the Firebird wire protocol and the Firebird sources the term 'incarnation' is used. What does this mean? (fig.) Bringing into existence; (lit.) Embodiment in human flesh. Helen

Re: [Firebird-devel] isc_dsql_fetch() return code 101

2014-02-28 Thread Helen Borrie
At 04:08 a.m. 1/03/2014, Dimitry Sibiryakov wrote: What is the meaning of subj? 100 is no more data, but 101?.. 101 | 335544366 | segment | Segment buffer length shorter than expected Something to do with your next Old API and wide result set and a BLOB sub_type 1? H

[Firebird-devel] SYSDBA (Chicken/egg)

2014-02-27 Thread Helen Borrie
With Fb 3 alpha 2 on Windows, is there any way to get SYSDBA into the security database, other than installing everything on Linux first, initializing it there and file-copying the security db to the Windows box? Helen

Re: [Firebird-devel] SYSDBA (Chicken/egg)

2014-02-27 Thread Helen Borrie
At 10:03 p.m. 27/02/2014, Alex Peshkoff wrote: On 02/27/14 12:32, Helen Borrie wrote: With Fb 3 alpha 2 on Windows, is there any way to get SYSDBA into the security database, other than installing everything on Linux first, initializing it there and file-copying the security db to the Windows

Re: [Firebird-devel] SYSDBA (Chicken/egg)

2014-02-27 Thread Helen Borrie
At 12:59 a.m. 28/02/2014, Mark Rotteveel wrote: On Thu, 27 Feb 2014 21:32:20 +1300, Helen Borrie hele...@tpg.com.au wrote: With Fb 3 alpha 2 on Windows, is there any way to get SYSDBA into the security database, other than installing everything on Linux first, initializing it there and file

Re: [Firebird-devel] SYSDBA (Chicken/egg)

2014-02-27 Thread Helen Borrie
At 11:42 p.m. 27/02/2014, Alex Peshkoff wrote: On 02/27/14 14:19, Helen Borrie wrote: Observation: I had to commit explicitly following the CREATE USER statement. I guess it's really not pure DDL to be affected by autoddl=on...? CREATE USER is real DDL statement and it's affected

Re: [Firebird-devel] SYSDBA (Chicken/egg)

2014-02-27 Thread Helen Borrie
At 08:15 p.m. 28/02/2014, Alex wrote: [Mark Rotteveel] If you didn't enable legacy auth in the installer, then it only creates the 'new auth' sysdba account. Legacy SYSDBA is present in security database when it's installed. With masterke password - according to legacy rules :)

Re: [Firebird-devel] How to make a call of the same name of the stored procedure within a package from the global namespace?

2014-01-25 Thread Helen Borrie
At 08:24 a.m. 26/01/2014, Simonov Denis wrote: However there will be a problem of homonymy of schemas and packets. What is meant by packets? Same as packages? Something else? However current situation should be reflected in Release Notes. From a design perspective, my simple-minded view

[Firebird-devel] [FB-Tracker] Created: (CORE-4256) Include bitness info in property sheets of executables and libraries

2013-11-06 Thread Helen Borrie (JIRA)
: Improvement Components: Build Issues / Porting Affects Versions: 3.0 Alpha 1, 2.5.2 Update 1, 2.1.5 Update 1, 2.5.2, 2.1.5, 2.0.7 Environment: All 64-bit platforms, all versions Reporter: Helen Borrie Priority: Minor It is seemingly impossible

Re: [Firebird-devel] RFC: non-expandable fields

2013-04-04 Thread Helen Borrie
At 08:18 a.m. 5/04/2013, Mark Rotteveel wrote: On the other hand: using select * for anything other than ad-hoc queries is bad. Should we support that? AFAIK, there's a long legacy, in Delphi components at least, of using SELECT * as the dataset spec for emulating a table component (TTable and

[Firebird-devel] [FB-Tracker] Created: (CORE-4044) Include bitness in fbclient.dll properties

2013-02-09 Thread Helen Borrie (JIRA)
Library Affects Versions: 2.5.2, 2.1.5, 3.0 Initial Environment: Windows, all versions since we started supporting 64-bit, 32-bit and 64-bit platforms. Probably other platforms too. I think MacOSX takes care of this problem. Reporter: Helen Borrie In the property sheet

[Firebird-devel] gbak: restoring privileges

2013-01-28 Thread Helen Borrie
Backup of an ODS 11.2 database was made on a v.2.5 server using the gbak.exe from v.2.0. The database structure doesn't use anything that v.2.0 doesn't support and has no permissions depending on the RDB$ADMIN role. The backup completed without any errors. During the restore on the v.2.0.7

Re: [Firebird-devel] gbak: restoring privileges

2013-01-28 Thread Helen Borrie
gbak: ERROR:action cancelled by trigger (3) to preserve data integrity gbak: ERROR:table/procedure has non-SQL security class defined gbak:Exiting before completion due to errors What does the error signify? 28.01.2013 15:25, Alex Peshkoff wrote: Probably a bug. Can it be reproduced

Re: [Firebird-devel] gbak: restoring privileges

2013-01-28 Thread Helen Borrie
28.01.2013 19:48, Helen Borrie wrote: A related issue: This particular database has a very large amount of metadata and the extract script was rejected by isql -input as being too large for its buffer. Do we know what the limit on isql's buffer size is? At 07:58 a.m. 29/01/2013, Dimitry

Re: [Firebird-devel] ERROR:operating system directive CreateFile failed

2012-10-04 Thread Helen Borrie
At 07:57 AM 5/10/2012, Vlad Khorsun wrote: Why does Firebird return such a low level OS-dependent(?) error message instead of returning a Firebird-specific message that explains what went wrong (eg creating temporary files), instead of why it failed (the low-level error message)? - because

Re: [Firebird-devel] no permission for read/select access to TABLE

2012-07-21 Thread Helen Borrie
At 09:32 AM 22/07/2012, nezos wrote: Greetings, i have a new database which i populated with the membership tables and procedures using the 2.1 scripts. After that i decided not to use SYSDBA (everything works) and added a user and a role. I granted permissions then i saw that i couldn't run a

[Firebird-devel] [FB-Tracker] Created: (CORE-3878) DatabaseAccess default changed in 2.5+ unintentionally?

2012-06-25 Thread Helen Borrie (JIRA)
: Installation Affects Versions: 2.5.1, 2.5.0 Environment: Any? or just Windows? Reporter: Helen Borrie Priority: Minor In prior versions, DatabaseAccess was configured to None by default. In V.2.5+ it appears to be configured to Full by default

[Firebird-devel] [FB-Tracker] Created: (CORE-3717) Anomalies between 3 methods of user management regarding valid user names and passwords

2012-01-05 Thread Helen Borrie (JIRA)
Project: Firebird Core Issue Type: Bug Components: Security Affects Versions: 2.5.1 Environment: We tested on 32-bit Windows but the issues should be platform-independent. Reporter: Helen Borrie 1. With CREATE USER, cannot create a user name starting

Re: [Firebird-devel] FB 3: Use cases for updating system tables directly

2011-11-30 Thread Helen Borrie
At 10:50 PM 30/11/2011, Adriano dos Santos Fernandes wrote: On 30/11/2011 03:53, Alex Peshkoff wrote: On 11/30/11 02:42, Frank Ingermann wrote: DROP SOURCE OF [procedure name|trigger name|*] or CHANGE OWNER OF [db object|*] TOnew_owner This approach looks much better than use of system

[Firebird-devel] Firebird 2.5.1 release candidate kits

2011-08-24 Thread Helen Borrie
The Firebird Project team is happy to announce that the v.2.5.1 release candidate kits for Linux and Windows 32-bit and 64-bit platforms are ready for testing. http://firebirdsql.org/en/firebird-2-5-1-rc1 MacOSX kits are delayed by a problem with MacOSX 10.7 (Lion) but should appear soon.