SQLite Forum

Potential bug? = comparison on columns defined with no type
Login
The no_column_types also has:

```
sqlite> insert into no_column_types (id, name, country_id) values (3, 'Richard', '1');
sqlite> select * from no_column_types order by country_id;
id          name        country_id
----------  ----------  ----------
1           Bob         44
2           Karl        44
3           Richard     1
```

and, of course a simple solution:

```
sqlite> select * from no_column_types order by 0+country_id;
id          name        country_id
----------  ----------  ----------
3           Richard     1
1           Bob         44
2           Karl        44
```