Member

What problem does this PR solve?

features:

• Explicit defaults
  • Insert into t1 values(0, Default);
• Using on Join
  • select * from t1 left join t2 using (id);
• the inner table in a left or right outer join can also be used in an inner join
  • select * from t1 inner join t1 as t2 on t1.a = t2.a

fix:

• fixed when subquery on select, the table of column is temp.

select ( select a from t1 ) from t1;

+--------------------+
| t1.a               |
+====================+
| 1                  |
+--------------------+

• fixed when selecting * from multiple tables to join, the output fields are random by table.
  • select * from t1 inner join t2 on t1.id = t2.id

Issue link: #130

Code changes

• Has Rust code change
• Has CI related scripts change

Check List

Tests

• Unit test
• Integration test
• Manual test (add detailed scripts or steps below)
• No code

Side effects

• Performance regression: Consumes more CPU
• Performance regression: Consumes more Memory
• Breaking backward compatibility

Note for reviewer

feat: support Explicit defaults

c80f006

…outer join can also be used in an inner join

TODO: SQL 2016 #130