SQLite
Artifact Content
Not logged in

Artifact 275fd25264eb6e22aeb8ccf626dac6e82bd2a860:

Ticket change [275fd25264] - New ticket [a7b7803e8d1e8699cd8a460a38133b98892d2e17|a7b7803e8d] crash when filtering twice by same predicate using aliases. by anonymous 2012-12-19 15:01:05.
D 2012-12-19T15:01:05.675
J foundin 3.7.15
J icomment Try\sthe\sfollowing:\r\n<pre>\r\n\screate\stable\sname\s(\r\n\s\s\stype\sinteger,\r\n\s\s\spath\stext\sprimary\skey);\r\n\r\n\sselect\s(name.type\s=\s0)\sas\scontainer\sfrom\sName\sname\swhere\sname.type\s=\s0\sor\s\s\s\scontainer\sorder\sby\sname.path\r\n</pre>\r\n---\r\n\r\nThe\sselect\sstatement\scrashes\sduring\squery\spreparation.\r\n\r\n\r\n[7b96115e81deab0aa0472839cf787ba3f2fc64a7]\r\n\r\n<pre>\r\n\s\schar\ssqlite3ExprAffinity(Expr\s*pExpr){\r\n\s\s\s\sint\sop;\r\n\s\s\s\spExpr\s=\ssqlite3ExprSkipCollate(pExpr);\r\n\s\s\s\sint\sop\s=\spExpr->op;\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\r\n\s\s\s\sop\s=\spExpr->op;\r\n\s\s\s\s...\r\n</pre>\r\nlast\sline\scrashes\sbecause\ssqlite3ExprSkipCollate\sreturns\snull.
J login nobody
J mimetype text/x-fossil-wiki
J private_contact 2ed04df9406b2968426cb33430a95417205dd79f
J severity Critical
J status Open
J title crash\swhen\sfiltering\stwice\sby\ssame\spredicate\susing\saliases
J type Code_Defect
K a7b7803e8d1e8699cd8a460a38133b98892d2e17
U 
Z ba5269d4a246db65f3c1dd5aaf4eea3d