"bitsweat" has kicked AR/SQLServer while it was down...
http://dev.rubyonrails.org/changeset/6845
------------------------------------------------------------------------
r6845 | bitsweat | 2007-05-25 14:56:21 -0700 (Fri, 25 May 2007) | 1 line
Find with a list of ids supports limit/offset. Closes #8437.
------------------------------------------------------------------------
U activerecord\test\finder_test.rb
U activerecord\lib\active_record\base.rb
U activerecord\CHANGELOG
Updated to revision 6845.
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) Failure:
test_find_by_ids_with_limit_and_offset(FinderTest)
[./test/finder_test.rb:44: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']:
<2> expected but was
<[#<Entrant id: 1, name: "Ruby Developer", course_id: 1>,
#<Entrant id: 2, name: "Ruby Guru", course_id: 1>]>.
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 [EMAIL PROTECTED]'' ·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 ò}¢Í"''ËDH×`ààcÙÛêP
Kð3/4 r§ üé |;coâý%03Q ÆõÌ ¬LT Ç zg#ð¨§ðüQ[KäÉ4l..."0 äsûÖIS5SViÖúÙà " þá]¨
|&NzsJ[Á7XÂkn æÿ%02zÿ%02%ê}?G ù%03 F\~Î5ËD 1/2 V' /° <
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
