[FB-Tracker] Created: (CORE-5556) Index made on unedited column doesn't work

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[FB-Tracker] Created: (CORE-5556) Index made on unedited column doesn't work

JIRA tracker@firebirdsql.org
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