https://bugzilla.wikimedia.org/show_bug.cgi?id=23600
Platonides <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED CC| |[email protected] Resolution| |FIXED --- Comment #10 from Platonides <[email protected]> 2010-05-20 14:09:29 UTC --- It gives the error "Column upload does not exist", but on the SQL upload is not a column name, but a *content* that you compare with text fields. SELECT rc_namespace,rc_title,rc_timestamp,COUNT(rev_id) AS edits FROM recentchanges LEFT JOIN revision ON ((rc_cur_id=rev_page)) WHERE rc_user_text = 'Dummy User1' AND ((rc_new = 1) OR (rc_log_type = "upload" AND rc_log_action = "upload")) GROUP BY rc_namespace, rc_title, rc_timestamp ORDER BY rc_timestamp DESC ERROR: column "upload" does not exist Seems that Postgres doesn't support double quotes for constants. http://www.postgresql.org/docs/8.4/interactive/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS > A string constant in SQL is an arbitrary sequence of characters bounded by > single quotes ('), for example 'This is a string'. To include a single-quote > character within a string constant, write two adjacent single quotes, e.g., > 'Dianne''s horse'. Note that this is not the same as a double-quote character > ("). Double quotes are used to delimit identifiers. I have fixed it on the trunk version at r66693. Apparently, that version should work even for an old one like 1.13, so give it a try. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
