Artifact
16828871e712007d5be8980bee49eeeb085f4d86:
Ticket change
[16828871]
- New ticket
[acd12990] CREATE TABLE AS fails with a false report of database corruption.
by
drh
2015-09-09 12:34:14.
D 2015-09-09T12:34:14.528
J foundin 3.8.11.1
J icomment The\ssecond\sstatement\sin\sthe\sfollowing\sscript\sreports\san\sSQLITE_CORRUPT\serror:\r\n\r\n<blockquote><verbatim>\r\nCREATE\sTABLE\st1(a);\r\nCREATE\sTABLE\st2\sAS\sSELECT\sname\sFROM\ssqlite_master;\r\n</verbatim></blockquote>\r\n\r\nThe\sdatabase\sis\snot\sactually\scorrupt.\s\sThis\sis\sa\smalfunction\sin\sthe\sCREATE\sTABLE\sAS\sstatement.\r\n\r\nBisecting\sindicates\sthat\sthis\sproblem\swas\sintroduced\sby\scheck-in\r\n[972881c6d3]\son\s[2013-11-21],\sfirst\sreleased\swith\sversion\s3.8.2.
J login drh
J mimetype text/x-fossil-wiki
J severity Important
J status Open
J title CREATE\sTABLE\sAS\sfails\swith\sa\sfalse\sreport\sof\sdatabase\scorruption
J type Code_Defect
K acd12990885d927645a036e0acda6abf3d88ce4b
U drh
Z b133cafd6f041fc8412929bca698c006