Navigation Menu

Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

AV when blob is used in expression index [CORE952] #1353

Closed
firebird-automations opened this issue Oct 16, 2006 · 8 comments
Closed

AV when blob is used in expression index [CORE952] #1353

firebird-automations opened this issue Oct 16, 2006 · 8 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @hvlad

Relate to CORE1006

create table T (
ID integer not null,
N1 blob sub_type 1 segment size 80,
N2 varchar(10)
);
commit;

insert into T (ID, N1, N2) values (1, 'www', 'qwer');
commit;

alter table T add constraint PK_T primary key (ID);
create index T_IDX on T computed by (cast(substring(N1 from 1 for 100) as varchar(100)));
commit;

update T set T.N2 = 'asdf' where http://T.ID = 1;
commit; -- AV here

Commits: f4f2861 2541b58 bd1ea8b c747acb FirebirdSQL/fbt-repository@7b5a11b FirebirdSQL/fbt-repository@036eea6

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.1 [ 10041 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 2.0.1 [ 10090 ]

Version: 2.1 [ 10041 ] =>

Fix Version: 2.1 [ 10041 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Link: This issue relate to CORE1006 [ CORE1006 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pmakowski

Q/A tested and test made

@firebird-automations
Copy link
Collaborator Author

Modified by: @pmakowski

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 11252 ] => Firebird [ 15074 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test => Done successfully

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants