Clay Trychta <c...@trychta.com> wrote: > SELECT * FROM( > SELECT * FROM( > SELECT k FROM test_table > ) > UNION ALL > SELECT * FROM( > SELECT k, v FROM test_table > ) > ) > > I would think that unioning two selects which have a different number > of columns would return an error. If I remove the outermost SELECT * > then I receive the error I'm expecting: SELECTs to the left and right > of UNION ALL do not have the same number of result columns.
Looks like a bug to me, for what it's worth. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
