Something weird

[Zvoni]

Hi Folks/Mods

just experienced something weird: In the Database-Forum i tried to help a User out with some SQL

.... and:
i was not able to post a SQL-DDL-Statement with a specific constraint.
The Forum just froze (Not the Browser!)

I'll try to post it here, trying to outwit the parser

The Constraint (intentional Typos!!)
(KASE WHEN Student_Class_ID IS NULL THEN 0 ELSE 1 END)+(KASE WHEN Teacher_Subject_ID IS NULL THEN 0 ELSE 1 END)=1

CREATE TABLE "tbl_transaction2" (
    "ID"    INTEGER,
    "Payment"    REAL,
    "PayDate"    TEXT,
    "Student_Class_ID"    INTEGER DEFAULT NULL,
    "Teacher_Subject_ID"    INTEGER DEFAULT NULL,
    PRIMARY KEY("ID"),
    FOREIGN KEY("Student_Class_ID") REFERENCES "tbl_student_class"("ID") ON UPDATE CASCADE ON DELETE RESTRICT,
    FOREIGN KEY("Teacher_Subject_ID") REFERENCES "tbl_teacher_subject"("ID") ON UPDATE CASCADE ON DELETE RESTRICT,
    CONSTRAINT "CheckForeignKeyXOR" CHECK(
   /* Insert The Constraint from above here */
    )
)

Since when is the Forum choking on an SQL-CASE/WHEN?

[Steve R Jones]

I posted to the thread YOU reported.

[Zvoni]

I posted to the thread YOU reported.

Sorry, Steve, just saw it.
I, too, first thought, it might have to do with the "widespread" of my earlier post, but that's not the case.
It definitely is that "constraint" above i had to write "wrong" intentionally to get it even posted here