Developers July 2002

developers@phpmyadmin.net

16 participants
79 discussions

[Phpmyadmin-devel] Re: table name with "." / pma demo
by Lo�c 15 Jul '02

15 Jul '02

Marc wrote: >phpMyAdmin did not check for a dot in db, table or column >name. Hu, you're right. And there is a codding standard problem in the "PMA_checkReservedWords" function from the "common.lib.php3" script at line 1343: TRUE should be capitalized. >MySQL gave an error when creating the db, table. Yep, that's why we don't check for these invalid characters: MySQL does it very well... except for some buggy versions! >MySQL accepted to create the column, and to delete it. Yep because it's indeed a valid character for columns name. Loïc ______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif

2 1

[Phpmyadmin-devel] Re(4): A commit, please
by Lo�c 15 Jul '02

15 Jul '02

Marc wrote: >Merged. Thanks again, Marc :) Loïc ______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif

1 0

[Phpmyadmin-devel] Re(2): A commit, please
by Lo�c 15 Jul '02

15 Jul '02

>I don't have OmniWeb to test it. Why don't we wait until >someone with OmniWeb can do the test? Of course we can but since it won't broke anything... Loïc ______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif

2 1

[Phpmyadmin-devel] Re(2): table name with "." / pma demo
by Lo�c 15 Jul '02

15 Jul '02

Hi Robin! >eg CREATE foo (bar.bad double) >Produces a table: >CREATE TABLE foo ( > bad double default NULL >) TYPE=MyISAM; >The 'bar' part is totally ogne. Yep but the dot is a valid MySQL character for columns names! BTW I would prefer an error be displayed rather than a silent change in this area. But it's just my opinion. Loïc ______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif

2 1

[Phpmyadmin-devel] A commit, please
by Lo�c 15 Jul '02

15 Jul '02

Hi List! Could one of you test and submit the patch I've suggested in support request #579565 (DELETE SYNTAX)? Thanks, Loïc ______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif

2 1

[Phpmyadmin-devel] Re: table name with "." / pma demo
by Loïc 15 Jul '02

15 Jul '02

Hi List! Olivier wrote: >try to delete the table "www.nukeland" This is a known MySQL problem: dot is an invalid character in db/table/column name but MySQL doesn't check for it while creating db/table/column. BTW it can't do anything with such a db/table/colum. PMA already checks for such invalid characters as soon as you create db/table/column with PMA forms. But it doesn't if you run a SQL script and I'm afraid it would be really too hard to code it. Loïc ______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif

3 2

[Phpmyadmin-devel] ok for -rc3?
by Marc Delisle 14 Jul '02

14 Jul '02

Or is someone working on something today? Mike you wanted to add some messages and validation before -rc3... will you do it today? Marc

1 0

[Phpmyadmin-devel] SQL Standards
by Robin Johnson 13 Jul '02

13 Jul '02

The person I was working with pointed me to a little used link on their site, and I believe that all of us here should take a look at it when we have time. It's a link to get the draft copy of the SQL-200x standard, which, according to him as he is on the ISO SQL committee, is fairly near ready to be released. He also says there will be no more fixes to it, other than spelling/typo fixes. Here is the link: http://www.jtc1sc32.org/sc32/jtc1sc32.nsf/23933607697154bf852566160054bcf7/… You want the first PDF file. Most notably in it, I find that some things that MySQL thinks are valid, are NOT part of the SQL standard. ESP how it does the valid identifier tokens that I had trouble with. MySQL claims valid tokens are: ([A-Za-z$_0-9]*[a-zA-Z$_][A-Za-z$_0-9]*) But the standard says: ([a-zA-Z][a-zA-Z_0-9]*) There are a number of other things, so such a point where I have this question: Should we explictly support MySQL where it diverges from the standard, or only support the SQL standard, with minimal MySQL extensions? -- Robin Hugh Johnson E-Mail : robbat2(a)orbis-terrarum.net Home Page : http://www.orbis-terrarum.net/?l=people.robbat2 ICQ# : 30269588 or 41961639

2 2

[Phpmyadmin-devel] sql.php3 version 1.117
by Marc Delisle 13 Jul '02

13 Jul '02

Hi, I would like to understand the change made today in sql.php3. If I understand correctly, it is to avoid doing the big query if we are just displaying the sql-code of the previous query. If this is the case, I think we should also remove the navigation bar (show x rows...), the insert new row, print view, bookmark label, and avoid the "undefined variable" on $fields_meta at line 493. Marc

1 1

[Phpmyadmin-devel] my contribution
by ZARAZ Admin 13 Jul '02

13 Jul '02

I'd like to contribute to phpMyAdmin project, but you already have a lot of very knowledgeable people for PHP. What do you think if I will redesign the front page of http://www.phpmyadmin.net in a neat way? I will send you few samples, ok? -- Regards, Admin http://www.zaraz.com

2 1

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

Developers July 2002