Changeset: cdb5f4604dd0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cdb5f4604dd0 Added Files: sql/test/BugTracker-2020/Tests/view_with_aggr_column.Bug-7023.sql sql/test/BugTracker-2020/Tests/view_with_aggr_column.Bug-7023.stable.err sql/test/BugTracker-2020/Tests/view_with_aggr_column.Bug-7023.stable.out Modified Files: sql/test/BugTracker-2020/Tests/All Branch: Oct2020 Log Message:
Added test and expected out,err for Bug-7023 diffs (69 lines): diff --git a/sql/test/BugTracker-2020/Tests/All b/sql/test/BugTracker-2020/Tests/All --- a/sql/test/BugTracker-2020/Tests/All +++ b/sql/test/BugTracker-2020/Tests/All @@ -37,3 +37,4 @@ release_old_savepoint.Bug-7020 savepoints_crash_mserver5_1.Bug-7021 savepoints_crash_mserver5_2.Bug-7021 transaction_with_unreleased_savepoint.Bug-7022 +view_with_aggr_column.Bug-7023 diff --git a/sql/test/BugTracker-2020/Tests/view_with_aggr_column.Bug-7023.sql b/sql/test/BugTracker-2020/Tests/view_with_aggr_column.Bug-7023.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/view_with_aggr_column.Bug-7023.sql @@ -0,0 +1,6 @@ +create table tst (k integer not null, name char(20) not null); +-- this works +select min(k) from tst group by name; +-- but putting it in a VIEW doesn't +create view v1 as select max(k) from tst group by name; +select * from v1; diff --git a/sql/test/BugTracker-2020/Tests/view_with_aggr_column.Bug-7023.stable.err b/sql/test/BugTracker-2020/Tests/view_with_aggr_column.Bug-7023.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/view_with_aggr_column.Bug-7023.stable.err @@ -0,0 +1,16 @@ +stderr of test 'view_with_aggr_column.Bug-7023` in directory 'sql/test/BugTracker-2020` itself: + + +# 15:22:56 > +# 15:22:56 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-177928" "--port=37553" +# 15:22:56 > + +MAPI = (monetdb) /var/tmp/mtest-177928/.s.monetdb.37553 +QUERY = select * from v1; + +CODE = 42000 + +# 15:22:56 > +# 15:22:56 > "Done." +# 15:22:56 > + diff --git a/sql/test/BugTracker-2020/Tests/view_with_aggr_column.Bug-7023.stable.out b/sql/test/BugTracker-2020/Tests/view_with_aggr_column.Bug-7023.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/view_with_aggr_column.Bug-7023.stable.out @@ -0,0 +1,24 @@ +stdout of test 'view_with_aggr_column.Bug-7023` in directory 'sql/test/BugTracker-2020` itself: + + +# 15:22:56 > +# 15:22:56 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-177928" "--port=37553" +# 15:22:56 > + +#create table tst (k integer not null, name char(20) not null); +#select min(k) from tst group by name; +% sys.%1 # table_name +% %1 # name +% int # type +% 1 # length +#create view v1 as select max(k) from tst group by name; +#select * from v1; +% sys.%1 # table_name +% %1 # name +% int # type +% 1 # length + +# 15:22:56 > +# 15:22:56 > "Done." +# 15:22:56 > + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
