BaoForPostgreSQL icon indicating copy to clipboard operation
BaoForPostgreSQL copied to clipboard

unrecognized node type: 223 with Bao server

Open lucifer12346 opened this issue 1 year ago • 0 comments

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.

lucifer12346 avatar Nov 20 '23 08:11 lucifer12346