search

hellios78 / flexviews

Automatically exported from code.google.com/p/flexviews
0 stars 0 forks source link

is it normal ? count column in incremental view #20

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
I have a strange behavior in a INCREMENTAL material view on a query which join 
2 tables and group by column and count(*)

for example

Articles liked by people
I have a ARTICLE table join to PEOPLE_LIKE_ARTICLE table

My goal is to have a mat view with article id and number of likes so i have 
created it (and add tables in changelog tables of course)

each time a people like an article (for example article_id=5), the count is not 
updated for the line where article_id = 5 but instead of it, i have a new line 
with a count column equal to '1' (if people like it) or equal -1 (if people 
unlike it)

I dont understand the logic behind it or if it a bug

Original issue reported on code.google.com by michel.d...@gmail.com on 2 Sep 2012 at 9:47

GoogleCodeExporter commented 9 years ago 
This is not normal.  Make sure you are using the latest SVN release of 
Flexviews. 

If you can reproduce this on the latest SVN let me know.

Original comment by greenlion@gmail.com on 15 Feb 2013 at 4:04