[Firebird-devel] [FB-Tracker] Created: (CORE-4859) FB 3 embedded not working without folder C:\ProgramData\firebird
FB 3 embedded not working without folder C:\ProgramData\firebird Key: CORE-4859 URL: http://tracker.firebirdsql.org/browse/CORE-4859 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0 Beta 2 Environment: Windows 7 Reporter: Nick Dee Attachments: FbErr1.png how to reproduce: 1. delete folder C:\ProgramData\firebird if exists 2. unpack default installation zip to any place 3. connect to local database without server run. Error: operating system directive CreateFile failed Системе не удается найти указанный путь. Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements GDS Code: 335544373, SQL Code: -902, Error Code: 53 firebird.log: Sun Jul 05 13:46:11 2015 Operating system call CreateFile failed. Error code 3 Sun Jul 05 13:46:11 2015 ConfigStorage: Cannot initialize the shared memory region operating system directive CreateFile failed Системе не удается найти указанный путь. Sun Jul 05 13:46:12 2015 Operating system call CreateFile failed. Error code 3 Sun Jul 05 13:46:12 2015 ConfigStorage: Cannot initialize the shared memory region operating system directive CreateFile failed Системе не удается найти указанный путь. -- I use SysInternals tool for find what file will be failed (see screenshot) In future it will be helpful to found full path in log. Just for saving time. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4716) user-friendly DPB-string in new api
user-friendly DPB-string in new api --- Key: CORE-4716 URL: http://tracker.firebirdsql.org/browse/CORE-4716 Project: Firebird Core Issue Type: Improvement Components: API / Client Library Reporter: Nick Dee Now DPB looks like this: #1'?'#1#3'0'#7'WIN1251'#$1C#6'SYSDBA'#$1D#9'masterkey' (in Delphi). It is not so easy to generate it correctly. Something like 'ConnectionSqlDialect=[3], ConnectionCharSet=[WIN1251], UserName=[SYSDBA], Password=[masterkey]' seems more friendly. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4636) rollback works incorrect for some metadata changes
rollback works incorrect for some metadata changes -- Key: CORE-4636 URL: http://tracker.firebirdsql.org/browse/CORE-4636 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0 Beta 2 Environment: 3.0.0.31455 embedded Reporter: Nick Dee (1): --- DECLARE EXTERNAL FUNCTION F RETURNS INTEGER BY VALUE ENTRY_POINT 'F' MODULE_NAME 'MyUdf'; commit; --- (2): --- CREATE TABLE T (ID INTEGER NOT NULL); alter table T add constraint PK_T primary key (ID); create or alter trigger TR for T active after insert position 0 as declare H Integer; begin H = F(); end; commit; --- Invalid token. invalid request BLR at offset 18. function F is not defined. module name or entrypoint could not be found (3): --- make full disconnect. copy MyUdf.dll to udf folder, connect and try again (2). --- This operation is not defined for system tables. unsuccessful metadata update. cannot create index PK_T. I see 2 bugs: 1. database is in inconsistent state after rollback on step (2) . 2. checking for existance of udf library on ddl statement is serious restriction (maybe we need to create parameter in dbconfig for it). -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4583) FB 3 embedded tries to load wrong ICU DLLs (from third-party folders)
FB 3 embedded tries to load wrong ICU DLLs (from third-party folders) - Key: CORE-4583 URL: http://tracker.firebirdsql.org/browse/CORE-4583 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Beta 1 Reporter: Nick Dee ICU dlls deployed with fb 3 embeded is: icudt52.dll icuin52.dll icuuc52.dll But, FB tries to load icuuc519.dll icuuc518.dll icuuc517.dll icuuc516.dll icuuc515.dll icuuc514.dll icuuc513.dll icuuc512.dll icuuc511.dll icuuc510.dll icuuc59.dll icuuc58.dll icuuc57.dll icuuc56.dll icuuc55.dll icuuc54.dll icuuc53.dll And it tries to load it from all folders defined in PATH. What was happen if some third-party tool will write to PATH some folder with some of this ICU-dlls? May it be that some of this third-party icu will be somehow incompatibe with my database? For example: 1.user installs tool from SomeCompany, which bundled with custom-builded icuuc519.* (SomeCompany builds they own icu-dlls, as FB does). And this program adds self to PATH (they really need that) 2.user intalls our program "A" with FB embedded 3.user successfully works with our program "A" (using SomeCompany's icuuc519.*, as side-effect (which is not predicted by us, as developers of "A")) 4.user uninstalls tool from SomeCompany 5.user now can't work with our program A, because now FB loads icuuc52.*, and it is incompatible with custom-build icuuc519.dll from SomeCompany. May we be shure, that SomeCompany build their icuuc519.* without errors? :) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://p.sf.net/sfu/Zoho Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4581) FB3 embedded loads udfs from wrong place
FB3 embedded loads udfs from wrong place Key: CORE-4581 URL: http://tracker.firebirdsql.org/browse/CORE-4581 Project: Firebird Core Issue Type: Bug Components: UDF Affects Versions: 3.0 Beta 1 Environment: Windows 7 x64, FB 3.0.0.31378 32-bit embedded with default config Reporter: Nick Dee FB library: D:\Firebird\3.0.0.31378\fbclient.dll, loaded by full path by function "LoadLibraryEx('D:\Firebird\3.0.0.31378\fbclient.dll', 0, LOAD_WITH_ALTERED_SEARCH_PATH)". Exe: D:\Project\Test.exe Got error on work with udf: invalid request BLR at offset 31 function FUNC is not defined module name or entrypoint could not be found Invalid token GDS Code: 335544343, SQL Code: -104, Error Code: 23 Process Monitor from SysInternals shows me that fb tryed to load my library from D:\Project\UDF\, but not from D:\Firebird\3.0.0.31378\UDF\ On 2.5.3 embedded it's ok. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Comprehensive Server Monitoring with Site24x7. Monitor 10 servers for $9/Month. Get alerted through email, SMS, voice calls or mobile push notifications. Take corrective actions from your mobile device. http://p.sf.net/sfu/Zoho Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4525) add field with default value to table with data has not intuitive behavior
add field with default value to table with data has not intuitive behavior -- Key: CORE-4525 URL: http://tracker.firebirdsql.org/browse/CORE-4525 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0 Beta 1 Reporter: Nick Dee create table T (Id integer); insert into T (Id) values (1); insert into T (Id) values (2); alter table T add field F1 integer default 1 not null; select F1 from T -- 1 1 alter table T add field F2 integer default 1; select F2 from T -- null null snapshot 31273 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4455) Allow user to get original names of meta-objects (tables, fields, views, SP(with params), etc)
Allow user to get original names of meta-objects (tables, fields, views, SP(with params), etc) -- Key: CORE-4455 URL: http://tracker.firebirdsql.org/browse/CORE-4455 Project: Firebird Core Issue Type: New Feature Reporter: Nick Dee Priority: Minor Attachments: screen4.gif It will be useful in IDEs. case 1: create table FirebirdFeatures(Id integer not null, ShortDescription varchar(200), LongDescription blob sub_type text); case 2: create table "FirebirdFeatures"("Id" integer not null, "ShortDescription" varchar(200), "LongDescription" blob sub_type text); After it in system tables we have: case 1: RDB$RELATIONS.RDB$RELATION_NAME = 'FIREBIRDFEATURES'; RDB$RELATION_FIELDS.RDB$FIELD_NAME = 'ID'; RDB$RELATION_FIELDS.RDB$FIELD_NAME = 'SHORTDESCRIPTION'; RDB$RELATION_FIELDS.RDB$FIELD_NAME = 'LONGDESCRIPTION'; All in UPPERCASE, and original case is lost forewer. case 2: RDB$RELATIONS.RDB$RELATION_NAME = 'FirebirdFeatures'; RDB$RELATION_FIELDS.RDB$FIELD_NAME = 'Id'; RDB$RELATION_FIELDS.RDB$FIELD_NAME = 'ShortDescription'; RDB$RELATION_FIELDS.RDB$FIELD_NAME = 'LongDescription'; All in original case. It's ok. But now we must add double quotes (" ") in any sql: select "Id", "ShortDescription, "LongDescription" from "FirebirdFeatures"; So. Case 1 is unusable because of original case lost. Case 2 is unusable because of double quotes everywhere in sql code. I suggest to add fields RDB$SRC_*_NAME to all system tables with system object names, and put there names in original case. So we can get it from there and use in query builder (for example) with original word-cases, like in attached picture. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4284) add index statistics on restore output (gbak, svc)
add index statistics on restore output (gbak, svc) -- Key: CORE-4284 URL: http://tracker.firebirdsql.org/browse/CORE-4284 Project: Firebird Core Issue Type: New Feature Components: GBAK Reporter: Nick Dee Priority: Minor like: gbak:activating and creating deferred index IDX_PK (0.003471) gbak:activating and creating deferred index IDX_FOREIGN (0.50) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4279) Invalid error message: "CHARACTER SET OCTETS is not defined" on db creation with isc_dpb_lc_ctype = OCTETS
Invalid error message: "CHARACTER SET OCTETS is not defined" on db creation with isc_dpb_lc_ctype = OCTETS --- Key: CORE-4279 URL: http://tracker.firebirdsql.org/browse/CORE-4279 Project: Firebird Core Issue Type: Bug Components: Charsets/Collation Affects Versions: 3.0 Alpha 1, 3.0 Alpha 2 Reporter: Nick Dee Priority: Trivial 1. OCTETS charset is defined in RDB$CHARACTER_SETS 2. I can specify it in isc_dpb_set_db_charset 3. I can specify it in field definitions So error message "CHARACTER SET OCTETS is not defined" is untrue. It must be replaced to something more appropriate for user. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Shape the Mobile Experience: Free Subscription Software experts and developers: Be at the forefront of tech innovation. Intel(R) Software Adrenaline delivers strategic insight and game-changing conversations that shape the rapidly evolving mobile landscape. Sign up now. http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4277) can create database with invalid character set
can create database with invalid character set -- Key: CORE-4277 URL: http://tracker.firebirdsql.org/browse/CORE-4277 Project: Firebird Core Issue Type: Bug Components: Charsets/Collation Affects Versions: 3.0 Alpha 2 Reporter: Nick Dee Priority: Minor With isc_dpb_set_db_charset = 'WIN2151' database normally created. And i can normally create tables with varchars if define charset for fields. But I can't create varchar field with default charset. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Shape the Mobile Experience: Free Subscription Software experts and developers: Be at the forefront of tech innovation. Intel(R) Software Adrenaline delivers strategic insight and game-changing conversations that shape the rapidly evolving mobile landscape. Sign up now. http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4276) error on create table with "CHARACTER SET DOS775" field
error on create table with "CHARACTER SET DOS775" field --- Key: CORE-4276 URL: http://tracker.firebirdsql.org/browse/CORE-4276 Project: Firebird Core Issue Type: Bug Components: Charsets/Collation Affects Versions: 3.0 Alpha 1, 3.0 Alpha 2 Reporter: Nick Dee CREATE TABLE CHARSETS_TEST( "DOS775" VARCHAR(10) CHARACTER SET DOS775) Commit transaction Error: unsuccessful metadata update CHARSETS_TEST COLLATION DOS775 for CHARACTER SET DOS775 is not installed -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Shape the Mobile Experience: Free Subscription Software experts and developers: Be at the forefront of tech innovation. Intel(R) Software Adrenaline delivers strategic insight and game-changing conversations that shape the rapidly evolving mobile landscape. Sign up now. http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-4275) create database fault if fbclient.dll loaded from another directory (Providers = Engine12)
create database fault if fbclient.dll loaded from another directory (Providers = Engine12) -- Key: CORE-4275 URL: http://tracker.firebirdsql.org/browse/CORE-4275 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0 Alpha 1, 3.0 Alpha 2 Environment: Windows7 x64 Reporter: Nick Dee error: "Could not find acceptable ICU library" steps to reproduce: - unpack snapshot "Firebird-3.0.0.30759-0_Win32 .7z" to folder "D:\App\Firebird\30759\" - in firebird.conf set Providers = Engine12 - run gsec -add SYSDBA -pw masterkey -admin yes from "D:\App\Firebird\30759\" - in project code: a) load fbclient.dll by full path "D:\App\Firebird\30759\fbclient.dll" b) try create database with charset win1251 - put exe to "D:\App\" and run it results: 1. error produced: "Could not find acceptable ICU library" 2. invalid database file was created. But if I copy icu*.dll from "D:\App\Firebird\30759\" to "D:\App\", then all ok. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Shape the Mobile Experience: Free Subscription Software experts and developers: Be at the forefront of tech innovation. Intel(R) Software Adrenaline delivers strategic insight and game-changing conversations that shape the rapidly evolving mobile landscape. Sign up now. http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-3458) Can't alter field after dropping all dependent triggers (all in one transaction)
Can't alter field after dropping all dependent triggers (all in one transaction) Key: CORE-3458 URL: http://tracker.firebirdsql.org/browse/CORE-3458 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.5.1 Reporter: Nick Dee test: CREATE TABLE T (F INTEGER); CREATE TRIGGER T_BI FOR T ACTIVE BEFORE INSERT POSITION 0 AS BEGIN NEW.F = 0; END COMMIT; DROP TRIGGER T_BI; ALTER TABLE T ALTER F TO FF -- exception here COMMIT; Exception text: unsuccessful metadata update Column F from table T is referenced in T_BI This operation is not defined for system tables. Error Code: 31 --- Tested on FB 2.5.1.26266 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel