int8::[
  envs::{
    int8_tbl:[
      {
        q1:123,
        q2:456
      },
      {
        q1:123,
        q2:4567890123456789
      },
      {
        q1:4567890123456789,
        q2:123
      },
      {
        q1:4567890123456789,
        q2:4567890123456789
      },
      {
        q1:4567890123456789,
        q2:-4567890123456789
      }
    ]
  },
  {
    name:"PG_INT8_01",
    statement:"SELECT * FROM int8_tbl WHERE q2 = 4567890123456789",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          q1:123,
          q2:4567890123456789
        },
        {
          q1:4567890123456789,
          q2:4567890123456789
        }
      ]
    }
  },
  {
    name:"PG_INT8_02",
    statement:"SELECT * FROM int8_tbl WHERE q2 <> 4567890123456789",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          q1:123,
          q2:456
        },
        {
          q1:4567890123456789,
          q2:123
        },
        {
          q1:4567890123456789,
          q2:-4567890123456789
        }
      ]
    }
  },
  {
    name:"PG_INT8_03",
    statement:"SELECT * FROM int8_tbl WHERE q2 < 4567890123456789",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          q1:123,
          q2:456
        },
        {
          q1:4567890123456789,
          q2:123
        },
        {
          q1:4567890123456789,
          q2:-4567890123456789
        }
      ]
    }
  },
  {
    name:"PG_INT8_04",
    statement:"SELECT * FROM int8_tbl WHERE q2 > 4567890123456789",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
      ]
    }
  },
  {
    name:"PG_INT8_05",
    statement:"SELECT * FROM int8_tbl WHERE q2 <= 4567890123456789",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          q1:123,
          q2:456
        },
        {
          q1:123,
          q2:4567890123456789
        },
        {
          q1:4567890123456789,
          q2:123
        },
        {
          q1:4567890123456789,
          q2:4567890123456789
        },
        {
          q1:4567890123456789,
          q2:-4567890123456789
        }
      ]
    }
  },
  {
    name:"PG_INT8_06",
    statement:"SELECT * FROM int8_tbl WHERE q2 >= 4567890123456789",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          q1:123,
          q2:4567890123456789
        },
        {
          q1:4567890123456789,
          q2:4567890123456789
        }
      ]
    }
  },
  {
    name:"PG_INT8_07",
    statement:"SELECT * FROM int8_tbl WHERE q2 = 456",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          q1:123,
          q2:456
        }
      ]
    }
  },
  {
    name:"PG_INT8_08",
    statement:"SELECT * FROM int8_tbl WHERE q2 <> 456",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          q1:123,
          q2:4567890123456789
        },
        {
          q1:4567890123456789,
          q2:123
        },
        {
          q1:4567890123456789,
          q2:4567890123456789
        },
        {
          q1:4567890123456789,
          q2:-4567890123456789
        }
      ]
    }
  },
  {
    name:"PG_INT8_09",
    statement:"SELECT * FROM int8_tbl WHERE q2 < 456",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          q1:4567890123456789,
          q2:123
        },
        {
          q1:4567890123456789,
          q2:-4567890123456789
        }
      ]
    }
  },
  {
    name:"PG_INT8_10",
    statement:"SELECT * FROM int8_tbl WHERE q2 > 456",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          q1:123,
          q2:4567890123456789
        },
        {
          q1:4567890123456789,
          q2:4567890123456789
        }
      ]
    }
  },
  {
    name:"PG_INT8_11",
    statement:"SELECT * FROM int8_tbl WHERE q2 <= 456",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          q1:123,
          q2:456
        },
        {
          q1:4567890123456789,
          q2:123
        },
        {
          q1:4567890123456789,
          q2:-4567890123456789
        }
      ]
    }
  },
  {
    name:"PG_INT8_12",
    statement:"SELECT * FROM int8_tbl WHERE q2 >= 456",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          q1:123,
          q2:456
        },
        {
          q1:123,
          q2:4567890123456789
        },
        {
          q1:4567890123456789,
          q2:4567890123456789
        }
      ]
    }
  },
  {
    name:"PG_INT8_13",
    statement:"SELECT * FROM int8_tbl WHERE 123 = q1",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          q1:123,
          q2:456
        },
        {
          q1:123,
          q2:4567890123456789
        }
      ]
    }
  },
  {
    name:"PG_INT8_14",
    statement:"SELECT * FROM int8_tbl WHERE 123 <> q1",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          q1:4567890123456789,
          q2:123
        },
        {
          q1:4567890123456789,
          q2:4567890123456789
        },
        {
          q1:4567890123456789,
          q2:-4567890123456789
        }
      ]
    }
  },
  {
    name:"PG_INT8_15",
    statement:"SELECT * FROM int8_tbl WHERE 123 < q1",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          q1:4567890123456789,
          q2:123
        },
        {
          q1:4567890123456789,
          q2:4567890123456789
        },
        {
          q1:4567890123456789,
          q2:-4567890123456789
        }
      ]
    }
  },
  {
    name:"PG_INT8_16",
    statement:"SELECT * FROM int8_tbl WHERE 123 > q1",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
      ]
    }
  },
  {
    name:"PG_INT8_17",
    statement:"SELECT * FROM int8_tbl WHERE 123 <= q1",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          q1:123,
          q2:456
        },
        {
          q1:123,
          q2:4567890123456789
        },
        {
          q1:4567890123456789,
          q2:123
        },
        {
          q1:4567890123456789,
          q2:4567890123456789
        },
        {
          q1:4567890123456789,
          q2:-4567890123456789
        }
      ]
    }
  },
  {
    name:"PG_INT8_18",
    statement:"SELECT * FROM int8_tbl WHERE 123 >= q1",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          q1:123,
          q2:456
        },
        {
          q1:123,
          q2:4567890123456789
        }
      ]
    }
  },
  {
    name:"PG_INT8_19",
    statement:"SELECT '' AS five, q1 AS plus, -q1 AS minus FROM int8_tbl",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          five:"",
          plus:123,
          minus:-123
        },
        {
          five:"",
          plus:123,
          minus:-123
        },
        {
          five:"",
          plus:4567890123456789,
          minus:-4567890123456789
        },
        {
          five:"",
          plus:4567890123456789,
          minus:-4567890123456789
        },
        {
          five:"",
          plus:4567890123456789,
          minus:-4567890123456789
        }
      ]
    }
  },
  {
    name:"PG_INT8_20",
    statement:"SELECT '' AS five, q1, q2, q1 + q2 AS plus FROM int8_tbl",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          five:"",
          q1:123,
          q2:456,
          plus:579
        },
        {
          five:"",
          q1:123,
          q2:4567890123456789,
          plus:4567890123456912
        },
        {
          five:"",
          q1:4567890123456789,
          q2:123,
          plus:4567890123456912
        },
        {
          five:"",
          q1:4567890123456789,
          q2:4567890123456789,
          plus:9135780246913578
        },
        {
          five:"",
          q1:4567890123456789,
          q2:-4567890123456789,
          plus:0
        }
      ]
    }
  },
  {
    name:"PG_INT8_21",
    statement:"SELECT '' AS five, q1, q2, q1 + q2 AS plus FROM int8_tbl",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          five:"",
          q1:123,
          q2:456,
          plus:579
        },
        {
          five:"",
          q1:123,
          q2:4567890123456789,
          plus:4567890123456912
        },
        {
          five:"",
          q1:4567890123456789,
          q2:123,
          plus:4567890123456912
        },
        {
          five:"",
          q1:4567890123456789,
          q2:4567890123456789,
          plus:9135780246913578
        },
        {
          five:"",
          q1:4567890123456789,
          q2:-4567890123456789,
          plus:0
        }
      ]
    }
  },
  {
    name:"PG_INT8_22",
    statement:"SELECT '' AS five, q1, q2, q1 - q2 AS minus FROM int8_tbl",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          five:"",
          q1:123,
          q2:456,
          minus:-333
        },
        {
          five:"",
          q1:123,
          q2:4567890123456789,
          minus:-4567890123456666
        },
        {
          five:"",
          q1:4567890123456789,
          q2:123,
          minus:4567890123456666
        },
        {
          five:"",
          q1:4567890123456789,
          q2:4567890123456789,
          minus:0
        },
        {
          five:"",
          q1:4567890123456789,
          q2:-4567890123456789,
          minus:9135780246913578
        }
      ]
    }
  },
  {
    name:"PG_INT8_23",
    statement:"SELECT '' AS three, q1, q2, q1 * q2 AS multiply FROM int8_tbl WHERE q1 < 1000 or (q2 > 0 and q2 < 1000)",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          three:"",
          q1:123,
          q2:456,
          multiply:56088
        },
        {
          three:"",
          q1:123,
          q2:4567890123456789,
          multiply:561850485185185047
        },
        {
          three:"",
          q1:4567890123456789,
          q2:123,
          multiply:561850485185185047
        }
      ]
    }
  },
  {
    name:"PG_INT8_24",
    statement:"SELECT '' AS five, q1, q2, q1 / q2 AS divide, q1 % q2 AS modulo FROM int8_tbl",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          five:"",
          q1:123,
          q2:456,
          divide:0,
          modulo:123
        },
        {
          five:"",
          q1:123,
          q2:4567890123456789,
          divide:0,
          modulo:123
        },
        {
          five:"",
          q1:4567890123456789,
          q2:123,
          divide:37137318076884,
          modulo:57
        },
        {
          five:"",
          q1:4567890123456789,
          q2:4567890123456789,
          divide:1,
          modulo:0
        },
        {
          five:"",
          q1:4567890123456789,
          q2:-4567890123456789,
          divide:-1,
          modulo:0
        }
      ]
    }
  },
  {
    name:"PG_INT8_25",
    statement:"SELECT 37 + q1 AS plus4 FROM int8_tbl",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          plus4:160
        },
        {
          plus4:160
        },
        {
          plus4:4567890123456826
        },
        {
          plus4:4567890123456826
        },
        {
          plus4:4567890123456826
        }
      ]
    }
  },
  {
    name:"PG_INT8_26",
    statement:"SELECT 37 - q1 AS minus4 FROM int8_tbl",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          minus4:-86
        },
        {
          minus4:-86
        },
        {
          minus4:-4567890123456752
        },
        {
          minus4:-4567890123456752
        },
        {
          minus4:-4567890123456752
        }
      ]
    }
  },
  {
    name:"PG_INT8_27",
    statement:"SELECT '' AS five, 2 * q1 AS \"twice int4\" FROM int8_tbl",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          five:"",
          'twice int4':246
        },
        {
          five:"",
          'twice int4':246
        },
        {
          five:"",
          'twice int4':9135780246913578
        },
        {
          five:"",
          'twice int4':9135780246913578
        },
        {
          five:"",
          'twice int4':9135780246913578
        }
      ]
    }
  },
  {
    name:"PG_INT8_28",
    statement:"SELECT '' AS five, q1 * 2 AS \"twice int4\" FROM int8_tbl",
    assert:{
      result:EvaluationSuccess,
      evalMode:[
        EvalModeCoerce,
        EvalModeError
      ],
      output:$bag::[
        {
          five:"",
          'twice int4':246
        },
        {
          five:"",
          'twice int4':246
        },
        {
          five:"",
          'twice int4':9135780246913578
        },
        {
          five:"",
          'twice int4':9135780246913578
        },
        {
          five:"",
          'twice int4':9135780246913578
        }
      ]
    }
  }
]