Recent changes to 4868: (ok 4.5) Parser: ANSI mode breaks insert featurehttps://sourceforge.net/p/phpmyadmin/bugs/4868/2015-07-13T21:32:35.998000ZRecent changes to 4868: (ok 4.5) Parser: ANSI mode breaks insert feature#4868 (ok 4.5) Parser: ANSI mode breaks insert feature2015-07-13T21:32:35.998000Z2015-07-13T21:32:35.998000ZMarc Delislehttps://sourceforge.net/u/lem9/https://sourceforge.net79df93423ec6cd6d390af31aaf6db003a7e81166<div class="markdown_content"><ul>
<li><strong>summary</strong>: Parser: ANSI mode breaks insert feature --> (ok 4.5) Parser: ANSI mode breaks insert feature</li>
<li><strong>status</strong>: open --> resolved</li>
</ul></div>#4868 Parser: ANSI mode breaks insert feature2015-07-13T20:36:18.161000Z2015-07-13T20:36:18.161000ZDan Ungureanuhttps://sourceforge.net/u/udan11/https://sourceforge.netb2a5e1085f3ab87276fd6cb91eb4c20519bd672b<div class="markdown_content"><p>I could not reproduce this using the latest version of phpMyAdmin (the one that integrates the new parser). It seems to be fixed.</p></div>#4868 Parser: ANSI mode breaks insert feature2015-04-26T11:07:12.141000Z2015-04-26T11:07:12.141000ZMarc Delislehttps://sourceforge.net/u/lem9/https://sourceforge.net9b6bfa729a25f4a10c1a14dec4e731642f26c9c3<div class="markdown_content"><p>Thanks. I confirm that the parser is the culprit. In GSoC 2015 there will be a parser rewrite which I expect will take care of this case.</p></div>#4868 Parser: ANSI mode breaks insert feature2015-04-26T11:06:02.778000Z2015-04-26T11:06:02.778000ZMarc Delislehttps://sourceforge.net/u/lem9/https://sourceforge.net0b56bc705be0331d2606cc83f8745cd0d4ef9981<div class="markdown_content"><ul>
<li><strong>summary</strong>: ANSI mode breaks insert feature --> Parser: ANSI mode breaks insert feature</li>
<li><strong>assigned_to</strong>: Marc Delisle</li>
</ul></div>#4868 ANSI mode breaks insert feature2015-04-25T12:14:11.508000Z2015-04-25T12:14:11.508000ZMarc Delislehttps://sourceforge.net/u/lem9/https://sourceforge.net9778afcffc70f88ad91624affb8928815d2d7e06<div class="markdown_content"><ul>
<li><strong>assigned_to</strong>: Marc Delisle --> nobody </li>
</ul></div>#4868 ANSI mode breaks insert feature2015-04-25T11:00:36.719000Z2015-04-25T11:00:36.719000ZMarc Delislehttps://sourceforge.net/u/lem9/https://sourceforge.net0682099fe7eac020680e8e1b317150876226186e<div class="markdown_content"><ul>
<li><strong>assigned_to</strong>: Marc Delisle</li>
</ul></div>ANSI mode breaks insert feature2015-04-23T12:40:09.657000Z2015-04-23T12:40:09.657000Zalbert songhttps://sourceforge.net/u/albb0920/https://sourceforge.netf4ce8a1ea5371981f57a2464f0ab71e8f9119f9d<div class="markdown_content"><p>If mysql server is running under ANSI mode, when visiting the insert page, phpMyAdmin will output following message:</p>
<div class="codehilite"><pre>Notice in ./libraries/Util.class.php#3730
Undefined index: a
Backtrace
./libraries/Util.class.php#3773: PMA_Util::getDefaultFunctionForField(
array,
boolean true,
)
./libraries/insert_edit.lib.php#406: PMA_Util::getFunctionsForField(
array,
boolean true,
)
...
</pre></div>
<p>This is probabily due to PMA_SQP_analyze() doesn't accepts ANSI style quote in CREATE TABLE statement, causing the key of create_table_fields to be empty.</p>
<div class="codehilite"><pre>[create_table_fields] => Array
(
[] => Array
(
[type] => INT
)
)
</pre></div>
<p>Here's a example SHOW CREATE TABLE output by MySQL under ANSI mode.</p>
<div class="codehilite"><pre>CREATE TABLE "test" (
"a" int(11) NOT NULL
)
</pre></div>
<p>Thank you!</p></div>ANSI mode breaks insert feature2015-04-23T12:40:09.657000Z2015-04-23T12:40:09.657000Zalbert songhttps://sourceforge.net/u/albb0920/https://sourceforge.net0fc97cdcf9121f3dd8e91d7817c8026f30a0d94d<div class="markdown_content"><p>Ticket 4868 has been modified: ANSI mode breaks insert feature<br />
Edited By: Marc Delisle (lem9)<br />
Owner updated: None => u'lem9'</p></div>ANSI mode breaks insert feature2015-04-23T12:40:09.657000Z2015-04-23T12:40:09.657000Zalbert songhttps://sourceforge.net/u/albb0920/https://sourceforge.neta85c812020337a823d6d223b2fbe26b2c17da49c<div class="markdown_content"><p>Ticket 4868 has been modified: ANSI mode breaks insert feature<br />
Edited By: Marc Delisle (lem9)<br />
Owner updated: u'lem9' => None</p></div>Parser: ANSI mode breaks insert feature2015-04-23T12:40:09.657000Z2015-04-23T12:40:09.657000Zalbert songhttps://sourceforge.net/u/albb0920/https://sourceforge.net9004f8b1c9c4dca14c1995992bb6a26ca29cd33e<div class="markdown_content"><p>Ticket 4868 has been modified: Parser: ANSI mode breaks insert feature<br />
Edited By: Marc Delisle (lem9)<br />
Summary updated: u'ANSI mode breaks insert feature' => u'Parser: ANSI mode breaks insert feature'<br />
Owner updated: None => u'lem9'</p></div>