From brian@tangent.org Wed Dec  5 22:25:31 2012
From: Brian Aker <brian@tangent.org>
To: discuss@lists.mariadb.org
Subject: Re: [Maria-discuss] [Drizzle-discuss] DrizzleJDBC 1,2
Date: Wed, 05 Dec 2012 14:25:22 -0800
Message-ID: <946CA02D-28AB-4D75-B282-0E06286F4889@tangent.org>
In-Reply-To:
 <CA+1dbhMPmaX7kc2i=CUnV=1_AQ6swhWzu29aq3eSkgSP0Ake=Q@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============0415683957523423575=="

--===============0415683957523423575==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hi Marcus,

Is there a a blog entry that we can link to? (Or a download?)

Thanks!
	-Brian

On Nov 28, 2012, at 12:27 PM, Marcus Eriksson <krummas(a)gmail.com> wrote:

> Hi
>=20
> I just released DrizzleJDBC 1.2
>=20
> DrizzleJDBC is a BSD licensed JDBC driver for MySQL/MariaDB/Drizzle
>=20
> It is in maven central:
> <dependency>
>     <groupId>org.drizzle.jdbc</groupId>
>     <artifactId>drizzle-jdbc</artifactId>
>     <version>1.2</version>
> </dependency>
>=20
> Changelog;
> - IPv6 support, enclose the IP in brackets, [::1] (https://github.com/krumm=
as/DrizzleJDBC/issues/10)
> - Correct behavior if getInt on larger than MAXINT values (https://github.c=
om/krummas/DrizzleJDBC/issues/9)
> - Fix ssl support, was not possible to close connection (https://github.com=
/krummas/DrizzleJDBC/issues/8)
> - Support InputStream in LOAD DATA INFILE (https://github.com/krummas/Drizz=
leJDBC/issues/7)
> - support getting columns using <table>.<column> (https://github.com/krumma=
s/DrizzleJDBC/issues/6)
> - use single quotes (https://github.com/krummas/DrizzleJDBC/pull/5)
> - clean up unicode support (https://github.com/krummas/DrizzleJDBC/pull/4)
> - Fix NPE bug when timestamp is null, patch by Tim Rickettsl on launchpad
> - set FOUND ROWS by default (https://github.com/krummas/DrizzleJDBC/issues/=
2)
>=20
> Report bugs/feature requests etc on github;
> https://github.com/krummas/DrizzleJDBC
>=20
> /Marcus
>=20
>=20
> _______________________________________________
> Mailing list: https://launchpad.net/~drizzle-discuss
> Post to     : drizzle-discuss(a)lists.launchpad.net
> Unsubscribe : https://launchpad.net/~drizzle-discuss
> More help   : https://help.launchpad.net/ListHelp


--===============0415683957523423575==
Content-Type: application/pkcs7-signature
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
MIME-Version: 1.0

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIDYzCCA18w
ggJHoAMCAQICAQEwCwYJKoZIhvcNAQELMGMxEzARBgNVBAMMClRhbmdlbnRPcmcxCzAJBgNVBAgM
AldBMQswCQYDVQQGEwJVUzEQMA4GA1UEBwwHU2VhdHRsZTEgMB4GCSqGSIb3DQEJARYRYnJpYW5A
dGFuZ2VudC5vcmcwHhcNMTIwNTMwMDczMTE3WhcNMTMwNTMwMDczMTE3WjBjMRMwEQYDVQQDDApU
YW5nZW50T3JnMQswCQYDVQQIDAJXQTELMAkGA1UEBhMCVVMxEDAOBgNVBAcMB1NlYXR0bGUxIDAe
BgkqhkiG9w0BCQEWEWJyaWFuQHRhbmdlbnQub3JnMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIB
CgKCAQEAo5NUnoaG5/H8mlvbtCwGcaVyBSsZnoUL+JK6TVGV/aR3MIz9HnE10UMMn8pS65lLBf39
GPmY+JIOWk760dBSBpTU/OA1n1KunjfJb5V6UZ05PfZGHymziiDJaH1DNNSHg0aYrY3e0ILsGToe
v2dxINRpl5jS2UG5+gK1ok9upZp5JlLRYLIfhiqfXxj3V+E5M9BuC7VSHWuHiCRz7r8dluzNABTi
FhcscR8NV5BR+9NObfIOAXDcLZ7Wm3t3c7KNJV9Khckx3+CEGPpAszjtbjlUsFPSzas3wqQYL94p
35uWGXkAGLxwA8Xkq7o4ybp7aA0nytbvDPayJVeraC/Q9wIDAQABoyAwHjAPBgNVHRMBAf8EBTAD
AQH/MAsGA1UdDwQEAwIChDANBgkqhkiG9w0BAQsFAAOCAQEADlo/ydvUhypE0bnYQQDrzkWI+3hh
Aq8hEllAaRHW5Gfz0AjTv8ASXYuVl9ivnHYSe5yJpCuzf/RibUa+qxeXb3oJHfbFfl1z/4rx45qT
7jFHj9Tp/yg2T9qYhUrBTTvXTvvz4WAaG33VKqu3BnqeLSDwQGtrgvkIaKaK/pQka7KxLjUDxSMn
oW1cptbQIfMiEtSoxUZKqoVPh26TMBqYRialesF5fblipoO20HYG38xmiaN4Pdjjp5C2ArT2qT/7
nYg57vDn9+UZ69U8+BuPIC1hZiM/uT49qezJ1nRcWQpD+Vr5JxnjGvQOObryvSZujBLLdW0chFR9
Lm62bLNEbzGCAe4wggHqAgEBMGgwYzETMBEGA1UEAwwKVGFuZ2VudE9yZzELMAkGA1UECAwCV0Ex
CzAJBgNVBAYTAlVTMRAwDgYDVQQHDAdTZWF0dGxlMSAwHgYJKoZIhvcNAQkBFhFicmlhbkB0YW5n
ZW50Lm9yZwIBATAJBgUrDgMCGgUAoF0wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG
9w0BCQUxDxcNMTIxMjA1MjIyNTIyWjAjBgkqhkiG9w0BCQQxFgQUQ2pvpUO60yTS3zACqGCKmWt5
c8kwDQYJKoZIhvcNAQEBBQAEggEAMuH8nufIk2CY1Q3+lxaGIIDGxNYN83ACXhf+sYujYrGdLxUf
GvxT8KRG1CATU+rGhLrZyDaSqEhV4DIb96sR5oUU/LEQc2xs0tXMYI17ASGKNwh6MRk6OgiRvTfL
FgvzmI6HHsxxQaFEhknUjqVVgJGvgTQMWL/3uwU9IrV2EuBWbW3UtaqNJAiB+ZXqZH+OmiIMMZIU
AUirjjU4D4zoSrY7SlmLxaaW+LewNmpLQ2buNx9Jmce+DSWn6ll4nT8Gg91BCLeK4IDXBnbVMQd4
UPGWw7ueDyLMaWgJNN49tPd/GYwGsH/qZ4pJXkyFx1oEbX2GI9Ms3rqCPI6wLsphdwAAAAAAAA==

--===============0415683957523423575==--


From gleebix@gmail.com Wed Dec  5 22:43:09 2012
From: pcrews <gleebix@gmail.com>
To: discuss@lists.mariadb.org
Subject: Re: [Maria-discuss] [Drizzle-discuss] DrizzleJDBC 1,2
Date: Wed, 05 Dec 2012 17:43:03 -0500
Message-ID: <50BFCDF7.1020800@gmail.com>
In-Reply-To: <946CA02D-28AB-4D75-B282-0E06286F4889@tangent.org>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============0213122096456697055=="

--===============0213122096456697055==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hi.

I found these links, but no current blogs.

http://repo2.maven.org/maven2/org/drizzle/jdbc/drizzle-jdbc/
http://repo2.maven.org/maven2/org/drizzle/jdbc/drizzle-jdbc/1.2/



On 12/05/2012 05:25 PM, Brian Aker wrote:
> Hi Marcus,
>
> Is there a a blog entry that we can link to? (Or a download?)
>
> Thanks!
> 	-Brian
>
> On Nov 28, 2012, at 12:27 PM, Marcus Eriksson <krummas(a)gmail.com> wrote:
>
>> Hi
>>
>> I just released DrizzleJDBC 1.2
>>
>> DrizzleJDBC is a BSD licensed JDBC driver for MySQL/MariaDB/Drizzle
>>
>> It is in maven central:
>> <dependency>
>>      <groupId>org.drizzle.jdbc</groupId>
>>      <artifactId>drizzle-jdbc</artifactId>
>>      <version>1.2</version>
>> </dependency>
>>
>> Changelog;
>> - IPv6 support, enclose the IP in brackets, [::1] (https://github.com/krum=
mas/DrizzleJDBC/issues/10)
>> - Correct behavior if getInt on larger than MAXINT values (https://github.=
com/krummas/DrizzleJDBC/issues/9)
>> - Fix ssl support, was not possible to close connection (https://github.co=
m/krummas/DrizzleJDBC/issues/8)
>> - Support InputStream in LOAD DATA INFILE (https://github.com/krummas/Driz=
zleJDBC/issues/7)
>> - support getting columns using <table>.<column> (https://github.com/krumm=
as/DrizzleJDBC/issues/6)
>> - use single quotes (https://github.com/krummas/DrizzleJDBC/pull/5)
>> - clean up unicode support (https://github.com/krummas/DrizzleJDBC/pull/4)
>> - Fix NPE bug when timestamp is null, patch by Tim Rickettsl on launchpad
>> - set FOUND ROWS by default (https://github.com/krummas/DrizzleJDBC/issues=
/2)
>>
>> Report bugs/feature requests etc on github;
>> https://github.com/krummas/DrizzleJDBC
>>
>> /Marcus
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~drizzle-discuss
>> Post to     : drizzle-discuss(a)lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~drizzle-discuss
>> More help   : https://help.launchpad.net/ListHelp
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~drizzle-discuss
> Post to     : drizzle-discuss(a)lists.launchpad.net
> Unsubscribe : https://launchpad.net/~drizzle-discuss
> More help   : https://help.launchpad.net/ListHelp
>



--===============0213122096456697055==--


From krummas@gmail.com Thu Dec  6 06:55:26 2012
From: Marcus Eriksson <krummas@gmail.com>
To: discuss@lists.mariadb.org
Subject: Re: [Maria-discuss] [Drizzle-discuss] DrizzleJDBC 1,2
Date: Thu, 06 Dec 2012 07:55:25 +0100
Message-ID:
 <CA+1dbhPUh1zHXdFfQiE8j8KqnKy9o41+2nBf6pOFncNeHujhqg@mail.gmail.com>
In-Reply-To: <50BFCDF7.1020800@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============8649637118702163446=="

--===============8649637118702163446==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hi

I put the email up on;

http://developian.blogspot.se/2012/12/drizzle-jdbc-12.html

/Marcus


On Wed, Dec 5, 2012 at 11:43 PM, pcrews <gleebix(a)gmail.com> wrote:

> Hi.
>
> I found these links, but no current blogs.
>
> http://repo2.maven.org/maven2/**org/drizzle/jdbc/drizzle-jdbc/<http://repo2=
.maven.org/maven2/org/drizzle/jdbc/drizzle-jdbc/>
> http://repo2.maven.org/maven2/**org/drizzle/jdbc/drizzle-jdbc/**1.2/<http:/=
/repo2.maven.org/maven2/org/drizzle/jdbc/drizzle-jdbc/1.2/>
>
>
>
>
> On 12/05/2012 05:25 PM, Brian Aker wrote:
>
>> Hi Marcus,
>>
>> Is there a a blog entry that we can link to? (Or a download?)
>>
>> Thanks!
>>         -Brian
>>
>> On Nov 28, 2012, at 12:27 PM, Marcus Eriksson <krummas(a)gmail.com> wrote:
>>
>>  Hi
>>>
>>> I just released DrizzleJDBC 1.2
>>>
>>> DrizzleJDBC is a BSD licensed JDBC driver for MySQL/MariaDB/Drizzle
>>>
>>> It is in maven central:
>>> <dependency>
>>>      <groupId>org.drizzle.jdbc</**groupId>
>>>      <artifactId>drizzle-jdbc</**artifactId>
>>>      <version>1.2</version>
>>> </dependency>
>>>
>>> Changelog;
>>> - IPv6 support, enclose the IP in brackets, [::1] (
>>> https://github.com/krummas/**DrizzleJDBC/issues/10<https://github.com/kru=
mmas/DrizzleJDBC/issues/10>
>>> )
>>> - Correct behavior if getInt on larger than MAXINT values (
>>> https://github.com/krummas/**DrizzleJDBC/issues/9<https://github.com/krum=
mas/DrizzleJDBC/issues/9>
>>> )
>>> - Fix ssl support, was not possible to close connection (
>>> https://github.com/krummas/**DrizzleJDBC/issues/8<https://github.com/krum=
mas/DrizzleJDBC/issues/8>
>>> )
>>> - Support InputStream in LOAD DATA INFILE (https://github.com/krummas/**
>>> DrizzleJDBC/issues/7 <https://github.com/krummas/DrizzleJDBC/issues/7>)
>>> - support getting columns using <table>.<column> (
>>> https://github.com/krummas/**DrizzleJDBC/issues/6<https://github.com/krum=
mas/DrizzleJDBC/issues/6>
>>> )
>>> - use single quotes (https://github.com/krummas/**DrizzleJDBC/pull/5<http=
s://github.com/krummas/DrizzleJDBC/pull/5>
>>> )
>>> - clean up unicode support (https://github.com/krummas/**
>>> DrizzleJDBC/pull/4 <https://github.com/krummas/DrizzleJDBC/pull/4>)
>>> - Fix NPE bug when timestamp is null, patch by Tim Rickettsl on launchpad
>>> - set FOUND ROWS by default (https://github.com/krummas/**
>>> DrizzleJDBC/issues/2 <https://github.com/krummas/DrizzleJDBC/issues/2>)
>>>
>>> Report bugs/feature requests etc on github;
>>> https://github.com/krummas/**DrizzleJDBC<https://github.com/krummas/Drizz=
leJDBC>
>>>
>>> /Marcus
>>>
>>>
>>> ______________________________**_________________
>>> Mailing list: https://launchpad.net/~**drizzle-discuss<https://launchpad.=
net/~drizzle-discuss>
>>> Post to     : drizzle-discuss(a)lists.**launchpad.net<drizzle-discuss(a)l=
ists.launchpad.net>
>>> Unsubscribe : https://launchpad.net/~**drizzle-discuss<https://launchpad.=
net/~drizzle-discuss>
>>> More help   : https://help.launchpad.net/**ListHelp<https://help.launchpa=
d.net/ListHelp>
>>>
>>
>>
>>
>> ______________________________**_________________
>> Mailing list: https://launchpad.net/~**drizzle-discuss<https://launchpad.n=
et/~drizzle-discuss>
>> Post to     : drizzle-discuss(a)lists.**launchpad.net<drizzle-discuss(a)li=
sts.launchpad.net>
>> Unsubscribe : https://launchpad.net/~**drizzle-discuss<https://launchpad.n=
et/~drizzle-discuss>
>> More help   : https://help.launchpad.net/**ListHelp<https://help.launchpad=
.net/ListHelp>
>>
>>
>



--===============8649637118702163446==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

PGRpdj5IaTwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+SSBwdXQgdGhlIGVtYWlsIHVwIG9uOzwv
ZGl2PjxkaXY+PGJyPjwvZGl2PjxhIGhyZWY9Imh0dHA6Ly9kZXZlbG9waWFuLmJsb2dzcG90LnNl
LzIwMTIvMTIvZHJpenpsZS1qZGJjLTEyLmh0bWwiPmh0dHA6Ly9kZXZlbG9waWFuLmJsb2dzcG90
LnNlLzIwMTIvMTIvZHJpenpsZS1qZGJjLTEyLmh0bWw8L2E+PGRpdj48YnI+PC9kaXY+CjxkaXY+
L01hcmN1czwvZGl2PjxkaXYgY2xhc3M9ImdtYWlsX2V4dHJhIj48YnI+PGJyPjxkaXYgY2xhc3M9
ImdtYWlsX3F1b3RlIj5PbiBXZWQsIERlYyA1LCAyMDEyIGF0IDExOjQzIFBNLCBwY3Jld3MgPHNw
YW4gZGlyPSJsdHIiPiZsdDs8YSBocmVmPSJtYWlsdG86Z2xlZWJpeEBnbWFpbC5jb20iIHRhcmdl
dD0iX2JsYW5rIj5nbGVlYml4QGdtYWlsLmNvbTwvYT4mZ3Q7PC9zcGFuPiB3cm90ZTo8YnI+Cjxi
bG9ja3F1b3RlIGNsYXNzPSJnbWFpbF9xdW90ZSIgc3R5bGU9Im1hcmdpbjowIDAgMCAuOGV4O2Jv
cmRlci1sZWZ0OjFweCAjY2NjIHNvbGlkO3BhZGRpbmctbGVmdDoxZXgiPkhpLjxicj4KPGJyPgpJ
IGZvdW5kIHRoZXNlIGxpbmtzLCBidXQgbm8gY3VycmVudCBibG9ncy48YnI+Cjxicj4KPGEgaHJl
Zj0iaHR0cDovL3JlcG8yLm1hdmVuLm9yZy9tYXZlbjIvb3JnL2RyaXp6bGUvamRiYy9kcml6emxl
LWpkYmMvIiB0YXJnZXQ9Il9ibGFuayI+aHR0cDovL3JlcG8yLm1hdmVuLm9yZy9tYXZlbjIvPHU+
PC91Pm9yZy9kcml6emxlL2pkYmMvZHJpenpsZS1qZGJjLzwvYT48YnI+CjxhIGhyZWY9Imh0dHA6
Ly9yZXBvMi5tYXZlbi5vcmcvbWF2ZW4yL29yZy9kcml6emxlL2pkYmMvZHJpenpsZS1qZGJjLzEu
Mi8iIHRhcmdldD0iX2JsYW5rIj5odHRwOi8vcmVwbzIubWF2ZW4ub3JnL21hdmVuMi88dT48L3U+
b3JnL2RyaXp6bGUvamRiYy9kcml6emxlLWpkYmMvPHU+PC91PjEuMi88L2E+PGRpdiBjbGFzcz0i
SE9FblpiIj48ZGl2IGNsYXNzPSJoNSI+PGJyPgo8YnI+Cjxicj4KPGJyPgpPbiAxMi8wNS8yMDEy
IDA1OjI1IFBNLCBCcmlhbiBBa2VyIHdyb3RlOjxicj4KPGJsb2NrcXVvdGUgY2xhc3M9ImdtYWls
X3F1b3RlIiBzdHlsZT0ibWFyZ2luOjAgMCAwIC44ZXg7Ym9yZGVyLWxlZnQ6MXB4ICNjY2Mgc29s
aWQ7cGFkZGluZy1sZWZ0OjFleCI+CkhpIE1hcmN1cyw8YnI+Cjxicj4KSXMgdGhlcmUgYSBhIGJs
b2cgZW50cnkgdGhhdCB3ZSBjYW4gbGluayB0bz8gKE9yIGEgZG93bmxvYWQ/KTxicj4KPGJyPgpU
aGFua3MhPGJyPgqgIKAgoCCgIC1Ccmlhbjxicj4KPGJyPgpPbiBOb3YgMjgsIDIwMTIsIGF0IDEy
OjI3IFBNLCBNYXJjdXMgRXJpa3Nzb24gJmx0OzxhIGhyZWY9Im1haWx0bzprcnVtbWFzQGdtYWls
LmNvbSIgdGFyZ2V0PSJfYmxhbmsiPmtydW1tYXNAZ21haWwuY29tPC9hPiZndDsgd3JvdGU6PGJy
Pgo8YnI+CjxibG9ja3F1b3RlIGNsYXNzPSJnbWFpbF9xdW90ZSIgc3R5bGU9Im1hcmdpbjowIDAg
MCAuOGV4O2JvcmRlci1sZWZ0OjFweCAjY2NjIHNvbGlkO3BhZGRpbmctbGVmdDoxZXgiPgpIaTxi
cj4KPGJyPgpJIGp1c3QgcmVsZWFzZWQgRHJpenpsZUpEQkMgMS4yPGJyPgo8YnI+CkRyaXp6bGVK
REJDIGlzIGEgQlNEIGxpY2Vuc2VkIEpEQkMgZHJpdmVyIGZvciBNeVNRTC9NYXJpYURCL0RyaXp6
bGU8YnI+Cjxicj4KSXQgaXMgaW4gbWF2ZW4gY2VudHJhbDo8YnI+CiZsdDtkZXBlbmRlbmN5Jmd0
Ozxicj4KoCCgIKAmbHQ7Z3JvdXBJZCZndDtvcmcuZHJpenpsZS5qZGJjJmx0Oy88dT48L3U+Z3Jv
dXBJZCZndDs8YnI+CqAgoCCgJmx0O2FydGlmYWN0SWQmZ3Q7ZHJpenpsZS1qZGJjJmx0Oy88dT48
L3U+YXJ0aWZhY3RJZCZndDs8YnI+CqAgoCCgJmx0O3ZlcnNpb24mZ3Q7MS4yJmx0Oy92ZXJzaW9u
Jmd0Ozxicj4KJmx0Oy9kZXBlbmRlbmN5Jmd0Ozxicj4KPGJyPgpDaGFuZ2Vsb2c7PGJyPgotIElQ
djYgc3VwcG9ydCwgZW5jbG9zZSB0aGUgSVAgaW4gYnJhY2tldHMsIFs6OjFdICg8YSBocmVmPSJo
dHRwczovL2dpdGh1Yi5jb20va3J1bW1hcy9Ecml6emxlSkRCQy9pc3N1ZXMvMTAiIHRhcmdldD0i
X2JsYW5rIj5odHRwczovL2dpdGh1Yi5jb20va3J1bW1hcy88dT48L3U+RHJpenpsZUpEQkMvaXNz
dWVzLzEwPC9hPik8YnI+Ci0gQ29ycmVjdCBiZWhhdmlvciBpZiBnZXRJbnQgb24gbGFyZ2VyIHRo
YW4gTUFYSU5UIHZhbHVlcyAoPGEgaHJlZj0iaHR0cHM6Ly9naXRodWIuY29tL2tydW1tYXMvRHJp
enpsZUpEQkMvaXNzdWVzLzkiIHRhcmdldD0iX2JsYW5rIj5odHRwczovL2dpdGh1Yi5jb20va3J1
bW1hcy88dT48L3U+RHJpenpsZUpEQkMvaXNzdWVzLzk8L2E+KTxicj4KLSBGaXggc3NsIHN1cHBv
cnQsIHdhcyBub3QgcG9zc2libGUgdG8gY2xvc2UgY29ubmVjdGlvbiAoPGEgaHJlZj0iaHR0cHM6
Ly9naXRodWIuY29tL2tydW1tYXMvRHJpenpsZUpEQkMvaXNzdWVzLzgiIHRhcmdldD0iX2JsYW5r
Ij5odHRwczovL2dpdGh1Yi5jb20va3J1bW1hcy88dT48L3U+RHJpenpsZUpEQkMvaXNzdWVzLzg8
L2E+KTxicj4KLSBTdXBwb3J0IElucHV0U3RyZWFtIGluIExPQUQgREFUQSBJTkZJTEUgKDxhIGhy
ZWY9Imh0dHBzOi8vZ2l0aHViLmNvbS9rcnVtbWFzL0RyaXp6bGVKREJDL2lzc3Vlcy83IiB0YXJn
ZXQ9Il9ibGFuayI+aHR0cHM6Ly9naXRodWIuY29tL2tydW1tYXMvPHU+PC91PkRyaXp6bGVKREJD
L2lzc3Vlcy83PC9hPik8YnI+Ci0gc3VwcG9ydCBnZXR0aW5nIGNvbHVtbnMgdXNpbmcgJmx0O3Rh
YmxlJmd0Oy4mbHQ7Y29sdW1uJmd0OyAoPGEgaHJlZj0iaHR0cHM6Ly9naXRodWIuY29tL2tydW1t
YXMvRHJpenpsZUpEQkMvaXNzdWVzLzYiIHRhcmdldD0iX2JsYW5rIj5odHRwczovL2dpdGh1Yi5j
b20va3J1bW1hcy88dT48L3U+RHJpenpsZUpEQkMvaXNzdWVzLzY8L2E+KTxicj4KLSB1c2Ugc2lu
Z2xlIHF1b3RlcyAoPGEgaHJlZj0iaHR0cHM6Ly9naXRodWIuY29tL2tydW1tYXMvRHJpenpsZUpE
QkMvcHVsbC81IiB0YXJnZXQ9Il9ibGFuayI+aHR0cHM6Ly9naXRodWIuY29tL2tydW1tYXMvPHU+
PC91PkRyaXp6bGVKREJDL3B1bGwvNTwvYT4pPGJyPgotIGNsZWFuIHVwIHVuaWNvZGUgc3VwcG9y
dCAoPGEgaHJlZj0iaHR0cHM6Ly9naXRodWIuY29tL2tydW1tYXMvRHJpenpsZUpEQkMvcHVsbC80
IiB0YXJnZXQ9Il9ibGFuayI+aHR0cHM6Ly9naXRodWIuY29tL2tydW1tYXMvPHU+PC91PkRyaXp6
bGVKREJDL3B1bGwvNDwvYT4pPGJyPgotIEZpeCBOUEUgYnVnIHdoZW4gdGltZXN0YW1wIGlzIG51
bGwsIHBhdGNoIGJ5IFRpbSBSaWNrZXR0c2wgb24gbGF1bmNocGFkPGJyPgotIHNldCBGT1VORCBS
T1dTIGJ5IGRlZmF1bHQgKDxhIGhyZWY9Imh0dHBzOi8vZ2l0aHViLmNvbS9rcnVtbWFzL0RyaXp6
bGVKREJDL2lzc3Vlcy8yIiB0YXJnZXQ9Il9ibGFuayI+aHR0cHM6Ly9naXRodWIuY29tL2tydW1t
YXMvPHU+PC91PkRyaXp6bGVKREJDL2lzc3Vlcy8yPC9hPik8YnI+Cjxicj4KUmVwb3J0IGJ1Z3Mv
ZmVhdHVyZSByZXF1ZXN0cyBldGMgb24gZ2l0aHViOzxicj4KPGEgaHJlZj0iaHR0cHM6Ly9naXRo
dWIuY29tL2tydW1tYXMvRHJpenpsZUpEQkMiIHRhcmdldD0iX2JsYW5rIj5odHRwczovL2dpdGh1
Yi5jb20va3J1bW1hcy88dT48L3U+RHJpenpsZUpEQkM8L2E+PGJyPgo8YnI+Ci9NYXJjdXM8YnI+
Cjxicj4KPGJyPgpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX188dT48L3U+X19fX19fX19f
X19fX19fX188YnI+Ck1haWxpbmcgbGlzdDogPGEgaHJlZj0iaHR0cHM6Ly9sYXVuY2hwYWQubmV0
L35kcml6emxlLWRpc2N1c3MiIHRhcmdldD0iX2JsYW5rIj5odHRwczovL2xhdW5jaHBhZC5uZXQv
fjx1PjwvdT5kcml6emxlLWRpc2N1c3M8L2E+PGJyPgpQb3N0IHRvIKAgoCA6IDxhIGhyZWY9Im1h
aWx0bzpkcml6emxlLWRpc2N1c3NAbGlzdHMubGF1bmNocGFkLm5ldCIgdGFyZ2V0PSJfYmxhbmsi
PmRyaXp6bGUtZGlzY3Vzc0BsaXN0cy48dT48L3U+bGF1bmNocGFkLm5ldDwvYT48YnI+ClVuc3Vi
c2NyaWJlIDogPGEgaHJlZj0iaHR0cHM6Ly9sYXVuY2hwYWQubmV0L35kcml6emxlLWRpc2N1c3Mi
IHRhcmdldD0iX2JsYW5rIj5odHRwczovL2xhdW5jaHBhZC5uZXQvfjx1PjwvdT5kcml6emxlLWRp
c2N1c3M8L2E+PGJyPgpNb3JlIGhlbHAgoCA6IDxhIGhyZWY9Imh0dHBzOi8vaGVscC5sYXVuY2hw
YWQubmV0L0xpc3RIZWxwIiB0YXJnZXQ9Il9ibGFuayI+aHR0cHM6Ly9oZWxwLmxhdW5jaHBhZC5u
ZXQvPHU+PC91Pkxpc3RIZWxwPC9hPjxicj4KPC9ibG9ja3F1b3RlPgo8YnI+Cjxicj4KPGJyPgpf
X19fX19fX19fX19fX19fX19fX19fX19fX19fX188dT48L3U+X19fX19fX19fX19fX19fX188YnI+
Ck1haWxpbmcgbGlzdDogPGEgaHJlZj0iaHR0cHM6Ly9sYXVuY2hwYWQubmV0L35kcml6emxlLWRp
c2N1c3MiIHRhcmdldD0iX2JsYW5rIj5odHRwczovL2xhdW5jaHBhZC5uZXQvfjx1PjwvdT5kcml6
emxlLWRpc2N1c3M8L2E+PGJyPgpQb3N0IHRvIKAgoCA6IDxhIGhyZWY9Im1haWx0bzpkcml6emxl
LWRpc2N1c3NAbGlzdHMubGF1bmNocGFkLm5ldCIgdGFyZ2V0PSJfYmxhbmsiPmRyaXp6bGUtZGlz
Y3Vzc0BsaXN0cy48dT48L3U+bGF1bmNocGFkLm5ldDwvYT48YnI+ClVuc3Vic2NyaWJlIDogPGEg
aHJlZj0iaHR0cHM6Ly9sYXVuY2hwYWQubmV0L35kcml6emxlLWRpc2N1c3MiIHRhcmdldD0iX2Js
YW5rIj5odHRwczovL2xhdW5jaHBhZC5uZXQvfjx1PjwvdT5kcml6emxlLWRpc2N1c3M8L2E+PGJy
PgpNb3JlIGhlbHAgoCA6IDxhIGhyZWY9Imh0dHBzOi8vaGVscC5sYXVuY2hwYWQubmV0L0xpc3RI
ZWxwIiB0YXJnZXQ9Il9ibGFuayI+aHR0cHM6Ly9oZWxwLmxhdW5jaHBhZC5uZXQvPHU+PC91Pkxp
c3RIZWxwPC9hPjxicj4KPGJyPgo8L2Jsb2NrcXVvdGU+Cjxicj4KPC9kaXY+PC9kaXY+PC9ibG9j
a3F1b3RlPjwvZGl2Pjxicj48L2Rpdj4K

--===============8649637118702163446==--


From eric@interplas.com Wed Dec 26 15:07:04 2012
From: Eric Wood <eric@interplas.com>
To: discuss@lists.mariadb.org
Subject: [Maria-discuss] ASFORMENTIONED keyword suggestion
Date: Wed, 26 Dec 2012 10:07:06 -0500
Message-ID: <50DB129A.3050004@interplas.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============2233565485576031427=="

--===============2233565485576031427==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit

Routinely updating records with 20 or more columns can be exhausting 
work.    Many have asked for this for many years and I was hoping a 
MariaDB developer would take the reins in implementing a shorter ON 
DUPLICATE KEY UPDATE syntax:

INSERT INTO `tableName` (`a`,`b`,`c`) VALUES (1,2,3) ON DUPLICATE KEY 
UPDATE `a`=VALUES(`a`), `b`=VALUES(`b`), `c`=VALUES(`c`);
INSERT INTO `tableName` SET a=1, b=2, c=3 ON DUPLICATE KEY UPDATE a=1, 
b=2, c=3;

INSERT INTO `tableName` (`a`,`b`,`c`) VALUES (1,2,3) ON DUPLICATE KEY 
UPDATE ASFORMENTIONED;
INSERT INTO `tableName` SET a=1, b=2, c=3 ON DUPLICATE KEY UPDATE 
ASFORMENTIONED;

Something like this would certainly make SQL enjoyable again.
-Eric Wood


--===============2233565485576031427==--