Toad World® Forums

12.9.0.53: Checkbox "Include Updatable?" for views changes result

The length of a VARCHAR2(CHAR) data-type is displayed wrong in Columns of a describe window, when the checkbox is selected:

CREATE VIEW v_test AS
SELECT CAST( NULL AS VARCHAR2(1 CHAR) ) AS x
FROM dual;

Checkbox unselected:
VARCHAR2 (1 Char)

Checkbox selected:
VARCHAR2 (3 Char)

Fixed for next beta. Thanks.