Changeset: a3990762c1dd for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a3990762c1dd
Added Files:
sql/test/BugTracker-2019/Tests/rank-nan.Bug-6780.sql
sql/test/BugTracker-2019/Tests/rank-nan.Bug-6780.stable.err
sql/test/BugTracker-2019/Tests/rank-nan.Bug-6780.stable.out
Modified Files:
gdk/gdk_analytic_func.c
sql/server/rel_exp.c
sql/test/BugTracker-2015/Tests/crash.Bug-3736.sql
sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
sql/test/BugTracker-2019/Tests/All
Branch: default
Log Message:
Merge with Nov2019
diffs (truncated from 1415 to 300 lines):
diff --git a/gdk/gdk_analytic_func.c b/gdk/gdk_analytic_func.c
--- a/gdk/gdk_analytic_func.c
+++ b/gdk/gdk_analytic_func.c
@@ -25,13 +25,38 @@
} \
} else { \
for (; bp < end; bp++, rb++) { \
- if (*bp != prev) { \
+ if (*bp == prev) { \
+ *rb = FALSE; \
+ } else { \
+ *rb = TRUE; \
+ prev = *bp; \
+ } \
+ } \
+ } \
+ } while (0)
+
+/* We use NaN for floating point null values, which always output false on
equality tests */
+#define ANALYTICAL_DIFF_FLOAT_IMP(TPE) \
+ do { \
+ TPE *bp = (TPE*)Tloc(b, 0); \
+ TPE prev = *bp, *end = bp + cnt; \
+ if (np) { \
+ for (; bp < end; bp++, rb++, np++) { \
+ *rb = *np; \
+ if (*bp != prev && (!is_##TPE##_nil(*bp) ||
!is_##TPE##_nil(prev))) { \
*rb = TRUE; \
prev = *bp; \
- } else { \
- *rb = FALSE; \
} \
} \
+ } else { \
+ for (; bp < end; bp++, rb++) { \
+ if (*bp == prev || (is_##TPE##_nil(*bp) &&
is_##TPE##_nil(prev))) { \
+ *rb = FALSE; \
+ } else { \
+ *rb = TRUE; \
+ prev = *bp; \
+ } \
+ } \
} \
} while (0)
@@ -63,10 +88,10 @@ GDKanalyticaldiff(BAT *r, BAT *b, BAT *p
break;
#endif
case TYPE_flt:
- ANALYTICAL_DIFF_IMP(flt);
+ ANALYTICAL_DIFF_FLOAT_IMP(flt);
break;
case TYPE_dbl:
- ANALYTICAL_DIFF_IMP(dbl);
+ ANALYTICAL_DIFF_FLOAT_IMP(dbl);
break;
default:{
BATiter it = bat_iterator(b);
diff --git a/sql/server/rel_exp.c b/sql/server/rel_exp.c
--- a/sql/server/rel_exp.c
+++ b/sql/server/rel_exp.c
@@ -2085,7 +2085,15 @@ exp_sum_scales(sql_subfunc *f, sql_exp *
/* numeric types are fixed length */
if (ares->type.type->eclass == EC_NUM) {
- sql_find_numeric(&t, ares->type.type->localtype,
res->digits);
+#ifdef HAVE_HGE
+ if (have_hge && ares->type.type->localtype == TYPE_hge
&& res->digits == 128)
+ t = *sql_bind_localtype("hge");
+ else
+#endif
+ if (ares->type.type->localtype == TYPE_lng &&
res->digits == 64)
+ t = *sql_bind_localtype("lng");
+ else
+ sql_find_numeric(&t,
ares->type.type->localtype, res->digits);
} else {
sql_find_subtype(&t, ares->type.type->sqlname,
res->digits, res->scale);
}
diff --git a/sql/test/BugTracker-2015/Tests/crash.Bug-3736.sql
b/sql/test/BugTracker-2015/Tests/crash.Bug-3736.sql
--- a/sql/test/BugTracker-2015/Tests/crash.Bug-3736.sql
+++ b/sql/test/BugTracker-2015/Tests/crash.Bug-3736.sql
@@ -1,4 +1,3 @@
-
CREATE TABLE open_auctions (
id int NOT NULL AUTO_INCREMENT,
@@ -16,7 +15,7 @@ CREATE TABLE open_auctions (
PRIMARY KEY (id)
);
-INSERT INTO "open_auctions" ("id", "open_auction_id", "initial", "reserve",
"aktuell", "privacy", "itemref", "seller", "quantity", "type", "start", "ende")
VALUES
+INSERT INTO open_auctions (id, open_auction_id, initial, reserve, aktuell,
privacy, itemref, seller, quantity, type, start, ende) VALUES
(1, 'open_auction0', 210.62, 1540.75, 263.12, 'No', 'item0', 'person11', 1,
'Regular', '02/27/1998', '03/09/1999'),
(2, 'open_auction1', 69.64, 398.65, 168.64, '', 'item2', 'person10', 1,
'Featured', '06/14/1998', '02/27/1999'),
(3, 'open_auction2', 13.9, 0, 16.9, 'No', 'item3', 'person11', 1, 'Featured',
'07/16/2000', '10/22/2000'),
@@ -43,7 +42,7 @@ CREATE TABLE bidder (
-- Daten für Tabelle "bidder"
--
-INSERT INTO "bidder" ("id", "open_auction_id", "date", "time", "personref",
"increase") VALUES
+INSERT INTO bidder (id, open_auction_id, date, time, personref, increase)
VALUES
(1, 'open_auction0', '06/13/2001', '13:16:15', 'person0', 18),
(2, 'open_auction0', '09/18/2000', '11:29:44', 'person23', 12),
(3, 'open_auction0', '01/07/1998', '10:23:59', 'person14', 18),
@@ -106,9 +105,36 @@ INSERT INTO "bidder" ("id", "open_auctio
(60, 'open_auction11', '10/22/2001', '15:34:49', 'person4', 15);
Select b.* FROM open_auctions o, b bidder WHERE (select b3.INCREASE from
bidder b3 where b3.id = (select min (b3a.id) from bidder b3a where
b3a.open_auction_id = o.open_auction_id)) * 2 <= (Select b2.INCREASE from
bidder b2 where b2.id = (SELECT MAX (b2a.id) from bidder b2a where
b2a.open_auction_id = o.open_auction_id)) AND o.open_auction_id =
b.open_auction_id order by date, time;
+-- should return: ERROR = !SELECT: no such table 'b'
-plan Select b.* FROM open_auctions o, bidder b WHERE (select b3.INCREASE from
bidder b3 where b3.id = (select min (b3a.id) from bidder b3a where
b3a.open_auction_id = o.open_auction_id)) * 2 <= (Select b2.INCREASE from
bidder b2 where b2.id = (SELECT MAX (b2a.id) from bidder b2a where
b2a.open_auction_id = o.open_auction_id)) AND o.open_auction_id =
b.open_auction_id;
-Select b.* FROM open_auctions o, bidder b WHERE (select b3.INCREASE from
bidder b3 where b3.id = (select min (b3a.id) from bidder b3a where
b3a.open_auction_id = o.open_auction_id)) * 2 <= (Select b2.INCREASE from
bidder b2 where b2.id = (SELECT MAX (b2a.id) from bidder b2a where
b2a.open_auction_id = o.open_auction_id)) AND o.open_auction_id =
b.open_auction_id order by date, time;
+plan
+Select b.* FROM open_auctions o, bidder b WHERE (select b3.INCREASE from
bidder b3 where b3.id = (select min (b3a.id) from bidder b3a where
b3a.open_auction_id = o.open_auction_id)) * 2 <= (Select b2.INCREASE from
bidder b2 where b2.id = (SELECT MAX (b2a.id) from bidder b2a where
b2a.open_auction_id = o.open_auction_id)) AND o.open_auction_id =
b.open_auction_id;
+
+Select b.* FROM open_auctions o, bidder b WHERE (select b3.INCREASE from
bidder b3 where b3.id = (select min(b3a.id) from bidder b3a where
b3a.open_auction_id = o.open_auction_id)) * 2 <= (Select b2.INCREASE from
bidder b2 where b2.id = (SELECT MAX(b2a.id) from bidder b2a where
b2a.open_auction_id = o.open_auction_id)) AND o.open_auction_id =
b.open_auction_id order by date, time;
+-- note that the ordering is done on two varchar columns, so not chronological
on date and time.
+/* should output 10 rows (according to PostgreSQL and MySQL):
+[ 11, "open_auction1", "05/21/2001", "08:02:16", "person5",
12 ]
+[ 8, "open_auction1", "06/22/1999", "12:43:47", "person19",
15 ]
+[ 29, "open_auction5", "07/07/2000", "08:53:00", "person15",
6 ]
+[ 30, "open_auction5", "08/06/2001", "10:16:15", "person13",
4.5 ]
+[ 31, "open_auction5", "08/23/1999", "08:26:06", "person17",
30 ]
+[ 6, "open_auction1", "10/02/2000", "22:48:00", "person4",
15 ]
+[ 5, "open_auction1", "11/12/1998", "11:23:38", "person20",
4.5 ]
+[ 10, "open_auction1", "11/12/2001", "04:50:27", "person9",
6 ]
+[ 9, "open_auction1", "12/02/2001", "13:38:51", "person15",
45 ]
+[ 7, "open_auction1", "12/04/1998", "22:29:38", "person23",
1.5 ]
+*/
+
+-- alternative way to write the query, but giving the correct output
+select * from (
+ Select b.*
+ , (select b3.INCREASE from bidder b3 where b3.id = (select min(b3a.id) from
bidder b3a where b3a.open_auction_id = o.open_auction_id)) as b3_increase
+ , (Select b2.INCREASE from bidder b2 where b2.id = (SELECT MAX(b2a.id) from
bidder b2a where b2a.open_auction_id = o.open_auction_id)) as b2_increase
+ FROM open_auctions o, bidder b
+ WHERE o.open_auction_id = b.open_auction_id
+) t
+where b3_increase * 2 <= b2_increase
+order by date, time;
drop table bidder;
drop table open_auctions;
diff --git a/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
b/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
--- a/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
+++ b/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
@@ -136,7 +136,7 @@ project (
| | ) [ "L6"."L6" NOT NULL, "o"."open_auction_id" NOT NULL as "L37"."L37" ]
| ) [ sys.sql_mul("b3"."increase" NOT NULL, double "2") <= "L6"."L6" NOT NULL,
"o"."open_auction_id" NOT NULL = "L37"."L37" NOT NULL ]
) [ "b"."id" NOT NULL HASHCOL , "b"."open_auction_id" NOT NULL, "b"."date" NOT
NULL, "b"."time" NOT NULL, "b"."personref" NOT NULL, "b"."increase" NOT NULL ]
-#Select b.* FROM open_auctions o, bidder b WHERE (select b3.INCREASE from
bidder b3 where b3.id = (select min (b3a.id) from bidder b3a where
b3a.open_auction_id = o.open_auction_id)) * 2 <= (Select b2.INCREASE from
bidder b2 where b2.id = (SELECT MAX (b2a.id) from bidder b2a where
b2a.open_auction_id = o.open_auction_id)) AND o.open_auction_id =
b.open_auction_id order by date, time;
+#Select b.* FROM open_auctions o, bidder b WHERE (select b3.INCREASE from
bidder b3 where b3.id = (select min(b3a.id) from bidder b3a where
b3a.open_auction_id = o.open_auction_id)) * 2 <= (Select b2.INCREASE from
bidder b2 where b2.id = (SELECT MAX(b2a.id) from bidder b2a where
b2a.open_auction_id = o.open_auction_id)) AND o.open_auction_id =
b.open_auction_id order by date, time;
% sys.b, sys.b, sys.b, sys.b, sys.b, sys.b # table_name
% id, open_auction_id, date, time, personref, increase # name
% int, varchar, varchar, varchar, varchar, double
# type
@@ -151,6 +151,29 @@ project (
[ 10, "open_auction1", "11/12/2001", "04:50:27", "person9",
6 ]
[ 9, "open_auction1", "12/02/2001", "13:38:51", "person15",
45 ]
[ 7, "open_auction1", "12/04/1998", "22:29:38", "person23",
1.5 ]
+#select * from (
+# Select b.*
+# , (select b3.INCREASE from bidder b3 where b3.id = (select min(b3a.id) from
bidder b3a where b3a.open_auction_id = o.open_auction_id)) as b3_increase
+# , (Select b2.INCREASE from bidder b2 where b2.id = (SELECT MAX(b2a.id) from
bidder b2a where b2a.open_auction_id = o.open_auction_id)) as b2_increase
+# FROM open_auctions o, bidder b
+# WHERE o.open_auction_id = b.open_auction_id
+#) t
+#where b3_increase * 2 <= b2_increase
+#order by date, time;
+% sys.t, sys.t, sys.t, sys.t, sys.t, sys.t, .t, .t # table_name
+% id, open_auction_id, date, time, personref, increase,
b3_increase, b2_increase # name
+% int, varchar, varchar, varchar, varchar,
double, double, double # type
+% 2, 13, 10, 8, 8, 24, 24, 24 # length
+[ 11, "open_auction1", "05/21/2001", "08:02:16", "person5",
12, 4.5, 12 ]
+[ 8, "open_auction1", "06/22/1999", "12:43:47", "person19",
15, 4.5, 12 ]
+[ 29, "open_auction5", "07/07/2000", "08:53:00", "person15",
6, 6, 30 ]
+[ 30, "open_auction5", "08/06/2001", "10:16:15", "person13",
4.5, 6, 30 ]
+[ 31, "open_auction5", "08/23/1999", "08:26:06", "person17",
30, 6, 30 ]
+[ 6, "open_auction1", "10/02/2000", "22:48:00", "person4",
15, 4.5, 12 ]
+[ 5, "open_auction1", "11/12/1998", "11:23:38", "person20",
4.5, 4.5, 12 ]
+[ 10, "open_auction1", "11/12/2001", "04:50:27", "person9",
6, 4.5, 12 ]
+[ 9, "open_auction1", "12/02/2001", "13:38:51", "person15",
45, 4.5, 12 ]
+[ 7, "open_auction1", "12/04/1998", "22:29:38", "person23",
1.5, 4.5, 12 ]
#drop table bidder;
#drop table open_auctions;
diff --git a/sql/test/BugTracker-2019/Tests/All
b/sql/test/BugTracker-2019/Tests/All
--- a/sql/test/BugTracker-2019/Tests/All
+++ b/sql/test/BugTracker-2019/Tests/All
@@ -43,3 +43,4 @@ prod-decimals.Bug-6774
NOT_IN-AND-OR-wrong-results.Bug-6775
outer-join-varchar.Bug-6776
msqldump-mapi-cache.Bug-6777
+rank-nan.Bug-6780
diff --git a/sql/test/BugTracker-2019/Tests/rank-nan.Bug-6780.sql
b/sql/test/BugTracker-2019/Tests/rank-nan.Bug-6780.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2019/Tests/rank-nan.Bug-6780.sql
@@ -0,0 +1,935 @@
+START TRANSACTION;
+CREATE TABLE "sys"."BondPricesWithNulls" (
+ "Category" VARCHAR(255),
+ "Field 2" TIMESTAMP,
+ "Field 3" VARCHAR(255),
+ "Ticker" VARCHAR(255),
+ "Issue Name" VARCHAR(255),
+ "Field 6" VARCHAR(255),
+ "Coupon" VARCHAR(255),
+ "Field 8" VARCHAR(255),
+ "Maturity Date" VARCHAR(255),
+ "Tier" VARCHAR(255),
+ "Benchmark Gilt" VARCHAR(255),
+ "Composite Rating" VARCHAR(255),
+ "Implied Credit Rating" VARCHAR(255),
+ "Is Split" VARCHAR(255),
+ "Liq Cat" DOUBLE,
+ "Market Price" DOUBLE,
+ "Market Yield" DOUBLE,
+ "Model Yield" DOUBLE,
+ "Field 19" BIGINT,
+ "Market Spread (Swaps)" BIGINT,
+ "_visokio_row_id_" BIGINT NOT NULL,
+ CONSTRAINT """BondPricesWithNulls""_PK" PRIMARY KEY ("_visokio_row_id_")
+);
+INSERT INTO "sys"."BondPricesWithNulls" VALUES ('Subordinated', TIMESTAMP
'1997-05-13 00:00:00.000000', 'XS0076061927', 'ABBEY', NULL, 'N', '8.75', NULL,
NULL, NULL, '4.5 07', 'BBB-', 'BB+', 'Y', 5, 105.855, 5.252, NULL, NULL, 88,
0),
+('Subordinated', NULL, NULL, 'HBOS', 'BANK OF SCOTLAND', 'N', '8.375', 'Y',
'30-Oct-2006 00:00:00', 'UT2', '7.5 06', NULL, 'BBB+', 'Y', 5, 104.635, 4.565,
NULL, NULL, 18, 1),
+('Subordinated', TIMESTAMP '2004-11-04 00:00:00.000000', 'XS0204938798', NULL,
'SL MACS PLC', NULL, '6.546', 'Y', '06-Jan-2020 00:00:00', NULL, '8 21',
'BBB+', NULL, NULL, 4, 106.255, NULL, 5.292, 155, 132, 2),
+('Subordinated', TIMESTAMP '2005-06-15 00:00:00.000000', 'XS0220428154',
'ANGIRI', 'LAMBAY CAPTL SECURITIES', 'N', NULL, NULL, '16-Jun-2015 00:00:00',
NULL, NULL, 'BBB+', NULL, 'N', NULL, 102.41, 5.835, NULL, NULL, NULL, 3),
+('Subordinated', TIMESTAMP '2003-10-02 00:00:00.000000', 'XS0177600920',
'ZURNVX', NULL, NULL, NULL, 'Y', '02-Oct-2022 00:00:00', 'Other', NULL, NULL,
NULL, NULL, 3, 110.187, NULL, 5.347, 135, 113, 4),
+('Subordinated', TIMESTAMP '2004-03-26 00:00:00.000000', NULL, 'FSPAA',
'SWEDBANK', NULL, '5.75', NULL, '17-Mar-2016 00:00:00', 'T1', NULL, 'A-', 'A-',
'Y', NULL, NULL, 5.162, 5.07, 95, 69, 5),
+('Subordinated', NULL, 'XS0179407910', 'HSBC', 'HSBC BANK FUNDING STER', 'N',
'5.844', 'Y', '05-Nov-2031 00:00:00', 'T1', '4.25 32', NULL, 'A', NULL, 3,
108.097, NULL, 5.241, NULL, 79, 6),
+(NULL, TIMESTAMP '2002-04-19 00:00:00.000000', 'XS0145875513', 'BACR',
'BARCLAYS BANK PLC', 'N', '6.125', 'Y', '19-Apr-2027 00:00:00', NULL, '6 28',
'AA-', NULL, NULL, 3, 113.35, 5.031, 4.918, 80, 57, 7),
+(NULL, TIMESTAMP '2003-05-09 00:00:00.000000', NULL, NULL, 'EGG BANKING PLC',
NULL, '7.5', 'Y', '09-Dec-2013 00:00:00', 'UT2', NULL, NULL, NULL, 'N', NULL,
111.692, 5.626, 5.162, 143, 116, 8),
+(NULL, TIMESTAMP '2001-11-28 00:00:00.000000', NULL, 'HBOS', 'HBOS CAPITAL
FUNDING LP', 'N', '6.461', 'Y', '30-Nov-2018 00:00:00', 'T1', NULL, 'A', 'A-',
'N', 3, 112.493, 5.157, 5.004, 95, 69, 9),
+('Subordinated', TIMESTAMP '2002-11-28 00:00:00.000000', NULL, 'HBOS', 'HBOS
PLC', 'N', '5.75', 'Y', NULL, 'UT2', '5 25', 'A+', 'A', 'Y', NULL, NULL, NULL,
5.002, NULL, NULL, 10),
+(NULL, TIMESTAMP '2001-05-11 00:00:00.000000', NULL, NULL, NULL, 'N', '8.103',
'Y', '11-May-2016 00:00:00', 'T1', '4.75 15', 'BBB+', NULL, 'N', NULL, NULL,
NULL, 5.331, NULL, 78, 11),
+('Subordinated', TIMESTAMP '2002-07-18 00:00:00.000000', NULL, 'NBHSS',
'NORDEA BANK FINLAND PLC', NULL, '6.25', NULL, NULL, 'UT2', '5 14', 'A', NULL,
'Y', 4, 108.851, 4.945, 4.832, 75, 47, 12),
+('Subordinated', TIMESTAMP '2000-11-27 00:00:00.000000', 'XS0120327571', NULL,
'BARCLAYS BANK PLC', NULL, NULL, 'Y', '27-Nov-2015 00:00:00', 'UT2', '4.75
15', 'AA-', NULL, 'Y', 3, 114.818, 4.944, 4.735, NULL, 46, 13),
+(NULL, TIMESTAMP '2005-03-16 00:00:00.000000', 'XS0214342569', 'DANBNK',
'DANSKE BANK A/S', 'N', NULL, 'Y', NULL, 'T1', '4.75 15', 'A+', NULL, 'Y', 4,
103.74, 5.062, 4.857, NULL, NULL, 14),
+('Subordinated', TIMESTAMP '2000-09-28 00:00:00.000000', 'XS0117972967',
'ABBEY', NULL, 'N', '7.5', 'Y', '28-Sep-2015 00:00:00', 'UT2', '4.75 15',
NULL, 'A-', 'Y', 3, NULL, 4.99, 4.874, 78, 50, 15),
+('Subordinated', TIMESTAMP '2000-05-26 00:00:00.000000', NULL, 'HBOS', 'HBOS
PLC', 'N', '7.5', NULL, NULL, 'UT2', NULL, NULL, NULL, 'Y', NULL, 119.509,
5.051, 4.812, NULL, NULL, 16),
+('Subordinated', TIMESTAMP '2001-07-23 00:00:00.000000', 'XS0133173137',
'ABBEY', 'SCOTTISH MUTUAL ASSURANC', 'N', NULL, NULL, '25-Mar-2021 00:00:00',
'Other', '8 21', 'BBB-', NULL, NULL, 4, NULL, 6.261, 5.962, 201, 179, 17),
+('Subordinated', TIMESTAMP '1999-11-05 00:00:00.000000', 'XS0103961743', NULL,
'CLERICAL MEDICAL FIN PLC', 'N', '7.375', NULL, '05-Nov-2019 00:00:00',
'Other', NULL, 'A+', NULL, NULL, 4, 120.214, 5.249, 4.844, NULL, 77, 18),
+(NULL, TIMESTAMP '1993-08-12 00:00:00.000000', NULL, NULL, 'ROYAL BK OF
SCOTLAND PLC', 'N', '9.5', NULL, '12-Aug-2018 00:00:00', 'UT2', '4.75 15',
NULL, NULL, 'N', NULL, 141.635, 5.007, NULL, 80, 54, 19),
+(NULL, TIMESTAMP '1999-07-15 00:00:00.000000', 'XS0099507534', 'LLOYDS',
'LLOYDS TSB BANK PLC', NULL, '6.5', 'Y', '15-Jul-2019 00:00:00', 'UT2', '8
21', 'AA', 'A', NULL, NULL, 113.903, 5.025, NULL, NULL, NULL, 20),
+('Subordinated', NULL, 'XS0222208539', 'BACR', 'BARCLAYS BANK PLC', 'N', '6',
NULL, '15-Dec-2017 00:00:00', 'T1', NULL, 'AA-', 'BBB', NULL, 3, 102.988, NULL,
4.793, 137, 109, 21),
+('Subordinated', TIMESTAMP '1997-04-23 00:00:00.000000', 'XS0075423565',
'HSBC', NULL, NULL, NULL, 'Y', '07-Dec-2007 00:00:00', 'UT2', '4.5 07', 'A+',
'A-', 'Y', 5, NULL, 4.555, 4.492, NULL, 18, 22),
+('Subordinated', TIMESTAMP '2004-12-16 00:00:00.000000', 'XS0208374891',
'BUPA', 'BUPA FINANCE PLC', 'N', NULL, 'Y', '16-Sep-2020 00:00:00', 'Other',
NULL, 'BBB', 'BBB', 'N', 4, 104.427, 5.601, 5.518, 135, 111, 23),
+('Subordinated', TIMESTAMP '1996-07-22 00:00:00.000000', 'XS0067584101',
'SOCGEN', 'SOCIETE GENERALE', 'N', '9.125', NULL, NULL, NULL, '7.5 06', NULL,
'BBB', 'Y', 5, 105.677, 4.778, 4.434, 69, 40, 24),
+(NULL, NULL, 'XS0201559811', 'MQB', 'MACQUARIE CAP FUNDING', NULL, '6.177',
'Y', NULL, 'T1', NULL, NULL, 'A-', 'Y', 3, 108.483, 5.338, 5.507, NULL, 85, 25),
+('Subordinated', TIMESTAMP '2005-06-29 00:00:00.000000', 'XS0223265462',
'STALIF', 'STANDARD LIFE FUNDING BV', NULL, NULL, 'Y', '29-Jun-2015 00:00:00',
NULL, '4.75 15', 'BBB+', 'BBB-', NULL, 4, 102.643, 5.787, 5.142, 158, 130, 26),
+('Subordinated', TIMESTAMP '2004-03-22 00:00:00.000000', 'XS0188550114',
'ALLNCE', 'ALLIANCE & LEICESTER PLC', NULL, '5.827', NULL, '22-Mar-2016
00:00:00', 'T1', '4.75 15', 'A', 'A-', 'Y', 4, 105.239, 5.108, NULL, NULL,
NULL, 27),
+('Subordinated', TIMESTAMP '2005-03-24 00:00:00.000000', 'XS0215556142', NULL,
NULL, 'N', NULL, NULL, '24-Mar-2020 00:00:00', NULL, '8 21', 'BBB', NULL,
NULL, 3, NULL, 5.77, 5.505, 152, 128, 28),
+('Subordinated', TIMESTAMP '2003-09-29 00:00:00.000000', 'XS0177447983',
'AVLN', 'AVIVA PLC', 'N', '6.125', 'Y', '29-Sep-2022 00:00:00', NULL, NULL,
'A-', 'BBB+', NULL, 3, NULL, 5.269, 5.132, NULL, 80, 29),
+('Subordinated', TIMESTAMP '2002-04-19 00:00:00.000000', 'XS0145875190',
'BACR', NULL, 'N', NULL, 'Y', '19-Apr-2017 00:00:00', NULL, NULL, NULL, NULL,
'Y', 3, 111.861, NULL, 4.769, NULL, 47, 30),
+('Subordinated', TIMESTAMP '2003-04-29 00:00:00.000000', 'XS0167366433', NULL,
'N', '5.625', 'Y', '20-Dec-2013 00:00:00', 'UT2', '5 14', NULL, NULL, 'N',
NULL, 102.179, 5.224, NULL, 103, 76, NULL, 31),
+('Subordinated', NULL, 'XS0138939854', NULL, 'ROYAL BK OF SCOTLAND PLC', 'N',
'5.625', 'Y', NULL, 'UT2', NULL, 'AA-', NULL, 'Y', 3, NULL, 5.084, NULL, 85,
67, 32),
+('Subordinated', NULL, 'XS0154144132', 'RBS', 'ROYAL BK OF SCOTLAND PLC',
NULL, NULL, NULL, '16-Sep-2026 00:00:00', 'UT2', NULL, 'AA-', 'A+', 'Y', 4,
106.223, NULL, 4.915, NULL, 61, 33),
+('Subordinated', TIMESTAMP '2001-02-28 00:00:00.000000', 'XS0125686229',
'HBOS', 'BANK OF SCOTLAND', 'N', '7.281', 'Y', '31-May-2026 00:00:00', NULL, '5
25', NULL, NULL, 'Y', 5, 125.351, NULL, 4.952, 102, 80, 34),
+(NULL, TIMESTAMP '2002-07-12 00:00:00.000000', 'XS0151267878', 'STALIF', NULL,
'N', '6.75', NULL, NULL, 'Other', '6 28', 'A-', 'BBB', 'N', 4, 112.604, 5.648,
NULL, 141, 119, 35),
+(NULL, TIMESTAMP '2000-10-30 00:00:00.000000', 'XS0119816402', 'STANLN',
'STANDARD CHARTERED BANK', NULL, NULL, NULL, '31-Jan-2022 00:00:00', 'UT2', '8
21', 'A-', NULL, 'Y', 4, NULL, 5.221, 5.215, NULL, 75, 36),
+('Subordinated', TIMESTAMP '2004-10-21 00:00:00.000000', 'XS0203782551', NULL,
'RABOBANK CAP FD TRUST IV', 'N', '5.556', 'Y', '31-Dec-2019 00:00:00', NULL, '8
21', 'AA', 'AA-', NULL, 4, 106.451, 4.86, NULL, 61, 38, 37),
+(NULL, TIMESTAMP '2000-09-28 00:00:00.000000', NULL, NULL, 'ABBEY NATIONAL
PLC', NULL, '7.5', 'Y', '28-Sep-2010 00:00:00', 'UT2', '4 09', 'A', NULL, 'Y',
NULL, 112.131, 4.754, 4.642, NULL, NULL, 38),
+(NULL, TIMESTAMP '2000-04-17 00:00:00.000000', 'XS0110560165', 'HSBC', 'HSBC
CAPITAL FUNDING LP', 'N', '8.208', NULL, '30-Jun-2015 00:00:00', 'T1', '4.75
15', 'A', 'A-', NULL, 3, 123.375, 5.087, NULL, NULL, 60, 39),
+(NULL, TIMESTAMP '1999-10-05 00:00:00.000000', 'XS0102493680', NULL, 'NATIONAL
WESTMINSTER BK', 'N', '7.125', NULL, '05-Oct-2022 00:00:00', 'UT2', '8 21',
'AA-', NULL, NULL, 4, 122.538, 5.058, NULL, 81, 59, 40),
+('Subordinated', NULL, NULL, NULL, 'FP FINANCE PLC', 'N', NULL, 'Y',
'25-Nov-2006 00:00:00', 'Other', '7.5 06', NULL, 'BBB', 'Y', 5, 105.592,
4.747, 4.439, 66, 36, 41),
+('Subordinated', TIMESTAMP '1993-11-04 00:00:00.000000', NULL, NULL, 'BANK OF
SCOTLAND', 'N', NULL, 'Y', '04-Nov-2013 00:00:00', 'UT2', '5 14', NULL, NULL,
NULL, 4, 123.659, 5.001, 4.674, 80, 53, 42),
+('Subordinated', TIMESTAMP '1999-06-17 00:00:00.000000', 'XS0098556961',
'NRBS', 'NORTHERN ROCK PLC', 'N', '6.75', NULL, '17-Jun-2024 00:00:00', NULL,
'5 25', 'A-', 'A-', 'Y', NULL, 117.298, 5.214, 5.275, 97, NULL, 43),
+('Subordinated', TIMESTAMP '1996-11-28 00:00:00.000000', NULL, 'SLAC', NULL,
'N', '9', 'Y', '28-Nov-2006 00:00:00', 'Other', '7.5 06', NULL, 'BB+', 'Y', 5,
104.649, 5.322, 4.623, NULL, 94, 44),
+(NULL, NULL, 'XS0206633082', NULL, 'ROYAL BK OF SCOTLAND PLC', 'N', '5.5',
'Y', '03-Dec-2019 00:00:00', NULL, NULL, 'AA-', 'A', NULL, 3, 103.945, 5.039,
NULL, 79, 56, 45),
+(NULL, TIMESTAMP '1996-03-21 00:00:00.000000', 'XS0064538647', 'HSBC', NULL,
'N', NULL, 'Y', NULL, 'UT2', NULL, 'A+', NULL, 'Y', 5, 106.164, 4.557, 4.434,
NULL, 17, 46),
+('Subordinated', TIMESTAMP '2004-06-03 00:00:00.000000', NULL, NULL, NULL,
NULL, NULL, 'Y', '08-Sep-2014 00:00:00', 'UT2', '5 14', 'AA-', NULL, NULL,
NULL, 107.517, 4.897, 4.705, 70, 42, 47),
+(NULL, NULL, NULL, NULL, NULL, 'N', '6', 'Y', NULL, 'UT2', '8 21', NULL,
'BBB+', 'N', NULL, 105.528, NULL, 5.011, 111, 88, 48),
+('Subordinated', TIMESTAMP '2003-09-29 00:00:00.000000', 'XS0177395901',
'NAB', 'NATIONAL CAPITAL TRUST', 'N', '5.62', 'Y', '17-Dec-2018 00:00:00',
'T1', '4.75 15', 'A', NULL, 'Y', 4, 104.082, 5.193, NULL, 99, 73, 49),
+('Subordinated', TIMESTAMP '2002-03-28 00:00:00.000000', 'XS0145407507', NULL,
'LLOYDS TSB GROUP PLC', 'N', '6', NULL, '07-Jun-2032 00:00:00', 'UT2', NULL,
NULL, 'A+', 'Y', NULL, 112.178, 5.088, 4.897, 86, 68, 50),
+('Subordinated', TIMESTAMP '2003-04-14 00:00:00.000000', 'XS0166717388',
'HBOS', 'HBOS PLC', 'N', '5.75', 'Y', NULL, 'UT2', '8 21', 'A+', 'A', 'Y', 3,
NULL, 5.142, 4.949, 89, NULL, 51),
+('Subordinated', TIMESTAMP '2001-11-02 00:00:00.000000', 'XS0137784426', NULL,
'ROYAL BK OF SCOTLAND PLC', 'N', '6.25', NULL, '17-Dec-2012 00:00:00', NULL, '5
12', 'AA-', 'A', NULL, 4, 108.577, NULL, NULL, 64, NULL, 52),
+('Subordinated', TIMESTAMP '2002-08-09 00:00:00.000000', 'XS0152838586', NULL,
NULL, NULL, '6.984', 'Y', '09-Feb-2018 00:00:00', NULL, '4.75 15', 'A', 'A-',
NULL, NULL, 116.928, NULL, 5.007, 93, 68, 53),
+(NULL, TIMESTAMP '2001-02-28 00:00:00.000000', NULL, 'HBOS', NULL, 'N',
'7.286', NULL, '31-May-2016 00:00:00', NULL, '4.75 15', 'AA-', 'A-', 'Y',
NULL, 117.699, 5.142, NULL, NULL, 67, 54),
+('Subordinated', TIMESTAMP '2002-07-04 00:00:00.000000', NULL, NULL, 'BARCLAYS
BANK PLC', 'N', NULL, 'Y', '15-Jun-2032 00:00:00', NULL, NULL, 'AA-', 'A', 'Y',
3, 111.263, 5.216, 4.992, 99, 81, 55),
+('Subordinated', TIMESTAMP '2000-10-24 00:00:00.000000', 'XS0118932366',
'BACR', NULL, 'N', '7.125', NULL, '24-Oct-2020 00:00:00', 'UT2', '8 21',
'AA-', 'A', 'Y', NULL, 121.238, 5.026, 4.828, NULL, 54, 56),
+('Subordinated', TIMESTAMP '2000-09-21 00:00:00.000000', NULL, 'NRBS',
'NORTHERN ROCK PLC', NULL, NULL, NULL, '21-Sep-2015 00:00:00', NULL, '4.75
15', 'A-', 'BBB+', NULL, NULL, NULL, 5.21, 5.028, 100, 72, 57),
+('Subordinated', TIMESTAMP '2000-03-14 00:00:00.000000', NULL, 'HBOS', 'BK OF
SCOTLAND CAP FUND', NULL, NULL, NULL, NULL, 'T1', NULL, NULL, 'A-', 'Y', 5,
126.833, NULL, 4.972, NULL, NULL, 58),
+('Subordinated', TIMESTAMP '1999-10-05 00:00:00.000000', 'XS0102493508',
'RBS', 'NATIONAL WESTMINSTER BK', 'N', '7.625', 'Y', NULL, 'UT2', '4 09',
NULL, 'A-', NULL, 4, NULL, 4.721, NULL, NULL, 31, 59),
+('Subordinated', TIMESTAMP '1993-05-12 00:00:00.000000', 'XS0043398519',
'BACR', 'BARCLAYS BANK PLC', 'N', '9.875', 'Y', '12-May-2008 00:00:00', 'UT2',
NULL, 'AA-', 'A-', 'Y', 4, NULL, 4.54, 4.455, 51, 17, 60),
+(NULL, NULL, 'XS0083932144', 'HBOS', NULL, 'N', '7.375', 'Y', NULL, NULL, '8
21', NULL, NULL, 'N', 5, 124.614, 5.135, NULL, 88, NULL, 61),
+('Subordinated', TIMESTAMP '1996-12-11 00:00:00.000000', 'XS0071285760', NULL,
'SKANDINAVISKA ENSKILDA', NULL, NULL, NULL, '11-Dec-2006 00:00:00', 'UT2', '7.5
06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 62),
+('Subordinated', NULL, 'XS0206511486', 'AVLN', 'AVIVA PLC', 'N', '5.902', 'Y',
'27-Jul-2020 00:00:00', 'Other', '8 21', NULL, NULL, 'N', 3, NULL, 5.409,
5.091, 116, 92, 63),
+('Subordinated', TIMESTAMP '1995-08-10 00:00:00.000000', 'XS0059171230', NULL,
NULL, 'N', NULL, 'Y', '10-Aug-2015 00:00:00', NULL, '4.75 15', 'AA-', NULL,
NULL, 5, 139.558, 5.063, NULL, 86, 58, 64),
+('Subordinated', NULL, 'XS0189704140', 'HSBC', NULL, 'N', '5.862', NULL,
'07-Apr-2020 00:00:00', 'T1', NULL, 'A+', 'A-', 'Y', 4, 106.139, NULL, NULL,
93, 70, 65),
+('Subordinated', TIMESTAMP '2003-12-19 00:00:00.000000', 'BE0119284710',
'KBC', 'KBC BANK NV', 'N', '6.202', 'Y', NULL, 'T1', NULL, NULL, 'A-', 'Y',
NULL, 109.073, 5.216, NULL, 97, 74, 66),
+('Subordinated', TIMESTAMP '2003-06-09 00:00:00.000000', NULL, 'LLOYDS',
'LLOYDS TSB BANK PLC', 'N', '5.125', NULL, NULL, 'UT2', '4.75 15', 'AA', NULL,
'Y', 3, 100.849, 4.96, NULL, 75, 49, 67),
+('Subordinated', TIMESTAMP '2002-03-22 00:00:00.000000', 'XS0144810529',
'RBS', 'ROYAL BK OF SCOTLAND PLC', 'N', NULL, 'Y', NULL, NULL, NULL, 'AA-',
'A', 'Y', 3, 111.942, 5.052, 4.855, NULL, NULL, 68),
+(NULL, NULL, 'XS0165122655', 'BKIR', 'BANK OF IRELAND HOLDINGS', 'N', '6.25',
'Y', NULL, NULL, NULL, 'A', 'A-', NULL, 4, 110.37, NULL, 5.108, NULL, NULL, 69),
+('Subordinated', NULL, NULL, 'ANGIRI', 'ANGLO IRISH ASSET FIN', 'N', NULL,
NULL, '28-Jun-2011 00:00:00', 'T1', NULL, 'BBB+', NULL, 'N', NULL, 117.495,
5.097, 5.016, 95, 66, 70),
+(NULL, TIMESTAMP '2002-08-21 00:00:00.000000', NULL, 'NRBS', 'NORTHERN ROCK
PLC', 'N', '7.053', 'Y', '21-Sep-2027 00:00:00', NULL, NULL, 'A-', 'A-', 'Y',
NULL, 119.817, 5.412, NULL, 118, NULL, 71),
+(NULL, NULL, NULL, 'ABBEY', 'ABBEY NATIONAL PLC', 'N', NULL, NULL, NULL, 'T1',
'5 25', 'A', 'A', 'Y', 4, NULL, NULL, NULL, 99, NULL, 72),
+('Subordinated', NULL, 'XS0148995888', 'CRDSUI', 'CRED SUISSE GP FIN (GRN)',
'N', '6.875', 'Y', NULL, NULL, NULL, 'A', 'A-', 'Y', NULL, 113.813, NULL, NULL,
101, 73, 73),
+(NULL, NULL, 'XS0117973429', NULL, 'ABBEY NATIONAL PLC', 'N', '7.125', NULL,
'30-Sep-2030 00:00:00', 'UT2', NULL, 'A', 'A', 'Y', 4, NULL, 5.127, 5.179, 89,
72, 74),
+('Subordinated', TIMESTAMP '2000-08-31 00:00:00.000000', NULL, 'RBS', NULL,
NULL, '7.375', 'Y', '31-Aug-2010 00:00:00', 'UT2', '4 09', 'AA-', 'A-', NULL,
5, 111.546, 4.729, 4.599, 68, 32, 75),
+('Subordinated', NULL, 'XS0109138536', 'HBOS', 'BK OF SCOTLAND CAP FUND', 'N',
'8.117', 'Y', NULL, 'T1', '4 09', 'A+', NULL, NULL, NULL, NULL, NULL, 4.594,
81, 45, 76),
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
