#81 filter transitive's sub query SQL, do not work

v6.1.4
open
None
5
2012-04-23
2012-04-23
iwan
No

Hi,

I have tried transitive SQL fiature from http://docs.openlinksw.com/virtuoso/transitivityinsQL.html , but unfortunately my filter transitive's sub query SQL, do not work. But if I save the the result from transitive query to another table, the after that I query them, it do work.

This is the SQL for how to repeat the problem:

select *
from (
select *
from (
select
transitive t_in (1)
t_out (2)
t_min (0)
t_distinct
p1,
p2,
t_step (1) as via,
t_step ('path_id') as path ,
t_step ('step_no') as step
from knows
)
k where p1 = 1

) l
where l.step = 1

Note: I don't know if this bug has been fixed in the 6.1.5 version.

Discussion

  • iODBC Maintainer

    Mitko: please comment on this

     
  • iODBC Maintainer

    • assigned_to: nobody --> imitko
     
  • iwan

    iwan - 2012-04-25

    > Note: I don't know if this bug has been fixed in the 6.1.5 version.

    I have verified that the "error" still happened in the 6.1.5 version.

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks