D 2012-12-19T15:01:05.675 J foundin 3.7.15 J icomment Try\sthe\sfollowing:\r\n
\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
\r\n---\r\n\r\nThe\sselect\sstatement\scrashes\sduring\squery\spreparation.\r\n\r\n\r\n[7b96115e81deab0aa0472839cf787ba3f2fc64a7]\r\n\r\n
\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
\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