diff options
| author | ptmcg <ptmcg@austin.rr.com> | 2022-04-30 14:36:51 -0500 |
|---|---|---|
| committer | ptmcg <ptmcg@austin.rr.com> | 2022-04-30 14:36:51 -0500 |
| commit | 17a39e8e3739f956b74031731966160938858bcd (patch) | |
| tree | 356cba57824d2eec380f20e0acf8558da62a953a /examples | |
| parent | 0ec8031ba42d3475afb906c64894538cca8d4c52 (diff) | |
| download | pyparsing-git-17a39e8e3739f956b74031731966160938858bcd.tar.gz | |
Added test case to bigquery_view_parser.py from #291
Diffstat (limited to 'examples')
| -rw-r--r-- | examples/bigquery_view_parser.py | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/examples/bigquery_view_parser.py b/examples/bigquery_view_parser.py index 3ab13f3..9215225 100644 --- a/examples/bigquery_view_parser.py +++ b/examples/bigquery_view_parser.py @@ -1775,6 +1775,12 @@ if __name__ == "__main__": (None, 'bigquery-public-data:samples', 'wikipedia'), ] ], + [ + """\ + with t as (select CASE when EXTRACT(dayofweek FROM CURRENT_DATETIME()) == 1 then "S" end) select * from t + """, + [], + ], ] # fmt: on |