Changeset: 145a7317d652 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=145a7317d652 Modified Files: sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.out Branch: Jun2020 Log Message:
Force an order on the output. diffs (64 lines): diff --git a/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql b/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql --- a/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql +++ b/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql @@ -18,6 +18,6 @@ 0.809 0.504 -select (temp_table.mmax - temp_table.mmin)+temp_table.mmin from temp_value, temp_table where temp_value.vvalue<=temp_table.norm_max and temp_value.vvalue>temp_table.norm_min; -select (0.72/2147483648.0)*(temp_table.mmax - temp_table.mmin)+temp_table.mmin from temp_value, temp_table where temp_value.vvalue<=temp_table.norm_max and temp_value.vvalue>temp_table.norm_min; +select (temp_table.mmax - temp_table.mmin)+temp_table.mmin as col1 from temp_value, temp_table where temp_value.vvalue<=temp_table.norm_max and temp_value.vvalue>temp_table.norm_min order by col1; +select (0.72/2147483648.0)*(temp_table.mmax - temp_table.mmin)+temp_table.mmin as col1 from temp_value, temp_table where temp_value.vvalue<=temp_table.norm_max and temp_value.vvalue>temp_table.norm_min order by col1; rollback; diff --git a/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.out b/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.out --- a/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.out +++ b/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.out @@ -28,35 +28,35 @@ stdout of test 'select-and.Bug-6878` in #0.809 #0.504 [ 10 ] -#select (temp_table.mmax - temp_table.mmin)+temp_table.mmin from temp_value, temp_table where temp_value.vvalue<=temp_table.norm_max and temp_value.vvalue>temp_table.norm_min; -% sys.%1 # table_name -% %1 # name +#select (temp_table.mmax - temp_table.mmin)+temp_table.mmin as col1 from temp_value, temp_table where temp_value.vvalue<=temp_table.norm_max and temp_value.vvalue>temp_table.norm_min order by col1; +% sys. # table_name +% col1 # name % double # type % 24 # length +[ 12.25 ] +[ 24.75 ] +[ 24.75 ] [ 24.75 ] [ 24.75 ] [ 31 ] [ 31 ] [ 31 ] -[ 12.25 ] +[ 31 ] [ 31 ] -[ 24.75 ] -[ 24.75 ] -[ 31 ] -#select (0.72/2147483648.0)*(temp_table.mmax - temp_table.mmin)+temp_table.mmin from temp_value, temp_table where temp_value.vvalue<=temp_table.norm_max and temp_value.vvalue>temp_table.norm_min; -% .%1 # table_name -% %1 # name +#select (0.72/2147483648.0)*(temp_table.mmax - temp_table.mmin)+temp_table.mmin as col1 from temp_value, temp_table where temp_value.vvalue<=temp_table.norm_max and temp_value.vvalue>temp_table.norm_min order by col1; +% . # table_name +% col1 # name % double # type % 24 # length +[ 6 ] +[ 18.5 ] +[ 18.5 ] [ 18.5 ] [ 18.5 ] [ 24.75 ] [ 24.75 ] [ 24.75 ] -[ 6 ] [ 24.75 ] -[ 18.5 ] -[ 18.5 ] [ 24.75 ] #rollback; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
