List:Internals« Previous MessageNext Message »
From:Benjamin Pflugmann Date:August 17 2001 2:28pm
Subject:Re: adding INSERT support to MERGE tables
View as plain text  
Hi.

On Fri, Aug 17, 2001 at 03:31:08PM +0200, serg@stripped wrote:
[...]
> Hmm, I see some problems here.
> 
> Such an information (INSERT_METHOD) should go to .frm file (at least,
> for SHOW CREATE TABLE, ALTER TABLE, etc. to work) but there's no place
> for it. *.frm files (originating in 1980's) are our main obstacle
> in implementing new features. Luckily, 4.0 will have plain-text .frm's
> (that is CREATE TABLE statement in plain text - infinitely expandable).
> 
> Also, INSERT_METHOD should also go to MRG file, for isam layer to know it.
> Also in ROUND_ROBIN it has somehow to preserve the last-target-table number
> on shutdown. This will change MRG files from simple ``ls *.MYI > table.MRG''
> to something more complex. In ROUND_ROBIN they also won't be read-only.
> 
> Otherwise, there can be introduced second file, say, table.MRO (merge-options),
> for such a information.

I somehow knew this part looked to easy at first glance. ;-)

Well, I will start with simply hard-coding the insert method next week
and when inserting works, have a closer look at the config options. At
least I already have my first self-compiled server running now. :)

Thank to both of you for the hints.

Bye,

	Benjamin.

Thread
adding INSERT support to MERGE tablesBenjamin Pflugmann17 Aug
  • Re: adding INSERT support to MERGE tablesSergei Golubchik17 Aug
    • Re: adding INSERT support to MERGE tablesMichael Widenius17 Aug
      • Re: adding INSERT support to MERGE tablesBenjamin Pflugmann30 Aug
        • Re: adding INSERT support to MERGE tablesSergei Golubchik30 Aug
          • Re: adding INSERT support to MERGE tablesBenjamin Pflugmann30 Aug
        • Re: adding INSERT support to MERGE tablesMichael Widenius30 Aug
          • Re: adding INSERT support to MERGE tablesBenjamin Pflugmann30 Aug
            • Re: adding INSERT support to MERGE tablesMichael Widenius1 Sep
              • Re: adding INSERT support to MERGE tablesBenjamin Pflugmann5 Sep
                • Re: adding INSERT support to MERGE tablesMichael Widenius6 Sep
                  • Re: adding INSERT support to MERGE tablesBenjamin Pflugmann10 Sep
                    • Re: adding INSERT support to MERGE tablesBenjamin Pflugmann11 Sep
                      • Re: adding INSERT support to MERGE tablesMichael Widenius12 Sep
                        • Re: adding INSERT support to MERGE tablesBenjamin Pflugmann12 Sep
                          • Re: adding INSERT support to MERGE tablesMichael Widenius13 Sep
                            • Re: adding INSERT support to MERGE tablesBenjamin Pflugmann18 Sep
                      • Re: adding INSERT support to MERGE tablesMichael Widenius22 Sep
                      • Re: adding INSERT support to MERGE tablesMichael Widenius24 Sep
                        • Re: adding INSERT support to MERGE tablesBenjamin Pflugmann27 Sep
    • Re: adding INSERT support to MERGE tablesSergei Golubchik17 Aug
      • Re: adding INSERT support to MERGE tablesBenjamin Pflugmann17 Aug
      • Re: adding INSERT support to MERGE tablesMichael Widenius18 Aug
        • Re: adding INSERT support to MERGE tablesSergei Golubchik18 Aug
          • Re: adding INSERT support to MERGE tablesMichael Widenius20 Aug
RE: adding INSERT support to MERGE tablesThe Tilghman20 Aug