SQLite Can't add 1+1?

[Nigel_Simpson]

I'm new to SQLite SQL so please can someone help explain why this SQL:

select 1 + 1 as two, typeof(1) as onetype, typeof(1 + 1) as twotype
from t_object
limit 1

returns 11, integer, text

Is there a very different approach to standard arithmetic in this database?

[Richard Freggi]

Read up on sqlite.org, your syntax is off (SQLite is ANSI SQL, your query is not)

[Nigel_Simpson]

Read up on sqlite.org, your syntax is off (SQLite is ANSI SQL, your query is not)

Please could you be more specific? What is the syntax I have done incorrectly?

[Richard Freggi]

Your query runs on my native SQLite (I don't have EA V16)

By ANSI SQL I meant

SELECT 1+1 AS "Two", typeof(1) AS "Type1", typeof(1+1) AS "Type2"

|Two|Type1  |Type2  |
|----|--------|---------|
|2   |integer |integer |

SQLite defaults to TEXT datatype whenever possible, so it may be the EA 16 SQLite driver that's playing games on you

[Nigel_Simpson]

Your query runs on my native SQLite (I don't have EA V16)

By ANSI SQL I meant

SELECT 1+1 AS "Two", typeof(1) AS "Type1", typeof(1+1) AS "Type2"

|Two|Type1  |Type2  |
|----|--------|---------|
|2   |integer |integer |

SQLite defaults to TEXT datatype whenever possible, so it may be the EA 16 SQLite driver that's playing games on you

OK thanks for the clarification. I still have the problem if I just issue:

SELECT 1 + 1

I'm sure it will be the EA16 driver as you say. I've reported a bug.

[Richard Freggi]

It's treating "1" as TEXT datatype, so it's concatenating 2 strings