[Firebird-devel] [FB-Tracker] Created: (CORE-5778) install.sh fails if -path argument contains "firebird"
install.sh fails if -path argument contains "firebird" -- Key: CORE-5778 URL: http://tracker.firebirdsql.org/browse/CORE-5778 Project: Firebird Core Issue Type: Bug Components: Installation Affects Versions: 3.0.3 Environment: Slackware, v14.2, x86-64 Reporter: Marius Dinu Priority: Minor If install.sh is run with a -path argument that contains "firebird", it fails with error saying that Firebird server is running. Example: root@test0:/build/Firebird-3.0.3.32900-0.amd64# ./install.sh -path /mnt/sdb/firebird Firebird 3.0.3.32900-0.amd64 Installation Press Enter to start installation or ^C to abort An instance of the Firebird server seems to be running. Please quit all Firebird applications and then proceed. root@test0:/build/Firebird-3.0.3.32900-0.amd64# -- 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 -- 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
[Firebird-devel] ALTER COLUMN and index rebuild
Looking at bug CORE-5774 i found very odd behavior of engine: it seems it rebuilds indices in many unneeded cases, when almost any property of the indexed field is changed. I understand that index should be rebuild in this cases only: - field data type is changed *and* its "index" type changed too - default value is set at nullable field *and* there was no default value before - "computed by" expression is changed and indices should not be rebuild when: - field data type is changed but its "index" type is still the same - default value is changed (not added) - default value is added or changed at non-nullable field - default value is dropped - field's identity value is restarted - field name is changed - field position is changed Am i missing something ? Am i wrong ? Thanks, Vlad -- 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
[Firebird-devel] [FB-Tracker] Reopened: (CORE-405) Garbage vs indices/constraints
[ http://tracker.firebirdsql.org/browse/CORE-405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vlad Khorsun reopened CORE-405: --- Assignee: Vlad Khorsun > Garbage vs indices/constraints > -- > > Key: CORE-405 > URL: http://tracker.firebirdsql.org/browse/CORE-405 > Project: Firebird Core > Issue Type: Bug > Components: Engine >Reporter: Dmitry Yemanov >Assignee: Vlad Khorsun > > SFID: 744175# > Submitted By: dimitr > If an index contains garbage and automatic GC > is disabled, then it's impossible to create unique > indices or PK/UK/FK constraints. > For example: > 1) attach with isc_dpb_no_garbage_collect > 2) insert some duplicate data > INSERT INTO T1 (F1) VALUES (1); > INSERT INTO T1 (F1) VALUES (1); > 3) delete these rows > DELETE FROM T1; > 4) create unique index > CREATE UNIQUE INDEX IDX1 ON T1 (F1); > You'll see "attempt to store duplicate value ..." > error message, which is incorrect in this case. > Since indices work outside transaction control, it > may be a initial design/implementation pitfall. It > appears the index creation and partner lookup > code never touches records and hence is unable > to determine which versions are actual at the > moment of index creation. -- 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 -- 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