Re: [sqlite] Re: SQLite version 3 design question: '500'=500?

[Peter Boehm]

> Who can tell me what other SQL database engines do with
> the following?
>
>    CREATE TABLE test1(a VARCHAR(100));
>    INSERT INTO test1 VALUES('501');
>    INSERT INTO test1 VALUES('  502  ');
>    SELECT * FROM test1 WHERE a=501;
>    SELECT * FROM test1 WHERE a=502;
>    SELECT * FROM test1 WHERE a<'502';
Gupta's SQLBase:

TABLE CREATED

1 ROW INSERTED

1 ROW INSERTED

A
====================================================================================================
501
1 ROW SELECTED

A
====================================================================================================
0 ROWS SELECTED

A
====================================================================================================
501
  502
2 ROWS SELECTED

> Or how about this:
>
>    CREATE TABLE test2(b INTEGER);
>    INSERT INTO test2 VALUES(503);
>    INSERT INTO test2 VALUES(504);
>    SELECT * FROM test2 WHERE b='503';
>    SELECT * FROM test2 WHERE b>'503';
>
>
Gupta's SQLBase:

TABLE CREATED

1 ROW INSERTED

1 ROW INSERTED

          B
===========
        503
1 ROW SELECTED

          B
===========
        504
1 ROW SELECTED

Peter

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]