Changeset: 2a95e99830ef for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/2a95e99830ef
Modified Files:
sql/test/pg_regress/Tests/int8-nohge.test
sql/test/prepare/Tests/sqlancer_prepare.stable.out
Branch: cleanup_types
Log Message:
Approve some no-hge tests.
diffs (117 lines):
diff --git a/sql/test/pg_regress/Tests/int8-nohge.test
b/sql/test/pg_regress/Tests/int8-nohge.test
--- a/sql/test/pg_regress/Tests/int8-nohge.test
+++ b/sql/test/pg_regress/Tests/int8-nohge.test
@@ -239,59 +239,59 @@ 9135780246913578
# TO_CHAR()
# Note: this PostgreSQL (and Oracle) function is NOT supported by MonetDB, so
all to_char(<expr>, '<format>') queries will fail with Error: SELECT: no such
binary operator 'to_char(bigint,char)'
-statement error 42000!SELECT: no such binary operator 'to_char'(bigint,char)
+statement error 42000!SELECT: no such binary operator 'to_char'(bigint,varchar)
SELECT '' AS to_char_1, to_char(q1, '9G999G999G999G999G999'), to_char(q2,
'9,999,999,999,999,999')
FROM INT8_TBL
-statement error 42000!SELECT: no such binary operator 'to_char'(bigint,char)
+statement error 42000!SELECT: no such binary operator 'to_char'(bigint,varchar)
SELECT '' AS to_char_2, to_char(q1, '9G999G999G999G999G999D999G999'),
to_char(q2, '9,999,999,999,999,999.999,999')
FROM INT8_TBL
-statement error 42000!SELECT: no such binary operator 'to_char'(bigint,char)
+statement error 42000!SELECT: no such binary operator 'to_char'(bigint,varchar)
SELECT '' AS to_char_3, to_char( (q1 * -1), '9999999999999999PR'), to_char(
(q2 * -1), '9999999999999999.999PR')
FROM INT8_TBL
-statement error 42000!SELECT: no such binary operator 'to_char'(bigint,char)
+statement error 42000!SELECT: no such binary operator 'to_char'(bigint,varchar)
SELECT '' AS to_char_4, to_char( (q1 * -1), '9999999999999999S'), to_char( (q2
* -1), 'S9999999999999999')
FROM INT8_TBL
-statement error 42000!SELECT: no such binary operator 'to_char'(bigint,char)
+statement error 42000!SELECT: no such binary operator 'to_char'(bigint,varchar)
SELECT '' AS to_char_5, to_char(q2, 'MI9999999999999999') FROM INT8_TBL
-statement error 42000!SELECT: no such binary operator 'to_char'(bigint,char)
+statement error 42000!SELECT: no such binary operator 'to_char'(bigint,varchar)
SELECT '' AS to_char_6, to_char(q2, 'FMS9999999999999999') FROM INT8_TBL
-statement error 42000!SELECT: no such binary operator 'to_char'(bigint,char)
+statement error 42000!SELECT: no such binary operator 'to_char'(bigint,varchar)
SELECT '' AS to_char_7, to_char(q2, 'FM9999999999999999THPR') FROM INT8_TBL
-statement error 42000!SELECT: no such binary operator 'to_char'(bigint,char)
+statement error 42000!SELECT: no such binary operator 'to_char'(bigint,varchar)
SELECT '' AS to_char_8, to_char(q2, 'SG9999999999999999th') FROM INT8_TBL
-statement error 42000!SELECT: no such binary operator 'to_char'(bigint,char)
+statement error 42000!SELECT: no such binary operator 'to_char'(bigint,varchar)
SELECT '' AS to_char_9, to_char(q2, '0999999999999999') FROM INT8_TBL
-statement error 42000!SELECT: no such binary operator 'to_char'(bigint,char)
+statement error 42000!SELECT: no such binary operator 'to_char'(bigint,varchar)
SELECT '' AS to_char_10, to_char(q2, 'S0999999999999999') FROM INT8_TBL
-statement error 42000!SELECT: no such binary operator 'to_char'(bigint,char)
+statement error 42000!SELECT: no such binary operator 'to_char'(bigint,varchar)
SELECT '' AS to_char_11, to_char(q2, 'FM0999999999999999') FROM INT8_TBL
-statement error 42000!SELECT: no such binary operator 'to_char'(bigint,char)
+statement error 42000!SELECT: no such binary operator 'to_char'(bigint,varchar)
SELECT '' AS to_char_12, to_char(q2, 'FM9999999999999999.000') FROM INT8_TBL
-statement error 42000!SELECT: no such binary operator 'to_char'(bigint,char)
+statement error 42000!SELECT: no such binary operator 'to_char'(bigint,varchar)
SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000') FROM INT8_TBL
-statement error 42000!SELECT: no such binary operator 'to_char'(bigint,char)
+statement error 42000!SELECT: no such binary operator 'to_char'(bigint,varchar)
SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM INT8_TBL
-statement error 42000!SELECT: no such binary operator 'to_char'(bigint,char)
+statement error 42000!SELECT: no such binary operator 'to_char'(bigint,varchar)
SELECT '' AS to_char_15, to_char(q2, 'S 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 . 9 9
9') FROM INT8_TBL
-statement error 42000!SELECT: no such binary operator 'to_char'(bigint,char)
+statement error 42000!SELECT: no such binary operator 'to_char'(bigint,varchar)
SELECT '' AS to_char_16, to_char(q2, E'99999 "text" 9999 "9999" 999 "\\"text
between quote marks\\"" 9999') FROM INT8_TBL
-statement error 42000!SELECT: no such binary operator 'to_char'(bigint,char)
+statement error 42000!SELECT: no such binary operator 'to_char'(bigint,varchar)
SELECT '' AS to_char_17, to_char(q2, '999999SG9999999999') FROM INT8_TBL
# cleanup created table
diff --git a/sql/test/prepare/Tests/sqlancer_prepare.stable.out
b/sql/test/prepare/Tests/sqlancer_prepare.stable.out
--- a/sql/test/prepare/Tests/sqlancer_prepare.stable.out
+++ b/sql/test/prepare/Tests/sqlancer_prepare.stable.out
@@ -69,14 +69,14 @@
% varchar, int, int, varchar, varchar, varchar # type
% 7, 2, 1, 0, 2, 2 # length
[ "double", 53, 0, "", "%2", "%2" ]
-[ "char", 9, 0, NULL, NULL, NULL ]
+[ "varchar", 9, 0, NULL, NULL, NULL ]
[ "tinyint", 7, 0, NULL, NULL, NULL ]
% .prepare, .prepare, .prepare, .prepare, .prepare,
.prepare # table_name
% type, digits, scale, schema, table, column # name
% varchar, int, int, varchar, varchar, varchar # type
-% 6, 2, 1, 0, 3, 2 # length
+% 7, 2, 1, 0, 3, 2 # length
[ "bigint", 63, 0, "", "%12", "%4" ]
-[ "char", 0, 0, NULL, NULL, NULL ]
+[ "varchar", 0, 0, NULL, NULL, NULL ]
[ "bigint", 63, 0, NULL, NULL, NULL ]
#PREPARE VALUES (CASE WHEN true THEN 5 BETWEEN 4 AND 2 END);
#PREPARE VALUES (CASE WHEN true THEN 5 BETWEEN 4 AND 2 END);
@@ -165,12 +165,12 @@
% type, digits, scale, schema, table, column # name
% varchar, int, int, varchar, varchar, varchar # type
% 7, 1, 1, 0, 3, 3 # length
-[ "char", 1, 0, "", "%22", "%14" ]
-[ "char", 1, 0, NULL, NULL, NULL ]
+[ "varchar", 1, 0, "", "%22", "%14" ]
+[ "varchar", 1, 0, NULL, NULL, NULL ]
[ "boolean", 1, 0, NULL, NULL, NULL ]
% .%22 # table_name
% %14 # name
-% char # type
+% varchar # type
% 1 # length
[ "b" ]
[ 9999 ]
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
