8

I've encountered issues posting comments or answers numerous times over the last month, I've narrowed it down that it only occurs when I use UNION and ALL next to each other (ie SQL). If I separate them by a dash it works fine.

The error is always generic: 'An error occurred during ____ submission' The blank being either comment or answer.

Someone suggested I post this question here. I do not see a similar question, interestingly even trying to search the site for UNION and ALL errored, similarly separating them with + returns an error.

Screenshot:

Screenshot

This occurs in Chrome or IE, on Win 7, will test tonight from personal machines.

UPDATE: Apparently through good coincidence I just never had attempted to use UNION ALL when answering questions from home, works fine here. So it must indeed be some firewall/policy setting at my office with very specific criteria, never found any other code bits I couldn't post, and don't have a problem with UNION ALL on other sites. Still interested to find out how it's being blocked given our high level of access.

closed as off-topic by ale, Danubian Sailor, Martijn Pieters, Lance Roberts, Flyk Feb 12 '14 at 8:46

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "The problem described here can no longer be reproduced. Changes to the system or to the circumstances affecting the asker have rendered it obsolete. If you encounter a similar problem, please post a new question." – ale, Danubian Sailor, Martijn Pieters, Lance Roberts, Flyk
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 6
    UNION ALL test comment. Works fine here. – juergen d Jun 24 '13 at 19:02
  • I'm seeing over 16k results. stackoverflow.com/search?q=%22union+all%22 – Bill the Lizard Jun 24 '13 at 19:03
  • Yes, I get that it works for others, trying to find out why it doesn't work for me. – Hart CO Jun 24 '13 at 19:04
  • @BilltheLizard I can't open your link, maybe that means the error is firewall/policy related, but I can use the terms on other sites without issue. – Hart CO Jun 24 '13 at 19:16
  • 1
    That is weird. Please report back if you find out anything. – Bill the Lizard Jun 24 '13 at 19:19
  • I suppose the error comes from a Javascript postback to the server. Do you see additional details if you use Chrome's developer tools, or Firefox's FireBug ? – Andomar Jun 24 '13 at 19:29
  • Browser/operating system? – Benjamin Gruenbaum Jun 24 '13 at 19:29
  • 11
    I remember reading about someone a while back that couldn't post SQL code because their company firewall was blocking it because they thought it was SQL injection. Did you find anything regarding your firewall policy? – FDinoff Jun 24 '13 at 19:31
  • @BenjaminGruenbaum added that info to the question. – Hart CO Jun 24 '13 at 19:33
  • @FDinoff after not being able to browse to Bill's link I think it must be somehow related to firewall settings, it's odd though because I can post code and use the terms UNION and ALL together on other sites. – Hart CO Jun 24 '13 at 19:34
  • UNION ALL testing – Hart CO Jun 25 '13 at 1:58
  • UNION ALL - it works here! – Undo - Reinstate Monica Jun 25 '13 at 2:17
  • @FDinoff It's definitely firewall related, works fine from home, oddly specific, affects only SQL Fiddle and stackoverflow as far as I can tell. If you make an answer I'll choose it. – Hart CO Jun 25 '13 at 16:50
  • 1
    UNION ALL. This is just a test. – It'sNotALie. Jun 25 '13 at 18:19
  • UNION ALL - testing (works for me on Chrome...) – Mysticial Feb 11 '14 at 22:29
5

As @FDinoff suggested, it seems to be firewall related. I can use the terms together on many other sites, but for some reason on SQL Fiddle and SO I am prevented from doing so at work, despite being able to post many other bits of SQL code.

Trying to hunt down the exact rule that prevents this, but at least the cause of the problem is known.

Thanks to those of you that didn't just say "it works fine for me."

Update: I found a workaround a while back, if I simply use two spaces instead of one, the firewall does not block it. UNION ALL

3

UNION ALL test answer. Works

  • 1
    UNION ALL testing – Benjamin Gruenbaum Jun 24 '13 at 19:29
  • UNION ALL DROP TABLE Users – Richard J. Ross III Jun 25 '13 at 18:13
  • 2
    UNION ALL DELETE FROM Users WHERE display_name="Richard J.Ross III" – George Cummins Jun 25 '13 at 18:16
  • 5
    @GeorgeCummins *Gasp* I can't believe you deleted me! You're no longer invited to my birthday party :( – Richard J. Ross III Jun 25 '13 at 18:16
  • UNION ALL UPDATE Users SET coolness_factor = coolness_factor + 1 WHERE display_name = "Richard J. Ross III"; Friends? – George Cummins Jun 25 '13 at 18:18
  • select 'fish' union all select 'chips' – user272201 Oct 9 '14 at 9:49

Not the answer you're looking for? Browse other questions tagged .