Question
What is the columnDefinition in an XSD for a bigInt(21) field.
I created a view in SQL to calculate the age of a person. MariaDB is formating the age field as a bigint(21). I am connecting an CDT to this view and I need to know what the columnDefinition would be for a big integer. I tried INT and BIGINT and that doesn't work.
@Column(name="Age", columnDefinition="INT")
I even tried to cast the calculated field as an integer in the SQL statement, but that did not work either?
CAST(TIMESTAMPDIFF(YEAR, `CM`.`ClergyDOB`,
CASE
WHEN `CM`.`ClergyDOD` IS NULL THEN CURDATE()
ELSE `CM`.`ClergyDOD`
END
)
AS INT) AS `Age`, 