"Row value misused" error in SQLite database

Question

I'm getting an error from an sqlite3 query for which I can't find any reference material. Googling the string takes me deep in the SQLite code itself, and that's so opaque I can't make heads or tails of it.

The table schema:

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) );

The query:

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

The error:

Error: row value misused

I have no idea how to proceed here. There is plenty of data in the table that would match the query:

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

Can anyone offer any guidance here? Sqlite version is 3.16.2.

row values.

CL.
– CL.

2017-02-09 09:27:11 +00:00
Commented Feb 9, 2017 at 9:27 — CL.
– CL., Commented Feb 9, 2017 at 9:27

John S · Accepted Answer · 2017-02-08 20:47:05Z

167

Nevermind. Those parentheses around the select columns (left over from a copy/paste) are the problem. Poor error message, maybe. But my fault.

answered Feb 8, 2017 at 20:47

John S

3,6733 gold badges23 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

ruffin Over a year ago

Argh. Made exactly the same mistake during an INSERT INTO X (c1, c2...) SELECT... statement. This is a horrible error. And it looks like you have plenty of company.

Falko Over a year ago

Same issue with ORDER BY (sections.orderId, items.orderId). You're answer pointed me into the right direction. :)

Arthur Khazbulatov Over a year ago

@Falko Thank you for your comment, ORDER BY (…) was the case for me too

1.618 · Accepted Answer · 2022-09-18 12:36:03Z

5

JUST

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

then it works.

answered Sep 18, 2022 at 12:36

1.618

8852 gold badges13 silver badges19 bronze badges

Comments

Diomidis Spinellis · Accepted Answer · 2023-01-14 11:32:55Z

4

The same error occurs when putting the elements of a GROUP BY clause inside brackets, as in

SELECT 1 as a, 2 as b FROM (SELECT 1) GROUP BY (a, b);

The correct syntax is, of course

SELECT 1 as a, 2 as b FROM (SELECT 1) GROUP BY a, b;

answered Jan 14, 2023 at 11:32

Diomidis Spinellis

19.5k6 gold badges68 silver badges85 bronze badges

Comments

Otniel · Accepted Answer · 2022-01-08 22:38:52Z

3

I deleted brackets from query and it work for me: from SELECT (column1, column2, ...) FROM table to SELECT column1, column2, ... FROM table

answered Jan 8, 2022 at 22:38

Otniel

312 bronze badges

Comments

halfer · Accepted Answer · 2022-05-27 22:30:10Z

I had a similar when working with a Rails 5.2 Application.

For my case I was trying to write a search query for a model in application:

def self.search(params)
  applications = all.order('created_at DESC') # for not existing params args
  applications = applications.where("cast(id as text) like ?, email like ?, first_name like ?, last_name like ?, appref like ?", "#{params[:search]}", "%#{params[:search]}%", "#{params[:search]}", "#{params[:search]}", "#{params[:search]}",) if params[:search]
  applications
end

The issue was that I was using a comma (,) to separate the search parameters, I simply corrected by using an OR instead:

def self.search(params)
  applications = all.order('created_at DESC') # for not existing params args
  applications = applications.where("cast(id as text) like ? OR email like ? OR first_name like ? OR last_name like ? OR appref like ?", "#{params[:search]}", "%#{params[:search]}%", "#{params[:search]}", "#{params[:search]}", "#{params[:search]}",) if params[:search]
  applications
end

Kupen · Accepted Answer · 2022-05-26 01:54:50Z

2

Yeah, this bug is happing in my code, and I found this questions, but none of the answers helped me.
I fixed this problem with remove the same column in my SELECT command.
(It's stupid, because I can't select the column if the column is already in the condition subcommand.)

This is the problem SQL command (DO NOT USE THIS):

SELECT (`id`, `username`) FROM `users` WHERE `id` = 'someone_s id'

This is the fixed SQL command (PLEASE USE THIS):

SELECT (`username`) FROM `users` WHERE `id` = 'someone_s id'

answered May 26, 2022 at 1:54

Kupen

291 bronze badge

Collectives™ on Stack Overflow

"Row value misused" error in SQLite database

6 Answers 6

3 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

3 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related