D 2020-02-13T02:13:37.325
J foundin trunk
J icomment Consider\sthe\sfollowing\sPOC:\r\n---\r\nCREATE\sTABLE\sv0\s(\sv1\s)\s;\r\nCREATE\sTABLE\sv2\s(\sv5\sINTEGER\sPRIMARY\sKEY\s,\sv4\sINT\s,\sv3\sCHAR(100)\s)\s;\r\nSELECT\sDISTINCT\s*\sFROM\sv0\sLEFT\sJOIN\sv2\sON\sv5\s=\sv4\sAND\sv5\s=\s(\sSELECT\szipfile\s(\slower\s(\s'17'\s)\s,\sv1\s)\sFROM\sv0\sORDER\sBY\srandom\s()\s)\sWHERE\sv2\s.\sv4\s>\s10\s;\r\n---\r\n\r\nIt\striggers\san\sassertion\sin\sdebug\sversion\sof\strunk.
J login yongheng
J mimetype text/plain
J severity Minor
J status Open
J title Assertion\s`pColl1\s&&\s(pParse->nErr\s||\spColl2)'\sfailed.
J type Code_Defect
K 41c1456a6e61c0e7bdffe719361eeab3c540d38a
U yongheng
Z fa66637eb4c6d8b8b364e3912048fa63