Re: [Firebird-devel] Profiler plugin is not found. Windows snapshot Firebird-5.0.0.684-0-x64

23.08.2022 13:38, Norbert Saint Georges пишет: Simonov Denis via Firebird-devel a écrit : SQL> connect inet://localhost:3055/employee user SYSDBA password 'masterkey'; Database: inet://localhost:3055/employee, User: SYSDBA SQL> select rdb$profiler.start_session('Profile Session 1') fro

[Firebird-devel] Profiler plugin is not found. Windows snapshot Firebird-5.0.0.684-0-x64

SQL> connect inet://localhost:3055/employee user SYSDBA password 'masterkey'; Database: inet://localhost:3055/employee, User: SYSDBA SQL> select rdb$profiler.start_session('Profile Session 1') from rdb$database; START_SESSION = Statement failed, SQLSTATE = HY000

[Firebird-devel] Windows snapshor for Firebird 5.0

No snapshots for windows in http://web.firebirdsql.org/download/snapshot_builds/win/5.0/ And the second problem. If you download the artifact https://github.com/FirebirdSQL/firebird/suites/7826192155/artifacts/330779110 and others under Windows, it does not contain default_profiler.dll

Re: [Firebird-devel] New statement: EXECUTE SQL

15.08.2022 13:24, Adriano dos Santos Fernandes пишет: On 15/08/2022 04:16, Simonov Denis via Firebird-devel wrote: Very good feature, reminds me of the functionality from Oracle WITH Procedure p1 ...  AS ... FUNCTION f1 ... AS ... SELECT... Firebird does not have any support for client

Re: [Firebird-devel] New statement: EXECUTE SQL

14.08.2022 2:28, Adriano dos Santos Fernandes пишет: Hi! When one starts with a DSQL command and need to adapt it to EXECUTE BLOCK (for example to use sub routines or use a single parameter in many places), work is difficult when there are many parameters and output fields. Everything must

Re: [Firebird-devel] New statement: EXECUTE SQL

14.08.2022 2:28, Adriano dos Santos Fernandes пишет: Hi! When one starts with a DSQL command and need to adapt it to EXECUTE BLOCK (for example to use sub routines or use a single parameter in many places), work is difficult when there are many parameters and output fields. Everything must

Re: [Firebird-devel] Tablespaces proposal

should be postponed until the next major version, otherwise the release of Firebird 5.0 will be delayed as always. It is necessary to release a release more often than once 4-5 years. -- Simonov Denis Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists

Re: [Firebird-devel] ODP: SQL profiler

://lists.sourceforge.net/lists/listinfo/firebird-devel -- Simonov Denis Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] PSQL profiler

/firebird-devel -- Simonov Denis Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Firebird PDO preprocessing sql

rewritten. In particular, this one https://github.com/FirebirdSQL/firebird/blob/master/src/jrd/extds/ExtDS.cpp#L1928 The question is, are there any license restrictions? Can contributors apply this patch? -- Simonov Denis Firebird-Devel mailing list, web interface at https

Re: [Firebird-devel] OO API examples for Object Pascal

data from char/varchar is not so easy to convert to delphi strings, given the character sets. It is desirable that the examples can be compiled in both FPC and Delpli. -- Simonov Denis Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird

[Firebird-devel] [FB-Tracker] Created: (CORE-6345) Server crashes on overflow of division result

;WI-V4.0.0.2076 Firebird 4.0 Release Candidate 1/tcp (DESKTOP-E3INAFT)/P16:C" Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V4.0.0.2076 Firebird 4.0 Release Candidate 1/tcp (DESKTOP-E3INAFT)/P16:C" on disk structure version 13.0 Reporter: Simonov Deni

Re: [Firebird-devel] No Firebird 4.0 snapshots

, but there are still no snapshots under Windows. Is there any progress? -- Simonov Denis Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] SET BIND OF

Alex Peshkoff via Firebird-devel писал(а) в своём письме Sun, 08 Dec 2019 18:59:12 +0300: On 2019-12-08 16:39, Simonov Denis via Firebird-devel wrote: Alex Peshkoff via Firebird-devel wrote Sun, 08 Dec 2019 15:12:03 +0300: Thank you, not needed - fixed that. Fixed

Re: [Firebird-devel] SET BIND OF

-- NORMALIZE_DECFLOAT(4300) as n1, QUANTIZE(2, 9.9) as n2, COMPARE_DECFLOAT(2, 2) as n3, TOTALORDER(1.0, 1) as n4 from rdb$database; Works OK -- Simonov Denis Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] SET BIND OF

4.0.0.1683 x64. If necessary, I can create a ticket in the tracker. -- Best regards, Simonov Denis Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-6191) Broken short C-style cast for literary 'NOW'

Environment: windows 7 x64 Reporter: Simonov Denis select current_timestamp as t1, timestamp 'now' as t2, cast('now' as timestamp) as t3 from rdb$database Overflow occurred during data type conversion. conversion error from string "now". If you comment out

Re: [Firebird-devel] Underlying format of high precision numerics

Vlad Khorsun wrote Tue, 17 Sep 2019 17:22:10 +0300: 17.09.2019 16:42, Simonov Denis via Firebird-devel wrote: Simonov Denis via Firebird-devel wrote Tue, 17 Sep 2019 15:47:14 +0300: FIELD_TYPE = 26 - this is bigint I'm sorry, it seems like I'm wrong. It would be nice to add a new

Re: [Firebird-devel] Underlying format of high precision numerics

Simonov Denis via Firebird-devel wrote Tue, 17 Sep 2019 15:47:14 +0300: FIELD_TYPE = 26 - this is bigint I'm sorry, it seems like I'm wrong. It would be nice to add a new type to RDB$TYPES. However, the examples above do not work. -- Simonov Denis Firebird-Devel mailing list, web

Re: [Firebird-devel] Underlying format of high precision numerics

22003 arithmetic exception, numeric overflow, or string truncation -numeric value is out of range I don’t know, maybe because the windows platform? -- Simonov Denis Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Underlying format of high precision numerics

: name: CAST alias: N : table: owner: N = 12345678901234567890 If you bind to char, then everything works. -- Simonov Denis Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] TIME WITH TZ

list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- regards, Simonov Denis Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Underlying format of high precision numerics

don’t need to remove anything. We are talking only about the implementation of NUMERIC (19+, x) and DECIMAL (19+, x) -- Simonov Denis Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

Windows Server 2012 x64. After installation Firebird 4.0.0.1436 x64 we have the following. Connect from IBExpert use c:\Program Files\Firebird\Firebird_4_0\WOW64\fbclient.dll When trying to execute a query, we get the error "Could not find acceptable ICU library" select current_timestamp

[Firebird-devel] [FB-Tracker] Created: (CORE-6078) Permissions for create or alter statements are not checked.

Components: Security Affects Versions: 3.0.4 Environment: Firebird 3.0.5.33139 Windows x64 Reporter: Simonov Denis create test$user password '123'; -- Unprivileged user -- connect to any database set term ! ; create procedure New_Procedure123 as begin end! set term

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

06.03.2019 18:26, Adriano dos Santos Fernandes пишет: On 04/03/2019 11:08, Adriano dos Santos Fernandes wrote: On 04/03/2019 10:57, Alex Peshkoff via Firebird-devel wrote: On 3/4/19 3:15 PM, Vlad Khorsun wrote: 04.03.2019 14:01, Alex Peshkoff via Firebird-devel wrote: On 3/4/19 2:57 PM, Vlad

[Firebird-devel] Firebird 4: Could not find acceptable ICU library

in the user database and the request was immediately executed successfully. Is it possible to improve the search for ICU libraries if another version of ICU is already loaded by the application? -- Simonov Denis Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists

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

as c6__null_and_true, /* NULL */ null and false as c7__null_and_false /* FALSE */ from rdb$database Just - yes or no :) Thanks, Dmitry Kovalenko Yes -- Simonov Denis Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

Dimitry Sibiryakov wrote Mon, 01 Oct 2018 13:28:44 +0300: 01.10.2018 12:22, Simonov Denis via Firebird-devel wrote: Current SPs do not know how to aggregate data by an external cursor. To do this, you need to write queries inside the SP. How is this related to (in)ability to return

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

Dimitry Sibiryakov wrote Mon, 01 Oct 2018 13:12:36 +0300: 01.10.2018 12:07, Simonov Denis via Firebird-devel wrote: To return more than one value you need support for ROW types. Otherwise, the function still does not extract more than one value. Current SP can return several values

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

) do begin if (i is not null) then begin count = count + 1; accumulated = accumulated + i; result = accumulated / count; end yeild result; end end -- Simonov Denis Firebird-Devel mailing list, web interface at https

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

+ deviation. To return more than one value you need support for ROW types. Otherwise, the function still does not extract more than one value. -- Simonov Denis Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Broken read committed consistency (was Changes in JRD_start/JRD_start_and_send in "read consistency" patch)

transactionally independent UDRs and for them, too, change the default behavior. In the end, you can come up with a new isc_tpb_no_restart for read committed read consistency -- Simonov Denis -- Check out the vibrant tech

Re: [Firebird-devel] Changes in JRD_start/JRD_start_and_send in "read consistency" patch

, the transaction of which will be rolled back nothing better than sending mail twice. __ Regards, Simonov Denis -- Check out the vibrant tech community on one of the world's most engaging tech sites

Re: [Firebird-devel] Smart end of statement detection in ISQL

Adriano dos Santos Fernandes wrote Sun, 24 Jun 2018 21:09:21 +0300: Not touching the algorithm AUTOTERM. This functionality would be useful. Moreover, some IDEs for Firebird successfully solve this problem, for example IB Expert. Although perhaps this is not cheap. -- Simonov Denis

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

e rule? -- Simonov Denis -- 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.sourcefor

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

Dmitry Yemanov wrote Fri, 08 Sep 2017 11:03:02 +0300: 1) d 2) c 3) b 4) b -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org!

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

Dmitry Yemanov wrote Fri, 08 Sep 2017 11:03:02 +0300: 1) d 2) c 3) b 4) b -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org!

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

Dmitry Yemanov wrote Fri, 08 Sep 2017 11:03:02 +0300: 1) d 2) c 3) b 4) b -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org!

[Firebird-devel] firebirdsql.org not work

should correct your system's clock and then refresh this page. -- Simonov Denis -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel

Re: [Firebird-devel] RFC: Timeouts

Dimitry Sibiryakov wrote Sun, 26 Feb 2017 14:16:53 +0300: > >Shouldn't this timer run till call isc_free_statement(..., > DSQL_close) instead of fetch > of the last record? Bidirectional cursors will still keep resources > after last fetch and > current timeout

Re: [Firebird-devel] RFC: Timeouts

opers JDBC and ADO .NET drivers because they do not use fbclient. -- The best regards, Simonov Denis -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot

[Firebird-devel] [FB-Tracker] Created: (CORE-5471) Add support for parts of the date and time in the clause RANGE window functions

Issue Type: Improvement Reporter: Simonov Denis Priority: Minor Currently RANGE clause supports only numeric values for PRECEDING and FOLLOWING borders. However, if an expression in the ORDER BY clause is a type of TIMESTAMP is difficult to set any interval

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

. If FileSystemCacheThreshold < DefaultDbCachePages file cache is disabled, which may reduce performance ability to make some cases. -- Simonov Denis -- Developer Access Program for Intel Xeon Phi Processors Access

Re: [Firebird-devel] FB3.0.1 - Impossible to alter table

n of such restrictions is to fix an old bug. The fact that the addition of a field with a NOT NULL constraint to non-empty table violates the consistency of the database. You must use the following statement: ALTER TABLE Defects ADD idDefectType TLongInt DEFAULT 0 NOT NULL; -- Simonov Denis

[Firebird-devel] [FB-Tracker] Created: (CORE-5373) Error reuse reference cursor if one of the query field is computed using a subquery

: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.1 Reporter: Simonov Denis SET SQL DIALECT 3; SET TERM ^ ; CREATE PROCEDURE SP_TESP RETURNS ( RESULT SMALLINT) AS BEGIN SUSPEND; END^ SET TERM ; ^ CREATE TABLE TEST ( ID SMALLINT

[Firebird-devel] [FB-Tracker] Created: (CORE-5337) Regression: The cursor does not see the changes made earlier in the same executable block.

Project: Firebird Core Issue Type: Bug Affects Versions: 3.0.0 Reporter: Simonov Denis WI-V6.3.0.32483 Firebird 3.0 CREATE TABLE TEST ( ID INTEGER NOT NULL, VAL INTEGER NOT NULL ); execute block as begin insert into test (id, val) values (1, 100); insert

Re: [Firebird-devel] RFC: Timeouts

cursor open for hours. Although most of the applications in Delphi RO RC transactions do just that. Do not take the DBA for a fool, if he puts a specific parameter in the configuration, it must understand the consequences of their decisions. -- Simonov Denis ---

[Firebird-devel] [FB-Tracker] Created: (CORE-5271) Regression: Can not create large index

: Windows 10 x64, WI-T4.0.0.246 Firebird 4.0 Reporter: Simonov Denis set names utf8; create database 'localhost/3054:test' user SYSDBA password 'masterkey' page_size 8192 default character set utf8; create table t1( id int not null, a int ); commit; set term !; execute block

Re: [Firebird-devel] Firebird.pas for the windows build

ds.g.doubleclick.net/gampad/clk?id=278785351=/4140 > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > -- Simonov Denis -- Find and fix applicati

Re: [Firebird-devel] Physical replication using NBACKUP

k > } > These commands can also be combined into one, such as nbackup -MERGE -DATABASE source.fdb target.fdb [-INCREMENT source-inc.nbk] During the execution of this command, GUID could be read automatically from target.fdb -- Simonov Denis ---

[Firebird-devel] [FB-Tracker] Created: (CORE-5133) "Alter sequence restart with" does not change the initial value

Type: Bug Affects Versions: 3.0 RC2 Environment: WI-V3.0.0.32342 Firebird 3.0 Release Candidate 2 Reporter: Simonov Denis SQL> create sequence s1 start with 100 increment 2; SQL> show sequences; Generator S1, current value: 100, initial value: 100, increment: 2 SQL>

[Firebird-devel] [FB-Tracker] Created: (CORE-5128) Allow to specify a prefix protocol for embedded

Allow to specify a prefix protocol for embedded --- Key: CORE-5128 URL: http://tracker.firebirdsql.org/browse/CORE-5128 Project: Firebird Core Issue Type: Improvement Reporter: Simonov

[Firebird-devel] [FB-Tracker] Created: (CORE-5117) Firebird embedded hangs and crashes when disconnect if not called fb_shutdown function

: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.5.5 Environment: Firebird 2.5.6.26976 and IBExpert Reporter: Simonov Denis -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one

Re: [Firebird-devel] String error with actual snapshot of 3.0

Gabor Boros wrote Wed, 06 Jan 2016 12:32:31 +0300: > Hi All, > > After switched from 3.0.0.32233 to 32266 my app (and IBExpert) give a > string error with the below query, "expected length 124, actual 0". > > SELECT COUNT(MON$ATTACHMENTS.MON$ATTACHMENT_ID) FROM

Re: [Firebird-devel] Pull request fixed (explained plan xml format)

> > > > > >

[Firebird-devel] [FB-Tracker] Created: (CORE-4975) Do not invalidate the package body when [CREATE OR] ALTER PACKAGE did not change the packet header

-4975 Project: Firebird Core Issue Type: Improvement Reporter: Simonov Denis Do not invalidate the package body when [CREATE OR] ALTER PACKAGE did not change the packet header. For example, adding comments or formatting source of the package header should

[Firebird-devel] [FB-Tracker] Created: (CORE-4969) Table PLG$USERS and view PLG$VIEW_USERS are not created automatically when you create a SYSDBA with Legacy_UserManager

://tracker.firebirdsql.org/browse/CORE-4969 Project: Firebird Core Issue Type: Bug Components: Security Affects Versions: 3.0 Beta 2 Environment: Windows 7 x64, Firebird 3.0.0.32060 x64 Reporter: Simonov Denis Create database with standard

Re: [Firebird-devel] -m switch

has its own DB >> pages cache >> # >> # Type: string >> # >> #ServerMode = Super > > Where is this? It's not in Fb3 Beta2 config file... > > Helen > It's firebird.conf for current snaphot Firebird 3. > >

[Firebird-devel] [FB-Tracker] Created: (CORE-4954) The package procedure with value by default isn't called if this parameter isn't specified.

Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0 Beta 2 Reporter: Simonov Denis set term ^; create package t1 as begin procedure p1(a int, b int = 1); procedure p2; end^ create package body t1 as begin procedure p1(a int

Re: [Firebird-devel] revoke all on all

ted by ABC rights too > ? > > -- > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > I vote for option 2. It is more correct to behavior statement REVOKE ALL ON ALL was no different fr

Re: [Firebird-devel] CORE-4881

- > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > -- Simonov Denis -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Invalid scripts to install SS/CS in a snapshot

D:\fb\fb30>D:\fb\fb30\install_super.bat instreg version WI-V3.0.0.32047 Firebird 3.0 Release Candidate 1 Firebird has been successfully installed in the registry. Unknown switch "superserver" If I understand correctly now has to be only one installation script: install.bat --

Re: [Firebird-devel] RDB$VIEW_RELATIONS

Helen Borrie <hele...@tpg.com.au> wrote Thu, 17 Sep 2015 03:45:43 +0300: > The new FBLangref 25 says RDB$VIEW_RELATIONS is not used in current > versions. It seems to me there is not quite correctly written. Since Firebird 3 this table even expanded. -- S

[Firebird-devel] [FB-Tracker] Created: (CORE-4909) The incorrect result HASH / MERGE JOIN in the fields of type VARCHAR with a trailing space

Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Beta 2, 2.5.4 Reporter: Simonov Denis RECREATE TABLE T ( V VARCHAR(10), X INTEGER ); INSERT INTO T (V, X) VALUES ('ww', 1); INSERT INTO T (V, X) VALUES ('ww ', 2); COMMIT; --CREATE INDEX IDX_T_V

Re: [Firebird-devel] Problem with MERGE

the former to the latter internally). Dmitry -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Simonov Denis

[Firebird-devel] Inconsistency in the table RDB$AUTH_MAPPING.

executed statement CREATE MAPPING WIN_ADMINS USING ANY PLUGIN SERVERWIDE FROM Predefined_Group DOMAIN_ANY_RID_ADMINS TO ROLE RDB$ADMIN; Found that the field RDB$SYSTEM_FLAG matters NULL, despite the fact that it is defined as NOT NULL. Although it should be 0. -- Simonov Denis

[Firebird-devel] [FB-Tracker] Created: (CORE-4721) Hangs statistics collection by the service manager, if you change the database security in databases.conf

/browse/CORE-4721 Project: Firebird Core Issue Type: Bug Components: SVCMGR Affects Versions: 3.0 Beta 1 Environment: Windows 7 x64, Firebird 3.0.0.31739 x64 Reporter: Simonov Denis database.conf horses = d:\fb\fb30\data\horses.fdb

Re: [Firebird-devel] Firebird 3 snapshot not contain Employee.fdb and more..

and supposedly forgotten to be enabled back. I will check. Dmitry directory /help and its contents is also absent -- Simonov Denis -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Simonov Denis -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot

[Firebird-devel] [FB-Tracker] Created: (CORE-4702) Regression: The order for joining the tables is less than optimal in Firebird 2.x.

: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0 Beta 1 Reporter: Simonov Denis Priority: Minor CREATE TABLE TRIAL ( CODE_TRIAL INTEGER NOT NULL, CODE_PRIZE INTEGER NOT NULL, BYDATE DATE

Re: [Firebird-devel] DDL permissions

should be the right user control mapping. SYSDBA and users rights RDB$ADMIN? -- Simonov Denis -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership

[Firebird-devel] FB3 snapshots on Windows are not builded.

FB3 snapshots on Windows are not builded. The archives at http://web.firebirdsql.org/download/snapshot_builds/win/3.0/ only examples without binaries. -- Simonov Denis -- Dive into the World of Parallel Programming

[Firebird-devel] [FB-Tracker] Created: (CORE-4657) Error when duplicating user in different plug-ins

Environment: FB 3.0.0.31529 x64, Windows x64, ISQL Reporter: Simonov Denis Priority: Minor Tried to create a SYSDBA Legacy_UserManager. In firebird.conf set UserManager = Srp, Legacy_UserManager In Srp SYSDBA already existed. c:\Program Files\Firebird

[Firebird-devel] Boolean parameters

= 0 # # Type: boolean # #Redirection = 0 # Type: boolean # #TcpNoNagle = 1 # Type: boolean # #RelaxedAliasChecking = 0 # Type: boolean # #BugcheckAbort = 0 # # Type: boolean # #RemoteFileOpenAbility = 0 -- Simonov Denis

[Firebird-devel] [FB-Tracker] Created: (CORE-4591) Push the predicate into derived tables or CTE with a window function if it uses the column on which the partitioning occurs

URL: http://tracker.firebirdsql.org/browse/CORE-4591 Project: Firebird Core Issue Type: Improvement Components: Engine Environment: isql WI-T3.0.0.31385 Firebird 3.0 Beta 1 Reporter: Simonov Denis Push the predicate into derived tables or CTE

[Firebird-devel] Incorrect error for PSQL functions.

3.0 Alpha 2/tcp (station9)/P13:C on disk structure version 12.0 It seems to me that the error message for PSQL functions should be the same as for the procedure. -- Simonov Denis -- Meet PCI DSS 3.0 Compliance

[Firebird-devel] [FB-Tracker] Created: (CORE-4572) Incorrect error for PSQL function when the number of actual arguments does not match the number of formal arguments.

://tracker.firebirdsql.org/browse/CORE-4572 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0 Alpha 2 Environment: isql, Firebird WI-T3.0.0.31353 Firebird 3.0 Alpha 2 Reporter: Simonov Denis Priority

[Firebird-devel] [FB-Tracker] Created: (CORE-4566) Incorrect size of the output argument when connection character set does not match the character set of the return argument

URL: http://tracker.firebirdsql.org/browse/CORE-4566 Project: Firebird Core Issue Type: Bug Components: Charsets/Collation Affects Versions: 3.0 Alpha 2 Reporter: Simonov Denis Incorrect size of the output argument when connection character set

[Firebird-devel] [FB-Tracker] Created: (CORE-4539) Server does not accept the right plan

: Windows 7 x64, ISQL Reporter: Simonov Denis Server does not accept the right plan SQL set plan on; SQL select count(*) CON from horse CON join color on horse.code_color = color.code_color CON where horse.name = color.name; PLAN JOIN (COLOR NATURAL, HORSE INDEX (HORSE_IDX_NAME

Re: [Firebird-devel] Hiding source code of procedures and triggers will not work in FB 3

Saunders, Rich greym...@mykolab.com wrote Mon, 01 Sep 2014 04:06:24 +0400: In addition to protecting FB3 procedures, functions and triggers should also realize and reset the source code of the package body. -- Simonov Denis

Re: [Firebird-devel] DDL permissions

Alex Peshkoff peshk...@mail.ru wrote Sun, 17 Aug 2014 13:00:52 +0400: Denis, please add a ticket to the tracker. OK. http://tracker.firebirdsql.org/browse/CORE-4522 -- Simonov Denis -- Firebird-Devel mailing list

[Firebird-devel] [FB-Tracker] Created: (CORE-4522) DDL permission do not protect against removal BLOB filters

Components: Engine Affects Versions: 3.0 Alpha 2 Reporter: Simonov Denis It seems that the DLL permissions protects not all objects. In particular, I conducted an experiment on BLOB filters. Creating a new filter is effectively prohibited for any user. But the removal could

Re: [Firebird-devel] DDL permissions

ENTRY_POINT 'desc_filter' CON MODULE_NAME 'FILTERLIB'; Statement failed, SQLSTATE = 42000 unsuccessful metadata update -DECLARE FILTER DESC_FILTER failed -There is no privilege for this operation SQL -- Simonov Denis

[Firebird-devel] [FB-Tracker] Created: (CORE-4518) Show in trace new counters have been added to the MON$RECORD_STATS

: Improvement Components: TRACEMGR Reporter: Simonov Denis The table MON$RECORD_STATS have added new columns: MON$RECORD_LOCKS MON$RECORD_WAITS MON$RECORD_CONFLICTS MON$VERSION_READS MON$FRAGMENT_READS However, in tracing these statistics not available. Table

Re: [Firebird-devel] DDL permissions

Dmitry Yemanov firebi...@yandex.ru wrote Sat, 02 Aug 2014 20:14:38 +0400: 01.08.2014 18:55, Simonov Denis wrote: SQL insert into RDB$EXCEPTIONS(RDB$EXCEPTION_NAME) VALUES ('E1'); Note that I did this unprivileged user! At the first glance, I don't see why it cannot be prohibited. But I see

Re: [Firebird-devel] DDL permissions

$EXCEPTIONS(RDB$EXCEPTION_NAME) VALUES ('E1'); SQL commit; SQL show exceptions; Exception Name Used by, Type === = E1 -- Simonov Denis

[Firebird-devel] [FB-Tracker] Created: (CORE-4506) Firebird server crashes when execute command show roles after reconnect

Type: Bug Components: Engine Affects Versions: 3.0 Alpha 2 Environment: Windows 7 x64, ISQL Reporter: Simonov Denis SQL create database 'localhost:test' user 'sysdba' password 'masterkey'; SQL show version; ISQL Version: WI-T3.0.0.31272 Firebird 3.0 Alpha 2

[Firebird-devel] [FB-Tracker] Created: (CORE-4503) ISQL command SHOW USERS display only me

Alpha 2 Environment: Windows 7 x64, Firebird Version: WI-T3.0.0.31258 Firebird 3.0 Alpha 2, SuperServer Reporter: Simonov Denis Priority: Minor Use CONNECT or CREATE DATABASE to specify a database SQL connect 'localhost:test' user 'sysdba' password 'masterkey

[Firebird-devel] COMMENT ON docs

something like [EXTERNAL] FUNCTION -- Simonov Denis -- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps

Re: [Firebird-devel] DDL permissions

, COLLATION, FILTER . however, the revision 59902 Removed SHADOW permissions since they handled by ALTER DATABASE permission Please update docs. -- Simonov Denis -- Want fast and easy access to all the code

Re: [Firebird-devel] Firebird 3 - Gsec error with snapshot build

the user. unsuccessful metadata update CREATE TABLE PLG$SRP failed There is no privilege for this operation Gabor workarounds by Dmitry gsec -user sysdba -pass masterkey GSEC add sysdba -pw masterkey -- Simonov Denis

Re: [Firebird-devel] DDL permissions

snapshot. -- Simonov Denis -- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's

Re: [Firebird-devel] DDL permissions

Dmitry Yemanov firebi...@yandex.ru wrote Thu, 17 Jul 2014 17:58:59 +0400: 17.07.2014 12:32, Simonov Denis wrote: Two workarounds are possible: (1) gsec -user sysdba -pass masterkey GSEC add sysdba -pw masterkey or (2) isql -user sysdba employee SQL create user sysdba password

Re: [Firebird-devel] DDL permissions

/role name [with grant option]; REVOKE [grant option for] CREATE OBJECT FROM [USER | ROLE] user/role name; REVOKE [grant option for] ALTER ANY OBJECT FROM [USER | ROLE] user/role name; REVOKE [grant option for] DROP ANY OBJECT FROM [USER | ROLE] user/role name; -- Simonov Denis

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

. -- Simonov Denis -- Open source business process management suite built on Java and Eclipse Turn processes into business applications with Bonita BPM Community Edition Quickly connect people, data, and systems into organized

[Firebird-devel] RDB$MAP_TO_TYPE in RDB$TYPES

Field RDB$MAP_TO_TYPE of tables RDB$AUTH_MAPPING and SEC$GLOBAL_AUTH_MAPPING is not present in RDB$TYPES. Or am I bad looking and what I do not understand? -- Simonov Denis -- Open source business process

Re: [Firebird-devel] RDB$MAP_TO_TYPE in RDB$TYPES

Alex Peshkoff peshk...@mail.ru писал(а) в своём письме Mon, 30 Jun 2014 17:06:25 +0400: On 06/30/14 16:56, Simonov Denis wrote: Field RDB$MAP_TO_TYPE of tables RDB$AUTH_MAPPING and SEC$GLOBAL_AUTH_MAPPING is not present in RDB$TYPES. Or am I bad looking and what I do not understand? It's

[Firebird-devel] [FB-Tracker] Created: (CORE-4477) Field RDB$MAP_TO_TYPE is not present in RDB$TYPES

Reporter: Simonov Denis Priority: Minor Field RDB$MAP_TO_TYPE of tables RDB$AUTH_MAPPING and SEC$GLOBAL_AUTH_MAPPING is not present in RDB$TYPES. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

the default behavior, but it does not negate an separate TBP. Current behavior RO RC convenient for Grids when fetch data as you scroll. An alternative is to fetch all records that may take quite a decent time. -- Simonov Denis

  1   2   >