set dolphin.b_compatibility_mode to off;
drop database if exists db_b_sqrt_test;
NOTICE: database "db_b_sqrt_test" does not exist, skipping
create database db_b_sqrt_test dbcompatibility 'A';
\c db_b_sqrt_test
SELECT SQRT(64);
sqrt
------
8
(1 row)
SELECT SQRT(-64);
ERROR: cannot take square root of a negative number
CONTEXT: referenced column: sqrt
\c contrib_regression
set dolphin.b_compatibility_mode to off;
drop database db_b_sqrt_test;
set dolphin.b_compatibility_mode to on;
create schema db_b_sqrt_test;
set current_schema to 'db_b_sqrt_test';
SELECT SQRT(64);
sqrt
------
8
(1 row)
SELECT SQRT(-64);
sqrt
------
(1 row)
SELECT SQRT(64::numeric);
sqrt
-------------------
8.000000000000000
(1 row)
SELECT SQRT(-64::numeric);
sqrt
------
(1 row)
select sqrt(111);
sqrt
-------------------
10.53565375285274
(1 row)
select sqrt(b'111');
sqrt
-------------------
2.645751311064591
(1 row)
select sqrt(7);
sqrt
-------------------
2.645751311064591
(1 row)
select sqrt(b'111'::int);
sqrt
-------------------
2.645751311064591
(1 row)
drop schema db_b_sqrt_test cascade;
reset current_schema;