postgres.git / summary / log / commit / refs

commit    0226cd72ec46ae946db77e9904b5588ca54f3ec6
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Tue Dec 11 16:48:00 2018 +0000
First released in: 12.0, 9.5.16, 9.6.12, 10.7, 11.2

    Fix test_rls_hooks to assign expression collations properly.
    
    This module overlooked this necessary fixup step on the results of
    transformWhereClause().  It accidentally worked anyway, because the
    constructed expression involved type "name" which is not collatable,
    but it fell over while I was experimenting with changing "name" to
    be collatable.
    
    Back-patch, not because there's any live bug here in back branches,
    but because somebody might use this code as a model for some real
    application and then not understand why it doesn't work.


 src/test/modules/test_rls_hooks/test_rls_hooks.c | 5 +++++
 1 file changed, 5 insertions(+)

diff --git a/src/test/modules/test_rls_hooks/test_rls_hooks.c b/src/test/modules/test_rls_hooks/test_rls_hooks.c
index 65bf3e33c90..447971a1785 100644
--- a/src/test/modules/test_rls_hooks/test_rls_hooks.c
+++ b/src/test/modules/test_rls_hooks/test_rls_hooks.c
@@ -22,6 +22,7 @@
 #include <nodes/makefuncs.h>
 #include <nodes/makefuncs.h>
 #include <parser/parse_clause.h>
+#include <parser/parse_collate.h>
 #include <parser/parse_node.h>
 #include <parser/parse_relation.h>
 #include <rewrite/rowsecurity.h>
@@ -107,6 +108,8 @@ test_rls_hooks_permissive(CmdType cmdtype, Relation relation)
 	policy->qual = (Expr *) transformWhereClause(qual_pstate, copyObject(e),
 												 EXPR_KIND_POLICY,
 												 "POLICY");
+	/* Fix up collation information */
+	assign_expr_collations(qual_pstate, (Node *) policy->qual);
 
 	policy->with_check_qual = copyObject(policy->qual);
 	policy->hassublinks = false;
@@ -165,6 +168,8 @@ test_rls_hooks_restrictive(CmdType cmdtype, Relation relation)
 	policy->qual = (Expr *) transformWhereClause(qual_pstate, copyObject(e),
 												 EXPR_KIND_POLICY,
 												 "POLICY");
+	/* Fix up collation information */
+	assign_expr_collations(qual_pstate, (Node *) policy->qual);
 
 	policy->with_check_qual = copyObject(policy->qual);
 	policy->hassublinks = false;


[parent: b10997b5b3ee]