← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/schema_dictionary/tests/t/schema_version.test

  • Committer: lbieber
  • Date: 2010-10-06 02:01:43 UTC
  • mfrom: (1814.1.1 build)
  • Revision ID: lbieber@orisndriz08-20101006020143-gho0wsmd346m02f9
Merge Brian - fix bug 654905 - DATA_DICTIONARY.TABLE.TYPE not returning BASE or VIEW (it reports the port type).

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/schema_dictionary/tests/t/schema_version.test
 
1
# We test that version increments, and that when dropped version number is
 
2
# not reused. Along the way, we make sure UUID is stable;
 
3
CREATE SCHEMA version_test;
 
4
SELECT SCHEMA_VERSION FROM DATA_DICTIONARY.SCHEMAS WHERE SCHEMA_NAME="version_test";
 
5
 
 
6
SELECT SCHEMA_UUID INTO @current_schema_uuid FROM DATA_DICTIONARY.SCHEMAS WHERE SCHEMA_NAME="version_test";
 
7
 
 
8
ALTER SCHEMA version_test COLLATE = "utf8_persian_ci";
 
9
SELECT SCHEMA_VERSION FROM DATA_DICTIONARY.SCHEMAS WHERE SCHEMA_NAME="version_test";
 
10
 
 
11
SELECT COUNT(*) FROM DATA_DICTIONARY.SCHEMAS WHERE SCHEMA_UUID = @current_schema_uuid;
 
12
 
 
13
ALTER SCHEMA version_test COLLATE = "utf8_persian_ci";
 
14
SELECT SCHEMA_VERSION FROM DATA_DICTIONARY.SCHEMAS WHERE SCHEMA_NAME="version_test";
 
15
 
 
16
SELECT COUNT(*) FROM DATA_DICTIONARY.SCHEMAS WHERE SCHEMA_UUID = @current_schema_uuid;
 
17
 
 
18
DROP SCHEMA VERSION_test;
 
19
SELECT SCHEMA_VERSION FROM DATA_DICTIONARY.SCHEMAS WHERE SCHEMA_NAME="version_test";
 
20
 
 
21
CREATE SCHEMA version_test;
 
22
SELECT SCHEMA_VERSION FROM DATA_DICTIONARY.SCHEMAS WHERE SCHEMA_NAME="version_test";
 
23
 
 
24
# Just make sure UUID is not reused.
 
25
SELECT COUNT(*) FROM DATA_DICTIONARY.SCHEMAS WHERE SCHEMA_UUID = @current_schema_uuid;
 
26
 
 
27
DROP SCHEMA VERSION_test;