On the miniscule chance anyone's itching to see Informix ver 9
behaviour, here are the results:
IBM Informix Dynamic Server Version 9.40.TC7
CREATE temp TABLE t1(a INTEGER, b INTEGER);
INSERT INTO t1 VALUES(1,2);
INSERT INTO t1 VALUES(9,8);
SELECT a AS b, b AS a FROM t1 ORDER BY a;
b a
1 2
9 8
SELECT b AS a, a AS b FROM t1 ORDER BY a;
a b
2 1
8 9
SELECT a, b AS a FROM t1 ORDER BY a;
a a
1 2
9 8
SELECT a AS x, b AS x ORDER BY x;
201: A syntax error has occurred.
SELECT a AS b, b AS a WHERE a=1;
201: A syntax error has occurred.
SELECT a AS b, b AS a WHERE a=2;
201: A syntax error has occurred.
SELECT a AS x, b AS x WHERE x=1;
201: A syntax error has occurred.
This email and any attachments have been scanned for known viruses using
multiple scanners. We believe that this email and any attachments are virus
free, however the recipient must take full responsibility for virus checking.
This email message is intended for the named recipient only. It may be
privileged and/or confidential. If you are not the named recipient of this
email please notify us immediately and do not copy it or use it for any
purpose, nor disclose its contents to any other person.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
