Sqlite:“行值被滥用"sqlite中的错误 [英] Sqlite: "Row value misused" error in sqlite

问题描述

我从 sqlite3 查询中收到错误，我找不到任何参考资料.谷歌搜索字符串让我深入了解 sqlite 代码本身，这太不透明了，我无法理解它.

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.

表架构:

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

查询:

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

错误:

错误:行值被滥用

我不知道如何在这里进行.表中有大量数据与查询匹配:

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

有人可以在这里提供任何指导吗?Sqlite 版本为 3.16.2.

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

推荐答案

没关系.选择列周围的括号(从复制/粘贴中遗留下来)是问题所在.糟糕的错误信息，也许吧.但我的错.

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

这篇关于Sqlite:“行值被滥用"sqlite中的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！