trafodion icon indicating copy to clipboard operation
trafodion copied to clipboard
verified publisher icon apache

[TRAFODION-2791] 'Not casespecific' column comparison returns wrong

Open duoluodexiaokeke opened this issue 8 years ago • 20 comments

'Not casespecific' column comparison returns wrongresult, now like and t.c1=t.c2 not support

duoluodexiaokeke avatar Nov 21 '17 11:11 duoluodexiaokeke

Can one of the admins verify this patch?

Traf-Jenkins avatar Nov 21 '17 11:11 Traf-Jenkins

Can one of the admins verify this patch?

Traf-Jenkins avatar Nov 21 '17 11:11 Traf-Jenkins

Can one of the admins verify this patch?

Traf-Jenkins avatar Nov 21 '17 11:11 Traf-Jenkins

Can one of the admins verify this patch?

Traf-Jenkins avatar Nov 21 '17 11:11 Traf-Jenkins

jenkins, ok to test

svarnau avatar Nov 21 '17 17:11 svarnau

Check Test Started: https://jenkins.esgyn.com/job/Check-PR-master/2193/

Traf-Jenkins avatar Nov 21 '17 17:11 Traf-Jenkins

Test Failed. https://jenkins.esgyn.com/job/Check-PR-master/2193/

Traf-Jenkins avatar Nov 21 '17 20:11 Traf-Jenkins

-1 You may need to study RangeSpecs a bit more before solving this problem.

zellerh avatar Nov 28 '17 17:11 zellerh

Hi again, here is a suggestion: Change method OptRangeSpec::buildRange() and add a check whether a comparison operation (ITM_EQUAL, ITM_LESS, etc.) involves a case-inspecific comparison. If so, then set the local variable isRange to FALSE. This should avoid getting into this problem, as there will be no more RangeSpecs for case-inspecific comparisons.

zellerh avatar Dec 01 '17 02:12 zellerh

Can one of the admins verify this patch?

Traf-Jenkins avatar Dec 28 '17 23:12 Traf-Jenkins

Can one of the admins verify this patch?

Traf-Jenkins avatar Dec 28 '17 23:12 Traf-Jenkins

Can one of the admins verify this patch?

Traf-Jenkins avatar Dec 28 '17 23:12 Traf-Jenkins

Check Test Started: https://jenkins.esgyn.com/job/Check-PR-master/2289/

Traf-Jenkins avatar Dec 28 '17 23:12 Traf-Jenkins

Can one of the admins verify this patch?

Traf-Jenkins avatar Dec 28 '17 23:12 Traf-Jenkins

Test Failed. https://jenkins.esgyn.com/job/Check-PR-master/2289/

Traf-Jenkins avatar Dec 29 '17 20:12 Traf-Jenkins

core/TEST032 and core/TEST038 are failing with compiler assertion errors. Those need to be fixed before we can merge this change.

DaveBirdsall avatar Jan 04 '18 20:01 DaveBirdsall

Check Test Started: https://jenkins.esgyn.com/job/Check-PR-master/2890/

Traf-Jenkins avatar Jul 27 '18 16:07 Traf-Jenkins

Test Failed. https://jenkins.esgyn.com/job/Check-PR-master/2890/

Traf-Jenkins avatar Jul 27 '18 16:07 Traf-Jenkins

Can one of the admins verify this patch?

Traf-Jenkins avatar Aug 01 '18 20:08 Traf-Jenkins

Can one of the admins verify this patch?

Traf-Jenkins avatar Aug 01 '18 20:08 Traf-Jenkins