Changeset: 4a81b6466e70 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4a81b6466e70 Modified Files: sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part1.test sql/test/BugTracker-2015/Tests/reserved_keywords.Bug-3613.test sql/test/BugTracker/Tests/range_select.SF-1907006.test Branch: clean_parser Log Message:
fixed queries (ie use correct syntax) diffs (50 lines): diff --git a/sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part1.test b/sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part1.test --- a/sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part1.test +++ b/sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part1.test @@ -71,6 +71,6 @@ select actiontype, propertytype, loanpur ---- query TTT rowsort -select tables.name, columns.name, location from tables inner join columns on tables.id=columns.table_id left join storage on tables.name=storage.table and columns.name=storage.column where location is null and tables.name like 'hmda%' +select tables.name, columns.name, location from tables inner join columns on tables.id=columns.table_id left join storage on tables.name=storage."table" and columns.name=storage."column" where location is null and tables.name like 'hmda%' ---- diff --git a/sql/test/BugTracker-2015/Tests/reserved_keywords.Bug-3613.test b/sql/test/BugTracker-2015/Tests/reserved_keywords.Bug-3613.test --- a/sql/test/BugTracker-2015/Tests/reserved_keywords.Bug-3613.test +++ b/sql/test/BugTracker-2015/Tests/reserved_keywords.Bug-3613.test @@ -25,7 +25,7 @@ select distinct action from sys.sql_keyw 1 query I rowsort -select distinct as from sys.sql_keywords +select distinct "as" as as from sys.sql_keywords ---- 2 @@ -35,7 +35,7 @@ select distinct authorization from sys.s 3 query I rowsort -select distinct column from sys.sql_keywords +select distinct "column" column from sys.sql_keywords ---- 4 @@ -85,7 +85,7 @@ select distinct statement from sys.sql_k 13 query I rowsort -select distinct table from sys.sql_keywords +select distinct "table" table from sys.sql_keywords ---- 14 diff --git a/sql/test/BugTracker/Tests/range_select.SF-1907006.test b/sql/test/BugTracker/Tests/range_select.SF-1907006.test --- a/sql/test/BugTracker/Tests/range_select.SF-1907006.test +++ b/sql/test/BugTracker/Tests/range_select.SF-1907006.test @@ -1,4 +1,4 @@ query T rowsort -select name from tables where 0<id>10 +select name from sys._tables where 0<id and id<10 ---- _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
