Re: [Maria-developers] question on MariaDB and end_bulk_insert

2010-07-22 Thread Zardosht Kasheff
The function is different than mysql 5.1.46. I have not looked at mysql 5.1.47

Thanks
-Zardosht

On Thu, Jul 22, 2010 at 8:19 AM, Sergei Golubchik  wrote:
> Hi, Zardosht!
>
> On Jul 06, Zardosht Kasheff wrote:
>>
>> Oops, it turns out the function signature is different from MySQL.
>> This tripped us up.
>
> Hm, this is arguably a bug. We should not have changed an API.
> I'll fix it.
>
> Regards,
> Sergei
>
>> -Zardosht
>>
>> On Tue, Jul 6, 2010 at 3:15 PM, Zardosht Kasheff  wrote:
>> > Hello,
>> >
>> > First off, is this the right list to post questions about MariaDB's
>> > source code? If it is not, I apologize, and can somebody please direct
>> > me to the right alias? I could not find anything on MariaDB's website.
>> >
>> > I have noticed the following behavior in MariaDB 5.1.47 with our
>> > storage engine that is different than MySQL. I see many cases where
>> > handler::start_bulk_insert before insertions, but
>> > handler::end_bulk_insert is NOT called. In MySQL 5.1.46,
>> > handler::end_bulk_insert is always called if there was a call to
>> > handler::start_bulk_insert.
>> >
>> > The commands run are:
>> > MariaDB [test]> create table ttt(a int);
>> > MariaDB [test]> insert into ttt values (1),(2),(3);
>> > Query OK, 3 rows affected (0.01 sec)
>> > Records: 3 Duplicates: 0 Warnings: 0
>> >
>> > Is there a reason for this? Does some flag need to be exposed for this
>> > function to be called?
>> >
>

___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp


Re: [Maria-developers] question on MariaDB and end_bulk_insert

2010-07-22 Thread Sergei Golubchik
Hi, Zardosht!

On Jul 06, Zardosht Kasheff wrote:
> 
> Oops, it turns out the function signature is different from MySQL.
> This tripped us up.

Hm, this is arguably a bug. We should not have changed an API.
I'll fix it.
 
Regards,
Sergei

> -Zardosht
> 
> On Tue, Jul 6, 2010 at 3:15 PM, Zardosht Kasheff  wrote:
> > Hello,
> >
> > First off, is this the right list to post questions about MariaDB's
> > source code? If it is not, I apologize, and can somebody please direct
> > me to the right alias? I could not find anything on MariaDB's website.
> >
> > I have noticed the following behavior in MariaDB 5.1.47 with our
> > storage engine that is different than MySQL. I see many cases where
> > handler::start_bulk_insert before insertions, but
> > handler::end_bulk_insert is NOT called. In MySQL 5.1.46,
> > handler::end_bulk_insert is always called if there was a call to
> > handler::start_bulk_insert.
> >
> > The commands run are:
> > MariaDB [test]> create table ttt(a int);
> > MariaDB [test]> insert into ttt values (1),(2),(3);
> > Query OK, 3 rows affected (0.01 sec)
> > Records: 3 Duplicates: 0 Warnings: 0
> >
> > Is there a reason for this? Does some flag need to be exposed for this
> > function to be called?
> >

___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp


Re: [Maria-developers] [Fwd: [Commits] bzr commit into Mariadb 5.2, with Maria 2.0:maria/5.2 branch (igor:2821) Bug#604549]

2010-07-22 Thread Philip Stoev
When one sees this pair of codes ER_CONST_EXPR_IN_VCOL and 
ER_ROW_EXPR_FOR_VCOL,
one can't help asking himself whether that's the only disallowed 
expressions,

and if not, do we have error codes for vcol expressions with
- user variables
- subqueries
- SP calls
- etc, etc.
Do we handle such cases at all?


Hello,

I checked our implementation and the Oracle and MS SQL Server documentation 
. We disallow subqueries, stored procedures and functions, but we allow user 
variables. The other database products are mostly stricter than we are, and 
I opened a new bug regarding the more relaxed rules in MariaDB and the 
issues this can cause.


https://bugs.launchpad.net/maria/+bug/608641 



___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp