BiteTheDDDDt opened a new pull request, #55576:
URL: https://github.com/apache/doris/pull/55576
### What problem does this PR solve?
```sql
select count(isnull(x)) from (select case i1
when -128 then -128
when -127 then -127
when -126 then -126
when -125 then -125
when -124 then -124
when -123 then -123
when -122 then -122
when -121 then -121
when -120 then -120
when -119 then -119
when -118 then -118
when -117 then -117
when -116 then -116
when -115 then -115
when -114 then -114
when -113 then -113
when -112 then -112
when -111 then -111
when -110 then -110
when -109 then -109
when -108 then -108
when -107 then -107
when -106 then -106
when -105 then -105
when -104 then -104
when -103 then -103
when -102 then -102
when -101 then -101
when -100 then -100
when -99 then -99
when -98 then -98
when -97 then -97
when -96 then -96
when -95 then -95
when -94 then -94
when -93 then -93
when -92 then -92
when -91 then -91
when -90 then -90
when -89 then -89
when -88 then -88
when -87 then -87
when -86 then -86
when -85 then -85
when -84 then -84
when -83 then -83
when -82 then -82
when -81 then -81
when -80 then -80
when -79 then -79
when -78 then -78
when -77 then -77
when -76 then -76
when -75 then -75
when -74 then -74
when -73 then -73
when -72 then -72
when -71 then -71
when -70 then -70
when -69 then -69
when -68 then -68
when -67 then -67
when -66 then -66
when -65 then -65
when -64 then -64
when -63 then -63
when -62 then -62
when -61 then -61
when -60 then -60
when -59 then -59
when -58 then -58
when -57 then -57
when -56 then -56
when -55 then -55
when -54 then -54
when -53 then -53
when -52 then -52
when -51 then -51
when -50 then -50
when -49 then -49
when -48 then -48
when -47 then -47
when -46 then -46
when -45 then -45
when -44 then -44
when -43 then -43
when -42 then -42
when -41 then -41
when -40 then -40
when -39 then -39
when -38 then -38
when -37 then -37
when -36 then -36
when -35 then -35
when -34 then -34
when -33 then -33
when -32 then -32
when -31 then -31
when -30 then -30
when -29 then -29
when -28 then -28
when -27 then -27
when -26 then -26
when -25 then -25
when -24 then -24
when -23 then -23
when -22 then -22
when -21 then -21
when -20 then -20
when -19 then -19
when -18 then -18
when -17 then -17
when -16 then -16
when -15 then -15
when -14 then -14
when -13 then -13
when -12 then -12
when -11 then -11
when -10 then -10
when -9 then -9
when -8 then -8
when -7 then -7
when -6 then -6
when -5 then -5
when -4 then -4
when -3 then -3
when -2 then -2
when -1 then -1
when 0 then 0
when 1 then 1
when 2 then 2
when 3 then 3
when 4 then 4
when 5 then 5
when 6 then 6
when 7 then 7
when 8 then 8
when 9 then 9
when 10 then 10
when 11 then 11
when 12 then 12
when 13 then 13
when 14 then 14
when 15 then 15
when 16 then 16
when 17 then 17
when 18 then 18
when 19 then 19
when 20 then 20
when 21 then 21
when 22 then 22
when 23 then 23
when 24 then 24
when 25 then 25
when 26 then 26
when 27 then 27
when 28 then 28
when 29 then 29
when 30 then 30
when 31 then 31
when 32 then 32
when 33 then 33
when 34 then 34
when 35 then 35
when 36 then 36
when 37 then 37
when 38 then 38
when 39 then 39
when 40 then 40
when 41 then 41
when 42 then 42
when 43 then 43
when 44 then 44
when 45 then 45
when 46 then 46
when 47 then 47
when 48 then 48
when 49 then 49
when 50 then 50
when 51 then 51
when 52 then 52
when 53 then 53
when 54 then 54
when 55 then 55
when 56 then 56
when 57 then 57
when 58 then 58
when 59 then 59
when 60 then 60
when 61 then 61
when 62 then 62
when 63 then 63
when 64 then 64
when 65 then 65
when 66 then 66
when 67 then 67
when 68 then 68
when 69 then 69
when 70 then 70
when 71 then 71
when 72 then 72
when 73 then 73
when 74 then 74
when 75 then 75
when 76 then 76
when 77 then 77
when 78 then 78
when 79 then 79
when 80 then 80
when 81 then 81
when 82 then 82
when 83 then 83
when 84 then 84
when 85 then 85
when 86 then 86
when 87 then 87
when 88 then 88
when 89 then 89
when 90 then 90
when 91 then 91
when 92 then 92
when 93 then 93
when 94 then 94
when 95 then 95
when 96 then 96
when 97 then 97
when 98 then 98
when 99 then 99
when 100 then 100
when 101 then 101
when 102 then 102
when 103 then 103
when 104 then 104
when 105 then 105
when 106 then 106
when 107 then 107
when 108 then 108
when 109 then 109
when 110 then 110
when 111 then 111
when 112 then 112
when 113 then 113
when 114 then 114
when 115 then 115
when 116 then 116
when 117 then 117
when 118 then 118
when 119 then 119
when 120 then 120
when 121 then 121
when 122 then 122
when 123 then 123
when 124 then 124
when 125 then 125
when 126 then 126
when 127 then 127
else null
end as x
from half_null)t;
```
12.14 sec -> 10.94 sec
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason <!-- Add your reason? -->
- Behavior changed:
- [ ] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] No.
- [ ] Yes. <!-- Add document PR link here. eg:
https://github.com/apache/doris-website/pull/1214 -->
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR should
merge into -->
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
