[MDEV-6008] MySQL Bug#12546960 - 60993: NAME QUOTED WITH QUOTE INSTEAD OF BACKTICK GIVES NO SYNTAX ERROR Created: 2014-04-02  Updated: 2022-09-08

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.10
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Sergey Vojtovich Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-4784 merge test cases from 5.6 Stalled

 Description   

    ------------------------------------------------------------
    revno: 4471.1.3
    committer: Alexander Nozdrin <alexander.nozdrin@oracle.com>
    branch nick: 5.6-bug14788443
    timestamp: Wed 2012-10-24 18:17:36 +0400
    message:
      Patch for Bug#14788443: ASSERTION FAILED: M_CPP_BUF <= PTR &&
      PTR <= M_CPP_BUF + M_BUF_LENGTH.
 
      The bug was a regression in 5.6.3 introduced by a patch for 12546960
      (revid: magne.mahre@oracle.com-20110725105406-kwpzpksmrsjgeloe).
 
      The problem was that in case of syntax error, the lexer was left in
      non-consistent state (Lex_input_stream::m_cpp_ptr was poiting
      to after-ending-zero byte).
 
      The fix is to return (unget) one character to the Lex_input_stream in
      case of syntax error.
------------------------------------------------------------
revno: 3298
committer: Magne Mahre <magne.mahre@oracle.com>
branch nick: mysql-trunk-12546960
timestamp: Mon 2011-07-25 12:54:06 +0200
message:
  Bug#12546960 - 60993: NAME QUOTED WITH QUOTE INSTEAD OF BACKTICK
                 GIVES NO SYNTAX ERROR
 
  If a statement ended with mismatched quotes, the server would
  accept the statement and present whatever was after the
  initial quote as a text string.
 
  In the particular bug report, the string was started with a
  backtick.  Since the concluding quote was a regular 'tick',
  it was not detected as and ending quote, so the tick was
  added to the string.
 
  The bug was not present when used interactively from the
  mysql client, nor from mysqltest, as these tools do some
  rudimentary quotes checking before sending the statement
  to the server.
 
  The fix introduces a check to verify that the statement
  does not end while still expecting an end quote.  If so -
  a parser error is returned.


Generated at Thu Feb 08 07:08:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.