aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPeter Eisentraut <peter_e@gmx.net>2017-04-10 11:18:15 -0400
committerPeter Eisentraut <peter_e@gmx.net>2017-04-10 11:18:15 -0400
commit244f1c89070c1a661623bf1eaddf1307f8f598a3 (patch)
tree4d2485cebe07f5a5ee30400f10ea458fbc18d910
parent511540dadf1166d80b864f63979178f324844060 (diff)
downloadpostgresql-244f1c89070c1a661623bf1eaddf1307f8f598a3.tar.gz
postgresql-244f1c89070c1a661623bf1eaddf1307f8f598a3.zip
Fix whitespace
-rw-r--r--contrib/sepgsql/expected/dml.out4
-rw-r--r--contrib/sepgsql/sql/dml.sql4
2 files changed, 4 insertions, 4 deletions
diff --git a/contrib/sepgsql/expected/dml.out b/contrib/sepgsql/expected/dml.out
index 995e425aca1..31243c723b4 100644
--- a/contrib/sepgsql/expected/dml.out
+++ b/contrib/sepgsql/expected/dml.out
@@ -257,7 +257,7 @@ ERROR: SELinux: security policy violation
---
-- partitioned table parent
UPDATE t1p SET o = 9 WHERE o < 10; -- ok
-UPDATE t1p SET o = 99 WHERE o >= 10; -- ok
+UPDATE t1p SET o = 99 WHERE o >= 10; -- ok
UPDATE t1p SET o = ascii(COALESCE(p,'upd'))%10 WHERE o < 10; -- ok
UPDATE t1p SET o = ascii(COALESCE(q,'upd'))%100 WHERE o >= 10; -- failed
ERROR: SELinux: security policy violation
@@ -266,7 +266,7 @@ UPDATE t1p_ones SET o = 9; -- ok
UPDATE t1p_ones SET o = ascii(COALESCE(p,'upd'))%10; -- ok
UPDATE t1p_ones SET o = ascii(COALESCE(q,'upd'))%10; -- failed
ERROR: SELinux: security policy violation
-UPDATE t1p_tens SET o = 99; -- ok
+UPDATE t1p_tens SET o = 99; -- ok
UPDATE t1p_tens SET o = ascii(COALESCE(p,'upd'))%100; -- ok
UPDATE t1p_tens SET o = ascii(COALESCE(q,'upd'))%100; -- failed
ERROR: SELinux: security policy violation
diff --git a/contrib/sepgsql/sql/dml.sql b/contrib/sepgsql/sql/dml.sql
index fc318110faf..19201f4b90b 100644
--- a/contrib/sepgsql/sql/dml.sql
+++ b/contrib/sepgsql/sql/dml.sql
@@ -158,14 +158,14 @@ UPDATE t5 SET e = g || '_upd'; -- failed
---
-- partitioned table parent
UPDATE t1p SET o = 9 WHERE o < 10; -- ok
-UPDATE t1p SET o = 99 WHERE o >= 10; -- ok
+UPDATE t1p SET o = 99 WHERE o >= 10; -- ok
UPDATE t1p SET o = ascii(COALESCE(p,'upd'))%10 WHERE o < 10; -- ok
UPDATE t1p SET o = ascii(COALESCE(q,'upd'))%100 WHERE o >= 10; -- failed
-- partitioned table children
UPDATE t1p_ones SET o = 9; -- ok
UPDATE t1p_ones SET o = ascii(COALESCE(p,'upd'))%10; -- ok
UPDATE t1p_ones SET o = ascii(COALESCE(q,'upd'))%10; -- failed
-UPDATE t1p_tens SET o = 99; -- ok
+UPDATE t1p_tens SET o = 99; -- ok
UPDATE t1p_tens SET o = ascii(COALESCE(p,'upd'))%100; -- ok
UPDATE t1p_tens SET o = ascii(COALESCE(q,'upd'))%100; -- failed
---