2 @message |
assert
Select Expression
-> Aggregate
-> Table "TEST" Full Scan
+ 2024-05-12T18:40:41.8440 (2548924:0x7fbbd151bdc0) PREPARE_STATEMENT
+ /var/tmp/fbqa/test_1860/test.fdb (ATT_9, SYSDBA:NONE, NONE, TCPv4:127.0.0.1/16012)
+ /home/fbqa/qa-2024/unpacked-snapshot.tmp/bin/isql:2548921
+ (TRA_7, READ_COMMITTED | NO_REC_VERSION | WAIT | READ_WRITE)
+ Statement 25:
+ -------------------------------------------------------------------------------
+ select count(*) from test
+ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
+ Select Expression
+ -> Aggregate
+ -> Table "TEST" Full Scan
LOG DETAILS:
2024-05-12 19:15:52.342
2024-05-12 19:15:52.348 act = <firebird.qa.plugin.Action object at [hex]>
2024-05-12 19:15:52.353 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2024-05-12 19:15:52.358
2024-05-12 19:15:52.365 @pytest.mark.version('>=3.0')
2024-05-12 19:15:52.370 def test_1(act: Action, capsys):
2024-05-12 19:15:52.377 with act.trace(db_events=trace):
2024-05-12 19:15:52.381 act.isql(switches=[], input='select count(*) from test;')
2024-05-12 19:15:52.387 # Process trace
2024-05-12 19:15:52.391 show_line = 0
2024-05-12 19:15:52.396 for line in act.trace_log:
2024-05-12 19:15:52.401 show_line = (show_line + 1 if ('^' * 79) in line or show_line>0 else show_line)
2024-05-12 19:15:52.406 if show_line > 1:
2024-05-12 19:15:52.411 print(line)
2024-05-12 19:15:52.416 # Check
2024-05-12 19:15:52.420 act.expected_stdout = expected_stdout
2024-05-12 19:15:52.425 act.stdout = capsys.readouterr().out
2024-05-12 19:15:52.429 > assert act.clean_stdout == act.clean_expected_stdout
2024-05-12 19:15:52.434 E assert
2024-05-12 19:15:52.438 E Select Expression
2024-05-12 19:15:52.442 E -> Aggregate
2024-05-12 19:15:52.447 E -> Table "TEST" Full Scan
2024-05-12 19:15:52.452 E + 2024-05-12T18:40:41.8440 (2548924:0x7fbbd151bdc0) PREPARE_STATEMENT
2024-05-12 19:15:52.458 E + /var/tmp/fbqa/test_1860/test.fdb (ATT_9, SYSDBA:NONE, NONE, TCPv4:127.0.0.1/16012)
2024-05-12 19:15:52.463 E + /home/fbqa/qa-2024/unpacked-snapshot.tmp/bin/isql:2548921
2024-05-12 19:15:52.468 E + (TRA_7, READ_COMMITTED | NO_REC_VERSION | WAIT | READ_WRITE)
2024-05-12 19:15:52.473 E + Statement 25:
2024-05-12 19:15:52.478 E + -------------------------------------------------------------------------------
2024-05-12 19:15:52.483 E + select count(*) from test
2024-05-12 19:15:52.488 E + ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-05-12 19:15:52.493 E + Select Expression
2024-05-12 19:15:52.497 E + -> Aggregate
2024-05-12 19:15:52.502 E + -> Table "TEST" Full Scan
2024-05-12 19:15:52.507
2024-05-12 19:15:52.512 tests/bugs/core_4451_test.py:50: AssertionError
2024-05-12 19:15:52.517 ---------------------------- Captured stdout setup -----------------------------
2024-05-12 19:15:52.522 Cached db: db-12.0-None-None-NONE.fdb [page_size=None, sql_dialect=None, charset='NONE'
|
3 #text |
act = <firebird.qa.plugin.Action pytest object at [hex]>
capsys = <_pytest.capture.CaptureFixture pytest object at [hex]>
@pytest.mark.version('>=3.0')
def test_1(act: Action, capsys):
with act.trace(db_events=trace):
act.isql(switches=[], input='select count(*) from test;')
# Process trace
show_line = 0
for line in act.trace_log:
show_line = (show_line + 1 if ('^' * 79) in line or show_line>0 else show_line)
if show_line > 1:
print(line)
# Check
act.expected_stdout = expected_stdout
act.stdout = capsys.readouterr().out
> assert act.clean_stdout == act.clean_expected_stdout
E assert
E Select Expression
E -> Aggregate
E -> Table "TEST" Full Scan
E + 2024-05-12T18:40:41.8440 (2548924:0x7fbbd151bdc0) PREPARE_STATEMENT
E + /var/tmp/fbqa/test_1860/test.fdb (ATT_9, SYSDBA:NONE, NONE, TCPv4:127.0.0.1/16012)
E + /home/fbqa/qa-2024/unpacked-snapshot.tmp/bin/isql:2548921
E + (TRA_7, READ_COMMITTED | NO_REC_VERSION | WAIT | READ_WRITE)
E + Statement 25:
E + -------------------------------------------------------------------------------
E + select count(*) from test
E + ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
E + Select Expression
E + -> Aggregate
E + -> Table "TEST" Full Scan
tests/bugs/core_4451_test.py:50: AssertionError
|