As far as I can tell, all the findings up to this point support that outcome. And yet...
On Fri, Sep 25, 2009 at 4:35 PM, Aman Gupta <[email protected]>wrote: > > Both of these work fine for me: > > > Marshal.load("\x04\b{\x10:\x0Epricedateu:\tTime\r\x04^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x06:\vsymbol0:\x13instrumenttype0:\x0Eopenprice0:\x0Ehighprice0:\rlowprice0:\x0Fcloseprice0:\vvolume0:\x11openinterest0")[:weekendday] > == 1 > => true > > > Marshal.load("\x04\b{\x11:\x0Epricedate0:\fholidayi\x00:\x0Fweekenddayi\x06:\rexchange0:\vsymbol0:\x13instrumenttype0:\x0Eopenprice0:\x0Ehighprice0:\rlowprice0:\x0Fcloseprice0:\vvolume0:\x11openinterest0")[:weekendday] > == 1 > => true > > > On Fri, Sep 25, 2009 at 12:46 PM, David Jenkins <[email protected]> > wrote: > >>Perhaps you can post the results of p(Marshal.dump(r)) for both cases: > >>with the select, and with the stored procedure. > > Here are the outputs (p(Marshal.dump(r)) of the last 4 recs from the > stored > > proc: > > > "\x04\b{\x10:\x0Epricedateu:\tTime\r\x04^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x06:\vsymbol0:\x13instrumenttype0:\x0Eopenprice0:\x0Ehighprice0:\rlowprice0:\x0Fcloseprice0:\vvolume0:\x11openinterest0" > > > "\x04\b{\x10:\x0Epricedateu:\tTime\r$^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x00:\vsymbol\"\tMSFT:\x13instrumenttype\"\x06S:\x0Eopenpricef\x1A23.319999694824201\x00\xFF\xFB:\x0Ehighpricef\x1A23.600000381469702\x00\xFF\xF9:\rlowpricef\x1823.2299995422363\x00\xFF\xF8:\x0Fclosepricef\n23.25:\vvolumei\x04\xD8\x1A\x88\x02:\x11openinteresti\x00" > > > "\x04\b{\x10:\x0Epricedateu:\tTime\rD^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x00:\vsymbol\"\tMSFT:\x13instrumenttype\"\x06S:\x0Eopenpricef\x1A23.290000915527301\x00\xFF\xF4:\x0Ehighpricef\x1A23.649999618530298\x00\x00\a:\rlowpricef\x1823.2700004577637\x00\x00\b:\x0Fclosepricef\x1A23.579999923706101\x00\x00\r:\vvolumei\x04P%Q\x02:\x11openinteresti\x00" > > > "\x04\b{\x10:\x0Epricedateu:\tTime\rd^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x00:\vsymbol\"\tMSFT:\x13instrumenttype\"\x06S:\x0Eopenpricef\n23.25:\x0Ehighpricef\x1A23.719999313354499\x00\x00\x02:\rlowpricef\n23.25:\x0Fclosepricef\x1A23.649999618530298\x00\x00\a:\vvolumei\x040'~\x02:\x11openinteresti\x00" > > > > and here are the last 4 from the select > > > "\x04\b{\x11:\x0Epricedate0:\fholidayi\x00:\x0Fweekenddayi\x06:\rexchange0:\vsymbol0:\x13instrumenttype0:\x0Eopenprice0:\x0Ehighprice0:\rlowprice0:\x0Fcloseprice0:\vvolume0:\x11openinterest0" > > > "\x04\b{\x11:\x0Epricedate0:\fholidayi\x00:\x0Fweekenddayi\x06:\rexchange0:\vsymbol0:\x13instrumenttype0:\x0Eopenprice0:\x0Ehighprice0:\rlowprice0:\x0Fcloseprice0:\vvolume0:\x11openinterest0" > > > "\x04\b{\x11:\x0Epricedateu:\tTime\r$^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x00:\rexchange\"\tNASD:\vsymbol\"\tMSFT:\x13instrumenttype\"\x06S:\x0Eopenpricef\x1A23.319999694824201\x00\xFF\xFB:\x0Ehighpricef\x1A23.600000381469702\x00\xFF\xF9:\rlowpricef\x1823.2299995422363\x00\xFF\xF8:\x0Fclosepricef\n23.25:\vvolumei\x04\xD8\x1A\x88\x02:\x11openinteresti\x00" > > > "\x04\b{\x11:\x0Epricedateu:\tTime\rD^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x00:\rexchange\"\tNASD:\vsymbol\"\tMSFT:\x13instrumenttype\"\x06S:\x0Eopenpricef\x1A23.290000915527301\x00\xFF\xF4:\x0Ehighpricef\x1A23.649999618530298\x00\x00\a:\rlowpricef\x1823.2700004577637\x00\x00\b:\x0Fclosepricef\x1A23.579999923706101\x00\x00\r:\vvolumei\x04P%Q\x02:\x11openinteresti\x00" > > > > here's the stored proc: > > CREATE definer=`ro...@`localhost` PROCEDURE `GetInstRecs`(SYM > varchar(28), > > INSTTYPE varchar(2)) > > BEGIN > > declare FROMDATE date; > > declare TODATE date; > > call GetMinMaxDates(SYM,INSTTYPE, FROMDATE,TODATE ); > > SELECT m.pricedate , m.holiday, m.weekendday, p.symbol, > p.instrumenttype, > > p.openprice, > > p.highprice, p.lowprice, p.closeprice, p.volume, p.openinterest > > FROM masterdates m left join pricedata p > > on m.pricedate = p.pricedate and p.symbol = SYM and p.instrumenttype = > > INSTTYPE > > where m.pricedate >= FROMDATE and m.pricedate <= TODATE; > > END > > and here's how I call it: > > > > dataset = DB['call GetInstRecs(\'MSFT\', \'S\')'] > > > > > > and here's the sequel select version > > > > dataset = DB[:masterdates].left_outer_join(:pricedata, :pricedate => > > :pricedate, :symbol => 'MSFT', :instrumenttype => > > 'S').filter('(masterdates.pricedate > ?) and (masterdates.pricedate < > ?)', > > '2000-01-01', '2009-08-19') > > > > On Fri, Sep 25, 2009 at 3:27 PM, Aman Gupta <[email protected]> > > wrote: > >> > >> Perhaps you can post the results of p(Marshal.dump(r)) for both cases: > >> with the select, and with the stored procedure. > >> > >> Aman > >> > >> On Fri, Sep 25, 2009 at 12:19 PM, David Jenkins <[email protected]> > >> wrote: > >> > Hi, John > >> > > >> > Thanks for the suggestions. Using :holiday does the same thing, i.e., > I > >> > can't use it in an "if" test. I also tried setting a variable, > >> > "some_var" > >> > to r[:weekendday], and sure enough it gets set to 0 or 1, and its > class > >> > is > >> > Fixnum. > >> > > >> > Again, since this works with a select statement and not when I use a > >> > stored > >> > proc that returns a dataset, it seems to be a problem with the latter. > >> > I'm > >> > am trying to debug the sequel code in NetBeans 6.7, but I'm getting > >> > weird > >> > results: it keeps stopping on comment lines, as if the file it's > showing > >> > is > >> > not the file it's running (and the file its actually running has > actual > >> > non-comment code on those lines) -- the file in question being > mysql.rb. > >> > > >> > > >> > > >> > On Fri, Sep 25, 2009 at 3:10 PM, John W Higgins <[email protected]> > >> > wrote: > >> >> > >> >> > >> >> On Fri, Sep 25, 2009 at 11:49 AM, David Jenkins < > [email protected]> > >> >> wrote: > >> >>> > >> >>> tried p r[:weekendday].class, all Fixnum > >> >>> :( > >> >> > >> >> Try using :holiday instead - looks like the same semantics in terms > of > >> >> data type but it might help figure out if it's a field issue or > >> >> something > >> >> else. > >> >> > >> >> Also try setting another variable with the value and then testing > that > >> >> to > >> >> see if there is something else funky going on with the local > >> >> representation. > >> >> I would say at this point you're down to documenting every stage and > >> >> seeing > >> >> where this goes off track. > >> >> > >> >> Most times these types of things are nothing more then some weird > >> >> anomaly > >> >> but if you poke and prod around the issue sometimes you get the right > >> >> clue. > >> >> > >> >> Sorry I don't have a silver bullet - but sometimes the bullet > companies > >> >> are on strike :) > >> >> > >> >> John > >> >> > >> >> > >> > > >> > > >> > > > >> > > >> > >> > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" 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/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
