Thank you Peter! I like sqlite so much and I think we all benefit if errors are fixed. I see I was not very clear with my first post. Will do better next time. Yes would be nice if people would try to understand first not just think on title text.
Talking about sqlite I use it for web development, desktop apps. I also created tool or gui sqlite manager and will try to sell it in near future. I needed very good tool because I work with sqlite every day. It is just for windows platform. I support different datetime formats, blobs, compress etc. See this page: http://www.arsistemi.si/izdelki/sqlite-4-all.html Every report is created with sqlite tables. I read data from different RDBMS to sqlite and then work with data as needed. petern je 22.12.2017 ob 23:19 napisal:
Radovan. Thank you for sticking to your guns. Your appeal to expected behavior under other DB engines was also a very good post. I see the usual suspects of the echo chamber uselessly piled on against you to clog the forum nevertheless. That happens too frequently. BTW, here is a simpler test suite which pinpoints the problem: SELECT d FROM (SELECT c AS d FROM (SELECT 1 AS c)); d 1 CREATE TABLE test AS SELECT d FROM (SELECT c AS d FROM (SELECT 1 AS c)); SELECT * FROM test; c 1 CREATE TABLE test AS SELECT c AS d FROM (SELECT 1 AS c); SELECT * FROM test; d 1 And still one more that illustrates the contradictory and unstable behavior. Use '*' instead of 'd' and it works as expected. CREATE TABLE test AS SELECT * FROM (SELECT c AS d FROM (SELECT 1 AS c)); SELECT * FROM test; d 1 Obviously the most immediate well formed alias 'd' should be carried through irrespective of nesting. FYI, there was a checkin just now with some changes to track intermediate aliases: http://www.sqlite.org/src/info/5efd854fe2147033 Peter
_______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
