Skip to content

Instantly share code, notes, and snippets.

@tnachen
Created July 29, 2016 23:04
Show Gist options
  • Save tnachen/6bbf222f8a57535dadaf96edacdfc051 to your computer and use it in GitHub Desktop.
Save tnachen/6bbf222f8a57535dadaf96edacdfc051 to your computer and use it in GitHub Desktop.
private void evalExpr16(InternalRow i) {
/* 4539 */ /* CASE WHEN (((todate(todate(cast(input[29, StringType] as date))) < todate(input[22, DateType])) || isnull(input[22, DateType])) && isnull(todate(input[45, DateTy
pe]))) THEN never active WHEN ((CASE WHEN ((((isnotnull(input[3, IntegerType]) || isnull(input[13, DateType])) && (todate(cast(input[29, StringType] as date)) >= input[17, DateTyp
e])) && isnotnull(input[17, DateType])) && (isnull(input[24, DateType]) || (todate(cast(input[29, StringType] as date)) < input[24, DateType]))) THEN true WHEN (((isnotnull(input[
3, IntegerType]) && (todate(cast(input[29, StringType] as date)) >= input[24, DateType])) && isnotnull(input[24, DateType])) && isnotnull(input[20, IntegerType])) THEN CASE WHEN (
(isnull(input[39, DateType]) && isnull(input[43, DateType])) && (todate(cast(input[29, StringType] as date)) >= input[1, DateType])) THEN false WHEN (isnotnull(input[39, DateType]
) && (todate(cast(input[29, StringType] as date)) >= input[39, DateType])) THEN false WHEN ((todate(cast(input[29, StringType] as date)) >= input[7, DateType]) && isnotnull(input[
7, DateType])) THEN false WHEN ((input[10, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && isnotnull(input[25, IntegerType])) && (todate(cast(in
put[29, StringType] as date)) >= input[37, DateType])) THEN false WHEN ((((isnotnull(input[42, DateType]) && (isnotnull(input[39, DateType]) && (todate(cast(input[29, StringType]
as date)) >= input[39, DateType]))) && isnull(input[25, IntegerType])) && isnotnull(input[4, DateType])) && ((NOT input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - O
utbound,Lost - Inbound) && (((todate(cast(input[29, StringType] as date)) < input[11, DateType]) && isnotnull(input[11, DateType])) || isnull(input[11, DateType]))) || (input[0, S
tringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && (todate(cast(input[29, StringType] as date)) < input[37, DateType])))) THEN true ELSE true WHEN (
isnotnull(input[34, DateType]) && (isnull(input[19, DateType]) || (todate(cast(input[29, StringType] as date)) < input[19, DateType]))) THEN CASE WHEN ((input[26, IntegerType] = i
nput[21, IntegerType]) && isnotnull(input[15, IntegerType])) THEN CASE WHEN (input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && (todate(ca
st(input[29, StringType] as date)) >= input[37, DateType])) THEN false WHEN ((todate(cast(input[29, StringType] as date)) >= input[11, DateType]) && isnotnull(input[11, DateType])
) THEN false ELSE true WHEN NOT (input[26, IntegerType] = input[21, IntegerType]) THEN CASE WHEN (((input[34, DateType] < 16071) && (todate(cast(input[29, StringType] as date)) >=
input[11, DateType])) && isnotnull(input[11, DateType])) THEN false WHEN (((input[34, DateType] < 16071) && input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbou
nd,Lost - Inbound)) && (todate(cast(input[29, StringType] as date)) >= input[37, DateType])) THEN false WHEN (((todate(cast(input[29, StringType] as date)) >= input[7, DateType])
&& isnotnull(input[7, DateType])) && (input[33, IntegerType] = input[21, IntegerType])) THEN false WHEN (input[10, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,
Lost - Inbound) && (todate(cast(input[29, StringType] as date)) >= input[35, DateType])) THEN false WHEN (isnull(input[25, IntegerType]) && (todate(cast(input[29, StringType] as d
ate)) >= input[1, DateType])) THEN false ELSE true WHEN isnull(input[4, DateType]) THEN true ELSE false WHEN (((((isnotnull(input[34, DateType]) && isnotnull(input[19, DateType]))
&& (todate(cast(input[29, StringType] as date)) >= input[19, DateType])) && NOT (input[21, IntegerType] = input[26, IntegerType])) && (isnull(input[11, DateType]) || (todate(cast
(input[29, StringType] as date)) < input[11, DateType]))) && NOT input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound)) THEN true WHEN ((isnotnu
ll(input[3, IntegerType]) && (todate(cast(input[29, StringType] as date)) >= input[24, DateType])) && (input[8, BooleanType] = false)) THEN false ELSE false = true) && isnull(inpu
t[45, DateType])) THEN converted WHEN ((CASE WHEN ((((isnotnull(input[3, IntegerType]) || isnull(input[13, DateType])) && (todate(cast(input[29, StringType] as date)) >= input[17,
DateType])) && isnotnull(input[17, DateType])) && (isnull(input[24, DateType]) || (todate(cast(input[29, StringType] as date)) < input[24, DateType]))) THEN true WHEN (((isnotnul
l(input[3, IntegerType]) && (todate(cast(input[29, StringType] as date)) >= input[24, DateType])) && isnotnull(input[24, DateType])) && isnotnull(input[20, IntegerType])) THEN CAS
E WHEN ((isnull(input[39, DateType]) && isnull(input[43, DateType])) && (todate(cast(input[29, StringType] as date)) >= input[1, DateType])) THEN false WHEN (isnotnull(input[39, D
ateType]) && (todate(cast(input[29, StringType] as date)) >= input[39, DateType])) THEN false WHEN ((todate(cast(input[29, StringType] as date)) >= input[7, DateType]) && isnotnul
l(input[7, DateType])) THEN false WHEN ((input[10, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && isnotnull(input[25, IntegerType])) && (todate
(cast(input[29, StringType] as date)) >= input[37, DateType])) THEN false WHEN ((((isnotnull(input[42, DateType]) && (isnotnull(input[39, DateType]) && (todate(cast(input[29, Stri
ngType] as date)) >= input[39, DateType]))) && isnull(input[25, IntegerType])) && isnotnull(input[4, DateType])) && ((NOT input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,
Lost - Outbound,Lost - Inbound) && (((todate(cast(input[29, StringType] as date)) < input[11, DateType]) && isnotnull(input[11, DateType])) || isnull(input[11, DateType]))) || (input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && (todate(cast(input[29, StringType] as date)) < input[37, DateType])))) THEN true ELSE true WHEN (isnotnull(input[34, DateType]) && (isnull(input[19, DateType]) || (todate(cast(input[29, StringType] as date)) < input[19, DateType]))) THEN CASE WHEN ((input[26, IntegerType] = input[21, IntegerType]) && isnotnull(input[15, IntegerType])) THEN CASE WHEN (input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && (todate(cast(input[29, StringType] as date)) >= input[37, DateType])) THEN false WHEN ((todate(cast(input[29, StringType] as date)) >= input[11, DateType]) && isnotnull(input[11, DateType])) THEN false ELSE true WHEN NOT (input[26, IntegerType] = input[21, IntegerType]) THEN CASE WHEN (((input[34, DateType] < 16071) && (todate(cast(input[29, StringType] as date)) >= input[11, DateType])) && isnotnull(input[11, DateType])) THEN false WHEN (((input[34, DateType] < 16071) && input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound)) && (todate(cast(input[29, StringType] as date)) >= input[37, DateType])) THEN false WHEN (((todate(cast(input[29, StringType] as date)) >= input[7, DateType]) && isnotnull(input[7, DateType])) && (input[33, IntegerType] = input[21, IntegerType])) THEN false WHEN (input[10, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && (todate(cast(input[29, StringType] as date)) >= input[35, DateType])) THEN false WHEN (isnull(input[25, IntegerType]) && (todate(cast(input[29, StringType] as date)) >= input[1, DateType])) THEN false ELSE true WHEN isnull(input[4, DateType]) THEN true ELSE false WHEN (((((isnotnull(input[34, DateType]) && isnotnull(input[19, DateType])) && (todate(cast(input[29, StringType] as date)) >= input[19, DateType])) && NOT (input[21, IntegerType] = input[26, IntegerType])) && (isnull(input[11, DateType]) || (todate(cast(input[29, StringType] as date)) < input[11, DateType]))) && NOT input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound)) THEN true WHEN ((isnotnull(input[3, IntegerType]) && (todate(cast(input[29, StringType] as date)) >= input[24, DateType])) && (input[8, BooleanType] = false)) THEN false ELSE false = false) && isnull(input[45, DateType])) THEN all cancelled WHEN (isnotnull(CASE WHEN isnotnull(input[9, IntegerType]) THEN input[9, IntegerType] WHEN ((isnull(input[9, IntegerType]) && isnotnull(input[3, IntegerType])) && ((todate(cast(input[29, StringType] as date)) >= input[17, DateType]) && (((todate(cast(input[29, StringType] as date)) < input[24, DateType]) && isnotnull(input[24, DateType])) || isnull(input[24, DateType])))) THEN input[28, IntegerType]) && isnotnull(input[45, DateType])) THEN autoship WHEN ((datediff(todate(todate(cast(input[29, StringType] as date))),todate(input[45, DateType])) >= 365) && (CASE WHEN ((((isnotnull(input[3, IntegerType]) || isnull(input[13, DateType])) && (todate(cast(input[29, StringType] as date)) >= input[17, DateType])) && isnotnull(input[17, DateType])) && (isnull(input[24, DateType]) || (todate(cast(input[29, StringType] as date)) < input[24, DateType]))) THEN true WHEN (((isnotnull(input[3, IntegerType]) && (todate(cast(input[29, StringType] as date)) >= input[24, DateType])) && isnotnull(input[24, DateType])) && isnotnull(input[20, IntegerType])) THEN CASE WHEN ((isnull(input[39, DateType]) && isnull(input[43, DateType])) && (todate(cast(input[29, StringType] as date)) >= input[1, DateType])) THEN false WHEN (isnotnull(input[39, DateType]) && (todate(cast(input[29, StringType] as date)) >= input[39, DateType])) THEN false WHEN ((todate(cast(input[29, StringType] as date)) >= input[7, DateType]) && isnotnull(input[7, DateType])) THEN false WHEN ((input[10, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && isnotnull(input[25, IntegerType])) && (todate(cast(input[29, StringType] as date)) >= input[37, DateType])) THEN false WHEN ((((isnotnull(input[42, DateType]) && (isnotnull(input[39, DateType]) && (todate(cast(input[29, StringType] as date)) >= input[39, DateType]))) && isnull(input[25, IntegerType])) && isnotnull(input[4, DateType])) && ((NOT input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && (((todate(cast(input[29, StringType] as date)) < input[11, DateType]) && isnotnull(input[11, DateType])) || isnull(input[11, DateType]))) || (input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && (todate(cast(input[29, StringType] as date)) < input[37, DateType])))) THEN true ELSE true WHEN (isnotnull(input[34, DateType]) && (isnull(input[19, DateType]) || (todate(cast(input[29, StringType] as date)) < input[19, DateType]))) THEN CASE WHEN ((input[26, IntegerType] = input[21, IntegerType]) && isnotnull(input[15, IntegerType])) THEN CASE WHEN (input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && (todate(cast(input[29, StringType] as date)) >= input[37, DateType])) THEN false WHEN ((todate(cast(input[29, StringType] as date)) >= input[11, DateType]) && isnotnull(input[11, DateType])) THEN false ELSE true WHEN NOT (input[26, IntegerType] = input[21, IntegerType]) THEN CASE WHEN (((input[34, DateType] < 16071) && (todate(cast(input[29, StringType] as date)) >= input[11, DateType])) && isnotnull(input[11, DateType])) THEN false WHEN (((input[34, DateType] < 16071) && input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound)) && (todate(cast(input[29, StringType] as date)) >= input[37, DateType])) THEN false WHEN (((todate(cast(input[29, StringType] as date)) >= input[7, DateType]) && isnotnull(input[7, DateType])) && (input[33, IntegerType] = input[21, IntegerType])) THEN false WHEN (input[10, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && (todate(cast(input[29, StringType] as date)) >= input[35, DateType])) THEN false WHEN (isnull(input[25, IntegerType]) && (todate(cast(input[29, StringType] as date)) >= input[1, DateType])) THEN false ELSE true WHEN isnull(input[4, DateType]) THEN true ELSE false WHEN (((((isnotnull(input[34, DateType]) && isnotnull(input[19, DateType])) && (todate(cast(input[29, StringType] as date)) >= input[19, DateType])) && NOT (input[21, IntegerType] = input[26, IntegerType])) && (isnull(input[11, DateType]) || (todate(cast(input[29, StringType] as date)) < input[11, DateType]))) && NOT input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound)) THEN true WHEN ((isnotnull(input[3, IntegerType]) && (todate(cast(input[29, StringType] as date)) >= input[24, DateType])) && (input[8, BooleanType] = false)) THEN false ELSE false = false)) THEN dormant WHEN (((CASE WHEN ((((isnotnull(input[3, IntegerType]) || isnull(input[13, DateType])) && (todate(cast(input[29, StringType] as date)) >= input[17, DateType])) && isnotnull(input[17, DateType])) && (isnull(input[24, DateType]) || (todate(cast(input[29, StringType] as date)) < input[24, DateType]))) THEN true WHEN (((isnotnull(input[3, IntegerType]) && (todate(cast(input[29, StringType] as date)) >= input[24, DateType])) && isnotnull(input[24, DateType])) && isnotnull(input[20, IntegerType])) THEN CASE WHEN ((isnull(input[39, DateType]) && isnull(input[43, DateType])) && (todate(cast(input[29, StringType] as date)) >= input[1, DateType])) THEN false WHEN (isnotnull(input[39, DateType]) && (todate(cast(input[29, StringType] as date)) >= input[39, DateType])) THEN false WHEN ((todate(cast(input[29, StringType] as date)) >= input[7, DateType]) && isnotnull(input[7, DateType])) THEN false WHEN ((input[10, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && isnotnull(input[25, IntegerType])) && (todate(cast(input[29, StringType] as date)) >= input[37, DateType])) THEN false WHEN ((((isnotnull(input[42, DateType]) && (isnotnull(input[39, DateType]) && (todate(cast(input[29, StringType] as date)) >= input[39, DateType]))) && isnull(input[25, IntegerType])) && isnotnull(input[4, DateType])) && ((NOT input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && (((todate(cast(input[29, StringType] as date)) < input[11, DateType]) && isnotnull(input[11, DateType])) || isnull(input[11, DateType]))) || (input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && (todate(cast(input[29, StringType] as date)) < input[37, DateType])))) THEN true ELSE true WHEN (isnotnull(input[34, DateType]) && (isnull(input[19, DateType]) || (todate(cast(input[29, StringType] as date)) < input[19, DateType]))) THEN CASE WHEN ((input[26, IntegerType] = input[21, IntegerType]) && isnotnull(input[15, IntegerType])) THEN CASE WHEN (input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && (todate(cast(input[29, StringType] as date)) >= input[37, DateType])) THEN false WHEN ((todate(cast(input[29, StringType] as date)) >= input[11, DateType]) && isnotnull(input[11, DateType])) THEN false ELSE true WHEN NOT (input[26, IntegerType] = input[21, IntegerType]) THEN CASE WHEN (((input[34, DateType] < 16071) && (todate(cast(input[29, StringType] as date)) >= input[11, DateType])) && isnotnull(input[11, DateType])) THEN false WHEN (((input[34, DateType] < 16071) && input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound)) && (todate(cast(input[29, StringType] as date)) >= input[37, DateType])) THEN false WHEN (((todate(cast(input[29, StringType] as date)) >= input[7, DateType]) && isnotnull(input[7, DateType])) && (input[33, IntegerType] = input[21, IntegerType])) THEN false WHEN (input[10, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && (todate(cast(input[29, StringType] as date)) >= input[35, DateType])) THEN false WHEN (isnull(input[25, IntegerType]) && (todate(cast(input[29, StringType] as date)) >= input[1, DateType])) THEN false ELSE true WHEN isnull(input[4, DateType]) THEN true ELSE false WHEN (((((isnotnull(input[34, DateType]) && isnotnull(input[19, DateType])) && (todate(cast(input[29, StringType] as date)) >= input[19, DateType])) && NOT (input[21, IntegerType] = input[26, IntegerType])) && (isnull(input[11, DateType]) || (todate(cast(input[29, StringType] as date)) < input[11, DateType]))) && NOT input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound)) THEN true WHEN ((isnotnull(input[3, IntegerType]) && (todate(cast(input[29, StringType] as date)) >= input[24, DateType])) && (input[8, BooleanType] = false)) THEN false ELSE false = true) && isnotnull(input[45, DateType])) || ((datediff(todate(todate(cast(input[29, StringType] as date))),todate(input[45, DateType])) < 120) && (isnull(todate(input[24, DateType])) || (todate(input[24, DateType]) < todate(input[45, DateType]))))) THEN manual WHEN ((CASE WHEN ((((isnotnull(input[3, IntegerType]) || isnull(input[13, DateType])) && (todate(cast(input[29, StringType] as date)) >= input[17, DateType])) && isnotnull(input[17, DateType])) && (isnull(input[24, DateType]) || (todate(cast(input[29, StringType] as date)) < input[24, DateType]))) THEN true WHEN (((isnotnull(input[3, IntegerType]) && (todate(cast(input[29, StringType] as date)) >= input[24, DateType])) && isnotnull(input[24, DateType])) && isnotnull(input[20, IntegerType])) THEN CASE WHEN ((isnull(input[39, DateType]) && isnull(input[43, DateType])) && (todate(cast(input[29, StringType] as date)) >= input[1, DateType])) THEN false WHEN (isnotnull(input[39, DateType]) && (todate(cast(input[29, StringType] as date)) >= input[39, DateType])) THEN false WHEN ((todate(cast(input[29, StringType] as date)) >= input[7, DateType]) && isnotnull(input[7, DateType])) THEN false WHEN ((input[10, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && isnotnull(input[25, IntegerType])) && (todate(cast(input[29, StringType] as date)) >= input[37, DateType])) THEN false WHEN ((((isnotnull(input[42, DateType]) && (isnotnull(input[39, DateType]) && (todate(cast(input[29, StringType] as date)) >= input[39, DateType]))) && isnull(input[25, IntegerType])) && isnotnull(input[4, DateType])) && ((NOT input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && (((todate(cast(input[29, StringType] as date)) < input[11, DateType]) && isnotnull(input[11, DateType])) || isnull(input[11, DateType]))) || (input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && (todate(cast(input[29, StringType] as date)) < input[37, DateType])))) THEN true ELSE true WHEN (isnotnull(input[34, DateType]) && (isnull(input[19, DateType]) || (todate(cast(input[29, StringType] as date)) < input[19, DateType]))) THEN CASE WHEN ((input[26, IntegerType] = input[21, IntegerType]) && isnotnull(input[15, IntegerType])) THEN CASE WHEN (input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && (todate(cast(input[29, StringType] as date)) >= input[37, DateType])) THEN false WHEN ((todate(cast(input[29, StringType] as date)) >= i nput[11, DateType]) && isnotnull(input[11, DateType])) THEN false ELSE true WHEN NOT (input[26, IntegerType] = input[21, IntegerType]) THEN CASE WHEN (((input[34, DateType] < 16071) && (todate(cast(input[29, StringType] as date)) >= input[11, DateType])) && isnotnull(input[11, DateType])) THEN false WHEN (((input[34, DateType] < 16071) && input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound)) && (todate(cast(input[29, StringType] as date)) >= input[37, DateType])) THEN false WHEN (((todate(cast(input[29, StringType] as date)) >= input[7, DateType]) && isnotnull(input[7, DateType])) && (input[33, IntegerType] = input[21, IntegerType])) THEN false WHEN (input[10, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound) && (todate(cast(input[29, StringType] as date)) >= input[35, DateType])) THEN false WHEN (isnull(input[25, IntegerType]) && (todate(cast(input[29, StringType] as date)) >= input[1, DateType])) THEN false ELSE true WHEN isnull(input[4, DateType]) THEN true ELSE false WHEN (((((isnotnull(input[34, DateType]) && isnotnull(input[19, DateType])) && (todate(cast(input[29, StringType] as date)) >= input[19, DateType])) && NOT (input[21, IntegerType] = input[26, IntegerType])) && (isnull(input[11, DateType]) || (todate(cast(input[29, StringType] as date)) < input[11, DateType]))) && NOT input[0, StringType] IN (Cancelled,Truant,Fraud / Stolen,Lost - Outbound,Lost - Inbound)) THEN true WHEN ((isnotnull(input[3, IntegerType]) && (todate(cast(input[29, StringType] as date)) >= input[24, DateType])) && (input[8, BooleanType] = false)) THEN false ELSE false = false) && ((datediff(todate(todate(cast(input[29, StringType] as date))),todate(input[45, DateType])) >= 120) || (todate(input[24, DateType]) >= todate(input[45, DateType])))) THEN lapsed ELSE mysteryry
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment