Sqlite error "string misuse"

Question

I get an error from sqlite3 query for which I cannot find any reference material. Putting a string into a string takes me deep into the sqlite code itself, and it is so opaque that I cannot make heads or tails.

Table layout:

CREATE TABLE quote (seqnum INTEGER, session STRING, timestamp_sip INTEGER, timestamp_1 INTEGER, market_center STRING, symbol STRING, bid_price INTEGER, bid_lots INTEGER, offer_price INTEGER, offer_lots INTEGER, flags INTEGER, PRIMARY KEY (symbol, seqnum) );

Request:

select (seqnum, session, timestamp_sip, timestamp_1, market_center, symbol) from quote where symbol = 'QQQ';

Error:

Error: row value misused

I have no idea how to act here. There is a lot of data in the table that matches the query:

sqlite> select count(*) from quote where symbol = 'QQQ'; 2675931

Can anyone suggest any directions here? Sqlite version is 3.16.2.

Answer 1

Nevermind These are parentheses around the selection columns (left after copying / pasting). Bad error message maybe. But my fault.