Hi, all,
I was trying to allow UUID() to be used in DEFAULT clause in the column
definition. I found uuid() is already supported but in a strange way to me.
Now, one can use this query to get uuid:
select uuid();
But cannot do:
select uuid() from dual;
uuid() is fixed syntax and can only be used as 'select uuid()'. I didn't find
anywhere in the code base depend on this syntax. So I asked here if it is OK
for me to change uuid() into a normal function? So it will make me easier to
allow it in the column definition.
Anyone know the story why UUID is defined in yacc as it is now?
interactive_query_expression:
| TOK_SELECT TOK_UUID '(' ')'
If there is no special reason, I would like to change it into a misc_function.
thanks,
Ming