Sun Microsystems 5800 Examples of Supported Query Expressions, Queries Not Supported in Version

Queries Not Supported in Version 1.1

Examples of Supported Query Expressions

■{fn LCASE(mp3.artist)} LIKE ’%floyd%’ AND system.object_size > 2000000

■(object_size < 200) OR "Collation" = ’en-US’

■{fn TIMESTAMPDIFF(SQL_TSI_YEAR, system.test.type_timestamp, ’2007-04-02 01:50:50.999’)} < 3

■{fn TIMESTAMPADD(SQL_TSI_YEAR, 2, system.test.type_timestamp )} > ’2007-04-03 01:50:50.999’

Queries Not Supported in Version 1.1

The following JDBC escapes are not supported:

■CHAR(code)

■INSERT(string1, start, length, string2)

■LEFT(string, count)

■REPEAT(string, count)

■REPLACE(string1, string2, string3)

■RIGHT(string, count)

■SPACE(count)

■ROUND(value, number)

■TRUNCATE(value, number)

■POWER(value, power)

■ACOS(float)

■ASIN(float)

■ATAN(float)

■ATAN2(float1, float2)

■CEILING(number)

■COS(float)

■COT(float)

■DEGREES(number)

■EXP(float)

■FLOOR(number)

■LOG(float)

■LOG10(float)

■ASCII(string)

■MOD(float1, float2)

■PI()

■POWER(number, power)

■RADIANS(number)

■RAND(integer)

■SIGN(number)

Chapter 4 • Sun StorageTek 5800 System Query Language 123