SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select sqlite_version()

sqlite_version()

3.39.1

SELECT 1.5 > '1'

1.5 > '1'

0

SELECT 1.5 > '1.2'

1.5 > '1.2'

0

SELECT 1.5 > ('1' + 0)

1.5 > ('1' + 0)

1

SELECT 1.5 > ('1.2' + 0)

1.5 > ('1.2' + 0)

1

SELECT typeof('1' + 0)

typeof('1' + 0)

integer

SELECT typeof('1.2' + 0)

typeof('1.2' + 0)

real

SELECT CAST(1.5 as numeric) + CAST(1.5 as numeric) > '1'

CAST(1.5 as numeric) + CAST(1.5 as numeric) > '1'

0