<commit_before>--TEST--
Test parametrized insert and sql_variant as an output parameter.
--DESCRIPTION--
parameterized queries is not supported for Sql_Variant columns, this test, verifies a proper error message is returned  
--FILE--
﻿<?php
include 'MSCommon.inc';

function TestReverse($conn)
{
    $procName = GetTempProcName('sqlReverse');

    try
    {
        $spCode = "CREATE PROC [$procName] @string AS SQL_VARIANT OUTPUT as SELECT @string = REVERSE(CAST(@string AS varchar(30)))";

        $stmt = $conn->exec($spCode);
    }
    catch (Exception $e)
    {
        echo "Failed to create the reverse procedure\n";
        echo $e->getMessage();
    }        
    
    try<commit_msg>fixed typo<commit_after>--TEST--
Test parametrized insert and sql_variant as an output parameter.
--DESCRIPTION--
parameterized queries is not supported for Sql_Variant columns, this test, verifies a proper error message is returned  
--FILE--
﻿<?php
include 'MsCommon.inc';

function TestReverse($conn)
{
    $procName = GetTempProcName('sqlReverse');

    try
    {
        $spCode = "CREATE PROC [$procName] @string AS SQL_VARIANT OUTPUT as SELECT @string = REVERSE(CAST(@string AS varchar(30)))";

        $stmt = $conn->exec($spCode);
    }
    catch (Exception $e)
    {
        echo "Failed to create the reverse procedure\n";
        echo $e->getMessage();
    }        
    
    try
{'fraction_non_alphanumeric': 0.11552346570397112, 'fraction_numerical': 0.002888086642599278, 'mean_word_length': 2.9827586206896552, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 7, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3426057', 'n_tokens_mistral': 427, 'n_tokens_neox': 406, 'n_words': 132}