Changeset: 4e1d921eba80 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4e1d921eba80 Modified Files: sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.err sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.out Branch: default Log Message:
approved output, ie column aliases done work in the where part diffs (72 lines): diff --git a/sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.err b/sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.err --- a/sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.err +++ b/sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.err @@ -28,6 +28,18 @@ stderr of test 'column_alias_in_where_cl # 12:19:54 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-12389" "--port=31701" # 12:19:54 > +MAPI = (monetdb) /var/tmp/mtest-8448/.s.monetdb.34393 +QUERY = SELECT a AS "A", b AS "B", c AS "C" FROM t_alias WHERE "A" < "B"; +ERROR = !SELECT: identifier 'A' unknown +MAPI = (monetdb) /var/tmp/mtest-8448/.s.monetdb.34393 +QUERY = SELECT a AS "A", b * b AS "B", c AS "C" FROM t_alias WHERE "B" >99; +ERROR = !SELECT: identifier 'B' unknown +MAPI = (monetdb) /var/tmp/mtest-8448/.s.monetdb.34393 +QUERY = SELECT a AS "A", b AS "B", c AS "C" FROM t_alias WHERE "C" LIKE '%en'; +ERROR = !SELECT: identifier 'C' unknown +MAPI = (monetdb) /var/tmp/mtest-8448/.s.monetdb.34393 +QUERY = SELECT cast(null as char(1)) AS "CAT", a AS "A", c AS "C" FROM t_alias WHERE "CAT" = 'null'; +ERROR = !SELECT: identifier 'CAT' unknown # 12:19:54 > # 12:19:54 > "Done." diff --git a/sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.out b/sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.out --- a/sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.out +++ b/sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.out @@ -83,46 +83,23 @@ Ready. % 2, 2, 4 # length [ 1, 10, "tien" ] [ 11, 2, "elf" ] -#SELECT a AS "A", b AS "B", c AS "C" FROM t_alias WHERE "A" < "B"; -% sys.L, sys.L, sys.L # table_name -% A, B, C # name -% int, int, varchar # type -% 1, 2, 4 # length -[ 1, 10, "tien" ] #SELECT a AS "A", b * b AS "B", c AS "C" FROM t_alias WHERE "b" * b >99; % sys.L, sys.L, sys.L # table_name % A, B, C # name % int, bigint, varchar # type % 1, 3, 4 # length [ 1, 100, "tien" ] -#SELECT a AS "A", b * b AS "B", c AS "C" FROM t_alias WHERE "B" >99; -% sys.L, sys.L, sys.L # table_name -% A, B, C # name -% int, bigint, varchar # type -% 1, 3, 4 # length -[ 1, 100, "tien" ] #SELECT a AS "A", b AS "B", c AS "C" FROM t_alias WHERE "c" LIKE '%en'; % sys.L, sys.L, sys.L # table_name % A, B, C # name % int, int, varchar # type % 1, 2, 4 # length [ 1, 10, "tien" ] -#SELECT a AS "A", b AS "B", c AS "C" FROM t_alias WHERE "C" LIKE '%en'; -% sys.L, sys.L, sys.L # table_name -% A, B, C # name -% int, int, varchar # type -% 1, 2, 4 # length -[ 1, 10, "tien" ] #SELECT cast(null as char(1)) AS "CAT", a AS "A", c AS "C" FROM t_alias WHERE "c" = 'null'; % .L1, sys.L1, sys.L1 # table_name % CAT, A, C # name % char, int, varchar # type % 1, 1, 0 # length -#SELECT cast(null as char(1)) AS "CAT", a AS "A", c AS "C" FROM t_alias WHERE "CAT" = 'null'; -% .L1, sys.L1, sys.L1 # table_name -% CAT, A, C # name -% char, int, varchar # type -% 1, 1, 0 # length #SELECT a AS "A", b AS "B", c AS "C" FROM t_alias ORDER BY "C", "A", "B"; % sys.L, sys.L, sys.L # table_name % A, B, C # name _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list