You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
HeidiSQL version:12.6.0.6765
Database type and version:MariaDB 11.3 x64
OS:Windows 11
Describe the bug
Missing ‘INTERSECT’ keyword
To Reproduce
Write down the following SQL statements
-- 查询计算机科学系的学生与年龄不大于19岁的学生的交集
SELECT * FROM student WHERE sdept='CS' INTERSECT
SELECT * FROM student WHERE sage<=19;
'INTERSECT' No highlighting
Screenshots or Crash reports
The text was updated successfully, but these errors were encountered:
Preconditions
HeidiSQL version:12.6.0.6765
Database type and version:MariaDB 11.3 x64
OS:Windows 11
Describe the bug
Missing ‘INTERSECT’ keyword
To Reproduce
-- 查询计算机科学系的学生与年龄不大于19岁的学生的交集
SELECT * FROM student WHERE sdept='CS' INTERSECT
SELECT * FROM student WHERE sage<=19;
Screenshots or Crash reports
The text was updated successfully, but these errors were encountered: