Changeset: 3ed775f2d65a for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3ed775f2d65a Modified Files: sql/test/pg_regress/Tests/oid.stable.out sql/test/pg_regress/Tests/oid.stable.out.oid32 Branch: default Log Message:
Corrected and approved output oid.sql stable tests based on testweb reports diffs (112 lines): diff --git a/sql/test/pg_regress/Tests/oid.stable.out b/sql/test/pg_regress/Tests/oid.stable.out --- a/sql/test/pg_regress/Tests/oid.stable.out +++ b/sql/test/pg_regress/Tests/oid.stable.out @@ -48,7 +48,7 @@ Ready. [ 1 ] #INSERT INTO OID_TBL(f1) VALUES (null); [ 1 ] -#SELECT '' AS nine, OID_TBL.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL; +#SELECT '' AS ten, OID_TBL.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL; % .L, sys.oid_tbl, sys.L1 # table_name % ten, f1, oid2str # name % char, oid, varchar # type @@ -122,7 +122,7 @@ Ready. [ "", 5@0, "5@0" ] [ "", 10@0, "10@0" ] [ "", 15@0, "15@0" ] -#SELECT '' AS six, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o WHERE o.f1 <= '1234'; +#SELECT '' AS seven, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o WHERE o.f1 <> '1234'; % .L, sys.o, sys.L1 # table_name % seven, f1, oid2str # name % char, oid, varchar # type @@ -138,42 +138,63 @@ Ready. % .L1, sys.o, sys.L2 # table_name % six, f1, oid2str # name % char, oid, varchar # type -% 0, 4, 4 # length +% 0, 6, 6 # length +[ "", 1234@0, "1234@0" ] +[ "", 987@0, "987@0" ] +[ "", 0@0, "0@0" ] +[ "", 5@0, "5@0" ] [ "", 10@0, "10@0" ] [ "", 15@0, "15@0" ] #SELECT '' AS six, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o WHERE o.f1 <= 1234@0; % .L, sys.o, sys.L1 # table_name % six, f1, oid2str # name % char, oid, varchar # type -% 0, 4, 4 # length +% 0, 6, 6 # length +[ "", 1234@0, "1234@0" ] +[ "", 987@0, "987@0" ] +[ "", 0@0, "0@0" ] +[ "", 5@0, "5@0" ] [ "", 10@0, "10@0" ] [ "", 15@0, "15@0" ] #SELECT '' AS six, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o WHERE o.f1 <= '1234'; % .L, sys.o, sys.L1 # table_name % six, f1, oid2str # name % char, oid, varchar # type -% 0, 4, 4 # length +% 0, 6, 6 # length +[ "", 1234@0, "1234@0" ] +[ "", 987@0, "987@0" ] +[ "", 0@0, "0@0" ] +[ "", 5@0, "5@0" ] [ "", 10@0, "10@0" ] [ "", 15@0, "15@0" ] #SELECT '' AS five, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o WHERE o.f1 < cast(1234 as oid); % .L1, sys.o, sys.L2 # table_name % five, f1, oid2str # name % char, oid, varchar # type -% 0, 4, 4 # length +% 0, 5, 5 # length +[ "", 987@0, "987@0" ] +[ "", 0@0, "0@0" ] +[ "", 5@0, "5@0" ] [ "", 10@0, "10@0" ] [ "", 15@0, "15@0" ] #SELECT '' AS five, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o WHERE o.f1 < 1234@0; % .L, sys.o, sys.L1 # table_name % five, f1, oid2str # name % char, oid, varchar # type -% 0, 4, 4 # length +% 0, 5, 5 # length +[ "", 987@0, "987@0" ] +[ "", 0@0, "0@0" ] +[ "", 5@0, "5@0" ] [ "", 10@0, "10@0" ] [ "", 15@0, "15@0" ] #SELECT '' AS five, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o WHERE o.f1 < '1234'; % .L, sys.o, sys.L1 # table_name % five, f1, oid2str # name % char, oid, varchar # type -% 0, 4, 4 # length +% 0, 5, 5 # length +[ "", 987@0, "987@0" ] +[ "", 0@0, "0@0" ] +[ "", 5@0, "5@0" ] [ "", 10@0, "10@0" ] [ "", 15@0, "15@0" ] #SELECT '' AS three, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o WHERE o.f1 >= cast(1234 as oid); diff --git a/sql/test/pg_regress/Tests/oid.stable.out.oid32 b/sql/test/pg_regress/Tests/oid.stable.out.oid32 --- a/sql/test/pg_regress/Tests/oid.stable.out.oid32 +++ b/sql/test/pg_regress/Tests/oid.stable.out.oid32 @@ -46,7 +46,7 @@ Ready. [ 1 ] #INSERT INTO OID_TBL(f1) VALUES (null); [ 1 ] -#SELECT '' AS nine, OID_TBL.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL; +#SELECT '' AS ten, OID_TBL.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL; % .L, sys.oid_tbl, sys.L1 # table_name % ten, f1, oid2str # name % char, oid, varchar # type @@ -116,7 +116,7 @@ Ready. [ "", 5@0, "5@0" ] [ "", 10@0, "10@0" ] [ "", 15@0, "15@0" ] -#SELECT '' AS six, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o WHERE o.f1 <= '1234'; +#SELECT '' AS seven, o.*, cast(f1 as varchar(30)) as oid2str FROM OID_TBL o WHERE o.f1 <> '1234'; % .L, sys.o, sys.L1 # table_name % seven, f1, oid2str # name % char, oid, varchar # type _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
