为什么SQLite3中的SELECT查询不工作？

Question

插入：

INSERT INTO MATCHES ("url", "league", "home_team", "away_team", "current_time", "current_score", "penalty_not_score_team", "penalty_not_score_time", "penalty_not_score_name") 
VALUES ('https://www.myscore.com.ua/match/8nsN4E4k/#match-summary', 'АРГЕНТИНА: Кубок Аргентины - 1/16', 'Химнасия Мендоса', 'Ривер Плейт', 'Послес.п.', '1 - 2', 'home', '4''', 'Andrada B.')

结果：

Result: query completed successfully
At line 1:
INSERT INTO MATCHES ("url", "league", "home_team", "away_team", "current_time", "current_score", "penalty_not_score_team", "penalty_not_score_time", "penalty_not_score_name") 
VALUES ('https://www.myscore.com.ua/match/8nsN4E4k/#match-s...', 'АРГЕНТИНА: Кубок Аргентины - 1/16', 'Химнасия Мендоса', 'Ривер Плейт', 'Послес.п.', '1 - 2', 'home', '4''', 'Andrada B.')

选择：

SELECT * 
FROM MATCHES 
WHERE (url="https://www.myscore.com.ua/match/8nsN4E4k/#match-summary" AND league="АРГЕНТИНА: Кубок Аргентины - 1/16" AND home_team="Химнасия Мендоса" AND away_team="Ривер Плейт" AND current_time="Послес.п." AND current_score="1 - 2" AND penalty_not_score_team="home" AND penalty_not_score_time="4'" AND penalty_not_score_name="Andrada B.")

结果：

Result: 0 rows returned in 1ms
At line 1:
SELECT * 
FROM MATCHES 
WHERE (url="https://www.myscore.com.ua/match/8nsN4E4k/#match-s..." AND league="АРГЕНТИНА: Кубок Аргентины - 1/16" AND home_team="Химнасия Мендоса" AND away_team="Ривер Плейт" AND current_time="Послес.п." AND current_score="1 - 2" AND penalty_not_score_team="home" AND penalty_not_score_time="4'" AND penalty_not_score_name="Andrada B.")

数据库中的记录是100%，我用DB浏览器查看它，因为我尝试了不同的语法--但没有用。简短的查询工作，但我需要样本所有的项目。

Answer 1

您必须引用current_time，否则它将被视为函数调用SELECT current_time

AND current_time="Послес.п."
=>
AND "current_time"='Послес.п.'

db<>fiddle demo

CREATE TABLE t(current_time CHAR(10));
INSERT INTO t(current_time) VALUES('aaa');
-- 1 row
SELECT * FROM t;

-- 0 rows returned
SELECT *
FROM t
WHERE current_time = 'aaa';

-- 1 row returned
SELECT *
FROM t
WHERE "current_time" = 'aaa';