MySQL Bugs: #110864: A not exists subquery example has incorrect table reference

Bug #110864	A not exists subquery example has incorrect table reference
Submitted:	28 Apr 2023 10:08	Modified:	11 May 2023 13:33
Reporter:	Fei Yang	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	8.0, 5.7	OS:	Any
Assigned to:	Jon Stephens	CPU Architecture:	Any

Description:
https://dev.mysql.com/doc/refman/8.0/en/exists-and-not-exists-subqueries.html has a NOT EXISTS subquery example as follows

```
SELECT DISTINCT store_type FROM stores s1
  WHERE NOT EXISTS (
    SELECT * FROM cities WHERE NOT EXISTS (
      SELECT * FROM cities_stores
       WHERE cities_stores.city = cities.city
       AND cities_stores.store_type = stores.store_type));
```

where `stores.store_type` is a wrong table reference in the innermost subquery.

How to repeat:
As in description.

Suggested fix:
```diff
@@ -1,4 +1,4 @@
-SELECT DISTINCT store_type FROM stores s1
+SELECT DISTINCT store_type FROM stores
```

Remove the table alias `stores s1`

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.

Fixed in all version of the Manual, in mysqldoc rev 75610.

Thanks!

Closed.