Skip Menu |
 

This queue is for tickets about the SQL-Statement CPAN distribution.

Report information
The Basics
Id: 44034
Status: rejected
Priority: 0/
Queue: SQL-Statement

People
Owner: Nobody in particular
Requestors: casueps [...] hotmail.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



X-Originalarrivaltime: 11 Mar 2009 13:25:25.0756 (UTC) FILETIME=[D68D2BC0:01C9A24C]
MIME-Version: 1.0
X-Spam-Status: No, hits=0.0 required=8.0 tests=HTML_MESSAGE,SPF_PASS
X-Virus-Checked: Checked by ClamAV on 16.mx.develooper.com
Importance: Normal
Content-Type: multipart/alternative; boundary="_510c13c2-1d11-468c-af73-7a399092bc95_"
Message-ID: <BLU106-W9276AD3D83D8CDC8364F4AD9E0 [...] phx.gbl>
Received: from la.mx.develooper.com (x1.develooper.com [63.251.223.170]) by diesel.bestpractical.com (Postfix) with SMTP id 6789523C100 for <bug-sql-statement [...] rt.cpan.org>; Wed, 11 Mar 2009 09:25:46 -0400 (EDT)
Received: (qmail 17548 invoked by uid 103); 11 Mar 2009 13:25:45 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 11 Mar 2009 13:25:45 -0000
Received: from blu0-omc3-s25.blu0.hotmail.com (HELO blu0-omc3-s25.blu0.hotmail.com) (65.55.116.100) by 16.mx.develooper.com (qpsmtpd/0.43rc1) with ESMTP; Wed, 11 Mar 2009 06:25:42 -0700
Received: from BLU106-W9 ([65.55.116.74]) by blu0-omc3-s25.blu0.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Wed, 11 Mar 2009 06:25:25 -0700
Delivered-To: cpan-bug+sql-statement [...] diesel.bestpractical.com
Subject: problems with mysql queries
Return-Path: <casueps [...] hotmail.com>
X-Original-To: bug-sql-statement [...] rt.cpan.org
X-Spam-Check-BY: 16.mx.develooper.com
Date: Wed, 11 Mar 2009 13:25:25 +0000
X-Spam-Level: *
X-Originating-Ip: [194.224.48.93]
To: <bug-sql-statement [...] rt.cpan.org>
From: Toni Casueps <casueps [...] hotmail.com>
Content-Length: 0
content-type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: iso-8859-1
Content-Length: 768
Download (untitled) / with headers
text/plain 768b
I'm trying to parse a query and I get this error: SQL ERROR: Junk after table name 'N30_naps_future' This is the code that I used: $parser = SQL::Parser->new(); my $success = $parser->parse("update N30_naps_future n, nenaptype t set match_port_userlabel = concat(n.actual_eqpt_name,'/',replace(replace(t.userlabeltype,'SLOTNUMBER',concat('%',n.card)),'PORTNUMBER',concat('%',n.port)) ) where n.actual_eqpt_netype = t.netypeid"); my %output = %{$parser->structure}; The sentence is correct because I can execute it with a MySQL client. Is this a bug in the parser? Show quoted text
_________________________________________________________________ Llévate Messenger en el móvil a todas partes ¡Conéctate! http://www.microsoft.com/spain/windowsmobile/messenger/default.mspx
content-type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: iso-8859-1
Content-Length: 930
MIME-Version: 1.0
In-Reply-To: <BLU106-W9276AD3D83D8CDC8364F4AD9E0 [...] phx.gbl>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
Charset: utf8
References: <BLU106-W9276AD3D83D8CDC8364F4AD9E0 [...] phx.gbl>
Content-Type: text/plain
Message-ID: <rt-3.6.HEAD-25907-1237713757-991.44034-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 418
Download (untitled) / with headers
text/plain 418b
ANSI SQL 2003 says about the UPDATE syntax: UPDATE [ONLY] {table_name | view_name} SET {{column_name = { ARRAY [array_val[, ...]] | DEFAULT | NULL | scalar_expression }, column_name = ... } | {ROW = row_expression} [ WHERE search_condition | WHERE CURRENT OF cursor_name] Sure, SQL::Statement doesn't support the full SQL ANSI 2003 Standard, but it doesn't implement any MySQL modifications. Maybe it comes one time?


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.