Project

General

Profile

Actions
Copy link

Defect #19106

closed

IssueTest#test_visible_scope_for_member_with_groups_should_return_assigned_issues always fails

Added by Toshi MARUYAMA almost 10 years ago. Updated almost 10 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Affected version:

Description

As I described at #14534#note-41, test always fails on trunk r13998.

On SQLite3 ruby 1.9.3p551 (2014-11-13 revision 48407) [x86_64-linux]:

$ ruby test/unit/issue_test.rb
Run options: --seed 16583

# Running:

........................................F.......................
................................................................
................................................................
.........................

Finished in 20.813147s, 10.4261 runs/s, 28.9240 assertions/s.

  1) Failure:
IssueTest#test_visible_scope_for_member_with_groups_should_return_assigned_issues [test/unit/issue_test.rb:324]:
Failed assertion, no message given.

217 runs, 602 assertions, 1 failures, 0 errors, 0 skips

Files

Download all files
test.log (121 KB) test.log Toshi MARUYAMA, 2015-02-14 12:10
result.txt (1.98 KB) result.txt Toshi MARUYAMA, 2015-02-14 13:26
Actions
Copy link
 #1

Updated by Jean-Philippe Lang almost 10 years ago

Works for me with this ruby version and sqlite3:

C:\workspace\trunk>ruby test\unit\issue_test.rb --seed 16583
Run options: --seed 16583

# Running:

................................................................................
................................................................................
.........................................................

Finished in 17.886023s, 12.1324 runs/s, 33.6576 assertions/s.

217 runs, 602 assertions, 0 failures, 0 errors, 0 skips

C:\workspace\trunk>ruby --version
ruby 1.9.3p551 (2014-11-13) [i386-mingw32]

Does it fail when you run the full test suite?

Actions
Copy link
 #2

Updated by Toshi MARUYAMA almost 10 years ago

Fails.

$ rake test:units
Version: ImageMagick 6.5.4-7 2014-02-10 Q16 OpenMP http://www.imagemagick.org
Copyright: Copyright (C) 1999-2009 ImageMagick Studio LLC

(Test LDAP server not configured)
Bazaar test repository NOT FOUND. Skipping unit tests !!!
Cvs test repository NOT FOUND. Skipping unit tests !!!
Darcs test repository NOT FOUND. Skipping unit tests !!!
Filesystem test repository NOT FOUND. Skipping unit tests !!! See doc/RUNNING_TESTS.
Git test repository NOT FOUND. Skipping unit tests !!!
Mercurial test repository NOT FOUND. Skipping unit tests !!!
Subversion test repository NOT FOUND. Skipping unit tests !!!
Bazaar test repository NOT FOUND. Skipping unit tests !!!
CVS test repository NOT FOUND. Skipping unit tests !!!
Darcs test repository NOT FOUND. Skipping unit tests !!!
Filesystem test repository NOT FOUND. Skipping unit tests !!! See doc/RUNNING_TESTS.
Git test repository NOT FOUND. Skipping unit tests !!!
Mercurial test repository NOT FOUND. Skipping unit tests !!!
Subversion test repository NOT FOUND. Skipping unit tests !!!
Skipping LDAP tests.
Run options: --seed 3007

# Running:

S.....................................................................................................................................................................................................................................................................................................................................................................................................................F..............................................................................................................S.............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................

Finished in 198.634379s, 9.5200 runs/s, 62.9700 assertions/s.

  1) Failure:
IssueTest#test_visible_scope_for_member_with_groups_should_return_assigned_issues [/REDMINE/hg-workdir/redmine-bb-all/test/unit/issue_test.rb:324]:
Failed assertion, no message given.

1891 runs, 12508 assertions, 1 failures, 0 errors, 2 skips

You have skipped tests. Run with --verbose for details.
Actions
Copy link
 #3

Updated by Jean-Philippe Lang almost 10 years ago

Could you attach the log that you get for this single test?

Actions
Copy link
 #4

Updated by Toshi MARUYAMA almost 10 years ago

This is log.

$ ruby test/unit/issue_test.rb -n IssueTest#test_visible_scope_for_member_with_groups_should_return_assigned_issues
Run options: -n IssueTest#test_visible_scope_for_member_with_groups_should_return_assigned_issues --seed 20234

# Running:

F

Finished in 1.741598s, 0.5742 runs/s, 2.8709 assertions/s.

  1) Failure:
IssueTest#test_visible_scope_for_member_with_groups_should_return_assigned_issues [test/unit/issue_test.rb:324]:
Failed assertion, no message given.

1 runs, 5 assertions, 1 failures, 0 errors, 0 skips

Actions
Copy link
 #5

Updated by Jean-Philippe Lang almost 10 years ago

Thanks. The issue query seems OK and should return the created issue. Can you run it at r14005, the assertion should be more verbose.

Actions
Copy link
 #6

Updated by Toshi MARUYAMA almost 10 years ago

I have attached.

Actions
Copy link
 #7

Updated by Jean-Philippe Lang almost 10 years ago

No idea. The query that is generated should return the issue created with project_id=1 assigned_to_id=10

SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" 
WHERE (((projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))
AND (projects.id IN (5) OR (projects.id IN (5,2,1) AND ((issues.author_id = 8 OR issues.assigned_to_id IN (8,10,11)))))))

The query just before returns it and differs only with an additional issues.is_private = 'f' condition which doesn't match because the created issue is private:

SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" 
WHERE (((projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))
AND (projects.id IN (5) OR (projects.id IN (5,2,1) AND ((issues.is_private = 'f' OR issues.author_id = 8 OR issues.assigned_to_id IN (8,10,11)))))))
Actions
Copy link
 #8

Updated by Toshi MARUYAMA almost 10 years ago

  • Status changed from New to Closed
  • Target version deleted (3.0.0)

I replaced CentOS6 sqlite-3.6.20-1 by Fedora rawhide sqlite-3.8.8-2.fc22.src.rpm.
Then this test passes.

Actions
Copy link

Also available in: Atom PDF