Hello everybody, I am running a set of tests to understand which kind of metadata Calcite is exposing already, w.r.t. this JIRA [1].
Using both MySQL and Postgres I queried the available database metadata both through Calcite and directly using the relative driver class. The result is the attached files. What I am trying to understand is the meaning of the Calcite TYPE_NAME column values. Calcites interprets Postgres’ varchar 12 and MYSQL’s VARCHAR 12 as VARCHAR(100) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL and Postgres’ int4 and MYSQL’s INT as INTEGER NOT NULL Can you please explain to me what these datatypes refer to? thanks in advance! [1] https://issues.apache.org/jira/browse/CALCITE-1545 Riccardo Tommasini Master Degree Computer Science PhD Student at Politecnico di Milano (Italy) streamreasoning.org<http://streamreasoning.org/> Submitted from an iPhone, I apologise for typos.
