odbtools/odbctest/mql/0/cast/1.mql

select * into /temp1 from /matrix/jobs/jobrun
;

SELECT
cast(runid as text) as "cast as text runid",
runid as "org runid"
FROM
/temp1
/**
output()
metainfo()
**/
;

SELECT
cast(runid as text) as "cast as text runid",
runid as "org runid"
FROM
/matrix/jobs/jobrun
/**
output()
metainfo()
**/
;

SELECT
cast(runid as text)
FROM
/matrix/jobs/jobrun
/**
output()
metainfo()
**/
;

SELECT
cast(runid as text),
runid as org_runid
FROM
/matrix/jobs/jobrun
/**
output()
metainfo()
**/
;