{"issue":{"milestone":null,"title":"[FNL-13] fennel dumps during join in luciddb tests","created_at":"2011-12-30T03:29:42Z","user":{"login":"dynamobi-build","id":1123017,"url":"https://api.github.com/users/dynamobi-build","avatar_url":"https://secure.gravatar.com/avatar/cb215b3d786be20761071a562a56af64?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"cb215b3d786be20761071a562a56af64"},"labels":[{"name":"FNL","url":"https://api.github.com/repos/dynamobi/dynamobi/labels/FNL","color":"6124ad"}],"updated_at":"2011-12-30T03:29:43Z","state":"closed","id":2685968,"closed_at":"2011-12-30T03:29:43Z","html_url":"https://github.com/dynamobi/dynamobi/issues/495","pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"body":"<b><i>[reporter=\"boris\", created=\"Tue, 31 Jan 2006 16:33:26 -0500 (GMT-05:00)\"]</i></b>\nStack trace is:<br/>\n<br/>\n<br/>\n\"Main Thread\" id=1 idx=0x2 tid=19485 lastJavaFrame=0xbfffca78<br/>\n<br/>\nStack 0: start=0xbfe00000, end=0xc0000000, guards=0xbfe05000 (ok), forbidden=0xbfe03000<br/>\nThread Stack Trace:<br/>\n    at _ZN6fennel9SqlStrCmpILi1ELi1EEEiPKciS2_ii+150(SqlString.h:209)@0xa2ce9fb6    at _ZN6fennel7strCmpAEPNS_11RegisterRefIiEEPNS0_IPcEES5_+226(ExtString.cpp:79)@0xa2ce56dc<br/>\n    at _ZNK6fennel20ExtendedInstruction3IiPcS1_E4execERl+73(ExtendedInstruction.h:649)@0xa2cedde1<br/>\n    at _ZN6fennel10Calculator4execEv+1746(Calculator.cpp:298)@0xa2bff52a<br/>\n    at _ZN6fennel14CalcExecStream7executeERKNS_17ExecStreamQuantumE+246(CalcExecStream.cpp:137)@0xb739a68a<br/>\n    at _ZN6fennel19ExecStreamScheduler13executeStreamERNS_10ExecStreamERKNS_17ExecStreamQuantumE+140(ExecStreamScheduler.h:230)@0xb697801c<br/>\n    at _ZN6fennel26DfsTreeExecStreamScheduler10readStreamERNS_10ExecStreamE+1187(DfsTreeExecStreamScheduler.cpp:137)@0xb69761a3<br/>\n    at Java_net_sf_farrago_fennel_FennelStorage_tupleStreamFetch+166(NativeMethods.cpp:112)@0xb6c3c8b6<br/>\n    -- Java stack --<br/>\n    at net/sf/farrago/fennel/FennelStorage.tupleStreamFetch(J[B)I(Native Method)    at net/sf/farrago/fennel/FennelStreamGraph.fetch(Lnet/sf/farrago/fennel/FennelStreamHandle;[B)I(FennelStreamGraph.java:163)<br/>\n    at net/sf/farrago/runtime/FennelIterator.populateBuffer()I(FennelIterator.java:96)<br/>\n    at net/sf/farrago/runtime/FennelAbstractIterator.hasNext()Z(FennelAbstractIterator.java:100)<br/>\n    at org/eigenbase/runtime/IteratorResultSet.next()Z(IteratorResultSet.java:196)<br/>\n    at net/sf/farrago/runtime/FarragoIteratorResultSet.next()Z(FarragoIteratorResultSet.java:98)<br/>\n    at sqlline/SqlLine$BufferedRows.<init>(Lsqlline/SqlLine;Ljava/sql/ResultSet;)V(Unknown Source)<br/>\n    at sqlline/SqlLine.print(Ljava/sql/ResultSet;)I(Unknown Source)<br/>\n    at sqlline/SqlLine$Commands.execute(Ljava/lang/String;Z)Z(Unknown Source)<br/>\n    at sqlline/SqlLine$Commands.sql(Ljava/lang/String;)Z(Unknown Source)<br/>\n    at sqlline/SqlLine.dispatch(Ljava/lang/String;)Z(Unknown Source)<br/>\n    at sqlline/SqlLine.begin([Ljava/lang/String;Ljava/io/InputStream;)V(Unknown Source)<br/>\n    at sqlline/SqlLine.mainWithInputRedirection([Ljava/lang/String;Ljava/io/InputStream;)V(Unknown Source)<br/>\n    at sqlline/SqlLine.main([Ljava/lang/String;)V(Unknown Source)<br/>\n    at jrockit/vm/RNI.c2java(IIII)V(Native Method)<br/>\n    -- end of trace<br/>\n<br/>\n<br/>\n<br/>\nIn order to reproduce, run sqllineEngine from open/luciddb and execute the following (keep in mind that you need to do an \"ant restoreCatalog\" after this crash):<br/>\n<br/>\n<br/>\n=======================================<br/>\n<br/>\n-- SETUP:<br/>\ncreate schema s;<br/>\nset schema 's';<br/>\n<br/>\ncreate table CUSTOMERS(<br/>\nCUSTID integer primary key,<br/>\nFNAME varchar(30),<br/>\nLNAME varchar(30) not null,<br/>\nSEX char(1))<br/>\nserver sys_ftrs_data_server;<br/>\ncreate index CUSTOMERS_NAME on CUSTOMERS(LNAME, FNAME);<br/>\ncreate foreign data wrapper test_jdbc library '../farrago/plugin/FarragoMedJdbc.jar' language java;<br/>\n<br/>\ncreate server csv_server<br/>\nforeign data wrapper test_jdbc<br/>\noptions(<br/>\n    driver_class 'org.relique.jdbc.csv.CsvDriver',<br/>\n    url 'jdbc:relique:csv:test/sql/shortreg',<br/>\n    schema_name 'TESTDATA');<br/>\n<br/>\ncreate schema csv_schema;<br/>\n<br/>\ncreate foreign table csv_schema.SHORTREG_CUSTOMERS_SRC (<br/>\nCUSTID INTEGER,<br/>\nFNAME VARCHAR(30),<br/>\nLNAME VARCHAR(30),<br/>\nSEX VARCHAR(1)<br/>\n)<br/>\nserver csv_server<br/>\noptions (table_name 'customers');<br/>\n<br/>\nINSERT INTO s.CUSTOMERS<br/>\nSELECT CUSTID,FNAME,LNAME,SEX FROM csv_schema.SHORTREG_CUSTOMERS_SRC;<br/>\n<br/>\n-- QUERY THAT DIES<br/>\n-- many to many self join<br/>\nselect M.FNAME ,F.FNAME, M.LNAME<br/>\nFROM CUSTOMERS M, CUSTOMERS F<br/>\nWHERE M.LNAME = F.LNAME<br/>\nAND M.SEX = 'M'<br/>\nAND F.SEX = 'F'<br/>\norder by FNAME, FNAME, LNAME;<br/>\n<br/>\n<br/>\n","number":495,"url":"https://api.github.com/repos/dynamobi/dynamobi/issues/495","comments":0,"assignee":null},"action":"closed"}