Changeset: 4509f22a0e78 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4509f22a0e78 Modified Files: sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.sql sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out Branch: Dec2016 Log Message:
Add casts to oid to prevent errors such as: overflow in conversion of 780 to bte. Strangely qtag and tag do not have the same type (qtag is a bigint, tag is an oid). diffs (49 lines): diff --git a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.sql b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.sql --- a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.sql +++ b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.sql @@ -90,8 +90,8 @@ SELECT * FROM sys.db_user_info WHERE def SELECT * FROM sys.user_role WHERE login_id NOT IN (SELECT id FROM sys.auths); SELECT * FROM sys.user_role WHERE login_id NOT IN (SELECT a.id FROM sys.auths a WHERE a.name IN (SELECT u.name FROM sys.users u)); +SELECT * FROM sys.user_role WHERE role_id NOT IN (SELECT id FROM sys.auths); SELECT * FROM sys.user_role WHERE role_id NOT IN (SELECT a.id FROM sys.auths a WHERE a.name NOT IN (SELECT u.name FROM sys.users u)); -SELECT * FROM sys.user_role WHERE role_id NOT IN (SELECT id FROM sys.auths); SELECT * FROM sys.privileges WHERE auth_id NOT IN (SELECT id FROM sys.auths); SELECT * FROM sys.privileges WHERE grantor NOT IN (SELECT id FROM sys.auths) AND grantor > 0; @@ -105,7 +105,7 @@ SELECT * FROM sys.querylog_history WHERE SELECT * FROM sys.querylog_history WHERE owner NOT IN (SELECT name FROM sys.users); SELECT * FROM sys.querylog_history WHERE pipe NOT IN (SELECT name FROM sys.optimizers); -SELECT * FROM sys.queue WHERE tag > 0 AND tag NOT IN (SELECT qtag FROM sys.queue); +SELECT * FROM sys.queue WHERE tag > cast(0 as oid) AND tag NOT IN (SELECT cast(qtag as oid) FROM sys.queue); SELECT * FROM sys.queue WHERE "user" NOT IN (SELECT name FROM sys.users); SELECT * FROM sys.sessions WHERE "user" NOT IN (SELECT name FROM sys.users); diff --git a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out --- a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out +++ b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out @@ -299,12 +299,12 @@ Ready. % login_id, role_id # name % int, int # type % 1, 1 # length -#SELECT * FROM sys.user_role WHERE role_id NOT IN (SELECT a.id FROM sys.auths a WHERE a.name NOT IN (SELECT u.name FROM sys.users u)); +#SELECT * FROM sys.user_role WHERE role_id NOT IN (SELECT id FROM sys.auths); % sys.user_role, sys.user_role # table_name % login_id, role_id # name % int, int # type % 1, 1 # length -#SELECT * FROM sys.user_role WHERE role_id NOT IN (SELECT id FROM sys.auths); +#SELECT * FROM sys.user_role WHERE role_id NOT IN (SELECT a.id FROM sys.auths a WHERE a.name NOT IN (SELECT u.name FROM sys.users u)); % sys.user_role, sys.user_role # table_name % login_id, role_id # name % int, int # type @@ -354,7 +354,7 @@ Ready. % id, owner, defined, query, pipe, plan, mal, optimize, start, stop, arguments, tuples, run, ship, cpu, io # name % oid, clob, timestamp, clob, clob, clob, int, bigint, timestamp, timestamp, clob, bigint, bigint, bigint, int, int # type % 3, 0, 26, 0, 0, 0, 1, 1, 26, 26, 0, 1, 1, 1, 1, 1 # length -#SELECT * FROM sys.queue WHERE tag > 0 AND tag NOT IN (SELECT qtag FROM sys.queue); +#SELECT * FROM sys.queue WHERE tag > cast(0 as oid) AND tag NOT IN (SELECT cast(qtag as oid) FROM sys.queue); % .queue, .queue, .queue, .queue, .queue, .queue, .queue, .queue # table_name % qtag, user, started, estimate, progress, status, tag, query # name % bigint, clob, timestamp, timestamp, int, clob, oid, clob # type _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
