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
like doesn't work for computed values (at least in a view) [CORE1033] #1450
Comments
Commented by: @asfernandes Confirmed in V2. |
Modified by: @asfernandesFix Version: 2.0.1 [ 10090 ] assignee: Adriano dos Santos Fernandes [ asfernandes ] |
Commented by: @dyemanov Does v1.5 also have this bug? Looking at the patch, I'd say it should. |
Commented by: @asfernandes Seems to not. |
Commented by: @pcisar Fix confirmed for 2.0.1. Test added. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pcisarWorkflow: jira [ 11367 ] => Firebird [ 15141 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovQA Status: No test => Done successfully |
Submitted by: Rudolf Bartel (rudi.bartel)
Is related to QA131
There is a view and a table defined as
create table TABLE_X (
id numeric(10,0) not null,
desc varchar(50) not null
);
create view X_VW (id, description)
select
id
x.desc||' ('||x.id||')'
from TABLE_X as x;
The select: select * from X_VW where description like 'xyz'
does work (its finding entries if there is a string in the column desc), but doesn't find any entries if the '%' sign is used inside of criteria string:
select * from X_VW where description like 'xy%' -> no match
Commits: d24d14f
The text was updated successfully, but these errors were encountered: