TypeCheck after the default value is set

[sanjeethboddi]

DEFINE TABLE person;
DEFINE FIELD first_name ON TABLE person;
DEFINE FIELD last_name ON TABLE person;
DEFINE FIELD full_name ON TABLE person TYPE string VALUE $this.first_name + ' ' + $this.last_name;

CREATE person SET first_name = "Mr.", last_name = "Meow";

select * from person;

when I insert the record it fails because it's looking for full_name field with type string. I think the type check should happen after the default value is set. or it shouldn't happen.

[naisofly]

Hey @sanjeethboddi , thanks for flagging this! You can try separating the TYPE & VALUE definitions and then it works fine:

DEFINE TABLE person;
DEFINE FIELD first_name ON TABLE person TYPE string;
DEFINE FIELD last_name ON TABLE person TYPE string;
DEFINE FIELD full_name ON TABLE person TYPE string;
DEFINE FIELD full_name ON TABLE person VALUE $this.first_name + ' ' + $this.last_name;

CREATE person SET first_name = "Mr.", last_name = "Meow";

select * from person;