The conditional node has no <code class="notranslate"

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

Included in latest sqlite-parser@beta release <a href

Looks good to me <g-emoji class="g-emoji" alias="+1" fallback-src="https://github.gith

Node Structure Change: Change format in condition type node to variant about sqlite-parser HOT 4 CLOSED

codeschool commented on June 25, 2024

Node Structure Change: Change format in condition type node to variant

from sqlite-parser.

Comments (4)

nwronski commented on June 25, 2024

Another great find! This is probably an oversight on my part. I will make this change and tag this issue with the fix.

from sqlite-parser.

nwronski commented on June 25, 2024

@jdrew1303 What do you think about the following?

variant when has a condition and a consequent
variant else has just a consequent
the outer expression is now variant case instead of binary
instead of taking whatever is provided between CASE and WHEN (e.g., CASE foo WHEN ...) and calling that the expression, it is now added as the discriminant

select
    case acc
      when a = 0 then a1
      when a = 1 then b1
      else c1
    end

CASE Statement AST

{
  "type": "expression",
  "variant": "case",
  "expression": [
    {
      "type": "condition",
      "variant": "when",
      "condition": {
        "type": "expression",
        "format": "binary",
        "variant": "operation",
        "operation": "=",
        "left": {
          "type": "identifier",
          "variant": "column",
          "name": "a"
        },
        "right": {
          "type": "literal",
          "variant": "decimal",
          "value": "0"
        }
      },
      "consequent": {
        "type": "identifier",
        "variant": "column",
        "name": "a1"
      }
    },
    {
      "type": "condition",
      "variant": "when",
      "condition": {
        "type": "expression",
        "format": "binary",
        "variant": "operation",
        "operation": "=",
        "left": {
          "type": "identifier",
          "variant": "column",
          "name": "a"
        },
        "right": {
          "type": "literal",
          "variant": "decimal",
          "value": "1"
        }
      },
      "consequent": {
        "type": "identifier",
        "variant": "column",
        "name": "b1"
      }
    },
    {
      "type": "condition",
      "variant": "else",
      "consequent": {
        "type": "identifier",
        "variant": "column",
        "name": "c1"
      }
    }
  ],
  "discriminant": {
    "type": "identifier",
    "variant": "column",
    "name": "acc"
  }
}