On 01-03-2020 18:53, Adriano dos Santos Fernandes wrote:
On 01/03/2020 09:25, Mark Rotteveel wrote:
Looking at src/common/keywords.cpp, int128 is considered a non-reserved
token (it's defined as `{TOK_INT128, "INT128", true}`), and it is listed
in keyword_or_column, but not in non_reserved_word.
Attempts to use int128 as non-reserved word (eg `select 1 as int128 from
rdb$database`), will yield a token unknown error.
I also have doubts about this. Is INT128 a PSQL/SQL data type or not?
SQL> select cast(1 as int128) from rdb$database;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 18
-int128
Firebird 4 has no datatype INT128 exposed in SQL, only NUMERIC/DECIMAL
with precision between 19 and 38 inclusive. I was asking about using
INT128 as a non-reserved word (which is suggested is possible due to its
definition in src/common/keywords.cpp).
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
