If i perform a standard query in SQLite:

```
SELECT * FROM my_table

```

I get all records in my table as expected. If i perform following query:

```
SELECT *, 1 FROM my_table

```

I get all records as expected with rightmost column holding '1' in all records. But if i perform the query:

```
SELECT *, COUNT(*) FROM my_table

```

I get only ONE row (with rightmost column is a correct count).
Why is such results? I'm not very good in SQL, maybe such behavior is expected? It seems very strange and unlogical to me :(.