You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by jh...@apache.org on 2016/05/17 23:19:04 UTC
calcite git commit: Fix typo in SQL (Yi Xinglu)
Repository: calcite
Updated Branches:
refs/heads/master a15aa88bb -> 720b117ed
Fix typo in SQL (Yi Xinglu)
Close apache/calcite#231
Project: http://git-wip-us.apache.org/repos/asf/calcite/repo
Commit: http://git-wip-us.apache.org/repos/asf/calcite/commit/720b117e
Tree: http://git-wip-us.apache.org/repos/asf/calcite/tree/720b117e
Diff: http://git-wip-us.apache.org/repos/asf/calcite/diff/720b117e
Branch: refs/heads/master
Commit: 720b117ed4c4096b274d636711245f583b3e9826
Parents: a15aa88
Author: Yi Xinglu <yx...@gmail.com>
Authored: Mon May 16 21:23:39 2016 +0800
Committer: Julian Hyde <jh...@apache.org>
Committed: Tue May 17 16:18:36 2016 -0700
----------------------------------------------------------------------
site/_docs/stream.md | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/calcite/blob/720b117e/site/_docs/stream.md
----------------------------------------------------------------------
diff --git a/site/_docs/stream.md b/site/_docs/stream.md
index 63bdfcb..393bbad 100644
--- a/site/_docs/stream.md
+++ b/site/_docs/stream.md
@@ -819,7 +819,7 @@ the ship date is within one hour of the order date:
SELECT STREAM o.rowtime, o.productId, o.orderId, s.rowtime AS shipTime
FROM Orders AS o
JOIN Shipments AS s
- ON o.orderId = p.orderId
+ ON o.orderId = s.orderId
AND s.rowtime BETWEEN o.rowtime AND o.rowtime + INTERVAL '1' HOUR;
rowtime | productId | orderId | shipTime