Skip to content

unrecognized node type: 223 with Bao server #10

@lucifer12346

Description

@lucifer12346

In IMDB database, I can execute this SQL correctly without Bao server.

SELECT DISTINCT a.name AS cast_member, t.title AS complete_dynamic_hero_movie FROM cast_info AS ci JOIN complete_cast AS cc ON ci.movie_id = cc.movie_id JOIN char_name AS chn ON chn.id = ci.person_role_id JOIN name AS a ON a.id = ci.person_id JOIN movie_info_idx AS mi ON mi.movie_id = ci.movie_id JOIN movie_keyword AS mk ON mk.movie_id = ci.movie_id JOIN keyword AS k ON k.id = mk.keyword_id JOIN title AS t ON t.id = ci.movie_id WHERE ci.person_role_id IS NOT NULL AND (chn.name LIKE '%man%' OR chn.name LIKE '%Man%') AND (k.keyword = 'superhero' OR k.keyword = 'marvel-comics' OR k.keyword = 'based-on-comic' OR k.keyword = 'tv-special' OR k.keyword = 'fight' OR k.keyword = 'violence' OR k.keyword = 'magnet' OR k.keyword = 'web' OR k.keyword = 'claw' OR k.keyword = 'laser') AND mi.info_type_id = 99 AND t.production_year > 2000 ;

However, when I am using Bao as a remcommender, it seems that Bao do not work. Then I execute the SQL by adding 'explain' in front of it.
explain SELECT DISTINCT a.name AS cast_member, t.title AS complete_dynamic_hero_movie FROM cast_info AS ci JOIN complete_cast AS cc ON ci.movie_id = cc.movie_id JOIN char_name AS chn ON chn.id = ci.person_role_id JOIN name AS a ON a.id = ci.person_id JOIN movie_info_idx AS mi ON mi.movie_id = ci.movie_id JOIN movie_keyword AS mk ON mk.movie_id = ci.movie_id JOIN keyword AS k ON k.id = mk.keyword_id JOIN title AS t ON t.id = ci.movie_id WHERE ci.person_role_id IS NOT NULL AND (chn.name LIKE '%man%' OR chn.name LIKE '%Man%') AND (k.keyword = 'superhero' OR k.keyword = 'marvel-comics' OR k.keyword = 'based-on-comic' OR k.keyword = 'tv-special' OR k.keyword = 'fight' OR k.keyword = 'violence' OR k.keyword = 'magnet' OR k.keyword = 'web' OR k.keyword = 'claw' OR k.keyword = 'laser') AND mi.info_type_id = 99 AND t.production_year > 2000 ;

And it turns out to be:
ERROR: unrecognized node type: 223

Then another SQL which should have been executed correctly even with Bao cannot execute anymore until I restart Bao server. I wonder if there are any methods to use Bao with SQLs as mentioned above.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions