~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/transaction_log/tests/r/transaction_log_data_type.result

Committer: Brian Aker
Date: 2011-01-20 06:31:31 UTC
mto: This revision was merged to the branch mainline in revision 2098.
Revision ID: brian@tangent.org-20110120063131-zxb0w5iwfhxn37zb

Place limits on timestamp (unforunatly)

files modified:
drizzled/calendar.cc

drizzled/calendar.h

drizzled/function/time/from_unixtime.cc

drizzled/type/time.cc

drizzled/type/time.h

plugin/transaction_log/tests/r/transaction_log_data_type.result

plugin/transaction_log/tests/t/transaction_log_data_type.test

tests/r/func_time.result

tests/r/timezone.result

tests/suite/microtime_type/r/max.result

tests/suite/microtime_type/t/max.test

tests/t/func_time.test

tests/t/timezone.test

Show diffs side-by-side

added added

removed removed

plugin/transaction_log/tests/r/transaction_log_data_type.result

3460

3461

Testing MAX+1 TIMESTAMP

3462

INSERT INTO t1 (b) VALUES('2038-01-19 03:14:08');

3463

ERROR HY000: Received an invalid timestamp value '2038-01-19 03:14:08'.

3463

3464

Check transaction_log_entries

3464

3465

SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;

3465

3466

COUNT(*)

3466

3467

3468

3469

Check transaction_log_transactions

3469

3470

SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;

3470

3471

COUNT(*)

3471

3472

3473

Check transaction log contents

3473

3474

SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));

3474

3475

PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))

3500

3501

segment_id: 1

3501

3502

end_segment: true

3502

3503

record {

3503

insert_value: "3"

3504

insert_value: "2038-01-19 03:14:08"

3504

insert_value: "2"

3505

insert_value: "2038-01-19 03:14:07"

3505

3506

is_null: false

3506

3507

is_null: false

3507

3508

}

3517

3518

Check transaction_log_entries

3518

3519

SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;

3519

3520

COUNT(*)

3520

3521

3522

3523

Check transaction_log_transactions

3523

3524

SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;

3524

3525

COUNT(*)

3525

3526

3527

Check transaction log contents

3527

3528

SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));

3528

3529

PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))

3554

3555

segment_id: 1

3555

3556

end_segment: true

3556

3557

record {

3557

insert_value: "4"

3558

insert_value: "3"

3558

3559

insert_value: "2000-01-01 12:15:59"

3559

3560

is_null: false

3560

3561

is_null: false

3571

3572

Check transaction_log_entries

3572

3573

SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;

3573

3574

COUNT(*)

3574

3575

3576

3577

Check transaction_log_transactions

3577

3578

SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;

3578

3579

COUNT(*)

3579

3580

3581

Check transaction log contents

3581

3582

SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));

3582

3583

PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))

3608

3609

segment_id: 1

3609

3610

end_segment: true

3610

3611

record {

3611

insert_value: "5"

3612

insert_value: "4"

3612

3613

insert_value: "1999-06-01 12:15:47"

3613

3614

is_null: false

3614

3615

is_null: false

3625

3626

Check transaction_log_entries

3626

3627

SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;

3627

3628

COUNT(*)

3628

3629

3630

3631

Check transaction_log_transactions

3631

3632

SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;

3632

3633

COUNT(*)

3633

3634

3635

Check transaction log contents

3635

3636

SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));

3636

3637

PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))

3662

3663

segment_id: 1

3663

3664

end_segment: true

3664

3665

record {

3665

insert_value: "6"

3666

insert_value: "5"

3666

3667

insert_value: ""

3667

3668

is_null: false

3668

3669

is_null: true

3680

3681

Check transaction_log_entries

3681

3682

SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;

3682

3683

COUNT(*)

3683

3684

3685

3686

Check transaction_log_transactions

3686

3687

SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;

3687

3688

COUNT(*)

3688

3689

3690

Check transaction log contents

3690

3691

SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));

3691

3692

PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))

3717

3718

segment_id: 1

3718

3719

end_segment: true

3719

3720

record {

3720

insert_value: "6"

3721

insert_value: "5"

3721

3722

insert_value: ""

3722

3723

is_null: false

3723

3724

is_null: true

3735

3736

Check transaction_log_entries

3736

3737

SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;

3737

3738

COUNT(*)

3738

3739

3740

3741

Check transaction_log_transactions

3741

3742

SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;

3742

3743

COUNT(*)

3743

3744

3745

Check transaction log contents

3745

3746

SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));

3746

3747

PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))

3772

3773

segment_id: 1

3773

3774

end_segment: true

3774

3775

record {

3775

insert_value: "6"

3776

insert_value: "5"

3776

3777

insert_value: ""

3777

3778

is_null: false

3778

3779

is_null: true

3790

3791

Check transaction_log_entries

3791

3792

SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;

3792

3793

COUNT(*)

3793

3794

3795

3796

Check transaction_log_transactions

3796

3797

SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;

3797

3798

COUNT(*)

3798

3799

3800

Check transaction log contents

3800

3801

SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));

3801

3802

PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))

3827

3828

segment_id: 1

3828

3829

end_segment: true

3829

3830

record {

3830

insert_value: "6"

3831

insert_value: "5"

3831

3832

insert_value: ""

3832

3833

is_null: false

3833

3834

is_null: true

Older »