Changeset: a5ab23c66647 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/a5ab23c66647
Modified Files:
sql/server/sql_semantic.c
sql/test/BugTracker-2009/Tests/arithmetic-small-values-null.SF-2921310.test
sql/test/BugTracker-2012/Tests/power_priority.Bug-2291.test
sql/test/BugTracker-2023/Tests/misc-crashes-7390.test
sql/test/BugTracker-2024/Tests/7483-rel_setop_get_statistics.test
sql/test/BugTracker-2026/Tests/7818-out-of-bounds-analytics.test
sql/test/SQLancer/Tests/sqlancer02.test
sql/test/SQLancer/Tests/sqlancer04.test
sql/test/SQLancer/Tests/sqlancer05.test
sql/test/SQLancer/Tests/sqlancer07.test
sql/test/SQLancer/Tests/sqlancer08.test
sql/test/SQLancer/Tests/sqlancer09.test
sql/test/SQLancer/Tests/sqlancer10.test
sql/test/SQLancer/Tests/sqlancer19.test.in
sql/test/prepare/Tests/sqlancer_prepare.test
sql/test/sys-schema/Tests/webExamplesMathematicalFunctionsOperators.test
Branch: default
Log Message:
disallow casting /coercing from decimal to integers when the functions work on
bits (like xor, and, or, <<, >> etc)
diffs (truncated from 314 to 300 lines):
diff --git a/sql/server/sql_semantic.c b/sql/server/sql_semantic.c
--- a/sql/server/sql_semantic.c
+++ b/sql/server/sql_semantic.c
@@ -595,6 +595,9 @@ score_func( sql_func *f, list *tl, bool
if (nr_strconverts > 1)
return 0;
+ if (f->fix_scale == SCALE_NONE && a->type.type->eclass ==
EC_NUM && t->type->eclass == EC_DEC)
+ /* no automatic conversions into numerics for fixed
(SCALE_NONE) functions */
+ return 0;
if (f->fix_scale == SCALE_FIX && a->type.type->eclass == EC_DEC
&& digits > a->type.type->digits) /* doesn't fit */
return 0;
/* sql types equal but implementation differences */
diff --git
a/sql/test/BugTracker-2009/Tests/arithmetic-small-values-null.SF-2921310.test
b/sql/test/BugTracker-2009/Tests/arithmetic-small-values-null.SF-2921310.test
---
a/sql/test/BugTracker-2009/Tests/arithmetic-small-values-null.SF-2921310.test
+++
b/sql/test/BugTracker-2009/Tests/arithmetic-small-values-null.SF-2921310.test
@@ -1,10 +1,9 @@
-query I nosort
-select ((4.4054292 - 4.40572025343667)^2) + ((52.0903881 - 52.091375762174)^2)
+query R nosort
+select power(4.4054292 - 4.40572025343667,2) + power(52.0903881 -
52.091375762174, 2)
----
-4
+0.000
query R nosort
-select cast((4.4054292 - 4.40572025343667)^2 as double) + cast((52.0903881 -
52.091375762174)^2 as double)
+select cast(power(4.4054292 - 4.40572025343667,2) as double) +
cast(power(52.0903881 - 52.091375762174,2) as double)
----
-4.000
-
+0.000
diff --git a/sql/test/BugTracker-2012/Tests/power_priority.Bug-2291.test
b/sql/test/BugTracker-2012/Tests/power_priority.Bug-2291.test
--- a/sql/test/BugTracker-2012/Tests/power_priority.Bug-2291.test
+++ b/sql/test/BugTracker-2012/Tests/power_priority.Bug-2291.test
@@ -1,5 +1,5 @@
query I nosort
-select (4.4054292 - 4.40572025343667)^2 + (52.0903881 - 52.091375762174)^2
+select power(4.4054292 - 4.40572025343667,2) + power(52.0903881 -
52.091375762174,2)
----
0
diff --git a/sql/test/BugTracker-2023/Tests/misc-crashes-7390.test
b/sql/test/BugTracker-2023/Tests/misc-crashes-7390.test
--- a/sql/test/BugTracker-2023/Tests/misc-crashes-7390.test
+++ b/sql/test/BugTracker-2023/Tests/misc-crashes-7390.test
@@ -252,7 +252,7 @@ statement ok
CREATE TABLE v0(v1 NUMERIC)
query I nosort
-SELECT 38 ^ v1 FROM v0 AS v3 WINDOW v2 AS ( ), v4 AS (GROUPS BETWEEN -32768
PRECEDING AND 94 FOLLOWING) LIMIT 16 OFFSET 8
+SELECT power(38, v1) FROM v0 AS v3 WINDOW v2 AS ( ), v4 AS (GROUPS BETWEEN
-32768 PRECEDING AND 94 FOLLOWING) LIMIT 16 OFFSET 8
----
query I nosort
@@ -260,7 +260,7 @@ WITH v0 (v1) AS (SELECT 127 FROM v0 WHER
----
statement ok
-UPDATE v0 SET v1 = (WITH v0 (v1) AS (SELECT 127 WHERE (v1 < 2147483647 OR v1 >
-1) AND v1 / v1 + v1 <= 95 = v1 >= -128 + 15) SELECT 38 FROM v0 AS v3 WINDOW v2
AS ( ), v4 AS (GROUPS BETWEEN -32768 PRECEDING AND 94 FOLLOWING) LIMIT 16
OFFSET 8) ^ v1
+UPDATE v0 SET v1 = power((WITH v0 (v1) AS (SELECT 127 WHERE (v1 < 2147483647
OR v1 > -1) AND v1 / v1 + v1 <= 95 = v1 >= -128 + 15) SELECT 38 FROM v0 AS v3
WINDOW v2 AS ( ), v4 AS (GROUPS BETWEEN -32768 PRECEDING AND 94 FOLLOWING)
LIMIT 16 OFFSET 8), v1)
statement ok
DROP TABLE v0
@@ -459,7 +459,7 @@ DROP TABLE v0
-- 31.sql
onlyif has-hugeint
query I nosort
-SELECT ALL ( SELECT - - - - - - - - - - - 1 - - - - - - 16 FROM ( SELECT NULL
- - - - - - - - - - - - - - - - 1 FROM ( SELECT - - - - 1 * - - - - - -
2147483648 * - - - 43 * 77745222.000000 ) AS v1 ( v1 ) GROUP BY GROUPING SETS (
GROUPING SETS ( CUBE ( v1 ) ) ) ORDER BY v1 , - - - 86 + - - 93 ^ v1 , v1 LIMIT
21 ) AS v1 UNION SELECT - - - - - - - - - - - - 93 WHERE - v1 < -
63226945.000000 - - - - - - - - - - 68 ) FROM ( VALUES ( - - - - - - - - - 40 /
- ( SELECT - - - - - - - - 0 WHERE - - - - - - - 40 = - - - - - 0 ) ) , ( - -
88 ) ) v1 ( v1 )
+SELECT ALL ( SELECT - - - - - - - - - - - 1 - - - - - - 16 FROM ( SELECT NULL
- - - - - - - - - - - - - - - - 1 FROM ( SELECT - - - - 1 * - - - - - -
2147483648 * - - - 43 * 77745222.000000 ) AS v1 ( v1 ) GROUP BY GROUPING SETS (
GROUPING SETS ( CUBE ( v1 ) ) ) ORDER BY v1 , - - - 86 + - - power(93 , v1) ,
v1 LIMIT 21 ) AS v1 UNION SELECT - - - - - - - - - - - - 93 WHERE - v1 < -
63226945.000000 - - - - - - - - - - 68 ) FROM ( VALUES ( - - - - - - - - - 40 /
- ( SELECT - - - - - - - - 0 WHERE - - - - - - - 40 = - - - - - 0 ) ) , ( - -
88 ) ) v1 ( v1 )
----
15
15
diff --git a/sql/test/BugTracker-2024/Tests/7483-rel_setop_get_statistics.test
b/sql/test/BugTracker-2024/Tests/7483-rel_setop_get_statistics.test
--- a/sql/test/BugTracker-2024/Tests/7483-rel_setop_get_statistics.test
+++ b/sql/test/BugTracker-2024/Tests/7483-rel_setop_get_statistics.test
@@ -5,7 +5,7 @@ x
10
query I nosort
-SELECT NTILE ( 1.000000 ) OVER ( ORDER BY x LIKE x ) FROM ( SELECT 'x' x UNION
SELECT 10 x ) v
+SELECT NTILE ( 1 ) OVER ( ORDER BY x LIKE x ) FROM ( SELECT 'x' x UNION SELECT
10 x ) v
----
1
1
diff --git a/sql/test/BugTracker-2026/Tests/7818-out-of-bounds-analytics.test
b/sql/test/BugTracker-2026/Tests/7818-out-of-bounds-analytics.test
--- a/sql/test/BugTracker-2026/Tests/7818-out-of-bounds-analytics.test
+++ b/sql/test/BugTracker-2026/Tests/7818-out-of-bounds-analytics.test
@@ -44,7 +44,7 @@ SELECT covar_pop (
+ COALESCE (
corr ( 1 , 1 ) OVER ( ) ,
covar_pop ( 1 , NULL ) OVER ( ) ,
- covar_samp ( 1.900000 , 1.000000 ^ 1 )
OVER (
+ covar_samp ( 1.900000 , power(1.000000 ,
1) ) OVER (
ORDER BY 754 DESC NULLS FIRST
RANGE BETWEEN CURRENT ROW
AND CASE WHEN EXISTS ( SELECT NULL )
diff --git a/sql/test/SQLancer/Tests/sqlancer02.test
b/sql/test/SQLancer/Tests/sqlancer02.test
--- a/sql/test/SQLancer/Tests/sqlancer02.test
+++ b/sql/test/SQLancer/Tests/sqlancer02.test
@@ -494,7 +494,7 @@ RIGHT OUTER JOIN (SELECT ALL l1t1.c0, CA
THEN l1t1.c0 END FROM t2 AS l1t2, t1 AS l1t1 WHERE l1t1.c0) AS sub0 ON
((FALSE)OR(TRUE))
CROSS JOIN (VALUES ('-|cQ5', least(6, 4), CASE 0.13214429 WHEN
0.92287980834693872367324729566462337970733642578125
THEN 'Bv*氅.x' END), ('', 0.7763767959438655, "insert"('RR6Mw+', 5, -65604773,
'1225096844'))) AS sub1)) AS sub0
-CROSS JOIN (VALUES (2, ((0.53827864)>>("day"(DATE '1969-12-27'))),
CAST(((2)+(-1758578278)) AS REAL))) AS sub1
+CROSS JOIN (VALUES (2, ((053827864)>>("day"(DATE '1969-12-27'))),
CAST(((2)+(-1758578278)) AS REAL))) AS sub1
WHERE (3.0) IS NOT NULL
----
896 values hashing to 25c86efc7cd2ecb484be80b79f18927b
@@ -507,7 +507,7 @@ THEN t2.c2 END)>(greatest(t2.c2, t2.c0))
WHEN l1t1.c0 THEN l1t1.c0 WHEN l1t1.c0 THEN l1t1.c0 END FROM t2 AS l1t2, t1 AS
l1t1 WHERE l1t1.c0) AS sub0 ON ((FALSE)OR(TRUE))
CROSS JOIN (VALUES ('-|cQ5', least(6, 4), CASE 0.13214429 WHEN
0.92287980834693872367324729566462337970733642578125
THEN 'Bv*氅.x' END), ('', 0.7763767959438655, "insert"('RR6Mw+', 5, -65604773,
'1225096844'))) AS sub1)) AS sub0
-CROSS JOIN (VALUES (2, ((0.53827864)>>("day"(DATE '1969-12-27'))),
CAST(((2)+(-1758578278)) AS REAL))) AS sub1) as res
+CROSS JOIN (VALUES (2, ((053827864)>>("day"(DATE '1969-12-27'))),
CAST(((2)+(-1758578278)) AS REAL))) AS sub1) as res
----
896
diff --git a/sql/test/SQLancer/Tests/sqlancer04.test
b/sql/test/SQLancer/Tests/sqlancer04.test
--- a/sql/test/SQLancer/Tests/sqlancer04.test
+++ b/sql/test/SQLancer/Tests/sqlancer04.test
@@ -635,7 +635,7 @@ create view v3(vc0) as (values (not (('%') is not null)),
(least(cast(1 as boolean), not (true))), (case sql_min('vFP*鱍', '&G*')
when cast(0 as string) then (true) is null when cast(9 as string(678)) then
((true)or(false)) end), (false)) with check option
statement ok
-create view v20(vc0) as (values (((sql_max(2,
0.8207251106243245164506561195594258606433868408203125))&(abs(0.25579435)))))
+create view v20(vc0) as (values (((sql_max(2,
82072511062432451645065611))&(abs(025579435)))))
statement ok
create view v37(vc0) as (values ('1837521830'), (replace(coalesce('4', '',
'20', '0.5074455058602168'),
@@ -701,7 +701,7 @@ SELECT 1 FROM v7, v43 WHERE v7.vc1 ILIKE
query RI rowsort
SELECT median(ALL least(+
(0.26910993823565487748084024133277125656604766845703125),
-((0.5744001734384440727154697015066631138324737548828125)&(-1283341470)))),
CASE WHEN NOT (FALSE) THEN
+((6631138324737548828125)&(-1283341470)))), CASE WHEN NOT (FALSE) THEN
least(-650735786, -1123683253) ELSE 1414135574 END FROM v7, v38, v43 RIGHT
OUTER JOIN
(SELECT ALL sql_max(CAST(v28.vc0 AS REAL), ifthenelse(v32.vc1, 56, 104)),
((CAST(v28.vc1 AS DOUBLE))*
(CAST(TRUE AS TINYINT))), 'u''A#{' FROM v28, v32, v3) AS sub0 ON
(((TRUE)AND(TRUE))) = TRUE
@@ -754,7 +754,7 @@ weekofyear(sql_sub(date '1970-01-10', in
statement ok
create view v6(vc0, vc1, vc2) as (values (cast((true) = true as int),
cast(((1576421008)&(null)) as decimal),
-((((0.15598454)-(-235033638)))<<(((0.50459784)/(1078999181))))), (abs(20223),
+ (cast(0.6995354 as real)),
+((((4)-(-235033638)))<<(((50459784)/(1078999181))))), (abs(20223), +
(cast(0.6995354 as real)),
cast(-1695180722 as bigint)))
query I rowsort
diff --git a/sql/test/SQLancer/Tests/sqlancer05.test
b/sql/test/SQLancer/Tests/sqlancer05.test
--- a/sql/test/SQLancer/Tests/sqlancer05.test
+++ b/sql/test/SQLancer/Tests/sqlancer05.test
@@ -690,7 +690,7 @@ NULL
query T rowsort
select t2.c1 from v0, t2 right outer join (values (least(ifthenelse(false, '',
'47940718'), sql_max('栩', 'U*>Kz0')),
-case cast(interval '-165227345' month as string) when "insert"('f3',
0.57506007, -1550051844, '0.06527867754732408')
+case cast(interval '-165227345' month as string) when "insert"('f3',
057506007, -1550051844, '0.06527867754732408')
then 'u' when '2033856974' then case when true then '' when false then
'-1543387917' when true then '0.4055556886118663'
when false then 'c' else 'E\n' end end)) as sub0 on nullif(not (false),
(t2.c1) not between asymmetric (t2.c1) and (t2.c1))
where case ((50)*(1836147184)) when least(5110, 1303739364) then (false) =
false when 3 then least(true, true) when
diff --git a/sql/test/SQLancer/Tests/sqlancer07.test
b/sql/test/SQLancer/Tests/sqlancer07.test
--- a/sql/test/SQLancer/Tests/sqlancer07.test
+++ b/sql/test/SQLancer/Tests/sqlancer07.test
@@ -500,7 +500,7 @@ statement ok
create view v0(c0) as (values (((-839450346)||(0.2907855)))) with check option
statement ok
-create view v1(c0) as (with cte0(c0) as (values (case when ((true)or(true))
then ((0.75)&(0.16181643)) else 0.5068248 end)) select all 0.48 from t1, v0,
t2,t0,cte0)
+create view v1(c0) as (with cte0(c0) as (values (case when ((true)or(true))
then ((075)&(016181643)) else 0.5068248 end)) select all 0.48 from t1, v0,
t2,t0,cte0)
statement ok
create view v2(c0) as (select distinct interval '883554454' month from t1, t2)
with check option
diff --git a/sql/test/SQLancer/Tests/sqlancer08.test
b/sql/test/SQLancer/Tests/sqlancer08.test
--- a/sql/test/SQLancer/Tests/sqlancer08.test
+++ b/sql/test/SQLancer/Tests/sqlancer08.test
@@ -347,7 +347,7 @@ statement ok
create view v2(vc0) as (select cast(('|S4 흮,8GQ') not between symmetric
('3840') and ('n') as int))
statement ok
-create view v3(vc0) as (values (cast(((abs(0.11))-(((round(0.3,
3))<<(((-3)+(5)))))) as decimal))) with check option
+create view v3(vc0) as (values (cast(((abs(11))-(((3)<<(((-3)+(5)))))) as
decimal))) with check option
query I rowsort
SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(FALSE AS INT) as count
FROM t2, t1, v2 FULL OUTER JOIN t0 ON "isauuid"('2A') NATURAL JOIN v1 NATURAL
JOIN v3) as res
diff --git a/sql/test/SQLancer/Tests/sqlancer09.test
b/sql/test/SQLancer/Tests/sqlancer09.test
--- a/sql/test/SQLancer/Tests/sqlancer09.test
+++ b/sql/test/SQLancer/Tests/sqlancer09.test
@@ -232,7 +232,7 @@ create or replace view v21(vc0) as (sele
0.30544159200423870448304342062328942120075225830078125) where
((false)or(true)))
statement ok
-create view v59(vc0) as (select all
((degrees(0.92038196))^(0.20652191739572556)) where
(0.7852820956901502835734163454617373645305633544921875)
+create view v59(vc0) as (select all ((092038196)^(20652191739572556)) where
(0.7852820956901502835734163454617373645305633544921875)
not between symmetric (-1878062655) and
(0.557693883106285870354668077197857201099395751953125)) with check option
statement ok
@@ -538,7 +538,7 @@ statement ok
create view v24(vc0) as (values (0.22)) with check option
query II nosort
-select ((sum(all least(((((0.32)-(0.33))) -(0.43)), -(cast(3 as
bigint)))))>>2), 1 from v21
+select ((sum(all least(((((32)-(33))) -(43)), -(cast(3 as bigint)))))>>2), 1
from v21
join v18 on ((v18.vc0)>(cast(((0.33)
-(0.222)) as double))) inner join (select distinct
replace(sql_min(rtrim('便竼E*P'),
"concat"('?X', '沈pJqd')), replace('w', '95', '580488485'),
cast(((0.33827385)/(24413.0)) as string)) from v24)
@@ -546,7 +546,7 @@ as sub0 on ((least(342, v18.vc0))<>(1))
group by least((((('RJᦈ4[[h\340\272\246')like('9804')))and(not (false))),
"isauuid"(cast(v18.vc0 as string(979))))
----
--1
+-11
1
statement ok
diff --git a/sql/test/SQLancer/Tests/sqlancer10.test
b/sql/test/SQLancer/Tests/sqlancer10.test
--- a/sql/test/SQLancer/Tests/sqlancer10.test
+++ b/sql/test/SQLancer/Tests/sqlancer10.test
@@ -507,7 +507,7 @@ SELECT group_concat('a') FROM t1 RIGHT O
a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a,a
query TI nosort
-SELECT listagg(ALL CASE sql_min('pX1~e*', '1041995366') WHEN reverse(' ') THEN
COALESCE('-879625247', '0.19731369376302454', '1470019653', 'uUBi*') WHEN
"right"('e', 0.8362747) THEN '-1627785951'
+SELECT listagg(ALL CASE sql_min('pX1~e*', '1041995366') WHEN reverse(' ') THEN
COALESCE('-879625247', '0.19731369376302454', '1470019653', 'uUBi*') WHEN
"right"('e', 8362747) THEN '-1627785951'
ELSE substr('{!)5DӾ2_', 1) END), -1807892187 FROM t1 RIGHT OUTER JOIN ((SELECT
t1.c0, (SELECT DISTINCT CAST(l1t1.c0 AS INT) FROM t1 AS l1t1, t2 AS l1t2 WHERE
TRUE), t2.c0, -879625247 FROM t0, t1, t2
JOIN (SELECT DISTINCT 2.73848834E8, -879625247) AS sub0 ON CASE WHEN FALSE
THEN 'FALSE' WHEN TRUE THEN FALSE WHEN FALSE THEN FALSE END) INTERSECT ALL
(SELECT ALL ((CASE WHEN TRUE THEN 3 WHEN FALSE
THEN 321224835 WHEN TRUE THEN 0.19240692 WHEN FALSE THEN 4 WHEN TRUE THEN 5
END)/(+ (t0.c2))), ((SELECT CAST(l1t1.c0 AS bigint) FROM t2 AS l1t2, t1 AS l1t1
WHERE NULL) EXCEPT ALL (SELECT DISTINCT 7
diff --git a/sql/test/SQLancer/Tests/sqlancer19.test.in
b/sql/test/SQLancer/Tests/sqlancer19.test.in
--- a/sql/test/SQLancer/Tests/sqlancer19.test.in
+++ b/sql/test/SQLancer/Tests/sqlancer19.test.in
@@ -830,15 +830,15 @@ SELECT count(0.3121149) FROM (select cas
36
query I nosort
-SELECT CAST(2 AS REAL) BETWEEN 2 AND (t5.c0 / t5.c0)^5 AS X FROM t5 ORDER BY x
NULLS LAST
+SELECT CAST(2 AS REAL) BETWEEN 2 AND power(t5.c0 / t5.c0,5) AS X FROM t5 ORDER
BY x NULLS LAST
----
-1
-1
-1
-1
-1
-1
-1
+0
+0
+0
+0
+0
+0
+0
NULL
NULL
NULL
@@ -846,15 +846,15 @@ NULL
NULL
query I nosort
-SELECT CAST(2 AS REAL) BETWEEN 2 AND (rt5.c0 / rt5.c0)^5 AS X FROM rt5 ORDER
BY x NULLS LAST
+SELECT CAST(2 AS REAL) BETWEEN 2 AND power(rt5.c0 / rt5.c0,5) AS X FROM rt5
ORDER BY x NULLS LAST
----
-1
-1
-1
-1
-1
-1
-1
+0
+0
+0
+0
+0
+0
+0
NULL
NULL
NULL
diff --git a/sql/test/prepare/Tests/sqlancer_prepare.test
b/sql/test/prepare/Tests/sqlancer_prepare.test
--- a/sql/test/prepare/Tests/sqlancer_prepare.test
+++ b/sql/test/prepare/Tests/sqlancer_prepare.test
@@ -231,11 +231,11 @@ NULL
onlyif has-hugeint
statement error 42000!types hugeint(127,0) and sec_interval(13,0) are not equal
-PREPARE VALUES (CAST(? >> 1.2 AS INTERVAL SECOND)), (interval '1' second)
+PREPARE VALUES (CAST(? >> 1 AS INTERVAL SECOND)), (interval '1' second)
skipif has-hugeint
statement error 42000!types bigint(63,0) and sec_interval(13,0) are not equal
-PREPARE VALUES (CAST(? >> 1.2 AS INTERVAL SECOND)), (interval '1' second)
+PREPARE VALUES (CAST(? >> 1 AS INTERVAL SECOND)), (interval '1' second)
query TIITTT nosort
PREPARE (SELECT DISTINCT ((CAST(- (CASE r'' WHEN r'tU1' THEN 1739172851 WHEN ?
THEN -1313600539 WHEN r'X(' THEN NULL WHEN r')''CD' THEN 95 END) AS
BIGINT))&(least(- (-235253756), 64)))
diff --git
a/sql/test/sys-schema/Tests/webExamplesMathematicalFunctionsOperators.test
b/sql/test/sys-schema/Tests/webExamplesMathematicalFunctionsOperators.test
--- a/sql/test/sys-schema/Tests/webExamplesMathematicalFunctionsOperators.test
+++ b/sql/test/sys-schema/Tests/webExamplesMathematicalFunctionsOperators.test
@@ -21,7 +21,7 @@ project (
) [ "sys"."bit_xor"(tinyint(2) "2", tinyint(2) "3") NOT NULL ]
query I nosort
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
