> Cc: [EMAIL PROTECTED]
> Subject: RE: suspected bug...
>
>
> On 13 Mar 2003, at 15:30, lauren wrote:
>
> > the actual horror story query is:
> >
> > update link set path=insert(path,1,13,'\\test\\test21\\') where
> > person_id = 8 and path like
On 13 Mar 2003, at 15:30, lauren wrote:
> the actual horror story query is:
>
> update link set path=insert(path,1,13,'\\test\\test21\\') where
> person_id = 8 and path like '\\test\\test2\\%'
You still haven't told us how you're sending this query to MySQL, and
my advice remains the same. If
ith C. Ivey [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 13, 2003 15:27
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: suspected bug...
>
>
> On 13 Mar 2003, at 14:59, lauren wrote:
>
> > if u try to execute a query such as:
> >
> >
On 13 Mar 2003, at 14:59, lauren wrote:
> if u try to execute a query such as:
>
> insert into foo (id,textfield) values (54,'\\fred\\')
>
> the query fails
>
> if i add a space after the last \\ it works
> this is a real pain personally cos we use a lot of that stuff :(
You'll have to show us
[EMAIL PROTECTED] wrote:
I could be lame, but I couldn't reproduce the error.
The query worked ok for me -- using 4.0.4-beta-max-nt
Isn't Lauren using a language that uses \ as an escaping character? And
then tries to do something with \f? If it works form the mysql comman
line, then this can be
I could be lame, but I couldn't reproduce the error.
The query worked ok for me -- using 4.0.4-beta-max-nt
>i posted this to the newsgroups and got told it was probably a sql
>parser bug so here goes...
>
>if u try to execute a query such as:
>
>insert into foo (id,textfield) values (54,'\\fre
At 17:59 16/02/2002 +0100, Roger Baklund wrote:
Hi,
>Thanks for the detailed reply. :)
>
>I did my tests on a pretty old version, 3.23.30-gamma, on a win2k machine. I
>was not aware of the lower_case_table_names variable. (This explains why I
>got lower case filename in my error message, while Fr
* Miguel Angel Solorzano
> * Roger Baklund
>> mysql> rename table U1 to U2;
>> ERROR 7: Error on rename of '.\test\u1.MYI' to '.\test\u2.MYI' (Errcode:
13)
>> mysql> alter table U1 rename as U2;
>> Query OK, 0 rows affected (0.01 sec)
> How you can see we don't have a constant behavior of th
At 13:39 15/02/2002 +0100, Roger Baklund wrote:
Hi Roger,
If I am not wrong after the release 3.23.40 was removed from
config-win.h the line below:
#define FN_LOWER_CASE TRUE /* Files are represented in lower case */
The above meant that MySQL independently of the OS, always wrote the
tables w
nt: Friday, February 15, 2002 7:20 AM
To: SubbaReddy M; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Suspected Bug
Once tables are CREATEd, the name is listed in SHOW tables using lower case
characters, regardless of the case
used in the CREATE command.
Using upper case table names in RENA
t;[EMAIL PROTECTED]>
Sent: Friday, February 15, 2002 3:46 PM
Subject: Re: Suspected Bug
> Yeah, for me also find error.
>
> --
--
> --
> mysql> create table X1(name varchar(10));
&g
Roger,
Friday, February 15, 2002, 1:32:13 PM, you wrote:
RB> * Egor Egorov
>> FL = Fred Lovine
>> FL> CREATE TABLE X1 (x smallint);
>> FL> insert into X1 values(5);
>> FL> RENAME TABLE X1 TO X2;
>>
>> FL> is producing the following error:
>>
>> FL> 7 - Error on rename '.\\X1.MY1' to '.\\X2.MY
Hi,
this has to be a bug. It seems on windows "RENAME TABLE TO " only
works for uppercase table names _after_ an "ALTER TABLE RENAME AS
" _or_ if you first rename the table using lower case letters:
mysql> create table U1 (id int);
Query OK, 0 rows affected (0.04 sec)
mysql> insert into U1 va
Egor,
Yours/this arrived in my InBox whilst I was addressing the original msg - please see
my other reply/ies.
Error still occurs when running as Administrator on WinNT and root under MySQL
- definitely no access/permission issues.
Lower case works (please see earlier reply).
If I/my NT PC can
SubbaReddy M
> I am afraid it's not a bug, rather a syntax error.
> please follow the syntax to rename the table:
>
> mysql> alter table X1 rename as X2;
Why do you say this?
Manual entry:
6.5.5 RENAME TABLE Syntax
RENAME TABLE tbl_name TO new_table_name[, tbl_name2 TO new_table_name2,...]
.
>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: 15 February 2002 10:16
Subject: Re: Suspected Bug
> Yeah, for me also find error.
>
>
> --
> mysql> create table X1(
* Egor Egorov
> FL = Fred Lovine
> FL> CREATE TABLE X1 (x smallint);
> FL> insert into X1 values(5);
> FL> RENAME TABLE X1 TO X2;
>
> FL> is producing the following error:
>
> FL> 7 - Error on rename '.\\X1.MY1' to '.\\X2.MYI' (Errcode: 13)
>
> FL> The problem seems to be caused by using upper
t;[EMAIL PROTECTED]>
Sent: Friday, February 15, 2002 3:46 PM
Subject: Re: Suspected Bug
> Yeah, for me also find error.
>
> --
--
> --
> mysql> create table X1(name varchar(10));
> Query
Yeah, for me also find error.
--
mysql> create table X1(name varchar(10));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into X1 values(5);
Query OK, 1 row affected (0.01 sec)
mysql> RENAME
19 matches
Mail list logo