Forum Replies Created
-
AuthorPosts
-
peterlaursen
ParticipantWhat about this one ??
Is there or is there not an option to specify a logfile other than the default one?
ParticipantI think you exported a DB using “data only”. You must check “structure and data” (or copy the table definition from objects-pane)
@Ritesh: I can't reproduce the issue I thought I had, and I can't remeber details. So no bug report from here unless it comes back one day. But it could have been my fault!Participantand besides …
Open Office Base supports VIEWs when used with JDBC 😛
ParticipantQuote:You can use SQLyog for the same purposeI know! But I don't know if MySQL has some “policy” about exposing third-party clients like SQLyog in their bug-tracking system.
ParticipantI believe now that there is a trivial problem with MySQL's parser where there are two many -characters in a char or varchar field! (some buffer-overrun ??). That takes effect when used with a WHERE and maybe elsewhere ….
In the attached pic only the last query returns correct result! The others return nothing.
ParticipantI have an experience that might be related to it. When using SQLyog ODBC import wizard to import from Access TIMESTAMPs that are NULL with the Access database become 0000-00-00-000000 . When exporting from Access into MySQL values are kept as NULL.
However the two different procedures use different ODBC-drivers (M$ ODBC for Access and MyODBC respectively) so I am not sure whether this is an issue with SQLyog or with the M$ ODBC-driver.
ParticipantMaybe this is not a PK-problem, but rather a problem with escapes and wildcards used in conjunction!!
I consider posting this to MySQL bug system, but I'll let you read it first:
********************************************************************************
*******
Another way to reproduce:
STEP ONE: import this dump:
create database if not exists `music`;
USE `music`;
/*Table structure for table `test` */
DROP TABLE if exists `test`;
CREATE TABLE `test` (
`filename` varchar(255) NOT NULL,
`title` varchar(255) default NULL,
`artist` varchar(255) default NULL,
`album` varchar(255) default NULL,
PRIMARY KEY (`filename`)
);
insert into `test` values ('M:\Peters Musik\Abaji\Oriental Voyage\10 Tchai.mp3','Tchai','Abaji','Oriental Voyage');
STEP TWO: queries
Two queries that WORK:
1)
mysql> select title, filename from test where artist = 'abaji';
+
+
+| title | filename |
+
+
+| Tchai | M:MusicAbajiOriental Voyage10 Tchai.mp3 |
+
+
+1 row in set (0.00 sec)
2)
mysql> select title, filename from test where filename like '%\abaji%';
+
+
+| title | filename |
+
+
+| Tchai | M:MusicAbajiOriental Voyage10 Tchai.mp3 |
+
+
+1 row in set (0.00 sec)
Two queries that DON'T WORK:
3)
mysql> select title, filename from test where filename like '%\abaji\%';
Empty set (0.00 sec)
4)
mysql> select title, filename from test where filename like '%abaji\%';
Empty set (0.00 sec)
Please tell me what's wrong with the use of escaping with these two ??
However this one works:
5)
mysql> select title, filename from test where filename like '%\abaji\%';
+
+
+| title | filename |
+
+
+| Tchai | M:MusicAbajiOriental Voyage10 Tchai.mp3 |
+
+
+1 row in set (0.00 sec)
But why is it necessary to escape the % character here ??
The MySQL manual says
“To test for literal instances of a wildcard character, precede the character with the escape character. If you don't specify the ESCAPE character, '' is assumed.”
However this is not how it behaves in this case!! It seems that escape and wildcard charcters don't always behave as they should when used in combination. with these examples here it does not change anything to change the PK. So maybe it's not a problem related to the PK-setup.
Attached: data shown in graphical client (Open Office 2 Base);
ParticipantThat was better. And editor-bug fixed too!
But still the installation screen displays something like “Welcome …. to Beta 1!”
But from help-menu it does after all display “Beta 2”
ParticipantTwo possiblilties:
1) They forgot updating the messages displayed under installation and from help menu
or
2) They forgot to updating the file at location where the download link points at.
Which one, Ritesh ??
With the download available I dont' think this issue
http://www.webyog.com/forums/index.php?act…iew=getlastpost
is solved as it is supposed to be! But before doing another post in that thread I'd like to be sure that I got the right file!
ParticipantOk … then it's 3-1 to you. But I got this one 😀
ParticipantOK … I must accept that. But still don't understand why it is much faster first time than second time.
ParticipantYes that's how they have classified it till now. Maybe they have too much success at MySQL at the time. That way of just quoting 4 lines from some dicumentation without investigating the case (she couldn't possible do that in a few minutes) is what we call “left-hand-work” in Danish. It seems more important to close an issue than to investigate it
… that just as with my web hosting. If you have some support issue here you'll sometimes have to reopen it 4 or 5 times.
But I can see you have asked her a question. Let's see if she can answer it!
Participantthere is an ansser already from some Victoria Reznichenko
Quote:Because MySQL uses the C escape syntax in strings (for example, 'n' torepresent newline), you must double any '' that you use in your LIKE strings.
For example, to search for 'n', specify it as '\n'. To search for '', specify
it as '\\' (the backslashes are stripped once by the parser and another time
when the pattern match is done, leaving a single backslash to be matched).
I think she misses the point ??
We do
Quote:select * from tablename1 where id like 'M:\%'ParticipantI added a comment myself to the MySQL bug-system.
Participantthanks! 😀
-
AuthorPosts
