6 # Check that conflicting unique IDs triggers failover to alternative query
13 Tmp-String-0 := "%{sql:DELETE FROM radacct WHERE AcctSessionId = '00000001'}"
23 # Insert the Accounting-Request start
34 # Check the database has at least one row
37 Tmp-Integer-0 := "%{sql:SELECT count(*) FROM radacct WHERE AcctSessionId = '00000001'}"
39 if (!&Tmp-Integer-0 || (&Tmp-Integer-0 != 1)) {
47 # Check acctsessiontime matches the value in the request
50 Tmp-Integer-0 := "%{sql:SELECT acctsessiontime FROM radacct WHERE AcctSessionId = '00000001'}"
52 if (!&Tmp-Integer-0 || (&Tmp-Integer-0 != 0)) {
60 # Change acctsessiontime and verify it's updated
63 Connect-Info = 'updated'
73 Tmp-String-0 := "%{sql:SELECT connectinfo_start FROM radacct WHERE AcctSessionId = '00000001'}"
75 if (!&Tmp-Integer-0 || (&Tmp-String-0 != 'updated')) {