description: 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.

=>

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.

_________________________________________________________________________________________
Better example:
set term ^;
create table TRASH (
PKID int
)^
commit^

insert into TRASH(PKID) values (1)^
insert into TRASH(PKID) values (2)^
insert into TRASH(PKID) values (3)^
insert into TRASH(PKID) values (4)^
insert into TRASH(PKID) values (5)^
commit^

create domain CCSKUPINA varchar(50) default 'ALL' not null^
alter table TRASH add SKUPINA CCSKUPINA^
create index TRASH_PARAM on TRASH (SKUPINA, PKID)^
commit^

select*from TRASH A where A.SKUPINA='ALL'^

set term ;^

description: 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.

_________________________________________________________________________________________
Better example:
set term ^;
create table TRASH (
PKID int
)^
commit^

insert into TRASH(PKID) values (1)^
insert into TRASH(PKID) values (2)^
insert into TRASH(PKID) values (3)^
insert into TRASH(PKID) values (4)^
insert into TRASH(PKID) values (5)^
commit^

create domain CCSKUPINA varchar(50) default 'ALL' not null^
alter table TRASH add SKUPINA CCSKUPINA^
create index TRASH_PARAM on TRASH (SKUPINA, PKID)^
commit^

select*from TRASH A where A.SKUPINA='ALL'^

set term ;^

=>

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.

_________________________________________________________________________________________
Better example:
set term ^;
create table TRASH (
PKID int
)^
commit^

insert into TRASH(PKID) values (1)^
insert into TRASH(PKID) values (2)^
insert into TRASH(PKID) values (3)^
insert into TRASH(PKID) values (4)^
insert into TRASH(PKID) values (5)^
commit^

create domain CCSKUPINA varchar(50) default 'ALL' not null^
alter table TRASH add SKUPINA CCSKUPINA^
create index TRASH_PARAM on TRASH (SKUPINA, PKID)^
commit^

select*from TRASH A where A.SKUPINA='ALL'^

set term ;^

I should get all 5 rows, but I get nothing.