When does indexing happen?

Using version 5.0.6x on RH. The question I have is about the updating of
indexes.

Say I have a table with a primary key and one or more indexes. I run an
INSERT statement by way of a call to mysql_real_query() in the C api. If
that function call returns zero, i.e., indicating success, does that mean
that everything is guaranteed to be completed? In particular that all the
table indexes have been updated, so that an immediately-subsequent SELECT
statement with an appropriate WHERE clause seeking for the same row will
find it using the index?




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: When does indexing happen?

> Using version 5.0.6x on RH. The question I have is about the updating of
> indexes.
>
> Say I have a table with a primary key and one or more indexes. I run an
> INSERT statement by way of a call to mysql_real_query() in the C api. If
> that function call returns zero, i.e., indicating success, does that mean
> that everything is guaranteed to be completed? In particular that all the
> table indexes have been updated, so that an immediately-subsequent SELECT
> statement with an appropriate WHERE clause seeking for the same row will
> find it using the index?

Update with information I forgot to mention: using MyISAM tables for this.
Also, the table is a MERGED table.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: When does indexing happen?

In the last episode (Jul 26), buford@biffco.net said:
> Using version 5.0.6x on RH. The question I have is about the updating of
> indexes.
>
> Say I have a table with a primary key and one or more indexes. I run an
> INSERT statement by way of a call to mysql_real_query() in the C api. If
> that function call returns zero, i.e., indicating success, does that mean
> that everything is guaranteed to be completed? In particular that all the
> table indexes have been updated, so that an immediately-subsequent SELECT
> statement with an appropriate WHERE clause seeking for the same row will
> find it using the index?

Yes.

--
Dan Nelson
dnelson@allantgroup.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org