doupache commented on PR #12529:
URL: https://github.com/apache/datafusion/pull/12529#issuecomment-2370264124

   I have test all table in imdb dataset , there is no "negative" id 
   
   ```sql
   SELECT * FROM aka_name 
   WHERE id < 0 LIMIT 5
   
   SELECT * FROM aka_title 
   WHERE  id < 0 LIMIT 5
   
   SELECT * FROM cast_info  
   WHERE   id < 0 LIMIT 5
   
   SELECT * FROM char_name  
   WHERE   id < 0 LIMIT 5
   
   SELECT * FROM comp_cast_type  
   WHERE   id < 0 LIMIT 5
   
   SELECT * FROM company_name  
   WHERE   id < 0 LIMIT 5
   
   SELECT * FROM company_type  
   WHERE   id < 0 LIMIT 5
   
   SELECT * FROM complete_cast  
   WHERE   id < 0 LIMIT 5
   
   SELECT * FROM info_type  
   WHERE   id < 0 LIMIT 5
   
   SELECT * FROM keyword  
   WHERE   id < 0 LIMIT 5
   
   SELECT * FROM kind_type  
   WHERE   id < 0 LIMIT 5
   
   SELECT * FROM link_type  
   WHERE   id < 0 LIMIT 5
   
   SELECT * FROM movie_companies  
   WHERE   id < 0 LIMIT 5
   
   SELECT * FROM movie_info  
   WHERE   id < 0 LIMIT 5
   
   SELECT * FROM movie_info_idx  
   WHERE   id < 0 LIMIT 5
   
   SELECT * FROM movie_keyword  
   WHERE   id < 0 LIMIT 5
   
   SELECT * FROM movie_link  
   WHERE   id < 0 LIMIT 5
   
   SELECT * FROM name  
   WHERE id < 0 LIMIT 5
   
   SELECT * FROM person_info  
   WHERE   id < 0 LIMIT 5
   
   SELECT * FROM role_type  
   WHERE   id < 0 LIMIT 5
   
   SELECT * FROM title  
   WHERE   id < 0 LIMIT 5
   
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to