Lines Matching refs:text

25 # Tests for the CAST( AS blob), CAST( AS text) and CAST( AS numeric) built-ins
35     execsql {SELECT CAST(x'616263' AS text)}
38     execsql {SELECT typeof(CAST(x'616263' AS text))}
39   } text
66   execsql {SELECT CAST(NULL AS text)}
69   execsql {SELECT typeof(CAST(NULL AS text))}
96   execsql {SELECT CAST(123 AS text)}
99   execsql {SELECT typeof(CAST(123 AS text))}
100 } text
126   execsql {SELECT CAST(123.456 AS text)}
129   execsql {SELECT typeof(CAST(123.456 AS text))}
130 } text
154 } text
156   execsql {SELECT CAST('123abc' AS text)}
159   execsql {SELECT typeof(CAST('123abc' AS text))}
160 } text
366 # EVIDENCE-OF: R-33990-33527 When casting to INTEGER, if the text looks