~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/transaction_log/tests/t/transaction_log_data_type.test

  • Committer: Andrew Hutchings
  • Date: 2011-02-07 17:20:59 UTC
  • mfrom: (2148 staging)
  • mto: (2148.2.3 build)
  • mto: This revision was merged to the branch mainline in revision 2149.
  • Revision ID: andrew@linuxjedi.co.uk-20110207172059-dyeahrgzrlincoe3
Merge with trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
188
188
--echo
189
189
 
190
190
--echo Testing misc DECIMAL simple2
191
 
--ERROR 1265 
 
191
--ERROR ER_WARN_DATA_TRUNCATED
192
192
INSERT INTO t1 (b) VALUES(.0898);
193
193
--source ../plugin/transaction_log/tests/t/check_transaction_log.inc
194
194
--echo
238
238
--echo
239
239
 
240
240
--echo Testing BAD INPUT FLOAT simple
241
 
--ERROR 1265
 
241
--ERROR ER_WARN_DATA_TRUNCATED
242
242
INSERT INTO t1 (b) VALUES('abbazabba');
243
243
--source ../plugin/transaction_log/tests/t/check_transaction_log.inc
244
244
--echo
306
306
--echo
307
307
 
308
308
--echo Testing BAD INPUT ENUM simple
309
 
--ERROR 1691 
 
309
--ERROR ER_INVALID_ENUM_VALUE
310
310
INSERT INTO t1 (b) VALUES(6);
311
311
--source ../plugin/transaction_log/tests/t/check_transaction_log.inc
312
312
--echo
618
618
--echo
619
619
 
620
620
--echo Testing MAX DECIMAL + 1
621
 
--ERROR 1264
 
621
--ERROR ER_WARN_DATA_OUT_OF_RANGE
622
622
INSERT INTO t1 (b) VALUES (999999999999999999999999999999999999999999999999999999999999999990);
623
623
--source ../plugin/transaction_log/tests/t/check_transaction_log.inc
624
624
--echo
645
645
--echo
646
646
 
647
647
--echo Too long value
648
 
--ERROR 1265
 
648
--ERROR ER_WARN_DATA_TRUNCATED
649
649
INSERT INTO t1 (b) VALUES (99999999999999999999999999999999999.9999999999999999999999999999991);
650
650
--source ../plugin/transaction_log/tests/t/check_transaction_log.inc
651
651
--echo