thr3ads.net - Rails core - Rails AR/SQLServer Unit Test: [6846] failed (getting worse) [May 2007]

If this information is useful, please help other people find it:
Share via:
Rich Cox
2007-May-25 22:10 UTC
Rails AR/SQLServer Unit Test: [6846] failed (getting worse)

"bitsweat" has kicked AR/SQLServer while it was down...

http://dev.rubyonrails.org/changeset/6846
------------------------------------------------------------------------
r6846 | bitsweat | 2007-05-25 15:05:57 -0700 (Fri, 25 May 2007) | 1 line

Typo in [6845]. References #8437.
------------------------------------------------------------------------

U    activerecord\test\finder_test.rb
Updated to revision 6846.

  1) Error:
test_limited_eager_with_multiple_order_columns(EagerAssociationTest):
ActiveRecord::StatementInvalid: DBI::DatabaseError: Execute
    OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server
      ORDER BY items must appear in the select list if SELECT DISTINCT is
specified.
    HRESULT error code:0x80020009
      Exception occurred.: SELECT * FROM (SELECT TOP 2 * FROM (SELECT DISTINCT
TOP 3  posts.id FROM posts  LEFT OUTER JOIN authors ON authors.id =
posts.author_id  LEFT OUTER JOIN comments ON comments.post_id = posts.id WHERE
(authors.name = ''David'') ORDER BY UPPER(posts.title),
posts.id) AS tmp1 ORDER BY title DESC, id DESC) AS tmp2 ORDER BY title, id
    ./test/../lib/active_record/connection_adapters/abstract_adapter.rb:135:in
`log''
    ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:321:in
`execute_without_counting''
    ./test/abstract_unit.rb:71:in `execute''
    ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:517:in
`select''
   
./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:7:in
`select_all''
    ./test/../lib/active_record/associations.rb:1282:in
`select_limited_ids_list''
    ./test/../lib/active_record/associations.rb:1274:in
`add_limited_ids_condition!''
    ./test/../lib/active_record/associations.rb:1262:in
`construct_finder_sql_with_included_associations''
    ./test/../lib/active_record/associations.rb:1250:in
`select_all_rows''
    ./test/../lib/active_record/associations.rb:1105:in
`find_with_associations''
    ./test/../lib/active_record/associations.rb:1103:in `catch''
    ./test/../lib/active_record/associations.rb:1103:in
`find_with_associations''
    ./test/../lib/active_record/base.rb:1074:in `find_every''
    ./test/../lib/active_record/base.rb:431:in `find''
    ./test/associations/eager_test.rb:300:in
`test_limited_eager_with_multiple_order_columns''
   
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_case_adapter.rb:19:in
`__send__''
   
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_case_adapter.rb:19:in
`run''

  2) Error:
test_limited_eager_with_order(EagerAssociationTest):
ActiveRecord::StatementInvalid: DBI::DatabaseError: Execute
    OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server
      ORDER BY items must appear in the select list if SELECT DISTINCT is
specified.
    HRESULT error code:0x80020009
      Exception occurred.: SELECT * FROM (SELECT TOP 2 * FROM (SELECT DISTINCT
TOP 3  posts.id FROM posts  LEFT OUTER JOIN authors ON authors.id =
posts.author_id  LEFT OUTER JOIN comments ON comments.post_id = posts.id WHERE
(authors.name = ''David'') ORDER BY UPPER(posts.title)) AS tmp1
ORDER BY title DESC) AS tmp2 ORDER BY title
    ./test/../lib/active_record/connection_adapters/abstract_adapter.rb:135:in
`log''
    ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:321:in
`execute_without_counting''
    ./test/abstract_unit.rb:71:in `execute''
    ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:517:in
`select''
   
./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:7:in
`select_all''
    ./test/../lib/active_record/associations.rb:1282:in
`select_limited_ids_list''
    ./test/../lib/active_record/associations.rb:1274:in
`add_limited_ids_condition!''
    ./test/../lib/active_record/associations.rb:1262:in
`construct_finder_sql_with_included_associations''
    ./test/../lib/active_record/associations.rb:1250:in
`select_all_rows''
    ./test/../lib/active_record/associations.rb:1105:in
`find_with_associations''
    ./test/../lib/active_record/associations.rb:1103:in `catch''
    ./test/../lib/active_record/associations.rb:1103:in
`find_with_associations''
    ./test/../lib/active_record/base.rb:1074:in `find_every''
    ./test/../lib/active_record/base.rb:431:in `find''
    ./test/associations/eager_test.rb:295:in
`test_limited_eager_with_order''
   
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_case_adapter.rb:19:in
`__send__''
   
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_case_adapter.rb:19:in
`run''

  3) Error:
test_find_by_ids_with_limit_and_offset(FinderTest):
ActiveRecord::RecordNotFound: Couldn''t find all Entrants with IDs
(1,3,2) (found 1 results, but was looking for -1)
    ./test/../lib/active_record/base.rb:1134:in `find_some''
    ./test/../lib/active_record/base.rb:1095:in `find_from_ids''
    ./test/../lib/active_record/base.rb:432:in `find''
    ./test/finder_test.rb:45:in
`test_find_by_ids_with_limit_and_offset''
   
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_case_adapter.rb:19:in
`__send__''
   
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_case_adapter.rb:19:in
`run''

  4) Error:
test_attributes(FixturesTest):
ActiveRecord::StatementInvalid: DBI::DatabaseError: Not enough SQL parameters:
INSERT INTO binaries ([id], [data]) VALUES (1, ''ÿØÿà%02 JFIF%02  
%02H%02H%02%02ÿÛ%02C%02          		 %01  %00          %03   %03  
$.'''' ",#  (7),01444
''''9=82<.342ÿÛ%02C 			    %00%00 2!
!22222222222222222222222222222222222222222222222222ÿÀ%02   ^    "%02     
ÿÄ%02 %02%02      %02%02%02%02%02%02%02%02%02%02        ÿÄ%02E %02             
%02   %02    !1A  Qa"q  2''¡±Á #BÑ$Rbá3rðñ 
C%4Scs,''¢D²ÒÿÄ%02%03 %02     %02%02%02%02%02%02%02%02%02%02%02     
ÿÄ%02+ %02           %02%02%02%02%02    ! 1 A Q"2 a¡ #B q''±ÿÚ%02  
%02    %02?%02÷ú(¢EURO%01(¢EURO%01(¢EURO%01(¢EURO%01(ª·ú...|(tm)h÷W· Á%01õw8ú
Sí@ ª9§Þ -gT  ff8%02%01A§ø²ÓZåôýÁ`--Ës Áè 8ô9ïéR |ýÄ¿(tm)Øó Ã¡mïþ$hÖÒ  g¹
ÿ%02Q 	øOÐTpøÍõ -lÑ¨Çôãç...}1/4ðöq ´ö0|rZDø Ï""iú]Òý''6
Çþ$ aØ{%01"í{ S Í(c)ßMÏÚe%02õ ýª3/4 fe>lÜ÷$ñøÔ<<· 1ø(r)F  IùÔ
"1/4É(·"È`fÚ|1/2Ã#v8ÍA§\ [U¶k--7  eÛ''ÎrqÏ1/2]i 
"Æ>¢³ ±:(c)(tm)|gÃ;y  \ñë[ zF 3/4 -¿táZ Ù
NvîÎ8=hÔ|yy£4&âÍn"rAa"9ô¬Å¥¬ú
<<6"+eCï·vïãçV<BðÜiAw þz%021È9ÁÏãC"¢%01)³Ñ-<Iep HZ aÑÇ
|Èë"F §¡  × m EURO 3±msqhåí|t=ÂOEó ë''''Ø(r) FþÎÙx¢2
_¡>>Èªvÿ%02µ?Xæ dÕÑU"ä%03ªiô#TwE V~ QE%02 QE%02 QE%02 QE%02 QE%02
QE%02 QE%02 QHµMa h-IôiGè?1/2 ct	 µ b+ Q%02''oòç...ùÖaà_ O/ñ(üè--¢1à
ØôïÒ¢*Y[ 2{ãûÔÐÊð[  ''7 ZG "ò¤ç>>%03v¥§Éà-Mä´y LÔ~ 1É ÁÈ
ïÔàú|<<GámSísËnÜ2.[''''ç\Ó$Ö4ù r$v_ û¬:cÓýéoQ[Ãêv°
&u''Áø ÆOÈÒ^ìv-%03=ZI[V[iGøy`Äyä  IÇáG"n  (tm)ÍE}<×Vð
%02\E(tf  : {d!  ÊciÁ;E,ÁtHPã ã éKuHõ	#Å¬- õ ´ ù cëÚ(tm) @r$+ï,k|;ö2È¥
Èã9úÖhÛ x~ÇR²7WÚ>>*ªÀL''''*ß  >>íL 1/4   
Ç$C.ìÂO~cýén§(c) .×ùr| ÙÂ·J{áé#--DXÐ">>;''Û%j
<<Ð²z*x§F"T·{T%00w @  ¯|~|þ5Ô ÖàòÅí>>^A å 1/2û
§5ê>>ºÿ%02Þ² -¿&ûK± ¥wl , @ÇÈæ·,U[7 "--u5%00üD
ýØv`¨õltÏaM·nþ- òÔ Äè	  ³  ç(c)(c)ÑOE2(c)÷ ''''ý%03H 
''XõTÖW :Tí=¡ó"s(tm)-ÇF÷ õ(r)7 EURO
2A>Â¡XQ<Ç-EURO...éBtcFãNÔíµ;q5>>,;àúUÊËiÈ--"U$ 
ÏCki(r)ZMv,ÚeûG è}³ëí])ý''%03QE   QE%02 QE%02 QE%02 QE%02 QE%02 QHõ1/2
H {XOE(c)Æ$uä aXÝ #Õµmîm-ß ýn;û|(c) %01 mãÛ8(r)ð¡T 0GqT(r)/-à  
ßåS''*%00ÙDL ¨cø%02èxÏ(r))_ñ,- }àEL´%00·x''2{ YfÑwËË
²<úOEÖnÊA§ø¶öÁ\<W<<ö~(tm) 
pûÃæ+B"G"''¤*öæ°Þ'''',ëIÔmuT} J ?aÄ{ô£±£Ý ¯
iåÇ ø3/4*ú¸\ä'' åâ¡ú U foEu ±OEóÆjbXä = ` ä
ÊqÈç,?:L÷W%03DÉçâkW<Kýý ßú3/4 tçssÐqÜUi]Àhî!ß   n ><<×õ(c)ä
ÿ%02L%01ñÚÛê÷%01n"W¶"~OÌ<<{ Õ¯%012Øøe" Î`XË1É8sYø5 ápÉh
?Ä''''·''O  nSù v(c)4§óoõ&"v
à*n@ø'''' ·jÜY"×°<<LÕE¯[I9 -H×? ²  ý})N£emü~
XZçÏ]-Ë¿Lf¬D0r&oÿ%02/ïJ5<<W>>1/4Ò-OEKrPàã# Ç *<<*ödU=
Õ1ÙLü''''Ôv¯ ~ G¡¯,# ÀW ã Õ"OEg ¸ô¥ ù´tÜÃØTy%035ó
cÜ7  |yæ|''''"Ç¸¨Â¹(tm)Ø¯   <Ö ,^ÝÍ7òíd}ß|áíÏ  q,x*!\r
*}(tm)Á*1/2:Ñå<< é¡÷|nÅ£C¤j|p ¸uó ¡ ûßïN+%00   %011ÎA-."(c)}(r)/*b¢u
¿xzÕa;Ó ¯cJ(¢¨(QE %02QE %02QE %02QECws  ¬· OE$jXã¿µ%02,×µØ4xQX"4 1/4(\
£>>%03È6>>iñæ"OE <üë%00¯ÛjºÖ³y(c)]\ \ü  Â/ô¨ö ñ9|^
ð¬%03Å¥Ë_Í*É  WË%02  ß Ô¿w¢OERVÇ7ZÔ÷3Gianï4£%01  Ïì=êK  1/4ù--TÔ$gn|¸:/Ôõü)î
áû-%00eû6÷y1¹äÆìz v|| E!\3/4(c)ð& ý7Wcê§öªw> 3/4¶ ö%03|T vN§öÈ-¡(r)\e
zúPâ~rg KöÛ+ap11%02 #  çÓ j?ãðÝZMeyæl*J:\ H ó§*3i  é5ª¸¶·¹È | üÄ%00úÔ¡
H¤¤''åz

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Core" group.
To post to this group, send email to rubyonrails-core@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-core-unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---
Rails core - May 2007 - Rails AR/SQLServer Unit Test: [6846] failed (getting worse)

Rails AR/SQLServer Unit Test: [6846] failed (getting worse)
