/ Check-in [9ca18a01]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add tests that verify that keywords WITH, WITHOUT, and RECURSIVE can still be used as table and column names.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 9ca18a0191db6a9b0763e2f0b3b35d23099fb71b
User & Date: drh 2014-01-17 16:19:01
Context
2014-01-17
17:40
Resolve table names within CTEs in the context in which the CTE is declared, not the context in which it is used. check-in: a7323838 user: dan tags: trunk
16:19
Add tests that verify that keywords WITH, WITHOUT, and RECURSIVE can still be used as table and column names. check-in: 9ca18a01 user: drh tags: trunk
15:27
Fix a compiler warning in selectPopWith(). check-in: c8eb1163 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to test/keyword1.test.

61
62
63
64
65
66
67

68
69
70
71
72
73
74
..
76
77
78
79
80
81
82


83
84
85
86
87
88
89
  match
  of
  offset
  plan
  pragma
  query
  raise

  regexp
  reindex
  release
  rename
  replace
  restrict
  rollback
................................................................................
  savepoint
  temp
  temporary
  trigger
  vacuum
  view
  virtual


};
set exprkw {
  cast
  current_date
  current_time
  current_timestamp
  raise







>







 







>
>







61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
..
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
  match
  of
  offset
  plan
  pragma
  query
  raise
  recursive
  regexp
  reindex
  release
  rename
  replace
  restrict
  rollback
................................................................................
  savepoint
  temp
  temporary
  trigger
  vacuum
  view
  virtual
  with
  without
};
set exprkw {
  cast
  current_date
  current_time
  current_timestamp
  raise