create schema default_guc;
set current_schema to 'default_guc';
set dolphin.use_const_value_as_colname = false;
show behavior_compat_options;
behavior_compat_options
------------------------------------------------------------------
display_leading_zero,select_into_return_null,sql_mode_full_group
(1 row)
select 0.123;
?column?
----------
0.123
(1 row)
select md5(0.123);
md5
----------------------------------
677738b969d6037efce2c328c6814580
(1 row)
select md5('0.123');
md5
----------------------------------
677738b969d6037efce2c328c6814580
(1 row)
set behavior_compat_options = '';
show behavior_compat_options;
behavior_compat_options
-------------------------
(1 row)
select 0.123;
?column?
----------
.123
(1 row)
select md5(0.123);
md5
----------------------------------
8fac4453738620d469930241cc87e8dc
(1 row)
select md5('0.123');
md5
----------------------------------
677738b969d6037efce2c328c6814580
(1 row)
drop schema default_guc cascade;
reset current_schema;