API tools faq
paste
olemis

Bloodhound multiproduct : test report 23/2/2013

olemis
Feb 23rd, 2013
130
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 121.13 KB | None | 0 0
raw download clone embed print report
  1. $ python setup.py test -m tests
  2.  
  3. running test
  4. running egg_info
  5. writing BloodhoundMultiProduct.egg-info/PKG-INFO
  6. writing top-level names to BloodhoundMultiProduct.egg-info/top_level.txt
  7. writing dependency_links to BloodhoundMultiProduct.egg-info/dependency_links.txt
  8. writing entry points to BloodhoundMultiProduct.egg-info/entry_points.txt
  9. writing BloodhoundMultiProduct.egg-info/PKG-INFO
  10. writing top-level names to BloodhoundMultiProduct.egg-info/top_level.txt
  11. writing dependency_links to BloodhoundMultiProduct.egg-info/dependency_links.txt
  12. writing entry points to BloodhoundMultiProduct.egg-info/entry_points.txt
  13. reading manifest file 'BloodhoundMultiProduct.egg-info/SOURCES.txt'
  14. writing manifest file 'BloodhoundMultiProduct.egg-info/SOURCES.txt'
  15. running build_ext
  16. test_delete (tests.attachment.ProductAttachmentTestCase) ... ok
  17. test_delete_file_gone (tests.attachment.ProductAttachmentTestCase) ... ok
  18. test_get_path (tests.attachment.ProductAttachmentTestCase) ... ok
  19. test_get_path_encoded (tests.attachment.ProductAttachmentTestCase) ... ok
  20. test_insert (tests.attachment.ProductAttachmentTestCase) ... ok
  21. test_insert_outside_attachments_dir (tests.attachment.ProductAttachmentTestCase) ... ok
  22. test_insert_unique (tests.attachment.ProductAttachmentTestCase) ... ok
  23. Ensure that legacy action tests are done on parent.  As ... ok
  24. test_path_extension (tests.attachment.ProductAttachmentTestCase) ... ok
  25. test_product_path_isolation (tests.attachment.ProductAttachmentTestCase) ... ok
  26. test_reparent (tests.attachment.ProductAttachmentTestCase) ... ok
  27. test_resource_doesnt_exist (tests.attachment.ProductAttachmentTestCase) ... ok
  28. test_resource_exists (tests.attachment.ProductAttachmentTestCase) ... ok
  29. test_select_empty (tests.attachment.ProductAttachmentTestCase) ... ok
  30. test_default (tests.config.ProductConfigTestCase) ... ok
  31. test_default_bool (tests.config.ProductConfigTestCase) ... ok
  32. test_default_float (tests.config.ProductConfigTestCase) ... ok
  33. test_default_int (tests.config.ProductConfigTestCase) ... ok
  34. test_default_path (tests.config.ProductConfigTestCase) ... ok
  35. test_getpath (tests.config.ProductConfigTestCase) ... ok
  36. test_has_option (tests.config.ProductConfigTestCase) ... ok
  37. test_has_option_unicode (tests.config.ProductConfigTestCase) ... ok
  38. test_inherit_multiple (tests.config.ProductConfigTestCase) ... ok
  39. test_inherit_one_level (tests.config.ProductConfigTestCase) ... ok
  40. test_options (tests.config.ProductConfigTestCase) ... ok
  41. test_options_unicode (tests.config.ProductConfigTestCase) ... ok
  42. test_overwrite (tests.config.ProductConfigTestCase) ... ok
  43. test_read_and_choice (tests.config.ProductConfigTestCase) ... ok
  44. test_read_and_get (tests.config.ProductConfigTestCase) ... ok
  45. test_read_and_get_unicode (tests.config.ProductConfigTestCase) ... ok
  46. test_read_and_getbool (tests.config.ProductConfigTestCase) ... ok
  47. test_read_and_getfloat (tests.config.ProductConfigTestCase) ... ok
  48. test_read_and_getint (tests.config.ProductConfigTestCase) ... ok
  49. test_read_and_getlist (tests.config.ProductConfigTestCase) ... ok
  50. test_read_and_getlist_false_values (tests.config.ProductConfigTestCase) ... ok
  51. test_read_and_getlist_keep_empty (tests.config.ProductConfigTestCase) ... ok
  52. test_read_and_getlist_sep (tests.config.ProductConfigTestCase) ... ok
  53. test_reparse (tests.config.ProductConfigTestCase) ... ok
  54. test_sections (tests.config.ProductConfigTestCase) ... ok
  55. test_sections_unicode (tests.config.ProductConfigTestCase) ... ok
  56. test_set_and_save (tests.config.ProductConfigTestCase) ... ok
  57. test_set_and_save_inherit (tests.config.ProductConfigTestCase) ... ok
  58. test_simple_remove (tests.config.ProductConfigTestCase) ... ok
  59. Testing env.get_known_users ... ok
  60. Testing env.get_version ... ok
  61. Testing env.__getattr__ ... ok
  62. Testing env.is_component_enabled ... ok
  63. Testing env.config ... ok
  64. Testing env.path ... ok
  65. Testing env.__init__ ... ok
  66. test that we are able to delete Products ... ok
  67. test that we error when deleting twice on the same key ... ok
  68. tests that we can use table.field syntax to get to the field data ... ok
  69. tests that we can use table.field = something to set field data ... ok
  70. test saving new Product ... ok
  71. test attempted saving of Product with existing key fails ... ok
  72. ensure that that insert method works when _meta does not specify ... ok
  73. tests that select can search Products by fields ... ok
  74. tests that table.field style update works ... ok
  75. tests that we can use update to push data to the database ... ok
  76. tests that we raise an error for attempting to update key fields ... ok
  77. test_builtin_groups (tests.perm.ProductDefaultPermissionStoreTestCase) ... ok
  78. test_env_isolation (tests.perm.ProductDefaultPermissionStoreTestCase) ... ok
  79. test_get_all_permissions (tests.perm.ProductDefaultPermissionStoreTestCase) ... ok
  80. test_mixed_case_group (tests.perm.ProductDefaultPermissionStoreTestCase) ... ok
  81. test_nested_groups (tests.perm.ProductDefaultPermissionStoreTestCase) ... ok
  82. test_simple_actions (tests.perm.ProductDefaultPermissionStoreTestCase) ... ok
  83. test_simple_group (tests.perm.ProductDefaultPermissionStoreTestCase) ... ok
  84. Test search: link resolver ... ok
  85. Test search: link resolver with query arguments ... ok
  86. Test attachment: link resolver (deprecated) ... ok
  87. Test attachment: "foreign" links ... ok
  88. Test attachment: "local" links ... ok
  89. Test attachment: "missing" links ... ok
  90. Test attachment: "raw" links ... ok
  91. Test attachment: raw format as explicit argument ... ok
  92. Test mailto: obfuscated by default, like plain email ... ok
  93. Test mailto: not obfuscated, unlike plain email ... ok
  94. test_attachment_list_empty (tests.admin.console.ProductTracadminTestCase) ... ok
  95. test_backslash_use_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  96. test_component_add_error_already_exists (tests.admin.console.ProductTracadminTestCase) ... ok
  97. test_component_add_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  98. test_component_chown_error_bad_component (tests.admin.console.ProductTracadminTestCase) ... ok
  99. test_component_chown_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  100. test_component_list_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  101. test_component_remove_error_bad_component (tests.admin.console.ProductTracadminTestCase) ... ok
  102. test_component_remove_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  103. test_component_rename_error_bad_component (tests.admin.console.ProductTracadminTestCase) ... ok
  104. test_component_rename_error_bad_new_name (tests.admin.console.ProductTracadminTestCase) ... ok
  105. test_component_rename_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  106. test_config_get (tests.admin.console.ProductTracadminTestCase) ... ok
  107. test_config_remove (tests.admin.console.ProductTracadminTestCase) ... ok
  108. test_config_set (tests.admin.console.ProductTracadminTestCase) ... ok
  109. test_help_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  110. test_milestone_add_error_already_exists (tests.admin.console.ProductTracadminTestCase) ... ok
  111. test_milestone_add_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  112. test_milestone_add_utf8_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  113. test_milestone_completed_error_bad_milestone (tests.admin.console.ProductTracadminTestCase) ... ok
  114. test_milestone_completed_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  115. test_milestone_due_error_bad_milestone (tests.admin.console.ProductTracadminTestCase) ... ok
  116. test_milestone_due_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  117. test_milestone_due_unset_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  118. test_milestone_list_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  119. test_milestone_remove_error_bad_milestone (tests.admin.console.ProductTracadminTestCase) ... ok
  120. test_milestone_remove_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  121. test_milestone_rename_error_bad_milestone (tests.admin.console.ProductTracadminTestCase) ... ok
  122. test_milestone_rename_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  123. test_permission_add_already_exists (tests.admin.console.ProductTracadminTestCase) ... ok
  124. test_permission_add_multiple_actions_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  125. test_permission_add_one_action_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  126. test_permission_export_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  127. test_permission_import_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  128. test_permission_list_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  129. test_permission_remove_action_for_all_users (tests.admin.console.ProductTracadminTestCase) ... ok
  130. test_permission_remove_action_not_granted (tests.admin.console.ProductTracadminTestCase) ... ok
  131. test_permission_remove_all_actions_for_user (tests.admin.console.ProductTracadminTestCase) ... ok
  132. test_permission_remove_multiple_actions_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  133. test_permission_remove_one_action_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  134. test_permission_remove_unknown_user (tests.admin.console.ProductTracadminTestCase) ... ok
  135. test_priority_add_error_already_exists (tests.admin.console.ProductTracadminTestCase) ... ok
  136. test_priority_add_many_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  137. test_priority_add_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  138. test_priority_change_error_bad_new_name (tests.admin.console.ProductTracadminTestCase) ... ok
  139. test_priority_change_error_bad_priority (tests.admin.console.ProductTracadminTestCase) ... ok
  140. test_priority_change_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  141. test_priority_list_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  142. test_priority_order_down_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  143. test_priority_order_error_bad_priority (tests.admin.console.ProductTracadminTestCase) ... ok
  144. test_priority_order_up_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  145. test_priority_remove_error_bad_priority (tests.admin.console.ProductTracadminTestCase) ... ok
  146. test_priority_remove_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  147. test_session_add_duplicate_sid (tests.admin.console.ProductTracadminTestCase) ... ok
  148. test_session_add_missing_sid (tests.admin.console.ProductTracadminTestCase) ... ok
  149. test_session_add_sid (tests.admin.console.ProductTracadminTestCase) ... ok
  150. test_session_add_sid_all (tests.admin.console.ProductTracadminTestCase) ... ok
  151. test_session_add_sid_name (tests.admin.console.ProductTracadminTestCase) ... ok
  152. test_session_delete_anonymous (tests.admin.console.ProductTracadminTestCase) ... ok
  153. test_session_delete_missing_params (tests.admin.console.ProductTracadminTestCase) ... ok
  154. test_session_delete_multiple_sids (tests.admin.console.ProductTracadminTestCase) ... ok
  155. test_session_delete_sid (tests.admin.console.ProductTracadminTestCase) ... ok
  156. test_session_list_all (tests.admin.console.ProductTracadminTestCase) ... ok
  157. test_session_list_anonymous (tests.admin.console.ProductTracadminTestCase) ... ok
  158. test_session_list_anonymous_sid (tests.admin.console.ProductTracadminTestCase) ... ok
  159. test_session_list_authenticated (tests.admin.console.ProductTracadminTestCase) ... ok
  160. test_session_list_authenticated_sid (tests.admin.console.ProductTracadminTestCase) ... ok
  161. test_session_list_missing_sid (tests.admin.console.ProductTracadminTestCase) ... ok
  162. test_session_list_no_sessions (tests.admin.console.ProductTracadminTestCase) ... ok
  163. test_session_purge_age (tests.admin.console.ProductTracadminTestCase) ... ok
  164. test_session_set_attr_email (tests.admin.console.ProductTracadminTestCase) ... ok
  165. test_session_set_attr_missing_attr (tests.admin.console.ProductTracadminTestCase) ... ok
  166. test_session_set_attr_missing_sid (tests.admin.console.ProductTracadminTestCase) ... ok
  167. test_session_set_attr_missing_value (tests.admin.console.ProductTracadminTestCase) ... ok
  168. test_session_set_attr_name (tests.admin.console.ProductTracadminTestCase) ... ok
  169. test_session_set_attr_nonexistent_sid (tests.admin.console.ProductTracadminTestCase) ... ok
  170. test_severity_add_error_already_exists (tests.admin.console.ProductTracadminTestCase) ... ok
  171. test_severity_add_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  172. test_severity_change_error_bad_new_name (tests.admin.console.ProductTracadminTestCase) ... ok
  173. test_severity_change_error_bad_severity (tests.admin.console.ProductTracadminTestCase) ... ok
  174. test_severity_change_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  175. test_severity_list_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  176. test_severity_order_down_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  177. test_severity_order_error_bad_severity (tests.admin.console.ProductTracadminTestCase) ... ok
  178. test_severity_order_up_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  179. test_severity_remove_error_bad_severity (tests.admin.console.ProductTracadminTestCase) ... ok
  180. test_severity_remove_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  181. test_ticket_type_add_error_already_exists (tests.admin.console.ProductTracadminTestCase) ... ok
  182. test_ticket_type_add_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  183. test_ticket_type_change_error_bad_new_name (tests.admin.console.ProductTracadminTestCase) ... ok
  184. test_ticket_type_change_error_bad_type (tests.admin.console.ProductTracadminTestCase) ... ok
  185. test_ticket_type_change_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  186. test_ticket_type_list_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  187. test_ticket_type_order_down_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  188. test_ticket_type_order_error_bad_type (tests.admin.console.ProductTracadminTestCase) ... ok
  189. test_ticket_type_order_up_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  190. test_ticket_type_remove_error_bad_type (tests.admin.console.ProductTracadminTestCase) ... ok
  191. test_ticket_type_remove_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  192. test_version_add_error_already_exists (tests.admin.console.ProductTracadminTestCase) ... ok
  193. test_version_add_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  194. test_version_list_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  195. test_version_remove_error_bad_version (tests.admin.console.ProductTracadminTestCase) ... ok
  196. test_version_remove_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  197. test_version_rename_error_bad_version (tests.admin.console.ProductTracadminTestCase) ... ok
  198. test_version_rename_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  199. test_version_time_error_bad_version (tests.admin.console.ProductTracadminTestCase) ... ok
  200. test_version_time_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  201. test_version_time_unset_ok (tests.admin.console.ProductTracadminTestCase) ... ok
  202. test_get_last_id (trac.db.tests.api.ConnectionTestCase) ... ok
  203. test_update_sequence (trac.db.tests.api.ConnectionTestCase) ... ok
  204. test_mysql_simple (trac.db.tests.api.ParseConnectionStringTestCase) ... ok
  205. test_mysql_with_creds (trac.db.tests.api.ParseConnectionStringTestCase) ... ok
  206. test_postgres_simple (trac.db.tests.api.ParseConnectionStringTestCase) ... ok
  207. test_postgres_with_creds (trac.db.tests.api.ParseConnectionStringTestCase) ... ok
  208. test_postgres_with_port (trac.db.tests.api.ParseConnectionStringTestCase) ... ok
  209. test_postgres_with_quoted_password (trac.db.tests.api.ParseConnectionStringTestCase) ... ok
  210. test_sqlite_absolute (trac.db.tests.api.ParseConnectionStringTestCase) ... ok
  211. test_sqlite_relative (trac.db.tests.api.ParseConnectionStringTestCase) ... ok
  212. test_sqlite_windows_path (trac.db.tests.api.ParseConnectionStringTestCase) ... ok
  213. test_sqlite_with_timeout_param (trac.db.tests.api.ParseConnectionStringTestCase) ... ok
  214. test_get_last_id (tests.db.api.ProductConnectionTestCase) ... ok
  215. test_update_sequence (tests.db.api.ProductConnectionTestCase) ... ok
  216. test_mysql_simple (tests.db.api.ProductParseConnectionStringTestCase) ... ok
  217. test_mysql_with_creds (tests.db.api.ProductParseConnectionStringTestCase) ... ok
  218. test_postgres_simple (tests.db.api.ProductParseConnectionStringTestCase) ... ok
  219. test_postgres_with_creds (tests.db.api.ProductParseConnectionStringTestCase) ... ok
  220. test_postgres_with_port (tests.db.api.ProductParseConnectionStringTestCase) ... ok
  221. test_postgres_with_quoted_password (tests.db.api.ProductParseConnectionStringTestCase) ... ok
  222. test_sqlite_absolute (tests.db.api.ProductParseConnectionStringTestCase) ... ok
  223. test_sqlite_relative (tests.db.api.ProductParseConnectionStringTestCase) ... ok
  224. test_sqlite_windows_path (tests.db.api.ProductParseConnectionStringTestCase) ... ok
  225. test_sqlite_with_timeout_param (tests.db.api.ProductParseConnectionStringTestCase) ... ok
  226. test_insert_empty (tests.db.api.ProductStringsTestCase) ... ok
  227. test_insert_markup (tests.db.api.ProductStringsTestCase) ... ok
  228. test_insert_unicode (tests.db.api.ProductStringsTestCase) ... ok
  229. test_quote (tests.db.api.ProductStringsTestCase) ... ok
  230. test_explicit_failure (tests.db.api.ProductWithTransactionTestCase) ... ok
  231. test_explicit_in_implicit_failure (tests.db.api.ProductWithTransactionTestCase) ... ok
  232. test_explicit_in_implicit_success (tests.db.api.ProductWithTransactionTestCase) ... ok
  233. test_explicit_success (tests.db.api.ProductWithTransactionTestCase) ... ok
  234. test_failed_transaction (tests.db.api.ProductWithTransactionTestCase) ... ok
  235. test_implicit_in_explicit_failure (tests.db.api.ProductWithTransactionTestCase) ... ok
  236. test_implicit_in_explicit_success (tests.db.api.ProductWithTransactionTestCase) ... ok
  237. test_implicit_nesting_failure (tests.db.api.ProductWithTransactionTestCase) ... ok
  238. test_implicit_nesting_success (tests.db.api.ProductWithTransactionTestCase) ... ok
  239. test_invalid_nesting (tests.db.api.ProductWithTransactionTestCase) ... ok
  240. test_successful_transaction (tests.db.api.ProductWithTransactionTestCase) ... ok
  241. test_insert_empty (trac.db.tests.api.StringsTestCase) ... ok
  242. test_insert_markup (trac.db.tests.api.StringsTestCase) ... ok
  243. test_insert_unicode (trac.db.tests.api.StringsTestCase) ... ok
  244. test_quote (trac.db.tests.api.StringsTestCase) ... ok
  245. test_explicit_failure (trac.db.tests.api.WithTransactionTest) ... ok
  246. test_explicit_in_implicit_failure (trac.db.tests.api.WithTransactionTest) ... ok
  247. test_explicit_in_implicit_success (trac.db.tests.api.WithTransactionTest) ... ok
  248. test_explicit_success (trac.db.tests.api.WithTransactionTest) ... ok
  249. test_failed_transaction (trac.db.tests.api.WithTransactionTest) ... ok
  250. test_implicit_in_explicit_failure (trac.db.tests.api.WithTransactionTest) ... ok
  251. test_implicit_in_explicit_success (trac.db.tests.api.WithTransactionTest) ... ok
  252. test_implicit_nesting_failure (trac.db.tests.api.WithTransactionTest) ... ok
  253. test_implicit_nesting_success (trac.db.tests.api.WithTransactionTest) ... ok
  254. test_invalid_nesting (trac.db.tests.api.WithTransactionTest) ... ok
  255. test_successful_transaction (trac.db.tests.api.WithTransactionTest) ... ok
  256. test_custom_alter_table (tests.db.cursor.DbCursorTestCase) ... ok
  257. test_custom_create_table (tests.db.cursor.DbCursorTestCase) ... ok
  258. test_custom_insert (tests.db.cursor.DbCursorTestCase) ... ok
  259. test_custom_select (tests.db.cursor.DbCursorTestCase) ... ok
  260. test_custom_update (tests.db.cursor.DbCursorTestCase) ... ok
  261. test_system_insert_nontranslated (tests.db.cursor.DbCursorTestCase) ... ok
  262. test_system_insert_translated (tests.db.cursor.DbCursorTestCase) ... ok
  263. test_system_select_nontranslated (tests.db.cursor.DbCursorTestCase) ... ok
  264. test_system_select_translated (tests.db.cursor.DbCursorTestCase) ... ok
  265. test_system_update_nontranslated (tests.db.cursor.DbCursorTestCase) ... ok
  266. test_system_update_translated (tests.db.cursor.DbCursorTestCase) ... ok
  267. test_alter_column_types (trac.db.tests.mysql_test.MySQLTableAlterationSQLTest) ... ok
  268. test_alter_column_types_none (trac.db.tests.mysql_test.MySQLTableAlterationSQLTest) ... ok
  269. test_alter_column_types_same (trac.db.tests.mysql_test.MySQLTableAlterationSQLTest) ... ok
  270. test_alter_column_types (tests.db.mysql.ProductMySQLTableAlterationSQLTest) ... ok
  271. test_alter_column_types_none (tests.db.mysql.ProductMySQLTableAlterationSQLTest) ... ok
  272. test_alter_column_types_same (tests.db.mysql.ProductMySQLTableAlterationSQLTest) ... ok
  273. test_alter_column_types (trac.db.tests.postgres_test.PostgresTableAlterationSQLTest) ... ok
  274. test_alter_column_types_none (trac.db.tests.postgres_test.PostgresTableAlterationSQLTest) ... ok
  275. test_alter_column_types_same (trac.db.tests.postgres_test.PostgresTableAlterationSQLTest) ... ok
  276. test_assemble_dsn (trac.db.tests.postgres_test.PostgresTableCreationSQLTest) ... ok
  277. test_quote_column_names (trac.db.tests.postgres_test.PostgresTableCreationSQLTest) ... ok
  278. test_quote_compound_primary_key_declaration (trac.db.tests.postgres_test.PostgresTableCreationSQLTest) ... ok
  279. test_quote_index_declaration (trac.db.tests.postgres_test.PostgresTableCreationSQLTest) ... ok
  280. test_quote_index_declaration_for_multiple_indexes (trac.db.tests.postgres_test.PostgresTableCreationSQLTest) ... ok
  281. test_quote_table_name (trac.db.tests.postgres_test.PostgresTableCreationSQLTest) ... ok
  282. test_alter_column_types (tests.db.postgres.ProductPostgresTableAlterationSQLTest) ... ok
  283. test_alter_column_types_none (tests.db.postgres.ProductPostgresTableAlterationSQLTest) ... ok
  284. test_alter_column_types_same (tests.db.postgres.ProductPostgresTableAlterationSQLTest) ... ok
  285. test_assemble_dsn (tests.db.postgres.ProductPostgresTableCreationSQLTest) ... ok
  286. test_quote_column_names (tests.db.postgres.ProductPostgresTableCreationSQLTest) ... ok
  287. test_quote_compound_primary_key_declaration (tests.db.postgres.ProductPostgresTableCreationSQLTest) ... ok
  288. test_quote_index_declaration (tests.db.postgres.ProductPostgresTableCreationSQLTest) ... ok
  289. test_quote_index_declaration_for_multiple_indexes (tests.db.postgres.ProductPostgresTableCreationSQLTest) ... ok
  290. test_quote_table_name (tests.db.postgres.ProductPostgresTableCreationSQLTest) ... ok
  291. test_get_supported_conversions (tests.mimeview.api.ProductMimeviewTestCase) ... ok
  292. Regression test related to #4557 ... ok
  293. Regression test related to #5795 ... ok
  294. test_no_newline_in_base (tests.mimeview.patch.ProductPatchRendererTestCase) ... ok
  295. test_no_newline_in_changed (tests.mimeview.patch.ProductPatchRendererTestCase) ... ok
  296. test_simple (tests.mimeview.patch.ProductPatchRendererTestCase) ... ok
  297. test_empty_content (tests.mimeview.pygments.ProductPygmentsRendererTestCase) ... ok
  298. test_extra_mimetypes (tests.mimeview.pygments.ProductPygmentsRendererTestCase) ... ok
  299. test_newline_content (tests.mimeview.pygments.ProductPygmentsRendererTestCase) ... ok
  300. test_python_hello (tests.mimeview.pygments.ProductPygmentsRendererTestCase) ... ok
  301. test_python_hello_mimeview (tests.mimeview.pygments.ProductPygmentsRendererTestCase) ... ok
  302. test_available_actions_chgprop_only (tests.ticket.api.ProductTicketSystemTestCase) ... ok
  303. test_available_actions_create_only (tests.ticket.api.ProductTicketSystemTestCase) ... ok
  304. test_available_actions_full_perms (tests.ticket.api.ProductTicketSystemTestCase) ... ok
  305. test_available_actions_isolation (tests.ticket.api.ProductTicketSystemTestCase) ... ok
  306. test_available_actions_no_perms (tests.ticket.api.ProductTicketSystemTestCase) ... ok
  307. test_custom_field_isolation (tests.ticket.api.ProductTicketSystemTestCase) ... ok
  308. test_custom_field_optional_select (tests.ticket.api.ProductTicketSystemTestCase) ... ok
  309. test_custom_field_order (tests.ticket.api.ProductTicketSystemTestCase) ... ok
  310. test_custom_field_select (tests.ticket.api.ProductTicketSystemTestCase) ... ok
  311. test_custom_field_text (tests.ticket.api.ProductTicketSystemTestCase) ... ok
  312. test_custom_field_textarea (tests.ticket.api.ProductTicketSystemTestCase) ... ok
  313. Actions can have operations with side effects. ... ok
  314. Actions can have change status. ... ok
  315. test_add_batchmod_value_data_from_request (tests.ticket.batch.ProductBatchModifyTestCase) ... ok
  316. Append additional item. ... ok
  317. Append additional items. ... ok
  318. Existing items are not duplicated. ... ok
  319. Remove existing item and append additional item. ... ok
  320. Clear field. ... ok
  321. Remove all duplicates. ... ok
  322. Ignore missing item to be removed. ... ok
  323. Remove existing item. ... ok
  324. Remove existing items. ... ok
  325. Ignore only missing item to be removed. ... ok
  326. Replace emtpy field with items. ... ok
  327. Replace emtpy field with single item. ... ok
  328. Replace item with a different item. ... ok
  329. Replace item with different items. ... ok
  330. Replace items with different items. ... ok
  331. Replace items with different (or not) items. ... ok
  332. Replace items with a different item. ... ok
  333. These cannot be added through the UI, but if somebody tries ... ok
  334. If nothing is selected, the return value is the empty list. ... ok
  335. Comments are saved to all selected tickets. ... ok
  336. Changed values are saved to all tickets. ... ok
  337. test_selected_tickets (tests.ticket.batch.ProductBatchModifyTestCase) ... ok
  338. test_conversions (tests.ticket.conversion.ProductTicketConversionTestCase) ... ok
  339. test_csv_conversion (tests.ticket.conversion.ProductTicketConversionTestCase) ... ok
  340. test_rss_conversion (tests.ticket.conversion.ProductTicketConversionTestCase) ... ok
  341. test_tab_conversion (tests.ticket.conversion.ProductTicketConversionTestCase) ... ok
  342. test_can_save_ticket_without_explicit_comment (tests.ticket.model.ProductTicketTestCase) ... ok
  343. test_can_save_ticket_without_explicit_username (tests.ticket.model.ProductTicketTestCase) ... ok
  344. test_change_listener_changed (tests.ticket.model.ProductTicketTestCase) ... ok
  345. test_change_listener_created (tests.ticket.model.ProductTicketTestCase) ... ok
  346. test_change_listener_deleted (tests.ticket.model.ProductTicketTestCase) ... ok
  347. test_changelog (tests.ticket.model.ProductTicketTestCase) ... ok
  348. Verify ordering of attachments and comments in the changelog. ... ok
  349. test_changelog_with_reverted_change (tests.ticket.model.ProductTicketTestCase) ... ok
  350. test_comment_with_whitespace_only_is_not_saved (tests.ticket.model.ProductTicketTestCase) ... ok
  351. test_create_ticket_1 (tests.ticket.model.ProductTicketTestCase) ... ok
  352. test_create_ticket_2 (tests.ticket.model.ProductTicketTestCase) ... ok
  353. test_create_ticket_3 (tests.ticket.model.ProductTicketTestCase) ... ok
  354. test_create_ticket_4 (tests.ticket.model.ProductTicketTestCase) ... ok
  355. test_create_ticket_5 (tests.ticket.model.ProductTicketTestCase) ... ok
  356. test_invalid_ticket_id (tests.ticket.model.ProductTicketTestCase) ... ok
  357. test_no_disown_from_changed_component (tests.ticket.model.ProductTicketTestCase) ... ok
  358. test_owner_from_changed_component (tests.ticket.model.ProductTicketTestCase) ... ok
  359. test_owner_from_component (tests.ticket.model.ProductTicketTestCase) ... ok
  360. test_populate_ticket (tests.ticket.model.ProductTicketTestCase) ... ok
  361. test_prop_whitespace_change_is_not_saved (tests.ticket.model.ProductTicketTestCase) ... ok
  362. test_set_field_multi (tests.ticket.model.ProductTicketTestCase) ... ok
  363. test_set_field_stripped (tests.ticket.model.ProductTicketTestCase) ... ok
  364. Perform two ticket changes within a second. ... ok
  365. test_ticket_default_values (tests.ticket.model.ProductTicketTestCase) ... ok
  366. test_ticket_id_is_always_int (tests.ticket.model.ProductTicketTestCase) ... ok
  367. Check the generation of the comment history ... ok
  368. Modify a comment where one edit is missing ... ok
  369. Check modification of a "standalone" comment ... ok
  370. Editing a comment with no cnum in oldvalue ... ok
  371. Editing a comment when all cnums are missing and one comment ... ok
  372. Editing a comment where the comment field is missing ... ok
  373. Check modification of a "threaded" comment ... ok
  374. test_delete_all_comments (tests.ticket.model.ProductTicketCommentDeleteTestCase) ... ok
  375. test_delete_last_comment (tests.ticket.model.ProductTicketCommentDeleteTestCase) ... ok
  376. test_delete_last_comment_by_date (tests.ticket.model.ProductTicketCommentDeleteTestCase) ... ok
  377. Regression test for http://trac.edgewall.org/ticket/10858 ... ok
  378. test_delete_mid_comment (tests.ticket.model.ProductTicketCommentDeleteTestCase) ... ok
  379. test_delete_mid_comment_by_date (tests.ticket.model.ProductTicketCommentDeleteTestCase) ... ok
  380. test_delete_mid_comment_inconsistent (tests.ticket.model.ProductTicketCommentDeleteTestCase) ... ok
  381. test_priority_delete (tests.ticket.model.ProductEnumTestCase) ... ok
  382. test_priority_fetch (tests.ticket.model.ProductEnumTestCase) ... ok
  383. test_priority_insert (tests.ticket.model.ProductEnumTestCase) ... ok
  384. test_priority_insert_with_value (tests.ticket.model.ProductEnumTestCase) ... ok
  385. test_priority_update (tests.ticket.model.ProductEnumTestCase) ... ok
  386. test_ticket_type_update (tests.ticket.model.ProductEnumTestCase) ... ok
  387. test_change_listener_changed (tests.ticket.model.ProductMilestoneTestCase) ... ok
  388. test_change_listener_created (tests.ticket.model.ProductMilestoneTestCase) ... ok
  389. test_change_listener_deleted (tests.ticket.model.ProductMilestoneTestCase) ... ok
  390. test_create_and_update_milestone (tests.ticket.model.ProductMilestoneTestCase) ... ok
  391. test_create_milestone_without_name (tests.ticket.model.ProductMilestoneTestCase) ... ok
  392. test_delete_milestone (tests.ticket.model.ProductMilestoneTestCase) ... ok
  393. test_delete_milestone_retarget_tickets (tests.ticket.model.ProductMilestoneTestCase) ... ok
  394. test_existing_milestone (tests.ticket.model.ProductMilestoneTestCase) ... ok
  395. test_new_milestone (tests.ticket.model.ProductMilestoneTestCase) ... ok
  396. test_new_milestone_empty_name (tests.ticket.model.ProductMilestoneTestCase) ... ok
  397. test_rename_milestone (tests.ticket.model.ProductMilestoneTestCase) ... ok
  398. test_select_milestones (tests.ticket.model.ProductMilestoneTestCase) ... ok
  399. test_update_milestone (tests.ticket.model.ProductMilestoneTestCase) ... ok
  400. test_update_milestone_update_tickets (tests.ticket.model.ProductMilestoneTestCase) ... ok
  401. test_update_milestone_without_name (tests.ticket.model.ProductMilestoneTestCase) ... ok
  402. test_create_and_update (tests.ticket.model.ProductComponentTestCase) ... ok
  403. test_exists (tests.ticket.model.ProductComponentTestCase) ... ok
  404. test_exists_negative (tests.ticket.model.ProductComponentTestCase) ... ok
  405. test_create_and_update (tests.ticket.model.ProductVersionTestCase) ... ok
  406. test_exists (tests.ticket.model.ProductVersionTestCase) ... ok
  407. test_exists_negative (tests.ticket.model.ProductVersionTestCase) ... ok
  408. SMTP domain inclusion ... ok
  409. Visibility of recipients ... ok
  410. Notification w/o explicit recipients but Cc: (#3101) ... ok
  411. Date format compliance (RFC822) ... ok
  412. Default domain name ... ok
  413. Login-to-email mapping ... ok
  414. Using the reporter or change author as the notification sender ... ok
  415. Non-SMTP domain exclusion ... ok
  416. MD5 digest w/ non-ASCII recipient address (#3491) ... ok
  417. MIME Base64/utf-8 encoding ... ok
  418. MIME None encoding resulting in 7bit ... ok
  419. MIME None encoding resulting in 8bit ... ok
  420. MIME QP/utf-8 encoding ... ok
  421. Encoded headers split into multiple lines ... ok
  422. No recipient case ... ok
  423. test_notification_does_not_alter_ticket_instance (tests.ticket.notification.ProductNotificationTestCase) ... ok
  424. test_notification_get_message_id_unicode (tests.ticket.notification.ProductNotificationTestCase) ... ok
  425. test_props_format_ambiwidth_double (tests.ticket.notification.ProductNotificationTestCase) ... ok
  426. test_props_format_ambiwidth_single (tests.ticket.notification.ProductNotificationTestCase) ... ok
  427. test_props_format_obfuscated_email (tests.ticket.notification.ProductNotificationTestCase) ... ok
  428. test_props_format_obfuscated_email_disabled (tests.ticket.notification.ProductNotificationTestCase) ... ok
  429. test_props_format_wrap_bothsides (tests.ticket.notification.ProductNotificationTestCase) ... ok
  430. test_props_format_wrap_bothsides_unicode (tests.ticket.notification.ProductNotificationTestCase) ... ok
  431. test_props_format_wrap_leftside (tests.ticket.notification.ProductNotificationTestCase) ... ok
  432. test_props_format_wrap_leftside_unicode (tests.ticket.notification.ProductNotificationTestCase) ... ok
  433. test_props_format_wrap_rightside (tests.ticket.notification.ProductNotificationTestCase) ... ok
  434. test_props_format_wrap_rightside_unicode (tests.ticket.notification.ProductNotificationTestCase) ... ok
  435. To/Cc recipients ... ok
  436. Email addresses without a FQDN ... ok
  437. Basic SMTP message structure (headers, body) ... ok
  438. No-self-notification option ... ok
  439. Notification to reporter w/ updater option disabled (#3780) ... ok
  440. Notification w/ updater, w/o any other recipient (#4188) ... ok
  441. test_all_grouped_by_milestone (tests.ticket.query.ProductQueryTestCase) ... FAIL
  442. test_all_grouped_by_milestone_desc (tests.ticket.query.ProductQueryTestCase) ... FAIL
  443. test_all_ordered_by_id (tests.ticket.query.ProductQueryTestCase) ... FAIL
  444. test_all_ordered_by_id_desc (tests.ticket.query.ProductQueryTestCase) ... FAIL
  445. test_all_ordered_by_id_from_unicode (tests.ticket.query.ProductQueryTestCase) ... FAIL
  446. test_all_ordered_by_id_verbose (tests.ticket.query.ProductQueryTestCase) ... FAIL
  447. test_all_ordered_by_priority (tests.ticket.query.ProductQueryTestCase) ... FAIL
  448. test_all_ordered_by_priority_desc (tests.ticket.query.ProductQueryTestCase) ... FAIL
  449. test_all_ordered_by_version (tests.ticket.query.ProductQueryTestCase) ... ok
  450. test_all_ordered_by_version_desc (tests.ticket.query.ProductQueryTestCase) ... ok
  451. test_constrained_by_custom_field (tests.ticket.query.ProductQueryTestCase) ... FAIL
  452. test_constrained_by_empty_value_contains (tests.ticket.query.ProductQueryTestCase) ... FAIL
  453. test_constrained_by_empty_value_endswith (tests.ticket.query.ProductQueryTestCase) ... FAIL
  454. test_constrained_by_empty_value_startswith (tests.ticket.query.ProductQueryTestCase) ... FAIL
  455. test_constrained_by_keywords (tests.ticket.query.ProductQueryTestCase) ... ok
  456. test_constrained_by_milestone (tests.ticket.query.ProductQueryTestCase) ... FAIL
  457. test_constrained_by_milestone_not (tests.ticket.query.ProductQueryTestCase) ... ok
  458. test_constrained_by_milestone_or_version (tests.ticket.query.ProductQueryTestCase) ... FAIL
  459. test_constrained_by_multiple_owners (tests.ticket.query.ProductQueryTestCase) ... FAIL
  460. test_constrained_by_multiple_owners_contain (tests.ticket.query.ProductQueryTestCase) ... FAIL
  461. test_constrained_by_multiple_owners_not (tests.ticket.query.ProductQueryTestCase) ... FAIL
  462. test_constrained_by_owner_beginswith (tests.ticket.query.ProductQueryTestCase) ... FAIL
  463. test_constrained_by_owner_containing (tests.ticket.query.ProductQueryTestCase) ... FAIL
  464. test_constrained_by_owner_endswith (tests.ticket.query.ProductQueryTestCase) ... FAIL
  465. test_constrained_by_owner_not_containing (tests.ticket.query.ProductQueryTestCase) ... FAIL
  466. test_constrained_by_status (tests.ticket.query.ProductQueryTestCase) ... FAIL
  467. test_constrained_by_time_range (tests.ticket.query.ProductQueryTestCase) ... ok
  468. test_constrained_by_time_range_exclusion (tests.ticket.query.ProductQueryTestCase) ... ok
  469. test_constrained_by_time_range_modified (tests.ticket.query.ProductQueryTestCase) ... ok
  470. test_constrained_by_time_range_open_left (tests.ticket.query.ProductQueryTestCase) ... ok
  471. test_constrained_by_time_range_open_right (tests.ticket.query.ProductQueryTestCase) ... ok
  472. test_csv_escape (tests.ticket.query.ProductQueryTestCase) ... ok
  473. test_equal_in_value (tests.ticket.query.ProductQueryTestCase) ... FAIL
  474. test_grouped_by_custom_field (tests.ticket.query.ProductQueryTestCase) ... FAIL
  475. test_grouped_by_priority (tests.ticket.query.ProductQueryTestCase) ... FAIL
  476. test_repeated_constraint_field (tests.ticket.query.ProductQueryTestCase) ... ok
  477. test_special_character_escape (tests.ticket.query.ProductQueryTestCase) ... FAIL
  478. test_template_data (tests.ticket.query.ProductQueryTestCase) ... ok
  479. test_user_var (tests.ticket.query.ProductQueryTestCase) ... FAIL
  480. test_empty_query (tests.ticket.query.ProductQueryLinksTestCase) ... ok
  481. test_csv_escape (tests.ticket.report.ProductReportTestCase) ... ok
  482. test_saved_custom_query_redirect (tests.ticket.report.ProductReportTestCase) ... ok
  483. test_sub_var_digits_underscore (tests.ticket.report.ProductReportTestCase) ... ok
  484. test_sub_var_missing_args (tests.ticket.report.ProductReportTestCase) ... ok
  485. test_sub_var_no_quotes (tests.ticket.report.ProductReportTestCase) ... ok
  486. test_sub_var_quotes (tests.ticket.report.ProductReportTestCase) ... ok
  487. test_closed_interval (tests.ticket.roadmap.ProductDefaultTicketGroupStatsProviderTestCase) ... ok
  488. test_open_interval (tests.ticket.roadmap.ProductDefaultTicketGroupStatsProviderTestCase) ... ok
  489. test_stats (tests.ticket.roadmap.ProductDefaultTicketGroupStatsProviderTestCase) ... ok
  490. test_add_link_advanced (tests.web.chrome.ProductChromeTestCase) ... ok
  491. test_add_link_simple (tests.web.chrome.ProductChromeTestCase) ... ok
  492. test_add_meta (tests.web.chrome.ProductChromeTestCase) ... ok
  493. test_add_notice_is_unique (tests.web.chrome.ProductChromeTestCase) ... ok
  494. test_add_script (tests.web.chrome.ProductChromeTestCase) ... ok
  495. test_add_script_data (tests.web.chrome.ProductChromeTestCase) ... ok
  496. test_add_stylesheet (tests.web.chrome.ProductChromeTestCase) ... ok
  497. test_add_stylesheet_media (tests.web.chrome.ProductChromeTestCase) ... ok
  498. test_add_warning_is_unique (tests.web.chrome.ProductChromeTestCase) ... ok
  499. test_default_links (tests.web.chrome.ProductChromeTestCase) ... ok
  500. test_htdocs_location (tests.web.chrome.ProductChromeTestCase) ... ok
  501. test_icon_links (tests.web.chrome.ProductChromeTestCase) ... ok
  502. test_logo (tests.web.chrome.ProductChromeTestCase) ... ok
  503. test_nav_contributor (tests.web.chrome.ProductChromeTestCase) ... ok
  504. test_nav_contributor_active (tests.web.chrome.ProductChromeTestCase) ... ok
  505. test_nav_contributor_order (tests.web.chrome.ProductChromeTestCase) ... ok
  506. test_add_anonymous_session_var (tests.web.session.ProductSessionTestCase) ... ok
  507. test_add_authenticated_session_var (tests.web.session.ProductSessionTestCase) ... ok
  508. test_anonymous_session (tests.web.session.ProductSessionTestCase) ... ok
  509. test_authenticated_session (tests.web.session.ProductSessionTestCase) ... ok
  510. test_authenticated_session_independence_var (tests.web.session.ProductSessionTestCase) ... ok
  511. test_change_anonymous_session (tests.web.session.ProductSessionTestCase) ... ok
  512. test_delete_anonymous_session_var (tests.web.session.ProductSessionTestCase) ... ok
  513. test_delete_authenticated_session_var (tests.web.session.ProductSessionTestCase) ... ok
  514. test_delete_detached_session_var (tests.web.session.ProductSessionTestCase) ... ok
  515. test_delete_empty_session (tests.web.session.ProductSessionTestCase) ... ok
  516. test_modify_anonymous_session_var (tests.web.session.ProductSessionTestCase) ... ok
  517. test_modify_authenticated_session_var (tests.web.session.ProductSessionTestCase) ... ok
  518. test_modify_detached_session (tests.web.session.ProductSessionTestCase) ... ok
  519. test_new_session (tests.web.session.ProductSessionTestCase) ... ok
  520. test_new_session_promotion (tests.web.session.ProductSessionTestCase) ... ok
  521. test_purge_anonymous_session (tests.web.session.ProductSessionTestCase) ... ok
  522. test_session_admin_add (tests.web.session.ProductSessionTestCase) ... ok
  523. test_session_admin_delete (tests.web.session.ProductSessionTestCase) ... ok
  524. test_session_admin_list (tests.web.session.ProductSessionTestCase) ... ok
  525. test_session_admin_purge (tests.web.session.ProductSessionTestCase) ... ok
  526. test_session_admin_set (tests.web.session.ProductSessionTestCase) ... ok
  527. test_session_promotion (tests.web.session.ProductSessionTestCase) ... ok
  528. Verify that setting a variable in a session to the default value ... ok
  529. test_update_session (tests.web.session.ProductSessionTestCase) ... ok
  530. Test htdocs: links resolver ... ok
  531. Test Bold + italic markup ... ok
  532. Test Multiline bold italic markup (WikiCreole) ... ok
  533. Test Problematic markup: comma-separated list with a time + bold markup ... ok
  534. Test Consecutive bold + italic markup ... ok
  535. Test Underline + overstrike markup ... ok
  536. Test Problematic markup: overlapping tags ... ok
  537. Test Problematic markup: out of order close tags ... ok
  538. Test Problematic markup: bold + missing close italic ... ok
  539. Test Italic immediately followed by bold markup ... ok
  540. Test Bold immediately followed by italic markup ... ok
  541. Test Multiline bold italic markup ... ok
  542. Test Multiline bold italic markup ... ok
  543. Test Problematic multiline bold italic markup ... ok
  544. Test Super and subscript markup ... ok
  545. Test Super and subscript markup ... ok
  546. Test Escaping markup ... ok
  547. Test Complex mixed verbatim markup ... ok
  548. Test Complex mixed verbatim markup ... ok
  549. Test Link resolvers, short form ... ok
  550. Test Escaping links resolvers, short form ... ok
  551. Test Link resolvers, alternative short form ... ok
  552. Test Escaping links resolvers, alternative short form ... ok
  553. Test Link resolvers, long form with label ... ok
  554. Test Link resolver SHREF_TARGET_LAST ... ok
  555. Test Link resolver SHREF_TARGET_LAST ... ok
  556. Test Link resolver SHREF_TARGET_FIRST ... ok
  557. Test Link resolver SHREF_TARGET_MIDDLE ... ok
  558. Test Link resolver SHREF_TARGET_MIDDLE ... ok
  559. Test Link resolver, long form with quoting ... ok
  560. Test Link resolver in markup ... ok
  561. Test Link resolver, quoting of target ... ok
  562. Test Link resolver look alike, quoting of target ... ok
  563. Test Relative links ... ok
  564. Test Relative links (WikiCreole style) ... ok
  565. Test Wiki anchors ... ok
  566. Test Wiki anchors (WikiCreole style) ... ok
  567. Test Image links are now regular external links ... ok
  568. Test Image links are now regular external links ... ok
  569. Test Arbitrary protocol Link ... ok
  570. Test mailto: links and automatic e-mail detection ... ok
  571. Test Arbitrary protocol Link ... ok
  572. Test Generic InterTrac links ... ok
  573. Test Another arbitrary protocol Link ... ok
  574. Test WikiCreole style for the above examples ... ok
  575. Test More WikiCreole examples ... ok
  576. Test Link resolver counter examples ... ok
  577. Test Link resolver counter examples ... ok
  578. Test Link resolver counter examples ... ok
  579. Test Link resolver counter example ... ok
  580. Test Link resolver counter example ... ok
  581. Test Code Block 1 ... ok
  582. Test Code Block 1 ... ok
  583. Test Code Block 2 ... ok
  584. Test Code Block 2 ... ok
  585. Test Embedded code blocks ... ok
  586. Test Embedded code blocks ... ok
  587. Test Consecutive code blocks ... ok
  588. Test Consecutive code blocks ... ok
  589. Test Unfinished code blocks ... ok
  590. Test Unfinished code blocks ... ok
  591. Test Wiki processor ... ok
  592. Test Wiki processor ... ok
  593. Test Wiki processor, compact declaration ... ok
  594. Test Wiki processor, compact declaration ... ok
  595. Test Wiki processor, prefix removal ... ok
  596. Test Wiki processor counter example ... ok
  597. Test Wiki processor counter example ... ok
  598. Test HTML wiki processor ... ok
  599. Test HTML wiki processor ... ok
  600. Test HTML wiki processor, XSS check 1 ... ok
  601. Test HTML wiki processor, XSS check 1 ... ok
  602. Test HTML wiki processor, XSS check 2 ... ok
  603. Test HTML wiki processor, XSS check 2 ... ok
  604. Test HTML wiki processor, XSS check 3 ... ok
  605. Test HTML wiki processor, XSS check 3 ... ok
  606. Test HTML comment wiki processor ... ok
  607. Test HTML comment wiki processor ... ok
  608. Test HTML comment wiki processor, comment ends with "-" ... ok
  609. Test HTML comment wiki processor, comment ends with "-" ... ok
  610. Test HTML comment wiki processor, comment contains "--" ... ok
  611. Test HTML comment wiki processor, comment contains "--" ... ok
  612. Test WikiProcessor default arguments ... ok
  613. Test div and span wiki processors ... ok
  614. Test div and span wiki processors ... ok
  615. Test div and Span wiki processors ... ok
  616. Test div and Span wiki processors ... ok
  617. Test span wiki processor ... ok
  618. Test span wiki processor ... ok
  619. Test div and Span wiki processors ... ok
  620. Test div and Span wiki processors ... ok
  621. Test Macro help shortcut (with content) ... ok
  622. Test Macro help shortcut (with content) ... ok
  623. Test Macro help shortcut (no content) ... ok
  624. Test Macro help shortcut (no content) ... ok
  625. Test Macro with arguments (leading) ... ok
  626. Test Macro with arguments (leading) ... ok
  627. Test Macro with arguments (in flow) ... ok
  628. Test Macro with arguments (in flow) ... ok
  629. Test Bad macro call, but valid WikiCreole link ... ok
  630. Test Bad macro call, but valid WikiCreole link ... ok
  631. Test Another bad macro call ... ok
  632. Test Another bad macro call ... ok
  633. Test Two consecutive macros on a line ... ok
  634. Test Two consecutive macros on a line ... ok
  635. Test Macro returning a <div> ... ok
  636. Test Macro returning a <div> ... ok
  637. Test Macro returning a <table> preceeded by space ... ok
  638. Test Macro returning a <table> preceeded by space ... ok
  639. Test Macro returning a <div class="...code..."> ... ok
  640. Test Macro returning a <div class="...code..."> ... ok
  641. Test Macro returning an html.DIV(class="...code...">) ... ok
  642. Test Macro returning an html.DIV(class="...code...">) ... ok
  643. Test Macro returning a Genshi Stream (no "code" div) ... ok
  644. Test Macro returning a Genshi Stream (no "code" div) ... ok
  645. Test Macro returning None ... ok
  646. Test Macro returning None ... ok
  647. Test WikiProcessor defined as a macro ... ok
  648. Test WikiProcessor defined as a macro ... ok
  649. Test Inlined HTML wiki processor ... ok
  650. Test Inlined HTML wiki processor ... ok
  651. Test BR macro ... ok
  652. Test BR macro ... ok
  653. Test WikiCreole line break ... ok
  654. Test WikiCreole line break ... ok
  655. Test Comment wiki processor ... ok
  656. Test Comment wiki processor ... ok
  657. Test Comment wiki processor called as a macro ... ok
  658. Test Comment wiki processor called as a macro ... ok
  659. Test I18N heading ... ok
  660. Test I18N heading ... ok
  661. Test Quoted heading ... ok
  662. Test Quoted heading ... ok
  663. Test Heading with < and > ... ok
  664. Test Heading with < and > ... ok
  665. Test Heading with . ... ok
  666. Test Heading with . ... ok
  667. Test Normal heading ... ok
  668. Test Normal heading ... ok
  669. Test Formatted heading ... ok
  670. Test Formatted heading ... ok
  671. Test Heading with link ... ok
  672. Test Heading with link ... ok
  673. Test Normal heading, fixed id ... ok
  674. Test Normal heading, fixed id ... ok
  675. Test Normal heading, auto-corrected id ... ok
  676. Test Normal heading, auto-corrected id ... ok
  677. Test Normal heading, auto-corrected id ... ok
  678. Test Relaxed heading ... ok
  679. Test Relaxed heading ... ok
  680. Test Relaxed heading ... ok
  681. Test Bulleted lists ... ok
  682. Test Bulleted lists ... ok
  683. Test Changelog sample (and e-mail link) ... ok
  684. Test Complex bulleted list ... ok
  685. Test Numbered lists ... ok
  686. Test Numbered lists ... ok
  687. Test Numbered lists multi-line items ... ok
  688. Test Numbered lists multi-line items ... ok
  689. Test List with explicit numerical start > 9 ... ok
  690. Test List with explicit loweralpha start > 'a.' ... ok
  691. Test Numbered lists counter-examples ... ok
  692. Test Unicode digits will not start a numbered list ... ok
  693. Test Mixed lists multi-line items ... ok
  694. Test Lists and partial inline markup (#3232) ... ok
  695. Test Lists and partial inline markup (#3232) ... ok
  696. Test Lists starting at beginning of line ... ok
  697. Test Simple definition list ... ok
  698. Test Simple definition list ... ok
  699. Test Tricky definition list ... ok
  700. Test Tricky definition list ... ok
  701. Test Verbatim term in definition list ... ok
  702. Test Verbatim term in definition list ... ok
  703. Test Another verbatim term in definition list ... ok
  704. Test Another verbatim term in definition list ... ok
  705. Test Complex definition list ... ok
  706. Test Complex definition list ... ok
  707. Test Definition list counter example ... ok
  708. Test Definition list counter example ... ok
  709. Test Pathological definition list counter example with block quotes ... ok
  710. Test Pathological definition list counter example with block quotes ... ok
  711. Test Definition list + escaped definition list ... ok
  712. Test Definition list + escaped definition list ... ok
  713. Test Definition list + another escaped definition list ... ok
  714. Test Definition list + another escaped definition list ... ok
  715. Test Simple Table, one column ... ok
  716. Test Simple Table, one column ... ok
  717. Test Simple Table, multiple columns ... ok
  718. Test Simple Table, multiple columns ... ok
  719. Test Simple Table with colspan ... ok
  720. Test Simple Table with colspan ... ok
  721. Test Table headings (plus colspan) ... ok
  722. Test Table headings (plus alignment) ... ok
  723. Test Indented tables, multiple columns ... ok
  724. Test Indented tables, multiple columns ... ok
  725. Test Table escaping ... ok
  726. Test Table escaping ... ok
  727. Test Table with row continuation ... ok
  728. Test Table with !#th and !#td wiki processors ... ok
  729. Test Table with wiki processors, unfinished block ... ok
  730. Test Table with wiki processors, wikimedia row sep ... ok
  731. Test Table with wiki processors, wikimedia row sep ... ok
  732. Test Table with wiki processors (tr, th and td) ... ok
  733. Test Table with wiki processors (tr, th and td) ... ok
  734. Test Table with wiki processors (table but no cells) ... ok
  735. Test Table with wiki processors (table but no cells) ... ok
  736. Test Table with wiki processors (tr but no cells) ... ok
  737. Test Table with wiki processors (tr but no cells) ... ok
  738. Test Table with wiki processors (table + multiple embedded tables) ... ok
  739. Test Table with wiki processors (table + multiple embedded tables) ... ok
  740. Test Table with wiki processors within div ... ok
  741. Test Mix of headings and lists ... ok
  742. Test Mix of headings and lists ... ok
  743. Test Mix of headings and lists ... ok
  744. Test Heading, lists and table ... ok
  745. Test Heading, lists and table ... ok
  746. Test Heading, lists and table ... ok
  747. Test Lists, indents and table ... ok
  748. Test Lists, indents and table ... ok
  749. Test "Tabstops" set by lists and quotes ... ok
  750. Test Citations (mail style, no consistent space) ... ok
  751. Test Citations (mail style, no consistent space) ... ok
  752. Test Citations (mail style, no consistent space) ... ok
  753. Test Citations (reply to style, consistent space) ... ok
  754. Test Citations (reply to style, consistent space) ... ok
  755. Test Citations of arbitrary wiki content ... ok
  756. Test Citations of arbitrary wiki content ... ok
  757. Test Citation and follow-up block ... ok
  758. Test Citation and follow-up block ... ok
  759. Test Block and follow-up citation ... ok
  760. Test Block and follow-up citation ... ok
  761. Test Bold ... ok
  762. Test Italics ... ok
  763. Test Bold and Italics ... ok
  764. Test More Bold Italics ... ok
  765. Test Bold Italics counter examples ... ok
  766. Test Headings (wikified headings + ids) ... ok
  767. Test Links - Internal, External and Interwiki ... ok
  768. Test Paragraphs ... ok
  769. Test Line breaks ... ok
  770. Test Horizontal Rule ... ok
  771. Test Nowiki (Preformatted) ... ok
  772. Test Nowiki (inline) ... ok
  773. Test Bold and/or italic links ... ok
  774. Test source: Image, no other arguments ... ok
  775. Test source: Image, no other arguments ... ok
  776. Test intertrac:source: Image, no other arguments ... ok
  777. Test intertrac:source: Image, no other arguments ... ok
  778. Test source: Image, nolink ... ok
  779. Test source: Image, nolink ... ok
  780. Test source: Image, normal args ... ok
  781. Test source: Image, normal args ... ok
  782. Test source: Image, size arg ... ok
  783. Test source: Image, keyword alignment ... ok
  784. Test http: Image, nolink ... ok
  785. Test http: Image, absolute, many ':' ... ok
  786. Test // Image, server-relative ... ok
  787. Test / Image, project-relative, link to WikiStart ... ok
  788. Test / Image, project-relative, link to WikiStart ... ok
  789. Test Strip unicode white-spaces and ZWSPs (#10668) ... ok
  790. Test Strip unicode white-spaces and ZWSPs (#10668) ... ok
  791. Test TitleIndex, default format ... ok
  792. Test TitleIndex, default format ... ok
  793. Test TitleIndex, compact format ... ok
  794. Test TitleIndex, compact format ... ok
  795. Test TitleIndex, default format ... ok
  796. Test TitleIndex, default format ... ok
  797. Test TitleIndex, compact format ... ok
  798. Test TitleIndex, compact format ... ok
  799. Test TitleIndex, default format with prefix ... ok
  800. Test TitleIndex, default format with prefix ... ok
  801. Test TitleIndex, compact format with prefix ... ok
  802. Test TitleIndex, compact format with prefix ... ok
  803. Test TitleIndex, default format with prefix hidden ... ok
  804. Test TitleIndex, default format with prefix hidden ... ok
  805. Test TitleIndex, compact format with prefix hidden ... ok
  806. Test TitleIndex, compact format with prefix hidden ... ok
  807. Test TitleIndex, group format ... ok
  808. Test TitleIndex, hierarchy format ... ok
  809. Test TitleIndex, group format, prefix hidden ... ok
  810. Test TitleIndex, hierarchy format, prefix hidden ... ok
  811. Test TitleIndex group and page with numbers (#7919) ... ok
  812. Test TitleIndex, compact format with prefix hidden, including Test0.13* ... ok
  813. Test TitleIndex, compact format with prefix hidden, including Test0.13* but excluding Test0.131 ... ok
  814. Test TitleIndex, compact format, excluding various topics ... ok
  815. Test TitleIndex, compact format, including and excluding various topics ... ok
  816. Test TitleIndex, hierarchy format with complex hierarchy ... ok
  817. Test TitleIndex, hierarchy format with complex hierarchy (and min=5) ... ok
  818. Test TitleIndex, group format with complex hierarchy ... ok
  819. Test RecentChanges, group option ... ok
  820. Test TracIni, option with empty doc (#10940) ... ok
  821. test_create_page (tests.wiki.model.ProductWikiPageTestCase) ... ok
  822. test_delete_page (tests.wiki.model.ProductWikiPageTestCase) ... ok
  823. test_delete_page_last_version (tests.wiki.model.ProductWikiPageTestCase) ... ok
  824. test_delete_page_version (tests.wiki.model.ProductWikiPageTestCase) ... ok
  825. test_existing_page (tests.wiki.model.ProductWikiPageTestCase) ... ok
  826. test_invalid_page_name (tests.wiki.model.ProductWikiPageTestCase) ... ok
  827. test_new_page (tests.wiki.model.ProductWikiPageTestCase) ... ok
  828. test_rename_page (tests.wiki.model.ProductWikiPageTestCase) ... ok
  829. test_update_page (tests.wiki.model.ProductWikiPageTestCase) ... ok
  830. Test wiki: link resolver ... ok
  831. Test wiki: link resolver + query and fragment ... ok
  832. Test WikiPageNames conformance ... ok
  833. Test WikiPageNames conformance (unicode) ... ok
  834. Test More WikiPageNames conformance ... ok
  835. Test Escaping WikiPageNames ... ok
  836. Test WikiPageNames endings ... ok
  837. Test WikiPageNames counter examples ... ok
  838. Test WikiPageNames with fragment identifier ... ok
  839. Test WikiPageNames with fragment id (performance test) ... ok
  840. Test WikiPageNames counter examples (paths) ... ok
  841. Test WikiPageNames counter examples (numbers) ... ok
  842. Test WikiPageNames counter examples (numbers) ... ok
  843. Test WikiPageNames counter examples (unicode) ... ok
  844. Test WikiPageNames counter examples (unicode) ... ok
  845. Test not a WikiPageNames at all (#9025 regression) ... ok
  846. Test not a WikiPageNames at all (#9025 regression) ... ok
  847. Test MoinMoin style forced links ... ok
  848. Test Wiki links with @version ... ok
  849. Test WikiPageName with label ... ok
  850. Test WikiPageName with label should be strict... ... ok
  851. Test InterTrac for wiki ... ok
  852. Test Wiki InterTrac shorthands ... ok
  853. Test InterWiki links ... ok
  854. Test InterWiki links with parameters and fragment ... ok
  855. Test Regression for #9712 ... ok
  856. Test Wiki links with @version using unicode digits ... ok
  857. Test Relative to the project url ... ok
  858. Test Relative to the base url ... ok
  859. Test Relative to the current page ... ok
  860. Test Relative to the current page, in wiki realm ... ok
  861. Test Relative to the current page, as CamelCase ... ok
  862. Test Relative to the current page with query strings and fragments ... ok
  863. Test Splitting relative links ... ok
  864. Test Splitting scoped links ... ok
  865. Test Splitting internal free links ... ok
  866. Test Scoped links for hierarchical pages ... ok
  867.  
  868. ======================================================================
  869. FAIL: test_all_grouped_by_milestone (tests.ticket.query.ProductQueryTestCase)
  870. ----------------------------------------------------------------------
  871. Traceback (most recent call last):
  872.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 153, in test_all_grouped_by_milestone
  873.     ORDER BY COALESCE(t.milestone,'')='',COALESCE(milestone.completed,0)=0,milestone.completed,COALESCE(milestone.due,0)=0,milestone.due,t.milestone,COALESCE(t.id,0)=0,t.id""")
  874.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  875.    self.assertEqual(sql, correct_sql, failure_message)
  876. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\n  LEFT OUTER JOIN milestone ON (milestone.name=milestone)\nORDER BY COALESCE(t.milestone,'')='',COALESCE(milestone.completed,0)=0,milestone.completed,COALESCE(milestone.due,0)=0,milestone.due,t.milestone,COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.component AS component,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\n  LEFT OUTER JOIN milestone ON (milestone.name=milestone)\nORDER BY COALESCE(t.milestone,'')='',COALESCE(milestone.completed,0)=0,milestone.completed,COALESCE(milestone.due,0)=0,milestone.due,t.milestone,COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\n  LEFT OUTER JOIN milestone ON (milestone.name=milestone)\nORDER BY COALESCE(t.milestone,'')='',COALESCE(milestone.completed,0)=0,milestone.completed,COALESCE(milestone.due,0)=0,milestone.due,t.milestone,COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.component AS component,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\n  LEFT OUTER JOIN milestone ON (milestone.name=milestone)\nORDER BY COALESCE(t.milestone,'')='',COALESCE(milestone.completed,0)=0,milestone.completed,COALESCE(milestone.due,0)=0,milestone.due,t.milestone,COALESCE(t.id,0)=0,t.id"
  877. ---  
  878. +++  
  879. @@ -4,7 +4,7 @@
  880. t.type AS type,
  881. t.status AS status,
  882. t.priority AS priority,
  883. -t.component AS component,
  884. +t.product AS product,
  885. t.milestone AS milestone,
  886. t.time AS time,
  887. t.changetime AS changetime,
  888.  
  889.  
  890. ======================================================================
  891. FAIL: test_all_grouped_by_milestone_desc (tests.ticket.query.ProductQueryTestCase)
  892. ----------------------------------------------------------------------
  893. Traceback (most recent call last):
  894.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 165, in test_all_grouped_by_milestone_desc
  895.    ORDER BY COALESCE(t.milestone,'')='' DESC,COALESCE(milestone.completed,0)=0 DESC,milestone.completed DESC,COALESCE(milestone.due,0)=0 DESC,milestone.due DESC,t.milestone DESC,COALESCE(t.id,0)=0,t.id""")
  896.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  897.     self.assertEqual(sql, correct_sql, failure_message)
  898. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\n  LEFT OUTER JOIN milestone ON (milestone.name=milestone)\nORDER BY COALESCE(t.milestone,'')='' DESC,COALESCE(milestone.completed,0)=0 DESC,milestone.completed DESC,COALESCE(milestone.due,0)=0 DESC,milestone.due DESC,t.milestone DESC,COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.component AS component,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\n  LEFT OUTER JOIN milestone ON (milestone.name=milestone)\nORDER BY COALESCE(t.milestone,'')='' DESC,COALESCE(milestone.completed,0)=0 DESC,milestone.completed DESC,COALESCE(milestone.due,0)=0 DESC,milestone.due DESC,t.milestone DESC,COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\n  LEFT OUTER JOIN milestone ON (milestone.name=milestone)\nORDER BY COALESCE(t.milestone,'')='' DESC,COALESCE(milestone.completed,0)=0 DESC,milestone.completed DESC,COALESCE(milestone.due,0)=0 DESC,milestone.due DESC,t.milestone DESC,COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.component AS component,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\n  LEFT OUTER JOIN milestone ON (milestone.name=milestone)\nORDER BY COALESCE(t.milestone,'')='' DESC,COALESCE(milestone.completed,0)=0 DESC,milestone.completed DESC,COALESCE(milestone.due,0)=0 DESC,milestone.due DESC,t.milestone DESC,COALESCE(t.id,0)=0,t.id"
  899. ---  
  900. +++  
  901. @@ -4,7 +4,7 @@
  902.  t.type AS type,
  903.  t.status AS status,
  904.  t.priority AS priority,
  905. -t.component AS component,
  906. +t.product AS product,
  907.  t.milestone AS milestone,
  908.  t.time AS time,
  909.  t.changetime AS changetime,
  910.  
  911.  
  912. ======================================================================
  913. FAIL: test_all_ordered_by_id (tests.ticket.query.ProductQueryTestCase)
  914. ----------------------------------------------------------------------
  915. Traceback (most recent call last):
  916.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 48, in test_all_ordered_by_id
  917.     ORDER BY COALESCE(t.id,0)=0,t.id""")
  918.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  919.    self.assertEqual(sql, correct_sql, failure_message)
  920. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id"
  921. ---  
  922. +++  
  923. @@ -4,7 +4,7 @@
  924. t.type AS type,
  925. t.status AS status,
  926. t.priority AS priority,
  927. -t.milestone AS milestone,
  928. +t.product AS product,
  929. t.time AS time,
  930. t.changetime AS changetime,
  931. priority.value AS priority_value,
  932.  
  933.  
  934. ======================================================================
  935. FAIL: test_all_ordered_by_id_desc (tests.ticket.query.ProductQueryTestCase)
  936. ----------------------------------------------------------------------
  937. Traceback (most recent call last):
  938.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 59, in test_all_ordered_by_id_desc
  939.    ORDER BY COALESCE(t.id,0)=0 DESC,t.id DESC""")
  940.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  941.     self.assertEqual(sql, correct_sql, failure_message)
  942. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0 DESC,t.id DESC" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0 DESC,t.id DESC" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0 DESC,t.id DESC" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0 DESC,t.id DESC"
  943. ---  
  944. +++  
  945. @@ -4,7 +4,7 @@
  946.  t.type AS type,
  947.  t.status AS status,
  948.  t.priority AS priority,
  949. -t.milestone AS milestone,
  950. +t.product AS product,
  951.  t.time AS time,
  952.  t.changetime AS changetime,
  953.  priority.value AS priority_value,
  954.  
  955.  
  956. ======================================================================
  957. FAIL: test_all_ordered_by_id_from_unicode (tests.ticket.query.ProductQueryTestCase)
  958. ----------------------------------------------------------------------
  959. Traceback (most recent call last):
  960.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 81, in test_all_ordered_by_id_from_unicode
  961.     ORDER BY COALESCE(t.id,0)=0,t.id""")
  962.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  963.    self.assertEqual(sql, correct_sql, failure_message)
  964. AssertionError: u"SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id" : u"SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id"
  965. ---  
  966. +++  
  967. @@ -4,7 +4,7 @@
  968. t.type AS type,
  969. t.status AS status,
  970. t.priority AS priority,
  971. -t.milestone AS milestone,
  972. +t.product AS product,
  973. t.time AS time,
  974. t.changetime AS changetime,
  975. priority.value AS priority_value,
  976.  
  977.  
  978. ======================================================================
  979. FAIL: test_all_ordered_by_id_verbose (tests.ticket.query.ProductQueryTestCase)
  980. ----------------------------------------------------------------------
  981. Traceback (most recent call last):
  982.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 70, in test_all_ordered_by_id_verbose
  983.    ORDER BY COALESCE(t.id,0)=0,t.id""")
  984.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  985.     self.assertEqual(sql, correct_sql, failure_message)
  986. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.reporter AS reporter,t.description AS description,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.reporter AS reporter,t.description AS description,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.reporter AS reporter,t.description AS description,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.reporter AS reporter,t.description AS description,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id"
  987. ---  
  988. +++  
  989. @@ -4,7 +4,7 @@
  990.  t.type AS type,
  991.  t.status AS status,
  992.  t.priority AS priority,
  993. -t.milestone AS milestone,
  994. +t.product AS product,
  995.  t.reporter AS reporter,
  996.  t.description AS description,
  997.  t.time AS time,
  998.  
  999.  
  1000. ======================================================================
  1001. FAIL: test_all_ordered_by_priority (tests.ticket.query.ProductQueryTestCase)
  1002. ----------------------------------------------------------------------
  1003. Traceback (most recent call last):
  1004.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 93, in test_all_ordered_by_priority
  1005.     'cast_priority': self.env.get_read_db().cast('priority.value', 'int')})
  1006.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1007.     self.assertEqual(sql, correct_sql, failure_message)
  1008. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(priority.value,'')='',CAST(priority.value AS integer),t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(priority.value,'')='',CAST(priority.value AS integer),t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(priority.value,'')='',CAST(priority.value AS integer),t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(priority.value,'')='',CAST(priority.value AS integer),t.id"
  1009. ---  
  1010. +++  
  1011. @@ -4,7 +4,7 @@
  1012.  t.type AS type,
  1013.  t.status AS status,
  1014.  t.priority AS priority,
  1015. -t.milestone AS milestone,
  1016. +t.product AS product,
  1017.  t.time AS time,
  1018.  t.changetime AS changetime,
  1019.  priority.value AS priority_value,
  1020.  
  1021.  
  1022. ======================================================================
  1023. FAIL: test_all_ordered_by_priority_desc (tests.ticket.query.ProductQueryTestCase)
  1024. ----------------------------------------------------------------------
  1025. Traceback (most recent call last):
  1026.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 105, in test_all_ordered_by_priority_desc
  1027.     'cast_priority': self.env.get_read_db().cast('priority.value', 'int')})
  1028.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1029.     self.assertEqual(sql, correct_sql, failure_message)
  1030. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(priority.value,'')='' DESC,CAST(priority.value AS integer) DESC,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(priority.value,'')='' DESC,CAST(priority.value AS integer) DESC,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(priority.value,'')='' DESC,CAST(priority.value AS integer) DESC,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(priority.value,'')='' DESC,CAST(priority.value AS integer) DESC,t.id"
  1031. ---  
  1032. +++  
  1033. @@ -4,7 +4,7 @@
  1034.  t.type AS type,
  1035.  t.status AS status,
  1036.  t.priority AS priority,
  1037. -t.milestone AS milestone,
  1038. +t.product AS product,
  1039.  t.time AS time,
  1040.  t.changetime AS changetime,
  1041.  priority.value AS priority_value,
  1042.  
  1043.  
  1044. ======================================================================
  1045. FAIL: test_constrained_by_custom_field (tests.ticket.query.ProductQueryTestCase)
  1046. ----------------------------------------------------------------------
  1047. Traceback (most recent call last):
  1048.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 265, in test_constrained_by_custom_field
  1049.     ORDER BY COALESCE(t.id,0)=0,t.id""" % ((foo,) * 6))
  1050.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1051.    self.assertEqual(sql, correct_sql, failure_message)
  1052. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value,`foo`.value AS `foo`\nFROM ticket AS t\n  LEFT OUTER JOIN ticket_custom AS `foo` ON (id=`foo`.ticket AND `foo`.name='foo')\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(`foo`.value,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value,`foo`.value AS `foo`\nFROM ticket AS t\n  LEFT OUTER JOIN ticket_custom AS `foo` ON (id=`foo`.ticket AND `foo`.name='foo')\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(`foo`.value,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value,`foo`.value AS `foo`\nFROM ticket AS t\n  LEFT OUTER JOIN ticket_custom AS `foo` ON (id=`foo`.ticket AND `foo`.name='foo')\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(`foo`.value,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value,`foo`.value AS `foo`\nFROM ticket AS t\n  LEFT OUTER JOIN ticket_custom AS `foo` ON (id=`foo`.ticket AND `foo`.name='foo')\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(`foo`.value,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id"
  1053. ---  
  1054. +++  
  1055. @@ -4,7 +4,7 @@
  1056. t.type AS type,
  1057. t.status AS status,
  1058. t.priority AS priority,
  1059. -t.milestone AS milestone,
  1060. +t.product AS product,
  1061. t.time AS time,
  1062. t.changetime AS changetime,
  1063. priority.value AS priority_value,
  1064.  
  1065.  
  1066. ======================================================================
  1067. FAIL: test_constrained_by_empty_value_contains (tests.ticket.query.ProductQueryTestCase)
  1068. ----------------------------------------------------------------------
  1069. Traceback (most recent call last):
  1070.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 330, in test_constrained_by_empty_value_contains
  1071.    ORDER BY COALESCE(t.id,0)=0,t.id""")
  1072.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1073.     self.assertEqual(sql, correct_sql, failure_message)
  1074. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id"
  1075. ---  
  1076. +++  
  1077. @@ -4,7 +4,7 @@
  1078.  t.type AS type,
  1079.  t.status AS status,
  1080.  t.priority AS priority,
  1081. -t.milestone AS milestone,
  1082. +t.product AS product,
  1083.  t.time AS time,
  1084.  t.changetime AS changetime,
  1085.  priority.value AS priority_value,
  1086.  
  1087.  
  1088. ======================================================================
  1089. FAIL: test_constrained_by_empty_value_endswith (tests.ticket.query.ProductQueryTestCase)
  1090. ----------------------------------------------------------------------
  1091. Traceback (most recent call last):
  1092.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 352, in test_constrained_by_empty_value_endswith
  1093.     ORDER BY COALESCE(t.id,0)=0,t.id""")
  1094.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1095.    self.assertEqual(sql, correct_sql, failure_message)
  1096. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id"
  1097. ---  
  1098. +++  
  1099. @@ -4,7 +4,7 @@
  1100. t.type AS type,
  1101. t.status AS status,
  1102. t.priority AS priority,
  1103. -t.milestone AS milestone,
  1104. +t.product AS product,
  1105. t.time AS time,
  1106. t.changetime AS changetime,
  1107. priority.value AS priority_value,
  1108.  
  1109.  
  1110. ======================================================================
  1111. FAIL: test_constrained_by_empty_value_startswith (tests.ticket.query.ProductQueryTestCase)
  1112. ----------------------------------------------------------------------
  1113. Traceback (most recent call last):
  1114.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 341, in test_constrained_by_empty_value_startswith
  1115.    ORDER BY COALESCE(t.id,0)=0,t.id""")
  1116.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1117.     self.assertEqual(sql, correct_sql, failure_message)
  1118. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(t.id,0)=0,t.id"
  1119. ---  
  1120. +++  
  1121. @@ -4,7 +4,7 @@
  1122.  t.type AS type,
  1123.  t.status AS status,
  1124.  t.priority AS priority,
  1125. -t.milestone AS milestone,
  1126. +t.product AS product,
  1127.  t.time AS time,
  1128.  t.changetime AS changetime,
  1129.  priority.value AS priority_value,
  1130.  
  1131.  
  1132. ======================================================================
  1133. FAIL: test_constrained_by_milestone (tests.ticket.query.ProductQueryTestCase)
  1134. ----------------------------------------------------------------------
  1135. Traceback (most recent call last):
  1136.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 141, in test_constrained_by_milestone
  1137.     ORDER BY COALESCE(t.id,0)=0,t.id""")
  1138.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1139.    self.assertEqual(sql, correct_sql, failure_message)
  1140. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,t.milestone AS milestone,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.milestone,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.component AS component,t.time AS time,t.changetime AS changetime,t.milestone AS milestone,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.milestone,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,t.milestone AS milestone,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.milestone,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.component AS component,t.time AS time,t.changetime AS changetime,t.milestone AS milestone,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.milestone,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id"
  1141. ---  
  1142. +++  
  1143. @@ -4,7 +4,7 @@
  1144. t.type AS type,
  1145. t.status AS status,
  1146. t.priority AS priority,
  1147. -t.component AS component,
  1148. +t.product AS product,
  1149. t.time AS time,
  1150. t.changetime AS changetime,
  1151. t.milestone AS milestone,
  1152.  
  1153.  
  1154. ======================================================================
  1155. FAIL: test_constrained_by_milestone_or_version (tests.ticket.query.ProductQueryTestCase)
  1156. ----------------------------------------------------------------------
  1157. Traceback (most recent call last):
  1158.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 442, in test_constrained_by_milestone_or_version
  1159.    ORDER BY COALESCE(t.id,0)=0,t.id""")
  1160.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1161.     self.assertEqual(sql, correct_sql, failure_message)
  1162. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,t.version AS version,t.milestone AS milestone,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.milestone,'')=%s)) OR ((COALESCE(t.version,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.component AS component,t.time AS time,t.changetime AS changetime,t.version AS version,t.milestone AS milestone,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.milestone,'')=%s)) OR ((COALESCE(t.version,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,t.version AS version,t.milestone AS milestone,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.milestone,'')=%s)) OR ((COALESCE(t.version,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.component AS component,t.time AS time,t.changetime AS changetime,t.version AS version,t.milestone AS milestone,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.milestone,'')=%s)) OR ((COALESCE(t.version,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id"
  1163. ---  
  1164. +++  
  1165. @@ -4,7 +4,7 @@
  1166.  t.type AS type,
  1167.  t.status AS status,
  1168.  t.priority AS priority,
  1169. -t.component AS component,
  1170. +t.product AS product,
  1171.  t.time AS time,
  1172.  t.changetime AS changetime,
  1173.  t.version AS version,
  1174.  
  1175.  
  1176. ======================================================================
  1177. FAIL: test_constrained_by_multiple_owners (tests.ticket.query.ProductQueryTestCase)
  1178. ----------------------------------------------------------------------
  1179. Traceback (most recent call last):
  1180.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 293, in test_constrained_by_multiple_owners
  1181.     ORDER BY COALESCE(t.id,0)=0,t.id""")
  1182.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1183.    self.assertEqual(sql, correct_sql, failure_message)
  1184. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE (COALESCE(t.owner,'') IN (%s,%s))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE (COALESCE(t.owner,'') IN (%s,%s))\nORDER BY COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE (COALESCE(t.owner,'') IN (%s,%s))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE (COALESCE(t.owner,'') IN (%s,%s))\nORDER BY COALESCE(t.id,0)=0,t.id"
  1185. ---  
  1186. +++  
  1187. @@ -4,7 +4,7 @@
  1188. t.type AS type,
  1189. t.status AS status,
  1190. t.priority AS priority,
  1191. -t.milestone AS milestone,
  1192. +t.product AS product,
  1193. t.time AS time,
  1194. t.changetime AS changetime,
  1195. priority.value AS priority_value,
  1196.  
  1197.  
  1198. ======================================================================
  1199. FAIL: test_constrained_by_multiple_owners_contain (tests.ticket.query.ProductQueryTestCase)
  1200. ----------------------------------------------------------------------
  1201. Traceback (most recent call last):
  1202.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 320, in test_constrained_by_multiple_owners_contain
  1203.    ORDER BY COALESCE(t.id,0)=0,t.id""" % {'like': self.env.get_read_db().like()})
  1204.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1205.     self.assertEqual(sql, correct_sql, failure_message)
  1206. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') LIKE %s ESCAPE '/' OR COALESCE(t.owner,'') LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') LIKE %s ESCAPE '/' OR COALESCE(t.owner,'') LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') LIKE %s ESCAPE '/' OR COALESCE(t.owner,'') LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') LIKE %s ESCAPE '/' OR COALESCE(t.owner,'') LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id"
  1207. ---  
  1208. +++  
  1209. @@ -4,7 +4,7 @@
  1210.  t.type AS type,
  1211.  t.status AS status,
  1212.  t.priority AS priority,
  1213. -t.milestone AS milestone,
  1214. +t.product AS product,
  1215.  t.time AS time,
  1216.  t.changetime AS changetime,
  1217.  priority.value AS priority_value,
  1218.  
  1219.  
  1220. ======================================================================
  1221. FAIL: test_constrained_by_multiple_owners_not (tests.ticket.query.ProductQueryTestCase)
  1222. ----------------------------------------------------------------------
  1223. Traceback (most recent call last):
  1224.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 306, in test_constrained_by_multiple_owners_not
  1225.     ORDER BY COALESCE(t.id,0)=0,t.id""")
  1226.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1227.    self.assertEqual(sql, correct_sql, failure_message)
  1228. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE (COALESCE(t.owner,'') NOT IN (%s,%s))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE (COALESCE(t.owner,'') NOT IN (%s,%s))\nORDER BY COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE (COALESCE(t.owner,'') NOT IN (%s,%s))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE (COALESCE(t.owner,'') NOT IN (%s,%s))\nORDER BY COALESCE(t.id,0)=0,t.id"
  1229. ---  
  1230. +++  
  1231. @@ -4,7 +4,7 @@
  1232. t.type AS type,
  1233. t.status AS status,
  1234. t.priority AS priority,
  1235. -t.milestone AS milestone,
  1236. +t.product AS product,
  1237. t.time AS time,
  1238. t.changetime AS changetime,
  1239. priority.value AS priority_value,
  1240.  
  1241.  
  1242. ======================================================================
  1243. FAIL: test_constrained_by_owner_beginswith (tests.ticket.query.ProductQueryTestCase)
  1244. ----------------------------------------------------------------------
  1245. Traceback (most recent call last):
  1246.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 238, in test_constrained_by_owner_beginswith
  1247.    ORDER BY COALESCE(t.id,0)=0,t.id""" % {'like': self.env.get_read_db().like()})
  1248.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1249.     self.assertEqual(sql, correct_sql, failure_message)
  1250. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id"
  1251. ---  
  1252. +++  
  1253. @@ -4,7 +4,7 @@
  1254.  t.type AS type,
  1255.  t.status AS status,
  1256.  t.priority AS priority,
  1257. -t.milestone AS milestone,
  1258. +t.product AS product,
  1259.  t.time AS time,
  1260.  t.changetime AS changetime,
  1261.  priority.value AS priority_value,
  1262.  
  1263.  
  1264. ======================================================================
  1265. FAIL: test_constrained_by_owner_containing (tests.ticket.query.ProductQueryTestCase)
  1266. ----------------------------------------------------------------------
  1267. Traceback (most recent call last):
  1268.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 214, in test_constrained_by_owner_containing
  1269.     ORDER BY COALESCE(t.id,0)=0,t.id""" % {'like': self.env.get_read_db().like()})
  1270.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1271.    self.assertEqual(sql, correct_sql, failure_message)
  1272. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id"
  1273. ---  
  1274. +++  
  1275. @@ -4,7 +4,7 @@
  1276. t.type AS type,
  1277. t.status AS status,
  1278. t.priority AS priority,
  1279. -t.milestone AS milestone,
  1280. +t.product AS product,
  1281. t.time AS time,
  1282. t.changetime AS changetime,
  1283. priority.value AS priority_value,
  1284.  
  1285.  
  1286. ======================================================================
  1287. FAIL: test_constrained_by_owner_endswith (tests.ticket.query.ProductQueryTestCase)
  1288. ----------------------------------------------------------------------
  1289. Traceback (most recent call last):
  1290.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 250, in test_constrained_by_owner_endswith
  1291.    ORDER BY COALESCE(t.id,0)=0,t.id""" % {'like': self.env.get_read_db().like()})
  1292.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1293.     self.assertEqual(sql, correct_sql, failure_message)
  1294. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id"
  1295. ---  
  1296. +++  
  1297. @@ -4,7 +4,7 @@
  1298.  t.type AS type,
  1299.  t.status AS status,
  1300.  t.priority AS priority,
  1301. -t.milestone AS milestone,
  1302. +t.product AS product,
  1303.  t.time AS time,
  1304.  t.changetime AS changetime,
  1305.  priority.value AS priority_value,
  1306.  
  1307.  
  1308. ======================================================================
  1309. FAIL: test_constrained_by_owner_not_containing (tests.ticket.query.ProductQueryTestCase)
  1310. ----------------------------------------------------------------------
  1311. Traceback (most recent call last):
  1312.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 226, in test_constrained_by_owner_not_containing
  1313.     ORDER BY COALESCE(t.id,0)=0,t.id""" % {'like': self.env.get_read_db().like()})
  1314.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1315.    self.assertEqual(sql, correct_sql, failure_message)
  1316. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') NOT LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') NOT LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') NOT LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'') NOT LIKE %s ESCAPE '/'))\nORDER BY COALESCE(t.id,0)=0,t.id"
  1317. ---  
  1318. +++  
  1319. @@ -4,7 +4,7 @@
  1320. t.type AS type,
  1321. t.status AS status,
  1322. t.priority AS priority,
  1323. -t.milestone AS milestone,
  1324. +t.product AS product,
  1325. t.time AS time,
  1326. t.changetime AS changetime,
  1327. priority.value AS priority_value,
  1328.  
  1329.  
  1330. ======================================================================
  1331. FAIL: test_constrained_by_status (tests.ticket.query.ProductQueryTestCase)
  1332. ----------------------------------------------------------------------
  1333. Traceback (most recent call last):
  1334.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 202, in test_constrained_by_status
  1335.    ORDER BY COALESCE(t.id,0)=0,t.id""")
  1336.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1337.     self.assertEqual(sql, correct_sql, failure_message)
  1338. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.status AS status,t.owner AS owner,t.type AS type,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE (COALESCE(t.status,'') IN (%s,%s,%s))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.status AS status,t.owner AS owner,t.type AS type,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE (COALESCE(t.status,'') IN (%s,%s,%s))\nORDER BY COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.status AS status,t.owner AS owner,t.type AS type,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE (COALESCE(t.status,'') IN (%s,%s,%s))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.status AS status,t.owner AS owner,t.type AS type,t.priority AS priority,t.milestone AS milestone,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE (COALESCE(t.status,'') IN (%s,%s,%s))\nORDER BY COALESCE(t.id,0)=0,t.id"
  1339. ---  
  1340. +++  
  1341. @@ -4,7 +4,7 @@
  1342.  t.owner AS owner,
  1343.  t.type AS type,
  1344.  t.priority AS priority,
  1345. -t.milestone AS milestone,
  1346. +t.product AS product,
  1347.  t.time AS time,
  1348.  t.changetime AS changetime,
  1349.  priority.value AS priority_value,
  1350.  
  1351.  
  1352. ======================================================================
  1353. FAIL: test_equal_in_value (tests.ticket.query.ProductQueryTestCase)
  1354. ----------------------------------------------------------------------
  1355. Traceback (most recent call last):
  1356.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 455, in test_equal_in_value
  1357.     ORDER BY COALESCE(t.id,0)=0,t.id""")
  1358.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1359.    self.assertEqual(sql, correct_sql, failure_message)
  1360. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.priority AS priority,t.product AS product,t.milestone AS milestone,t.status AS status,t.time AS time,t.changetime AS changetime,t.version AS version,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.status,'')=%s) AND (COALESCE(t.version,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.priority AS priority,t.milestone AS milestone,t.component AS component,t.status AS status,t.time AS time,t.changetime AS changetime,t.version AS version,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.status,'')=%s) AND (COALESCE(t.version,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.priority AS priority,t.product AS product,t.milestone AS milestone,t.status AS status,t.time AS time,t.changetime AS changetime,t.version AS version,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.status,'')=%s) AND (COALESCE(t.version,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.priority AS priority,t.milestone AS milestone,t.component AS component,t.status AS status,t.time AS time,t.changetime AS changetime,t.version AS version,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.status,'')=%s) AND (COALESCE(t.version,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id"
  1361. ---  
  1362. +++  
  1363. @@ -3,8 +3,8 @@
  1364. t.owner AS owner,
  1365. t.type AS type,
  1366. t.priority AS priority,
  1367. +t.product AS product,
  1368. t.milestone AS milestone,
  1369. -t.component AS component,
  1370. t.status AS status,
  1371. t.time AS time,
  1372. t.changetime AS changetime,
  1373.  
  1374.  
  1375. ======================================================================
  1376. FAIL: test_grouped_by_custom_field (tests.ticket.query.ProductQueryTestCase)
  1377. ----------------------------------------------------------------------
  1378. Traceback (most recent call last):
  1379.  File "/path/to/bloodhound/bloodhound_multiproduct/tests/ticket/query.py", line 63, in test_grouped_by_custom_field
  1380.    ((foo,) * 7))
  1381.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1382.    self.assertEqual(sql, correct_sql, failure_message)
  1383. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value,`foo`.value AS `foo`\nFROM ticket AS t\n  LEFT OUTER JOIN ticket_custom AS `foo` ON (id=`foo`.ticket AND `foo`.name='foo')\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(`foo`.value,'')='',`foo`.value,COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value,`foo`.value AS `foo`\nFROM ticket AS t\n  LEFT OUTER JOIN ticket_custom AS `foo` ON (id=`foo`.ticket AND `foo`.name='foo')\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(`foo`.value,'')='',`foo`.value,COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value,`foo`.value AS `foo`\nFROM ticket AS t\n  LEFT OUTER JOIN ticket_custom AS `foo` ON (id=`foo`.ticket AND `foo`.name='foo')\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(`foo`.value,'')='',`foo`.value,COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value,`foo`.value AS `foo`\nFROM ticket AS t\n  LEFT OUTER JOIN ticket_custom AS `foo` ON (id=`foo`.ticket AND `foo`.name='foo')\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(`foo`.value,'')='',`foo`.value,COALESCE(t.id,0)=0,t.id"
  1384. ---  
  1385. +++  
  1386. @@ -4,7 +4,6 @@
  1387. t.type AS type,
  1388. t.status AS status,
  1389. t.priority AS priority,
  1390. -t.milestone AS milestone,
  1391. t.product AS product,
  1392. t.time AS time,
  1393. t.changetime AS changetime,
  1394.  
  1395.  
  1396. ======================================================================
  1397. FAIL: test_grouped_by_priority (tests.ticket.query.ProductQueryTestCase)
  1398. ----------------------------------------------------------------------
  1399. Traceback (most recent call last):
  1400.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 177, in test_grouped_by_priority
  1401.    'cast_priority': self.env.get_read_db().cast('priority.value', 'int')})
  1402.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1403.    self.assertEqual(sql, correct_sql, failure_message)
  1404. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.product AS product,t.milestone AS milestone,t.priority AS priority,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(priority.value,'')='',CAST(priority.value AS integer),t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.milestone AS milestone,t.component AS component,t.priority AS priority,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(priority.value,'')='',CAST(priority.value AS integer),t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.product AS product,t.milestone AS milestone,t.priority AS priority,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(priority.value,'')='',CAST(priority.value AS integer),t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.milestone AS milestone,t.component AS component,t.priority AS priority,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nORDER BY COALESCE(priority.value,'')='',CAST(priority.value AS integer),t.id"
  1405. ---  
  1406. +++  
  1407. @@ -3,8 +3,8 @@
  1408. t.owner AS owner,
  1409. t.type AS type,
  1410. t.status AS status,
  1411. +t.product AS product,
  1412. t.milestone AS milestone,
  1413. -t.component AS component,
  1414. t.priority AS priority,
  1415. t.time AS time,
  1416. t.changetime AS changetime,
  1417.  
  1418.  
  1419. ======================================================================
  1420. FAIL: test_special_character_escape (tests.ticket.query.ProductQueryTestCase)
  1421. ----------------------------------------------------------------------
  1422. Traceback (most recent call last):
  1423.  File "/path/to/bloodhound/bloodhound_multiproduct/tests/ticket/query.py", line 76, in test_special_character_escape
  1424.    ORDER BY COALESCE(t.id,0)=0,t.id""")
  1425.   File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1426.     self.assertEqual(sql, correct_sql, failure_message)
  1427. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.status AS status,t.owner AS owner,t.type AS type,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE (COALESCE(t.status,'') IN (%s,%s,%s))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.status AS status,t.owner AS owner,t.type AS type,t.priority AS priority,t.milestone AS milestone,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE (COALESCE(t.status,'') IN (%s,%s,%s))\nORDER BY COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.status AS status,t.owner AS owner,t.type AS type,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE (COALESCE(t.status,'') IN (%s,%s,%s))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.status AS status,t.owner AS owner,t.type AS type,t.priority AS priority,t.milestone AS milestone,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE (COALESCE(t.status,'') IN (%s,%s,%s))\nORDER BY COALESCE(t.id,0)=0,t.id"
  1428. ---  
  1429. +++  
  1430. @@ -4,7 +4,6 @@
  1431.  t.owner AS owner,
  1432.  t.type AS type,
  1433.  t.priority AS priority,
  1434. -t.milestone AS milestone,
  1435.  t.product AS product,
  1436.  t.time AS time,
  1437.  t.changetime AS changetime,
  1438.  
  1439.  
  1440. ======================================================================
  1441. FAIL: test_user_var (tests.ticket.query.ProductQueryTestCase)
  1442. ----------------------------------------------------------------------
  1443. Traceback (most recent call last):
  1444.   File "/path/to/bloodhound/bloodhound_multiproduct/tests/ticket/query.py", line 88, in test_user_var
  1445.     ORDER BY COALESCE(t.id,0)=0,t.id""")
  1446.  File "/path/to/bloodhound/trac/trac/ticket/tests/query.py", line 31, in assertEqualSQL
  1447.    self.assertEqual(sql, correct_sql, failure_message)
  1448. AssertionError: "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id" : "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id" != "SELECT t.id AS id,t.summary AS summary,t.owner AS owner,t.type AS type,t.status AS status,t.priority AS priority,t.milestone AS milestone,t.product AS product,t.time AS time,t.changetime AS changetime,priority.value AS priority_value\nFROM ticket AS t\n  LEFT OUTER JOIN enum AS priority ON (priority.type='priority' AND priority.name=priority)\nWHERE ((COALESCE(t.owner,'')=%s))\nORDER BY COALESCE(t.id,0)=0,t.id"
  1449. ---  
  1450. +++  
  1451. @@ -4,7 +4,6 @@
  1452. t.type AS type,
  1453. t.status AS status,
  1454. t.priority AS priority,
  1455. -t.milestone AS milestone,
  1456. t.product AS product,
  1457. t.time AS time,
  1458. t.changetime AS changetime,
  1459.  
  1460.  
  1461. ----------------------------------------------------------------------
  1462. Ran 851 tests in 2591.405s
  1463.  
  1464. FAILED (failures=27)
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!