2012-02-28 * Test 1
    E               20.00 EUR
    F

2012-02-29 * Test 2
    Test            10.01 EUR
    F

2012-03-24 Test 3
    C               30.00 EUR
    D

2012-03-25 (test) Test 4
    ; Payee: Test 5
    E               40.00 GBP
    F

test select "date, account, amount" from posts
12-Feb-28 E                                                           20.00 EUR
12-Feb-28 F                                                          -20.00 EUR
12-Feb-29 Test                                                        10.01 EUR
12-Feb-29 F                                                          -10.01 EUR
12-Mar-24 C                                                           30.00 EUR
12-Mar-24 D                                                          -30.00 EUR
12-Mar-25 E                                                           40.00 GBP
12-Mar-25 F                                                          -40.00 GBP
end test

test select "date, account, amount from posts where account =~ /^e/"
12-Feb-28 E                                                           20.00 EUR
12-Mar-25 E                                                           40.00 GBP
end test

test select "date, account, amount from posts where account =~ /e/"
12-Feb-28 E                                                           20.00 EUR
12-Feb-29 Test                                                        10.01 EUR
12-Mar-25 E                                                           40.00 GBP
end test

; leave out "from posts" since it is the default
test select "date, account, amount where account =~ /e/"
12-Feb-28 E                                                           20.00 EUR
12-Feb-29 Test                                                        10.01 EUR
12-Mar-25 E                                                           40.00 GBP
end test

test select "date, payee, amount from posts where account =~ /e/ and commodity =~ /GBP/"
12-Mar-25 Test 5                                                      40.00 GBP
end test

test select "date, payee, amount * 2 from posts where account =~ /e/ and commodity =~ /GBP/"
12-Mar-25 Test 5                                                      80.00 GBP
end test

test select "date, code, amount from posts where account =~ /e/ and commodity =~ /GBP/"
12-Mar-25 test          40.00 GBP
end test

test select "date, code * 2, amount from posts where account =~ /e/ and commodity =~ /GBP/"
12-Mar-25 testtest      40.00 GBP
end test