Changeset: 30b427583523 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/30b427583523
Removed Files:
sql/test/pg_regress/Tests/int8.SQL.py
sql/test/pg_regress/Tests/int8.stable.err
sql/test/pg_regress/Tests/int8.stable.err.int128
sql/test/pg_regress/Tests/int8.stable.out
sql/test/pg_regress/Tests/int8.stable.out.int128
Branch: Aug2024
Log Message:
Remove unused files.
diffs (truncated from 502 to 300 lines):
diff --git a/sql/test/pg_regress/Tests/int8.SQL.py
b/sql/test/pg_regress/Tests/int8.SQL.py
deleted file mode 100644
--- a/sql/test/pg_regress/Tests/int8.SQL.py
+++ /dev/null
@@ -1,20 +0,0 @@
-from MonetDBtesting.sqltest import SQLTestCase
-import pymonetdb, os
-
-conn1 = pymonetdb.connect(database=os.getenv("TSTDB"),
port=int(os.getenv("MAPIPORT")), autocommit=True)
-cur1 = conn1.cursor()
-try:
- cur1.execute('select cast(1 as hugeint)')
- suffix = '.int128'
-except pymonetdb.DatabaseError as e:
- suffix = ''
-cur1.close()
-conn1.close()
-
-with SQLTestCase() as tc:
- # optional or default connection
- tc.connect()
- with open('int8.sql') as f:
- tc.execute(query=None, client='mclient', stdin=f)\
- .assertMatchStableOut(fout='int8.stable.out%s' % (suffix))\
- .assertMatchStableError(ferr='int8.stable.err%s' % (suffix))
diff --git a/sql/test/pg_regress/Tests/int8.stable.err
b/sql/test/pg_regress/Tests/int8.stable.err
deleted file mode 100644
--- a/sql/test/pg_regress/Tests/int8.stable.err
+++ /dev/null
@@ -1,104 +0,0 @@
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
-QUERY = INSERT INTO INT8_TBL(q1) VALUES (' ');
-ERROR = !conversion of string ' ' to type lng failed.
-CODE = 22018
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = INSERT INTO INT8_TBL(q1) VALUES ('xxx');
-ERROR = !conversion of string 'xxx' to type lng failed.
-CODE = 22018
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = INSERT INTO INT8_TBL(q1) VALUES ('3908203590239580293850293850329485');
-ERROR = !conversion of string '3908203590239580293850293850329485' to type lng
failed.
-CODE = 22018
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = INSERT INTO INT8_TBL(q1) VALUES
('-1204982019841029840928340329840934');
-ERROR = !conversion of string '-1204982019841029840928340329840934' to type
lng failed.
-CODE = 22018
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = INSERT INTO INT8_TBL(q1) VALUES ('- 123');
-ERROR = !conversion of string '- 123' to type lng failed.
-CODE = 22018
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = INSERT INTO INT8_TBL(q1) VALUES (' 345 5');
-ERROR = !conversion of string ' 345 5' to type lng failed.
-CODE = 22018
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = INSERT INTO INT8_TBL(q1) VALUES ('');
-ERROR = !conversion of string '' to type lng failed.
-CODE = 22018
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = SELECT '' AS three, q1, q2, q1 * q2 AS multiply FROM INT8_TBL WHERE q2
<> 4567890123456789 ORDER BY q1, q2;
-ERROR = !overflow in calculation 4567890123456789*-4567890123456789.
-CODE = 22003
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = SELECT '' AS to_char_1, to_char(q1, '9G999G999G999G999G999'),
to_char(q2, '9,999,999,999,999,999')
- FROM INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = SELECT '' AS to_char_2, to_char(q1, '9G999G999G999G999G999D999G999'),
to_char(q2, '9,999,999,999,999,999.999,999')
- FROM INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = SELECT '' AS to_char_3, to_char( (q1 * -1), '9999999999999999PR'),
to_char( (q2 * -1), '9999999999999999.999PR')
- FROM INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = SELECT '' AS to_char_4, to_char( (q1 * -1), '9999999999999999S'),
to_char( (q2 * -1), 'S9999999999999999')
- FROM INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = SELECT '' AS to_char_5, to_char(q2, 'MI9999999999999999') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = SELECT '' AS to_char_6, to_char(q2, 'FMS9999999999999999') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = SELECT '' AS to_char_7, to_char(q2, 'FM9999999999999999THPR') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = SELECT '' AS to_char_8, to_char(q2, 'SG9999999999999999th') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = SELECT '' AS to_char_9, to_char(q2, '0999999999999999') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = SELECT '' AS to_char_10, to_char(q2, 'S0999999999999999') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = SELECT '' AS to_char_11, to_char(q2, 'FM0999999999999999') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = SELECT '' AS to_char_12, to_char(q2, 'FM9999999999999999.000') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = 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;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = monetdb@WIN2K12R2:33746
-QUERY = SELECT '' AS to_char_16, to_char(q2, E'99999 "text" 9999 "9999" 999
"\\"text between quote marks\\"" 9999') FROM INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
-QUERY = SELECT '' AS to_char_17, to_char(q2, '999999SG9999999999') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
diff --git a/sql/test/pg_regress/Tests/int8.stable.err.int128
b/sql/test/pg_regress/Tests/int8.stable.err.int128
deleted file mode 100644
--- a/sql/test/pg_regress/Tests/int8.stable.err.int128
+++ /dev/null
@@ -1,100 +0,0 @@
-MAPI = (monetdb) /var/tmp/mtest-27483/.s.monetdb.35395
-QUERY = INSERT INTO INT8_TBL(q1) VALUES (' ');
-ERROR = !conversion of string ' ' to type lng failed.
-CODE = 22018
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = INSERT INTO INT8_TBL(q1) VALUES ('xxx');
-ERROR = !conversion of string 'xxx' to type lng failed.
-CODE = 22018
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = INSERT INTO INT8_TBL(q1) VALUES ('3908203590239580293850293850329485');
-ERROR = !conversion of string '3908203590239580293850293850329485' to type lng
failed.
-CODE = 22018
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = INSERT INTO INT8_TBL(q1) VALUES
('-1204982019841029840928340329840934');
-ERROR = !conversion of string '-1204982019841029840928340329840934' to type
lng failed.
-CODE = 22018
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = INSERT INTO INT8_TBL(q1) VALUES ('- 123');
-ERROR = !conversion of string '- 123' to type lng failed.
-CODE = 22018
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = INSERT INTO INT8_TBL(q1) VALUES (' 345 5');
-ERROR = !conversion of string ' 345 5' to type lng failed.
-CODE = 22018
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = INSERT INTO INT8_TBL(q1) VALUES ('');
-ERROR = !conversion of string '' to type lng failed.
-CODE = 22018
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = SELECT '' AS to_char_1, to_char(q1, '9G999G999G999G999G999'),
to_char(q2, '9,999,999,999,999,999')
- FROM INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = SELECT '' AS to_char_2, to_char(q1, '9G999G999G999G999G999D999G999'),
to_char(q2, '9,999,999,999,999,999.999,999')
- FROM INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = SELECT '' AS to_char_3, to_char( (q1 * -1), '9999999999999999PR'),
to_char( (q2 * -1), '9999999999999999.999PR')
- FROM INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = SELECT '' AS to_char_4, to_char( (q1 * -1), '9999999999999999S'),
to_char( (q2 * -1), 'S9999999999999999')
- FROM INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = SELECT '' AS to_char_5, to_char(q2, 'MI9999999999999999') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = SELECT '' AS to_char_6, to_char(q2, 'FMS9999999999999999') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = SELECT '' AS to_char_7, to_char(q2, 'FM9999999999999999THPR') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = SELECT '' AS to_char_8, to_char(q2, 'SG9999999999999999th') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = SELECT '' AS to_char_9, to_char(q2, '0999999999999999') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = SELECT '' AS to_char_10, to_char(q2, 'S0999999999999999') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = SELECT '' AS to_char_11, to_char(q2, 'FM0999999999999999') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = SELECT '' AS to_char_12, to_char(q2, 'FM9999999999999999.000') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = 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;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-10958/.s.monetdb.35734
-QUERY = SELECT '' AS to_char_16, to_char(q2, E'99999 "text" 9999 "9999" 999
"\\"text between quote marks\\"" 9999') FROM INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
-QUERY = SELECT '' AS to_char_17, to_char(q2, '999999SG9999999999') FROM
INT8_TBL;
-ERROR = !SELECT: no such binary operator 'to_char'(bigint,char)
-CODE = 42000
diff --git a/sql/test/pg_regress/Tests/int8.stable.out
b/sql/test/pg_regress/Tests/int8.stable.out
deleted file mode 100644
--- a/sql/test/pg_regress/Tests/int8.stable.out
+++ /dev/null
@@ -1,122 +0,0 @@
-#CREATE TABLE INT8_TBL(q1 bigint, q2 bigint);
-#INSERT INTO INT8_TBL VALUES(' 123 ',' 456');
-[ 1 ]
-#INSERT INTO INT8_TBL VALUES('123 ','4567890123456789');
-[ 1 ]
-#INSERT INTO INT8_TBL VALUES('4567890123456789','123');
-[ 1 ]
-#INSERT INTO INT8_TBL VALUES('4567890123456789','4567890123456789');
-[ 1 ]
-#INSERT INTO INT8_TBL VALUES('4567890123456789','-4567890123456789');
-[ 1 ]
-#-- bad inputs
-#
-#
-#
-#
-#
-#
-#
-#SELECT * FROM INT8_TBL;
-% sys.int8_tbl, sys.int8_tbl # table_name
-% q1, q2 # name
-% bigint, bigint # type
-% 16, 17 # length
-[ 123, 456 ]
-[ 123, 4567890123456789 ]
-[ 4567890123456789, 123 ]
-[ 4567890123456789, 4567890123456789 ]
-[ 4567890123456789, -4567890123456789 ]
-
-#SELECT '' AS five, q1 AS plus, -q1 AS minus FROM INT8_TBL;
-% ., sys., sys. # table_name
-% five, plus, minus # name
-% char, bigint, bigint # type
-% 0, 16, 17 # length
-[ "", 123, -123 ]
-[ "", 123, -123 ]
-[ "", 4567890123456789, -4567890123456789 ]
-[ "", 4567890123456789, -4567890123456789 ]
-[ "", 4567890123456789, -4567890123456789 ]
-
-#SELECT '' AS five, q1, q2, q1 + q2 AS plus FROM INT8_TBL;
-% ., sys.int8_tbl, sys.int8_tbl, sys. # table_name
-% five, q1, q2, plus # name
-% char, bigint, bigint, bigint # type
-% 0, 16, 17, 16 # length
-[ "", 123, 456, 579 ]
-[ "", 123, 4567890123456789, 4567890123456912 ]
-[ "", 4567890123456789, 123, 4567890123456912 ]
-[ "", 4567890123456789, 4567890123456789, 9135780246913578 ]
-[ "", 4567890123456789, -4567890123456789, 0 ]
-
-#SELECT '' AS five, q1, q2, q1 - q2 AS minus FROM INT8_TBL;
-% ., sys.int8_tbl, sys.int8_tbl, sys. # table_name
-% five, q1, q2, minus # name
-% char, bigint, bigint, bigint # type
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
