id,summary,reporter,owner,description,type,status,priority,component,severity,resolution,keywords,cc,release
7975,Subscription.add and Subscription._update_priority incorrectly use CURRENT_TIMESTAMP on BIGINT column,anonymous,hasienda,The `subscription` table columns `time` and `changetime` are BIGINT as per most of the rest of Trac_ which stores time data as microseconds since Unix epoch. However_ AnnouncerPlugin uses CURRENT_TIMESTAMP when inserting the data_ which returns an ISO-8601 string_ and this is not appropriate for the given column type. With MySQL backend_ MySQL silently mangles the data to “2010”; with PostgreSQL backend_ an error is raised (cannot cast type timestamp with time zone to bigint). This means the plugin does not work at all on Postgres_ and works incorrectly on MySQL.,defect,new,normal,AnnouncerPlugin,major,,database API,,0.12