Index made on unedited column doesn't work
------------------------------------------
Key: CORE-5556
URL: http://tracker.firebirdsql.org/browse/CORE-5556
Project: Firebird Core
Issue Type: Bug
Affects Versions: 2.5.6
Environment: Processor Intel(R) Core(TM) i7-4510U CPU @ 2.00GHz
RAM 8.0 GB
Operating System Microsoft Windows 10 (build 15063), 64-bit
Reporter: Přemysl Šťastný
I had defined this table, which has a few row:
create table ODB_DOC_PRODUKTY_PARAMETRY (
PKID PKID,
PARAMETR PARAMETR,
HODNOTA TEXT5000_UTF,
ZAVISLOST_PARAMETR PARAMETR,
ZAVISLOST_HODNOTA TEXT5000_UTF,
EDITOVATELNOST LOGICAL3,
constraint ODB_DOC_PRODUKTY_PARAMETRY_PKID primary key (PKID))
I executed this script:
set term ^;
create domain DOCSKUPINA varchar(50) default 'ALL' not null^
alter table ODB_DOC_PRODUKTY_PARAMETRY add SKUPINA DOCSKUPINA^
create index ODB_DOC_SKUP_PARAM_PARAM on ODB_DOC_PRODUKTY_PARAMETRY (SKUPINA,
PARAMETR)^
create index ODB_DOC_SKUP_PARAM_ZAVISLOST on ODB_DOC_PRODUKTY_PARAMETRY
(SKUPINA, ZAVISLOST_PARAMETR)^
commit^
set term ;^
Now, when I try to:
select A.SKUPINA
from ODB_DOC_PRODUKTY_PARAMETRY A
where A.SKUPINA = 'ALL';
I get nothing.
When I
insert into ODB_DOC_PRODUKTY_PARAMETRY(PARAMETR) values ('para')
I get only the inserted row.
But when I deactivate indexes or
update ODB_DOC_PRODUKTY_PARAMETRY A
set A.SKUPINA = 'ALL';
I get all the rows.
--
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
