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

Mon, 21 May 2007 13:01:17 -0700 

"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¶k—7  
eۑÎrqϽ]i  “Æ>¢³ž ±:©™¦gÃ;yŒ  \ñƒë[ zF¾ -ž¿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 €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%02’oòç…ùÖaà_ O/ñ(ü藢1à ØôïÒ¢*Y[ 
2{ãûÔÐÊð[  ‘7 ZG “ò¤ç»%03Œv¥§Éà­Mä´y LÔ~ 1É ÁÈ 
ïÔàú|«GámSísËnÜ2.[''ŒçŠƒ\Ó$Ö4ù r$v_ ‰û¬:cÓýéoƒQ[Ãêv° &u‘Áøƒ 
ÆOÈÒ^ìv­%03=ZI[V[iGøy`Äyä  IÇáG”„n  Ž™ÍE}<×Vð %02\E(tf  : {dŠ!‰  
ÊciÁ;E,žÁtHPã ã éKuHõ      #Ŭ­ õ ´ ù cëڙ @r$+ï‚k¦;ö2È¥ Èã9úÖhÛ 
x~ÇR²7WÚ»*ªÀL''*ß  »íL¼    Ç$C.ìÂO˜cýén§© .×ùr| Ù·J{áé#—D†XÐ"»;‘Û%Žj 
«Ð²z*x§F“T·Š{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÷ ‡õ®7€2A>¡žXQ<Ç-Ž€…éBtcFãNÔíµ;q5»‚;ŽàúUÊËiÈ-­"U$  
ÏCški®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ÙD‹L ¨cøŠ%02èxÏ®)_ñˆ‹‚-› 
}àELš´%00·x’2{ YfÑwËË ²<úœÖnÊA§ø¶öÁ\<W«ö˜™  pûÃæ+B“G"’¤•öæ°Þ''‚ëIÔmu›T} J 
?ažÄ{ô£±£Ý ¯ iåÇ ø¾*ú¸\ä’ å⡆ú ›U fŒoEu ±œóÆjbXä Ž= ` ä 
ÊqÈç‚?:L÷W%03DÉçâkW<Kýý ßú¾tçssÐqÜUi]Àhî!ß   Œn >«×õ©ä 
ÿ%02L%01ñÚÛê÷%01n"W¶”˜Ǒ«{ Õ¯%012Øøe" Î`žXË1É8sYø5 ápÉh ?Ä''·‘O  nSù 
v©4§óoõ&“v [EMAIL PROTECTED]'' ·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,×µØ4xQX“4¼(\ £»%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æl•J:\ H ó§*3i  é5ª¸¶·¹Èž ¦ 
üÄ%00úÔ¡ H¤¤‘åz ò}¢Í"''ËDH×`ààcŠÙÛêP  Kð¾ r§ üé ˆ|;coâý%03Q †ÆõÌ ¬LT Ç 
zg#ð¨§ðüQ[KäÉ4l…”0 ä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… 
 ›†ÓžzŒqÐÕ¡á¿  çì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Ð/‰à¹K˜4É DmÊKŽ ãZM b     ›ÖOØS<ÓB    
    «1Ê  ´›é5%00:)æ ­ç# ÂÇ; ¿ÓÒ¯VrÊìÚÎ      û à [EMAIL PROTECTED]   Մ>ÑE %02QE 
%02QE %02V7ŗ²\Ü%Œ.¢(ÎdÉê݇ҵ7× ÖÊi· *„‚zgµy›Å b÷w…¤c– Ž§¯­K,©Pð[²•Í¼Ù)½ ¶q´ñO| 
m$ wo Ã<Àc9è:þtšhlò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ì* vcn…“c  ¹éž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 [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to