We wrote a query and intended to use a "natural" join but had a typo and wrote "natrual" join instead. We were surprised this query was processed without error and performed a cross join.
Example: SQLite version 3.7.6.3 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table a(id int, t text); sqlite> insert into a values (1,'a1'); sqlite> insert into a values (2,'a2'); sqlite> create table b(id int, btext text); sqlite> insert into b values (1,'b1'); sqlite> insert into b values (3,'b3'); sqlite> select * from a natural join b; id t btext ---------- ---------- ---------- 1 a1 b1 sqlite> select * from a natrual join b; id t id btext ---------- ---------- ---------- ---------- 1 a1 1 b1 1 a1 3 b3 2 a2 1 b1 2 a2 3 b3 sqlite> Thanks, Sam _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
