new file mode 100644
--- /dev/null
+++ b/elpa/sql-indent-1.4/test-data/pr42.sql
@@ -0,0 +1,12 @@
+-- sql-indent used to think that the statement begins at the "FOR" keyword in
+-- "V_SPORT_ZONE_FOR_SESSION"
+create view V_SPORT_ZONE_FOR_SESSION as
+  select S.id as session_id,
+         VSZ.zone_id as zone_id,
+         VSZ.zone_metric_id as zone_metric_id
+    from A_SESSION S, V_SPORT_ZONE VSZ
+   where S.sport_id = VSZ.sport_id
+     and (((S.sub_sport_id is null or S.sub_sport_id = 0)
+           and (VSZ.sub_sport_id is null or VSZ.sub_sport_id = 0))
+          or S.sub_sport_id = VSZ.sub_sport_id)
+     and S.start_time between VSZ.valid_from and VSZ.valid_until;