PayasR / paralite

0 stars 0 forks source link

unexpected outputs with UDX using DB divided into 3 chunks #18

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. cat ss
#!/usr/bin/perl
while (my $l = <STDIN>) {
  chomp($l);
  my @s = split(/\.\s*/, $l);
  for (my $i = 0; $i < scalar(@s); ++$i) {
    print $i+1 ."|$s[$i]\n";
  }
}

< 2 rows >
2-1. paralite test.db "select document_id, text from document"
32819|It is sunny today. I have a good mood.
82718|I am studying in the lab. I want to go outside and play pingpong.

2-2. paralite test.db "select document_id, F(text) from document with F=\"perl 
ss\" output_record_delimiter EMPTY_LINE"
32819|1|It is sunny today
32819|2|I have a good mood
82718|1|I am studying in the lab
82718|2|I want to go

< 2 rows - plus 10 letters >
3-1. paralite test.db "select document_id, text from document2"
32819|It is sunny today00000. I have a good mood00000.
82718|I am studying in the lab. I want to go outside and play pingpong.

3-2. paralite test.db "select document_id, F(text) from document2 with F=\"perl 
ss\" output_record_delimiter EMPTY_LINE"
32819|1|It is sunny today00000
32819|2|I have a good mood00000
82718|1|I am studying in the lab
82718|2|I want to go outside an

< 3 rows - short sentence >
4-1. paralite test.db "select document_id, text from document3"
32819|It is sunny today. I have a good mood.
82718|I am studying in the lab. I want to go outside and play pingpong.
88888|Time is money. Easier said than done.

4-2. paralite test.db "select document_id, F(text) from document3 with F=\"perl 
ss\" output_record_delimiter EMPTY_LINE"
32819|1|It is sunny today
32819|2|I have a good mood
88888|1|Time is money
88888|2|Easier said than done

< 3 rows - long sentence >
5-1. paralite test.db "select document_id, text from document4"
32819|It is sunny today. I have a good mood.
82718|I am studying in the lab. I want to go outside and play pingpong.
92345|A drowning man will catch at a straw. Time and tide wait for no man.

5-2. paralite test.db "select document_id, F(text) from document4 with F=\"perl 
ss\" output_record_delimiter EMPTY_LINE"
 (blank line)

< 4 rows >
6-1. paralite test.db "select document_id, text from document5"
32819|It is sunny today. I have a good mood.
82718|I am studying in the lab. I want to go outside and play pingpong.
88888|Time is money. Easier said than done.
92345|A drowning man will catch at a straw. Time and tide wait for no man.

6-2. paralite test.db "select document_id, F(text) from document5 with F=\"perl 
ss\" output_record_delimiter EMPTY_LINE"
 (blank line)

What is the expected output? What do you see instead?
2-2)
32819|1|It is sunny today
32819|2|I have a good mood
82718|1|I am studying in the lab
82718|2|I want to go outside and play pingpong

3-2)
32819|1|It is sunny today00000
32819|2|I have a good mood00000
82718|1|I am studying in the lab
82718|2|I want to go outside and play pingpong

4-2)
32819|1|It is sunny today
32819|2|I have a good mood
82718|1|I am studying in the lab
82718|2|I want to go outside and play pingpong
88888|1|Time is money
88888|2|Easier said than done

5-2)
32819|1|It is sunny today
32819|2|I have a good mood
82718|1|I am studying in the lab
82718|2|I want to go outside and play pingpong
92345|1|A drowning man will catch at a straw
92345|2|Time and tide wait for no man

6-2)
32819|1|It is sunny today
32819|2|I have a good mood
82718|1|I am studying in the lab
82718|2|I want to go outside and play pingpong
88888|1|Time is money
88888|2|Easier said than done
92345|1|A drowning man will catch at a straw
92345|2|Time and tide wait for no man

Please use labels and text to provide additional information.

Original issue reported on code.google.com by wdb.taki...@gmail.com on 11 Nov 2013 at 6:02