search

pingcap / parser

A MySQL Compatible SQL Parser
Apache License 2.0
1.41k stars 489 forks source link

not not exists not handle properly #1251

Closed longfeiss closed 3 years ago

longfeiss commented 3 years ago

Bug Report

Please answer these questions before submitting your issue. Thanks!

  1. What did you do? If possible, provide a recipe for reproducing the error.

select * from t where not not exists (select a from t);

  1. What did you expect to see?

select * from t where exists (select a from t);

  1. What did you see instead?

select * from t where not exists (select a from t);

  1. What version of TiDB SQL Parser are you using? master