Changeset: a1b0ee2b5f7b for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a1b0ee2b5f7b Modified Files: sql/test/pg_regress/Tests/case.sql sql/test/pg_regress/Tests/case.stable.out Branch: default Log Message:
Added order by and distinct to select query to produce stable and smaller output diffs (116 lines): diff --git a/sql/test/pg_regress/Tests/case.sql b/sql/test/pg_regress/Tests/case.sql --- a/sql/test/pg_regress/Tests/case.sql +++ b/sql/test/pg_regress/Tests/case.sql @@ -109,16 +109,16 @@ SELECT * FROM CASE_TBL WHERE COALESCE(f, SELECT * FROM CASE_TBL WHERE NULLIF(f,i) = 2; -SELECT COALESCE(a.f, b.i, b.j) - FROM CASE_TBL a, CASE2_TBL b; +SELECT distinct COALESCE(a.f, b.i, b.j) + FROM CASE_TBL a, CASE2_TBL b Order By COALESCE(a.f, b.i, b.j); SELECT * FROM CASE_TBL a, CASE2_TBL b WHERE COALESCE(a.f, b.i, b.j) = 2; -SELECT '' AS Five, NULLIF(a.i,b.i) AS "NULLIF(a.i,b.i)", +SELECT distinct '' AS Siksteen, NULLIF(a.i,b.i) AS "NULLIF(a.i,b.i)", NULLIF(b.i, 4) AS "NULLIF(b.i,4)" - FROM CASE_TBL a, CASE2_TBL b; + FROM CASE_TBL a, CASE2_TBL b Order By 2,3; SELECT '' AS "Two", * FROM CASE_TBL a, CASE2_TBL b diff --git a/sql/test/pg_regress/Tests/case.stable.out b/sql/test/pg_regress/Tests/case.stable.out --- a/sql/test/pg_regress/Tests/case.stable.out +++ b/sql/test/pg_regress/Tests/case.stable.out @@ -195,37 +195,19 @@ Ready. % i, f # name % int, double # type % 1, 24 # length -#SELECT COALESCE(a.f, b.i, b.j) -# FROM CASE_TBL a, CASE2_TBL b; -% sys.L # table_name -% isnull_not_isnull_f # name +#SELECT distinct COALESCE(a.f, b.i, b.j) +# FROM CASE_TBL a, CASE2_TBL b Order By COALESCE(a.f, b.i, b.j); +% sys.L1 # table_name +% L1 # name % double # type % 24 # length -[ 10.1 ] -[ 20.2 ] [ -30.3 ] +[ -6 ] [ 1 ] -[ 10.1 ] -[ 20.2 ] -[ -30.3 ] [ 2 ] -[ 10.1 ] -[ 20.2 ] -[ -30.3 ] [ 3 ] [ 10.1 ] [ 20.2 ] -[ -30.3 ] -[ 2 ] -[ 10.1 ] -[ 20.2 ] -[ -30.3 ] -[ 1 ] -[ 10.1 ] -[ 20.2 ] -[ -30.3 ] -[ -6 ] - #SELECT * # FROM CASE_TBL a, CASE2_TBL b # WHERE COALESCE(a.f, b.i, b.j) = 2; @@ -239,33 +221,25 @@ Ready. # NULLIF(b.i, 4) AS "NULLIF(b.i,4)" # FROM CASE_TBL a, CASE2_TBL b; % .L, sys.L, sys.L # table_name -% five, "NULLIF(a.i,b.i)", "NULLIF(b.i,4)" # name +% siksteen, "NULLIF(a.i,b.i)", "NULLIF(b.i,4)" # name % char, int, int # type % 0, 1, 1 # length [ "", NULL, 1 ] -[ "", 2, 1 ] -[ "", 3, 1 ] -[ "", 4, 1 ] -[ "", 1, 2 ] [ "", NULL, 2 ] -[ "", 3, 2 ] -[ "", 4, 2 ] -[ "", 1, 3 ] -[ "", 2, 3 ] [ "", NULL, 3 ] -[ "", 4, 3 ] -[ "", 1, 2 ] -[ "", NULL, 2 ] +[ "", 1, NULL ] +[ "", 1, 2 ] +[ "", 1, 3 ] +[ "", 2, NULL ] +[ "", 2, 1 ] +[ "", 2, 3 ] +[ "", 3, NULL ] +[ "", 3, 1 ] [ "", 3, 2 ] +[ "", 4, NULL ] +[ "", 4, 1 ] [ "", 4, 2 ] -[ "", NULL, 1 ] -[ "", 2, 1 ] -[ "", 3, 1 ] -[ "", 4, 1 ] -[ "", 1, NULL ] -[ "", 2, NULL ] -[ "", 3, NULL ] -[ "", 4, NULL ] +[ "", 4, 3 ] #SELECT '' AS "Two", * # FROM CASE_TBL a, CASE2_TBL b # WHERE COALESCE(f,b.i) = 2; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
