On Wed, Aug 14, 2013 at 8:03 PM, Richard Hipp <d...@sqlite.org> wrote:
> On Wed, Aug 14, 2013 at 1:59 PM, Dominique Devienne <ddevie...@gmail.com
> >wrote:
> > Not authoritative of course, but Oracle seems to agree with the
> previous behavior. --DD
>
> Dominique, can you please try the following SQL on Oracle and let me
> know what you get:
>
Sure, no problem:
SQL> CREATE TABLE t1(m VARCHAR(4));
Table created.
SQL> INSERT INTO t1 VALUES('az');
1 row created.
SQL> INSERT INTO t1 VALUES('by');
1 row created.
SQL> INSERT INTO t1 VALUES('cx');
1 row created.
SQL> SELECT '1', substr(m,2) AS m
2 FROM t1
3 ORDER BY m;
' M
- ------------
1 x
1 y
1 z
SQL> SELECT '2', substr(m,2) AS m
2 FROM t1
3 ORDER BY lower(m);
' M
- ------------
2 x
2 y
2 z
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
