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

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

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

http://dev.rubyonrails.org/changeset/6801
------------------------------------------------------------------------
r6801 | rick | 2007-05-21 12:50:44 -0700 (Mon, 21 May 2007) | 1 line

forgot binary fixture
------------------------------------------------------------------------

A    activerecord\test\fixtures\binaries.yml
Updated to revision 6801.

  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:1283:in
`select_limited_ids_list'
    ./test/../lib/active_record/associations.rb:1275:in
`add_limited_ids_condition!'
    ./test/../lib/active_record/associations.rb:1263:in
`construct_finder_sql_with_included_associations'
    ./test/../lib/active_record/associations.rb:1251:in `select_all_rows'
    ./test/../lib/active_record/associations.rb:1107:in
`find_with_associations'
    ./test/../lib/active_record/associations.rb:1105:in `catch'
    ./test/../lib/active_record/associations.rb:1105: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'

  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:1283:in
`select_limited_ids_list'
    ./test/../lib/active_record/associations.rb:1275:in
`add_limited_ids_condition!'
    ./test/../lib/active_record/associations.rb:1263:in
`construct_finder_sql_with_included_associations'
    ./test/../lib/active_record/associations.rb:1251:in `select_all_rows'
    ./test/../lib/active_record/associations.rb:1107:in
`find_with_associations'
    ./test/../lib/active_record/associations.rb:1105:in `catch'
    ./test/../lib/active_record/associations.rb:1105: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'

  3) 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÷ú(¢%01(¢%01(¢%01(¢%01(ª·ú¦h÷W· Á%01õw8ú Sí@ ª9§Þ gT 
ff8%02%01A§ø²ÓZåôýÁ`Ës Áè 8ô9ïéR |ýÄ¿Øó Ã¡mïþ$hÖÒ  g¹ ÿ%02Q 	øOÐTpøÍõ
-lÑ¨Çôãç}¼ðöq ´ö0¦rZDø Ï"iú]Òý6 Çþ$ aØ{%01í{ S Í©ßMÏÚe%02õ
ýª¾fe>lÜ÷$ñøÔ«· 1ø®F  IùÔ "¼É(·È`fÚ|½Ã#v8ÍA§\ [U¶k7  eÛÎrqÏ½]i 
Æ>¢³ ±:©¦gÃ;y  \ñë[ zF¾ -¿táZ Ù NvîÎ8=hÔ|yy£4&âÍn"rAa9ô¬Å¥¬ú
«6+eCï·vïãçV<BðÜiAw þz%021È9ÁÏãC¢%01)³Ñ<Iep HZ aÑÇ ¦Èë"F §¡ 
× m 3±msqhåí¦t=Âó ë''Ø® 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è?½ct	 µ b+
Q%02oòçùÖ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ÇáGn  ÍE}<×Vð %02\E(tf  : {d! 
ÊciÁ;E,ÁtHPã ã éKuHõ	#Å¬ õ ´ ù cëÚ @r$+ïk¦;ö2È¥ Èã9úÖhÛ
x~ÇR²7WÚ»*ªÀL''*ß  »íL¼    Ç$C.ìÂOcýén§© .×ùr|
ÙÂ·J{áé#DXÐ"»;Û%j «Ð²z*x§FT·{T%00w @  ¯¦~|þ5Ô ÖàòÅí»^A å ½û
§5ê»ºÿ%02Þ² -¿&ûK± ¥wl  @ÇÈæ·,U[7 "u5%00üD ýØv`¨õltÏaM·nþ òÔ
Äè	  ³  ç©©Ñ2©÷ ''ý%03H  XõTÖW :Tí=¡ó"s-ÇF÷
õ®72A>Â¡XQ<Ç-éBtcFãNÔíµ;q5»;àúUÊËiÈ-"U$ 
ÏCki®ZMv,ÚeûG è}³ëí])ý%03QE   QE%02 QE%02 QE%02 QE%02 QE%02 QHõ½H {X©Æ$uä aXÝ
#Õµmîmß ýn;û|© %01 mãÛ8®ð¡T 0GqT®/à   ßåS*%00ÙDL ¨cø%02èxÏ®)_ñ-
}àEL´%00·x2{ YfÑwËË ²<úÖnÊA§ø¶öÁ\<W«ö 
pûÃæ+BG"¤öæ°Þ''ëIÔmuT} J ?aÄ{ô£±£Ý ¯ iåÇ ø¾*ú¸\ä åâ¡ú U
foEu ±óÆjbXä = ` ä ÊqÈç?:L÷W%03DÉçâkW<Kýý ßú¾tçssÐqÜUi]Àhî!ß   n
>«×õ©ä ÿ%02L%01ñÚÛê÷%01n"W¶OÌ«{ Õ¯%012Øøe" Î`XË1É8sYø5
ápÉh ?Ä''·O  nSù v©4§óoõ&v àn@ø'' ·jÜY×°«LÕE¯[I9 H×? ²
ý})N£emü~ XZçÏ]Ë¿Lf¬D0r&oÿ%02/ïJ5«W»¼Ò-KrPàã# Ç *«ödU=
Õ1ÙLü''Ôv¯  G¡¯# ÀW ã Õ"g ¸ô¥ ù´tÜÃØTy%035ó cÜ7 
¦yæ¦''Ç¸¨Â¹Ø¯   <Ö ,^ÝÍ7òíd}ß¦áíÏ  q,x*!\r *}Á*½:Ñå«
é¡÷¦nÅ£C¤j¦p ¸uó ¡ ûßïN+%00   %011ÎA.©}®/*b¢u ¿xzÕa;Ó ¯cJ(¢¨(QE %02QE %02QE
%02QECws  ¬· $jXã¿µ%02,×µØ4xQX4¼(\ £»%03È6»iñæ <üë%00¯ÛjºÖ³y©]\ \ü 
Â/ô¨ö ñ9¦^ ð¬%03Å¥Ë_Í*É  WË%02  ß Ô¿w¢RVÇ7ZÔ÷3Gianï4£%01  Ïì=êK 
¼ùTÔ$gn|¸:/Ôõü)î áû-%00eû6÷y1¹äÆìz v¦¦ E!\¾©ð& ý7Wcê§öªw> ¾¶ ö%03¦T
vN§öÈ¡®\e zúPârg KöÛ+ap11%02 #  çÓ j?ãðÝZMeyælJ:\ H ó§*3i  é5ª¸¶·¹È ¦
üÄ%00úÔ¡ H¤¤åz ò}¢Í"''ËDH×`ààcÙÛêP  Kð¾ r§ üé |;coâý%03Q ÆõÌ
¬LT Ç zg#ð¨§ðüQ[KäÉ4l0 äsûÖIS5SViÖúÙÃ " þá]¨ ¦&NzsJ[Á7XÂkn
æÿ%02zÿ%02%ê}?G ù%03 F\~Î5ËD½V  /° <ôÉî§îCÚ¾x^Ý4$Ã	dÝpA 
%03¦ÚUå· e÷,dÅ%02²  w×HïPk .ÖuO-<âÒtÎG ê %01 %03É~ÃÑ°Iáà	
>IõÅ·¿Ò$·mÒ¥Ølzp ?:®</®2å/¬ÛÐäÿ%02þi]æ¨C©Ágs*4û#D¹ ã æ©$Ò±¡M
>)¦2 \±'' «¯60Ä P BÂ²0ø _(¥2Z  ÓzqÐÕ¡á¿  çìDzîÿ%02jn bèÒ5Ä(¡Ô
8$ÕY5{XÛ%01ZN: '' hW°_ ¯.Õfí¶ÿ%02 ëÜã=ªÝ§m®Õ§öóib jü {U Ý
i+&_TÁ ªtv  U¼KçIäÂQ¤ÇÜKÒÁá-  ±y§ÖY ÿ%02zâ{ KmA µ´P  È
%02Ï''ûS<t¬U$Ø¯õ+)o§]ÈÀóµ@ \TÐ/à¹K4É DmÊK ãZM b	ÖOØS<ÓB	«1Ê 
´é5%00:)æ ç# ÂÇ; ¿ÓÒ¯VrÊìÚÎ	û Ã Þ´@   Õ>ÑE %02QE %02QE
%02V7Å²\Ü%.¢(ÎdÉêÝÒµ7× ÖÊi· *zgµyÅ b÷w¤c §¯K,©Pð[²Í¼Ù)½ ¶q´ñO| m$ wo
Ã<Àc9è:þthlòOÚÜvç Ûuá;u^bäJX¯Â8ÀçL] > %|¯µòº +Ï µô×9É :%02É§þè£Ñ
½j³õ -©ÿ%02¿SZUl > ~ ^Êdôeÿ%02ñ  << ùÿ%02 :Ìø\  FöÁëìk½5Fµ¥,þb 
wäy=GãZ) % ãCFà«)èAàó=+Tÿ%02Ëú Î :4« å`ëÈÏ  ®x4dÖÆãKÑéá PAâ¾  Æyì* vcnc 
¹éqJg¸ÔSZ  ÌöÈ2Ä0P 2 rÇ=½ªªèHÆì]¬Ïb.®-§¹Äó¿Á  <cå

--~--~---------~--~----~------------~-------~--~----~
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: [6801] failed (getting worse)

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