[jira] [Updated] (ASTERIXDB-2218) Enforcement of a secondary index does not work.
[ https://issues.apache.org/jira/browse/ASTERIXDB-2218?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Till updated ASTERIXDB-2218: Affects Version/s: 0.9.4 > Enforcement of a secondary index does not work. > --- > > Key: ASTERIXDB-2218 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-2218 > Project: Apache AsterixDB > Issue Type: Bug > Components: COMP - Compiler, IDX - Indexes >Affects Versions: 0.9.4 >Reporter: Taewoo Kim >Assignee: Dmitry Lychagin >Priority: Major > Labels: triaged > > The enforced index does not check the field type when inserting a record. The > following code work on the current master. > {code} > create type tempType if not exists as open { > id: int64 > }; > create dataset tempDataset(tempType) primary key id; > create index tempIndex on tempDataset(val:int64?) enforced; > insert into tempDataset({"id":1,"val":64.79}); > {code} > For a closed-type field, it works as well. > {code} > create type tempClosedType if not exists as closed { > id: int64, > val: int64 > }; > create dataset tempClosedDataset(tempClosedType) primary key id; > create index tempClosedIndex on tempClosedDataset(val); > insert into tempClosedDataset({"id":1,"val":64.79}); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (ASTERIXDB-2218) Enforcement of a secondary index does not work.
[ https://issues.apache.org/jira/browse/ASTERIXDB-2218?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Till updated ASTERIXDB-2218: Fix Version/s: 0.9.4.2 > Enforcement of a secondary index does not work. > --- > > Key: ASTERIXDB-2218 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-2218 > Project: Apache AsterixDB > Issue Type: Bug > Components: COMP - Compiler, IDX - Indexes >Affects Versions: 0.9.4 >Reporter: Taewoo Kim >Assignee: Dmitry Lychagin >Priority: Major > Labels: triaged > Fix For: 0.9.4.2 > > > The enforced index does not check the field type when inserting a record. The > following code work on the current master. > {code} > create type tempType if not exists as open { > id: int64 > }; > create dataset tempDataset(tempType) primary key id; > create index tempIndex on tempDataset(val:int64?) enforced; > insert into tempDataset({"id":1,"val":64.79}); > {code} > For a closed-type field, it works as well. > {code} > create type tempClosedType if not exists as closed { > id: int64, > val: int64 > }; > create dataset tempClosedDataset(tempClosedType) primary key id; > create index tempClosedIndex on tempClosedDataset(val); > insert into tempClosedDataset({"id":1,"val":64.79}); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (ASTERIXDB-2218) Enforcement of a secondary index does not work.
[ https://issues.apache.org/jira/browse/ASTERIXDB-2218?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Till updated ASTERIXDB-2218: Component/s: IDX - Indexes COMP - Compiler > Enforcement of a secondary index does not work. > --- > > Key: ASTERIXDB-2218 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-2218 > Project: Apache AsterixDB > Issue Type: Bug > Components: COMP - Compiler, IDX - Indexes >Reporter: Taewoo Kim >Priority: Major > Labels: triaged > > The enforced index does not check the field type when inserting a record. The > following code work on the current master. > {code} > create type tempType if not exists as open { > id: int64 > }; > create dataset tempDataset(tempType) primary key id; > create index tempIndex on tempDataset(val:int64?) enforced; > insert into tempDataset({"id":1,"val":64.79}); > {code} > For a closed-type field, it works as well. > {code} > create type tempClosedType if not exists as closed { > id: int64, > val: int64 > }; > create dataset tempClosedDataset(tempClosedType) primary key id; > create index tempClosedIndex on tempClosedDataset(val); > insert into tempClosedDataset({"id":1,"val":64.79}); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (ASTERIXDB-2218) Enforcement of a secondary index does not work.
[ https://issues.apache.org/jira/browse/ASTERIXDB-2218?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Till updated ASTERIXDB-2218: Labels: triaged (was: ) > Enforcement of a secondary index does not work. > --- > > Key: ASTERIXDB-2218 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-2218 > Project: Apache AsterixDB > Issue Type: Bug > Components: COMP - Compiler, IDX - Indexes >Reporter: Taewoo Kim >Priority: Major > Labels: triaged > > The enforced index does not check the field type when inserting a record. The > following code work on the current master. > {code} > create type tempType if not exists as open { > id: int64 > }; > create dataset tempDataset(tempType) primary key id; > create index tempIndex on tempDataset(val:int64?) enforced; > insert into tempDataset({"id":1,"val":64.79}); > {code} > For a closed-type field, it works as well. > {code} > create type tempClosedType if not exists as closed { > id: int64, > val: int64 > }; > create dataset tempClosedDataset(tempClosedType) primary key id; > create index tempClosedIndex on tempClosedDataset(val); > insert into tempClosedDataset({"id":1,"val":64.79}); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (ASTERIXDB-2218) Enforcement of a secondary index does not work.
[ https://issues.apache.org/jira/browse/ASTERIXDB-2218?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Taewoo Kim updated ASTERIXDB-2218: -- Description: The enforced index does not check the field type when inserting a record. The following code work on the current master. {code} create type tempType if not exists as open { id: int64 }; create dataset tempDataset(tempType) primary key id; create index tempIndex on tempDataset(val:int64?) enforced; insert into tempDataset({"id":1,"val":64.79}); {code} For a closed-type field, it works as well. {code} create type tempClosedType if not exists as closed { id: int64, val: int64 }; create dataset tempClosedDataset(tempClosedType) primary key id; create index tempClosedIndex on tempClosedDataset(val); insert into tempClosedDataset({"id":1,"val":64.79}); {code} was: The enforced index does not check the field type when inserting a record. The following code work on the current master. {code} create type tempType if not exists as open { id: int64 }; create dataset tempDataset(tempType) primary key id; create index tempIndex on tempDataset(val:int64?) enforced; insert into tempDataset({"id":1,"val":64.79}); {code} > Enforcement of a secondary index does not work. > --- > > Key: ASTERIXDB-2218 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-2218 > Project: Apache AsterixDB > Issue Type: Bug >Reporter: Taewoo Kim > > The enforced index does not check the field type when inserting a record. The > following code work on the current master. > {code} > create type tempType if not exists as open { > id: int64 > }; > create dataset tempDataset(tempType) primary key id; > create index tempIndex on tempDataset(val:int64?) enforced; > insert into tempDataset({"id":1,"val":64.79}); > {code} > For a closed-type field, it works as well. > {code} > create type tempClosedType if not exists as closed { > id: int64, > val: int64 > }; > create dataset tempClosedDataset(tempClosedType) primary key id; > create index tempClosedIndex on tempClosedDataset(val); > insert into tempClosedDataset({"id":1,"val":64.79}); > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)