Changeset: 9d95c7e4e7ce for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9d95c7e4e7ce Modified Files: sql/test/BugTracker-2017/Tests/case.Bug-6386.sql sql/test/BugTracker-2017/Tests/case.Bug-6386.stable.out Branch: Jul2017 Log Message:
For the umpteenth time: do not use sys.tables for testing. diffs (77 lines): diff --git a/sql/test/BugTracker-2017/Tests/case.Bug-6386.sql b/sql/test/BugTracker-2017/Tests/case.Bug-6386.sql --- a/sql/test/BugTracker-2017/Tests/case.Bug-6386.sql +++ b/sql/test/BugTracker-2017/Tests/case.Bug-6386.sql @@ -1,1 +1,1 @@ -select case name when 'types' then 1 when 'args' then 60.3281 when 'keys' then 0.8415381117315 else 0 end as t1 from tables; +select case privilege_code_name when 'SELECT' then 1 when 'UPDATE' then 60.3281 when 'INSERT' then 0.8415381117315 else 0 end as t1 from privilege_codes order by privilege_code_id; diff --git a/sql/test/BugTracker-2017/Tests/case.Bug-6386.stable.out b/sql/test/BugTracker-2017/Tests/case.Bug-6386.stable.out --- a/sql/test/BugTracker-2017/Tests/case.Bug-6386.stable.out +++ b/sql/test/BugTracker-2017/Tests/case.Bug-6386.stable.out @@ -24,25 +24,14 @@ Ready. # 18:14:35 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-10620" "--port=33907" # 18:14:35 > -#select case name when 'types' then 1 when 'args' then 60.3281 when 'keys' then 0.8415381117315 else 0 end as t1 from tables; -% .L40 # table_name +#select case privilege_code_name when 'SELECT' then 1 when 'UPDATE' then 60.3281 when 'INSERT' then 0.8415381117315 else 0 end as t1 from privilege_codes order by privilege_code_id; +% sys.L2 # table_name % t1 # name % decimal # type % 18 # length -[ 0.0000000000000 ] [ 1.0000000000000 ] -[ 0.0000000000000 ] [ 60.3281000000000 ] [ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.8415381117315 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] [ 0.8415381117315 ] [ 0.0000000000000 ] [ 0.0000000000000 ] @@ -57,39 +46,6 @@ Ready. [ 0.0000000000000 ] [ 0.0000000000000 ] [ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] -[ 0.0000000000000 ] # 18:14:35 > # 18:14:35 > "Done." _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
