David Axmark | 1 Jan 2003 12:36
Picon
Favicon

MYSQL - GPL issues

> Subject: MYSQL - GPL issues
> Date: Tue, 31 Dec 2002 02:09:55 -0800 (PST)
> From: Karam Chand <karam_chand02 <at> yahoo.com>
> To: internals <at> lists.mysql.com
> 
> Hello,
> 
> I was not able to get a proper answer in
> mysql <at> lists.mysql.com, therefore I thought of mailing
> to internals.

You should have asked licensing <at> mysql.com not the list. And internals
is also a bad place to ask but this got forwarded.

> Can I make enhancements to libmysql.dll, and
> redistribute the modified libmysql.dll with my closed
> source application? I would also make the source code
> of the modified libmysql.dll available with my closed
> source application. Is is OK?

No, If you want to distribute the MySQL server or client with a closed
source application you will need a commercial license. 

That is the income that pays for all the MySQL developers!

/David

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
(Continue reading)

ramil | 1 Jan 2003 12:59
Picon
Favicon

bk commit into 4.1 tree (1.1428)

Below is the list of changes that have just been committed into a local
4.1 repository of ram. When ram does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet
  1.1428 03/01/01 15:59:35 ram <at> mysql.r18.ru +3 -0
  Fix for QUOTE() function.

  sql/item_strfunc.cc
    1.78 03/01/01 15:59:12 ram <at> mysql.r18.ru +1 -1
    Fix for QUOTE() function.

  mysql-test/t/func_str.test
    1.18 03/01/01 15:59:12 ram <at> mysql.r18.ru +1 -1
    Fix for QUOTE() function.

  mysql-test/r/func_str.result
    1.19 03/01/01 15:59:12 ram <at> mysql.r18.ru +3 -0
    Fix for QUOTE() function.

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	ram
# Host:	mysql.r18.ru
# Root:	/usr/home/ram/work/mysql-4.1.quote

(Continue reading)

paul | 2 Jan 2003 01:37
Favicon

bk commit into mysqldoc tree

Below is the list of changes that have just been committed into a local
mysqldoc repository of paul. When paul does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet <at> 1.162, 2003-01-01 18:37:00-06:00, paul <at> teton.kitebird.com
  manual.texi	remove duplicated words.

  Docs/manual.texi
    1.152 03/01/01 18:36:45 paul <at> teton.kitebird.com +18 -18
    remove duplicated words.

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	paul
# Host:	teton.kitebird.com
# Root:	/home/paul/mysqldoc

--- 1.151/Docs/manual.texi	Sat Dec 28 14:54:44 2002
+++ 1.152/Docs/manual.texi	Wed Jan  1 18:36:45 2003
 <at>  <at>  -5450,7 +5450,7  <at>  <at> 
  <at> enumerate
  <at> item
 If you are working on an NT/2000/XP server, logon as a user with
-with administrator privileges.
+administrator privileges.
  <at> item
(Continue reading)

sanja | 2 Jan 2003 11:24
Picon
Favicon

bk commit into 4.1 tree (1.1429)

Below is the list of changes that have just been committed into a local
4.1 repository of bell. When bell does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet
  1.1429 03/01/02 12:24:33 bell <at> sanja.is.com.ua +4 -0
  post-post-review fix (SCRUM)

  sql/item_subselect.cc
    1.47 03/01/02 12:24:27 bell <at> sanja.is.com.ua +1 -1
    post-post-review fix

  sql/item_row.cc
    1.8 03/01/02 12:24:27 bell <at> sanja.is.com.ua +2 -0
    post-post-review fix

  sql/item_cmpfunc.h
    1.36 03/01/02 12:24:27 bell <at> sanja.is.com.ua +2 -0
    post-post-review fix

  sql/item.cc
    1.72 03/01/02 12:24:27 bell <at> sanja.is.com.ua +3 -2
    post-post-review fix

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
(Continue reading)

Sinisa Milivojevic | 2 Jan 2003 14:52
Picon
Favicon

Re: Fix for INSERT INTO tablename SELECT * FROM tablename

Tim Bunce writes:
> 
> I believe that's not true. Monty added the SQL_BUFFER_RESULT SQL option at
> my suggestion. As the docs at http://www.mysql.com/doc/en/SELECT.html say:
> 
> It applies, or should apply, to all selects.
> 
> > A new option can be used to resolve the above. It would create a
> > temporary HEAP table, so that it would function the way you wanted.
> 
> If the temporary table is a HEAP or not is a separate issue
> (and probably ought to default to HEAP unless SQL_BIG_RESULT is
> specified or the optimiser thinks they'll be too much data).
> 
> My point was a general one: I believe that there is a mechanism
> that can be used to remove the current restriction.  I don't see a
> need for a new option, it should be automatic.
> 
> Tim.

I checked this out and you are right !!

I think that we could add an entry into our WorkLog to enable inserts
from the same table when SQL_BUFFER_RESULT is used. 

--

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <sinisa <at> mysql.com>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
(Continue reading)

peter | 2 Jan 2003 16:04
Picon
Favicon

bk commit into 4.1 tree (1.1431)

Below is the list of changes that have just been committed into a local
4.1 repository of pz. When pz does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet
  1.1431 03/01/02 18:04:02 peter <at> mysql.com +1 -0
  SCRUM password() function changes. 

  sql/item_strfunc.cc
    1.78 03/01/02 18:03:58 peter <at> mysql.com +14 -6
    Fix password() function according Monty's comment

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	peter
# Host:	abyss.local
# Root:	/home/pz/mysql/mysql-4.1

--- 1.77/sql/item_strfunc.cc	Wed Jan  1 20:11:13 2003
+++ 1.78/sql/item_strfunc.cc	Thu Jan  2 18:03:58 2003
 <at>  <at>  -1281,12 +1281,12  <at>  <at> 
   struct rand_struct rand_st; // local structure for 2 param version
   ulong  seed=0;              // seed to initialise random generator to

+  String *res  =args[0]->val_str(str);          
   if ((null_value=args[0]->null_value))
(Continue reading)

Tim Bunce | 2 Jan 2003 17:37
Picon
Favicon

Re: Fix for INSERT INTO tablename SELECT * FROM tablename

On Thu, Jan 02, 2003 at 03:52:30PM +0200, Sinisa Milivojevic wrote:
> Tim Bunce writes:
> > 
> > I believe that's not true. Monty added the SQL_BUFFER_RESULT SQL option at
> > my suggestion. As the docs at http://www.mysql.com/doc/en/SELECT.html say:
> > 
> > It applies, or should apply, to all selects.
> > 
> > > A new option can be used to resolve the above. It would create a
> > > temporary HEAP table, so that it would function the way you wanted.
> > 
> > If the temporary table is a HEAP or not is a separate issue
> > (and probably ought to default to HEAP unless SQL_BIG_RESULT is
> > specified or the optimiser thinks they'll be too much data).
> > 
> > My point was a general one: I believe that there is a mechanism
> > that can be used to remove the current restriction.  I don't see a
> > need for a new option, it should be automatic.
> 
> 
> I checked this out and you are right !!

Peter sent me a note saying that the docs are wrong and that
SQL_BUFFER_RESULT is more limited than that. I hope you're right!

> I think that we could add an entry into our WorkLog to enable inserts
> from the same table

Great. (I've needed it twice in recent weeks, hence the suggestion.)

(Continue reading)

monty | 2 Jan 2003 10:49
Picon
Favicon

bk commit into mysqldoc tree

Below is the list of changes that have just been committed into a local
mysqldoc repository of monty. When monty does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet
  1.161 03/01/02 11:49:13 monty <at> narttu.mysql.fi +1 -0
  Updated requirements for compiling MySQL

  Docs/manual.texi
    1.151 03/01/02 11:49:13 monty <at> narttu.mysql.fi +17 -10
    Updated requirements for compiling MySQL

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	monty
# Host:	narttu.mysql.fi
# Root:	/home/my/mysqldoc

--- 1.150/Docs/manual.texi	Fri Dec 27 21:53:11 2002
+++ 1.151/Docs/manual.texi	Thu Jan  2 11:49:13 2003
 <at>  <at>  -7060,17 +7060,24  <at>  <at> 
 speed of your connection; be patient.

  <at> item
-You will need GNU  <at> code{make},  <at> code{autoconf 2.52},  <at> code{automake 1.5},
+You will need GNU  <at> code{make},  <at> code{autoconf 2.53},  <at> code{automake 1.5},
(Continue reading)

monty | 2 Jan 2003 13:29
Picon
Favicon

bk commit into 4.0 tree (1.1495)

Below is the list of changes that have just been committed into a local
4.0 repository of monty. When monty does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet
  1.1495 03/01/02 14:29:26 monty <at> mashka.mysql.fi +2 -0
  Small optimization of sending big blocks.
  Updated Italian error messages

  sql/share/italian/errmsg.txt
    1.59 03/01/02 14:29:24 monty <at> mashka.mysql.fi +19 -19
    Updated error messages (by Cristian Giussani)

  sql/net_serv.cc
    1.48 03/01/02 14:29:24 monty <at> mashka.mysql.fi +19 -6
    Small optimization of sending big blocks.
    Some small formating changes

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	monty
# Host:	mashka.mysql.fi
# Root:	/home/my/mysql-4.0

--- 1.47/sql/net_serv.cc	Thu Dec 26 18:26:34 2002
+++ 1.48/sql/net_serv.cc	Thu Jan  2 14:29:24 2003
(Continue reading)

Jeremy Zawodny | 2 Jan 2003 22:20

Re: Fix for INSERT INTO tablename SELECT * FROM tablename

On Thu, Jan 02, 2003 at 04:37:00PM +0000, Tim Bunce wrote:
> 
> You already have code to detect inserting into the same table that's
> being selected, why not just change that code to set SQL_BUFFER_RESULT
> instead of raising an error?

Yeah, exactly.  If MySQL can reliably detect that, it'd be ideal if it
"just works" when someone tries it.

Jeremy
--

-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy <at> Zawodny.com>  |  http://jeremy.zawodny.com/

MySQL 3.23.51: up 18 days, processed 643,184,714 queries (398/sec. avg)

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail internals-thread6290 <at> lists.mysql.com
To unsubscribe, e-mail <internals-unsubscribe <at> lists.mysql.com>


Gmane