Executed the test and got this result:
2/0/563136D280B8: end processing
'-- SELECT (2/563136D280B8) selFlags=0x4400c4 nSelectRow=0
'-- result-set
'-- AS END
'-- CASE
|-- 1
'-- LIST
|-- EQ fg.af=40000000.n DDL
| |-- NEW(5)
| '-- 2
'-- CASE
|-- 1
'-- LIST
|-- OR fg.af=40000000.n DDL
| |-- NOT fg.af=40000000.n DDL
| | '-- IN flags=0x40000000
| | |-- OLD(5)
| | '-- LIST
| | |-- 1
| | '-- 128
| '-- AND fg.af=40000000.n DDL
| |-- NOTNULL fg.af=40000000.n DDL
| | '-- OLD(6)
| '-- NOT fg.af=40000000.n DDL
| '-- EQ fg.af=40000000.n DDL
| |-- OLD(5)
| '-- 4
|-- RAISE abort('Error: someone goofed')
|-- NE fg.af=40200000.n DDL
| |-- subquery-expr flags=0x42200800
| | '-- SELECT (1/563136D2AFF8) selFlags=0x40c4 nSelectRow=0
| | |-- result-set
| | | '-- {0:5} pTab=563136D21208 fg.af=40800000.n DDL
| | |-- FROM
| | | '-- {0:*} C1 tab='C1' nCol=8 ptr=563136D21208 used=22 DDL
| | |-- WHERE
| | | '-- EQ fg.af=40000000.n DDL
| | | |-- {0:1} pTab=563136D21208 fg.af=40800000.n DDL
| | | '-- NEW(0)
| | '-- LIMIT
| | '-- 1
| '-- 4
'-- RAISE abort('Error you are not allowed to change the status')
*** Optimizer Start *** (wctrlFlags: 0x1004)
---- Solution nRow=1
0 0.01.00 C1._2 1 f 01241 N 1 cost 0,39,1
*** Optimizer Finished ***
ONEPASS_SINGLE cursors: 3 4
Error: near line 6: no such column: C1_QTY_PRODUCED
Note that the .selecttrace crashes and the .wheretrace shows and error. What?!
Excuse me! The table C1 has a column C1_QTY_PRODUCED. Here is the table:
CREATE TABLE IF NOT EXISTS C1 (
C1_PRODUCTION_ORDER VARCHAR(20),
C1_INDEX INTEGER,
C1_QTY_TO_PRODUCE NUMBER DEFAULT 0,
C1_QTY_PRODUCED NUMBER DEFAULT 0,
C1_PRODUCTION_STATUS NUMBER
CHECK (C1_PRODUCTION_STATUS IN (1, 2, 4, 128)),
C1_STATUS NUMBER
CHECK (C1_STATUS IN (1, 2, 4, 8)),
C1_DTS_CREATED TEXT NOT NULL DEFAULT (DATETIME('NOW', 'UTC')),
C1_DTS_UPDATED TEXT NOT NULL DEFAULT (DATETIME('NOW', 'UTC')),
CONSTRAINT C1_PK PRIMARY KEY (
C1_PRODUCTION_ORDER
) ON CONFLICT ROLLBACK,
CONSTRAINT C1_INDEX_FK FOREIGN KEY (
C1_INDEX
)
REFERENCES A1 (
A1_INDEX
),
UNIQUE (
C1_INDEX
)
);
Am I overlooking something?