SQLite

Artifact [5c889138]
Login

Artifact 5c88913817fb9e4ca746822edfe1ceb8b1132c9a:

Ticket change [5c889138] - New ticket [190c2507] Assertion fault on a query against a view. by drh 2017-01-05 16:34:50.
D 2017-01-05T16:34:50.650
J foundin 3.16.1
J icomment The\sfollowing\sSQL\scauses\san\sassertion\sfault:\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1(a);\r\nCREATE\sTABLE\st2(b);\r\nCREATE\sTABLE\st3(c);\r\nCREATE\sVIEW\svvv\sAS\sSELECT\sb\sFROM\st2\sORDER\sBY\s1;\r\nSELECT\s123\sFROM\st1,\s(SELECT\sb\sFROM\svvv\sUNION\sALL\sSELECT\sc\sfrom\st3);\r\n</verbatim></blockquote>\r\n\r\nBisecting\sisolates\sthe\sproblem\sto\scheck-in\s[b9727e6bbfc3c]\s(2015-05-22).\r\nThe\sproblem\sfirst\sappeared\sin\sversion\s3.8.11\son\s2015-07-27.
J login drh
J mimetype text/x-fossil-wiki
J severity Severe
J status Open
J title Assertion\sfault\son\sa\squery\sagainst\sa\sview
J type Code_Defect
K 190c2507eeffcd1154196faa18551cd10a3d4703
U drh
Z 24f490d28767073331b8a63a7393e1de