select * +join #19517
Description
What happens?
When:
SELECT data.* not LIKE '%学时' , data.* like '%学时' from data;Then the result is right.
When:
SELECT data.* not LIKE '%学时' , data.* like '%学时' from data, dgjs;in the query results, some fields from table2 (dgjs) were added, but not all fields.
To Reproduce
CREATE TABLE "data"("学期" DOUBLE,"教学班名称" VARCHAR,"课程号" VARCHAR,"课程名称" VARCHAR,"课程性质" VARCHAR,"教师信息" VARCHAR,
"任务总学时" DOUBLE,"课程总学时" DOUBLE,"讲课学时" DOUBLE,"实验学时" DOUBLE,"实践学时" VARCHAR);
CREATE TABLE dgjs("课程名称" VARCHAR, "教学班" VARCHAR, "课程代码" VARCHAR, "学年" VARCHAR, "学期" VARCHAR, "教师名称" VARCHAR, "课程课外指导总学时" VARCHAR, "课程实验总学时" VARCHAR, "课程上机总学时" VARCHAR, "课程实践总学时" VARCHAR, "课程总学时" VARCHAR);When:
SELECT data.* not LIKE '%学时' , data.* like '%学时' from data;SELECT data.* not LIKE '%学时' , data.* like '%学时' from data, dgjs;OS:
x86_64
DuckDB Version:
1.4
DuckDB Client:
python ,dbeaver
Hardware:
No response
Full Name:
x
Affiliation:
xz
Did you include all relevant configuration (e.g., CPU architecture, Linux distribution) to reproduce the issue?
- Yes, I have
Did you include all code required to reproduce the issue?
- Yes, I have
Did you include all relevant data sets for reproducing the issue?
No - I cannot share the data sets because they are confidential