Jira (PDB-3366) Confusing error message when projected column is omitted from explicit subquery
Title: Message Title Wyatt Alt updated an issue PuppetDB / PDB-3366 Confusing error message when projected column is omitted from explicit subquery Change By: Wyatt Alt Note (Wyatt): The fix to the issue described here is in the comment, however it would be nice if we could return a friendlier error when this mistake is made.The following command causes a 500 internal server error. Stack trace pasted below. This happens on PE 2017.1*Query:*{code:java}puppet query 'facts { name = "no_blank_passwords" and name in fact_contents { path ~> [".*", "result"] and value = "pass"} }'{code}*Stacktrace*{code:java}java.lang.AssertionError: Assert failed: (= (count columns) (count projected-fields)) at puppetlabs.puppetdb.query_eng.engine$fix_in_expr_multi_comparisons.invokeStatic(engine.clj:2121) at puppetlabs.puppetdb.query_eng.engine$fix_in_expr_multi_comparisons.invoke(engine.clj:2117) at puppetlabs.puppetdb.query_eng.engine$fix_plan_in_expr_multi_comparisons$fix_node__27503.invoke(engine.clj:2144) at puppetlabs.puppetdb.zip$post_order_transform$fn__26179$fn__26180.invoke(zip.clj:103) at puppetlabs.puppetdb.zip$post_order_visit$fn__26174$fn__26175.invoke(zip.clj:92) at fast_zip.visit$visit_node.invokeStatic(visit.clj:11) at fast_zip.visit$visit_node.invoke(visit.clj:5) at fast_zip.visit$visit_location.invokeStatic(visit.clj:22) at fast_zip.visit$visit_location.invoke(visit.clj:19) at fast_zip.visit$visit.invokeStatic(visit.clj:52) at fast_zip.visit$visit.invoke(visit.clj:32) at puppetlabs.puppetdb.zip$post_order_visit.invokeStatic(zip.clj:87) at puppetlabs.puppetdb.zip$post_order_visit.invoke(zip.clj:82) at puppetlabs.puppetdb.zip$post_order_transform.invokeStatic(zip.clj:99) at puppetlabs.puppetdb.zip$post_order_transform.invoke(zip.clj:94) at puppetlabs.puppetdb.query_eng.engine$fix_plan_in_expr_multi_comparisons$fn__27505.invoke(engine.clj:2149) at clojure.core$update.invokeStatic(core.clj:5960) at clojure.core$update.invoke(core.clj:5952) at puppetlabs.puppetdb.query_eng.engine$fix_plan_in_expr_multi_comparisons.invokeStatic(engine.clj:2146) at puppetlabs.puppetdb.query_eng.engine$fix_plan_in_expr_multi_comparisons.invoke(engine.clj:2136) at puppetlabs.puppetdb.query_eng.engine$compile_user_query__GT_sql.invokeStatic(engine.clj:2171) at puppetlabs.puppetdb.query_eng.engine$compile_user_query__GT_sql.doInvoke(engine.clj:2155) at clojure.lang.RestFn.invoke(RestFn.java:442) at puppetlabs.puppetdb.query_eng$query__GT_sql.invokeStatic(query_eng.clj:105) at puppetlabs.puppetdb.query_eng$query__GT_sql.invoke(query_eng.clj:81) at puppetlabs.puppetdb.query_eng$eval30279$produce_streaming_body__30284$fn__30285$fn__30288.invoke(query_eng.clj:184) at puppetlabs.puppetdb.jdbc$with_transacted_connection_fn$fn__22193$fn__22194.invoke(jdbc.clj:308) at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:595) at clojure.java.jdbc$db_transaction_STAR_.doInvoke(jdbc.clj:568) at clojure.lang.RestFn.invoke(RestFn.java:464) at puppetlabs.puppetdb.jdbc$with_transacted_connection_fn$fn__22193.invoke(jdbc.clj:307) at puppetlabs.puppetdb.jdbc$eval22167$retry_sql_STAR___22172$fn__22173$fn__22174.invoke(jdbc.clj:285) at puppetlabs.puppetdb.jdbc$eval22167$retry_sql_STAR___22172$fn__22173.invoke(jdbc.clj:284) at
Jira (PDB-3366) Confusing error message when projected column is omitted from explicit subquery
Title: Message Title Wyatt Alt updated an issue PuppetDB / PDB-3366 Confusing error message when projected column is omitted from explicit subquery Change By: Wyatt Alt Summary: Using fact_contents as PQL sub query causes 500 Confusing error message when projected column is omitted from explicit subquery Add Comment This message was sent by Atlassian JIRA (v6.4.14#64029-sha1:ae256fe) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.