Merge lp:~ziminq/drizzle/filesystem-storage-engine into lp:~drizzle-trunk/drizzle/development

[Monty Taylor]

This is the current development of my GSoC project.
It has been run with param-build.
Please review it.

Thanks.

[Brian Aker (brianaker)]

Hi!

A few things:

1) "i" is difficult for us with older eyes to distinguish (please use x, or something with more characters).

2) Your style is off in a couple of places ( for (size_t x= 0 ; ....).

3) Why don't you declare no need for store_lock()?

4) It would be nice to see a test showing what happens if you get a file that parses incorrectly.

5) Why xread()?

6) Your copyright is off in a few places (I believe).

Cheers,
   -Brian

review: Needs Fixing

[ziminq (ziminq)]

Hi Brian,

Thanks for reviewing.
Replies inlined.

> Hi!
>
> A few things:
>
> 1) "i" is difficult for us with older eyes to distinguish (please use x, or
> something with more characters).

The variable "i" is used only in two places (both in for loop). I thought it would be ok.
Will fix it, change to "x".

>
> 2) Your style is off in a couple of places ( for (size_t x= 0 ; ....).

Thanks for pointing out.

>
> 3) Why don't you declare no need for store_lock()?

This is a bug when I use HTON_SKIP_STORE_LOCK, because I'm not doing the locking on my side.
I'm not sure what's the policy on using the table lock. Should the storage engine writer
write his own locking method?

>
> 4) It would be nice to see a test showing what happens if you get a file that
> parses incorrectly.

OK. Will add later.

>
> 5) Why xread()?

Stewart said it would be better not to use the functions in internal namespace,
so I changed the internal::my_read to the hand-made xread.
Should I go back to my_read? I'm kind of vague in this area as which is the right function to call.

>
> 6) Your copyright is off in a few places (I believe).

I copied the copyright info from CSV or archive plugin. hmm. let me double check this.

>
>
> Cheers,
> -Brian

[ziminq (ziminq)]

Please review:

2 points regarding the previous review:

1. store_lock is still used, as this storage engine is not critical about update/insert performance, and using table lock is easier to implement.

2. 'xread' vs 'internal::my_read，which one is preferred?

--Zimin

[Brian Aker (brianaker)]

Hi!

On Jul 14, 2010, at 7:12 AM, ziminq wrote:

> 1. store_lock is still used, as this storage engine is not critical about update/insert performance, and using table lock is easier to implement.

It is going away, and if we take an engine that uses it, it just forces us to rewrite that engine ourselves when it is fully gone.

> 2. 'xread' vs 'internal::my_read，which one is preferred?

Use posix based IO.

Cheers,
 -brian

[Monty Taylor (mordred)]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 07/14/2010 03:31 PM, Brian Aker wrote:

>> 2. 'xread' vs 'internal::my_read，which one is preferred?
>
> Use posix based IO.

Yes. This is what I was going to say. We don't want to use my_read
because we don't want special random wrappers around posix in our code
that people can't read.

Just use read() directly.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkw+LLMACgkQ2Jv7/VK1RgFLbQCdE1RU/6Gx/EVDIsv3MciLqJ7g
KUUAn2FtBO1JJEMrP1CuDDRmpmKGNxWj
=/JGZ
-----END PGP SIGNATURE-----

[ziminq (ziminq)]

Thanks Brian and Monty, I'll change the code.

[ziminq (ziminq)]

Please review:

The above two points are fixed, now the file system storage engine uses FilesystemLock. No table lock is used any more.

--Zimin

[Stewart Smith (stewart)]

The only thing I'd suggest is renaming "filesystem" to "filesystem_engine" (both directory and plugin name). Just to make it a little less confusing to people.

review: Approve

[lp:~ziminq/drizzle/filesystem-storage-engine]

1665. By ziminq on 2010-07-29

add pthread_mutex_destroy to share->mutex

1666. By ziminq on 2010-07-29

wrap transparentfile in scoped_ptr

1667. By ziminq on 2010-07-30

rename filesystem to filesystem_engine to make it less confusing to users per Stewart's review.

1668. By ziminq on 2010-07-30

modify macros to be in line with the change of the filesystem directory name

[ziminq (ziminq)]

renamed.

directory now is pluign/filesystem_engine/
and the files are plugin/filesystem_engine/filesystem_engine.{h,cc}

the plugin name is called FilesystemEngine.

however, the name specified at CREATE TABLE is still 'ENGINE="FILESYSTEM" '.

[lp:~ziminq/drizzle/filesystem-storage-engine]

1669. By ziminq on 2010-07-30

change engine name in tests

1670. By ziminq on 2010-07-30

wrap transparentfile in scoped_ptr

[Stewart Smith (stewart)]

On Fri, 30 Jul 2010 13:08:47 -0000, ziminq <email address hidden> wrote:
> renamed.
>
> directory now is pluign/filesystem_engine/
> and the files are plugin/filesystem_engine/filesystem_engine.{h,cc}
>
> the plugin name is called FilesystemEngine.
>
> however, the name specified at CREATE TABLE is still 'ENGINE="FILESYSTEM" '.

Excellent!

--
Stewart Smith

=== added directory 'plugin/filesystem_engine'
=== added file 'plugin/filesystem_engine/README'
--- plugin/filesystem_engine/README	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/README	2010-07-30 13:27:46 +0000
@@ -0,0 +1,14 @@
+Here's the corresponding example used in mysql-filesystem-engine.
+drizzle> CREATE TABLE LoadAverage (
+            load1 DECIMAL(3, 2), 
+            load5 DECIMAL(3, 2), 
+            load15 DECIMAL(3, 2), 
+            active_processes VARCHAR(12), 
+            lastpid INTEGER) ENGINE=FILESYSTEM, FILE="/proc/loadavg";
+
+drizzle> select * from LoadAverage;
++-------+-------+--------+------------------+---------+
+| load1 | load5 | load15 | active_processes | lastpid |
++-------+-------+--------+------------------+---------+
+|  0.00 |  0.00 |   0.00 | 1/97             |    6061 | 
++-------+-------+--------+------------------+---------+

=== added file 'plugin/filesystem_engine/demo.txt'
--- plugin/filesystem_engine/demo.txt	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/demo.txt	2010-07-30 13:27:46 +0000
@@ -0,0 +1,1 @@
+0.00 0.00 0.00 1/97 6061

=== added file 'plugin/filesystem_engine/filesystem_engine.cc'
--- plugin/filesystem_engine/filesystem_engine.cc	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/filesystem_engine.cc	2010-07-30 13:27:46 +0000
@@ -0,0 +1,962 @@
+/*
+  Copyright (C) 2010 Zimin
+
+  This program is free software; you can redistribute it and/or
+  modify it under the terms of the GNU General Public License
+  as published by the Free Software Foundation; either version 2
+  of the License, or (at your option) any later version.
+
+  This program is distributed in the hope that it will be useful,
+  but WITHOUT ANY WARRANTY; without even the implied warranty of
+  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+  GNU General Public License for more details.
+
+  You should have received a copy of the GNU General Public License
+  along with this program; if not, write to the Free Software
+  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
+*/
+
+#include "config.h"
+#include <drizzled/field.h>
+#include <drizzled/field/blob.h>
+#include <drizzled/field/timestamp.h>
+#include <drizzled/error.h>
+#include <drizzled/table.h>
+#include <drizzled/session.h>
+#include "drizzled/internal/my_sys.h"
+#include <google/protobuf/io/zero_copy_stream.h>
+#include <google/protobuf/io/zero_copy_stream_impl.h>
+
+#include "filesystem_engine.h"
+#include "utility.h"
+
+#include <fcntl.h>
+
+#include <string>
+#include <map>
+#include <fstream>
+#include <sstream>
+#include <iostream>
+#include <boost/algorithm/string.hpp>
+
+using namespace std;
+using namespace drizzled;
+
+#define FILESYSTEM_EXT ".FST"
+
+/* Stuff for shares */
+pthread_mutex_t filesystem_mutex;
+
+static const char *ha_filesystem_exts[] = {
+  FILESYSTEM_EXT,
+  NULL
+};
+
+class FilesystemEngine : public drizzled::plugin::StorageEngine
+{
+private:
+  typedef std::map<string, FilesystemTableShare*> FilesystemMap;
+  FilesystemMap fs_open_tables;
+public:
+  FilesystemEngine(const string& name_arg)
+   : drizzled::plugin::StorageEngine(name_arg,
+                                     HTON_NULL_IN_KEY |
+                                     HTON_SKIP_STORE_LOCK |
+                                     HTON_CAN_INDEX_BLOBS |
+                                     HTON_AUTO_PART_KEY),
+     fs_open_tables()
+  {
+    table_definition_ext= FILESYSTEM_EXT;
+    pthread_mutex_init(&filesystem_mutex, MY_MUTEX_INIT_FAST);
+  }
+  virtual ~FilesystemEngine()
+  {
+    pthread_mutex_destroy(&filesystem_mutex);
+  }
+
+  virtual Cursor *create(TableShare &table,
+                         drizzled::memory::Root *mem_root)
+  {
+    return new (mem_root) FilesystemCursor(*this, table);
+  }
+
+  const char **bas_ext() const {
+    return ha_filesystem_exts;
+  }
+
+  bool validateCreateTableOption(const std::string &key, const std::string &state);
+
+  int doCreateTable(Session &,
+                    Table &table_arg,
+                    const drizzled::TableIdentifier &identifier,
+                    drizzled::message::Table&);
+
+  int doGetTableDefinition(Session& ,
+                           const drizzled::TableIdentifier &,
+                           drizzled::message::Table &);
+
+  /* Temp only engine, so do not return values. */
+  void doGetTableNames(drizzled::CachedDirectory &, const drizzled::SchemaIdentifier &, drizzled::plugin::TableNameList &);
+
+  int doDropTable(Session&, const TableIdentifier &);
+
+  /* operations on FilesystemTableShare */
+  FilesystemTableShare *findOpenTable(const string table_name);
+  void addOpenTable(const string &table_name, FilesystemTableShare *);
+  void deleteOpenTable(const string &table_name);
+
+  uint32_t max_keys()          const { return 0; }
+  uint32_t max_key_parts()     const { return 0; }
+  uint32_t max_key_length()    const { return 0; }
+  bool doDoesTableExist(Session& , const TableIdentifier &);
+  int doRenameTable(Session&, const TableIdentifier &, const TableIdentifier &);
+  void doGetTableIdentifiers(drizzled::CachedDirectory &directory,
+                             const drizzled::SchemaIdentifier &schema_identifier,
+                             drizzled::TableIdentifiers &set_of_identifiers);
+private:
+  void getTableNamesFromFilesystem(drizzled::CachedDirectory &directory,
+                                   const drizzled::SchemaIdentifier &schema_identifier,
+                                   drizzled::plugin::TableNameList *set_of_names,
+                                   drizzled::TableIdentifiers *set_of_identifiers);
+};
+
+void FilesystemEngine::getTableNamesFromFilesystem(drizzled::CachedDirectory &directory,
+                                                   const drizzled::SchemaIdentifier &schema_identifier,
+                                                   drizzled::plugin::TableNameList *set_of_names,
+                                                   drizzled::TableIdentifiers *set_of_identifiers)
+{
+  drizzled::CachedDirectory::Entries entries= directory.getEntries();
+
+  for (drizzled::CachedDirectory::Entries::iterator entry_iter= entries.begin();
+      entry_iter != entries.end();
+      ++entry_iter)
+  {
+    drizzled::CachedDirectory::Entry *entry= *entry_iter;
+    const string *filename= &entry->filename;
+
+    assert(not filename->empty());
+
+    string::size_type suffix_pos= filename->rfind('.');
+
+    if (suffix_pos != string::npos &&
+        boost::iequals(filename->substr(suffix_pos), FILESYSTEM_EXT) &&
+        filename->compare(0, strlen(TMP_FILE_PREFIX), TMP_FILE_PREFIX))
+    {
+      char uname[NAME_LEN + 1];
+      uint32_t file_name_len;
+
+      file_name_len= TableIdentifier::filename_to_tablename(filename->c_str(), uname, sizeof(uname));
+      uname[file_name_len - sizeof(FILESYSTEM_EXT) + 1]= '\0';
+      if (set_of_names)
+        set_of_names->insert(uname);
+      if (set_of_identifiers)
+        set_of_identifiers->push_back(TableIdentifier(schema_identifier, uname));
+    }
+  }
+}
+
+void FilesystemEngine::doGetTableNames(drizzled::CachedDirectory &directory,
+                                       const drizzled::SchemaIdentifier &schema_identifier,
+                                       drizzled::plugin::TableNameList &set_of_names)
+{
+  getTableNamesFromFilesystem(directory, schema_identifier, &set_of_names, NULL);
+}
+
+void FilesystemEngine::doGetTableIdentifiers(drizzled::CachedDirectory &directory,
+                                             const drizzled::SchemaIdentifier &schema_identifier,
+                                             drizzled::TableIdentifiers &set_of_identifiers)
+{
+  getTableNamesFromFilesystem(directory, schema_identifier, NULL, &set_of_identifiers);
+}
+
+int FilesystemEngine::doDropTable(Session &, const TableIdentifier &identifier)
+{
+  string new_path(identifier.getPath());
+  new_path+= FILESYSTEM_EXT;
+  int err= unlink(new_path.c_str());
+  if (err)
+  {
+    err= errno;
+  }
+  return err;
+}
+
+bool FilesystemEngine::doDoesTableExist(Session &, const TableIdentifier &identifier)
+{
+  string proto_path(identifier.getPath());
+  proto_path.append(FILESYSTEM_EXT);
+
+  if (access(proto_path.c_str(), F_OK))
+  {
+    return false;
+  }
+
+  return true;
+}
+
+FilesystemTableShare *FilesystemEngine::findOpenTable(const string table_name)
+{
+  FilesystemMap::iterator find_iter=
+    fs_open_tables.find(table_name);
+
+  if (find_iter != fs_open_tables.end())
+    return (*find_iter).second;
+  else
+    return NULL;
+}
+
+void FilesystemEngine::addOpenTable(const string &table_name, FilesystemTableShare *share)
+{
+  fs_open_tables[table_name]= share;
+}
+
+void FilesystemEngine::deleteOpenTable(const string &table_name)
+{
+  fs_open_tables.erase(table_name);
+}
+
+static int parseTaggedFile(const FormatInfo &fi, vector< map<string, string> > &v)
+{
+  int filedesc= ::open(fi.getFileName().c_str(), O_RDONLY);
+  if (filedesc < 0)
+    return errno;
+
+  boost::scoped_ptr<TransparentFile> filebuffer(new TransparentFile);
+  filebuffer->init_buff(filedesc);
+
+  bool last_line_empty= false;
+  map<string, string> kv;
+  int pos= 0;
+  string line;
+  while (1)
+  {
+    char ch= filebuffer->get_value(pos);
+    if (ch == '\0')
+    {
+      if (!last_line_empty)
+      {
+        v.push_back(kv);
+        kv.clear();
+      }
+      break;
+    }
+    ++pos;
+
+    if (!fi.isRowSeparator(ch))
+    {
+      line.push_back(ch);
+      continue;
+    }
+
+    // if we have a new empty line,
+    // it means we got the end of a section, push it to vector
+    if (line.empty())
+    {
+      if (!last_line_empty)
+      {
+        v.push_back(kv);
+        kv.clear();
+      }
+      last_line_empty= true;
+      continue;
+    }
+
+    // parse the line
+    vector<string> sv, svcopy;
+    boost::split(sv, line, boost::is_any_of(fi.getColSeparator()));
+    for (vector<string>::iterator iter= sv.begin();
+         iter != sv.end();
+         ++iter)
+    {
+      if (!iter->empty())
+        svcopy.push_back(*iter);
+    }
+
+    // the first splitted string as key,
+    // and the second splitted string as value.
+    string key(svcopy[0]);
+    boost::trim(key);
+    if (svcopy.size() >= 2)
+    {
+      string value(svcopy[1]);
+      boost::trim(value);
+      kv[key]= value;
+    }
+    else if (svcopy.size() >= 1)
+      kv[key]= "";
+
+    last_line_empty= false;
+    line.clear();
+  }
+  close(filedesc);
+  return 0;
+}
+
+int FilesystemEngine::doGetTableDefinition(Session &,
+                                           const drizzled::TableIdentifier &identifier,
+                                           drizzled::message::Table &table_proto)
+{
+  string new_path(identifier.getPath());
+  new_path.append(FILESYSTEM_EXT);
+
+  int fd= ::open(new_path.c_str(), O_RDONLY);
+  if (fd < 0)
+    return ENOENT;
+
+  google::protobuf::io::ZeroCopyInputStream* input=
+    new google::protobuf::io::FileInputStream(fd);
+
+  if (not input)
+    return HA_ERR_CRASHED_ON_USAGE;
+
+  if (not table_proto.ParseFromZeroCopyStream(input))
+  {
+    close(fd);
+    delete input;
+    if (not table_proto.IsInitialized())
+    {
+      my_error(ER_CORRUPT_TABLE_DEFINITION, MYF(0),
+               table_proto.InitializationErrorString().c_str());
+      return ER_CORRUPT_TABLE_DEFINITION;
+    }
+
+    return HA_ERR_CRASHED_ON_USAGE;
+  }
+  delete input;
+
+  // if the file is a tagged file such as /proc/meminfo
+  // then columns of this table are added dynamically here.
+  FormatInfo format;
+  format.parseFromTable(&table_proto);
+  if (!format.isTagFormat() || !format.isFileGiven())
+    return EEXIST;
+
+  vector< map<string, string> > vm;
+  if (parseTaggedFile(format, vm) != 0)
+    return EEXIST;
+  if (vm.size() == 0)
+    return EEXIST;
+
+  // we don't care what user provides, just clear them all
+  table_proto.clear_field();
+  // we take the first section as sample
+  map<string, string> kv= vm[0];
+  for (map<string, string>::iterator iter= kv.begin();
+       iter != kv.end();
+       ++iter)
+  {
+    // add columns to table proto
+    message::Table::Field *field= table_proto.add_field();
+    field->set_name(iter->first);
+    field->set_type(drizzled::message::Table::Field::VARCHAR);
+    message::Table::Field::StringFieldOptions *stringoption= field->mutable_string_options();
+    stringoption->set_length(iter->second.length() + 1);
+  }
+  return EEXIST;
+}
+
+FilesystemTableShare::FilesystemTableShare(const string table_name_arg)
+  : use_count(0), table_name(table_name_arg),
+  update_file_opened(false),
+  needs_reopen(false)
+{
+}
+
+FilesystemTableShare::~FilesystemTableShare()
+{
+  pthread_mutex_destroy(&mutex);
+}
+
+FilesystemTableShare *FilesystemCursor::get_share(const char *table_name)
+{
+  Guard g(filesystem_mutex);
+
+  FilesystemEngine *a_engine= static_cast<FilesystemEngine *>(engine);
+  share= a_engine->findOpenTable(table_name);
+
+  /*
+    If share is not present in the hash, create a new share and
+    initialize its members.
+  */
+  if (share == NULL)
+  {
+    share= new (nothrow) FilesystemTableShare(table_name);
+    if (share == NULL)
+    {
+      return NULL;
+    }
+
+    share->format.parseFromTable(table->getShare()->getTableProto());
+    if (!share->format.isFileGiven())
+    {
+      return NULL;
+    }
+    /*
+     * for taggered file such as /proc/meminfo,
+     * we pre-process it first, and store the parsing result in a map.
+     */
+    if (share->format.isTagFormat())
+    {
+      if (parseTaggedFile(share->format, share->vm) != 0)
+      {
+        return NULL;
+      }
+    }
+    a_engine->addOpenTable(share->table_name, share);
+
+    pthread_mutex_init(&share->mutex, MY_MUTEX_INIT_FAST);
+  }
+  share->use_count++;
+
+  return share;
+}
+
+void FilesystemCursor::free_share()
+{
+  Guard g(filesystem_mutex);
+
+  if (!--share->use_count){
+    FilesystemEngine *a_engine= static_cast<FilesystemEngine *>(engine);
+    a_engine->deleteOpenTable(share->table_name);
+    pthread_mutex_destroy(&share->mutex);
+    delete share;
+  }
+}
+
+void FilesystemCursor::critical_section_enter()
+{
+  if (sql_command_type == SQLCOM_ALTER_TABLE ||
+      sql_command_type == SQLCOM_UPDATE ||
+      sql_command_type == SQLCOM_DELETE ||
+      sql_command_type == SQLCOM_INSERT ||
+      sql_command_type == SQLCOM_INSERT_SELECT ||
+      sql_command_type == SQLCOM_REPLACE ||
+      sql_command_type == SQLCOM_REPLACE_SELECT)
+    share->filesystem_lock.scan_update_begin();
+  else
+    share->filesystem_lock.scan_begin();
+
+  thread_locked = true;
+}
+
+void FilesystemCursor::critical_section_exit()
+{
+  if (sql_command_type == SQLCOM_ALTER_TABLE ||
+      sql_command_type == SQLCOM_UPDATE ||
+      sql_command_type == SQLCOM_DELETE ||
+      sql_command_type == SQLCOM_INSERT ||
+      sql_command_type == SQLCOM_INSERT_SELECT ||
+      sql_command_type == SQLCOM_REPLACE ||
+      sql_command_type == SQLCOM_REPLACE_SELECT)
+    share->filesystem_lock.scan_update_end();
+  else
+    share->filesystem_lock.scan_end();
+
+  thread_locked = false;
+}
+
+FilesystemCursor::FilesystemCursor(drizzled::plugin::StorageEngine &engine_arg, TableShare &table_arg)
+  : Cursor(engine_arg, table_arg),
+    file_buff(new TransparentFile),
+    thread_locked(false)
+{
+}
+
+int FilesystemCursor::doOpen(const drizzled::TableIdentifier &identifier, int, uint32_t)
+{
+  if (!(share= get_share(identifier.getPath().c_str())))
+    return ENOENT;
+
+  file_desc= ::open(share->format.getFileName().c_str(), O_RDONLY);
+  if (file_desc < 0)
+  {
+    free_share();
+    return ER_CANT_OPEN_FILE;
+  }
+
+  ref_length= sizeof(off_t);
+  return 0;
+}
+
+int FilesystemCursor::close(void)
+{
+  int err= ::close(file_desc);
+  if (err < 0)
+    err= errno;
+  free_share();
+  return err;
+}
+
+int FilesystemCursor::doStartTableScan(bool)
+{
+  sql_command_type = session_sql_command(table->getSession());
+
+  if (thread_locked)
+    critical_section_exit();
+  critical_section_enter();
+
+  if (share->format.isTagFormat())
+  {
+    tag_depth= 0;
+    return 0;
+  }
+
+  current_position= 0;
+  next_position= 0;
+  slots.clear();
+  if (share->needs_reopen)
+  {
+    file_desc= ::open(share->format.getFileName().c_str(), O_RDONLY);
+    if (file_desc < 0)
+      return HA_ERR_CRASHED_ON_USAGE;
+    share->needs_reopen= false;
+  }
+  file_buff->init_buff(file_desc);
+  return 0;
+}
+
+int FilesystemCursor::find_current_row(unsigned char *buf)
+{
+  ptrdiff_t row_offset= buf - table->record[0];
+
+  next_position= current_position;
+
+  string content;
+  bool line_done= false;
+  bool line_blank= true;
+  Field **field= table->getFields();
+  for (; !line_done && *field; ++next_position)
+  {
+    char ch= file_buff->get_value(next_position);
+    if (ch == '\0')
+      return HA_ERR_END_OF_FILE;
+
+    if (share->format.isEscapedChar(ch))
+    {
+      // read next character
+      ch= file_buff->get_value(++next_position);
+      if (ch == '\0')
+        return HA_ERR_END_OF_FILE;
+
+      content.push_back(FormatInfo::getEscapedChar(ch));
+
+      continue;
+    }
+
+    // if we find separator
+    bool is_row= share->format.isRowSeparator(ch);
+    bool is_col= share->format.isColSeparator(ch);
+    if (content.empty())
+    {
+      if (share->format.isSeparatorModeGeneral() && is_row && line_blank)
+        continue;
+      if (share->format.isSeparatorModeWeak() && is_col)
+        continue;
+    }
+
+    if (is_row || is_col)
+    {
+      (*field)->move_field_offset(row_offset);
+      if (!content.empty())
+      {
+        (*field)->set_notnull();
+        if ((*field)->isReadSet() || (*field)->isWriteSet())
+        {
+          (*field)->setWriteSet();
+          (*field)->store(content.c_str(),
+                          (uint32_t)content.length(),
+                          &my_charset_bin,
+                          CHECK_FIELD_WARN);
+        }
+        else
+          (*field)->set_default();
+      }
+      else
+        (*field)->set_null();
+      (*field)->move_field_offset(-row_offset);
+
+      content.clear();
+      ++field;
+
+      line_blank= false;
+      if (is_row)
+        line_done= true;
+
+      continue;
+    }
+    content.push_back(ch);
+  }
+  if (line_done)
+  {
+    for (; *field; ++field)
+    {
+      (*field)->move_field_offset(row_offset);
+      (*field)->set_notnull();
+      (*field)->set_default();
+      (*field)->move_field_offset(-row_offset);
+    }
+  }
+  else
+  {
+    // eat up characters when line_done
+    while (!line_done)
+    {
+      char ch= file_buff->get_value(next_position);
+      if (share->format.isRowSeparator(ch))
+        line_done= true;
+      ++next_position;
+    }
+  }
+  return 0;
+}
+
+int FilesystemCursor::rnd_next(unsigned char *buf)
+{
+  ha_statistic_increment(&system_status_var::ha_read_rnd_next_count);
+  if (share->format.isTagFormat())
+  {
+    if (tag_depth >= share->vm.size())
+      return HA_ERR_END_OF_FILE;
+
+    ptrdiff_t row_offset= buf - table->record[0];
+    for (Field **field= table->getFields(); *field; field++)
+    {
+      string key((*field)->field_name);
+      string content= share->vm[tag_depth][key];
+
+      (*field)->move_field_offset(row_offset);
+      if (!content.empty())
+      {
+        (*field)->set_notnull();
+        if ((*field)->isReadSet() || (*field)->isWriteSet())
+        {
+          (*field)->setWriteSet();
+          (*field)->store(content.c_str(),
+                          (uint32_t)content.length(),
+                          &my_charset_bin,
+                          CHECK_FIELD_WARN);
+        }
+        else
+        {
+          (*field)->set_default();
+        }
+      }
+      else
+      {
+        (*field)->set_null();
+      }
+      (*field)->move_field_offset(-row_offset);
+    }
+    ++tag_depth;
+    return 0;
+  }
+  // normal file
+  current_position= next_position;
+  return find_current_row(buf);
+}
+
+void FilesystemCursor::position(const unsigned char *)
+{
+  *reinterpret_cast<off_t *>(ref)= current_position;
+}
+
+int FilesystemCursor::rnd_pos(unsigned char * buf, unsigned char *pos)
+{
+  ha_statistic_increment(&system_status_var::ha_read_rnd_count);
+  current_position= *reinterpret_cast<off_t *>(pos);
+  return find_current_row(buf);
+}
+
+int FilesystemCursor::info(uint32_t)
+{
+  if (stats.records < 2)
+    stats.records= 2;
+  return 0;
+}
+
+int FilesystemCursor::openUpdateFile()
+{
+  if (!share->update_file_opened)
+  {
+    struct stat st;
+    if (stat(share->format.getFileName().c_str(), &st) < 0)
+      return -1;
+    update_file_name= share->format.getFileName();
+    update_file_name.append(".UPDATE");
+    unlink(update_file_name.c_str());
+    update_file_desc= ::open(update_file_name.c_str(),
+                             O_RDWR | O_CREAT | O_TRUNC,
+                             st.st_mode);
+    if (update_file_desc < 0)
+    {
+      return -1;
+    }
+    share->update_file_opened= true;
+  }
+  return 0;
+}
+
+int FilesystemCursor::doEndTableScan()
+{
+  sql_command_type = session_sql_command(table->getSession());
+
+  if (share->format.isTagFormat())
+  {
+    if (thread_locked)
+      critical_section_exit();
+    return 0;
+  }
+
+  if (slots.size() == 0)
+  {
+    if (thread_locked)
+      critical_section_exit();
+    return 0;
+  }
+
+  int err= -1;
+  sort(slots.begin(), slots.end());
+  vector< pair<off_t, off_t> >::iterator slot_iter= slots.begin();
+  off_t write_start= 0;
+  off_t write_end= 0;
+  off_t file_buffer_start= 0;
+
+  pthread_mutex_lock(&share->mutex);
+
+  file_buff->init_buff(file_desc);
+  if (openUpdateFile() < 0)
+    goto error;
+
+  while (file_buffer_start != -1)
+  {
+    bool in_hole= false;
+
+    write_end= file_buff->end();
+    if (slot_iter != slots.end() &&
+      write_end >= slot_iter->first)
+    {
+      write_end= slot_iter->first;
+      in_hole= true;
+    }
+
+    off_t write_length= write_end - write_start;
+    if (write_in_all(update_file_desc,
+               file_buff->ptr() + (write_start - file_buff->start()),
+               write_length) != write_length)
+      goto error;
+
+    if (in_hole)
+    {
+      while (file_buff->end() <= slot_iter->second && file_buffer_start != -1)
+        file_buffer_start= file_buff->read_next();
+      write_start= slot_iter->second;
+      ++slot_iter;
+    }
+    else
+      write_start= write_end;
+
+    if (write_end == file_buff->end())
+      file_buffer_start= file_buff->read_next();
+  }
+  // close update file
+  if (::fsync(update_file_desc) ||
+      ::close(update_file_desc))
+    goto error;
+  share->update_file_opened= false;
+
+  // close current file
+  if (::close(file_desc))
+    goto error;
+  if (::rename(update_file_name.c_str(), share->format.getFileName().c_str()))
+    goto error;
+
+  // reopen the data file
+  file_desc= ::open(share->format.getFileName().c_str(), O_RDONLY);
+  share->needs_reopen= true;
+  if (file_desc < 0)
+    goto error;
+  err= 0;
+error:
+  err= errno;
+  pthread_mutex_unlock(&share->mutex);
+
+  if (thread_locked)
+    critical_section_exit();
+  return err;
+}
+
+void FilesystemCursor::recordToString(string& output)
+{
+  bool first= true;
+  drizzled::String attribute;
+  for (Field **field= table->getFields(); *field; ++field)
+  {
+    if (first == true)
+    {
+      first= false;
+    }
+    else
+    {
+      output.append(share->format.getColSeparatorHead());
+    }
+
+    if (not (*field)->is_null())
+    {
+      (*field)->setReadSet();
+      (*field)->val_str(&attribute, &attribute);
+
+      output.append(attribute.ptr(), attribute.length());
+    }
+    else
+    {
+      output.append("0");
+    }
+  }
+  output.append(share->format.getRowSeparatorHead());
+}
+
+int FilesystemCursor::doInsertRecord(unsigned char * buf)
+{
+  (void)buf;
+
+  if (share->format.isTagFormat())
+    return 0;
+
+  sql_command_type = session_sql_command(table->getSession());
+
+  critical_section_enter();
+
+  int err_write= 0;
+  int err_close= 0;
+
+  string output_line;
+  recordToString(output_line);
+
+  int fd= ::open(share->format.getFileName().c_str(), O_WRONLY | O_APPEND);
+  if (fd < 0)
+  {
+    critical_section_exit();
+    return ENOENT;
+  }
+
+  err_write= write_in_all(fd, output_line.c_str(), output_line.length());
+  if (err_write < 0)
+    err_write= errno;
+  else
+    err_write= 0;
+
+  err_close= ::close(fd);
+  if (err_close < 0)
+    err_close= errno;
+
+  critical_section_exit();
+
+  if (err_write)
+    return err_write;
+  if (err_close)
+    return err_close;
+  return 0;
+}
+
+int FilesystemCursor::doUpdateRecord(const unsigned char *, unsigned char *)
+{
+  if (share->format.isTagFormat())
+    return 0;
+  if (openUpdateFile())
+    return errno;
+
+  // get the update information
+  string str;
+  recordToString(str);
+
+  if (write_in_all(update_file_desc, str.c_str(), str.length()) < 0)
+    return errno;
+
+  addSlot();
+
+  return 0;
+}
+
+void FilesystemCursor::addSlot()
+{
+  if (slots.size() > 0 && slots.back().second == current_position)
+    slots.back().second= next_position;
+  else
+    slots.push_back(make_pair(current_position, next_position));
+}
+
+int FilesystemCursor::doDeleteRecord(const unsigned char *)
+{
+  if (share->format.isTagFormat())
+    return 0;
+  addSlot();
+  return 0;
+}
+
+int FilesystemEngine::doRenameTable(Session&, const TableIdentifier &from, const TableIdentifier &to)
+{
+  if (rename_file_ext(from.getPath().c_str(), to.getPath().c_str(), FILESYSTEM_EXT))
+    return errno;
+  return 0;
+}
+
+bool FilesystemEngine::validateCreateTableOption(const std::string &key,
+                                                 const std::string &state)
+{
+  return FormatInfo::validateOption(key, state);
+}
+
+int FilesystemEngine::doCreateTable(Session &,
+                        Table&,
+                        const drizzled::TableIdentifier &identifier,
+                        drizzled::message::Table &proto)
+{
+  FormatInfo format;
+  format.parseFromTable(&proto);
+  if (format.isFileGiven())
+  {
+    int err= ::open(format.getFileName().c_str(), O_RDONLY);
+    if (err < 0)
+      return errno;
+  }
+
+  string new_path(identifier.getPath());
+  new_path+= FILESYSTEM_EXT;
+  fstream output(new_path.c_str(), ios::out | ios::binary);
+
+  if (! output)
+    return 1;
+
+  if (! proto.SerializeToOstream(&output))
+  {
+    output.close();
+    unlink(new_path.c_str());
+    return 1;
+  }
+
+  return 0;
+}
+
+static FilesystemEngine *filesystem_engine= NULL;
+
+static int filesystem_init_func(drizzled::module::Context &context)
+{
+  filesystem_engine= new FilesystemEngine("FILESYSTEM");
+  context.add(filesystem_engine);
+
+  return 0;
+}
+
+DRIZZLE_DECLARE_PLUGIN
+{
+  DRIZZLE_VERSION_ID,
+  "FILESYSTEM",
+  "1.0",
+  "Zimin",
+  "Filesystem Engine",
+  PLUGIN_LICENSE_GPL,
+  filesystem_init_func, /* Plugin Init */
+  NULL,                       /* system variables                */
+  NULL                        /* config options                  */
+}
+DRIZZLE_DECLARE_PLUGIN_END;

=== added file 'plugin/filesystem_engine/filesystem_engine.h'
--- plugin/filesystem_engine/filesystem_engine.h	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/filesystem_engine.h	2010-07-30 13:27:46 +0000
@@ -0,0 +1,116 @@
+/*
+  Copyright (C) 2010 Zimin
+
+  This program is free software; you can redistribute it and/or
+  modify it under the terms of the GNU General Public License
+  as published by the Free Software Foundation; either version 2
+  of the License, or (at your option) any later version.
+
+  This program is distributed in the hope that it will be useful,
+  but WITHOUT ANY WARRANTY; without even the implied warranty of
+  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+  GNU General Public License for more details.
+
+  You should have received a copy of the GNU General Public License
+  along with this program; if not, write to the Free Software
+  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
+*/
+
+#ifndef PLUGIN_FILESYSTEM_ENGINE_FILESYSTEM_ENGINE_H
+#define PLUGIN_FILESYSTEM_ENGINE_FILESYSTEM_ENGINE_H
+
+#include <drizzled/cursor.h>
+#include <drizzled/thr_lock.h>
+
+#include <boost/scoped_ptr.hpp>
+
+#include <sys/types.h>
+#include <sys/stat.h>
+#include <fstream>
+
+#include "transparent_file.h"
+#include "formatinfo.h"
+#include "filesystemlock.h"
+
+class FilesystemTableShare
+{
+  FilesystemTableShare();
+  FilesystemTableShare(const FilesystemTableShare &);
+  FilesystemTableShare& operator=(const FilesystemTableShare &);
+public:
+  explicit FilesystemTableShare(const std::string name);
+  ~FilesystemTableShare();
+
+  uint32_t use_count;
+  const std::string table_name;
+  bool update_file_opened;
+  bool needs_reopen;
+  pthread_mutex_t mutex;
+  FormatInfo format;
+  std::vector< std::map<std::string, std::string> > vm;
+  FilesystemLock filesystem_lock;
+};
+
+class FilesystemCursor : public drizzled::Cursor
+{
+  FilesystemTableShare *share;       /* Shared lock info */
+  boost::scoped_ptr<TransparentFile> file_buff;
+  int file_desc;
+  std::string update_file_name;
+  int update_file_desc;
+  size_t tag_depth;
+  off_t current_position;
+  off_t next_position;
+  bool thread_locked;
+  uint32_t sql_command_type; /* Type of SQL command to process */
+  /* each slot means an interval in a file which will be deleted later */
+  std::vector< std::pair<off_t, off_t> > slots;
+
+public:
+  FilesystemCursor(drizzled::plugin::StorageEngine &engine, drizzled::TableShare &table_arg);
+  ~FilesystemCursor()
+  {
+  }
+
+  /** @brief
+    The name that will be used for display purposes.
+   */
+  const char *table_type(void) const { return "FILESYSTEM"; }
+
+  /*
+     Called in test_quick_select to determine if indexes should be used.
+   */
+  virtual double scan_time() { return (double) (stats.records+stats.deleted) / 20.0+10; }
+
+  /* The next method will never be called */
+  virtual bool fast_key_read() { return 1;}
+  drizzled::ha_rows estimate_rows_upper_bound() { return HA_POS_ERROR; }
+
+  int doOpen(const drizzled::TableIdentifier &, int, uint32_t);
+  int close(void);
+  int doStartTableScan(bool scan=1);
+  int rnd_next(unsigned char *);
+  int rnd_pos(unsigned char * , unsigned char *);
+  void position(const unsigned char *);
+  int info(uint);
+  int doEndTableScan();
+  int doInsertRecord(unsigned char * buf);
+  int doUpdateRecord(const unsigned char *, unsigned char *);
+  int doDeleteRecord(const unsigned char *);
+
+  virtual void get_auto_increment(uint64_t offset, uint64_t increment,
+                                  uint64_t nb_desired_values,
+                                  uint64_t *first_value,
+                                  uint64_t *nb_reserved_values) { (void)offset; (void)increment; (void)nb_desired_values; (void)first_value; (void)nb_reserved_values; };
+  FilesystemTableShare *get_share(const char *table_name);
+  void free_share();
+  void critical_section_enter();
+  void critical_section_exit();
+private:
+  void recordToString(std::string& output);
+  void addSlot();
+  int openUpdateFile();
+  int find_current_row(unsigned char *buf);
+};
+
+#endif /* PLUGIN_FILESYSTEM_ENGINE_FILESYSTEM_ENGINE_H */

=== added file 'plugin/filesystem_engine/filesystemlock.cc'
--- plugin/filesystem_engine/filesystemlock.cc	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/filesystemlock.cc	2010-07-30 13:27:46 +0000
@@ -0,0 +1,89 @@
+/*
+  Copyright (C) 2010 Zimin
+
+  This program is free software; you can redistribute it and/or
+  modify it under the terms of the GNU General Public License
+  as published by the Free Software Foundation; either version 2
+  of the License, or (at your option) any later version.
+
+  This program is distributed in the hope that it will be useful,
+  but WITHOUT ANY WARRANTY; without even the implied warranty of
+  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+  GNU General Public License for more details.
+
+  You should have received a copy of the GNU General Public License
+  along with this program; if not, write to the Free Software
+  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
+*/
+
+#include <config.h>
+#include <pthread.h>
+#include <assert.h>
+#include "filesystemlock.h"
+
+FilesystemLock::FilesystemLock()
+  : scanner_count(0),
+    updater_count(0)
+{
+  pthread_cond_init(&condition, NULL);
+  pthread_mutex_init(&mutex, NULL);
+}
+
+FilesystemLock::~FilesystemLock()
+{
+  pthread_cond_destroy(&condition);
+  pthread_mutex_destroy(&mutex);
+}
+
+void FilesystemLock::scan_begin()
+{
+  pthread_mutex_lock(&mutex);
+  while (true)
+  {
+    if (updater_count == 0)
+    {
+      scanner_count++;
+      pthread_mutex_unlock(&mutex);
+      return;
+    }
+    pthread_cond_wait(&condition, &mutex);
+  }
+  pthread_mutex_unlock(&mutex);
+}
+
+void FilesystemLock::scan_end() {
+  pthread_mutex_lock(&mutex);
+  scanner_count--;
+  assert(scanner_count >= 0);
+  if (scanner_count == 0)
+    pthread_cond_broadcast(&condition);
+  pthread_mutex_unlock(&mutex);
+}
+
+void FilesystemLock::scan_update_begin()
+{
+  pthread_mutex_lock(&mutex);
+  while (true)
+  {
+    if (scanner_count == 0 && updater_count == 0)
+    {
+      scanner_count++;
+      updater_count++;
+      pthread_mutex_unlock(&mutex);
+      return;
+    }
+    pthread_cond_wait(&condition, &mutex);
+  }
+  pthread_mutex_unlock(&mutex);
+}
+
+void FilesystemLock::scan_update_end()
+{
+  pthread_mutex_lock(&mutex);
+  scanner_count--;
+  updater_count--;
+  assert(scanner_count >= 0 && updater_count >= 0);
+
+  pthread_cond_broadcast(&condition);
+  pthread_mutex_unlock(&mutex);
+}

=== added file 'plugin/filesystem_engine/filesystemlock.h'
--- plugin/filesystem_engine/filesystemlock.h	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/filesystemlock.h	2010-07-30 13:27:46 +0000
@@ -0,0 +1,60 @@
+/*
+  Copyright (C) 2010 Zimin
+
+  This program is free software; you can redistribute it and/or
+  modify it under the terms of the GNU General Public License
+  as published by the Free Software Foundation; either version 2
+  of the License, or (at your option) any later version.
+
+  This program is distributed in the hope that it will be useful,
+  but WITHOUT ANY WARRANTY; without even the implied warranty of
+  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+  GNU General Public License for more details.
+
+  You should have received a copy of the GNU General Public License
+  along with this program; if not, write to the Free Software
+  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
+*/
+
+#ifndef PLUGIN_FILESYSTEM_ENGINE_FILESYSTEMLOCK_H
+#define PLUGIN_FILESYSTEM_ENGINE_FILESYSTEMLOCK_H
+
+#include <pthread.h>
+
+class FilesystemLock
+{
+public:
+  FilesystemLock();
+  ~FilesystemLock();
+
+  void scan_begin();
+  void scan_end();
+  void scan_update_begin();
+  void scan_update_end();
+private:
+  pthread_cond_t condition;
+  pthread_mutex_t mutex;
+  int scanner_count;
+  int updater_count;
+};
+
+class Guard
+{
+public:
+  Guard(pthread_mutex_t& mutex) : mutex_(&mutex)
+  {
+    pthread_mutex_lock(mutex_);
+  }
+
+  ~Guard()
+  {
+    if (mutex_)
+    {
+      pthread_mutex_unlock(mutex_);
+    }
+  }
+private:
+  pthread_mutex_t *mutex_;
+};
+
+#endif /* PLUGIN_FILESYSTEM_ENGINE_FILESYSTEMLOCK_H */

=== added file 'plugin/filesystem_engine/formatinfo.cc'
--- plugin/filesystem_engine/formatinfo.cc	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/formatinfo.cc	2010-07-30 13:27:46 +0000
@@ -0,0 +1,187 @@
+/*
+  Copyright (C) 2010 Zimin
+
+  This program is free software; you can redistribute it and/or
+  modify it under the terms of the GNU General Public License
+  as published by the Free Software Foundation; either version 2
+  of the License, or (at your option) any later version.
+
+  This program is distributed in the hope that it will be useful,
+  but WITHOUT ANY WARRANTY; without even the implied warranty of
+  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+  GNU General Public License for more details.
+
+  You should have received a copy of the GNU General Public License
+  along with this program; if not, write to the Free Software
+  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
+*/
+
+#include "config.h"
+#include <drizzled/field.h>
+#include <string>
+#include <boost/algorithm/string.hpp>
+
+#include "formatinfo.h"
+
+#include <iostream>
+using namespace std;
+
+static const char* FORMAT_INFO_FILE_PATH= "FILE";
+static const char* FORMAT_INFO_ROW_SEPARATOR= "ROW_SEPARATOR";
+static const char* FORMAT_INFO_COL_SEPARATOR= "COL_SEPARATOR";
+static const char* FORMAT_INFO_FORMAT= "FORMAT";
+static const char* FORMAT_INFO_SEPARATOR_MODE= "SEPARATOR_MODE";
+static const char* FORMAT_INFO_SEPARATOR_MODE_STRICT= "STRICT";
+static const char* FORMAT_INFO_SEPARATOR_MODE_GENERAL= "GENERAL";
+static const char* FORMAT_INFO_SEPARATOR_MODE_WEAK= "WEAK";
+static const char* FORMAT_INFO_FORMAT_TAG= "KEY_VALUE";
+static const char* FORMAT_INFO_FORMAT_NORMAL= "NORMAL";
+static const char* FORMAT_INFO_ESCAPE= "ESCAPED_BY";
+enum filesystem_option_separator_mode_type
+{
+  FORMAT_INFO_SEPARATOR_MODE_STRICT_ENUM= 1,
+  FORMAT_INFO_SEPARATOR_MODE_GENERAL_ENUM,
+  FORMAT_INFO_SEPARATOR_MODE_WEAK_ENUM
+};
+
+static const char* DEFAULT_ROW_SEPARATOR= "\n";
+static const char* DEFAULT_COL_SEPARATOR= " \t";
+
+FormatInfo::FormatInfo()
+  : row_separator(DEFAULT_ROW_SEPARATOR),
+  col_separator(DEFAULT_COL_SEPARATOR),
+  file_format(FORMAT_INFO_FORMAT_NORMAL),
+  separator_mode(FORMAT_INFO_SEPARATOR_MODE_GENERAL_ENUM)
+{
+}
+
+void FormatInfo::parseFromTable(drizzled::message::Table *proto)
+{
+  if (!proto)
+    return;
+
+  for (int x= 0; x < proto->engine().options_size(); x++)
+  {
+    const drizzled::message::Engine::Option& option= proto->engine().options(x);
+
+    if (boost::iequals(option.name(), FORMAT_INFO_FILE_PATH))
+      real_file_name= option.state();
+    else if (boost::iequals(option.name(), FORMAT_INFO_ROW_SEPARATOR))
+      row_separator= option.state();
+    else if (boost::iequals(option.name(), FORMAT_INFO_COL_SEPARATOR))
+      col_separator= option.state();
+    else if (boost::iequals(option.name(), FORMAT_INFO_FORMAT))
+      file_format= option.state();
+    else if (boost::iequals(option.name(), FORMAT_INFO_ESCAPE))
+      escape= option.state();
+    else if (boost::iequals(option.name(), FORMAT_INFO_SEPARATOR_MODE))
+    {
+      if (boost::iequals(option.state(), FORMAT_INFO_SEPARATOR_MODE_STRICT))
+        separator_mode= FORMAT_INFO_SEPARATOR_MODE_STRICT_ENUM;
+      else if (boost::iequals(option.state(), FORMAT_INFO_SEPARATOR_MODE_GENERAL))
+        separator_mode= FORMAT_INFO_SEPARATOR_MODE_GENERAL_ENUM;
+      else if (boost::iequals(option.state(), FORMAT_INFO_SEPARATOR_MODE_WEAK))
+        separator_mode= FORMAT_INFO_SEPARATOR_MODE_WEAK_ENUM;
+    }
+  }
+}
+
+bool FormatInfo::isFileGiven() const
+{
+  return !real_file_name.empty();
+}
+
+string FormatInfo::getFileName() const
+{
+  return real_file_name;
+}
+
+bool FormatInfo::isRowSeparator(char ch) const
+{
+  return (row_separator.find(ch) != string::npos);
+}
+
+bool FormatInfo::isColSeparator(char ch) const
+{
+  return (col_separator.find(ch) != string::npos);
+}
+
+string FormatInfo::getRowSeparatorHead() const
+{
+  return row_separator.substr(0, 1);
+}
+
+string FormatInfo::getColSeparatorHead() const
+{
+  return col_separator.substr(0, 1);
+}
+
+string FormatInfo::getColSeparator() const
+{
+  return col_separator;
+}
+
+bool FormatInfo::validateOption(const std::string &key, const std::string &state)
+{
+  cerr << "validateOption: " << key << " , " << state << endl;
+  if (boost::iequals(key, FORMAT_INFO_FILE_PATH) &&
+      ! state.empty())
+    return true;
+  if (boost::iequals(key, FORMAT_INFO_FORMAT) &&
+      ! state.empty())
+    return true;
+  if (boost::iequals(key, FORMAT_INFO_ESCAPE) &&
+      ! state.empty())
+    return true;
+  if ((boost::iequals(key, FORMAT_INFO_ROW_SEPARATOR) ||
+       boost::iequals(key, FORMAT_INFO_COL_SEPARATOR)) &&
+      ! state.empty())
+    return true;
+  if (boost::iequals(key, FORMAT_INFO_SEPARATOR_MODE) &&
+      (boost::iequals(state, FORMAT_INFO_SEPARATOR_MODE_STRICT) ||
+       boost::iequals(state, FORMAT_INFO_SEPARATOR_MODE_GENERAL) ||
+       boost::iequals(state, FORMAT_INFO_SEPARATOR_MODE_WEAK)))
+    return true;
+  return false;
+}
+
+bool FormatInfo::isSeparatorModeGeneral() const
+{
+  return (separator_mode >= FORMAT_INFO_SEPARATOR_MODE_GENERAL_ENUM);
+}
+
+bool FormatInfo::isSeparatorModeWeak() const
+{
+  return (separator_mode >= FORMAT_INFO_SEPARATOR_MODE_WEAK_ENUM);
+}
+
+bool FormatInfo::isTagFormat() const
+{
+  return boost::iequals(file_format, FORMAT_INFO_FORMAT_TAG);
+}
+
+bool FormatInfo::isEscapedChar(char ch) const
+{
+  return (!escape.empty() && escape.find(ch) != string::npos);
+}
+
+char FormatInfo::getEscapedChar(const char ch)
+{
+  char escaped= ch;
+  switch (ch)
+  {
+    case 't':
+      escaped= '\t';
+      break;
+    case 'b':
+      escaped= '\b';
+      break;
+    case 'r':
+      escaped= '\r';
+      break;
+    case 'n':
+      escaped= '\n';
+      break;
+  }
+  return escaped;
+}

=== added file 'plugin/filesystem_engine/formatinfo.h'
--- plugin/filesystem_engine/formatinfo.h	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/formatinfo.h	2010-07-30 13:27:46 +0000
@@ -0,0 +1,51 @@
+/*
+  Copyright (C) 2010 Zimin
+
+  This program is free software; you can redistribute it and/or
+  modify it under the terms of the GNU General Public License
+  as published by the Free Software Foundation; either version 2
+  of the License, or (at your option) any later version.
+
+  This program is distributed in the hope that it will be useful,
+  but WITHOUT ANY WARRANTY; without even the implied warranty of
+  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+  GNU General Public License for more details.
+
+  You should have received a copy of the GNU General Public License
+  along with this program; if not, write to the Free Software
+  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
+*/
+
+#ifndef PLUGIN_FILESYSTEM_ENGINE_FORMATINFO_H
+#define PLUGIN_FILESYSTEM_ENGINE_FORMATINFO_H
+
+#include <drizzled/message/table.pb.h>
+
+class FormatInfo
+{
+public:
+  FormatInfo();
+  void parseFromTable(drizzled::message::Table *proto);
+  bool isFileGiven() const;
+  bool isRowSeparator(char ch) const;
+  bool isColSeparator(char ch) const;
+  bool isEscapedChar(char ch) const;
+  std::string getRowSeparatorHead() const;
+  std::string getColSeparatorHead() const;
+  std::string getColSeparator() const;
+  std::string getFileName() const;
+  bool isSeparatorModeGeneral() const;
+  bool isSeparatorModeWeak() const;
+  bool isTagFormat() const;
+  static bool validateOption(const std::string &key, const std::string &state);
+  static char getEscapedChar(const char ch);
+private:
+  std::string real_file_name;
+  std::string row_separator;
+  std::string col_separator;
+  std::string file_format;
+  std::string escape;
+  int separator_mode;
+};
+
+#endif /* PLUGIN_FILESYSTEM_ENGINE_FORMATINFO_H */

=== added file 'plugin/filesystem_engine/plugin.ini'
--- plugin/filesystem_engine/plugin.ini	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/plugin.ini	2010-07-30 13:27:46 +0000
@@ -0,0 +1,5 @@
+[plugin]
+title=File System Storage Engine
+description=This storage enigne enables you to access raw file in Drizzle.
+headers=filesystem_engine.h transparent_file.h utility.h formatinfo.h filesystemlock.h
+sources=filesystem_engine.cc transparent_file.cc formatinfo.cc filesystemlock.cc

=== added directory 'plugin/filesystem_engine/tests'
=== added directory 'plugin/filesystem_engine/tests/r'
=== added file 'plugin/filesystem_engine/tests/r/basic_create_table.result'
--- plugin/filesystem_engine/tests/r/basic_create_table.result	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/r/basic_create_table.result	2010-07-30 13:27:46 +0000
@@ -0,0 +1,16 @@
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="../filesystem_ln/_FILE_NOT_EXISTED_";
+ERROR HY000: Can't create table 'test.t1' (errno: 2)
+CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="../filesystem_ln/basic_create_table.data",COL_SEPARATOR="";
+ERROR HY000: Unknown table engine option key/pair COL_SEPARATOR = .
+CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="../filesystem_ln/basic_create_table.data",ROW_SEPARATOR="";
+ERROR HY000: Unknown table engine option key/pair ROW_SEPARATOR = .
+CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="../filesystem_ln/basic_create_table.data";
+CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="../filesystem_ln/basic_create_table.data";
+ERROR 42S01: Table 'test.t1' already exists
+SHOW CREATE TABLE t1;
+Table	Create Table
+t1	CREATE TABLE `t1` (
+  `a` int DEFAULT NULL
+) ENGINE=FILESYSTEM FILE='../filesystem_ln/basic_create_table.data'
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/r/basic_delete.result'
--- plugin/filesystem_engine/tests/r/basic_delete.result	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/r/basic_delete.result	2010-07-30 13:27:46 +0000
@@ -0,0 +1,22 @@
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (a INT, b VARCHAR(20)) ENGINE=FILESYSTEM,FILE="../filesystem_ln/basic_delete.data";
+INSERT INTO t1 VALUES (222, "bbb");
+INSERT INTO t1 VALUES (333, "ccc");
+INSERT INTO t1 VALUES (444, "ddd");
+INSERT INTO t1 VALUES (555, "eee");
+INSERT INTO t1 VALUES (666, "fff");
+SELECT * FROM t1;
+a	b
+111	aaa
+222	bbb
+333	ccc
+444	ddd
+555	eee
+666	fff
+DELETE FROM t1 WHERE a>=444;
+DELETE FROM t1 WHERE b="bbb";
+DELETE FROM t1 WHERE a!=111;
+SELECT * FROM t1;
+a	b
+111	aaa
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/r/basic_insert.result'
--- plugin/filesystem_engine/tests/r/basic_insert.result	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/r/basic_insert.result	2010-07-30 13:27:46 +0000
@@ -0,0 +1,21 @@
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (a INT, b VARCHAR(20)) ENGINE=FILESYSTEM,FILE="../filesystem_ln/basic_insert.data";
+INSERT INTO t1 VALUES (222, "bbb");
+INSERT INTO t1 VALUES (333, "ccc");
+INSERT INTO t1 VALUES (444, "ddd");
+INSERT INTO t1 VALUES (555, "eee");
+INSERT INTO t1 VALUES (666, "fff");
+SELECT * FROM t1;
+a	b
+111	aaa
+222	bbb
+333	ccc
+444	ddd
+555	eee
+666	fff
+DELETE FROM t1;
+INSERT INTO t1 VALUES (111, "aaa");
+SELECT * FROM t1;
+a	b
+111	aaa
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/r/basic_select.result'
--- plugin/filesystem_engine/tests/r/basic_select.result	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/r/basic_select.result	2010-07-30 13:27:46 +0000
@@ -0,0 +1,14 @@
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="../filesystem_ln/basic_select.data";
+SELECT * FROM t1;
+a
+999
+888
+777
+666
+555
+444
+333
+222
+111
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/r/basic_update.result'
--- plugin/filesystem_engine/tests/r/basic_update.result	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/r/basic_update.result	2010-07-30 13:27:46 +0000
@@ -0,0 +1,15 @@
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (a INT, b VARCHAR(20)) ENGINE=FILESYSTEM,FILE="../filesystem_ln/basic_update.data";
+INSERT INTO t1 VALUES (222, "bbb");
+INSERT INTO t1 VALUES (333, "ccc");
+INSERT INTO t1 VALUES (444, "ddd");
+UPDATE t1 SET a=999 WHERE a=444;
+UPDATE t1 SET b="zzz" WHERE a=222;
+SELECT * FROM t1;
+a	b
+222	zzz
+999	ddd
+111	aaa
+333	ccc
+DELETE FROM t1 WHERE a!=111;
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/r/multiple_update.result'
--- plugin/filesystem_engine/tests/r/multiple_update.result	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/r/multiple_update.result	2010-07-30 13:27:46 +0000
@@ -0,0 +1,403 @@
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="../filesystem_ln/multiple_update.data";
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+SELECT * FROM t1 ORDER BY a;
+a
+111
+333
+555
+777
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/r/rnd_pos.result'
--- plugin/filesystem_engine/tests/r/rnd_pos.result	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/r/rnd_pos.result	2010-07-30 13:27:46 +0000
@@ -0,0 +1,19 @@
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (
+aufnr VARCHAR(12) NOT NULL DEFAULT '',
+plnfl VARCHAR(6) NOT NULL DEFAULT '',
+vornr VARCHAR(4) NOT NULL DEFAULT '',
+xstatus_vor INT NOT NULL DEFAULT '0'
+) ENGINE=FILESYSTEM,FILE="../filesystem_ln/rnd_pos.data";
+DELETE FROM t1;
+INSERT INTO t1 VALUES ('40004712','000001','0010',9);
+INSERT INTO t1 VALUES ('40004712','000001','0020',0);
+UPDATE t1 SET t1.xstatus_vor = Greatest(t1.xstatus_vor,1) WHERE t1.aufnr =
+"40004712" AND t1.plnfl = "000001" AND t1.vornr > "0010" ORDER BY t1.vornr
+ASC LIMIT 1;
+SELECT * FROM t1;
+aufnr	plnfl	vornr	xstatus_vor
[phone]	0020	1
[phone]	0010	9
+DELETE FROM t1;
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/r/select_big_file.result'
--- plugin/filesystem_engine/tests/r/select_big_file.result	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/r/select_big_file.result	2010-07-30 13:27:46 +0000
@@ -0,0 +1,1005 @@
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (c1 INT, c2 DECIMAL(3, 2), c3 VARCHAR(20)) ENGINE=FILESYSTEM,FILE="../filesystem_ln/select_big_file.data";
+SELECT * FROM t1;
+c1	c2	c3
+192	9.40	jpBjgUdnwLxojNxvoQFX
+618	9.60	LSkNQAZjODwYvOYUeAVb
+847	2.60	yphkuCaGsgbReRQTcUob
+814	3.25	rJDEnFNRTVftDpWPLeRa
+571	4.84	bjQkbVIPlNmlHpKvDBVv
+292	5.60	ikfinRYRKPIjJsjNXtGe
+736	6.34	NxSIHnLbJEndkqmwZFPF
+776	2.97	YhdGuHgspSDfPZfeSHDs
+693	2.51	IRVxHgPmpDZDzVWReFRK
+27	3.27	gtAvpxIwXldqKYADhkna
+592	5.54	CEuIPODTitAOYqEQusEv
+59	4.34	PJSVLGMjcRyqRdffDeMk
+108	4.60	HlopFPmGpvJjdmtSlcmJ
+183	4.57	KqHsxxrIUHTkEVHUmJUa
+799	0.88	iARALomncGlwqWlGDfvu
+34	2.60	qKUfyEozvawQfNySJoqF
+622	3.31	tfdGYDefcGYveIwEgIzU
+35	8.99	oCnDHfJLNVTcysrBRXBY
+765	9.17	aUQUhRRYTMbDqMpLndwe
+77	7.30	emYjkJPwamuIrPPbrzQQ
+608	1.30	GYracqTOoUAsKQyhyrTv
+71	9.92	wgFQfoXxyonAlQJfruiZ
+480	9.89	vzwhdoBgcjgADPxWfRmA
+996	3.74	nQggLzdKdXkFCjWBCPbj
+765	2.74	DPXTTBcNawKyiAgthVVh
+252	7.47	kSeWSMDVpMiWJQRJPcdH
+195	9.49	NgCBvAmiGRYvooUImjPq
+749	1.66	mhChOLdNCIkWwdxkAwYo
+925	5.90	BpfNtOtlZQzVTFCVXryN
+898	8.92	SExwIoHiQyUJumKmnvKg
+62	1.75	qhpdevbKjgqZMrgbKMEc
+419	8.68	zlBKEOoGGNPAQHuRWuAh
+538	1.50	ZgfSjbeWkAPWvQHYwteg
+297	7.20	vTPAUlmqQBOnBkvSitAT
+612	4.30	VzhSsYdmdsAmYmxaCANx
+485	0.26	RQxqgQpyrlLmKtwIyvAC
+984	8.81	RIYiiQQTMuxEPDFrTtwt
+275	9.39	EjyENeSSzHpKzFuFUVwh
+709	1.66	VHVcUOsrTBxBYwZylLSy
+314	3.80	kTajmgdMehDoMHBUpiIo
+261	3.58	HddjywgLGBnGzFSGNClc
+576	8.11	RrqwMWPwzKEEneiaLMJs
+339	3.32	hkzWfriTUKqcjHrgzgzE
+204	8.75	EkKdLmvJaYhbuZSXcvdC
+569	7.10	jOwhQZpHMCOqHxEmMdFM
+563	2.96	aWOcwWfOXnabektPGgKM
+221	6.32	EjczZetUKWHOPFKzedTk
+64	4.40	oLEjGHTKkVHgAzuDZWTi
+990	3.32	uIbcYwWgYrVFJOHcaJNl
+706	9.72	hRFpTOsHmnTaPWWIyNpv
+21	3.95	tseEKNEUwtplsFPxQABr
+256	1.70	uaVrtCMWUGpyndDouJpc
+193	3.70	wulxTHaLUJWHZncPfdyu
+326	6.88	ATIxHVhtJxDzCxKCkJVO
+532	0.88	jGxbPAFdGbIofquyrqEg
+970	4.47	EJsLdVXEaVPSXHqjsfPz
+642	3.96	nRHrrKhutsNspLrLlFPN
+741	0.74	gmPcoeQZQLzvPiFEJQsm
+548	7.10	jPUBesAPDCXOExMUDAsU
+691	2.21	mWujjRogVFQJaClsMeHj
+698	7.29	DypRHqMfdBYLWLPiyhyL
+748	9.81	TabdxNOFnMZGsyxSLvmV
+888	0.35	xWvAwZWBZnMQWUsySaHg
+328	1.60	JxVdEHzpSVCEEyuDRmPf
+781	8.15	zhdERXUSBYSqsSXiRjJs
+418	4.33	ymBkxrlFulEGWsHCgfFz
+605	7.64	uHgZctYWEUcwLmnKottg
+568	1.97	mMNkVHoXdCxgRgNaLkTO
+391	0.71	uclHEKTLUXLBLADIgSpy
+322	7.40	ehHcEKwmkBzunaKHRlBK
+735	2.72	vBQxKqICfEOcRBnOLPRr
+977	5.85	vxWkZBLAIOMZFBQWBPRz
+655	1.38	ixdZfjUlvvYrrPHmtcbb
+793	1.55	DLcvRJKRjKaFMMCpbLVR
+42	7.76	EdQOUwzQItBPmvvctVZx
+403	5.63	aAEmSBQirVlkRZKGuPZo
+694	6.25	dNNzAvBWUZubaMjhawVk
+96	7.60	WvCodyAPgaureBHuNSOI
+655	7.34	LIQWyyTFoKsgBVIlMOip
+749	3.26	otEImKHWdviBWMHnKnAy
+392	5.70	eKTgSPSaFHlBJWhUsYcQ
+229	3.51	RSCUAZXTpnksXIIyMNqn
+60	3.32	heoxppRRMqVjnwLTIkzM
+59	4.66	shFimshNjoBhtiyXHkeu
+685	4.61	WpjzucNyNnbsYMcOHjbl
+906	1.61	AMMYTKlHMcxrxEWzcEgl
+452	1.17	hvIYeVQxRVjLGcMIIPlq
+776	5.96	kbrrFqzVHBhfCeGRAidR
+171	5.30	XIwmcpjETarpXQfWeCsf
+889	5.18	OARTITueckClWEhGnFfG
+209	6.95	yuAVMcZLBZOZnuqDJXtq
+228	1.15	wzkFOcmpmkGvKfrfrMqJ
+348	1.58	CMkNbteFRyBnKcZElcZT
+482	1.60	XBbtwyZJSINdDKJPFBLh
+549	6.25	POTjzYGerRZoSBXawlMW
+482	0.38	cEseEtPoLnbEGCvmLSKC
+311	9.99	DXzdcEyOaoQdemrFiWkb
+978	8.49	gZjBebGdmOjoeJsgQAYx
+675	8.76	XRaCqXGtiKmmTccyHFpV
+343	4.98	THxNBaZxylAvUxgUiVfb
+595	8.46	ohLRcfIjnWVYOrgWProB
+237	5.11	HTYrsiAjtvhWzIJdLMSs
+197	0.66	zqTBbbgaOZcjpNRcNipQ
+504	7.50	aWkDGoCMpwTMccGwiSia
+540	7.30	jwouGMVrewbgUiQMCtKH
+882	7.16	xxOjEZwHEUNmrrQpdwhl
+853	3.92	QdOAVhabDkUuaQBLXDoE
+433	7.72	dZtxCYRmZcGgdbKvagop
+643	0.19	jIjfjbYdFXEWlXZlnlWs
+757	2.30	IikDjuRNvdLPttddkKjO
+800	9.95	HnzCoSOyDuEsvfyckmHS
+428	9.78	kTTmhNmpFkjVluKWHvtx
+189	7.70	DBeQVZMalbmhVEsgYsbq
+30	1.22	aKCRJXmPebvzUaQHIBHP
+776	7.43	SrwJlmQaJTnSyRbmAWHO
+603	5.23	QDUPvENiqcHWRmTfxaDe
+26	1.24	UolXjCmCIQiSllznooXy
+221	2.66	GnFWlqKKyuCdWYXkbCqt
+108	4.20	pAnYwmpkSwOZRgwiYVWL
+175	6.51	opEldPFkpCDsVSKRcZaW
+324	2.71	stiTcwAYdZxbxZILylHo
+280	5.37	ZYtykbYUBCLALVJFkirF
+798	2.47	xYgSFtzerVqucvqIvEGr
+897	3.17	gGEkYIvCrpIiQTzkJxxV
+62	1.25	gGOidOOuWHbezVnTEWIq
+620	3.00	yYdLZxIbTLUnJgQxDUmG
+502	3.24	gjUyXarzITiqkNUPePvL
+70	5.40	NPnxdxhkOfnKjzpJNsiU
+204	9.11	KrJvPSsEdFSqLiXuxQiA
+456	7.34	OXbMZUKsUSAZbOVPQIBn
+975	7.89	kCwlsRqUGAytpCAGcxwN
+929	3.66	NunymCZUGzUBfhmtWeNR
+991	7.49	XPVKOhSsRghDcjftqkyS
+437	0.51	UAXgfvYvZVyDffmqhBIS
+440	9.25	sXzGZDTZgJAAWgqUAQTf
+940	8.25	uKjfbnoyNyXCZvsERros
+449	0.54	DcaJRKbcNwRwJLxKLhZf
+673	1.64	AUnDLAhoyAhmYZnIRbhw
+926	3.25	PWzbZhFqMyeCMWrLvVZv
+807	5.77	NvfsIyaqQAkvzttOVkMv
+485	7.85	YOglmchMYUvpPVLrfbSJ
+48	6.88	bvTBWQvQKSDIeZOCWCFO
+175	7.96	xmAknBEqJuviUaNxpljS
+633	1.90	DvflcynsTEHwPBwOFKBN
+92	6.50	ebZCXpoUWoVynKwUFIZn
+498	2.13	dWSNUAKKzNRSmBIACmBE
+151	0.34	wGiOfpmvKhvFPZxEADbR
+548	0.12	HMEBWQahnDjYRbcsiBWU
+711	3.16	cVbbfaLumCYjanAKrohP
+746	3.48	dZlqLnbCyPYlFyBctmdk
+597	4.24	BNLzfOVkAgXHMpjcqIFq
+399	0.36	qfprAaaoVnGgdczINYFm
+546	9.43	iTGNNVCPUrwkYbbadyKW
+594	9.62	YkiepbdHTqBOGMaVutQh
+371	7.81	MYLwxhHhjfVqSrozPlvR
+309	3.56	NRMiGLKDjAYmMIiwzJhM
+297	8.98	KEZjoQOGBHyZptWvcShi
+119	4.75	vIlqzrkTNdmwHVyxLzCG
+791	9.86	cBCiAmKLMiJyWzfyOrQb
+499	4.54	yuIpPSIGjBKmmpjgtsAS
+601	6.95	qvikjiMrezxQIQnZYKqx
+171	6.61	IrNSAEhVPmGuopQhsiGe
+137	7.68	RbEbHNMcCFyHHtgxbwru
+470	1.58	DJzSuYlqXdvjJMPGwvAD
+981	1.36	YXthDiWzZKmTFaVHXIvM
+449	6.95	NBzYrdifSJvroerfjCrx
+816	7.46	bGqzWGlbYVCsmBQnqeFn
+892	1.57	lKPDCgUjWXGrXoTmqofn
+796	0.38	hhnhhuUcZYFSXodkYozq
+849	9.65	pQkmTlynZGroEMhQqeFV
+978	8.22	tSRSfFdnvYJzIUCXvffS
+817	1.30	ivnVtbbzIWzRdHWrrFNS
+92	4.87	nLVXqazvXeIuRYKpgEVw
+543	7.65	ytoZORdbOanKCaJnEoWx
+3	5.96	YHGQRnNBeHPFqScDQIXb
+644	7.62	auOOpsagsSMpXIxvNcuT
+177	6.19	kKckdAjWPaeNfbFeylcA
+253	6.34	xBuVMpdAWoJLXHohZQaj
+54	2.55	ckBdUuXMWvOmUMnjtQnY
+240	9.70	QxRyBbBeFehndsCGDzQg
+313	5.29	gfQIQiJDpJxbASsPeaYn
+735	1.67	olIKdcfamVrSuTFQFMIc
+103	8.69	zvQtXyFOIMryLyDXUehS
+295	6.40	nyEPnztubhxQBSMOqvfF
+502	7.19	qAEFhiNyVNNQaUYRNUEg
+513	7.34	wwAXuDbQBjFVZjsbZqNK
+848	0.57	xguKpJPjMiZMTsymbcPo
+751	5.94	jTiBWgYHnXNkzmlXmHuq
+836	9.58	CnPTfaxPvUCCdRMymioa
+455	2.69	pejDtFBUxPIxKKhMJUWs
+861	0.22	rnWsdSZXNAuPccpGfjNU
+26	7.61	ZzRzeEKyIOVTkWCYSYZF
+54	0.65	gtXbYWuFVKvZjnCrJUAB
+779	2.75	guVKPZxSmxGYMXfypSFK
+159	3.93	AKpUxqRGiThzoxQQRROp
+917	6.87	IGnKppqKLyvMleSpohGY
+316	0.00	FMzIEKNXGeWgHmytBqwk
+428	1.45	WnBnkAegeZkxeqCwmUJj
+290	5.50	nWuIHEhhpvGEQqXIFyLO
+948	9.94	UivnZfMKAibZsjCRCXiW
+590	1.20	FvVXEdLxGPhErzVOXwWO
+303	0.35	syxsPFTZcZfqsxSQuHOK
+931	7.46	AXzLovMIsDZVnFSoLnzf
+737	6.62	YfnLlPXRMQxAyZCUaJPP
+259	3.96	dxPNIzgfZOKZFFdzLQJj
+544	4.27	JjpUuBRXnPbNrMLaFoAU
+807	6.64	hFSLCBZZmDoOzFjQnOMa
+437	9.21	slnNrajpGjHmrPEDjyLv
+487	3.44	zgBROXScbWoDFYwDrZZq
+649	1.22	MyVRplRDvwckcEtcnSwL
+755	5.11	KUQyMRwRuXVsnuxApTBB
+751	6.26	MVbpeNaiKKOWYzsApugb
+871	9.90	RHqbdbSECFpzqKBBQXDY
+706	9.40	QMuhdWuocukxUQvtLeHA
+941	7.35	bffBwXuTwyizVNyVlNAP
+178	5.53	AGhDovrxSzyBBTylixsz
+667	9.52	dIodUNdnPEOaluUaaqQq
+127	0.79	nNrfQxaHaJeXunrbldTW
+451	9.25	ujihJXZfnOueOdvPXSJO
+620	5.83	cooShIhtOkOBrKudjGaR
+240	8.31	oecWoiuhzPzuwOgXeyQG
+38	0.67	jrvinjtyLPPcfnvttKKW
+271	3.74	DbOuyotNTMTEexjZdMHE
+313	1.73	teXwnvclJHkCiAhJhLlu
+321	1.54	cRUfRNHbDdoVhZoqdIOj
+621	6.16	YiNFPRBJVUgsnzLRuloF
+369	1.43	slqjryaHUVDJhgwJASXl
+945	2.70	sLcNjEjGvzWDmWBLiaLh
+354	7.41	fudoFUiNtacDMhXApenm
+189	5.62	xSZfGwrdPjmoQRhmYDcX
+234	6.20	qMkPxrvYITMBVEYhznpF
+749	2.32	AVoZwcBZMLgLWiOHTflR
+866	0.61	nKZVmVoOMhxAFntgqFkT
+785	3.48	MPDRmXTvUXuqqjESKtSN
+608	9.92	ZzRTvbcwyQfIwuMzBXfs
+807	2.25	fUjmfEGNWHIQGrPaXEye
+720	1.56	NVAaIhYeHhneuljfohyp
+683	3.12	UVKsAEIpVJmTfhURNwgW
+659	5.41	GYkNtAnHDwqmxwffTDoe
+656	6.69	wjLBrxtwmuRaJtMMoldU
+900	5.13	ScAgZTpdXBxbeeJwGXDN
+489	7.96	IbNiaXivMkITJhoTTWPk
+437	0.20	vtXWIRaTgkFBnBfPLGFu
+535	2.22	NakPyqNTyeqRLRvNbmed
+761	6.20	sBwOoEdEGlNoMUqdlKtb
+780	5.62	OublVKVZwhTLAoXxPnXX
+529	3.73	LCmyRbilZVyeBNEoSNyw
+502	6.70	RYvkcCNTBvoUrpZBRDPA
+487	0.78	qnVDgcFTuKhBrngvWFYF
+579	4.53	kRHWQhoFFBhNVlPBjxXH
+797	1.55	ZuwmgmLGVdvarBRaprWV
+861	4.78	FMhjmagLzxhTmZrnbibL
+652	2.32	InRhNqlnTiHTcrVmBMwE
+870	1.41	lFhMOGAaleKyYUToNejF
+246	6.30	LstfbtAFDQCWSdIEOuiL
+742	4.72	RZmyfVBggxHDeuskAIeO
+888	6.66	CJWAxISMCUKavFGIRyIi
+377	1.96	xVqkyBNLYUkMYdwpAgEB
+347	0.16	MiOXVOagqkLSTzYIeSra
+873	9.93	QwyZZFOkUHXlvqmajTuU
+866	0.45	QfynYftmOdOhNYZABCfo
+720	0.70	XjNbriAhLUwcRijUzwZa
+21	8.90	cEFeZfJHGEEYHGDGDDzt
+842	5.53	NQrkWAnXfNjmcPapfnBZ
+395	8.26	WoObGTrswUXVocMpWzam
+805	7.34	wkCPGHHoroEkDDGXzcuo
+945	2.29	xgJvJcfIQmKDuaZpzqIY
+715	5.65	xzzVjlborTJLevAptgeT
+714	7.96	FxxJYhazQxFvKSlXXfLO
+625	8.31	yutfvCmOfLowqxqjuMUK
+573	9.29	EEUtQpLEUcJMBiYBGsXx
+363	8.80	ToacrTKslmPSEuRQCJwv
+889	2.66	yklInCiTlxnHMHlEXDQl
+628	5.17	UTEagZGvGZfHOlDuXUKH
+643	3.23	jcCJJeRumgaDFqcosgLJ
+646	5.12	vVnIjqpMfSHLitIsfqMg
+886	0.38	stfEWcbuWNitgLtTtigQ
+363	5.93	OCMMpnvtEjbFuLgAEtkU
+236	2.89	txucVxohWxrnUUDEMZwk
+70	9.75	DXNLUUtrYxmkReokvALc
+572	5.71	XeVYLrueWGiQGebWUwkW
+434	2.10	xMTykKCEZnUmYNNOgSih
+444	0.47	axDOmwdUffipyarAtIJu
+454	8.23	lYuKfhOKtkPcDyaZdbmw
+740	9.54	kUFtOgiBRUPnhLwwrgUW
+209	2.41	JTgAfdoVfSFjTGutjAvH
+899	3.19	eTGGqVkoDcqtTnkahxHj
+829	3.80	OvkAywzARPbfqTPHMEXz
+685	3.22	lmFitDYHTZambPCWjllF
+578	7.21	MMpgfEfCkQHJtagEhoUx
+220	3.80	JEHCPrJeyxXLhdtXGWcu
+947	6.28	dTtJKhgwcBnipuWYxYEv
+54	8.83	CHsmJurywDSXAsymAqOw
+12	8.38	XISWvYQVeZocSmIrQNyj
+577	0.34	SSjCteOgDkQPwJofWEEU
+771	3.37	LSgNuOQFoetwCcCDtIxk
+656	2.14	adRsvhoZHvTfLTyLqvRF
+896	7.34	CyXBvEQSXNPNejYrjWOg
+980	0.14	VClbFxOwvvhMxJiSoHgv
+454	8.82	UGbZCbTYmxYfaNRvxmiZ
+892	1.56	WQdRYorTGjnXFWlvrxgX
+649	8.77	BuREkjbviHzhtVvaMswT
+299	2.92	WMbmvpVWVrbMQNvnVuYb
+866	5.15	ttVBDkjMAMBdCgbkTMTp
+771	7.37	bWSUWyErakTnbDULvkRJ
+748	8.59	LiodrknBJVVqOYTslJRE
+337	1.88	GbplVMxejUlPfbxiMhmj
+532	8.10	yeraTbSrtHHbyHnLnjvJ
+860	1.35	qfXroMPpihOyFNlbjdRa
+746	5.88	xwarOKMtEUqPGIDuWVbW
+572	2.34	ysIFbYbpyVngDNdscNzE
+693	5.56	sgWzpVDsrPedZaiuBvan
+736	8.30	JAGQGSmeBgmMrRxLLzJi
+411	6.69	eUMQMFlztnCXJnMhkXXV
+605	8.43	mDmgFeyVznUDAlSEFmzX
+882	0.77	gUJmprHdPOvzvQNKNDdV
+136	0.35	vyoNduORlklNvHjZtoCv
+763	9.96	RaJzaXnEfOYnReWFoyIY
+361	4.29	klsePKOxmWGBTXZaDtPi
+281	4.27	LqhRhVMFCxzmbvcNtOrq
+460	4.46	sSSwfpHvdoVutckHazUt
+621	0.40	AJfWbYHkYustCMIsEvFw
+44	1.49	ymzIqzGZPxTUiiAotMhC
+532	8.40	DiZFMlbWozhtkbnBpsMe
+974	6.36	BqPaSfOGYlmrWSDuzOVz
+257	2.98	vUprKOpULQnKAulAZpGb
+290	8.88	kXjaEAVNSfrjqyXuNhtF
+478	4.48	kweRAIdsBQtzcYjPpRXl
+432	8.19	ASvAPuQuqRIZDmvTJRBd
+12	1.74	WWIGjzlRZxbeZRmhdnhi
+944	5.85	mdUlAggcHyZWubrvhJwR
+724	5.29	ryHSuZWpITFwcyKWPoDa
+813	6.86	NhLEYhuQTTCVMKBNyEED
+568	8.99	FZiCwFYLNaMyrFxhqZJd
+560	8.64	eZOVPGpmTmfmMrdUCcLD
+279	7.74	ZfclbaBlhQmVvtPYOzWW
+151	2.48	dyBMcKxXNQkYNsmuSJtV
+281	1.45	FNQFBFHaMuooWYmgdSkw
+945	6.30	DZzoAHcKvhNrDendccIk
+209	2.52	nnBfHEVwRbVHQcMZWUjG
+770	5.97	GtdxrRhaMZKOHSepPwsv
+163	8.89	QyvjtJrpZpUjNUvrJeXB
+325	7.43	PfKbnXWnNDidiZWNpWft
+554	1.98	nRDXTUeiHSTwEjdZfMxn
+372	3.16	FttOhHsHiZgZJLqfVdBN
+931	0.83	fFCQoWnDdpeZlwbuwwWV
+382	9.70	mXsRKrHNpGMwoZRhJTuI
+696	0.70	OVFQBbDOjwmcGPvdRIqX
+810	3.15	KMiKawUCvImQAFLHVGYR
+23	4.53	UAqVGWUfVuoMZjVeknNY
+406	1.74	WNRrxNYESOaonJgVqBgc
+343	8.34	omnvEWQmSVklsJJpSqYw
+966	5.48	AZzbEwxGVItDLBMoLHfE
+448	4.23	BGBsISXvvxYCfNEzBYbG
+495	7.68	nzvLWgwuUYrskJiTarex
+338	9.50	HYrPfBaIEURguPWLwpGW
+562	5.77	OwDDTnSgGEGanAAFpIuk
+178	8.55	hgXeTKuJkPwUItJeaHuR
+234	2.53	SvVBGkFxRXqzXZQtPeFk
+566	7.91	UgtIXlzbAcDRyTuHYGyl
+165	5.13	RIRuMPSDAgODegLuHYtM
+473	0.59	VNahlMhbyNTpjbVspVuU
+918	4.68	PnKFhrrZFjBkIXpqAtyR
+126	1.60	JBcuGkhFlkIFUgIkjAvB
+4	5.90	AMnTFilyyQiOLxBvkZGA
+975	6.72	MzkWUUWzdLDtwISzNgpX
+430	7.59	FLYVcOWRCbIBztawYsSW
+86	6.71	JtEXDfmDuQFtPBOHgPNE
+224	2.70	EJowYiFEYrKVvAwSEpVG
+950	8.60	ZkRxwBNwbqVeXodSLrJb
+348	7.65	lFqwuSEruKeNzLGzWalK
+837	4.57	nlDzGGHykYZcqwTFnomR
+746	7.66	rDVPgehFbohxROiTjaGy
+603	9.53	oOdIjEKxmvfBjFuguiMZ
+591	6.11	YOWpmqtuRQoFLnLhyasJ
+73	2.77	pVJVLkRnwksBrTvALmrH
+339	7.10	GTOdZJxVlKKHEtBnoGrQ
+698	2.42	twClrIepXprGksUrGTbj
+821	8.92	LWAgApBUUiuszjRZbLcb
+227	9.11	JdDbFLSDUsBauYAciSrD
+255	9.56	pDjgONKekgxqTgdzTFcH
+794	4.66	iKLpSuRcGZuCfRHWBoDR
+235	3.36	lMFtQpAHvaqPSWcZpoas
+769	8.99	YdiTJnKaswltGNLuxvDQ
+430	0.73	arcmAZXkpyeotDfRyYPA
+788	9.17	okKxOdygEqXUeqsGcwRe
+563	0.93	nDnKCzxXjgVPctzeQOKg
+3	4.75	FzlYLMdjQTyTXLWKKNCB
+483	3.20	YixdiktWavAqoojjEtWf
+444	7.33	dBAJxPrDKUSGLgxAfVQv
+869	4.40	HltYNXLlSwXiwVpgBmDz
+725	9.63	ezuFHPAzKPfSKgYOBPFZ
+164	4.70	mWppbTXlNcvIAULGoktj
+200	1.51	GtTkJwsgvCnCuzqChotT
+942	3.36	NrdCmmzcntFdodBhfzsH
+736	0.20	URmRulmBtZYvTMvAwLBm
+0	6.90	wCpVrSqORejfCTisIlxk
+701	9.62	WjwEVffstqMHgMvAXiWe
+834	0.44	tmogwQMMcOBywnIQamVd
+819	9.50	ujtmbAoyYWcxaKBtsWIr
+957	2.43	yuNsZDnTUvYBsbnjKEai
+807	4.23	TdnQqmeRbziOXCKftSEH
+521	5.90	ElpNMUTDRUlyzTjcbstl
+314	8.14	pPsTWQuRUENWAWycvMos
+217	7.62	uYTHPCMyHacNbGIJdjlD
+626	7.86	KVvLVNeNllXwUkmQeIaV
+490	1.41	GLQixhqPsUIKwLQSLTBy
+838	8.25	lVUNCiPtoyRpFwJyrmyP
+607	9.20	FatUNtpyajGldFMawXEa
+162	2.36	unqFMicqtBhMNpoZoqQq
+310	1.49	CcJFouEtrrblvSeFCLkm
+10	5.22	aTuLxAJSrVZRqJkNZHry
+127	7.73	rzJYhFwSafZwVSXWBdLG
+750	8.40	VKcXOyaqczUEOqgTwxrf
+307	5.18	KNvOTEPzEjNCgASnslnP
+452	9.16	ubOLrsUNayFtfJzwSNae
+788	5.20	urcAAWBFuQVZqzzaAhwz
+86	2.42	WfXeFiKDcPblptymlSjM
+657	9.49	tTTGfzqPTLLoPvTksCAd
+362	3.98	IAEVbnwGSPOmyvJIlmTL
+129	9.34	XRmXHyjGvUjRyZuvsZDf
+787	9.60	GRcxDMxOiDkylniIDXiy
+919	0.23	XJDLPHpwZxjzmcXsKRUe
+624	5.54	abCXNSNiRDqhyJJqcCyQ
+67	2.33	cTDSPwJrthShnetFjxti
+838	2.89	SuqGHYfiuKNCggiRRqSh
+373	9.61	HFPFxDOHUvtAvJfvfMay
+559	1.85	JblTgGdfwEzNVIHBbdzy
+983	6.61	apUPvuSZDqrmzHQjrtzl
+850	8.30	GwOZbyHoxejRduSlSpiT
+955	3.90	aoQwDfqIblLIVwSqTGDN
+419	5.50	yXsNboLdXkWWfmhqDKIA
+881	4.18	FbagsovifdcFUqrkILOA
+97	5.25	FZyiaHPwrezjYNAArPfy
+161	0.11	zPoinwsgdRxXAyuVdDNJ
+241	7.84	LOLLKqdqpzfyWcdLXHKT
+824	0.24	doaLLQoyfHFQsTZqxyBx
+217	4.95	XXgktdeMhFEyeJwOebKQ
+150	6.39	JJmsIVQXoWpgfYjCxSaa
+508	1.75	GuwcWaoNaEZkQmTTAxeN
+108	2.34	IhNbBDnVirbjzMXzRevl
+595	7.66	SsUgYEgGeoyeplTRwzCo
+770	6.80	UfqwSLLnBKFaXlLKKrxT
+233	9.72	UnZMYddFVcZPPeXAImUS
+702	5.33	flGTAxeTnCqadOQtSnrW
+321	3.46	FdeSJuoilQFEnvPEeUTK
+414	5.32	ZdcWNHVDeChZApGIwZVj
+286	0.13	IsBLSOqofXnTkmdlYAje
+12	1.14	GWBGjxElgTtdyymPrYqL
+762	4.79	zKDtccjjTIefbRwTeojR
+640	2.33	bCtakLuWwVeywsKqrLdP
+872	0.61	TPznbeuhfEdJISxzOjjN
+736	0.72	huQFpeDjvjzdKYjPrCbO
+340	9.90	sXEvHgUlIxtFtIklyEUl
+730	5.89	clEIgBdirtYkgXsuryAH
+411	6.86	uBRGAuqkEBLQGWsDiUKl
+917	3.65	zZknJIJdXSlUCORrncWV
+190	6.28	yYSFfGMqzOuOokGoHvHu
+39	6.58	JCjrrHoXgELebNLFjOcS
+454	5.89	YpacUspejlbNMtmUbOpv
+749	7.80	EKJFAjLpGKeNbGtwsNil
+640	4.50	oBZwZUdLHdzbrGEcvxyI
+430	2.00	NTgyKmzIGwJfLXBWkRQt
+505	7.89	fGMbDIHOiZdxUVNISXXw
+880	2.19	ljKmhqeIjzljvsvemwZL
+430	5.46	RyoGyMzLxknNVczgnAot
+80	6.97	WWJrEgNboEpLkhuYHzvo
+729	2.35	oKFMPUHsXnpPWrWGAFfz
+644	0.79	ADmynCvscyBJsXmOCgoB
+20	0.93	LjrarLhooIjmHBrCWsbS
+749	2.32	QcWpVgStgSaohrEVMKUR
+904	4.23	vEptXOoXtCLyniMOtAYC
+397	9.42	FIiisBxhBecdrqtfjJSW
+115	8.47	ZiBMZVuaqFqhCtgoWuVF
+160	8.86	bYffCeoGSiiCNuTMagYg
+311	1.70	QtTIiQVFwrXBxYOFxTyE
+944	1.88	TEurBDMzyTJrDGCAzWBU
+782	6.70	bPPKaOQSwvtNKPETlBmo
+15	0.29	qgapCHoTDCoeoDkNuZbw
+770	1.85	qoRhigPWcPpYFqIJfzCH
+853	4.29	FouHQmvyPoXebZDtiByS
+739	5.23	lIscLaypkgzMmefRjgNH
+666	7.40	sAoneIUBaIXmCbdwomrP
+532	8.47	XlbTgxmdnBwwLFuSxCik
+603	7.76	gQooOPqPyORAlENfABgD
+74	8.50	UZhRAZpWgrvTOSvUpiFA
+174	8.17	lBJQcLsPjBPhwePTNBel
+151	6.46	AqAFTgnrVSZlatBNOYfh
+862	8.84	KxySyhemIiOwmAkDfWkp
+926	7.94	UIxlLySbnGwxGvUYdhdP
+786	3.16	JZDAyjGEjJcxlCnxxzzn
+229	7.60	zoYamVISryvfqUDFfets
+160	7.10	VmcKltBNFmsMKoXyCzCi
+39	4.53	PfKbQxoANxKZtBkeMHOq
+616	8.23	ogxAmPaHduqwtxTvLrjk
+511	6.63	klLlFnJIdDpvtHeeSdHW
+171	8.96	YdgLViqAdvzywmyBSiMm
+871	9.65	TExnBkPUoWKGfzZDpoyi
+113	3.14	OtgZXsfcBvLCdzMxBYst
+396	1.14	UmBYWTMYrAhprBqPAqAF
+977	9.77	gLPxyWjqzcJGhGODLFse
+919	1.10	twRSubVFtafDSEVnYrVt
+662	7.33	OeGjbkibAqrccNifLmrx
+754	6.44	TaUkvWHmNczbpEEwffUM
+722	7.40	eZdyfkMYvkGpHyvfwlUh
+460	5.90	iZhEJwWAZQnqSBYqiICd
+496	4.87	kwbzPhmKesfqoDjkjfBC
+181	2.50	jqILbPIsfiEPCMtAtfiq
+897	7.13	SlAqOFhFQXfQblbPzbrM
+348	4.81	hDQlBgznFGAcQVeCaFtd
+187	7.43	EYMObWOrWRDKgRNMsSzo
+934	5.43	rYwDFXPEdEqJOwDxxTjX
+181	5.37	ECwQivqQCZVrRtvqCAKV
+769	8.80	nIbSAyDSZteIKkfukVZl
+919	4.76	rvmAqHUPJvKnrpxmAPMj
+705	9.20	vBilNKhDnCkAcDXhCLDH
+447	6.53	xahXLjLkXvnplveQdgbP
+332	8.46	wdwZYxZtewyydyLnRyik
+512	3.65	OPPVCcCgOXtQDXVeWVTU
+973	2.51	zrvAepVJkFxAAXlsgNml
+316	9.48	ucywvQCUpuoKaAoIMpWx
+980	4.36	HySwAocfdnHmbLpvGIRj
+266	5.85	TeQhygiPHCPGrsyqaQnH
+685	2.46	gWWavAEzAOaWquajoWKT
+820	3.38	EUtmZqDBMGjGUXnWeBMA
+300	6.57	UbAkWmCyEYqTSTLLVrTM
+503	8.23	cQRgeVNqxhammMuGfggI
+923	9.27	ZNbFicrbGJdPtfzencEA
+804	9.84	dZpWhBdTnFwcZDSkveSO
+386	8.23	kbQuVoFbDQEIBGecNejk
+53	0.83	ntAZekjoyZSqwnWPzthC
+819	2.74	TASFSozJXEFyRkquhrrj
+563	8.68	OfDoFXKcZtHtKjhnzCyP
+489	5.30	lwNuDiWhTNKYnXKcuDLR
+702	0.74	vbSuZeATRsTuGXIupEyU
+80	7.62	ydaNjWFvVRZRgIrsORIJ
+901	8.22	jOqKRBjSdXOmpobcDjWl
+169	3.10	IYjwnptZZSjoPhUSUyVF
+331	4.25	RSObaoHCDcdNnWYEJVGc
+75	1.63	TvgvGbheutcwdUBmzcam
+574	7.71	RUfWWmrCRIaxCivQEzzg
+513	6.44	EiDrvBLShPrLnwyPoyrb
+160	6.79	RglYVbXSqKCrvVpkFKHh
+351	6.89	CwwwSvlzlvMgXfYaDGau
+512	8.94	eCkWDrCOelfpcueTQWMr
+692	3.55	EFhmVNZtGEOmmhgQNYgI
+488	7.51	xGvKtSSUPuJaeigKpzvr
+338	9.92	VaCHRkSPzojoiApMDYef
+826	7.59	jeyncSDvPHCSbHaPgaur
+367	3.76	XexiyFcTilYHgdJwEvab
+16	5.91	DTyxoowjIiXQgEMpLDhh
+298	4.77	nNdsGAuXzGeFXlRdzfSV
+931	0.41	oNRWNSAATghjFvQERFfD
+694	8.77	LEWMAidjZMhzCkzkEEpN
+6	2.74	lkeKVOFnZKuzKMFigAgg
+454	6.11	BLrUMfsOwJddHxGYtKoT
+477	2.99	BqqfjApFWBCNNMJlIifv
+267	4.10	uxxRmaiwESVjKCctPBvJ
+295	6.57	iCketfXTFRQBFPFfdbOX
+75	0.95	lOpdYXlNpNgdmMXQCGDN
+412	6.19	HcrSAAgWBnZLJeshnKcV
+579	6.79	sjVJwgNuNUDfkVFyrpSm
+386	5.66	upxIpdrfyjCtwCfXrqJy
+47	6.00	aPPWeJCJUIXtpKnmeqKf
+210	6.53	ERoRPgpUERSygdnrEOHs
+885	1.94	tlcNciWFDLllMpIsyuKn
+673	7.77	qLAUxdDaWobWjvYicMvs
+48	6.50	qnYGfEnNpDGsOLNvHrwU
+472	8.12	vCuXhwRzInctwjnRnfTU
+154	4.83	WmduMrHPMUueVLIxzLxT
+784	8.39	MYMhNkmYCXykAOpFyEFt
+73	3.29	WdvCQNsFYhylbDoKQZni
+992	6.46	FHUQMIWGcgMdbWfJqdAL
+437	2.43	GvcquKiBgNVMeLyywtlE
+487	0.77	cRPvIzDsXqZoPohdlIzN
+354	4.44	aFjWeTulcAiCsdwZnQjI
+64	6.29	tiekZPtZugCJnyxyRpNl
+536	0.57	AfcyCWoZVTuzrtAgdxXh
+609	7.86	sdXQFHXFGfkFkgfXxXOg
+295	7.15	mnofxohdUqozGmBnrbbd
+207	8.40	uFsscAmoswwURsTtLkuM
+357	2.98	WVpOIEdZqaRPlnejIYSX
+532	0.52	QPsHmLcufykATBwljQDG
+143	5.20	xlvUXrBxAXjoUDoDQztI
+225	9.57	XRBJUxoDzSQzUJVCASHF
+681	1.41	NkxBrKHtmLChJKjxseaH
+840	8.29	abxkARdGIMiQYBtCXseY
+468	4.56	EDEADRvbXJynTSOOXzOl
+568	4.14	ymvWEObBwkPqeYydDTCm
+755	4.46	uZYxNpPHciRCUeVneiTA
+71	4.50	RFaaMcAElRINKgYHgxNx
+843	9.18	NVYzQLfutveUNBzQunHp
+711	9.65	YyjrXkawAYSkYBUeAixA
+718	5.46	GvADhdPByAJActNNZGyJ
+647	0.69	VFjyLHWobDXVabQSEVZi
+0	1.55	VCGISunAnpxINgKqeNUg
+227	6.24	ZZlhmwmbQfweHnPChDkm
+430	5.14	vDZeUhlsyUtCVjockEeL
+852	4.59	rIOJLoHsarmdyxjoAzud
+49	2.30	MndlmeetVfnqIHpXtiab
+587	0.42	kbZCxqiIShmfatrYBgUH
+509	4.72	aIxjRHDITEwXHscDFXfZ
+545	8.92	gpkRZjSEygzWRvPBrMfB
+366	7.57	kpdxbBuMBLEFgTtsmwGZ
+134	5.37	vNfcwTTwpLFMOFjUmeJA
+258	0.74	RDLDYZpgVevDyKugoBJy
+64	1.55	jGvvzOTgUiDsKgjgvwhr
+325	1.54	OfmXRoBAajlYUDKHPnMD
+527	0.76	kiWWchRlmzhFqtJDxQin
+106	7.74	SvJvpoNRylNrTUBNcmtH
+705	6.77	ajSvfwpJXdiqtEBXzZiP
+551	3.54	DKfAfKZmiacZVkljJoYg
+897	8.36	fUfcunfweNXmdfMLzHpF
+261	9.22	BskeJbnXXSxQFUnPoGpO
+720	4.19	yriRxVSSBrHnZhFqctJq
+367	8.37	bIzpQFvBVfSdNcbksXlw
+922	5.41	KZhPxWAJhMSYPSfNeHbF
+612	3.84	qJNgIzklSoKaWceUWvvL
+7	2.79	PlbVQComhFXxTWGsYUUE
+799	1.10	jiAgQwCoXsgiQmukYzRp
+336	2.34	WcVUtAREjfpKxYwjpfFX
+219	4.91	EzQLsudoINcHrzDUjouc
+236	4.76	IuzIkcLKSedivWijHnRP
+392	9.38	TGsTUbNLaufnnHOVmQvQ
+371	6.52	oipxGWnTdpOabCTkWLUm
+788	7.33	stkTdrbdOcZLLiftXjMv
+230	4.98	kzrYdCpZxhyaiIRFSRsd
+183	9.15	SrmkkApzWrZxOTGuszoK
+964	4.34	WXQfamXYCutjEmTuEbho
+891	6.89	NQCFqHIDzyPuTxjLJHOV
+763	0.93	utabDJMskmdfNWcDyQXC
+714	0.60	OqZwntqfOyrhRfiMUpKL
+657	5.88	gEmQxzOtYkDuECqXwuLG
+942	9.14	kVpbzwwYMPbJniQzjgFk
+24	7.18	UbtsqaMofOCciHImDhqg
+471	8.23	enrlpkzbOZIvjwUXTmlS
+205	9.23	ClJQkfcHrTYekEEsPsaJ
+939	4.57	zwQSrehzczpbkThuQfPU
+312	2.20	poOeFKDgxqDxvrJtaluq
+791	1.27	VUWWFIxKbOKCmbjsdomr
+926	6.91	oMxAeQFmkErJgikTBhIy
+197	8.95	qmnpZlDiNsWHgcTEeIkJ
+903	0.80	TzWlyotfDJQcsDURTRAX
+666	9.50	gNfRsmMniOzFhZejwtDB
+821	1.77	KPXLvXfDQfcXXrOsZcXP
+284	5.33	blACUBYIWJIcZcBwOWWG
+492	9.94	GWiyZHfXTSOhsFbKuIhk
+765	4.30	GBetTJgPyvkAxrXRpsJl
+253	0.92	HIzAohqVOuEzLhMrmWHM
+817	5.83	fKrTaePFivQaDodpUPcp
+634	6.51	fnoBFIBLvWYcnwWmGPDW
+856	3.74	tAdowmIYZKjoOGTwJAfO
+96	3.51	qOtvIpGNjQMQrHSLeRUx
+75	2.35	GlMwkqlZGvRCPRABnVgP
+375	2.55	SJCtkjXdFWcDFgYFDPXd
+858	3.96	MpRNSIajCaxjbWOxGeDl
+77	4.19	tnBtDfXccMjoKXssfnTZ
+625	2.60	clrWhxrSVdhpmMuoJqpr
+759	7.39	BOHgQDXUYQEZCTGJEnjm
+281	1.64	hePfEHzrcuNJCRqvBmfE
+976	6.23	hUgIipTXKSatNHGZvnPa
+192	8.69	KJPrLjSZTxZGLSogyfIl
+272	9.67	suulJBidiCsxEtsLJPXz
+784	9.82	PuOALbofWxYYAAPFpxhu
+742	0.46	lROKSHzHeEFyRPSoGGgq
+427	2.99	QGZUIpDngmQfbWdLiGgF
+431	2.85	odAeTWgMbFesukcwSGSz
+589	8.87	LaCVLltVFubMVdTsMJaw
+335	7.71	UIGNHghfqsRvvQysVnmC
+123	1.61	HfCuGmJjnqZogPANFShb
+861	2.64	kOmfuePaydwDbxqVxDkc
+313	7.93	OZERQTeZNZsVKfoDZqii
+89	4.10	WvfImSzUGnAqALNHKIje
+808	1.28	QTCKhTcIUWFaVwdwmHWC
+272	6.27	MlZrgZXkQMKRCErhnavN
+887	9.97	vksEBVPsrIjjJEzienso
+128	8.73	SAUsMljcuUHAeUpCfScF
+146	9.45	yubOLwcdxuXjREUHhszB
+133	4.92	bbqtNfbeQvPzFeKeKpNm
+920	7.80	qcADPDdxUaPRwBUNGoPe
+707	6.61	xWfsbVaPFalICCFNbNrF
+944	6.10	MKDQiwtYJJoChkYVaduo
+98	1.16	LVjBXNuotJGHfvwhbOUu
+366	6.16	JvQWxeSMZKnvCEwWfkdO
+238	6.33	cpBXyzqJdjSgtlADhYwn
+664	0.65	WKTGKRELWenQpKNbBDQa
+488	8.50	aoXWhqjECruNWEQqKogb
+841	0.98	wRvGDWDMYxYGfZNjgPLZ
+923	8.10	sWbpzsuxsygtdoGpNdmV
+762	2.73	ghtVfGPxISzriCrEcRxa
+268	6.96	eOqpdaYgWoVocwDChewK
+712	9.80	NjCCgBXbVodOHSWyQnqI
+851	7.52	NeuAPcRrdBTcGeDkPsjE
+97	6.47	bzZpgZHdpJUKQBkgspIZ
+237	9.19	WQOrhqdyoZgEVBoZtNbs
+763	5.14	LpvjSWJPvyMpPTdRIBJh
+952	3.31	wniuoanPhMZzVwGaZKQi
+145	6.55	DwWThCWXkzreoyswWOcm
+619	8.38	IcKqPCVXBefXJvEmTCWz
+894	6.24	RszFDfdThKnkAMVgWfcY
+411	4.68	MnidokwIgxwjlmDPHXbL
+976	8.66	KYwtBwvUpmFBvFmclDfB
+154	9.78	vHjmwHbimyafbDzSMGhf
+780	5.23	cmvPpbPfgnRQyIkdPxre
+776	6.72	jESxTrbGnbmrvfgVhIrm
+794	0.49	nfqmJtZtxKzszwmwFbMn
+378	2.80	APOmsppWHnyBVNaHeuis
+240	9.22	UOnvdxPLvRdkBYyYhsGx
+599	2.70	oMhMyuKEgNwLWlzuuRxj
+963	9.79	lcOnqWKoBmionyzBNQGJ
+802	0.76	vsAEnzkHaedQRrLgYYjP
+324	9.50	wXnYxuHAYLBIERYGHgXe
+311	2.38	nFKzDaDSwoYcHDDeIidT
+587	7.32	eNBSPUCRyHaQSJXsGMtl
+926	1.62	XyifJlxGaORFBsMmSgVb
+493	7.42	MoCNJnECHicCIJHTYLsD
+646	9.28	eHBRTtfBenbZIvQbEnmB
+617	8.12	MnVPUntngEgmfrfjxGcI
+376	3.00	NsSloRjlZuYLWPpyTYcx
+284	6.61	WXVHKoxNagUgsSWiaFGR
+490	6.48	DSdAOphODhVTRVNcvfPe
+959	9.22	HjrqzJycSdjEEkSeEdkb
+980	1.50	zHctjFBHUROCnUbkxQdr
+947	2.35	oDCGDOCNUDGUabOwSqCR
+158	8.92	esBpVVllfWfdPVVVSypg
+166	1.50	yfFUjRZCSppnUjxBezVy
+591	8.92	gSZzebedXBmGWKcemqol
+211	8.83	zrrpMzIscltleXtvcKsu
+287	9.11	cAzsUVnbDmJlyKGSVeES
+761	7.32	pmAfNAuNBcLceuqgLwuv
+622	9.70	wUgAVFVucWEBUNSSwkwX
+468	3.36	NYFlnMObVgutevtdPAXN
+529	4.88	WMfPZyGvaGbeoPTfuKNr
+96	6.38	PSpmPerAPtqFBjNaDpwL
+2	2.55	OjyJsmTJymhbblQDiSwd
+3	5.75	yDjwaTlyaRKztkgbUSgt
+893	2.14	slYhpTYbYlqbkLHMDKzc
+524	4.92	kDEqHUcQRAZPziLXASIL
+678	0.31	nsaLguBwtWEUFGbMYaMy
+931	7.35	KCgquCRLjyVyPIUmDEys
+867	8.29	NEPyfvcdZdWprkLEqMNe
+100	1.50	hoKqHYiYEZAwzwIrkGJj
+746	1.71	veeERjGTYnQMQfKxACdq
+826	2.59	gQnPWlEPSQXxdxEkxiDP
+539	1.14	oNmEyExhBdmaSYTJOXbS
+226	8.53	NuWtUSOpVmbgfWDdOPHp
+304	7.41	WaKFaWrBGEzySdPJToTd
+162	8.40	XNMcOPBtZHjYIebUtthr
+167	2.83	ksrspRMkuhQbQkMNXlVm
+219	5.22	rWrmTqhKWQnzBxUOqKdk
+181	3.25	qTtVLsHSJTgJELIniLrt
+755	8.17	xPIgwGOnubwThOAgvxRX
+907	3.80	zCEtnyUMjVYXDIdtjKqS
+882	1.54	QwgLYXxcXuUhDdkxpmPy
+407	8.36	sBebgTdBqvhKfbAqcJXJ
+86	8.21	WUNPBlKGYncVtjNmiEku
+640	0.94	FZaXSveJfSKlJGVqJshL
+924	2.48	TrCAiDQDiBPtgiCeRWFN
+709	6.23	IkkmqxxunVSibSDANfEi
+702	1.60	BLTNhNPDXUnaelUaMKsQ
+656	5.75	iSRsERaxJgmTIyqlOXfR
+64	7.50	NfrqpSzDSrFnWNabmZtZ
+561	6.52	BfdQGsXJJamhbGRmnZhF
+838	9.27	gwzhOPbcHIrKlYyzylmp
+594	3.80	zdhWVEpVkryRDDziblRT
+431	6.68	nrWaEHIpEZqNVdrduveT
+585	0.20	BLznkxwXmLmFAqTXtsLG
+793	7.48	UydrggvJOmMngnjiyGby
+711	2.60	BRQCFFLDGHmOjcCoZVeE
+963	3.20	dYVgFIyykHShyyEWlwyq
+699	5.90	MXmxYHqCPQTyfHjoWXNt
+357	1.00	vcMBeilpEQVqWpWxuFPn
+874	7.58	fgTKOTitYQwtxjyVheMi
+657	1.56	dlGmCjxHTCEYhkqTcZqy
+996	4.25	mFOHRuoWHrCZbqQuQWee
+752	5.30	HPgaHJLRLTbdAqjfxrVD
+14	6.28	hrvSDSigoTaoVrdvkIjz
+978	7.12	qpYUewhHKGWgFYGHCKsl
+803	8.50	KmirXHpYJFjrSUsprByY
+794	4.80	PnirpkAFxPhXUKaRfFSh
+255	9.16	VwMUqvdgbDiJuuuffkZA
+576	6.63	uKxSaObMYAFWczMCcCeh
+501	3.73	nvrjpZJXxVhHlnVRUBCg
+747	4.77	GbkUyqSSwzRkbpRbVgUT
+398	5.61	ZOnSftpAIYHsNrNXoRbn
+457	0.56	lojBbBLzQYhGLhhmihVm
+112	2.74	nfFoaFmQOwtmxQApohmS
+586	7.25	HgLCKFiBvRwbpxSrAiNz
+492	5.89	vDZnaFenpXvBLQrTdVEC
+516	9.73	biXEfEzupaXgYYSGJEvj
+464	5.30	mOxzsvtZMJXVydfYvwQt
+912	7.33	hWoSuRVMPWUxLGYeHKWT
+498	8.44	csEBPlIuKcPLYqFpgvPo
+317	9.90	xjmCWWuJVyyZLJWitSJu
+449	8.45	lbOTYARhIKjsvZrJDDLc
+535	4.71	xNsPAvTVOJOTpbGYcaEj
+852	2.64	gnlfHhaGDbesWXHqERdF
+304	9.69	ZrHCaNXDmQybfSYrvTVw
+710	3.79	dRCihjVEcQxXJWqMDxeo
+773	2.10	jJdelWwqPoqWfTmWGsZk
+991	1.19	NjyCjfpFZupBOpetsrAx
+507	9.34	WMiiOWvifiwGeyPfNYED
+358	4.97	DhZcLFRhigrudPVyhnCq
+662	3.98	vTXayBmDNqzJlYyfWZNt
+507	7.75	YyOLbYGdMzcWLpUEMktX
+738	8.59	HVANysGlgsFYYENRBJLv
+295	8.82	ySqHYVFtksJmfZxZxIKy
+984	1.64	SZiTCEsSQYPwEKGrUzXq
+949	7.86	yxuIlvnpyHhwgSYCqfzG
+168	7.18	lUULhUneHMLZQSAUHBTo
+938	2.59	hkNHgcCmoyCsEkNcpXHe
+878	1.22	IMlcVToHOvtQoAKtOAOZ
+824	8.25	nWoHoqzsqrgmPMHhhBvp
+677	8.81	GFlSdWJwuDbhibVxcJIe
+754	0.79	lswvYmUipujZGssasZZs
+875	3.83	aIiDifayDeyznpPAyDRg
+565	5.23	unkzeWMvdDSFoMzpIlZO
+120	9.83	gLDFeShLWfyYDoQfCSZM
+65	5.57	zxGFAuwltfPNhmLXwGvq
+605	6.72	FyjqLLXbmnUFQIifLGDl
+962	5.64	FgGVEHmXtWbTjqlpXrZR
+687	2.50	OXpbxAdsZzKcozqKashw
+652	6.52	EOzUuWTiGudFkdfgvJPx
+223	7.89	eXRuLdrMRislqVSPrOPN
+825	7.96	wRFENOLBcgIggYOGVxdG
+8	9.47	cjhAxVamOWsSdoQNKLqn
+153	1.80	BVUyTTLXHmVldMLlywag
+554	9.41	RDqlVDVrrKkEeZOWHONI
+873	7.70	QriNidzzaKAwEMcrBRxG
+726	5.49	YWvtTmqjSduziEzYjDPa
+945	2.38	hIybylnSCPmHuEalnKfF
+348	3.53	oSTjhbXyDhDYPriXkdAa
+477	3.27	uwYAVKhGuNqrASpWjbhS
+493	6.14	CVDcxFbnNZDykZFEOxKq
+150	9.65	PvptXpcHWiOOOpcAlfUI
+752	6.39	ouXYOzGCgKBPjscsJgtI
+979	0.92	SPUtqGnWEnRUqggexxLf
+394	9.66	tkgzNvlNjKhGxjQHqMTn
+812	1.87	ytfRgWZTrXsCbKsMaDEm
+75	8.90	gTRNMbGxyLbKegeBqCbk
+60	2.59	LchJepJVTxDkSNSCBjwG
+87	9.14	pAYJtODZsmItUEbKEHPq
+214	8.69	MDODqGCuZbSIecdcNRjh
+444	8.64	uQLEcXkaAszAuXtekKYW
+273	3.67	caQpkUCIMRhADFxHOJdY
+946	1.24	KHRszujDHEqzDWiNbUqn
+459	3.00	CMVIjthRPWCGRriRPQNN
+838	3.11	jdoZfKkpspAMQDcCHfSO
+147	1.18	eWcCpPBfxtvbaKguEOgL
+250	2.65	NlstFbCiVIsbFLSsvXyF
+218	5.64	EBmbDNcybbLkgDoQyAPX
+155	5.94	hqISVwRJGGcUpPsogHEp
+757	2.15	qyZiYrZQPLbfEeeVwxbM
+808	8.64	sQkcXHKphTqmbeMoQyKd
+611	9.94	vANiaAgfgJyRIQhLzjhq
+901	5.89	RtElsqTRXOrJfEYyTHNC
+907	2.16	IAcqfqbLpIvXlIMbWFIh
+599	6.10	uQLFvJlcZYQVNFKVkEOl
+375	6.75	sPKkvIqNzbcnlzStgfeg
+804	3.80	qCsreKtxOTTKwbpOCcXm
+315	3.54	WnlQWsOVYUbosaOLOPQt
+855	1.54	OVYVpZRzjEDJrOMibrSI
+114	6.19	xnhCusHcpzhKmNNzXMDD
+215	0.76	DFBElSengQCWWCKGTmeR
+268	3.28	PmfavTNRPYZgNUCZivBI
+544	5.53	ZDlQMLtDYNCOtbKWDgOp
+120	8.80	vrjDnCVyugNDsKiAYpjX
+162	9.85	cAyOTlMgPyJCqigjhHoM
+117	4.20	UKURKmjuQxiYkZbrUOiX
+972	8.10	ClTGSsUJebREwBUInuTy
+772	7.44	lNsiOPZvYqshrPZFnxjC
+808	1.33	laWEnkkaRHhnTFPWSRss
+262	9.91	EDcVzMXlCgVQtaCeEcfP
+702	9.00	rpkEwhnPzbQWRntwGXAM
+700	6.52	lzFVaxgJMJOuQylTAUUs
+929	5.58	irxLUjAYvhflrKcepdWv
+386	7.37	bHxOrDcXxHgCpswxzeRS
+946	7.10	mjBaKAnepQGhMbykfSpq
+24	0.72	NTcNpjIWpboDmCRCLxkk
+997	9.97	HkufAuDNOGmetgsgwKIF
+691	1.91	qRuqQGMxObGGbyQhOuym
+201	1.78	lJNeEOeENEiQTAJOMtWZ
+932	1.63	gssjKuuiBWeKuyPZlXYv
+496	6.70	BpXVgtsjPcJKnxoTVgzP
+511	2.65	ZhCPNTqiSrZZYwnmIcMz
+749	5.45	CriuhVmUitYuLKqVGeeM
+652	3.73	JrDrGnOTHMIYgYKPKxqC
+913	2.81	sRivrqAHczXCbGLjuWiA
+723	7.70	TVolfTbnDLkMksYKwJwp
+821	4.13	PgplIumUlymWWvHXFaBU
+613	0.80	VAonZFIjlIYyyaZkjLUV
+735	5.50	ipAtfieINhaqoTCfRuMB
+79	3.90	hnFEUemQmwYOIsNsTnWP
+703	4.72	pOkbGLDqEmkOaUhtnFaJ
+775	3.29	kijKDMPrtLoDPQDPPdzm
+258	4.63	IQhyQMOQkdLgqHwsyBQF
+800	0.26	gaozoumOTyvzXPlpmDgv
+766	7.30	AjwjksjnSKpZHMtwrzZP
+440	0.30	BiChKYZUvwbTQOCmgunV
+53	9.77	gVUfBCuOjRwNTSDhZDme
+32	9.47	ifzLoYCDjXcYHbbVyvww
+749	0.58	dipSHODvHkBzMTiVKcvY
+285	5.31	ygoSgfRXudzxmsqNBkEZ
+141	1.89	AAFopiHBwWYUPjRHuWZw
+248	5.12	KFxTsNEWrMPlCKJIkGum
+641	4.67	TojOvtPpaqetlWlpMwcd
+649	1.28	ywUnZMHscsXVfAVnxpuq
+774	5.40	QProygQPJTBuvQwutgVI
+209	2.60	ZbBaaYLvQGfKtuzTSUVt
+860	7.59	zmpTjLLVvRjJkfpSCOWW
+957	3.87	dKkAuKAaXEgKaMjkDagl
+412	4.31	VxAVuOKMQYEJMOIztvOW
+930	4.98	lNSgzbFMpKXyAmKcUhPo
+860	9.20	NAQYwxbDUXYuZDGtAwFM
+846	7.85	NSiFtFPljAAPIRSKrXgy
+819	0.33	RVxYhzUvdNprbqrsnjzz
+192	6.23	XCuUdIbEpjprxcQzTtkz
+446	3.64	tWiNzVnUFwNtaKCbyRHA
+452	1.48	BpBbfkMXYcGhLwtogNCN
+580	1.56	tseDNgBeKsRorIWkfrRo
+823	5.32	CaEbQLnvKKttrComiNct
+776	7.79	htvnWLZUPHoCMkCjFTqa
+107	8.55	wUZTOVqWLcqWaShSWxrr
+122	5.35	BipUWzNXtkrWhEcMebjN
+303	5.59	AmfLvEqQeRwGbZmLrVfS
+262	4.38	GSwTRNmMYBOFvAlLxBdw
+812	6.54	OvfIaKsMVvLnrkNEONQp
+980	6.67	bVglLpqYKQAjEuMTwTdk
+98	6.21	rFDMoKNLdhnDdAgTTgAe
+91	8.11	WTaActKUdEikgQxNlZNC
+283	3.62	tkHGYDapLUWEKShowzre
+301	8.81	weLWvyBPDBcVNsVhkTgx
+764	8.98	luWWpGgxEbsEndwRSSoC
+976	0.40	myMJoqbDaleEXfDhDuJh
+334	1.63	VpFHTtsUWyeIDmTPRCdN
+879	5.64	FeMEZpbfGcJatvxvXvvG
+458	3.58	PZbWWATDgivhdQQBycoS
+389	3.79	YQTPfQdrfOqYZETgLmMW
+969	8.82	jEwGRRFhFrIssnQvQfvC
+880	3.81	hAYIuvNZMHxYckABDlOh
+482	0.15	xZSzCFAIAnZPprYxFtpO
+315	8.48	kwNiyIFCiILOkaRXyKpm
+972	2.10	fgbcTJkoRRNsALhHwngZ
+906	8.97	IdtZEgnFNzmtsEAicYlm
+153	7.28	QBMGyWImeRrrEKEtdMYk
+725	1.11	ABKrNPrTXbVbQYfZRdVG
+246	7.84	BfGyFnjQkPRmbbNWUCgT
+210	4.93	EveCQKDDLMXOzntjTmsW
+513	1.00	BNLtwyvUlLuJxUrEdZaf
+636	5.41	DLLkJtXfIXCAXCEbwJIw
+252	1.28	MOojcVHswqSQxYIBOfAo
+768	7.49	usFqWGXJdkMbMVXRYebk
+235	6.64	bQtTNXELHzpFStdtlwRt
+458	6.47	nBNgHCfoHHegbKFMEAEl
+291	2.20	wYUySuiufmsRWfwQrMfj
+212	4.30	TeUuWTTXzjhpEOoUFdCw
+67	9.40	HbMUofhJJbzIuujOEszx
+211	8.80	lUrYCeAhPUNbhOMGzSVs
+75	7.30	SFUoPFeFUCpLnSVsPGrI
+895	6.50	RdDUXXzeYdaVYSVcENHA
+484	7.96	UJNdoiiatlqTfjAihsXE
+774	6.80	amkNaHVMzbsbaJtNsNLp
+960	9.45	MwIGIBdfGSHSLOMhNdFA
+613	3.27	jLizwWOcZiwBECMDhaLS
+198	6.80	aQFgqrbjjCYKxVElbPix
+763	0.32	NpuoPFLKBkkJxpaZHVDP
+233	0.91	jTzFaWskVbkNlwWMmvDp
+474	2.73	NIfjcrWlJSAEhtAJPBsM
+241	9.62	elsjNxvuxGKyZRwNHTvq
+685	9.11	ctjuXmvjOWOqcHVEIEzT
+797	0.35	apvUfTtJMDKaHNCZzLyA
+405	1.57	KwjnJCmTlzUYoXsXEReA
+344	8.60	XyvChRXhioGEsAGKDKZS
+256	6.73	ovrqINvYzNaTHyZuBGMZ
+364	1.30	CWVleOfvIkiaPqUZyJdK
+845	6.16	xrqIYWdMJJMskdxaMWhZ
+974	6.14	JFjbDNpaYLtvgbtItCQZ
+819	2.40	CdrkqWiCUnMQOVjZFwey
+285	7.26	NKHuZkNUlIfzoGhvGZNQ
+435	6.81	DiieFEAIbWGMhrdRaPRR
+960	1.90	nXOfUqZzHriiPAzqXlmY
+518	8.40	yMXUXKrBfCYOphxlWQmZ
+599	2.18	VWaVlkkHXNXQssoiVolb
+544	5.80	MAicdYDIxNbRpfGuHspL
+933	1.67	ZFFUKAsVWEOjbpiwIsSD
+547	4.65	YwUJBSJdKNbJfIMSqQJk
+185	5.62	qmEnfTsRUFqJHeeBijsQ
+798	7.69	EWqDLYUJwrumsCSTjtMz
+963	3.69	jwwOloyGyrSEojGfuthl
+527	8.81	yNqQBCxVnINNBrymFAcG
+615	6.42	pqVBjvmIvOLNLXZrqEVa
+564	8.79	PvjyJclAHPjaOGoTJwVc
+476	2.53	ivYxeUzAMEKUEQhqupID
+775	8.79	JQVhTQcIMJxgvcpsveFB
+356	8.51	hOCxGmnEdnrYcKZPxeTl
+933	6.38	HyYEXxNvQIUBgtAqiHqP
+734	1.25	KUjasKiikmTbOtfqTbFR
+522	8.45	WamSGQZFHlSVurtwNRxm
+878	3.34	ldCMEyyYjOqIKpvlIrSM
+973	0.81	ynUbpbUhuzGREmfJpUGo
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/r/select_chop_line.result'
--- plugin/filesystem_engine/tests/r/select_chop_line.result	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/r/select_chop_line.result	2010-07-30 13:27:46 +0000
@@ -0,0 +1,9 @@
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (c1 INT, c2 DECIMAL(3, 2)) ENGINE=FILESYSTEM,FILE="../filesystem_ln/select_chop_line.data";
+SELECT * FROM t1;
+c1	c2
+618	9.60
+847	2.60
+814	3.25
+571	4.84
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/r/select_cpuinfo.result'
--- plugin/filesystem_engine/tests/r/select_cpuinfo.result	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/r/select_cpuinfo.result	2010-07-30 13:27:46 +0000
@@ -0,0 +1,35 @@
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (a int) ENGINE=FILESYSTEM,FILE="../filesystem_ln/select_cpuinfo.data",FORMAT="KEY_VALUE",COL_SEPARATOR=":";
+SELECT * FROM t1;
+address sizes	apicid	bogomips	cache size	cache_alignment	clflush size	core id	cpu MHz	cpu cores	cpu family	cpuid level	flags	fpu	fpu_exception	initial apicid	model	model name	physical id	power management	processor	siblings	stepping	vendor_id	wp
+36 bits physical, 48 bits virtual	0	5999.27	6144 KB	64	64	0	2000.000	2	6	13	fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good nopl pni monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr sse4_1 lahf_lm	yes	yes	0	23	Intel(R) Core(TM)2 Duo CPU     E8400  @ 3.00GHz	0	NULL	0	2	10	GenuineIntel	yes
+36 bits physical, 48 bits virtual	1	5999.08	6144 KB	64	64	1	2000.000	2	6	13	fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good nopl pni monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr sse4_1 lahf_lm	yes	yes	1	23	Intel(R) Core(TM)2 Duo CPU     E8400  @ 3.00GHz	0	NULL	1	2	10	GenuineIntel	yes
+SHOW CREATE TABLE t1;
+Table	Create Table
+t1	CREATE TABLE `t1` (
+  `address sizes` varchar(34) DEFAULT NULL,
+  `apicid` varchar(2) DEFAULT NULL,
+  `bogomips` varchar(8) DEFAULT NULL,
+  `cache size` varchar(8) DEFAULT NULL,
+  `cache_alignment` varchar(3) DEFAULT NULL,
+  `clflush size` varchar(3) DEFAULT NULL,
+  `core id` varchar(2) DEFAULT NULL,
+  `cpu MHz` varchar(9) DEFAULT NULL,
+  `cpu cores` varchar(2) DEFAULT NULL,
+  `cpu family` varchar(2) DEFAULT NULL,
+  `cpuid level` varchar(3) DEFAULT NULL,
+  `flags` varchar(249) DEFAULT NULL,
+  `fpu` varchar(4) DEFAULT NULL,
+  `fpu_exception` varchar(4) DEFAULT NULL,
+  `initial apicid` varchar(2) DEFAULT NULL,
+  `model` varchar(3) DEFAULT NULL,
+  `model name` varchar(48) DEFAULT NULL,
+  `physical id` varchar(2) DEFAULT NULL,
+  `power management` varchar(1) DEFAULT NULL,
+  `processor` varchar(2) DEFAULT NULL,
+  `siblings` varchar(2) DEFAULT NULL,
+  `stepping` varchar(3) DEFAULT NULL,
+  `vendor_id` varchar(13) DEFAULT NULL,
+  `wp` varchar(4) DEFAULT NULL
+) ENGINE=FILESYSTEM FILE='../filesystem_ln/select_cpuinfo.data' FORMAT='KEY_VALUE' COL_SEPARATOR=':'
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/r/select_meminfo.result'
--- plugin/filesystem_engine/tests/r/select_meminfo.result	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/r/select_meminfo.result	2010-07-30 13:27:46 +0000
@@ -0,0 +1,42 @@
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (a int) ENGINE=FILESYSTEM,FILE="../filesystem_ln/select_meminfo.data",FORMAT="KEY_VALUE",COL_SEPARATOR=": ";
+SELECT * FROM t1;
+Active	AnonPages	Bounce	Buffers	Cached	CommitLimit	Committed_AS	DirectMap2M	DirectMap4k	Dirty	HugePages_Free	HugePages_Rsvd	HugePages_Surp	HugePages_Total	Hugepagesize	Inactive	Mapped	MemFree	MemTotal	NFS_Unstable	PageTables	SReclaimable	SUnreclaim	Slab	SwapCached	SwapFree	SwapTotal	VmallocChunk	VmallocTotal	VmallocUsed	Writeback	WritebackTmp
[phone]	221004	2829356	2600136	495728	4186112	7040	1916	0	0	0	0	2048	1722772	51064	502844	4059680	0	27124	198000	12076	210076	0	570296	570296	34359655499	34359738367	82808	0	0
+SHOW CREATE TABLE t1;
+Table	Create Table
+t1	CREATE TABLE `t1` (
+  `Active` varchar(8) DEFAULT NULL,
+  `AnonPages` varchar(7) DEFAULT NULL,
+  `Bounce` varchar(2) DEFAULT NULL,
+  `Buffers` varchar(7) DEFAULT NULL,
+  `Cached` varchar(8) DEFAULT NULL,
+  `CommitLimit` varchar(8) DEFAULT NULL,
+  `Committed_AS` varchar(7) DEFAULT NULL,
+  `DirectMap2M` varchar(8) DEFAULT NULL,
+  `DirectMap4k` varchar(5) DEFAULT NULL,
+  `Dirty` varchar(5) DEFAULT NULL,
+  `HugePages_Free` varchar(2) DEFAULT NULL,
+  `HugePages_Rsvd` varchar(2) DEFAULT NULL,
+  `HugePages_Surp` varchar(2) DEFAULT NULL,
+  `HugePages_Total` varchar(2) DEFAULT NULL,
+  `Hugepagesize` varchar(5) DEFAULT NULL,
+  `Inactive` varchar(8) DEFAULT NULL,
+  `Mapped` varchar(6) DEFAULT NULL,
+  `MemFree` varchar(7) DEFAULT NULL,
+  `MemTotal` varchar(8) DEFAULT NULL,
+  `NFS_Unstable` varchar(2) DEFAULT NULL,
+  `PageTables` varchar(6) DEFAULT NULL,
+  `SReclaimable` varchar(7) DEFAULT NULL,
+  `SUnreclaim` varchar(6) DEFAULT NULL,
+  `Slab` varchar(7) DEFAULT NULL,
+  `SwapCached` varchar(2) DEFAULT NULL,
+  `SwapFree` varchar(7) DEFAULT NULL,
+  `SwapTotal` varchar(7) DEFAULT NULL,
+  `VmallocChunk` varchar(12) DEFAULT NULL,
+  `VmallocTotal` varchar(12) DEFAULT NULL,
+  `VmallocUsed` varchar(6) DEFAULT NULL,
+  `Writeback` varchar(2) DEFAULT NULL,
+  `WritebackTmp` varchar(2) DEFAULT NULL
+) ENGINE=FILESYSTEM FILE='../filesystem_ln/select_meminfo.data' FORMAT='KEY_VALUE' COL_SEPARATOR=': '
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/r/select_separator_mode_weak.result'
--- plugin/filesystem_engine/tests/r/select_separator_mode_weak.result	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/r/select_separator_mode_weak.result	2010-07-30 13:27:46 +0000
@@ -0,0 +1,9 @@
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (c1 INT, c2 DECIMAL(3, 2), c3 VARCHAR(20)) ENGINE=FILESYSTEM,FILE="../filesystem_ln/select_chop_line.data",SEPARATOR_MODE=WEAK;
+SELECT * FROM t1;
+c1	c2	c3
+618	9.60	LSkNQAZjODwYvOYUeAVb
+847	2.60	yphkuCaGsgbReRQTcUob
+814	3.25	rJDEnFNRTVftDpWPLeRa
+571	4.84	bjQkbVIPlNmlHpKvDBVv
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/r/select_short_line.result'
--- plugin/filesystem_engine/tests/r/select_short_line.result	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/r/select_short_line.result	2010-07-30 13:27:46 +0000
@@ -0,0 +1,9 @@
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (c1 INT, c2 DECIMAL(3, 2), c3 VARCHAR(20)) ENGINE=FILESYSTEM,FILE="../filesystem_ln/select_short_line.data";
+SELECT * FROM t1;
+c1	c2	c3
+618	9.60	NULL
+847	2.60	NULL
+814	NULL	c3data
+571	4.84	NULL
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/r/select_skip_blank_line.result'
--- plugin/filesystem_engine/tests/r/select_skip_blank_line.result	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/r/select_skip_blank_line.result	2010-07-30 13:27:46 +0000
@@ -0,0 +1,11 @@
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (c1 INT, c2 VARCHAR(10)) ENGINE=FILESYSTEM,FILE="../filesystem_ln/select_skip_blank_line.data",ROW_SEPARATOR=";\n";
+SELECT * FROM t1;
+c1	c2
+111	aaa
+222	bbb
+333	ccc
+444	ddd
+888	eee
+999	fff
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/r/select_with_escaped_character.result'
--- plugin/filesystem_engine/tests/r/select_with_escaped_character.result	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/r/select_with_escaped_character.result	2010-07-30 13:27:46 +0000
@@ -0,0 +1,8 @@
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (c1 INT, c2 VARCHAR(20), c3 INT)
+ENGINE=FILESYSTEM,FILE="../filesystem_ln/select_with_escaped_character.data",COL_SEPARATOR=",",ESCAPED_BY="\\";
+SELECT * FROM t1;
+c1	c2	c3
+1	one, two or three	1234
+2	other 			text	4567
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/r/select_with_omit_field.result'
--- plugin/filesystem_engine/tests/r/select_with_omit_field.result	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/r/select_with_omit_field.result	2010-07-30 13:27:46 +0000
@@ -0,0 +1,13 @@
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (c1 INT, c2 VARCHAR(20),
+c3 INT, c4 VARCHAR(20),
+c5 DECIMAL(3, 2))
+ENGINE=FILESYSTEM,FILE="../filesystem_ln/select_with_omit_field.data",COL_SEPARATOR="|/",ROW_SEPARATOR=";\n";
+SELECT * FROM t1;
+c1	c2	c3	c4	c5
+111	aaa	222	bbb	4.32
+333	NULL	888	1.89	NULL
+555	xxx	999	ppp	5.67
+NULL	ddd	100	qqq	7.15
+999	eee	231	ooo	9.11
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/r/select_with_separators.result'
--- plugin/filesystem_engine/tests/r/select_with_separators.result	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/r/select_with_separators.result	2010-07-30 13:27:46 +0000
@@ -0,0 +1,13 @@
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (c1 INT, c2 VARCHAR(20),
+c3 INT, c4 VARCHAR(20),
+c5 DECIMAL(3, 2))
+ENGINE=FILESYSTEM,FILE="../filesystem_ln/select_with_separators.data",COL_SEPARATOR="|/",ROW_SEPARATOR=";\n";
+SELECT * FROM t1;
+c1	c2	c3	c4	c5
+111	aaa	222	bbb	4.32
+333	zzz	888	yyy	1.89
+555	xxx	999	ppp	5.67
+777	ddd	100	qqq	7.15
+999	eee	231	ooo	9.11
+DROP TABLE t1;

=== added directory 'plugin/filesystem_engine/tests/t'
=== added file 'plugin/filesystem_engine/tests/t/basic_create_table-master.opt'
--- plugin/filesystem_engine/tests/t/basic_create_table-master.opt	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/basic_create_table-master.opt	2010-07-30 13:27:46 +0000
@@ -0,0 +1,1 @@
+--plugin_add=filesystem_engine

=== added file 'plugin/filesystem_engine/tests/t/basic_create_table.data'
=== added file 'plugin/filesystem_engine/tests/t/basic_create_table.test'
--- plugin/filesystem_engine/tests/t/basic_create_table.test	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/basic_create_table.test	2010-07-30 13:27:46 +0000
@@ -0,0 +1,25 @@
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+# test file not existed
+--error 1005
+CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="../filesystem_ln/_FILE_NOT_EXISTED_";
+
+# test col separator not empty
+--error 1698
+CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="../filesystem_ln/basic_create_table.data",COL_SEPARATOR="";
+
+# test row separator not empty
+--error 1698
+CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="../filesystem_ln/basic_create_table.data",ROW_SEPARATOR="";
+
+CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="../filesystem_ln/basic_create_table.data";
+
+# test table existed
+--error 1050
+CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="../filesystem_ln/basic_create_table.data";
+
+SHOW CREATE TABLE t1;
+
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/t/basic_delete-master.opt'
--- plugin/filesystem_engine/tests/t/basic_delete-master.opt	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/basic_delete-master.opt	2010-07-30 13:27:46 +0000
@@ -0,0 +1,1 @@
+--plugin_add=filesystem_engine

=== added file 'plugin/filesystem_engine/tests/t/basic_delete.data'
--- plugin/filesystem_engine/tests/t/basic_delete.data	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/basic_delete.data	2010-07-30 13:27:46 +0000
@@ -0,0 +1,1 @@
+111 aaa

=== added file 'plugin/filesystem_engine/tests/t/basic_delete.test'
--- plugin/filesystem_engine/tests/t/basic_delete.test	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/basic_delete.test	2010-07-30 13:27:46 +0000
@@ -0,0 +1,21 @@
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+CREATE TABLE t1 (a INT, b VARCHAR(20)) ENGINE=FILESYSTEM,FILE="../filesystem_ln/basic_delete.data";
+
+INSERT INTO t1 VALUES (222, "bbb");
+INSERT INTO t1 VALUES (333, "ccc");
+INSERT INTO t1 VALUES (444, "ddd");
+INSERT INTO t1 VALUES (555, "eee");
+INSERT INTO t1 VALUES (666, "fff");
+
+SELECT * FROM t1;
+
+DELETE FROM t1 WHERE a>=444;
+DELETE FROM t1 WHERE b="bbb";
+DELETE FROM t1 WHERE a!=111;
+
+SELECT * FROM t1;
+
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/t/basic_insert-master.opt'
--- plugin/filesystem_engine/tests/t/basic_insert-master.opt	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/basic_insert-master.opt	2010-07-30 13:27:46 +0000
@@ -0,0 +1,1 @@
+--plugin_add=filesystem_engine

=== added file 'plugin/filesystem_engine/tests/t/basic_insert.data'
--- plugin/filesystem_engine/tests/t/basic_insert.data	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/basic_insert.data	2010-07-30 13:27:46 +0000
@@ -0,0 +1,1 @@
+111 aaa

=== added file 'plugin/filesystem_engine/tests/t/basic_insert.test'
--- plugin/filesystem_engine/tests/t/basic_insert.test	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/basic_insert.test	2010-07-30 13:27:46 +0000
@@ -0,0 +1,21 @@
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+CREATE TABLE t1 (a INT, b VARCHAR(20)) ENGINE=FILESYSTEM,FILE="../filesystem_ln/basic_insert.data";
+
+INSERT INTO t1 VALUES (222, "bbb");
+INSERT INTO t1 VALUES (333, "ccc");
+INSERT INTO t1 VALUES (444, "ddd");
+INSERT INTO t1 VALUES (555, "eee");
+INSERT INTO t1 VALUES (666, "fff");
+
+SELECT * FROM t1;
+
+DELETE FROM t1;
+
+INSERT INTO t1 VALUES (111, "aaa");
+
+SELECT * FROM t1;
+
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/t/basic_select-master.opt'
--- plugin/filesystem_engine/tests/t/basic_select-master.opt	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/basic_select-master.opt	2010-07-30 13:27:46 +0000
@@ -0,0 +1,1 @@
+--plugin_add=filesystem_engine

=== added file 'plugin/filesystem_engine/tests/t/basic_select.data'
--- plugin/filesystem_engine/tests/t/basic_select.data	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/basic_select.data	2010-07-30 13:27:46 +0000
@@ -0,0 +1,9 @@
+999
+888
+777
+666
+555
+444
+333
+222
+111

=== added file 'plugin/filesystem_engine/tests/t/basic_select.test'
--- plugin/filesystem_engine/tests/t/basic_select.test	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/basic_select.test	2010-07-30 13:27:46 +0000
@@ -0,0 +1,9 @@
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="../filesystem_ln/basic_select.data";
+
+SELECT * FROM t1;
+
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/t/basic_update-master.opt'
--- plugin/filesystem_engine/tests/t/basic_update-master.opt	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/basic_update-master.opt	2010-07-30 13:27:46 +0000
@@ -0,0 +1,1 @@
+--plugin_add=filesystem_engine

=== added file 'plugin/filesystem_engine/tests/t/basic_update.data'
--- plugin/filesystem_engine/tests/t/basic_update.data	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/basic_update.data	2010-07-30 13:27:46 +0000
@@ -0,0 +1,1 @@
+111 aaa

=== added file 'plugin/filesystem_engine/tests/t/basic_update.test'
--- plugin/filesystem_engine/tests/t/basic_update.test	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/basic_update.test	2010-07-30 13:27:46 +0000
@@ -0,0 +1,18 @@
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+CREATE TABLE t1 (a INT, b VARCHAR(20)) ENGINE=FILESYSTEM,FILE="../filesystem_ln/basic_update.data";
+
+INSERT INTO t1 VALUES (222, "bbb");
+INSERT INTO t1 VALUES (333, "ccc");
+INSERT INTO t1 VALUES (444, "ddd");
+
+UPDATE t1 SET a=999 WHERE a=444;
+UPDATE t1 SET b="zzz" WHERE a=222;
+
+SELECT * FROM t1;
+
+DELETE FROM t1 WHERE a!=111;
+
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/t/multiple_update-master.opt'
--- plugin/filesystem_engine/tests/t/multiple_update-master.opt	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/multiple_update-master.opt	2010-07-30 13:27:46 +0000
@@ -0,0 +1,1 @@
+--plugin_add=filesystem_engine

=== added file 'plugin/filesystem_engine/tests/t/multiple_update.data'
--- plugin/filesystem_engine/tests/t/multiple_update.data	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/multiple_update.data	2010-07-30 13:27:46 +0000
@@ -0,0 +1,4 @@
+777
+555
+333
+111

=== added file 'plugin/filesystem_engine/tests/t/multiple_update.test'
--- plugin/filesystem_engine/tests/t/multiple_update.test	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/multiple_update.test	2010-07-30 13:27:46 +0000
@@ -0,0 +1,422 @@
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+CREATE TABLE t1 (a INT) ENGINE=FILESYSTEM,FILE="../filesystem_ln/multiple_update.data";
+
+connect (con1,localhost,root,,);
+connect (con2,localhost,root,,);
+connect (con3,localhost,root,,);
+connect (con4,localhost,root,,);
+
+connection con1;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+UPDATE t1 SET a=222 WHERE a=111;
+UPDATE t1 SET a=111 WHERE a=222;
+
+connection con2;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+UPDATE t1 SET a=444 WHERE a=333;
+UPDATE t1 SET a=333 WHERE a=444;
+
+connection con3;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+UPDATE t1 SET a=666 WHERE a=555;
+UPDATE t1 SET a=555 WHERE a=666;
+
+connection con4;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+UPDATE t1 SET a=888 WHERE a=777;
+UPDATE t1 SET a=777 WHERE a=888;
+
+connection default;
+disconnect con1;
+disconnect con2;
+disconnect con3;
+disconnect con4;
+
+SELECT * FROM t1 ORDER BY a;
+
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/t/rnd_pos-master.opt'
--- plugin/filesystem_engine/tests/t/rnd_pos-master.opt	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/rnd_pos-master.opt	2010-07-30 13:27:46 +0000
@@ -0,0 +1,1 @@
+--plugin_add=filesystem_engine

=== added file 'plugin/filesystem_engine/tests/t/rnd_pos.data'
=== added file 'plugin/filesystem_engine/tests/t/rnd_pos.test'
--- plugin/filesystem_engine/tests/t/rnd_pos.test	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/rnd_pos.test	2010-07-30 13:27:46 +0000
@@ -0,0 +1,28 @@
+#
+# borrowed from embbedded innodb test suite
+#
+
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+CREATE TABLE t1 (
+  aufnr VARCHAR(12) NOT NULL DEFAULT '',
+  plnfl VARCHAR(6) NOT NULL DEFAULT '',
+  vornr VARCHAR(4) NOT NULL DEFAULT '',
+  xstatus_vor INT NOT NULL DEFAULT '0'
+) ENGINE=FILESYSTEM,FILE="../filesystem_ln/rnd_pos.data";
+
+DELETE FROM t1;
+
+INSERT INTO t1 VALUES ('40004712','000001','0010',9);
+INSERT INTO t1 VALUES ('40004712','000001','0020',0);
+
+UPDATE t1 SET t1.xstatus_vor = Greatest(t1.xstatus_vor,1) WHERE t1.aufnr =
+"40004712" AND t1.plnfl = "000001" AND t1.vornr > "0010" ORDER BY t1.vornr
+ASC LIMIT 1;
+
+SELECT * FROM t1;
+
+DELETE FROM t1;
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/t/select_big_file-master.opt'
--- plugin/filesystem_engine/tests/t/select_big_file-master.opt	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/select_big_file-master.opt	2010-07-30 13:27:46 +0000
@@ -0,0 +1,1 @@
+--plugin_add=filesystem_engine

=== added file 'plugin/filesystem_engine/tests/t/select_big_file.data'
--- plugin/filesystem_engine/tests/t/select_big_file.data	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/select_big_file.data	2010-07-30 13:27:46 +0000
@@ -0,0 +1,1000 @@
+192 9.4 jpBjgUdnwLxojNxvoQFX
+618 9.60 LSkNQAZjODwYvOYUeAVb
+847 2.60 yphkuCaGsgbReRQTcUob
+814 3.25 rJDEnFNRTVftDpWPLeRa
+571 4.84 bjQkbVIPlNmlHpKvDBVv
+292 5.6 ikfinRYRKPIjJsjNXtGe
+736 6.34 NxSIHnLbJEndkqmwZFPF
+776 2.97 YhdGuHgspSDfPZfeSHDs
+693 2.51 IRVxHgPmpDZDzVWReFRK
+27 3.27 gtAvpxIwXldqKYADhkna
+592 5.54 CEuIPODTitAOYqEQusEv
+59 4.34 PJSVLGMjcRyqRdffDeMk
+108 4.6 HlopFPmGpvJjdmtSlcmJ
+183 4.57 KqHsxxrIUHTkEVHUmJUa
+799 0.88 iARALomncGlwqWlGDfvu
+34 2.6 qKUfyEozvawQfNySJoqF
+622 3.31 tfdGYDefcGYveIwEgIzU
+35 8.99 oCnDHfJLNVTcysrBRXBY
+765 9.17 aUQUhRRYTMbDqMpLndwe
+77 7.3 emYjkJPwamuIrPPbrzQQ
+608 1.30 GYracqTOoUAsKQyhyrTv
+71 9.92 wgFQfoXxyonAlQJfruiZ
+480 9.89 vzwhdoBgcjgADPxWfRmA
+996 3.74 nQggLzdKdXkFCjWBCPbj
+765 2.74 DPXTTBcNawKyiAgthVVh
+252 7.47 kSeWSMDVpMiWJQRJPcdH
+195 9.49 NgCBvAmiGRYvooUImjPq
+749 1.66 mhChOLdNCIkWwdxkAwYo
+925 5.90 BpfNtOtlZQzVTFCVXryN
+898 8.92 SExwIoHiQyUJumKmnvKg
+62 1.75 qhpdevbKjgqZMrgbKMEc
+419 8.68 zlBKEOoGGNPAQHuRWuAh
+538 1.50 ZgfSjbeWkAPWvQHYwteg
+297 7.2 vTPAUlmqQBOnBkvSitAT
+612 4.30 VzhSsYdmdsAmYmxaCANx
+485 0.26 RQxqgQpyrlLmKtwIyvAC
+984 8.81 RIYiiQQTMuxEPDFrTtwt
+275 9.39 EjyENeSSzHpKzFuFUVwh
+709 1.66 VHVcUOsrTBxBYwZylLSy
+314 3.80 kTajmgdMehDoMHBUpiIo
+261 3.58 HddjywgLGBnGzFSGNClc
+576 8.11 RrqwMWPwzKEEneiaLMJs
+339 3.32 hkzWfriTUKqcjHrgzgzE
+204 8.75 EkKdLmvJaYhbuZSXcvdC
+569 7.10 jOwhQZpHMCOqHxEmMdFM
+563 2.96 aWOcwWfOXnabektPGgKM
+221 6.32 EjczZetUKWHOPFKzedTk
+64 4.40 oLEjGHTKkVHgAzuDZWTi
+990 3.32 uIbcYwWgYrVFJOHcaJNl
+706 9.72 hRFpTOsHmnTaPWWIyNpv
+21 3.95 tseEKNEUwtplsFPxQABr
+256 1.70 uaVrtCMWUGpyndDouJpc
+193 3.7 wulxTHaLUJWHZncPfdyu
+326 6.88 ATIxHVhtJxDzCxKCkJVO
+532 0.88 jGxbPAFdGbIofquyrqEg
+970 4.47 EJsLdVXEaVPSXHqjsfPz
+642 3.96 nRHrrKhutsNspLrLlFPN
+741 0.74 gmPcoeQZQLzvPiFEJQsm
+548 7.10 jPUBesAPDCXOExMUDAsU
+691 2.21 mWujjRogVFQJaClsMeHj
+698 7.29 DypRHqMfdBYLWLPiyhyL
+748 9.81 TabdxNOFnMZGsyxSLvmV
+888 0.35 xWvAwZWBZnMQWUsySaHg
+328 1.6 JxVdEHzpSVCEEyuDRmPf
+781 8.15 zhdERXUSBYSqsSXiRjJs
+418 4.33 ymBkxrlFulEGWsHCgfFz
+605 7.64 uHgZctYWEUcwLmnKottg
+568 1.97 mMNkVHoXdCxgRgNaLkTO
+391 0.71 uclHEKTLUXLBLADIgSpy
+322 7.40 ehHcEKwmkBzunaKHRlBK
+735 2.72 vBQxKqICfEOcRBnOLPRr
+977 5.85 vxWkZBLAIOMZFBQWBPRz
+655 1.38 ixdZfjUlvvYrrPHmtcbb
+793 1.55 DLcvRJKRjKaFMMCpbLVR
+42 7.76 EdQOUwzQItBPmvvctVZx
+403 5.63 aAEmSBQirVlkRZKGuPZo
+694 6.25 dNNzAvBWUZubaMjhawVk
+96 7.6 WvCodyAPgaureBHuNSOI
+655 7.34 LIQWyyTFoKsgBVIlMOip
+749 3.26 otEImKHWdviBWMHnKnAy
+392 5.70 eKTgSPSaFHlBJWhUsYcQ
+229 3.51 RSCUAZXTpnksXIIyMNqn
+60 3.32 heoxppRRMqVjnwLTIkzM
+59 4.66 shFimshNjoBhtiyXHkeu
+685 4.61 WpjzucNyNnbsYMcOHjbl
+906 1.61 AMMYTKlHMcxrxEWzcEgl
+452 1.17 hvIYeVQxRVjLGcMIIPlq
+776 5.96 kbrrFqzVHBhfCeGRAidR
+171 5.30 XIwmcpjETarpXQfWeCsf
+889 5.18 OARTITueckClWEhGnFfG
+209 6.95 yuAVMcZLBZOZnuqDJXtq
+228 1.15 wzkFOcmpmkGvKfrfrMqJ
+348 1.58 CMkNbteFRyBnKcZElcZT
+482 1.60 XBbtwyZJSINdDKJPFBLh
+549 6.25 POTjzYGerRZoSBXawlMW
+482 0.38 cEseEtPoLnbEGCvmLSKC
+311 9.99 DXzdcEyOaoQdemrFiWkb
+978 8.49 gZjBebGdmOjoeJsgQAYx
+675 8.76 XRaCqXGtiKmmTccyHFpV
+343 4.98 THxNBaZxylAvUxgUiVfb
+595 8.46 ohLRcfIjnWVYOrgWProB
+237 5.11 HTYrsiAjtvhWzIJdLMSs
+197 0.66 zqTBbbgaOZcjpNRcNipQ
+504 7.50 aWkDGoCMpwTMccGwiSia
+540 7.30 jwouGMVrewbgUiQMCtKH
+882 7.16 xxOjEZwHEUNmrrQpdwhl
+853 3.92 QdOAVhabDkUuaQBLXDoE
+433 7.72 dZtxCYRmZcGgdbKvagop
+643 0.19 jIjfjbYdFXEWlXZlnlWs
+757 2.30 IikDjuRNvdLPttddkKjO
+800 9.95 HnzCoSOyDuEsvfyckmHS
+428 9.78 kTTmhNmpFkjVluKWHvtx
+189 7.70 DBeQVZMalbmhVEsgYsbq
+30 1.22 aKCRJXmPebvzUaQHIBHP
+776 7.43 SrwJlmQaJTnSyRbmAWHO
+603 5.23 QDUPvENiqcHWRmTfxaDe
+26 1.24 UolXjCmCIQiSllznooXy
+221 2.66 GnFWlqKKyuCdWYXkbCqt
+108 4.20 pAnYwmpkSwOZRgwiYVWL
+175 6.51 opEldPFkpCDsVSKRcZaW
+324 2.71 stiTcwAYdZxbxZILylHo
+280 5.37 ZYtykbYUBCLALVJFkirF
+798 2.47 xYgSFtzerVqucvqIvEGr
+897 3.17 gGEkYIvCrpIiQTzkJxxV
+62 1.25 gGOidOOuWHbezVnTEWIq
+620 3.0 yYdLZxIbTLUnJgQxDUmG
+502 3.24 gjUyXarzITiqkNUPePvL
+70 5.40 NPnxdxhkOfnKjzpJNsiU
+204 9.11 KrJvPSsEdFSqLiXuxQiA
+456 7.34 OXbMZUKsUSAZbOVPQIBn
+975 7.89 kCwlsRqUGAytpCAGcxwN
+929 3.66 NunymCZUGzUBfhmtWeNR
+991 7.49 XPVKOhSsRghDcjftqkyS
+437 0.51 UAXgfvYvZVyDffmqhBIS
+440 9.25 sXzGZDTZgJAAWgqUAQTf
+940 8.25 uKjfbnoyNyXCZvsERros
+449 0.54 DcaJRKbcNwRwJLxKLhZf
+673 1.64 AUnDLAhoyAhmYZnIRbhw
+926 3.25 PWzbZhFqMyeCMWrLvVZv
+807 5.77 NvfsIyaqQAkvzttOVkMv
+485 7.85 YOglmchMYUvpPVLrfbSJ
+48 6.88 bvTBWQvQKSDIeZOCWCFO
+175 7.96 xmAknBEqJuviUaNxpljS
+633 1.90 DvflcynsTEHwPBwOFKBN
+92 6.50 ebZCXpoUWoVynKwUFIZn
+498 2.13 dWSNUAKKzNRSmBIACmBE
+151 0.34 wGiOfpmvKhvFPZxEADbR
+548 0.12 HMEBWQahnDjYRbcsiBWU
+711 3.16 cVbbfaLumCYjanAKrohP
+746 3.48 dZlqLnbCyPYlFyBctmdk
+597 4.24 BNLzfOVkAgXHMpjcqIFq
+399 0.36 qfprAaaoVnGgdczINYFm
+546 9.43 iTGNNVCPUrwkYbbadyKW
+594 9.62 YkiepbdHTqBOGMaVutQh
+371 7.81 MYLwxhHhjfVqSrozPlvR
+309 3.56 NRMiGLKDjAYmMIiwzJhM
+297 8.98 KEZjoQOGBHyZptWvcShi
+119 4.75 vIlqzrkTNdmwHVyxLzCG
+791 9.86 cBCiAmKLMiJyWzfyOrQb
+499 4.54 yuIpPSIGjBKmmpjgtsAS
+601 6.95 qvikjiMrezxQIQnZYKqx
+171 6.61 IrNSAEhVPmGuopQhsiGe
+137 7.68 RbEbHNMcCFyHHtgxbwru
+470 1.58 DJzSuYlqXdvjJMPGwvAD
+981 1.36 YXthDiWzZKmTFaVHXIvM
+449 6.95 NBzYrdifSJvroerfjCrx
+816 7.46 bGqzWGlbYVCsmBQnqeFn
+892 1.57 lKPDCgUjWXGrXoTmqofn
+796 0.38 hhnhhuUcZYFSXodkYozq
+849 9.65 pQkmTlynZGroEMhQqeFV
+978 8.22 tSRSfFdnvYJzIUCXvffS
+817 1.30 ivnVtbbzIWzRdHWrrFNS
+92 4.87 nLVXqazvXeIuRYKpgEVw
+543 7.65 ytoZORdbOanKCaJnEoWx
+3 5.96 YHGQRnNBeHPFqScDQIXb
+644 7.62 auOOpsagsSMpXIxvNcuT
+177 6.19 kKckdAjWPaeNfbFeylcA
+253 6.34 xBuVMpdAWoJLXHohZQaj
+54 2.55 ckBdUuXMWvOmUMnjtQnY
+240 9.70 QxRyBbBeFehndsCGDzQg
+313 5.29 gfQIQiJDpJxbASsPeaYn
+735 1.67 olIKdcfamVrSuTFQFMIc
+103 8.69 zvQtXyFOIMryLyDXUehS
+295 6.40 nyEPnztubhxQBSMOqvfF
+502 7.19 qAEFhiNyVNNQaUYRNUEg
+513 7.34 wwAXuDbQBjFVZjsbZqNK
+848 0.57 xguKpJPjMiZMTsymbcPo
+751 5.94 jTiBWgYHnXNkzmlXmHuq
+836 9.58 CnPTfaxPvUCCdRMymioa
+455 2.69 pejDtFBUxPIxKKhMJUWs
+861 0.22 rnWsdSZXNAuPccpGfjNU
+26 7.61 ZzRzeEKyIOVTkWCYSYZF
+54 0.65 gtXbYWuFVKvZjnCrJUAB
+779 2.75 guVKPZxSmxGYMXfypSFK
+159 3.93 AKpUxqRGiThzoxQQRROp
+917 6.87 IGnKppqKLyvMleSpohGY
+316 0.0 FMzIEKNXGeWgHmytBqwk
+428 1.45 WnBnkAegeZkxeqCwmUJj
+290 5.5 nWuIHEhhpvGEQqXIFyLO
+948 9.94 UivnZfMKAibZsjCRCXiW
+590 1.2 FvVXEdLxGPhErzVOXwWO
+303 0.35 syxsPFTZcZfqsxSQuHOK
+931 7.46 AXzLovMIsDZVnFSoLnzf
+737 6.62 YfnLlPXRMQxAyZCUaJPP
+259 3.96 dxPNIzgfZOKZFFdzLQJj
+544 4.27 JjpUuBRXnPbNrMLaFoAU
+807 6.64 hFSLCBZZmDoOzFjQnOMa
+437 9.21 slnNrajpGjHmrPEDjyLv
+487 3.44 zgBROXScbWoDFYwDrZZq
+649 1.22 MyVRplRDvwckcEtcnSwL
+755 5.11 KUQyMRwRuXVsnuxApTBB
+751 6.26 MVbpeNaiKKOWYzsApugb
+871 9.90 RHqbdbSECFpzqKBBQXDY
+706 9.4 QMuhdWuocukxUQvtLeHA
+941 7.35 bffBwXuTwyizVNyVlNAP
+178 5.53 AGhDovrxSzyBBTylixsz
+667 9.52 dIodUNdnPEOaluUaaqQq
+127 0.79 nNrfQxaHaJeXunrbldTW
+451 9.25 ujihJXZfnOueOdvPXSJO
+620 5.83 cooShIhtOkOBrKudjGaR
+240 8.31 oecWoiuhzPzuwOgXeyQG
+38 0.67 jrvinjtyLPPcfnvttKKW
+271 3.74 DbOuyotNTMTEexjZdMHE
+313 1.73 teXwnvclJHkCiAhJhLlu
+321 1.54 cRUfRNHbDdoVhZoqdIOj
+621 6.16 YiNFPRBJVUgsnzLRuloF
+369 1.43 slqjryaHUVDJhgwJASXl
+945 2.70 sLcNjEjGvzWDmWBLiaLh
+354 7.41 fudoFUiNtacDMhXApenm
+189 5.62 xSZfGwrdPjmoQRhmYDcX
+234 6.20 qMkPxrvYITMBVEYhznpF
+749 2.32 AVoZwcBZMLgLWiOHTflR
+866 0.61 nKZVmVoOMhxAFntgqFkT
+785 3.48 MPDRmXTvUXuqqjESKtSN
+608 9.92 ZzRTvbcwyQfIwuMzBXfs
+807 2.25 fUjmfEGNWHIQGrPaXEye
+720 1.56 NVAaIhYeHhneuljfohyp
+683 3.12 UVKsAEIpVJmTfhURNwgW
+659 5.41 GYkNtAnHDwqmxwffTDoe
+656 6.69 wjLBrxtwmuRaJtMMoldU
+900 5.13 ScAgZTpdXBxbeeJwGXDN
+489 7.96 IbNiaXivMkITJhoTTWPk
+437 0.20 vtXWIRaTgkFBnBfPLGFu
+535 2.22 NakPyqNTyeqRLRvNbmed
+761 6.2 sBwOoEdEGlNoMUqdlKtb
+780 5.62 OublVKVZwhTLAoXxPnXX
+529 3.73 LCmyRbilZVyeBNEoSNyw
+502 6.70 RYvkcCNTBvoUrpZBRDPA
+487 0.78 qnVDgcFTuKhBrngvWFYF
+579 4.53 kRHWQhoFFBhNVlPBjxXH
+797 1.55 ZuwmgmLGVdvarBRaprWV
+861 4.78 FMhjmagLzxhTmZrnbibL
+652 2.32 InRhNqlnTiHTcrVmBMwE
+870 1.41 lFhMOGAaleKyYUToNejF
+246 6.3 LstfbtAFDQCWSdIEOuiL
+742 4.72 RZmyfVBggxHDeuskAIeO
+888 6.66 CJWAxISMCUKavFGIRyIi
+377 1.96 xVqkyBNLYUkMYdwpAgEB
+347 0.16 MiOXVOagqkLSTzYIeSra
+873 9.93 QwyZZFOkUHXlvqmajTuU
+866 0.45 QfynYftmOdOhNYZABCfo
+720 0.7 XjNbriAhLUwcRijUzwZa
+21 8.90 cEFeZfJHGEEYHGDGDDzt
+842 5.53 NQrkWAnXfNjmcPapfnBZ
+395 8.26 WoObGTrswUXVocMpWzam
+805 7.34 wkCPGHHoroEkDDGXzcuo
+945 2.29 xgJvJcfIQmKDuaZpzqIY
+715 5.65 xzzVjlborTJLevAptgeT
+714 7.96 FxxJYhazQxFvKSlXXfLO
+625 8.31 yutfvCmOfLowqxqjuMUK
+573 9.29 EEUtQpLEUcJMBiYBGsXx
+363 8.8 ToacrTKslmPSEuRQCJwv
+889 2.66 yklInCiTlxnHMHlEXDQl
+628 5.17 UTEagZGvGZfHOlDuXUKH
+643 3.23 jcCJJeRumgaDFqcosgLJ
+646 5.12 vVnIjqpMfSHLitIsfqMg
+886 0.38 stfEWcbuWNitgLtTtigQ
+363 5.93 OCMMpnvtEjbFuLgAEtkU
+236 2.89 txucVxohWxrnUUDEMZwk
+70 9.75 DXNLUUtrYxmkReokvALc
+572 5.71 XeVYLrueWGiQGebWUwkW
+434 2.10 xMTykKCEZnUmYNNOgSih
+444 0.47 axDOmwdUffipyarAtIJu
+454 8.23 lYuKfhOKtkPcDyaZdbmw
+740 9.54 kUFtOgiBRUPnhLwwrgUW
+209 2.41 JTgAfdoVfSFjTGutjAvH
+899 3.19 eTGGqVkoDcqtTnkahxHj
+829 3.8 OvkAywzARPbfqTPHMEXz
+685 3.22 lmFitDYHTZambPCWjllF
+578 7.21 MMpgfEfCkQHJtagEhoUx
+220 3.8 JEHCPrJeyxXLhdtXGWcu
+947 6.28 dTtJKhgwcBnipuWYxYEv
+54 8.83 CHsmJurywDSXAsymAqOw
+12 8.38 XISWvYQVeZocSmIrQNyj
+577 0.34 SSjCteOgDkQPwJofWEEU
+771 3.37 LSgNuOQFoetwCcCDtIxk
+656 2.14 adRsvhoZHvTfLTyLqvRF
+896 7.34 CyXBvEQSXNPNejYrjWOg
+980 0.14 VClbFxOwvvhMxJiSoHgv
+454 8.82 UGbZCbTYmxYfaNRvxmiZ
+892 1.56 WQdRYorTGjnXFWlvrxgX
+649 8.77 BuREkjbviHzhtVvaMswT
+299 2.92 WMbmvpVWVrbMQNvnVuYb
+866 5.15 ttVBDkjMAMBdCgbkTMTp
+771 7.37 bWSUWyErakTnbDULvkRJ
+748 8.59 LiodrknBJVVqOYTslJRE
+337 1.88 GbplVMxejUlPfbxiMhmj
+532 8.1 yeraTbSrtHHbyHnLnjvJ
+860 1.35 qfXroMPpihOyFNlbjdRa
+746 5.88 xwarOKMtEUqPGIDuWVbW
+572 2.34 ysIFbYbpyVngDNdscNzE
+693 5.56 sgWzpVDsrPedZaiuBvan
+736 8.3 JAGQGSmeBgmMrRxLLzJi
+411 6.69 eUMQMFlztnCXJnMhkXXV
+605 8.43 mDmgFeyVznUDAlSEFmzX
+882 0.77 gUJmprHdPOvzvQNKNDdV
+136 0.35 vyoNduORlklNvHjZtoCv
+763 9.96 RaJzaXnEfOYnReWFoyIY
+361 4.29 klsePKOxmWGBTXZaDtPi
+281 4.27 LqhRhVMFCxzmbvcNtOrq
+460 4.46 sSSwfpHvdoVutckHazUt
+621 0.40 AJfWbYHkYustCMIsEvFw
+44 1.49 ymzIqzGZPxTUiiAotMhC
+532 8.4 DiZFMlbWozhtkbnBpsMe
+974 6.36 BqPaSfOGYlmrWSDuzOVz
+257 2.98 vUprKOpULQnKAulAZpGb
+290 8.88 kXjaEAVNSfrjqyXuNhtF
+478 4.48 kweRAIdsBQtzcYjPpRXl
+432 8.19 ASvAPuQuqRIZDmvTJRBd
+12 1.74 WWIGjzlRZxbeZRmhdnhi
+944 5.85 mdUlAggcHyZWubrvhJwR
+724 5.29 ryHSuZWpITFwcyKWPoDa
+813 6.86 NhLEYhuQTTCVMKBNyEED
+568 8.99 FZiCwFYLNaMyrFxhqZJd
+560 8.64 eZOVPGpmTmfmMrdUCcLD
+279 7.74 ZfclbaBlhQmVvtPYOzWW
+151 2.48 dyBMcKxXNQkYNsmuSJtV
+281 1.45 FNQFBFHaMuooWYmgdSkw
+945 6.30 DZzoAHcKvhNrDendccIk
+209 2.52 nnBfHEVwRbVHQcMZWUjG
+770 5.97 GtdxrRhaMZKOHSepPwsv
+163 8.89 QyvjtJrpZpUjNUvrJeXB
+325 7.43 PfKbnXWnNDidiZWNpWft
+554 1.98 nRDXTUeiHSTwEjdZfMxn
+372 3.16 FttOhHsHiZgZJLqfVdBN
+931 0.83 fFCQoWnDdpeZlwbuwwWV
+382 9.7 mXsRKrHNpGMwoZRhJTuI
+696 0.70 OVFQBbDOjwmcGPvdRIqX
+810 3.15 KMiKawUCvImQAFLHVGYR
+23 4.53 UAqVGWUfVuoMZjVeknNY
+406 1.74 WNRrxNYESOaonJgVqBgc
+343 8.34 omnvEWQmSVklsJJpSqYw
+966 5.48 AZzbEwxGVItDLBMoLHfE
+448 4.23 BGBsISXvvxYCfNEzBYbG
+495 7.68 nzvLWgwuUYrskJiTarex
+338 9.50 HYrPfBaIEURguPWLwpGW
+562 5.77 OwDDTnSgGEGanAAFpIuk
+178 8.55 hgXeTKuJkPwUItJeaHuR
+234 2.53 SvVBGkFxRXqzXZQtPeFk
+566 7.91 UgtIXlzbAcDRyTuHYGyl
+165 5.13 RIRuMPSDAgODegLuHYtM
+473 0.59 VNahlMhbyNTpjbVspVuU
+918 4.68 PnKFhrrZFjBkIXpqAtyR
+126 1.6 JBcuGkhFlkIFUgIkjAvB
+4 5.90 AMnTFilyyQiOLxBvkZGA
+975 6.72 MzkWUUWzdLDtwISzNgpX
+430 7.59 FLYVcOWRCbIBztawYsSW
+86 6.71 JtEXDfmDuQFtPBOHgPNE
+224 2.70 EJowYiFEYrKVvAwSEpVG
+950 8.60 ZkRxwBNwbqVeXodSLrJb
+348 7.65 lFqwuSEruKeNzLGzWalK
+837 4.57 nlDzGGHykYZcqwTFnomR
+746 7.66 rDVPgehFbohxROiTjaGy
+603 9.53 oOdIjEKxmvfBjFuguiMZ
+591 6.11 YOWpmqtuRQoFLnLhyasJ
+73 2.77 pVJVLkRnwksBrTvALmrH
+339 7.1 GTOdZJxVlKKHEtBnoGrQ
+698 2.42 twClrIepXprGksUrGTbj
+821 8.92 LWAgApBUUiuszjRZbLcb
+227 9.11 JdDbFLSDUsBauYAciSrD
+255 9.56 pDjgONKekgxqTgdzTFcH
+794 4.66 iKLpSuRcGZuCfRHWBoDR
+235 3.36 lMFtQpAHvaqPSWcZpoas
+769 8.99 YdiTJnKaswltGNLuxvDQ
+430 0.73 arcmAZXkpyeotDfRyYPA
+788 9.17 okKxOdygEqXUeqsGcwRe
+563 0.93 nDnKCzxXjgVPctzeQOKg
+3 4.75 FzlYLMdjQTyTXLWKKNCB
+483 3.20 YixdiktWavAqoojjEtWf
+444 7.33 dBAJxPrDKUSGLgxAfVQv
+869 4.4 HltYNXLlSwXiwVpgBmDz
+725 9.63 ezuFHPAzKPfSKgYOBPFZ
+164 4.70 mWppbTXlNcvIAULGoktj
+200 1.51 GtTkJwsgvCnCuzqChotT
+942 3.36 NrdCmmzcntFdodBhfzsH
+736 0.2 URmRulmBtZYvTMvAwLBm
+0 6.90 wCpVrSqORejfCTisIlxk
+701 9.62 WjwEVffstqMHgMvAXiWe
+834 0.44 tmogwQMMcOBywnIQamVd
+819 9.50 ujtmbAoyYWcxaKBtsWIr
+957 2.43 yuNsZDnTUvYBsbnjKEai
+807 4.23 TdnQqmeRbziOXCKftSEH
+521 5.90 ElpNMUTDRUlyzTjcbstl
+314 8.14 pPsTWQuRUENWAWycvMos
+217 7.62 uYTHPCMyHacNbGIJdjlD
+626 7.86 KVvLVNeNllXwUkmQeIaV
+490 1.41 GLQixhqPsUIKwLQSLTBy
+838 8.25 lVUNCiPtoyRpFwJyrmyP
+607 9.20 FatUNtpyajGldFMawXEa
+162 2.36 unqFMicqtBhMNpoZoqQq
+310 1.49 CcJFouEtrrblvSeFCLkm
+10 5.22 aTuLxAJSrVZRqJkNZHry
+127 7.73 rzJYhFwSafZwVSXWBdLG
+750 8.4 VKcXOyaqczUEOqgTwxrf
+307 5.18 KNvOTEPzEjNCgASnslnP
+452 9.16 ubOLrsUNayFtfJzwSNae
+788 5.2 urcAAWBFuQVZqzzaAhwz
+86 2.42 WfXeFiKDcPblptymlSjM
+657 9.49 tTTGfzqPTLLoPvTksCAd
+362 3.98 IAEVbnwGSPOmyvJIlmTL
+129 9.34 XRmXHyjGvUjRyZuvsZDf
+787 9.6 GRcxDMxOiDkylniIDXiy
+919 0.23 XJDLPHpwZxjzmcXsKRUe
+624 5.54 abCXNSNiRDqhyJJqcCyQ
+67 2.33 cTDSPwJrthShnetFjxti
+838 2.89 SuqGHYfiuKNCggiRRqSh
+373 9.61 HFPFxDOHUvtAvJfvfMay
+559 1.85 JblTgGdfwEzNVIHBbdzy
+983 6.61 apUPvuSZDqrmzHQjrtzl
+850 8.3 GwOZbyHoxejRduSlSpiT
+955 3.90 aoQwDfqIblLIVwSqTGDN
+419 5.5 yXsNboLdXkWWfmhqDKIA
+881 4.18 FbagsovifdcFUqrkILOA
+97 5.25 FZyiaHPwrezjYNAArPfy
+161 0.11 zPoinwsgdRxXAyuVdDNJ
+241 7.84 LOLLKqdqpzfyWcdLXHKT
+824 0.24 doaLLQoyfHFQsTZqxyBx
+217 4.95 XXgktdeMhFEyeJwOebKQ
+150 6.39 JJmsIVQXoWpgfYjCxSaa
+508 1.75 GuwcWaoNaEZkQmTTAxeN
+108 2.34 IhNbBDnVirbjzMXzRevl
+595 7.66 SsUgYEgGeoyeplTRwzCo
+770 6.80 UfqwSLLnBKFaXlLKKrxT
+233 9.72 UnZMYddFVcZPPeXAImUS
+702 5.33 flGTAxeTnCqadOQtSnrW
+321 3.46 FdeSJuoilQFEnvPEeUTK
+414 5.32 ZdcWNHVDeChZApGIwZVj
+286 0.13 IsBLSOqofXnTkmdlYAje
+12 1.14 GWBGjxElgTtdyymPrYqL
+762 4.79 zKDtccjjTIefbRwTeojR
+640 2.33 bCtakLuWwVeywsKqrLdP
+872 0.61 TPznbeuhfEdJISxzOjjN
+736 0.72 huQFpeDjvjzdKYjPrCbO
+340 9.9 sXEvHgUlIxtFtIklyEUl
+730 5.89 clEIgBdirtYkgXsuryAH
+411 6.86 uBRGAuqkEBLQGWsDiUKl
+917 3.65 zZknJIJdXSlUCORrncWV
+190 6.28 yYSFfGMqzOuOokGoHvHu
+39 6.58 JCjrrHoXgELebNLFjOcS
+454 5.89 YpacUspejlbNMtmUbOpv
+749 7.8 EKJFAjLpGKeNbGtwsNil
+640 4.50 oBZwZUdLHdzbrGEcvxyI
+430 2.0 NTgyKmzIGwJfLXBWkRQt
+505 7.89 fGMbDIHOiZdxUVNISXXw
+880 2.19 ljKmhqeIjzljvsvemwZL
+430 5.46 RyoGyMzLxknNVczgnAot
+80 6.97 WWJrEgNboEpLkhuYHzvo
+729 2.35 oKFMPUHsXnpPWrWGAFfz
+644 0.79 ADmynCvscyBJsXmOCgoB
+20 0.93 LjrarLhooIjmHBrCWsbS
+749 2.32 QcWpVgStgSaohrEVMKUR
+904 4.23 vEptXOoXtCLyniMOtAYC
+397 9.42 FIiisBxhBecdrqtfjJSW
+115 8.47 ZiBMZVuaqFqhCtgoWuVF
+160 8.86 bYffCeoGSiiCNuTMagYg
+311 1.70 QtTIiQVFwrXBxYOFxTyE
+944 1.88 TEurBDMzyTJrDGCAzWBU
+782 6.70 bPPKaOQSwvtNKPETlBmo
+15 0.29 qgapCHoTDCoeoDkNuZbw
+770 1.85 qoRhigPWcPpYFqIJfzCH
+853 4.29 FouHQmvyPoXebZDtiByS
+739 5.23 lIscLaypkgzMmefRjgNH
+666 7.40 sAoneIUBaIXmCbdwomrP
+532 8.47 XlbTgxmdnBwwLFuSxCik
+603 7.76 gQooOPqPyORAlENfABgD
+74 8.5 UZhRAZpWgrvTOSvUpiFA
+174 8.17 lBJQcLsPjBPhwePTNBel
+151 6.46 AqAFTgnrVSZlatBNOYfh
+862 8.84 KxySyhemIiOwmAkDfWkp
+926 7.94 UIxlLySbnGwxGvUYdhdP
+786 3.16 JZDAyjGEjJcxlCnxxzzn
+229 7.60 zoYamVISryvfqUDFfets
+160 7.10 VmcKltBNFmsMKoXyCzCi
+39 4.53 PfKbQxoANxKZtBkeMHOq
+616 8.23 ogxAmPaHduqwtxTvLrjk
+511 6.63 klLlFnJIdDpvtHeeSdHW
+171 8.96 YdgLViqAdvzywmyBSiMm
+871 9.65 TExnBkPUoWKGfzZDpoyi
+113 3.14 OtgZXsfcBvLCdzMxBYst
+396 1.14 UmBYWTMYrAhprBqPAqAF
+977 9.77 gLPxyWjqzcJGhGODLFse
+919 1.1 twRSubVFtafDSEVnYrVt
+662 7.33 OeGjbkibAqrccNifLmrx
+754 6.44 TaUkvWHmNczbpEEwffUM
+722 7.40 eZdyfkMYvkGpHyvfwlUh
+460 5.9 iZhEJwWAZQnqSBYqiICd
+496 4.87 kwbzPhmKesfqoDjkjfBC
+181 2.50 jqILbPIsfiEPCMtAtfiq
+897 7.13 SlAqOFhFQXfQblbPzbrM
+348 4.81 hDQlBgznFGAcQVeCaFtd
+187 7.43 EYMObWOrWRDKgRNMsSzo
+934 5.43 rYwDFXPEdEqJOwDxxTjX
+181 5.37 ECwQivqQCZVrRtvqCAKV
+769 8.80 nIbSAyDSZteIKkfukVZl
+919 4.76 rvmAqHUPJvKnrpxmAPMj
+705 9.2 vBilNKhDnCkAcDXhCLDH
+447 6.53 xahXLjLkXvnplveQdgbP
+332 8.46 wdwZYxZtewyydyLnRyik
+512 3.65 OPPVCcCgOXtQDXVeWVTU
+973 2.51 zrvAepVJkFxAAXlsgNml
+316 9.48 ucywvQCUpuoKaAoIMpWx
+980 4.36 HySwAocfdnHmbLpvGIRj
+266 5.85 TeQhygiPHCPGrsyqaQnH
+685 2.46 gWWavAEzAOaWquajoWKT
+820 3.38 EUtmZqDBMGjGUXnWeBMA
+300 6.57 UbAkWmCyEYqTSTLLVrTM
+503 8.23 cQRgeVNqxhammMuGfggI
+923 9.27 ZNbFicrbGJdPtfzencEA
+804 9.84 dZpWhBdTnFwcZDSkveSO
+386 8.23 kbQuVoFbDQEIBGecNejk
+53 0.83 ntAZekjoyZSqwnWPzthC
+819 2.74 TASFSozJXEFyRkquhrrj
+563 8.68 OfDoFXKcZtHtKjhnzCyP
+489 5.30 lwNuDiWhTNKYnXKcuDLR
+702 0.74 vbSuZeATRsTuGXIupEyU
+80 7.62 ydaNjWFvVRZRgIrsORIJ
+901 8.22 jOqKRBjSdXOmpobcDjWl
+169 3.1 IYjwnptZZSjoPhUSUyVF
+331 4.25 RSObaoHCDcdNnWYEJVGc
+75 1.63 TvgvGbheutcwdUBmzcam
+574 7.71 RUfWWmrCRIaxCivQEzzg
+513 6.44 EiDrvBLShPrLnwyPoyrb
+160 6.79 RglYVbXSqKCrvVpkFKHh
+351 6.89 CwwwSvlzlvMgXfYaDGau
+512 8.94 eCkWDrCOelfpcueTQWMr
+692 3.55 EFhmVNZtGEOmmhgQNYgI
+488 7.51 xGvKtSSUPuJaeigKpzvr
+338 9.92 VaCHRkSPzojoiApMDYef
+826 7.59 jeyncSDvPHCSbHaPgaur
+367 3.76 XexiyFcTilYHgdJwEvab
+16 5.91 DTyxoowjIiXQgEMpLDhh
+298 4.77 nNdsGAuXzGeFXlRdzfSV
+931 0.41 oNRWNSAATghjFvQERFfD
+694 8.77 LEWMAidjZMhzCkzkEEpN
+6 2.74 lkeKVOFnZKuzKMFigAgg
+454 6.11 BLrUMfsOwJddHxGYtKoT
+477 2.99 BqqfjApFWBCNNMJlIifv
+267 4.1 uxxRmaiwESVjKCctPBvJ
+295 6.57 iCketfXTFRQBFPFfdbOX
+75 0.95 lOpdYXlNpNgdmMXQCGDN
+412 6.19 HcrSAAgWBnZLJeshnKcV
+579 6.79 sjVJwgNuNUDfkVFyrpSm
+386 5.66 upxIpdrfyjCtwCfXrqJy
+47 6.0 aPPWeJCJUIXtpKnmeqKf
+210 6.53 ERoRPgpUERSygdnrEOHs
+885 1.94 tlcNciWFDLllMpIsyuKn
+673 7.77 qLAUxdDaWobWjvYicMvs
+48 6.5 qnYGfEnNpDGsOLNvHrwU
+472 8.12 vCuXhwRzInctwjnRnfTU
+154 4.83 WmduMrHPMUueVLIxzLxT
+784 8.39 MYMhNkmYCXykAOpFyEFt
+73 3.29 WdvCQNsFYhylbDoKQZni
+992 6.46 FHUQMIWGcgMdbWfJqdAL
+437 2.43 GvcquKiBgNVMeLyywtlE
+487 0.77 cRPvIzDsXqZoPohdlIzN
+354 4.44 aFjWeTulcAiCsdwZnQjI
+64 6.29 tiekZPtZugCJnyxyRpNl
+536 0.57 AfcyCWoZVTuzrtAgdxXh
+609 7.86 sdXQFHXFGfkFkgfXxXOg
+295 7.15 mnofxohdUqozGmBnrbbd
+207 8.4 uFsscAmoswwURsTtLkuM
+357 2.98 WVpOIEdZqaRPlnejIYSX
+532 0.52 QPsHmLcufykATBwljQDG
+143 5.2 xlvUXrBxAXjoUDoDQztI
+225 9.57 XRBJUxoDzSQzUJVCASHF
+681 1.41 NkxBrKHtmLChJKjxseaH
+840 8.29 abxkARdGIMiQYBtCXseY
+468 4.56 EDEADRvbXJynTSOOXzOl
+568 4.14 ymvWEObBwkPqeYydDTCm
+755 4.46 uZYxNpPHciRCUeVneiTA
+71 4.50 RFaaMcAElRINKgYHgxNx
+843 9.18 NVYzQLfutveUNBzQunHp
+711 9.65 YyjrXkawAYSkYBUeAixA
+718 5.46 GvADhdPByAJActNNZGyJ
+647 0.69 VFjyLHWobDXVabQSEVZi
+0 1.55 VCGISunAnpxINgKqeNUg
+227 6.24 ZZlhmwmbQfweHnPChDkm
+430 5.14 vDZeUhlsyUtCVjockEeL
+852 4.59 rIOJLoHsarmdyxjoAzud
+49 2.30 MndlmeetVfnqIHpXtiab
+587 0.42 kbZCxqiIShmfatrYBgUH
+509 4.72 aIxjRHDITEwXHscDFXfZ
+545 8.92 gpkRZjSEygzWRvPBrMfB
+366 7.57 kpdxbBuMBLEFgTtsmwGZ
+134 5.37 vNfcwTTwpLFMOFjUmeJA
+258 0.74 RDLDYZpgVevDyKugoBJy
+64 1.55 jGvvzOTgUiDsKgjgvwhr
+325 1.54 OfmXRoBAajlYUDKHPnMD
+527 0.76 kiWWchRlmzhFqtJDxQin
+106 7.74 SvJvpoNRylNrTUBNcmtH
+705 6.77 ajSvfwpJXdiqtEBXzZiP
+551 3.54 DKfAfKZmiacZVkljJoYg
+897 8.36 fUfcunfweNXmdfMLzHpF
+261 9.22 BskeJbnXXSxQFUnPoGpO
+720 4.19 yriRxVSSBrHnZhFqctJq
+367 8.37 bIzpQFvBVfSdNcbksXlw
+922 5.41 KZhPxWAJhMSYPSfNeHbF
+612 3.84 qJNgIzklSoKaWceUWvvL
+7 2.79 PlbVQComhFXxTWGsYUUE
+799 1.1 jiAgQwCoXsgiQmukYzRp
+336 2.34 WcVUtAREjfpKxYwjpfFX
+219 4.91 EzQLsudoINcHrzDUjouc
+236 4.76 IuzIkcLKSedivWijHnRP
+392 9.38 TGsTUbNLaufnnHOVmQvQ
+371 6.52 oipxGWnTdpOabCTkWLUm
+788 7.33 stkTdrbdOcZLLiftXjMv
+230 4.98 kzrYdCpZxhyaiIRFSRsd
+183 9.15 SrmkkApzWrZxOTGuszoK
+964 4.34 WXQfamXYCutjEmTuEbho
+891 6.89 NQCFqHIDzyPuTxjLJHOV
+763 0.93 utabDJMskmdfNWcDyQXC
+714 0.6 OqZwntqfOyrhRfiMUpKL
+657 5.88 gEmQxzOtYkDuECqXwuLG
+942 9.14 kVpbzwwYMPbJniQzjgFk
+24 7.18 UbtsqaMofOCciHImDhqg
+471 8.23 enrlpkzbOZIvjwUXTmlS
+205 9.23 ClJQkfcHrTYekEEsPsaJ
+939 4.57 zwQSrehzczpbkThuQfPU
+312 2.20 poOeFKDgxqDxvrJtaluq
+791 1.27 VUWWFIxKbOKCmbjsdomr
+926 6.91 oMxAeQFmkErJgikTBhIy
+197 8.95 qmnpZlDiNsWHgcTEeIkJ
+903 0.8 TzWlyotfDJQcsDURTRAX
+666 9.50 gNfRsmMniOzFhZejwtDB
+821 1.77 KPXLvXfDQfcXXrOsZcXP
+284 5.33 blACUBYIWJIcZcBwOWWG
+492 9.94 GWiyZHfXTSOhsFbKuIhk
+765 4.30 GBetTJgPyvkAxrXRpsJl
+253 0.92 HIzAohqVOuEzLhMrmWHM
+817 5.83 fKrTaePFivQaDodpUPcp
+634 6.51 fnoBFIBLvWYcnwWmGPDW
+856 3.74 tAdowmIYZKjoOGTwJAfO
+96 3.51 qOtvIpGNjQMQrHSLeRUx
+75 2.35 GlMwkqlZGvRCPRABnVgP
+375 2.55 SJCtkjXdFWcDFgYFDPXd
+858 3.96 MpRNSIajCaxjbWOxGeDl
+77 4.19 tnBtDfXccMjoKXssfnTZ
+625 2.60 clrWhxrSVdhpmMuoJqpr
+759 7.39 BOHgQDXUYQEZCTGJEnjm
+281 1.64 hePfEHzrcuNJCRqvBmfE
+976 6.23 hUgIipTXKSatNHGZvnPa
+192 8.69 KJPrLjSZTxZGLSogyfIl
+272 9.67 suulJBidiCsxEtsLJPXz
+784 9.82 PuOALbofWxYYAAPFpxhu
+742 0.46 lROKSHzHeEFyRPSoGGgq
+427 2.99 QGZUIpDngmQfbWdLiGgF
+431 2.85 odAeTWgMbFesukcwSGSz
+589 8.87 LaCVLltVFubMVdTsMJaw
+335 7.71 UIGNHghfqsRvvQysVnmC
+123 1.61 HfCuGmJjnqZogPANFShb
+861 2.64 kOmfuePaydwDbxqVxDkc
+313 7.93 OZERQTeZNZsVKfoDZqii
+89 4.1 WvfImSzUGnAqALNHKIje
+808 1.28 QTCKhTcIUWFaVwdwmHWC
+272 6.27 MlZrgZXkQMKRCErhnavN
+887 9.97 vksEBVPsrIjjJEzienso
+128 8.73 SAUsMljcuUHAeUpCfScF
+146 9.45 yubOLwcdxuXjREUHhszB
+133 4.92 bbqtNfbeQvPzFeKeKpNm
+920 7.8 qcADPDdxUaPRwBUNGoPe
+707 6.61 xWfsbVaPFalICCFNbNrF
+944 6.1 MKDQiwtYJJoChkYVaduo
+98 1.16 LVjBXNuotJGHfvwhbOUu
+366 6.16 JvQWxeSMZKnvCEwWfkdO
+238 6.33 cpBXyzqJdjSgtlADhYwn
+664 0.65 WKTGKRELWenQpKNbBDQa
+488 8.5 aoXWhqjECruNWEQqKogb
+841 0.98 wRvGDWDMYxYGfZNjgPLZ
+923 8.1 sWbpzsuxsygtdoGpNdmV
+762 2.73 ghtVfGPxISzriCrEcRxa
+268 6.96 eOqpdaYgWoVocwDChewK
+712 9.80 NjCCgBXbVodOHSWyQnqI
+851 7.52 NeuAPcRrdBTcGeDkPsjE
+97 6.47 bzZpgZHdpJUKQBkgspIZ
+237 9.19 WQOrhqdyoZgEVBoZtNbs
+763 5.14 LpvjSWJPvyMpPTdRIBJh
+952 3.31 wniuoanPhMZzVwGaZKQi
+145 6.55 DwWThCWXkzreoyswWOcm
+619 8.38 IcKqPCVXBefXJvEmTCWz
+894 6.24 RszFDfdThKnkAMVgWfcY
+411 4.68 MnidokwIgxwjlmDPHXbL
+976 8.66 KYwtBwvUpmFBvFmclDfB
+154 9.78 vHjmwHbimyafbDzSMGhf
+780 5.23 cmvPpbPfgnRQyIkdPxre
+776 6.72 jESxTrbGnbmrvfgVhIrm
+794 0.49 nfqmJtZtxKzszwmwFbMn
+378 2.8 APOmsppWHnyBVNaHeuis
+240 9.22 UOnvdxPLvRdkBYyYhsGx
+599 2.70 oMhMyuKEgNwLWlzuuRxj
+963 9.79 lcOnqWKoBmionyzBNQGJ
+802 0.76 vsAEnzkHaedQRrLgYYjP
+324 9.50 wXnYxuHAYLBIERYGHgXe
+311 2.38 nFKzDaDSwoYcHDDeIidT
+587 7.32 eNBSPUCRyHaQSJXsGMtl
+926 1.62 XyifJlxGaORFBsMmSgVb
+493 7.42 MoCNJnECHicCIJHTYLsD
+646 9.28 eHBRTtfBenbZIvQbEnmB
+617 8.12 MnVPUntngEgmfrfjxGcI
+376 3.0 NsSloRjlZuYLWPpyTYcx
+284 6.61 WXVHKoxNagUgsSWiaFGR
+490 6.48 DSdAOphODhVTRVNcvfPe
+959 9.22 HjrqzJycSdjEEkSeEdkb
+980 1.50 zHctjFBHUROCnUbkxQdr
+947 2.35 oDCGDOCNUDGUabOwSqCR
+158 8.92 esBpVVllfWfdPVVVSypg
+166 1.50 yfFUjRZCSppnUjxBezVy
+591 8.92 gSZzebedXBmGWKcemqol
+211 8.83 zrrpMzIscltleXtvcKsu
+287 9.11 cAzsUVnbDmJlyKGSVeES
+761 7.32 pmAfNAuNBcLceuqgLwuv
+622 9.70 wUgAVFVucWEBUNSSwkwX
+468 3.36 NYFlnMObVgutevtdPAXN
+529 4.88 WMfPZyGvaGbeoPTfuKNr
+96 6.38 PSpmPerAPtqFBjNaDpwL
+2 2.55 OjyJsmTJymhbblQDiSwd
+3 5.75 yDjwaTlyaRKztkgbUSgt
+893 2.14 slYhpTYbYlqbkLHMDKzc
+524 4.92 kDEqHUcQRAZPziLXASIL
+678 0.31 nsaLguBwtWEUFGbMYaMy
+931 7.35 KCgquCRLjyVyPIUmDEys
+867 8.29 NEPyfvcdZdWprkLEqMNe
+100 1.50 hoKqHYiYEZAwzwIrkGJj
+746 1.71 veeERjGTYnQMQfKxACdq
+826 2.59 gQnPWlEPSQXxdxEkxiDP
+539 1.14 oNmEyExhBdmaSYTJOXbS
+226 8.53 NuWtUSOpVmbgfWDdOPHp
+304 7.41 WaKFaWrBGEzySdPJToTd
+162 8.40 XNMcOPBtZHjYIebUtthr
+167 2.83 ksrspRMkuhQbQkMNXlVm
+219 5.22 rWrmTqhKWQnzBxUOqKdk
+181 3.25 qTtVLsHSJTgJELIniLrt
+755 8.17 xPIgwGOnubwThOAgvxRX
+907 3.80 zCEtnyUMjVYXDIdtjKqS
+882 1.54 QwgLYXxcXuUhDdkxpmPy
+407 8.36 sBebgTdBqvhKfbAqcJXJ
+86 8.21 WUNPBlKGYncVtjNmiEku
+640 0.94 FZaXSveJfSKlJGVqJshL
+924 2.48 TrCAiDQDiBPtgiCeRWFN
+709 6.23 IkkmqxxunVSibSDANfEi
+702 1.6 BLTNhNPDXUnaelUaMKsQ
+656 5.75 iSRsERaxJgmTIyqlOXfR
+64 7.5 NfrqpSzDSrFnWNabmZtZ
+561 6.52 BfdQGsXJJamhbGRmnZhF
+838 9.27 gwzhOPbcHIrKlYyzylmp
+594 3.8 zdhWVEpVkryRDDziblRT
+431 6.68 nrWaEHIpEZqNVdrduveT
+585 0.2 BLznkxwXmLmFAqTXtsLG
+793 7.48 UydrggvJOmMngnjiyGby
+711 2.6 BRQCFFLDGHmOjcCoZVeE
+963 3.2 dYVgFIyykHShyyEWlwyq
+699 5.90 MXmxYHqCPQTyfHjoWXNt
+357 1.0 vcMBeilpEQVqWpWxuFPn
+874 7.58 fgTKOTitYQwtxjyVheMi
+657 1.56 dlGmCjxHTCEYhkqTcZqy
+996 4.25 mFOHRuoWHrCZbqQuQWee
+752 5.3 HPgaHJLRLTbdAqjfxrVD
+14 6.28 hrvSDSigoTaoVrdvkIjz
+978 7.12 qpYUewhHKGWgFYGHCKsl
+803 8.5 KmirXHpYJFjrSUsprByY
+794 4.8 PnirpkAFxPhXUKaRfFSh
+255 9.16 VwMUqvdgbDiJuuuffkZA
+576 6.63 uKxSaObMYAFWczMCcCeh
+501 3.73 nvrjpZJXxVhHlnVRUBCg
+747 4.77 GbkUyqSSwzRkbpRbVgUT
+398 5.61 ZOnSftpAIYHsNrNXoRbn
+457 0.56 lojBbBLzQYhGLhhmihVm
+112 2.74 nfFoaFmQOwtmxQApohmS
+586 7.25 HgLCKFiBvRwbpxSrAiNz
+492 5.89 vDZnaFenpXvBLQrTdVEC
+516 9.73 biXEfEzupaXgYYSGJEvj
+464 5.3 mOxzsvtZMJXVydfYvwQt
+912 7.33 hWoSuRVMPWUxLGYeHKWT
+498 8.44 csEBPlIuKcPLYqFpgvPo
+317 9.90 xjmCWWuJVyyZLJWitSJu
+449 8.45 lbOTYARhIKjsvZrJDDLc
+535 4.71 xNsPAvTVOJOTpbGYcaEj
+852 2.64 gnlfHhaGDbesWXHqERdF
+304 9.69 ZrHCaNXDmQybfSYrvTVw
+710 3.79 dRCihjVEcQxXJWqMDxeo
+773 2.1 jJdelWwqPoqWfTmWGsZk
+991 1.19 NjyCjfpFZupBOpetsrAx
+507 9.34 WMiiOWvifiwGeyPfNYED
+358 4.97 DhZcLFRhigrudPVyhnCq
+662 3.98 vTXayBmDNqzJlYyfWZNt
+507 7.75 YyOLbYGdMzcWLpUEMktX
+738 8.59 HVANysGlgsFYYENRBJLv
+295 8.82 ySqHYVFtksJmfZxZxIKy
+984 1.64 SZiTCEsSQYPwEKGrUzXq
+949 7.86 yxuIlvnpyHhwgSYCqfzG
+168 7.18 lUULhUneHMLZQSAUHBTo
+938 2.59 hkNHgcCmoyCsEkNcpXHe
+878 1.22 IMlcVToHOvtQoAKtOAOZ
+824 8.25 nWoHoqzsqrgmPMHhhBvp
+677 8.81 GFlSdWJwuDbhibVxcJIe
+754 0.79 lswvYmUipujZGssasZZs
+875 3.83 aIiDifayDeyznpPAyDRg
+565 5.23 unkzeWMvdDSFoMzpIlZO
+120 9.83 gLDFeShLWfyYDoQfCSZM
+65 5.57 zxGFAuwltfPNhmLXwGvq
+605 6.72 FyjqLLXbmnUFQIifLGDl
+962 5.64 FgGVEHmXtWbTjqlpXrZR
+687 2.5 OXpbxAdsZzKcozqKashw
+652 6.52 EOzUuWTiGudFkdfgvJPx
+223 7.89 eXRuLdrMRislqVSPrOPN
+825 7.96 wRFENOLBcgIggYOGVxdG
+8 9.47 cjhAxVamOWsSdoQNKLqn
+153 1.80 BVUyTTLXHmVldMLlywag
+554 9.41 RDqlVDVrrKkEeZOWHONI
+873 7.7 QriNidzzaKAwEMcrBRxG
+726 5.49 YWvtTmqjSduziEzYjDPa
+945 2.38 hIybylnSCPmHuEalnKfF
+348 3.53 oSTjhbXyDhDYPriXkdAa
+477 3.27 uwYAVKhGuNqrASpWjbhS
+493 6.14 CVDcxFbnNZDykZFEOxKq
+150 9.65 PvptXpcHWiOOOpcAlfUI
+752 6.39 ouXYOzGCgKBPjscsJgtI
+979 0.92 SPUtqGnWEnRUqggexxLf
+394 9.66 tkgzNvlNjKhGxjQHqMTn
+812 1.87 ytfRgWZTrXsCbKsMaDEm
+75 8.9 gTRNMbGxyLbKegeBqCbk
+60 2.59 LchJepJVTxDkSNSCBjwG
+87 9.14 pAYJtODZsmItUEbKEHPq
+214 8.69 MDODqGCuZbSIecdcNRjh
+444 8.64 uQLEcXkaAszAuXtekKYW
+273 3.67 caQpkUCIMRhADFxHOJdY
+946 1.24 KHRszujDHEqzDWiNbUqn
+459 3.0 CMVIjthRPWCGRriRPQNN
+838 3.11 jdoZfKkpspAMQDcCHfSO
+147 1.18 eWcCpPBfxtvbaKguEOgL
+250 2.65 NlstFbCiVIsbFLSsvXyF
+218 5.64 EBmbDNcybbLkgDoQyAPX
+155 5.94 hqISVwRJGGcUpPsogHEp
+757 2.15 qyZiYrZQPLbfEeeVwxbM
+808 8.64 sQkcXHKphTqmbeMoQyKd
+611 9.94 vANiaAgfgJyRIQhLzjhq
+901 5.89 RtElsqTRXOrJfEYyTHNC
+907 2.16 IAcqfqbLpIvXlIMbWFIh
+599 6.1 uQLFvJlcZYQVNFKVkEOl
+375 6.75 sPKkvIqNzbcnlzStgfeg
+804 3.8 qCsreKtxOTTKwbpOCcXm
+315 3.54 WnlQWsOVYUbosaOLOPQt
+855 1.54 OVYVpZRzjEDJrOMibrSI
+114 6.19 xnhCusHcpzhKmNNzXMDD
+215 0.76 DFBElSengQCWWCKGTmeR
+268 3.28 PmfavTNRPYZgNUCZivBI
+544 5.53 ZDlQMLtDYNCOtbKWDgOp
+120 8.8 vrjDnCVyugNDsKiAYpjX
+162 9.85 cAyOTlMgPyJCqigjhHoM
+117 4.20 UKURKmjuQxiYkZbrUOiX
+972 8.10 ClTGSsUJebREwBUInuTy
+772 7.44 lNsiOPZvYqshrPZFnxjC
+808 1.33 laWEnkkaRHhnTFPWSRss
+262 9.91 EDcVzMXlCgVQtaCeEcfP
+702 9.0 rpkEwhnPzbQWRntwGXAM
+700 6.52 lzFVaxgJMJOuQylTAUUs
+929 5.58 irxLUjAYvhflrKcepdWv
+386 7.37 bHxOrDcXxHgCpswxzeRS
+946 7.10 mjBaKAnepQGhMbykfSpq
+24 0.72 NTcNpjIWpboDmCRCLxkk
+997 9.97 HkufAuDNOGmetgsgwKIF
+691 1.91 qRuqQGMxObGGbyQhOuym
+201 1.78 lJNeEOeENEiQTAJOMtWZ
+932 1.63 gssjKuuiBWeKuyPZlXYv
+496 6.70 BpXVgtsjPcJKnxoTVgzP
+511 2.65 ZhCPNTqiSrZZYwnmIcMz
+749 5.45 CriuhVmUitYuLKqVGeeM
+652 3.73 JrDrGnOTHMIYgYKPKxqC
+913 2.81 sRivrqAHczXCbGLjuWiA
+723 7.70 TVolfTbnDLkMksYKwJwp
+821 4.13 PgplIumUlymWWvHXFaBU
+613 0.8 VAonZFIjlIYyyaZkjLUV
+735 5.5 ipAtfieINhaqoTCfRuMB
+79 3.90 hnFEUemQmwYOIsNsTnWP
+703 4.72 pOkbGLDqEmkOaUhtnFaJ
+775 3.29 kijKDMPrtLoDPQDPPdzm
+258 4.63 IQhyQMOQkdLgqHwsyBQF
+800 0.26 gaozoumOTyvzXPlpmDgv
+766 7.3 AjwjksjnSKpZHMtwrzZP
+440 0.3 BiChKYZUvwbTQOCmgunV
+53 9.77 gVUfBCuOjRwNTSDhZDme
+32 9.47 ifzLoYCDjXcYHbbVyvww
+749 0.58 dipSHODvHkBzMTiVKcvY
+285 5.31 ygoSgfRXudzxmsqNBkEZ
+141 1.89 AAFopiHBwWYUPjRHuWZw
+248 5.12 KFxTsNEWrMPlCKJIkGum
+641 4.67 TojOvtPpaqetlWlpMwcd
+649 1.28 ywUnZMHscsXVfAVnxpuq
+774 5.4 QProygQPJTBuvQwutgVI
+209 2.60 ZbBaaYLvQGfKtuzTSUVt
+860 7.59 zmpTjLLVvRjJkfpSCOWW
+957 3.87 dKkAuKAaXEgKaMjkDagl
+412 4.31 VxAVuOKMQYEJMOIztvOW
+930 4.98 lNSgzbFMpKXyAmKcUhPo
+860 9.20 NAQYwxbDUXYuZDGtAwFM
+846 7.85 NSiFtFPljAAPIRSKrXgy
+819 0.33 RVxYhzUvdNprbqrsnjzz
+192 6.23 XCuUdIbEpjprxcQzTtkz
+446 3.64 tWiNzVnUFwNtaKCbyRHA
+452 1.48 BpBbfkMXYcGhLwtogNCN
+580 1.56 tseDNgBeKsRorIWkfrRo
+823 5.32 CaEbQLnvKKttrComiNct
+776 7.79 htvnWLZUPHoCMkCjFTqa
+107 8.55 wUZTOVqWLcqWaShSWxrr
+122 5.35 BipUWzNXtkrWhEcMebjN
+303 5.59 AmfLvEqQeRwGbZmLrVfS
+262 4.38 GSwTRNmMYBOFvAlLxBdw
+812 6.54 OvfIaKsMVvLnrkNEONQp
+980 6.67 bVglLpqYKQAjEuMTwTdk
+98 6.21 rFDMoKNLdhnDdAgTTgAe
+91 8.11 WTaActKUdEikgQxNlZNC
+283 3.62 tkHGYDapLUWEKShowzre
+301 8.81 weLWvyBPDBcVNsVhkTgx
+764 8.98 luWWpGgxEbsEndwRSSoC
+976 0.4 myMJoqbDaleEXfDhDuJh
+334 1.63 VpFHTtsUWyeIDmTPRCdN
+879 5.64 FeMEZpbfGcJatvxvXvvG
+458 3.58 PZbWWATDgivhdQQBycoS
+389 3.79 YQTPfQdrfOqYZETgLmMW
+969 8.82 jEwGRRFhFrIssnQvQfvC
+880 3.81 hAYIuvNZMHxYckABDlOh
+482 0.15 xZSzCFAIAnZPprYxFtpO
+315 8.48 kwNiyIFCiILOkaRXyKpm
+972 2.10 fgbcTJkoRRNsALhHwngZ
+906 8.97 IdtZEgnFNzmtsEAicYlm
+153 7.28 QBMGyWImeRrrEKEtdMYk
+725 1.11 ABKrNPrTXbVbQYfZRdVG
+246 7.84 BfGyFnjQkPRmbbNWUCgT
+210 4.93 EveCQKDDLMXOzntjTmsW
+513 1.0 BNLtwyvUlLuJxUrEdZaf
+636 5.41 DLLkJtXfIXCAXCEbwJIw
+252 1.28 MOojcVHswqSQxYIBOfAo
+768 7.49 usFqWGXJdkMbMVXRYebk
+235 6.64 bQtTNXELHzpFStdtlwRt
+458 6.47 nBNgHCfoHHegbKFMEAEl
+291 2.20 wYUySuiufmsRWfwQrMfj
+212 4.30 TeUuWTTXzjhpEOoUFdCw
+67 9.4 HbMUofhJJbzIuujOEszx
+211 8.80 lUrYCeAhPUNbhOMGzSVs
+75 7.30 SFUoPFeFUCpLnSVsPGrI
+895 6.50 RdDUXXzeYdaVYSVcENHA
+484 7.96 UJNdoiiatlqTfjAihsXE
+774 6.8 amkNaHVMzbsbaJtNsNLp
+960 9.45 MwIGIBdfGSHSLOMhNdFA
+613 3.27 jLizwWOcZiwBECMDhaLS
+198 6.8 aQFgqrbjjCYKxVElbPix
+763 0.32 NpuoPFLKBkkJxpaZHVDP
+233 0.91 jTzFaWskVbkNlwWMmvDp
+474 2.73 NIfjcrWlJSAEhtAJPBsM
+241 9.62 elsjNxvuxGKyZRwNHTvq
+685 9.11 ctjuXmvjOWOqcHVEIEzT
+797 0.35 apvUfTtJMDKaHNCZzLyA
+405 1.57 KwjnJCmTlzUYoXsXEReA
+344 8.60 XyvChRXhioGEsAGKDKZS
+256 6.73 ovrqINvYzNaTHyZuBGMZ
+364 1.3 CWVleOfvIkiaPqUZyJdK
+845 6.16 xrqIYWdMJJMskdxaMWhZ
+974 6.14 JFjbDNpaYLtvgbtItCQZ
+819 2.40 CdrkqWiCUnMQOVjZFwey
+285 7.26 NKHuZkNUlIfzoGhvGZNQ
+435 6.81 DiieFEAIbWGMhrdRaPRR
+960 1.90 nXOfUqZzHriiPAzqXlmY
+518 8.40 yMXUXKrBfCYOphxlWQmZ
+599 2.18 VWaVlkkHXNXQssoiVolb
+544 5.8 MAicdYDIxNbRpfGuHspL
+933 1.67 ZFFUKAsVWEOjbpiwIsSD
+547 4.65 YwUJBSJdKNbJfIMSqQJk
+185 5.62 qmEnfTsRUFqJHeeBijsQ
+798 7.69 EWqDLYUJwrumsCSTjtMz
+963 3.69 jwwOloyGyrSEojGfuthl
+527 8.81 yNqQBCxVnINNBrymFAcG
+615 6.42 pqVBjvmIvOLNLXZrqEVa
+564 8.79 PvjyJclAHPjaOGoTJwVc
+476 2.53 ivYxeUzAMEKUEQhqupID
+775 8.79 JQVhTQcIMJxgvcpsveFB
+356 8.51 hOCxGmnEdnrYcKZPxeTl
+933 6.38 HyYEXxNvQIUBgtAqiHqP
+734 1.25 KUjasKiikmTbOtfqTbFR
+522 8.45 WamSGQZFHlSVurtwNRxm
+878 3.34 ldCMEyyYjOqIKpvlIrSM
+973 0.81 ynUbpbUhuzGREmfJpUGo

=== added file 'plugin/filesystem_engine/tests/t/select_big_file.test'
--- plugin/filesystem_engine/tests/t/select_big_file.test	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/select_big_file.test	2010-07-30 13:27:46 +0000
@@ -0,0 +1,9 @@
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+CREATE TABLE t1 (c1 INT, c2 DECIMAL(3, 2), c3 VARCHAR(20)) ENGINE=FILESYSTEM,FILE="../filesystem_ln/select_big_file.data";
+
+SELECT * FROM t1;
+
+DROP TABLE t1;

=== added file 'plugin/filesystem_engine/tests/t/select_chop_line-master.opt'
--- plugin/filesystem_engine/tests/t/select_chop_line-master.opt	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/select_chop_line-master.opt	2010-07-30 13:27:46 +0000
@@ -0,0 +1,1 @@
+--plugin_add=filesystem_engine

=== added file 'plugin/filesystem_engine/tests/t/select_chop_line.data'
--- plugin/filesystem_engine/tests/t/select_chop_line.data	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/select_chop_line.data	2010-07-30 13:27:46 +0000
@@ -0,0 +1,4 @@
+618 9.60 LSkNQAZjODwYvOYUeAVb uncessary junk characters
+847 2.60 yphkuCaGsgbReRQTcUob test this also
+814 3.25 rJDEnFNRTVftDpWPLeRa in create table only two fields
+571 4.84 bjQkbVIPlNmlHpKvDBVv

=== added file 'plugin/filesystem_engine/tests/t/select_chop_line.test'
--- plugin/filesystem_engine/tests/t/select_chop_line.test	1970-01-01 00:00:00 +0000
+++ plugin/filesystem_engine/tests/t/select_chop_line.test	2010-07-30 13:27:46 +0000
@@ -0,0 +1,9 @@
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+CREATE TABLE t1 (c1 INT, c2 DECIMAL(3, 2)) ENGINE=FILESYSTEM,FILE="../filesystem_ln/select_chop_line.data";
+
+SELECT * FROM t1;
+
+DROP TABLE t1;